水怪RPG新增武器&職業問題

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

版主: 版主管理群

主題已鎖定
最初
星球公民
星球公民
文章: 34
註冊時間: 2007-01-11 21:41

水怪RPG新增武器&職業問題

文章 最初 »

問題外掛:水怪RPG1.0.5
參考連結:http://phpbb-tw.net/phpbb/viewtopic.php?t=20786
使用版本:phpBB 2.0.21
網站位置:http://club.nfu.edu.tw/~nfucosplay/
狀況描述:

當我想要新增盜賊使用的手套的時候我用直接輸入會出現
SQL 語法:

INSERT INTO cos_rpg_items
VALUES (

"664", "練習用偷東西手套", "", "1", "15", "0", "8", "", "", "18000", "0", "0", "1", "1624", "0", "0.2", "0.0", "0.0", "0.1", "0.0", "0.0"
)
要是用檔案輸入的話會出現
錯誤
這可能是您找到了 SQL 分析程式的一些程式錯誤,請細心查看您的語法,檢查一下引號是正確及沒有遺漏,其他可能出錯的原因可能來自您上載檔案時在引號外的地方使用了二進制碼。您可以嘗試在 MySQL 命令列介面執行該語法。如 MySQL 伺服器發出錯誤信息,這可能幫助您去找出問題所在。如您仍然未能解決問題,或在分析程式出現錯誤,但在命令列模式能正常執行,請將該句出現錯誤的 SQL 語法抽出,並將以下的"剪取"部份一同提交到臭虫區:
----開始 剪取----
eNqNjs9Og0AQxu/7FHNojCaw7q50i+uJkLWSUECW1mPjH7QktKVAtfV51EMPxnjvK/gKJp58DKk9
0QOaTDLzzcz3m5Fh6IcCbAo2A1d6AowOGCZQ3kEqqiYrhOyBEtBybgQUszS7zIs4x2lyhbNRpt0D
w0ccGCHtQ2JWUZWCMUEppPH4GOQigxbqLdW5K6CNCWYM9VUIvtLA6kov0mAgqzMXyQQcCRwTFPQs
UVE5NvQsNVBwFmxWNF9tABRzcJPJfIFcy+sKeByVD/q8vNVN9HvC8ZQMoypFPlxPi2Ge3Q2TMh4X
MLDcvlT7e7P5tDzh3NgWGmzzevz++fzxtl6dvnw/fb326tO6ojuyXdekLs0m1A7JJIQ0wkjzJ5wZ
zXbMdhvkzwb9r+XgBxLnst4=
----結束 剪取----
----開始 原始資料----
ERROR: C1 C2 LEN: 47 48 167
STR: ?

