竹貓星球

目前正要安裝推薦網站精華版MOD

版本是1.2.2

可是我在說明檔下並沒發現要貼什麼SQL語法

還是這語法是在links_install 這檔案下

這是我在這檔案下找尋到ㄉ

$sql = array(
"CREATE TABLE ".$table_prefix."link_categories (
cat_id mediumint(8) unsigned NOT NULL auto_increment,
cat_title varchar(100) NOT NULL default '',
cat_order mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (cat_id),
KEY cat_order (cat_order))",
"CREATE TABLE ".$table_prefix."links (
link_id mediumint(8) unsigned NOT NULL auto_increment,
link_title varchar(100) NOT NULL default '',
link_desc varchar(255) default NULL,
link_category mediumint(8) unsigned NOT NULL default '0',
link_url varchar(100) NOT NULL default '',
link_logo_src varchar(120) default NULL,
link_joined int(11) NOT NULL default '0',
link_active tinyint(1) NOT NULL default '0',
link_hits int(10) unsigned NOT NULL default '0',
user_id mediumint(8) NOT NULL default '0',
user_ip varchar(8) NOT NULL default '',
last_user_ip varchar(8) NOT NULL default '',
PRIMARY KEY (link_id))",
"INSERT INTO ".$table_prefix."link_categories VALUES (1, 'Arts', 1)",
"INSERT INTO ".$table_prefix."link_categories VALUES (2, 'Business', 2)",
"INSERT INTO ".$table_prefix."link_categories VALUES (3, 'Children and Teens', 3)",
"INSERT INTO ".$table_prefix."link_categories VALUES (4, 'Computers', 4)",
"INSERT INTO ".$table_prefix."link_categories VALUES (5, 'Games', 5)",
"INSERT INTO ".$table_prefix."link_categories VALUES (6, 'Health', 6)",
"INSERT INTO ".$table_prefix."link_categories VALUES (7, 'Home', 7)",
"INSERT INTO ".$table_prefix."link_categories VALUES (8, 'News', 8)",
"INSERT INTO ".$table_prefix."links VALUES (1, 'phpBB Official Website', 'Official phpBB Website', 4, 'http://www.phpbb.com/', 'images/links/phpBB_88a.gif', ".time().", 1, 0, 2, '', '')",
"INSERT INTO ".$table_prefix."links VALUES (2, 'phpbb-tw.net', 'Unofficial phpBB Chinese Support Centre', 4, 'http://phpbb-tw.net', 'images/links/phpbb-tw_logo88a.gif', ".time().", 1, 0, 2, '', '')",
"INSERT INTO ".$table_prefix."links VALUES (3, 'phpbb2.de', 'Your Source for phpBB2 Stuff', 4, 'http://www.phpbb2.de', 'images/links/phpbb2_de_logo.gif', ".time().", 1, 0, 2, '', '')",
"INSERT INTO ".$table_prefix."links VALUES (4, 'Forumimages.com', 'Forumimages.com', 4, 'http://www.forumimages.com', 'images/links/forum_images_banner_88x31.gif', ".time().", 1, 0, 2, '', '')",
"CREATE TABLE ".$table_prefix."link_config (
config_name varchar(255) NOT NULL default '',
config_value varchar(255) NOT NULL default ''
)",
"INSERT INTO ".$table_prefix."link_config (config_name, config_value) VALUES ('site_logo', 'http://".$board_config['server_name'].$board_config['script_path']."images/links/web_logo88a.gif')",
"INSERT INTO ".$table_prefix."link_config (config_name, config_value) VALUES ('site_url', 'http://".$board_config['server_name'].$board_config['script_path']."')",
"INSERT INTO ".$table_prefix."link_config (config_name, config_value) VALUES ('width', '88')",
"INSERT INTO ".$table_prefix."link_config (config_name, config_value) VALUES ('height', '31')",
"INSERT INTO ".$table_prefix."link_config (config_name, config_value) VALUES ('linkspp', '10')",
"INSERT INTO ".$table_prefix."link_config (config_name, config_value) VALUES ('display_interval', '6000')",
"INSERT INTO ".$table_prefix."link_config (config_name, config_value) VALUES ('display_logo_num', '10')",
"INSERT INTO ".$table_prefix."link_config (config_name, config_value) VALUES ('display_links_logo', '1')",
"INSERT INTO ".$table_prefix."link_config (config_name, config_value) VALUES ('email_notify', '1')",
"INSERT INTO ".$table_prefix."link_config (config_name, config_value) VALUES ('pm_notify ', '0')",
"INSERT INTO ".$table_prefix."link_config (config_name, config_value) VALUES ('lock_submit_site', '0')",
"INSERT INTO ".$table_prefix."link_config (config_name, config_value) VALUES ('allow_no_logo', '0')"
);

請問我語法該貼什麼呢? 多謝

SQL語法 是 指把這些語法放入MySQL

好好看一看教學吧\r
http://phpbb-tw.net/phpbb/viewtopic.php?p=152233#152233

天霜 寫:[*]有些外掛例如Birthday、Gender、Custom mass PM等都是需要輸入 SQL 語法的
但為何我沒在說明文件中看到 SQL 語法？[/color]

有些外掛作者會考慮到有些使用者對於phpMyAdmin不大熟悉
所以他們會在外掛包理附加一個"執行檔"
通常檔案名稱是db_update.php、install.php等
像是Advanced Links Mod 1.2.2就是links_install.php
Birthday則是birthday_db_update.php

~Mac

我想各位大大搞錯了...

我會貼語法 但是我在MOD說明檔下未發現要我貼語法

但是我關看寶典卻有貼語法這段\r

然而我在看links_install 這檔案時 有發現首篇的語法

我是想請問 上段語法中\r

$sql = array(
"CREATE TABLE ".$table_prefix."link_categories (
cat_id mediumint(8) unsigned NOT NULL auto_increment,
cat_title varchar(100) NOT NULL default '',
cat_order mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (cat_id),
KEY cat_order (cat_order))",
"CREATE TABLE ".$table_prefix."links (
link_id mediumint(8) unsigned NOT NULL auto_increment,
link_title varchar(100) NOT NULL default '',
link_desc varchar(255) default NULL,
link_category mediumint(8) unsigned NOT NULL default '0',
link_url varchar(100) NOT NULL default '',
link_logo_src varchar(120) default NULL,
link_joined int(11) NOT NULL default '0',
link_active tinyint(1) NOT NULL default '0',
link_hits int(10) unsigned NOT NULL default '0',
user_id mediumint(8) NOT NULL default '0',
user_ip varchar(8) NOT NULL default '',
last_user_ip varchar(8) NOT NULL default '',
PRIMARY KEY (link_id))",

是造這全貼嗎? 還是需要修改 THX

直接執行links_install.php就行了吧\r
我記得是這樣啦

kelvin0113，就像 k122417901 說的
所以... 先看教學吧\r

~Mac

喔喔喔 我到了 多謝各位大大費心教導...

不好意思 ^^ THX

我已經執行過links_install.php了

可是他給我出現這個

Could not query link categories list

DEBUG MODE

SQL Error : 1146 Table 'mintrain_mintrain.LINK_CATEGORIES_TABLE' doesn't exist

SELECT cat_id, cat_title FROM LINK_CATEGORIES_TABLE ORDER BY cat_order

Line : 63
File : /home/mintrain/public_html/phpbbX_SP/admin/admin_links.php

是什麼意思?

SQL Error : 1146 Table 'mintrain_mintrain.LINK_CATEGORIES_TABLE' doesn't exist

你的SQL指令還是沒有匯入