Catalog articole (Knowledge Base Mod).

skeleton · Mesaj de **skeleton** » 06-Ian-2007, 23:09:03

Asemenea

sorelsorel · Mesaj de **sorelsorel** » 07-Ian-2007, 15:36:42

Am studiat din nou fisierul si nu s-ar putea sa se faca conexiune directa, am incercat sa iau manual comenzile dar nu am reusit, si forumul meu cam are nevoie mare de catalogul de articole.

Aliniuz · Mesaj de **Aliniuz** » 07-Ian-2007, 15:43:32

Initiam credeam ca nu e inclus fisierul config.php in install_kb_tables , insa am vazut ca este . Eu unul nu gasesc decat o solutie , sa incercam a scoate comenzile SQL propriu-zise din fisierul de instalare si sa le rulam in phpmyadmin-ul fiecaruia .

sorelsorel · Mesaj de **sorelsorel** » 07-Ian-2007, 17:20:40

Am incercat eu sa extrag mysql-ul si sa scot elementele pentru php:

Cod: Selectaţi tot

	     CREATE TABLE 'KB_ARTICLES_TABLE' (
						article_id mediumint(8) unsigned NOT NULL auto_increment,
  						article_category_id mediumint(8) unsigned NOT NULL default '0',
  						article_title varchar(255) binary NOT NULL default '',
  						article_description varchar(255) binary NOT NULL default '',
  						article_date varchar(255) binary NOT NULL default '',
  						article_author_id mediumint(8) NOT NULL,
						username VARCHAR(255),
  						bbcode_uid varchar(10) binary NOT NULL default '',
  						article_body text NOT NULL,
  						article_type mediumint(8) unsigned NOT NULL default '0',
  						approved tinyint(1) unsigned NOT NULL default '0',
  						topic_id mediumint(8) unsigned NOT NULL default '0',
  						views BIGINT(8) NOT NULL DEFAULT '0',
  						article_rating double(6,4) NOT NULL default '0.0000',
  						article_totalvotes int(255) NOT NULL default '0',
  						KEY article_id (article_id)
				    ) TYPE=MyISAM ;
					
			INSERT INTO 'KB_ARTICLES_TABLE ' VALUES (
				   	      1, 1, 'Test Article', 'This is a test article for your KB', '1057708235', 2, '', '93074f48a9', 'This is a test article for your Knowledge Base. This MOD is based on code written by wGEric < eric@egcnetwork.com > (Eric Faerber) - http://eric.best-1.biz/, now supervised by _Haplo < jonohlsson@hotmail.com > (Jon Ohlsson) - http://www.mx-system.com/ \r\n\r\nBe sure you add categories and article types in the ACP and also change the Configuration to your liking.\r\n\r\nHave fun and enjoy your new Knowledge Base!  :D', 1, 1, 0, 0,0,0
					  ) ;

			CREATE TABLE 'KB_CATEGORIES_TABLE' (
  			 	   	    category_id mediumint(8) unsigned NOT NULL auto_increment, 
  						category_name VARCHAR(255) binary NOT NULL, 
  						category_details VARCHAR(255) binary NOT NULL, 
 						number_articles mediumint(8) unsigned NOT NULL,
						parent mediumint(8) unsigned,
						cat_order mediumint(8) unsigned NOT NULL,
					  	auth_view tinyint(3) NOT NULL DEFAULT '0',
						auth_post tinyint(3) NOT NULL DEFAULT '0',
						auth_rate tinyint(3) NOT NULL DEFAULT '0',
						auth_comment tinyint(3) NOT NULL DEFAULT '0',
						auth_edit tinyint(3) NOT NULL DEFAULT '0',
						auth_delete tinyint(3) NOT NULL DEFAULT '2',
						auth_approval tinyint(3) NOT NULL DEFAULT '0',
						auth_approval_edit tinyint(3) NOT NULL DEFAULT '0',
						auth_view_groups varchar(255),
						auth_post_groups varchar(255),
						auth_rate_groups varchar(255),
						auth_comment_groups varchar(255),
						auth_edit_groups varchar(255),
						auth_delete_groups varchar(255),
						auth_approval_groups varchar(255),
						auth_approval_edit_groups varchar(255),
						auth_moderator_groups varchar(255),
						comments_forum_id tinyint(3) NOT NULL DEFAULT '-1',
  						KEY category_id (category_id)
					) TYPE=MyISAM ;
					
			  
		    INSERT INTO 'KB_CATEGORIES_TABLE ' VALUES (1, 'Test Category 1', 'This is a test category', '0', '0', '10', '0', '0', '0', '0', '0', '2', '0', '0', '', '', '', '', '', '', '', '', '', '0' ) ;

			CREATE TABLE 'KB_CONFIG_TABLE' (
			  			config_name VARCHAR(255) NOT NULL default '', 
						config_value varchar(255) NOT NULL default '',
						PRIMARY KEY  (config_name)
						) TYPE=MyISAM ;
			
			INSERT INTO 'KB_CONFIG_TABLE' (config_name, config_value) VALUES ('allow_new', '1')';
			INSERT INTO 'KB_CONFIG_TABLE' (config_name, config_value) VALUES ('notify', '1')';
			INSERT INTO 'KB_CONFIG_TABLE' (config_name, config_value) VALUES ('admin_id', '2')';
			INSERT INTO 'KB_CONFIG_TABLE' (config_name, config_value) values('show_pretext',0) ;
			INSERT INTO 'KB_CONFIG_TABLE' (config_name, config_value) values('pt_header','Article Submission Instructions') ;
			INSERT INTO 'KB_CONFIG_TABLE' (config_name, config_value) values('pt_body','Please check your references and include as much information as you can.') ;
			INSERT INTO 'KB_CONFIG_TABLE' (config_name, config_value) VALUES ('use_comments', '1') ;
			INSERT INTO 'KB_CONFIG_TABLE' (config_name, config_value) VALUES ('del_topic', '1') ;
			INSERT INTO 'KB_CONFIG_TABLE' (config_name, config_value) VALUES ('use_ratings', '0') ;
			INSERT INTO 'KB_CONFIG_TABLE' (config_name, config_value) VALUES ('comments_show', '1') ;
			INSERT INTO 'KB_CONFIG_TABLE' (config_name, config_value) VALUES ('bump_post', '1') ;
			INSERT INTO 'KB_CONFIG_TABLE' (config_name, config_value) VALUES ('stats_list', '1') ;
			INSERT INTO 'KB_CONFIG_TABLE' (config_name, config_value) VALUES ('header_banner', '1') ;

			INSERT INTO 'KB_CONFIG_TABLE' (config_name, config_value) VALUES ('votes_check_userid', '1') ;
			INSERT INTO 'KB_CONFIG_TABLE' (config_name, config_value) VALUES ('votes_check_ip', '1') ;
			INSERT INTO 'KB_CONFIG_TABLE' (config_name, config_value) VALUES ('art_pagination', '5') ;

			INSERT INTO 'KB_CONFIG_TABLE' (config_name, config_value) VALUES ('comments_pagination', '5') ;
			INSERT INTO 'KB_CONFIG_TABLE' (config_name, config_value) VALUES ('news_sort', 'Alphabetic') ;
			INSERT INTO 'KB_CONFIG_TABLE' (config_name, config_value) VALUES ('news_sort_par', 'ASC') ;

			INSERT INTO 'KB_CONFIG_TABLE' (config_name, config_value) VALUES ('wysiwyg', '0') ;
			INSERT INTO 'KB_CONFIG_TABLE' (config_name, config_value) VALUES ('wysiwyg_path', 'modules/') ;
			INSERT INTO 'KB_CONFIG_TABLE' (config_name, config_value) VALUES ('allow_html', '1') ;
			INSERT INTO 'KB_CONFIG_TABLE' (config_name, config_value) VALUES ('allow_bbcode', '1') ;
			INSERT INTO 'KB_CONFIG_TABLE' (config_name, config_value) VALUES ('allow_smilies', '1') ;
			INSERT INTO 'KB_CONFIG_TABLE' (config_name, config_value) VALUES ('formatting_fixup', '0') ;
			INSERT INTO 'KB_CONFIG_TABLE' (config_name, config_value) VALUES ('allowed_html_tags', 'b,i,u,a') ;
					
			CREATE TABLE 'KB_TYPES_TABLE' (
  				 	       	id mediumint(8) unsigned NOT NULL auto_increment, 
  						   	type varchar(255) binary DEFAULT '' NOT NULL, 
  						   	KEY id (id)
					  ) TYPE=MyISAM ;
					  
			INSERT INTO '  KB_TYPES_TABLE' VALUES (1, 'Test Type 1')';

			 CREATE TABLE 'KB_VOTES_TABLE' (
  							votes_ip varchar(50) NOT NULL default '0',
  							votes_userid int(50) NOT NULL default '0',
  							votes_file int(50) NOT NULL default '0'
					  ) TYPE=MyISAM ;

			CREATE TABLE 'KB_SEARCH_TABLE' (
	  				 	    search_id int(11) unsigned NOT NULL default '0',
	  						session_id varchar(32) NOT NULL default '',
	  						search_array text NOT NULL,
	  						PRIMARY KEY  (search_id),
	  						KEY session_id (session_id)
					   ) TYPE=MyISAM ;

			CREATE TABLE 'KB_WORD_TABLE' (
	  				 	   	word_text varchar(50) binary NOT NULL default '',
		  					word_id mediumint(8) unsigned NOT NULL auto_increment,
		  					word_common tinyint(1) unsigned NOT NULL default '0',
		  					PRIMARY KEY  (word_text),
		  					KEY word_id (word_id)
					   ) TYPE=MyISAM ;

			CREATE TABLE 'KB_MATCH_TABLE' (
		  				 	article_id mediumint(8) unsigned NOT NULL default '0',
		  					word_id mediumint(8) unsigned NOT NULL default '0',
		  					title_match tinyint(1) NOT NULL default '0',
		  					KEY post_id (article_id),
		  					KEY word_id (word_id)
					  	) TYPE=MyISAM ;	

			CREATE TABLE 'KB_CUSTOM_TABLE' (
							custom_id int(50) NOT NULL auto_increment,
							custom_name text NOT NULL,
							custom_description text NOT NULL,
							data text NOT NULL,
							field_order int(20) NOT NULL default '0',
							field_type tinyint(2) NOT NULL default '0',
							regex varchar(255) NOT NULL default '',
							PRIMARY KEY  (custom_id)
						)  TYPE=MyISAM ;
			
			CREATE TABLE 'KB_CUSTOM_DATA_TABLE' (
							customdata_file int(50) NOT NULL default '0',
							customdata_custom int(50) NOT NULL default '0',
							data text NOT NULL
						) TYPE=MyISAM ;