CVS: $Id: sqlparser.lib.php,v 2.36 2005/08/08 20:22:11 lem9 Exp $
MySQL: 5.0.22
USR OS, AGENT, VER: Win IE 6.0
PMA: 2.6.4-pl4
PHP VER,OS: 5.1.6 Linux
LANG: zhtw-utf-8
SQL: INSERT INTO cos_rpg_items VALUES("664", "?m?ߥΰ??F?褢?M", "", "1", "15", "0", "8", "", "", "18000", "0", "0", "1", "1624", "0", "0.2", "0.0", "0.0", "0.1", "0.0", "0.0")
----結束 原始資料----
我匯入/執行的文件是
INSERT INTO cos_rpg_items VALUES("664", "練習用偷東西手套", "", "1", "15", "0", "8", "", "", "18000", "0", "0", "1", "1624", "0", "0.2", "0.0", "0.0", "0.1", "0.0", "0.0");
INSERT INTO cos_rpg_items VALUES("665", "偷東西手套", "", "1", "20", "0", "8", "", "", "25000", "0", "0", "1", "1625", "0", "0.4", "0.0", "0.0", "0.0", "0.0", "0.0");
INSERT INTO cos_rpg_items VALUES("666", "滑滑的手套", "", "1", "25", "0", "8", "", "", "30000", "0", "0", "1", "1626", "0", "0.6", "0.0", "0.0", "0.0", "0.5", "0.0");
INSERT INTO cos_rpg_items VALUES("667", "粗布手套", "", "1", "32", "0", "8", "", "", "100000", "0", "0", "1", "1627", "0", "1.0", "0.0", "0.0", "0.0", "1.0", "0.0");
INSERT INTO cos_rpg_items VALUES("668", "騎機車用防風手套", "", "1", "30", "0", "8", "", "", "80000", "0", "0", "1", "1628", "0", "1.2", "0.0", "0.0", "1.5", "0.0", "0.0");
INSERT INTO cos_rpg_items VALUES("669", "不起眼的手套", "", "1", "35", "0", "8", "", "", "100000", "0", "0", "1", "1629", "0", "1.6", "0.0", "0.0", "2.0", "0.0", "0.0");
INSERT INTO cos_rpg_items VALUES("670", "手術用手套", "", "1", "40", "0", "8", "", "", "250000", "0", "0", "1", "1630", "0", "2.0", "0.0", "0.0", "2.5", "0.0", "0.0");
INSERT INTO cos_rpg_items VALUES("671", "看不見的手套", "", "1", "45", "0", "8", "", "", "400000", "0", "0", "1", "1631", "0", "2.6", "0.0", "0.0", "3.0", "0.0", "0.0");
INSERT INTO cos_rpg_items VALUES("672", "被抓到的手套", "", "1", "50", "0", "8", "", "", "800000", "0", "0", "1", "1632", "0", "3.2", "0.0", "0.0", "3.5", "0.0", "0.0");
INSERT INTO cos_rpg_items VALUES("673", "這不是手套", "", "1", "55", "0", "8", "", "", "1000000", "0", "0", "1", "1633", "0", "4.0", "0.0", "0.0", "4.0", "0.0", "0.0");
INSERT INTO cos_rpg_items VALUES("674", "偷了就走手套", "", "1", "60", "0", "8", "", "", "4000000", "0", "0", "1", "1634", "0", "5.0", "0.0", "0.0", "4.5", "0.0", "0.0");
INSERT INTO cos_rpg_items VALUES("675", "保證偷不到手套", "", "1", "100", "0", "8", "", "", "10000000", "0", "0", "1", "1635", "0", "6.0", "0.0", "0.0", "5.0", "0.0", "0.0");
請問有哪裡改錯嗎?不然怎麼匯不進資料庫...

還有就是我要是想要增加新職業的話就會變成這樣
17 蠢系Lv9 攻擊+23.0 速度+22.0 30000
18 蠢系Lv9 攻擊+23.0 速度+22.0 30000

就是同樣的東西會變成兩行...

