竹貓星球

發表於 : **2003-12-29 22:15**

MOD水怪RPG完整版

我想要在水怪增加新職業
在 phpmyadmin 要增加第128號新職業時出現這個訊息\r

INSERT INTO `phpbb_rpg_position`
VALUES ( 128, '職業14號之6', 14, 7, 780000, '2.2', '4.8', '19.0', '10.0', '1.0', '9.0' )

MySQL 傳回：

#1062 - Duplicate entry '127' for key 1

我要如何修改才能增加超過127呢

發表於 : **2003-12-30 01:38**

ilove1291 寫:MOD水怪RPG完整版

我想要在水怪增加新職業
在 phpmyadmin 要增加第128號新職業時出現這個訊息\r

INSERT INTO `phpbb_rpg_position`
VALUES ( 128, '職業14號之6', 14, 7, 780000, '2.2', '4.8', '19.0', '10.0', '1.0', '9.0' )

MySQL 傳回：

#1062 - Duplicate entry '127' for key 1

我要如何修改才能增加超過127呢

那個phpbb_rpg_position是資料表還是欄位？？？
每個欄位的形別是啥？？

發表於 : **2003-12-30 01:51**

streitleak 寫:那個phpbb_rpg_position是資料表還是欄位？？？
每個欄位的形別是啥？？

我幫忙貼一下吧，原始(未經過修改)是這個樣子：

代碼: 選擇全部

# 所有職照列表\r
CREATE TABLE `phpbb_rpg_position` (
  `position_id` tinyint(4) NOT NULL auto_increment,
  `position_name` varchar(30) default NULL,
  `position_class` tinyint(2) NOT NULL default '0',
  `position_order` tinyint(2) NOT NULL default '0',
  `position_fee` int(8) default NULL,
  `attack_property` decimal(4,1) NOT NULL default '0.0',
  `defense_property` decimal(4,1) NOT NULL default '0.0',
  `magic_property` decimal(4,1) NOT NULL default '0.0',
  `speed_property` decimal(4,1) NOT NULL default '0.0',
  `hp_property` decimal(4,1) NOT NULL default '0.0',
  `mp_property` decimal(4,1) NOT NULL default '0.0',
  PRIMARY KEY  (`position_id`)
) TYPE=MyISAM;

