目前正要安裝推薦網站精華版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語法...
版主: 版主管理群
-
- 星球公民
- 文章: 84
- 註冊時間: 2004-06-03 23:12
- 來自: Starry Recollection
- 聯繫:
好好看一看教學吧\r
http://phpbb-tw.net/phpbb/viewtopic.php?p=152233#152233
http://phpbb-tw.net/phpbb/viewtopic.php?p=152233#152233
~Mac天霜 寫:[*]有些外掛例如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
- kelvin0113
- 星球普通子民
- 文章: 7
- 註冊時間: 2004-06-16 23:19
我想各位大大搞錯了...
我會貼語法 但是我在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
我會貼語法 但是我在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
架站環境: 虛擬主機提供
空間的資料: why3s虛擬主機
網址: http://www.kelvin.why3s.net/phpbbx/index.php
phpBB 版本: phpbbX / iOptional Board SP
空間的資料: why3s虛擬主機
網址: http://www.kelvin.why3s.net/phpbbx/index.php
phpBB 版本: phpbbX / iOptional Board SP
- kelvin0113
- 星球普通子民
- 文章: 7
- 註冊時間: 2004-06-16 23:19
喔喔喔 我到了 多謝各位大大費心教導...
不好意思 ^^ THX
不好意思 ^^ THX
架站環境: 虛擬主機提供
空間的資料: why3s虛擬主機
網址: http://www.kelvin.why3s.net/phpbbx/index.php
phpBB 版本: phpbbX / iOptional Board SP
空間的資料: why3s虛擬主機
網址: http://www.kelvin.why3s.net/phpbbx/index.php
phpBB 版本: phpbbX / iOptional Board SP
我已經執行過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
是什麼意思?
可是他給我出現這個
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
是什麼意思?