水客版宠物forD4正式版

看看情况先...

强制装下拉 郁闷 ~~

原帖由 lj80117 于 2006-1-10 14:21 发表


现在在后台修改

后台修改那两个 并不是~~最大的HP 跟 SP 来的~~~~~


100/20  10000/20  这样。。。如何修改呢~？

[ 本帖最后由 jicki 于 2006-1-10 15:05 编辑 ]

楼主。问一下。怎么修改物品价格啊，太贵了。会员买不起啊
我在管理中心哪里只能改几个东西。下面的就都改不了了。不是要我去
PHPMYADMIN修改吧。晕。

1. 
   
2. 数据位于 cdb_mypetitemdata
   
3. 插入数据所用SQL语句为:
   
4. 
   
5. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('alife,1','0','999','50,20','复活之羽','让死掉的宠物复活，并回复少量hp','store,user,useable','','0','+dead,1,+hp,100') ;
   
6. 
   
7. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('alife,2','0','999','70,20','复活之羽2级','让死掉的宠物复活，并回复少量hp和sp','store,user,useable','','0','+dead,1,+hp,300,+sp,100') ;
   
8. 
   
9. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('alife,3','0','999','90,20','复活之羽3级','让死掉的宠物复活，并回复大量hp和少量sp','store,user,useable','','0','+dead,1,+hp,500,+sp,200') ;
   
10. 
    
11. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('armor,1','0','1','25,10','软皮甲','皮做的轻盔甲','store,user,armable,fixable','body','0','+def,11-21,+dur,250-300,-spd,10') ;
    
12. 
    
13. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('armor,11','11','1','75,5','鳞甲','鳞甲','store,user,armable,fixable','body','0','+def,30,+maxhp,5-20,-spd,1-5,+rebound,1-5,+restore,1-5,+dur,300-500') ;
    
14. 
    
15. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('armor,12','11','1','75,8','胸甲','胸甲','store,user,armable,fixable','body','0','+def,40,+maxhp,10-40,-spd,1-5,+rebound,6-10,+restore,5-10,+dur,300-500') ;
    
16. 
    
17. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('armor,13','11','1','75,10','环甲','环甲','store,user,armable,fixable','body','0','+def,60,+maxhp,20-50,+rebound,12,+restore,15-20,+dur,300-500') ;
    
18. 
    
19. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('armor,14','11','1','75,15','轻板甲','轻板甲','store,user,armable,fixable','body','0','+def,70,+maxhp,40-60,+maxsp,50-60,+spd,1-5,+rebound,6-12,+restore,20-30,+dur,300-500') ;
    
20. 
    
21. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('armor,15','11','1','75,20','哥特式盔甲','哥特式盔甲','store,user,armable,fixable','body','0','+def,50-70,+maxhp,70-90,+mag,1-6,+rebound,15-20,+restore,30-40,+dur,300-500') ;
    
22. 
    
23. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('armor,16','11','1','75,25','野战板甲','野战板甲','store,user,armable,fixable','body','0','+def,60-85,+maxhp,100,+mag,5-10,+rebound,10-22,+restore,40-50,+dur,300-500') ;
    
24. 
    
25. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('armor,17','11','1','75,30','全板甲','全板甲','store,user,armable,fixable','body','0','+def,70-100,+maxhp,40-110,+mag,11-15,+spd,5-10,+rebound,25-30,+restore,60-70,+dur,300-500') ;
    
26. 
    
27. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('armor,18','11','1','75,35','战神的战衣','传说中战神战斗时所穿的盔甲','store,user,armable,fixable','body','0','+def,80-150,+maxhp,70-120,+mag,5-20,+spd,5-10,+rebound,30-50,+restore,40-70,+dur,400-500') ;
    
28. 
    
29. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('armor,2','10','1','50,15','青铜铠甲','铜制的盔甲 肩膀上有突起部','store,user,armable,fixable','body','0','+def,23-42,+dur,250-300,-spd,10') ;
    
30. 
    
31. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('armor,3','20','1','120,50','轻型锁炼甲','链子般的轻量铁做的防具','store,user,armable,fixable','body','0','+def,38-63,+dur,250-300,-spd,10') ;
    
32. 
    
33. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('armor,4','30','1','45000,20000','钢铁铠甲','锻炼过的钢铁制盔甲','store,user,armable,fixable','body','0','+def,55-84,+dur,250-300,-spd,10') ;
    
34. 
    
35. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('armor,5','40','1','120000,50000','长型金属铠甲','很多长方形金属片叠起来做的盔甲','store,user,armable,fixable','body','0','+def,74-105,+dur,250-300,-spd,10') ;
    
36. 
    
37. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('armor,6','50','1','250000,120000','重铁板甲','板金叠起来做的盔甲','store,user,armable,fixable','body','0','+def,95-126,+dur,250-300,-spd,10') ;
    
38. 
    
39. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('armor,7','60','1','350000,150000','实战铠甲','重视实战的全身盔甲','store,user,armable,fixable','body','0','+def,110-147,+dur,250-300,-spd,10') ;
    
40. 
    
41. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('armor,8','70','1','450000,200000','重金属铠甲','全身用金属包起来的强固盔甲','store,user,armable,fixable','body','0','+def,126-179,+dur,250-300,-spd,10') ;
    
42. 
    
43. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('armor,9','80','1','550000,250000','帝王之铠','统一世界的人曾用过的盔甲','store,user,armable,fixable','body','0','+def,160-200,+dur,250-300,-spd,10') ;
    
44. 
    
45. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('axe,1','11','1','15000,500','双刃斧','双刃斧','store,user,armable,fixable','right','0','+atk,20-30,+spd,1-5,+dur,300-500') ;
    
46. 
    
47. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('axe,2','11','1','15000,100','巨斧','巨斧','store,user,armable,fixable','right','0','+atk,44-50,-spd,5,+dur,300-500') ;
    
48. 
    
49. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('axe,3','11','1','15000,150','巨人斧','巨人斧','store,user,armable,fixable','left','0','+atk,45-60,-spd,7,+dur,300-500') ;
    
50. 
    
51. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('axe,4','11','1','15000,150','战斧','战斧','store,user,armable,fixable','left','0','+atk,50-70,-spd,5-7,+dur,300-500') ;
    
52. 
    
53. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('axe,5','11','1','15000,200','战争斧','战争斧','store,user,armable,fixable','right','0','+atk,80-90,-spd,8-10,+dur,400-500') ;
    
54. 
    
55. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('boots,1','0','1','2000,1000','软皮靴','以柔软素材做的靴','store,user,armable,fixable','foot','0','+def,5-10,+dur,250-300') ;
    
56. 
    
57. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('boots,11','11','1','15000,50','链靴','链靴','store,user,armable,fixable','foot','0','+def,5-10,+maxhp,10-50,+spd,1-5,+dur,300-500') ;
    
58. 
    
59. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('boots,12','11','1','15000,100','轻甲靴','轻甲靴','store,user,armable,fixable','foot','0','+def,10-20,+maxhp,50-80,+spd,3-7,+dur,300-500') ;
    
60. 
    
61. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('boots,13','11','1','15000,200','重型靴','重型靴','store,user,armable,fixable','foot','0','+def,20-30,+maxhp,60-120,+spd,7-10,+dur,300-500') ;
    
62. 
    
63. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('boots,14','11','1','15000,300','战神的钢甲靴','传说中战神战斗时所穿的钢甲靴','store,user,armable,fixable','foot','0','+def,70-90,+maxhp,50-180,+spd,10-15,+dur,400-500') ;
    
64. 
    
65. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('boots,2','10','1','4000,2000','硬皮靴','用硬又结实的皮做的靴','store,user,armable,fixable','foot','0','+def,10-19,+dur,250-300') ;
    
66. 
    
67. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('boots,3','20','1','9000,4000','厚底靴','靴底厚又保暖','store,user,armable,fixable','foot','0','+def,17-29,+dur,250-300') ;
    
68. 
    
69. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('boots,4','30','1','15000,6000','锁炼长靴','绑金属网，加强的长统靴','store,user,armable,fixable','foot','0','+def,25-38,+dur,250-300') ;
    
70. 
    
71. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('boots,5','40','1','24000,10000','蜥蝪靴','鲮形金属片叠起来做的靴','store,user,armable,fixable','foot','0','+def,34-48,+dur,250-300') ;
    