INSERT INTO phpbb_rpg_position VALUES("1", "小老百姓", "0", "1", "500", "1.5", "1.5", "1.0", "1.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("2", "老百姓", "0", "2", "1000", "2.0", "2.0", "1.2", "1.2", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("3", "士兵", "0", "3", "1500", "2.5", "2.5", "1.5", "1.5", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("4", "戰士系Lv1", "1", "0", "2000", "4.0", "4.0", "2.0", "3.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("5", "戰士系Lv2", "1", "1", "3000", "5.2", "5.2", "2.6", "4.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("6", "戰士系Lv3", "1", "2", "4500", "6.4", "6.4", "3.2", "5.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("7", "戰士系Lv4", "1", "3", "6000", "7.6", "7.6", "3.8", "6.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("8", "戰士系Lv5", "1", "4", "8000", "8.8", "8.8", "4.4", "7.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("9", "戰士系Lv6", "1", "5", "11000", "10.0", "10.0", "5.0", "8.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("10", "戰士系Lv7", "1", "6", "15000", "11.2", "11.2", "5.6", "9.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("11", "戰士系Lv8", "1", "7", "20000", "12.4", "12.4", "6.2", "10.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("12", "戰士系Lv9", "1", "8", "30000", "13.6", "13.6", "6.8", "11.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("13", "弓箭系Lv1", "2", "0", "2000", "5.0", "2.0", "3.0", "3.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("14", "弓箭系Lv2", "2", "1", "3000", "6.5", "2.6", "3.9", "3.9", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("15", "弓箭系Lv3", "2", "2", "4500", "8.0", "3.2", "4.8", "4.8", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("16", "弓箭系Lv4", "2", "3", "6000", "9.5", "3.8", "5.7", "5.7", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("17", "弓箭系Lv5", "2", "4", "8000", "11.0", "4.4", "6.6", "6.6", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("18", "弓箭系Lv6", "2", "5", "11000", "13.5", "5.0", "7.5", "7.5", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("19", "弓箭系Lv7", "2", "6", "15000", "15.0", "5.6", "8.4", "8.4", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("20", "弓箭系Lv8", "2", "7", "20000", "16.5", "6.2", "9.3", "9.3", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("21", "弓箭系Lv9", "2", "8", "30000", "18.0", "6.8", "10.2", "10.2", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("22", "僧侶系Lv1", "3", "0", "2000", "3.0", "3.0", "4.5", "2.5", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("23", "僧侶系Lv2", "3", "1", "3000", "3.9", "3.9", "6.0", "3.2", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("24", "僧侶系Lv3", "3", "2", "4500", "4.8", "4.8", "7.5", "3.9", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("25", "僧侶系Lv4", "3", "3", "6000", "5.7", "5.7", "9.0", "4.6", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("26", "僧侶系Lv5", "3", "4", "8000", "6.6", "6.6", "10.5", "5.3", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("27", "僧侶系Lv6", "3", "5", "11000", "7.5", "7.5", "12.0", "6.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("28", "僧侶系Lv7", "3", "6", "15000", "8.4", "8.4", "13.5", "6.7", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("29", "僧侶系Lv8", "3", "7", "20000", "9.3", "9.3", "15.0", "7.4", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("30", "僧侶系Lv9", "3", "8", "30000", "10.2", "10.2", "16.5", "8.1", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("31", "魔法系Lv1", "4", "0", "2000", "3.0", "3.0", "5.0", "2.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("32", "魔法系Lv2", "4", "1", "3000", "3.9", "3.9", "6.6", "2.6", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("33", "魔法系Lv3", "4", "2", "4500", "4.8", "4.8", "8.2", "3.2", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("34", "魔法系Lv4", "4", "3", "6000", "5.7", "5.7", "9.8", "3.8", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("35", "魔法系Lv5", "4", "4", "8000", "6.6", "6.6", "11.4", "4.4", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("36", "魔法系Lv6", "4", "5", "11000", "7.5", "7.5", "13.0", "5.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("37", "魔法系Lv7", "4", "6", "15000", "8.4", "8.4", "14.6", "5.6", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("38", "魔法系Lv8", "4", "7", "20000", "9.3", "9.3", "16.2", "6.2", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("39", "魔法系Lv9", "4", "8", "30000", "10.2", "10.2", "17.8", "6.8", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("40", "騎兵系Lv1", "5", "0", "2000", "4.0", "3.0", "2.0", "4.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("41", "騎兵系Lv2", "5", "1", "3000", "5.2", "4.0", "2.6", "5.2", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("42", "騎兵系Lv3", "5", "2", "4500", "6.4", "5.0", "3.2", "6.4", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("43", "騎兵系Lv4", "5", "3", "6000", "7.6", "6.0", "3.8", "7.6", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("44", "騎兵系Lv5", "5", "4", "8000", "8.8", "7.0", "4.4", "8.8", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("45", "騎兵系Lv6", "5", "5", "11000", "10.0", "8.0", "5.0", "10.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("46", "騎兵系Lv7", "5", "6", "15000", "11.2", "9.0", "5.6", "11.2", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("47", "騎兵系Lv8", "5", "7", "20000", "12.4", "10.0", "6.2", "12.4", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("48", "騎兵系Lv9", "5", "8", "30000", "13.6", "11.0", "6.8", "13.6", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("49", "甲兵系Lv1", "6", "0", "2000", "3.0", "6.0", "2.0", "2.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("50", "甲兵系Lv2", "6", "1", "3000", "3.9", "7.9", "2.6", "2.6", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("51", "甲兵系Lv3", "6", "2", "4500", "4.8", "9.8", "3.2", "3.2", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("52", "甲兵系Lv4", "6", "3", "6000", "5.7", "11.7", "3.8", "3.8", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("53", "甲兵系Lv5", "6", "4", "8000", "6.6", "13.6", "4.4", "4.4", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("54", "甲兵系Lv6", "6", "5", "11000", "7.5", "15.5", "5.0", "5.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("55", "甲兵系Lv7", "6", "6", "15000", "8.4", "17.4", "5.6", "5.6", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("56", "甲兵系Lv8", "6", "7", "20000", "9.3", "19.3", "6.2", "6.2", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("57", "甲兵系Lv9", "6", "8", "30000", "10.2", "21.2", "6.8", "6.8", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("58", "忍者系Lv1", "7", "0", "2000", "5.0", "2.0", "2.0", "4.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("59", "忍者系Lv2", "7", "1", "3000", "6.6", "2.6", "2.6", "5.2", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("60", "忍者系Lv3", "7", "2", "4500", "8.2", "3.2", "3.2", "6.4", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("61", "忍者系Lv4", "7", "3", "6000", "9.8", "3.8", "3.8", "7.6", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("62", "忍者系Lv5", "7", "4", "8000", "11.4", "4.4", "4.4", "8.8", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("63", "忍者系Lv6", "7", "5", "11000", "13.0", "5.0", "5.0", "10.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("64", "忍者系Lv7", "7", "6", "15000", "14.6", "5.6", "5.6", "11.2", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("65", "忍者系Lv8", "7", "7", "20000", "16.2", "6.2", "6.2", "12.4", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("66", "忍者系Lv9", "7", "8", "30000", "17.8", "6.8", "6.8", "13.6", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("67", "盜賊系Lv1", "8", "0", "2000", "3.0", "3.0", "2.0", "5.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("68", "盜賊系Lv2", "8", "1", "3000", "3.9", "3.9", "2.6", "6.6", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("69", "盜賊系Lv3", "8", "2", "4500", "4.8", "4.8", "3.2", "8.2", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("70", "盜賊系Lv4", "8", "3", "6000", "5.7", "5.7", "3.8", "9.8", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("71", "盜賊系Lv5", "8", "4", "8000", "6.6", "6.6", "4.4", "11.4", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("72", "盜賊系Lv6", "8", "5", "11000", "7.5", "7.5", "5.0", "13.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("73", "盜賊系Lv7", "8", "6", "15000", "8.4", "8.4", "5.6", "14.6", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("74", "盜賊系Lv8", "8", "7", "20000", "9.3", "9.3", "6.2", "16.2", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("75", "盜賊系Lv9", "8", "8", "30000", "10.2", "10.2", "6.8", "17.8", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("76", "笙美系Lv1", "9", "0", "2000", "3.5", "3.5", "3.0", "3.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("77", "笙美系Lv2", "9", "1", "3000", "4.5", "4.5", "4.0", "4.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("78", "笙美系Lv3", "9", "2", "4500", "5.5", "5.5", "5.0", "5.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("79", "笙美系Lv4", "9", "3", "6000", "6.5", "6.5", "6.0", "6.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("80", "笙美系Lv5", "9", "4", "8000", "7.5", "7.5", "7.0", "7.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("81", "笙美系Lv6", "9", "5", "11000", "8.5", "8.5", "8.0", "8.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("82", "笙美系Lv7", "9", "6", "15000", "9.5", "9.5", "9.0", "9.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("83", "笙美系Lv8", "9", "7", "20000", "10.5", "10.5", "10.0", "10.0", "0.0", "0.0");
INSERT INTO phpbb_rpg_position VALUES("84", "笙美系Lv9", "9", "8", "30000", "11.5", "11.5", "11.0", "11.0", "0.0", "0.0");

發表於 : **2003-12-30 05:06**

原本只有84個職業，
你居然增加到128個了@@'(汗)
不過話說回來，
你既然有辦法增加到127個，
不可能128個不行！

我沒研究過rpg，不敢說你問題在哪，
不過mySQL回傳的錯誤訊息是你重複輸入資料了！
可能是因為你新增的資料與第127筆的資料中有些是不能重複的吧。
再仔細檢查一下吧。

發表於 : **2003-12-30 05:29**

`position_id` tinyint(4) NOT NULL auto_increment,

tinyint值為(-128~127)~

所以當值為128~不合格式~~

可以將資料欄位型態的屬性加入UNSIGNED只取正值\r
則資料欄位將可以輸入(0~255)

要注意一點~~~確定該欄位資料並沒有負數

或者可以考慮修改欄位為smallint(6)
可容許範圍(-32768~32767)~~加入UNSIGNED屬性(0~65535)
3萬多個職業~~~用不完了吧~~

發表於 : **2003-12-30 07:48**

messagebox 寫:可以考慮修改欄位為smallint(6)
可容許範圍(-32768~32767)~~加入UNSIGNED屬性(0~65535)
3萬多個職業~~~用不完了吧~~

太棒了
我真的有15類128種職業對於想名字想不出來的可以參考

代碼: 選擇全部

CREATE TABLE `phpbb_rpg_position` (
  `position_id` smallint(6) NOT NULL auto_increment,
  `position_name` varchar(30) default NULL,
  `position_class` tinyint(2) NOT NULL default '0',
  `position_order` tinyint(2) NOT NULL default '0',
  `position_fee` int(8) default NULL,
  `attack_property` decimal(4,1) NOT NULL default '0.0',
  `defense_property` decimal(4,1) NOT NULL default '0.0',
  `magic_property` decimal(4,1) NOT NULL default '0.0',
  `speed_property` decimal(4,1) NOT NULL default '0.0',
  `hp_property` decimal(4,1) NOT NULL default '0.0',
  `mp_property` decimal(4,1) NOT NULL default '0.0',
  PRIMARY KEY  (`position_id`)
) TYPE=MyISAM AUTO_INCREMENT=130 ;

#
# 列出以下資料庫的數據： `phpbb_rpg_position`
#

INSERT INTO `phpbb_rpg_position` VALUES (1, '初心者', 0, 1, 500, '1.5', '1.5', '1.0', '1.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (2, '小農夫', 0, 2, 1000, '2.0', '2.0', '1.2', '1.2', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (3, '農場主人', 0, 3, 1500, '2.5', '2.5', '1.5', '1.5', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (4, '戰士', 1, 0, 20000, '4.0', '4.0', '2.0', '3.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (5, '劍鬥士', 1, 1, 30000, '5.2', '5.2', '2.6', '4.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (6, '傭兵戰士', 1, 2, 45000, '6.4', '6.4', '3.2', '5.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (7, '帝國輕裝步兵', 1, 3, 60000, '7.6', '7.6', '3.8', '6.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (8, '步兵隊長', 1, 4, 80000, '8.8', '8.8', '4.4', '7.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (9, '將軍', 1, 5, 110000, '10.0', '10.0', '5.0', '8.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (10, '龍戰士', 1, 6, 150000, '11.2', '11.2', '5.6', '9.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (11, '聖戰士', 1, 7, 200000, '12.4', '12.4', '6.2', '10.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (12, '戰神', 1, 8, 3000000, '13.6', '13.6', '6.8', '11.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (13, '弓箭手', 2, 0, 20000, '5.0', '2.0', '3.0', '3.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (14, '長弓手', 2, 1, 30000, '6.5', '2.6', '3.9', '3.9', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (15, '獵人', 2, 2, 45000, '8.0', '3.2', '4.8', '4.8', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (16, '帝國獵兵', 2, 3, 60000, '9.5', '3.8', '5.7', '5.7', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (17, '狙擊手', 2, 4, 80000, '11.0', '4.4', '6.6', '6.6', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (18, '火槍使', 2, 5, 110000, '13.5', '5.0', '7.5', '7.5', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (19, '快槍俠', 2, 6, 150000, '15.0', '5.6', '8.4', '8.4', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (20, '賞金獵人', 2, 7, 200000, '16.5', '6.2', '9.3', '9.3', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (21, '鷹眼', 2, 8, 3000000, '18.0', '6.8', '10.2', '10.2', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (22, '僧兵', 3, 0, 20000, '3.0', '3.0', '4.5', '2.5', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (23, '重裝僧兵', 3, 1, 30000, '3.9', '3.9', '6.0', '3.2', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (24, '自由僧兵', 3, 2, 45000, '4.8', '4.8', '7.5', '3.9', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (25, '帝國僧兵', 3, 3, 60000, '5.7', '5.7', '9.0', '4.6', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (26, '聖地守護者', 3, 4, 80000, '6.6', '6.6', '10.5', '5.3', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (27, '神思者', 3, 5, 110000, '7.5', '7.5', '12.0', '6.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (28, '神學者', 3, 6, 150000, '8.4', '8.4', '13.5', '6.7', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (29, '先知', 3, 7, 200000, '9.3', '9.3', '15.0', '7.4', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (30, '教宗', 3, 8, 3000000, '10.2', '10.2', '16.5', '8.1', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (31, '魔法學生', 4, 0, 20000, '3.0', '3.0', '5.0', '2.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (32, '魔法留學生', 4, 1, 30000, '3.9', '3.9', '6.6', '2.6', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (33, '法師', 4, 2, 45000, '4.8', '4.8', '8.2', '3.2', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (34, '宮廷魔術師', 4, 3, 60000, '5.7', '5.7', '9.8', '3.8', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (35, '白魔導士', 4, 4, 80000, '6.6', '6.6', '11.4', '4.4', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (36, '黑魔導士', 4, 5, 110000, '7.5', '7.5', '13.0', '5.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (37, '青魔導士', 4, 6, 150000, '8.4', '8.4', '14.6', '5.6', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (38, '赤魔導士', 4, 7, 200000, '9.3', '9.3', '16.2', '6.2', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (39, '時魔導士', 4, 8, 3000000, '10.2', '10.2', '17.8', '6.8', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (40, '騎士學徒', 5, 0, 20000, '4.0', '3.0', '2.0', '4.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (41, '騎士', 5, 1, 30000, '5.2', '4.0', '2.6', '5.2', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (42, '遊騎兵', 5, 2, 45000, '6.4', '5.0', '3.2', '6.4', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (43, '帝國騎兵', 5, 3, 60000, '7.6', '6.0', '3.8', '7.6', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (44, '遊俠', 5, 4, 80000, '8.8', '7.0', '4.4', '8.8', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (45, '皇家騎士', 5, 5, 110000, '10.0', '8.0', '5.0', '10.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (46, '騎士團長', 5, 6, 150000, '11.2', '9.0', '5.6', '11.2', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (47, '龍騎士', 5, 7, 200000, '12.4', '10.0', '6.2', '12.4', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (48, '聖殿騎士', 5, 8, 3000000, '13.6', '11.0', '6.8', '13.6', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (49, '斧兵', 6, 0, 20000, '3.0', '6.0', '2.0', '2.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (50, '重裝步兵', 6, 1, 30000, '3.9', '7.9', '2.6', '2.6', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (51, '帝都守衛', 6, 2, 45000, '4.8', '9.8', '3.2', '3.2', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (52, '帝國重裝步兵', 6, 3, 60000, '5.7', '11.7', '3.8', '3.8', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (53, '帝國機甲兵', 6, 4, 80000, '6.6', '13.6', '4.4', '4.4', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (54, '重裝幾甲兵', 6, 5, 110000, '7.5', '15.5', '5.0', '5.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (55, '人型兵器操者', 6, 6, 150000, '8.4', '17.4', '5.6', '5.6', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (56, 'MH駕駛員', 6, 7, 200000, '9.3', '19.3', '6.2', '6.2', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (57, '魔裝機神', 6, 8, 300000, '10.2', '21.2', '6.8', '6.8', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (58, '忍蛋', 7, 0, 20000, '5.0', '2.0', '2.0', '4.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (59, '下忍', 7, 1, 30000, '6.6', '2.6', '2.6', '5.2', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (60, '中忍', 7, 2, 45000, '8.2', '3.2', '3.2', '6.4', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (61, '帝國忍者', 7, 3, 60000, '9.8', '3.8', '3.8', '7.6', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (62, '刺客', 7, 4, 80000, '11.4', '4.4', '4.4', '8.8', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (63, '暗部', 7, 5, 110000, '13.0', '5.0', '5.0', '10.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (64, '影武者', 7, 6, 150000, '14.6', '5.6', '5.6', '11.2', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (65, '上忍', 7, 7, 200000, '16.2', '6.2', '6.2', '12.4', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (66, '火影', 7, 8, 3000000, '17.8', '6.8', '6.8', '13.6', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (67, '職業小偷', 8, 0, 20000, '3.0', '3.0', '2.0', '5.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (68, '流氓', 8, 1, 30000, '3.9', '3.9', '2.6', '6.6', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (69, '特攻隊員', 8, 2, 45000, '4.8', '4.8', '3.2', '8.2', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (70, '特攻隊長', 8, 3, 60000, '5.7', '5.7', '3.8', '9.8', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (71, '黑道堂主', 8, 4, 80000, '6.6', '6.6', '4.4', '11.4', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (72, '黑道家族成員', 8, 5, 110000, '7.5', '7.5', '5.0', '13.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (73, '黑道幫主', 8, 6, 150000, '8.4', '8.4', '5.6', '14.6', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (74, '黑道盟主', 8, 7, 200000, '9.3', '9.3', '6.2', '16.2', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (75, '黑幫教父', 8, 8, 3000000, '10.2', '10.2', '6.8', '17.8', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (76, '服事', 9, 0, 20000, '3.5', '3.5', '3.0', '3.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (77, '祭司', 9, 1, 30000, '4.5', '4.5', '4.0', '4.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (78, '大祭司', 9, 2, 45000, '5.5', '5.5', '5.0', '5.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (79, '修行者', 9, 3, 60000, '6.5', '6.5', '6.0', '6.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (80, '退魔人', 9, 4, 80000, '7.5', '7.5', '7.0', '7.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (81, '靈操者', 9, 5, 11000, '8.5', '8.5', '8.0', '8.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (82, '聖人', 9, 6, 150000, '9.5', '9.5', '9.0', '9.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (83, '類神人', 9, 7, 200000, '10.5', '10.5', '10.0', '10.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (84, '神之子', 9, 8, 3000000, '11.5', '11.5', '11.0', '11.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (85, '小精靈', 10, 0, 40000, '3.5', '2.5', '3.5', '3.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (86, '長耳精靈', 10, 1, 80000, '4.5', '3.5', '4.5', '4.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (87, '雙翅精靈', 10, 2, 120000, '5.5', '4.5', '5.5', '4.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (88, '精靈巡守', 10, 3, 140000, '6.5', '5.5', '6.5', '5.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (89, '銀月遊俠', 10, 4, 160000, '7.5', '6.5', '7.5', '5.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (90, '精靈使', 10, 5, 180000, '8.5', '7.5', '8.5', '6.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (91, '聖精靈', 10, 6, 220000, '9.5', '8.5', '9.5', '6.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (92, '精靈王', 10, 7, 230000, '10.5', '9.5', '10.5', '7.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (93, '席林長老', 10, 8, 4000000, '11.5', '10.5', '11.5', '7.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (94, '半獸人', 11, 0, 45000, '4.0', '2.5', '1.5', '2.5', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (95, '狼人', 11, 1, 80000, '5.0', '2.5', '1.5', '2.5', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (96, '黑狐妖', 11, 2, 160000, '7.0', '3.5', '2.5', '3.5', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (97, '獸人領主', 11, 3, 200000, '9.0', '3.5', '2.5', '3.5', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (98, '魔獸人', 11, 4, 250000, '11.0', '4.5', '3.5', '4.5', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (99, '半龍人', 11, 5, 300000, '13.0', '4.5', '3.5', '4.5', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (100, '聖獸人', 11, 6, 500000, '15.0', '5.5', '4.5', '5.5', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (101, '神獸人', 11, 7, 750000, '17.0', '5.5', '4.5', '5.5', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (102, '獸人王', 11, 8, 4500000, '19.0', '6.5', '5.5', '6.5', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (103, '鬥士', 12, 0, 20000, '4.2', '3.8', '2.0', '3.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (104, '格鬥家', 12, 1, 40000, '5.2', '4.8', '2.0', '5.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (105, '武術師', 12, 2, 80000, '7.2', '5.8', '2.0', '7.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (106, '帝王護衛', 12, 3, 120000, '8.2', '6.8', '2.0', '9.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (107, '幻影鬥士', 12, 4, 160000, '10.2', '7.8', '2.0', '11.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (108, '聖拳士', 12, 5, 320000, '11.2', '8.8', '2.0', '12.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (109, '神拳士', 12, 6, 400000, '12.2', '9.8', '2.0', '14.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (110, '修羅鬥士', 12, 7, 600000, '14.2', '10.8', '2.0', '15.0', '0.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (111, '一代宗師', 12, 8, 3000000, '15.2', '10.8', '2.0', '16.0', '1.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (112, '收集者', 13, 0, 20000, '4.2', '4.8', '1.0', '3.0', '1.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (113, '工匠', 13, 1, 40000, '5.2', '5.8', '1.0', '4.0', '3.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (114, '商人', 13, 2, 150000, '6.2', '6.8', '1.0', '5.0', '5.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (115, '武裝商團', 13, 3, 300000, '7.2', '7.8', '1.0', '6.0', '7.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (116, '銀匠', 13, 4, 450000, '8.2', '8.8', '1.0', '7.0', '9.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (117, '練金術士', 13, 5, 600000, '9.2', '8.8', '2.0', '8.0', '11.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (118, '帝國練金術士', 13, 6, 750000, '10.2', '9.8', '3.0', '9.0', '13.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (119, '黃金練金術士', 13, 7, 990000, '11.2', '9.8', '4.0', '10.0', '15.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (120, '人體練金術士', 13, 8, 4000000, '13.2', '10.8', '5.0', '11.0', '17.0', '0.0');
INSERT INTO `phpbb_rpg_position` VALUES (121, '小道士', 14, 0, 30000, '2.2', '4.8', '5.0', '3.0', '1.0', '2.0');
INSERT INTO `phpbb_rpg_position` VALUES (122, '幻術士', 14, 1, 50000, '2.2', '4.8', '7.0', '4.0', '1.0', '3.0');
INSERT INTO `phpbb_rpg_position` VALUES (123, '召喚士', 14, 2, 90000, '2.2', '4.8', '9.0', '5.0', '1.0', '4.0');
INSERT INTO `phpbb_rpg_position` VALUES (124, '動物使', 14, 3, 110000, '2.2', '4.8', '11.0', '6.0', '1.0', '5.0');
INSERT INTO `phpbb_rpg_position` VALUES (125, '精靈使', 14, 4, 230000, '2.2', '4.8', '13.0', '7.0', '1.0', '6.0');
INSERT INTO `phpbb_rpg_position` VALUES (126, '魔獸使', 14, 5, 370000, '2.2', '4.8', '15.0', '8.0', '1.0', '7.0');
INSERT INTO `phpbb_rpg_position` VALUES (127, '陰陽使', 14, 6, 510000, '2.2', '4.8', '17.0', '9.0', '1.0', '8.0');
INSERT INTO `phpbb_rpg_position` VALUES (128, '神魔使', 14, 7, 780000, '2.2', '4.8', '19.0', '10.0', '1.0', '9.0');
INSERT INTO `phpbb_rpg_position` VALUES (129, '精神控制者', 14, 8, 2500000, '2.2', '4.8', '21.0', '11.0', '1.0', '10.0');

發表於 : **2003-12-30 08:43**

messagebox 寫:`position_id` tinyint(4) NOT NULL auto_increment,

tinyint值為(-128~127)~

所以當值為128~不合格式~~

吐各槽....範圍是-127~127 你忘了把0算下去....

messagebox 寫:`可以將資料欄位型態的屬性加入UNSIGNED只取正值\r
則資料欄位將可以輸入(0~255)

要注意一點~~~確定該欄位資料並沒有負數

或者可以考慮修改欄位為smallint(6)
可容許範圍(-32768~32767)~~加入UNSIGNED屬性(0~65535)
3萬多個職業~~~用不完了吧~~

這就是我想說的意思....基本上如果沒用用上unsigned這個宣告的話..
一般來說數值都會用第一個位元作為判斷正負數用..所以要用unsigned宣告後才不會用到負數....

發表於 : **2003-12-30 12:37**

streitleak 寫: 吐各槽....範圍是-127~127 你忘了把0算下去....

沒錯的喔~~(-127~127)只有(127*2+1=255)一個bytes應該是0x00-0xFF

正值~~(0-255)~
正負~~(-128~127)~

發表於 : **2003-12-30 19:45**

messagebox 寫:
streitleak 寫: 吐各槽....範圍是-127~127 你忘了把0算下去....
沒錯的喔~~(-127~127)只有(127*2+1=255)一個bytes應該是0x00-0xFF

正值~~(0-255)~
正負~~(-128~127)~

基本上呢....你忘記了一件事....1Byte=8Bits 第一個Bit被拿來當作正負號判斷用..
所以....負數最小以Bits表示的話是11111111...
因為第一個1代表負數所以11111111代表數值為(-1)*(2^6+2^5+2^4+2^3+2^2+2^1+2^0)=-127
而最大正數為01111111轉換後所得數值為\r
2^6+2^5+2^4+2^3+2^2+2^1+2^0=127
所以在沒有宣告unsigned的狀況下...負數最小到-127正數最大到127...
再者...以2進位的算法...只要最後一個Bit不是0的話.根本不可能出現偶數...
所以請再把書翻出來看一下吧..

發表於 : **2003-12-30 20:16**

我看過書了 -128~127

發表於 : **2003-12-30 20:38**

隨便吧~~~
這是mysql官方的文件~~

TINYINT[(M)] [UNSIGNED] [ZEROFILL]
A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255.

發表於 : **2003-12-30 20:56**

ilove1291 寫:太棒了
我真的有15類128種職業對於想名字想不出來的可以參考

感謝大大分享\r
不知道有沒有新職業可用的魔法與裝備可供參考～o_O

發表於 : **2003-12-30 21:01**

我剛買了一本書~上面寫著 TINYINT (-2的七次方到 2的七次方減一 )

-128 ~ 127 或者 unsigned 0~255 (二的八次方-1)

@@" streitleak 兄你書是那一本阿

發表於 : **2003-12-30 21:05**

ilove1291 寫:太棒了
我真的有15類128種職業對於想名字想不出來的可以參考

還參考勒~~~~
直接用抄了~~~

發表於 : **2003-12-30 21:09**

design 寫:我剛買了一本書~上面寫著 TINYINT (-2的七次方到 2的七次方減一 )
-128 ~ 127 或者 unsigned 0~255 (二的八次方-1)

終於讓我知道那個值是怎麼來的了~~
剛剛用計算機算了一下~~

我的資料都來自官方文件~~~以及手上的1本書~~
但是就是沒說為什麼是(-128~127)

竹貓星球

[問題]rpg_position(感謝messagebox)

[問題]rpg_position(感謝messagebox)

Re: [問題]php_rpg_position只能放127個資料

Re: [問題]php_rpg_position只能放127個資料