[問題] advanced links mod (亂碼顯示)

phpBB 2 MOD Support
無論是官方或非官方認證之外掛，安裝與使用問題討論。
(發表文章請按照公告格式發表，違者砍文)

版主: 版主管理群

主題已鎖定
Hsuan
星球普通子民
星球普通子民
文章: 30
註冊時間: 2004-09-06 08:34
聯繫:
聯繫 Hsuan

[問題] advanced links mod (亂碼顯示)

文章 由 Hsuan »

目前系統windows xp home
phpbb版本 繁體正文語系2.0.18
風格 igloov1.02
advanced links mod版本 1.2.2
mysql版本 4.0.24-nt

因為advanced links mod裡的sql語法無法直接執行
我將原來的sql語法

代碼: 選擇全部

"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')"
);
改成\r

代碼: 選擇全部

CREATE TABLE phpbb_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 phpbb_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 phpbb_link_categories VALUES (1, 'Arts', 1);
INSERT INTO phpbb_link_categories VALUES (2, 'Business', 2);
INSERT INTO phpbb_link_categories VALUES (3, 'Children and Teens', 3);
INSERT INTO phpbb_link_categories VALUES (4, 'Computers', 4);
INSERT INTO phpbb_link_categories VALUES (5, 'Games', 5);
INSERT INTO phpbb_link_categories VALUES (6, 'Health', 6);
INSERT INTO phpbb_link_categories VALUES (7, 'Home', 7);
INSERT INTO phpbb_link_categories VALUES (8, 'News', 8);  	  		
INSERT INTO phpbb_links VALUES (1, 'phpBB Official Website', 'Official phpBB Website', 4, 'http://www.phpbb.com/', 'images/links/phpBB_88a.gif', 1019910254, 1, 0, 2, '', '');
INSERT INTO phpbb_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 phpbb_links VALUES (3, 'phpbb2.de', 'Your Source for phpBB2 Stuff', 4, 'http://www.phpbb2.de', 'images/links/phpbb2_de_logo.gif', 1019910254, 1, 0, 2, '', '');
INSERT INTO phpbb_links VALUES (4, 'Forumimages.com', 'Forumimages.com', 4, 'http://www.forumimages.com', 'images/links/forum_images_banner_88x31.gif',1019910254, 1, 0, 2, '', '');
CREATE TABLE phpbb_link_config (
  config_name varchar(255) NOT NULL default '',
  config_value varchar(255) NOT NULL default ''
);
INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('site_logo', 'http://www.phpbb2/images/links/web_logo88a.gif');
INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('site_url', 'http://www.phpbb2/');
INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('width', '88');
INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('height', '31');
INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('linkspp', '10');
INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('display_interval', '6000');
INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('display_logo_num', '10');
INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('display_links_logo', '1');
INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('email_notify', '1');
INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('pm_notify ', '0');
INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('lock_submit_site', '0');
INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('allow_no_logo', '0')
);
這樣sql就可以執行了~
接著按照install的其他步驟把該放的資料夾都複製上去 該改的也改了

最後回到我的論壇上去看@@~
區塊是出來了 後台選項也出來了 ~
但卻碰到亂碼問題
亂碼圖如下
首頁下方"連結"變為亂碼\r
圖檔
控制台links admin ==>新增 畫面變為亂碼\r
圖檔
控制台links admin==>分區 畫面變為亂碼\r
圖檔
控制台 links admin==>基本組態 畫面變為亂碼\r
圖檔
控制台 links admin==>管理選項 畫面變為亂碼\r
圖檔

以上這些圖 如果將ie編碼變成"utf-8" 則 會將亂碼變成繁體中文
但 原來正常的部份就會變成亂碼\r

想請大家幫幫忙 看看哪裡出問題了~~
應該怎樣改才能在 編碼為 big5的情況下 都顯示正常呢??

謝謝
努力的架站!

●架設主機作業系統：虛擬主機 用的是windows為作業系統
●您的上網方式：大樓區域網路
●您安裝的程式： php + MySql
●您的 phpBB2 版本：phpBB 2.0.18
●您的 domain(網域名稱) ：tw-jh.com
●您的 phpBB2 連結網址：tw-jh.com
●安裝的風格: Igloo v1.02
●已安裝的外掛: 附加檔案; cash mod;勳章外掛;註冊文字; 版面圖示; advanced lind mod; 隨機logo; CPG; 快速坎人;閃亮會員名稱;bbcode box 5.0;寵物外掛;普通銀行外掛;付費瀏覽外掛1.0.9
回頂端
頭像
心靈捕手
默默耕耘的老師
默默耕耘的老師
文章: 8547
註冊時間: 2004-04-30 01:54
來自: Taiwan

文章 由 心靈捕手 »

To Hsuan:

類似( 亂碼) 的情況, 昨天不是有人提出討論過嗎?
您可以參考看看:
http://phpbb-tw.net/phpbb/viewtopic.php?t=40207
http://phpbb-tw.net/phpbb/viewtopic.php?p=217923#217923
施比受有福，祝福您好運！ ^_^
歡迎光臨★★心靈捕手★★ :: 討論區
https://wang5555.dnsfor.me/phpBB3/
回頂端
主題已鎖定

回到「外掛問題討論」