72. 
    
73. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('boots,6','50','1','60000,25000','钢靴','钢铁制靴','store,user,armable,fixable','foot','0','+def,43-57,+dur,250-300') ;
    
74. 
    
75. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('boots,7','60','1','90000,40000','水晶靴','以水晶做的靴','store,user,armable,fixable','foot','0','+def,54-72,+dur,250-300') ;
    
76. 
    
77. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('boots,8','70','1','120000,50000','流水之靴','受火之力量保护的靴','store,user,armable,fixable','foot','0','+def,61-81,+dur,250-300') ;
    
78. 
    
79. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('boots,9','80','1','160000,70000','钻石靴','钻石做的，非常强固的靴','store,user,armable,fixable','foot','0','+def,78-91,+dur,250-300') ;
    
80. 
    
81. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('cook,1','0','999','200,90','面包','魔力值复约100点','store,user,useable','','0','+sp,100') ;
    
82. 
    
83. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('cook,2','0','999','400,180','法国面包','魔力值复约200点','store,user,useable','','0','+sp,200') ;
    
84. 
    
85. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('cook,3','0','999','750,100','炒豆角','恢复魔力约400点','store,user,useable','','0','+sp,400') ;
    
86. 
    
87. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('cook,4','0','999','900,100','三鲜伊面','恢复魔力约600点','store,user,useable','','0','+sp,600') ;
    
88. 
    
89. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('exp,1','0','999','120,50','木瓜叶','增加少量 Exp 约 100 点','store,user,useable','','0','+exp,100') ;
    
90. 
    
91. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('exp,2','10','999','600,250','木瓜橘子','增加少量 Exp 约 500 点','store,user,useable','','0','+exp,500') ;
    
92. 
    
93. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('exp,3','20','999','1200,500','木瓜苹果','增加少量 Exp 约 1000 点','store,user,useable','','0','+exp,1000') ;
    
94. 
    
95. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('exp,4','30','999','6500,3000','木瓜葡萄','增加少量 Exp 约 5000 点','store,user,useable','','0','+exp,5000') ;
    
96. 
    
97. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('gem,1','1','999','10,2','水客坊的力量','来自水客坊的神秘宝石','store,user,useable','','0','+atk,1-2') ;
    
98. 
    
99. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('gem,10','1','999','30,10','结晶的鲜血的召唤','来自水客坊的神秘能量宝石','store,user,useable','','0','+blood,2-5') ;
    
100. 
     
101. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('gem,11','1','999','30,10','结晶的魔法的力量','来自水客坊的神秘能量宝石','store,user,useable','','0','+magatk,2-5') ;
     
102. 
     
103. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('gem,12','1','999','30,10','结晶的生命的复苏','来自水客坊的神秘能量宝石','store,user,useable','','0','+restore,2-5') ;
     
104. 
     
105. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('gem,13','1','999','40,15','速度的源泉','来自水客坊的神秘能量宝石','store,user,useable','','0','+spd,1-5') ;
     
106. 
     
107. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('gem,14','1','999','40,15','魔法的技能','来自水客坊的神秘能量宝石','store,user,useable','','0','+mag,1-5') ;
     
108. 
     
109. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('gem,15','1','999','80,20','天神的力量','来自水客坊的神秘能量宝石','store,user,useable','','0','+atk,3,+def,3,+maxhp,3,+maxsp,3,+rebound,3,+blood,3,+magatk,3,+restore,3,+spd,1-3,+mag,1-3') ;
     
110. 
     
111. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('gem,2','1','999','10,2','水客坊的坚强','来自水客坊的神秘宝石','store,user,useable','','0','+def,1-2') ;
     
112. 
     
113. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('gem,3','1','999','10,2','水客坊的血液','来自水客坊的神秘宝石','store,user,useable','','0','+maxhp,1-2') ;
     
114. 
     
115. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('gem,4','1','999','10,2','水客坊的魔力','来自水客坊的神秘宝石','store,user,useable','','0','+maxsp,1-2') ;
     
116. 
     
117. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('gem,5','1','999','20,5','利刃的护持','来自水客坊的神秘能量球','store,user,useable','','0','+rebound,1-2') ;
     