Dar imi spune:

Cod: Selectaţi tot

#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near ''KB_ARTICLES_TABLE' (
                        article_id mediumint(8) unsigned N

Ce e gresit?

Aliniuz · Mesaj de **Aliniuz** » 07-Ian-2007, 17:44:13

Bineinteles ca e gresit, acel cod SQL e integrat in php .

Deja mi-am luat gandul de la KB si incerc alt MOD , Article Manager .

sorelsorel · Mesaj de **sorelsorel** » 07-Ian-2007, 17:52:13

Pai am elmininat elementele de php..

Mesaj de **flowers** » 08-Ian-2007, 01:03:13

sorelsorel, daca te uiti in /includes/kb_constants.php o sa vezi ca 'KB_ARTICLES_TABLE' are asignat 'kb_articles'. Deci comenzile SQL vor arata asa:

Cod: Selectaţi tot

CREATE TABLE `phpbb_kb_articles` (
  `article_id` mediumint(8) unsigned NOT NULL auto_increment,
  `article_category_id` mediumint(8) unsigned NOT NULL default '0',
  `article_title` varchar(255) NOT NULL default '',
  `article_description` varchar(255) NOT NULL default '',
  `article_date` varchar(255) NOT NULL default '',
  `article_author_id` mediumint(8) NOT NULL default '0',
  `username` varchar(255) default NULL,
  `bbcode_uid` varchar(10) NOT NULL default '',
  `article_body` text NOT NULL,
  `article_type` mediumint(8) unsigned NOT NULL default '0',
  `approved` tinyint(1) unsigned NOT NULL default '0',
  `topic_id` mediumint(8) unsigned NOT NULL default '0',
  `views` bigint(8) NOT NULL default '0',
  `article_rating` double(6,4) NOT NULL default '0.0000',
  `article_totalvotes` int(255) NOT NULL default '0',
  KEY `article_id` (`article_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

INSERT INTO `phpbb_kb_articles` (`article_id`, `article_category_id`, `article_title`, `article_description`, `article_date`, `article_author_id`, `username`, `bbcode_uid`, `article_body`, `article_type`, `approved`, `topic_id`, `views`, `article_rating`, `article_totalvotes`) VALUES
(1, 1, 'Test Article', 'This is a test article for your KB', '1057708235', 2, '', '93074f48a9', 'This is a test article for your Knowledge Base. This MOD is based on code written by wGEric < eric@egcnetwork.com > (Eric Faerber) - http://eric.best-1.biz/, now supervised by _Haplo < jonohlsson@hotmail.com > (Jon Ohlsson) - http://www.mx-system.com/ \r\n\r\nBe sure you add categories and article types in the ACP and also change the Configuration to your liking.\r\n\r\nHave fun and enjoy your new Knowledge Base!  :D', 1, 1, 0, 0, 0.0000, 0);

CREATE TABLE `phpbb_kb_categories` (
  `category_id` mediumint(8) unsigned NOT NULL auto_increment,
  `category_name` varchar(255) NOT NULL default '',
  `category_details` varchar(255) NOT NULL default '',
  `number_articles` mediumint(8) unsigned NOT NULL default '0',
  `parent` mediumint(8) unsigned default NULL,
  `cat_order` mediumint(8) unsigned NOT NULL default '0',
  `auth_view` tinyint(3) NOT NULL default '0',
  `auth_post` tinyint(3) NOT NULL default '0',
  `auth_rate` tinyint(3) NOT NULL default '0',
  `auth_comment` tinyint(3) NOT NULL default '0',
  `auth_edit` tinyint(3) NOT NULL default '0',
  `auth_delete` tinyint(3) NOT NULL default '2',
  `auth_approval` tinyint(3) NOT NULL default '0',
  `auth_approval_edit` tinyint(3) NOT NULL default '0',
  `auth_view_groups` varchar(255) default NULL,
  `auth_post_groups` varchar(255) default NULL,
  `auth_rate_groups` varchar(255) default NULL,
  `auth_comment_groups` varchar(255) default NULL,
  `auth_edit_groups` varchar(255) default NULL,
  `auth_delete_groups` varchar(255) default NULL,
  `auth_approval_groups` varchar(255) default NULL,
  `auth_approval_edit_groups` varchar(255) default NULL,
  `auth_moderator_groups` varchar(255) default NULL,
  `comments_forum_id` tinyint(3) NOT NULL default '-1',
  KEY `category_id` (`category_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

INSERT INTO `phpbb_kb_categories` (`category_id`, `category_name`, `category_details`, `number_articles`, `parent`, `cat_order`, `auth_view`, `auth_post`, `auth_rate`, `auth_comment`, `auth_edit`, `auth_delete`, `auth_approval`, `auth_approval_edit`, `auth_view_groups`, `auth_post_groups`, `auth_rate_groups`, `auth_comment_groups`, `auth_edit_groups`, `auth_delete_groups`, `auth_approval_groups`, `auth_approval_edit_groups`, `auth_moderator_groups`, `comments_forum_id`) VALUES
(1, 'Test Category 1', 'This is a test category', 0, 0, 10, 0, 0, 0, 0, 0, 2, 0, 0, '', '', '', '', '', '', '', '', '', 0);

CREATE TABLE `phpbb_kb_config` (
  `config_name` varchar(255) NOT NULL default '',
  `config_value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`config_name`)
) TYPE=MyISAM;

INSERT INTO `phpbb_kb_config` (`config_name`, `config_value`) VALUES
('allow_new', '1'),
('notify', '1'),
('admin_id', '2'),
('show_pretext', '0'),
('pt_header', 'Article Submission Instructions'),
('pt_body', 'Please check your references and include as much information as you can.'),
('use_comments', '1'),
('del_topic', '1'),
('use_ratings', '0'),
('comments_show', '1'),
('bump_post', '1'),
('stats_list', '1'),
('header_banner', '1'),
('votes_check_userid', '1'),
('votes_check_ip', '1'),
('art_pagination', '5'),
('comments_pagination', '5'),
('news_sort', 'Alphabetic'),
('news_sort_par', 'ASC'),
('wysiwyg', '0'),
('wysiwyg_path', 'modules/'),
('allow_html', '1'),
('allow_bbcode', '1'),
('allow_smilies', '1'),
('formatting_fixup', '0'),
('allowed_html_tags', 'b,i,u,a');

CREATE TABLE `phpbb_kb_custom` (
  `custom_id` int(50) NOT NULL auto_increment,
  `custom_name` text NOT NULL,
  `custom_description` text NOT NULL,
  `data` text NOT NULL,
  `field_order` int(20) NOT NULL default '0',
  `field_type` tinyint(2) NOT NULL default '0',
  `regex` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`custom_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `phpbb_kb_customdata` (
  `customdata_file` int(50) NOT NULL default '0',
  `customdata_custom` int(50) NOT NULL default '0',
  `data` text NOT NULL
) TYPE=MyISAM;

CREATE TABLE `phpbb_kb_results` (
  `search_id` int(11) unsigned NOT NULL default '0',
  `session_id` varchar(32) NOT NULL default '',
  `search_array` text NOT NULL,
  PRIMARY KEY  (`search_id`),
  KEY `session_id` (`session_id`)
) TYPE=MyISAM;

CREATE TABLE `phpbb_kb_types` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `type` varchar(255) NOT NULL default '',
  KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

INSERT INTO `phpbb_kb_types` (`id`, `type`) VALUES
(1, 'Test Type 1');

CREATE TABLE `phpbb_kb_votes` (
  `votes_ip` varchar(50) NOT NULL default '0',
  `votes_userid` int(50) NOT NULL default '0',
  `votes_file` int(50) NOT NULL default '0'
) TYPE=MyISAM;

CREATE TABLE `phpbb_kb_wordlist` (
  `word_text` varchar(50) NOT NULL default '',
  `word_id` mediumint(8) unsigned NOT NULL auto_increment,
  `word_common` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`word_text`),
  KEY `word_id` (`word_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `phpbb_kb_wordmatch` (
  `article_id` mediumint(8) unsigned NOT NULL default '0',
  `word_id` mediumint(8) unsigned NOT NULL default '0',
  `title_match` tinyint(1) NOT NULL default '0',
  KEY `post_id` (`article_id`),
  KEY `word_id` (`word_id`)
) TYPE=MyISAM;

Aliniuz · Mesaj de **Aliniuz** » 08-Ian-2007, 12:08:09

Si nu uitati sa inlocuiti phpbb_ cu prefixul tabelelor din baza voastrad e date .

Multumim flowers pt comenzi .

skeleton · Mesaj de **skeleton** » 08-Ian-2007, 14:26:19

Mersi flowers, vorba aia: "Mare domn, mare caracter"

sorelsorel · Mesaj de **sorelsorel** » 08-Ian-2007, 14:44:32

Raman dator pe viata, aveam mare mare nevoie de modificarea aceasta.. multumesc mult.

Edit: Am executat comenzile SQL dar acum cand incerc sa creez o noua categorie, dau CREATE si ma duce pe prima pagina a forumului..

phpBB România • forumul phpBB in limba romana. Opinii, implementari, ajutor, instructiuni si download.

Catalog articole (Knowledge Base Mod).

Cine este conectat