我只是匯入
INSERT INTO cos_rpg_position VALUES("85", "蠢系Lv1", "10", "0", "2000", "7.0", "0.0", "0.0", "6.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("86", "蠢系Lv2", "10", "1", "3000", "9.0", "0.0", "0.0", "8.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("87", "蠢系Lv3", "10", "2", "4500", "11.0", "0.0", "0.0", "10.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("88", "蠢系Lv4", "10", "3", "6000", "13.0", "0.0", "0.0", "12.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("89", "蠢系Lv5", "10", "4", "8000", "15.0", "0.0", "0.0", "14.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("90", "蠢系Lv6", "10", "5", "11000", "17.0", "0.0", "0.0", "16.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("91", "蠢系Lv7", "10", "6", "15000", "19.0", "0.0", "0.0", "18.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("92", "蠢系Lv8", "10", "7", "20000", "21.0", "0.0", "0.0", "20.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("93", "蠢系Lv9", "10", "8", "30000", "23.0", "0.0", "0.0", "22.0", "0.0", "0.0");
而已,本來是只有蠢系會這樣,但是後來重新匯入時連笙美系都會變成兩行...
DL
竹貓忠實會員
竹貓忠實會員
文章: 717
註冊時間: 2005-03-05 15:29

文章 DL »

會不會是編碼問題?
頭像
心靈捕手
默默耕耘的老師
默默耕耘的老師
文章: 8510
註冊時間: 2004-04-30 01:54
來自: Taiwan

文章 心靈捕手 »

DL 寫:會不會是編碼問題?
我猜想, 應該是.

--
To 最初:

建議您:
匯入資料庫前, 試著先將您的 '*.sql' 轉存 utf-8 碼.

參考連結:
http://phpbb-tw.net/phpbb/viewtopic.php?p=230924#230924
施比受有福,祝福您好運! ^_^
歡迎光臨★★心靈捕手★★ :: 討論區
https://wang5555.dnsfor.me/phpBB3/
最初
星球公民
星球公民
文章: 34
註冊時間: 2007-01-11 21:41

文章 最初 »

我忘記說了!我架的論壇是全BIG-5

還有就是我用一行一行輸入跟存成.sql回傳的錯誤一樣,他都是說第一行錯誤...(每行當第一行都一樣)

我要是用.sql輸入我有改成BIG-5編碼,還有文字編碼檔案有改成latin1

不知道錯誤出在哪?應該也還沒到輸入的上限阿...

還有我的新職業在職業屬性一覽裡變成會跑兩行...就像這樣
15 蠢系Lv8 攻擊+21.0 速度+20.0 20000
16 蠢系Lv8 攻擊+21.0 速度+20.0 20000
17 蠢系Lv9 攻擊+23.0 速度+22.0 30000
18 蠢系Lv9 攻擊+23.0 速度+22.0 30000
本來是蠢系才會這樣,但是現在連笙美系都會這樣,不知道是資料庫哪裡出問題了?
頭像
心靈捕手
默默耕耘的老師
默默耕耘的老師
文章: 8510
註冊時間: 2004-04-30 01:54
來自: Taiwan

文章 心靈捕手 »

最初 寫:我忘記說了!我架的論壇是全BIG-5

還有就是我用一行一行輸入跟存成.sql回傳的錯誤一樣,他都是說第一行錯誤...(每行當第一行都一樣)

我要是用.sql輸入我有改成BIG-5編碼,還有文字編碼檔案有改成latin1

不知道錯誤出在哪?應該也還沒到輸入的上限阿...

還有我的新職業在職業屬性一覽裡變成會跑兩行...就像這樣
15 蠢系Lv8 攻擊+21.0 速度+20.0 20000
16 蠢系Lv8 攻擊+21.0 速度+20.0 20000
17 蠢系Lv9 攻擊+23.0 速度+22.0 30000
18 蠢系Lv9 攻擊+23.0 速度+22.0 30000
本來是蠢系才會這樣,但是現在連笙美系都會這樣,不知道是資料庫哪裡出問題了?
您的架站環境較特殊.
1. 您的 PHP 版本為 '5.1.6'
2. 您的論壇 '資料庫編碼' 應該是 'utf8'
3. 以瀏覽器檢視您的網站, 竟然出現不同的編碼?

圖檔

圖檔

--
此外掛升級至 1.0.5 後, 我已經將它轉 utf-8 碼,
既然您之前的安裝, 匯入資料庫沒問題,
沒有理由, 無法再匯入.

若以第一篇文章的錯誤訊息推斷,
則表示您匯入新的 *.sql 之前, 沒有轉 utf-8碼.

若以您前面回文推斷?
因為您並未再貼出任何錯誤訊息,
所以等於是 '瞎子摸象',
根本無法給您有效的建議.

建議您:
1. 匯入新的 *.sql 之前, 先轉 utf-8 碼
2. 貼出 '第一行錯誤' 的錯誤訊息
施比受有福,祝福您好運! ^_^
歡迎光臨★★心靈捕手★★ :: 討論區
https://wang5555.dnsfor.me/phpBB3/
最初
星球公民
星球公民
文章: 34
註冊時間: 2007-01-11 21:41

文章 最初 »

沒說詳細真是抱歉...

應該是分成兩個問題

一:新增的蠢系跟笙美系的職業屬性一覽裡會重複

二:新增武器(道具)的時候會出現錯誤

圖檔

PS. '資料庫編碼' 的怪異是因為我之前的論壇是用BIG-5碼、後來因為會造成原來的資料變亂碼

所以把所有的UTF-8碼轉成BIG-5碼(資料庫是UTF-8碼?會不會是我有哪個檔案沒改成BIG-5?)

還有就是*.sql要是用UTF-8碼匯入論壇會出現亂碼(出現的問題跟上面的圖片一樣)

最後...請問
1. 您的 PHP 版本為 '5.1.6'
這個指的是哪裡的版本?
頭像
心靈捕手
默默耕耘的老師
默默耕耘的老師
文章: 8510
註冊時間: 2004-04-30 01:54
來自: Taiwan

文章 心靈捕手 »

最初 寫:沒說詳細真是抱歉...

應該是分成兩個問題

一:新增的蠢系跟笙美系的職業屬性一覽裡會重複

二:新增武器(道具)的時候會出現錯誤

圖檔

PS. '資料庫編碼' 的怪異是因為我之前的論壇是用BIG-5碼、後來因為會造成原來的資料變亂碼

所以把所有的UTF-8碼轉成BIG-5碼(資料庫是UTF-8碼?會不會是我有哪個檔案沒改成BIG-5?)

還有就是*.sql要是用UTF-8碼匯入論壇會出現亂碼(出現的問題跟上面的圖片一樣)

最後...請問
1. 您的 PHP 版本為 '5.1.6'
這個指的是哪裡的版本?
建議您:
0. 除非您有更改編碼, 否則用您之前安裝的 (編碼) 方法匯入.
1. 刪除原有的 (蠢系跟笙美系的職業) 資料後, 再重新匯入.
2. 您所新增 (武器) 的 '欄位數' 不對.
底下是原來 (663) 者, 您少了後面兩個.
INSERT INTO phpbb_rpg_items VALUES("663", "聖皇之靴", "", "5", "100", "0", "8", "", "", "3000000", "0", "0", "5", "1623", "0", "0.0", "9.0", "0.0", "9.0", "0.0", "0.0", "0", "0");
3. 您的第一篇訊息, 已經透露了學校主機的環境.
----開始 原始資料----
ERROR: C1 C2 LEN: 47 48 167
STR: ?

CVS: $Id: sqlparser.lib.php,v 2.36 2005/08/08 20:22:11 lem9 Exp $
MySQL: 5.0.22
USR OS, AGENT, VER: Win IE 6.0
PMA: 2.6.4-pl4
PHP VER,OS: 5.1.6 Linux
LANG: zhtw-utf-8
SQL: INSERT INTO cos_rpg_items VALUES("664", "?m?ߥΰ??F?褢?M", "", "1", "15", "0", "8", "", "", "18000", "0", "0", "1", "1624", "0", "0.2", "0.0", "0.0", "0.1", "0.0", "0.0")
----結束 原始資料----
施比受有福,祝福您好運! ^_^
歡迎光臨★★心靈捕手★★ :: 討論區
https://wang5555.dnsfor.me/phpBB3/
最初
星球公民
星球公民
文章: 34
註冊時間: 2007-01-11 21:41

文章 最初 »

武器的問題已經解決了!感謝心靈捕手前輩的解答

我刪除了蠢系跟笙美系的資料重輸入了好幾次都會造成重複顯示的問題...

以下是我的刪除重輸的步驟

1.進入phpMyAdaim

2.進入資料表cos_rpg_position

3.按清空
圖檔

4.輸入全部的職業

跟原本在水怪中的SQL.sql裡的職業部分一樣,但是加了下面幾行
INSERT INTO cos_rpg_position VALUES("85", "蠢系Lv1", "10", "0", "2000", "7.0", "0.0", "0.0", "6.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("86", "蠢系Lv2", "10", "1", "3000", "9.0", "0.0", "0.0", "8.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("87", "蠢系Lv3", "10", "2", "4500", "11.0", "0.0", "0.0", "10.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("88", "蠢系Lv4", "10", "3", "6000", "13.0", "0.0", "0.0", "12.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("89", "蠢系Lv5", "10", "4", "8000", "15.0", "0.0", "0.0", "14.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("90", "蠢系Lv6", "10", "5", "11000", "17.0", "0.0", "0.0", "16.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("91", "蠢系Lv7", "10", "6", "15000", "19.0", "0.0", "0.0", "18.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("92", "蠢系Lv8", "10", "7", "20000", "21.0", "0.0", "0.0", "20.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("93", "蠢系Lv9", "10", "8", "30000", "23.0", "0.0", "0.0", "22.0", "0.0", "0.0");
若是去掉這幾行的話我的笙美系也還是會重複,不知道是我哪裡出了問題?

或是資料庫要全部重新輸入?
頭像
心靈捕手
默默耕耘的老師
默默耕耘的老師
文章: 8510
註冊時間: 2004-04-30 01:54
來自: Taiwan

文章 心靈捕手 »

最初 寫:武器的問題已經解決了!感謝心靈捕手前輩的解答

我刪除了蠢系跟笙美系的資料重輸入了好幾次都會造成重複顯示的問題...

以下是我的刪除重輸的步驟

1.進入phpMyAdaim

2.進入資料表cos_rpg_position

3.按清空
圖檔

4.輸入全部的職業

跟原本在水怪中的SQL.sql裡的職業部分一樣,但是加了下面幾行
INSERT INTO cos_rpg_position VALUES("85", "蠢系Lv1", "10", "0", "2000", "7.0", "0.0", "0.0", "6.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("86", "蠢系Lv2", "10", "1", "3000", "9.0", "0.0", "0.0", "8.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("87", "蠢系Lv3", "10", "2", "4500", "11.0", "0.0", "0.0", "10.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("88", "蠢系Lv4", "10", "3", "6000", "13.0", "0.0", "0.0", "12.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("89", "蠢系Lv5", "10", "4", "8000", "15.0", "0.0", "0.0", "14.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("90", "蠢系Lv6", "10", "5", "11000", "17.0", "0.0", "0.0", "16.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("91", "蠢系Lv7", "10", "6", "15000", "19.0", "0.0", "0.0", "18.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("92", "蠢系Lv8", "10", "7", "20000", "21.0", "0.0", "0.0", "20.0", "0.0", "0.0");
INSERT INTO cos_rpg_position VALUES("93", "蠢系Lv9", "10", "8", "30000", "23.0", "0.0", "0.0", "22.0", "0.0", "0.0");
若是去掉這幾行的話我的笙美系也還是會重複,不知道是我哪裡出了問題?

或是資料庫要全部重新輸入?
建議您:
試試刪除該資料表 (cos_rpg_position) 後,
重建新資料表, 以及所有的 (含新增) 欄位.
施比受有福,祝福您好運! ^_^
歡迎光臨★★心靈捕手★★ :: 討論區
https://wang5555.dnsfor.me/phpBB3/
最初
星球公民
星球公民
文章: 34
註冊時間: 2007-01-11 21:41

文章 最初 »

感謝心靈捕手前輩!

原來不是cos_rpg_position(原:phpbb_rpg_position)這個欄位作祟

是cos_rpg_setting(原:phpbb_rpg_setting)這個欄位作祟

似乎是重複輸入SQL.sql中#職業列表 裡的

INSERT INTO cos_rpg_setting VALUES("1", "9", "笙美系");

被我重複輸入了一次所造成的重複

再次感謝心靈捕手前輩的幫助!
主題已鎖定

回到「外掛問題討論」