118. 
     
119. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('gem,6','1','999','20,5','鲜血的召唤','来自水客坊的神秘能量球','store,user,useable','','0','+blood,1-2') ;
     
120. 
     
121. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('gem,7','1','999','20,5','魔法的力量','来自水客坊的神秘能量球','store,user,useable','','0','+magatk,1-2') ;
     
122. 
     
123. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('gem,8','1','999','20,5','生命的复苏','来自水客坊的神秘能量球','store,user,useable','','0','+restore,1-2') ;
     
124. 
     
125. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('gem,9','1','999','30,10','结晶的利刃的护持','来自水客坊的神秘能量宝石','store,user,useable','','0','+rebound,2-5') ;
     
126. 
     
127. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('helmet,1','0','1','2500,1000','硬皮头盔','硬皮做的头盔','store,user,armable,fixable','head','0','+def,6-11,+dur,250-300') ;
     
128. 
     
129. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('helmet,11','30','1','60000,25000','阿修罗的头盔','具有魔法效果的古老头盔','store,user,armable,fixable','head','0','+magatk,5-20,+dur,300-500') ;
     
130. 
     
131. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('helmet,12','11','1','15000,50','黑暗使者的头盔','来历不明的头盔','store,user,armable,fixable','head','0','+def,10-30,+maxhp,50,+dur,300-500') ;
     
132. 
     
133. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('helmet,13','11','1','15000,80','魔法的面具','具有魔法力量的面具','store,user,armable,fixable','head','0','+def,20-70,+maxsp,30-60,+dur,300-500') ;
     
134. 
     
135. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('helmet,14','11','1','15000,100','神圣的皇冠','神圣的皇冠','store,user,armable,fixable','head','0','+def,30-80,+maxsp,40-70,+dur,300-500') ;
     
136. 
     
137. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('helmet,15','11','1','15000,150','战神的头盔','传说中战神战斗时所使用的头盔','store,user,armable,fixable','head','0','+def,60-100,+maxhp,50-100,+magatk,10-50,+dur,400-500') ;
     
138. 
     
139. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('helmet,2','10','1','4500,2000','铁板布盔','铁板做，用布包起来的帽子型头盔','store,user,armable,fixable','head','0','+def,12-22,+dur,250-300') ;
     
140. 
     
141. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('helmet,3','20','1','8500,4000','金属护额','放铁板在额头上的头巾','store,user,armable,fixable','head','0','+def,20-33,+dur,250-300') ;
     
142. 
     
143. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('helmet,4','30','1','18500,8000','霸葛头盔','有帽缘与额头铁板的头盔','store,user,armable,fixable','head','0','+def,29-44,+dur,250-300') ;
     
144. 
     
145. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('helmet,5','40','1','28500,17000','葛理克头盔','保护脸部的头盔','store,user,armable,fixable','head','0','+def,39-55,+dur,250-300') ;
     
146. 
     
147. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('helmet,6','50','1','45500,20000','巴比克头盔','边边很宽的头盔','store,user,armable,fixable','head','0','+def,50-66,+dur,250-300') ;
     
148. 
     
149. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('helmet,7','60','1','85500,40000','骑士头盔','骑士用的头盔','store,user,armable,fixable','head','0','+def,62-83,+dur,250-300') ;
     
150. 
     
151. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('helmet,8','70','1','135500,60000','博流盖尔头盔','有羽毛装饰的铁制的头盔','store,user,armable,fixable','head','0','+def,71-94,+dur,250-300') ;
     
152. 
     
153. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('helmet,9','80','1','185500,70000','龙盔','古代勇者所戴的头盔','store,user,armable,fixable','head','0','+def,84-105,+dur,250-300') ;
     
154. 
     
155. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('mine,1','1','999','10,2','铁块','水客坊出产的铁块','store,user,useable','','0','+durmax,1') ;
     
156. 
     
157. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('mine,2','1','999','12,4','铜块','水客坊出产的铜块','store,user,useable','','0','+durmax,1-3') ;
     
158. 
     
159. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('mine,3','1','999','15,6','银块','水客坊出产的银块','store,user,useable','','0','+durmax,2-5') ;
     
160. 
     
161. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('mine,4','1','999','17,8','金块','水客坊出产的金块','store,user,useable','','0','+durmax,6-10') ;
     
162. 
     
163. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('mine,5','1','999','20,9','水客坊的陨石','在水客坊发现的天外飞石','store,user,useable','','0','+durmax,11-15') ;
     
164. 
     
165. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('necklace,1','0','1','1000,200','葛修','利用地狱看门犬的爪子做成的首饰','store,user,armable,fixable','leftear','0','+spd,4,-maxhp,10,+dur,100-150') ;
     
166. 
     
167. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('necklace,13','18','1','50000,20000','受祝福的耳环','一定几率恢复生命','store,user,armable,fixable','leftear','0','+restore,5-20,+dur,300-500') ;
     
168. 
     
169. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('necklace,2','0','1','3000,1000','斩牙','利用巨狼的牙作成的首饰','store,user,armable,fixable','leftear','0','+spd,10,-atk,8,+dur,100-150') ;
     
170. 
     
171. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('necklace,28','11','1','15000,50','生命的护身符','提高生命上限','store,user,armable,fixable','rightear','0','+maxhp,50-100,+dur,300-500') ;
     
172. 
     
173. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('necklace,29','11','1','15000,50','精力的护身符','提高魔法值上限','store,user,armable,fixable','rightear','0','+maxsp,50-100,+dur,300-500') ;
     
174. 
     
175. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('necklace,3','0','1','10000,5000','傲慢的腕轮','以原罪作为主题所制造的骷髅手环第一系列','store,user,armable,fixable','rightear','0','+atk,30,-maxhp,100,-spd,10,+dur,100-150') ;
     
176. 
     
177. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('necklace,30','11','1','15000,50','魔法力量的指环','使攻击带有魔法效果','store,user,armable,fixable','leftear','0','+magatk,5-20,+dur,300-500') ;
     
178. 
     
179. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('necklace,31','11','1','15000,50','偷生命的指环','攻击时吸取对方生命','store,user,armable,fixable','leftear','0','+blood,5-20,+dur,300-500') ;
     
180. 
     
181. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('necklace,8','0','1','10000,5000','克罗丝比','听说把这个戴在身上，自己的影子便会有自我意识','store,user,armable,fixable','rightear','0','+spd,30,-def,20,+dur,100-150') ;
     
182. 
     
183. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('potion,1','0','999','100,40','生命力回复药(100)','生命值回复约100点','store,user,useable','','0','+hp,100') ;
     
184. 
     
185. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('potion,2','0','999','200,80','生命力回复药(200)','生命值回复约200点','store,user,useable','','0','+hp,200') ;
     
186. 
     
187. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('potion,3','0','999','400,90','生命力回复药(400)','生命值回复约400点','store,user,useable','','0','+hp,400') ;
     
188. 
     
189. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('potion,4','0','999','700,90','生命力回复药(700)','生命值回复约700点','store,user,useable','','0','+hp,700') ;
     
190. 
     
191. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('shield,1','0','1','2500,1000','小圆盾','直接受到敌人攻击的轻量又小的盾牌','store,user,armable,fixable','left','0','+def,6-11,+dur,250-300,-spd,5') ;
     
192. 
     
193. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('shield,11','25','1','70000,30000','尖刺盾牌','会刺伤对手的神秘盾牌','store,user,armable,fixable','left','0','+def,12-22,-spd,3-5,+rebound,5-10,+dur,300-500') ;
     
194. 
     
195. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('shield,12','11','1','15000,50','小圆盾','小圆盾','store,user,armable,fixable','left','0','+def,20-30,-spd,3-4,+rebound,3-7,+dur,300-500') ;
     
196. 
     
197. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('shield,13','11','1','15000,80','黄金小圆盾','黄金小圆盾','store,user,armable,fixable','left','0','+def,30-40,-spd,1-2,+rebound,5-10,+dur,300-500') ;
     
198. 
     
199. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('shield,14','11','1','15000,100','死亡的盾牌','骷髅做成的盾牌','store,user,armable,fixable','left','0','+def,40-60,+rebound,10-20,+dur,300-500') ;
     
200. 
     
201. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('shield,15','11','1','15000,120','神圣的盾牌','神圣的盾牌','store,user,armable,fixable','left','0','+def,60-100,+rebound,20-30,+dur,300-500') ;
     
202. 
     
203. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('shield,16','11','1','15000,150','战神的盾牌','传说中战神战斗时所使用的盾牌','store,user,armable,fixable','left','0','+def,100-120,+restore,10-100,+rebound,40-50,+dur,400-500') ;
     
204. 
     
205. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('shield,2','10','1','4500,2000','板盾','张薄的木板合在一起的大型盾牌','store,user,armable,fixable','left','0','+def,12-22,+dur,250-300,-spd,5') ;
     
206. 
     
207. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('shield,3','20','1','9500,4000','漩涡重盾','有螺旋状花样的圆形大盾牌','store,user,armable,fixable','left','0','+def,20-33,+dur,250-300,-spd,5') ;
     
208. 
     
209. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('shield,4','30','1','15000,7000','士兵盾','装甲兵用的很素但性能高的盾牌','store,user,armable,fixable','left','0','+def,29-44,+dur,250-300,-spd,5') ;
     
210. 
     
211. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('shield,5','40','1','25000,10000','蜥蝪盾','鳞形金属叠起来做的盾牌','store,user,armable,fixable','left','0','+def,39-55,+dur,250-300,-spd,5') ;
     
212. 
     
213. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('shield,6','50','1','40000,18000','风之盾','有羽毛花样的盾牌，很轻，很好用','store,user,armable,fixable','left','0','+def,50-60,+dur,250-300,-spd,5') ;
     
214. 
     
215. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('shield,7','60','1','70000,30000','防守之盾','白银做的盾牌','store,user,armable,fixable','left','0','+def,58-77,+dur,250-300,-spd,5') ;
     
216. 
     
217. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('shield,8','70','1','110000,50000','力量之盾','由强烈魔力所保护的盾牌','store,user,armable,fixable','left','0','+def,66-88,+dur,250-300,-spd,5') ;
     
218. 
     
219. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('shield,9','80','1','210000,100000','火龙之盾','用火龙的皮做的很强之盾牌','store,user,armable,fixable','left','0','+def,84-105,+dur,250-300,-spd,5') ;
     
220. 
     
221. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('stave,1','11','1','15000,300','骨杖','骨杖','store,user,armable,fixable','right','0','+atk,1-7,+mag,5-10,+maxsp,40-50,+dur,300-500') ;
     
222. 
     
223. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('stave,2','11','1','15000,400','紫杉木权杖','紫杉木权杖','store,user,armable,fixable','right','0','+atk,1-7,+mag,11-15,+maxsp,51-100,+dur,300-500') ;
     
224. 
     
225. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('stave,3','11','1','15000,500','骷髅权杖','骷髅权杖','store,user,armable,fixable','right','0','+atk,1-8,+mag,16-20,+maxsp,100-150,+dur,300-500') ;
     
226. 
     
227. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('stave,4','11','1','15000,600','王者权杖','王者权杖','store,user,armable,fixable','right','0','+atk,1-9,+mag,21-25,+maxsp,150-200,+dur,400-500') ;
     
228. 
     
229. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('sword,1','0','1','3000,1200','长剑','坚固的巨大宽剑','store,user,armable,fixable','right','0','+atk,12-24,+dur,250-300') ;
     
230. 
     
231. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('sword,11','11','1','15000,5000','左手巨剑','倚天神剑左手版','store,user,armable,fixable','left','0','+atk,24-44,+magatk,1-5,-spd,5-7,+dur,300-500') ;
     
232. 
     
233. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('sword,12','15','1','17000,8000','嗜血的剑','传说中嗜血的剑,据说魔法高强者才能成为它真正的主人','store,user,armable,fixable','right','0','+atk,20-48,-spd,1-5,+blood,5-15,+dur,200-300') ;
     
234. 
     
235. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('sword,13','11','1','15000,100','血色水晶剑','可以吸取对方生命的神秘宝剑','store,user,armable,fixable','right','0','+atk,20-24,+blood,5-10,+dur,300-500') ;
     
236. 
     
237. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('sword,14','11','1','15000,100','双刃巨剑','双刃巨剑','store,user,armable,fixable','right','0','+atk,20-30,+def,1-5,+magatk,5-10,+dur,300-500') ;
     
238. 
     
239. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('sword,15','11','1','15000,100','马刀','马刀','store,user,armable,fixable','right','0','+atk,20-24,+spd,1-5,+magatk,10-15,+dur,300-500') ;
     
240. 
     
241. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('sword,16','11','1','15000,200','短刀','短刀','store,user,armable,fixable','right','0','+atk,14-30,+spd,5-15,+magatk,5,+dur,300-500') ;
     
242. 
     
243. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('sword,17','11','1','15000,300','波状刃短剑','波状刃短剑','store,user,armable,fixable','right','0','+atk,35-70,+maxhp,80-100,+dur,300-500') ;
     
244. 
     
245. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('sword,18','11','1','15000,500','幻影魔法剑','由水客坊管理员特别打造','store,user,armable,fixable','right','0','+atk,24-70,+mag,10-20,+magatk,20-30,+dur,400-500') ;
     
246. 
     
247. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('sword,2','10','1','7000,3000','突刺剑','十分细长的细剑','store,user,armable,fixable','right','0','+atk,26-48,+dur,250-300') ;
     
248. 
     
249. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('sword,3','20','1','17000,8000','面包剑','长柄的剑，不但很重也很坚固','store,user,armable,fixable','right','0','+atk,43-72,+dur,250-300') ;
     
250. 
     
251. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('sword,4','30','1','35000,15000','双刃长剑','细长ˋ剑身宽、而且又锐利的两刃剑','store,user,armable,fixable','right','0','+atk,62-93,+dur,250-300') ;
     
252. 
     
253. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('sword,5','40','1','69000,30000','格斗剑','适用于对战的改良宽剑','store,user,armable,fixable','right','0','+atk,84-120,+dur,250-300') ;
     
254. 
     
255. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('sword,6','50','1','100000,45000','猪牙剑','剑身像猪牙的细剑','store,user,armable,fixable','right','0','+atk,108-144,+dur,250-300') ;
     
256. 
     
257. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('sword,7','60','1','190000,90000','巨剑','单手可斩击，双手可突击的战斗实用剑','store,user,armable,fixable','right','0','+atk,125-170,+dur,250-300') ;
     
258. 
     
259. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('sword,8','70','1','290000,120000','护身短剑','装饰过度的防身用短剑','store,user,armable,fixable','right','0','+atk,153-204,+dur,250-300') ;
     
260. 
     
261. Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('sword,9','80','1','420000,180000','细刃重剑','剑身很细，剑柄却又重又长的两手剑','store,user,armable,fixable','right','0','+atk,182-228,+dur,250-300') ;
     
262. 
     

复制代码

打怪拾到之宝物如有重复时
它们都独立分开显示
须然可以透过使用[物品整理]
但只有部分物品能合并为一体
有些整理后却不能
这方面有方法修正吗

[ 本帖最后由 AE110 于 2006-1-10 18:49 编辑 ]

你们都是怎么修改物品价格的呀

状态 离线  你们都是怎么修改物品价格的呀

2.5時用童虎版寵物

現在用4.0

想問一下舊有童虎版寵物可不可保留?

原帖由 PHP论坛 于 2006-1-10 15:45 发表
楼主。问一下。怎么修改物品价格啊，太贵了。会员买不起啊
我在管理中心哪里只能改几个东西。下面的就都改不了了。不是要我去
PHPMYADMIN修改吧。晕。
[code]
数据位于 cdb_mypetitemdata
插入数据所用SQL语 ...

下面那些都是会员不购买的东西来的呀~~必须要打怪才能得到的东西~~价钱多少有什么关系~~~

商店里的东西~~后台都可以改的。。。。

原帖由 AE110 于 2006-1-10 15:56 发表
打怪拾到之宝物如有重复时
它们都独立分开显示
这样的处理方式好像太不方便
能否将之修改为相同物品只显示一张图而总数目则自行加上
这样对太多物品买卖时也比较方便

lj大哥你要好好看一下这个问题 这个问题我在你论坛反映过的 你没理会我喔.