水客版宠物 FOR D4[正式版已出,见1楼说明]

宠物存进银行后,希望能完善啊.还有想了解下怎样才能自定义加入宠物

Discuz! info: MySQL Query Error

User: admin
Time: 2006-1-5 1:21pm
Script: /bbs/pet.php

SQL: UPDATE cdb_mypetdata SET extcredits7=extcredits7-100 WHERE username='admin'
Error: Unknown column 'extcredits7' in 'field list'
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖

Similar error report has beed dispatched to administrator before.

[ 本帖最后由 szqyn 于 2006-1-5 13:25 编辑 ]

itemtomarket.php  itemmarket.php 里面还有MONEY
另外一个文件里面也有,记不清是哪个了

[ 本帖最后由 oldsword 于 2006-1-5 13:34 编辑 ]

原帖由 szqyn 于 2006-1-5 13:24 发表
宠物存进银行后,希望能完善啊.还有想了解下怎样才能自定义加入宠物

修改:petstore.php
查找
        $query = $db->query("UPDATE $tablepre"."mypetdata SET extcredits7=extcredits7-100 WHERE username='$discuz_user'");       


改成
        $query = $db->query("UPDATE $tablepre"."members SET extcredits7=extcredits7-100 WHERE username='$discuz_user'");

[ 本帖最后由 oldsword 于 2006-1-5 13:42 编辑 ]

谢谢楼上,能不能完善下自定义加入宠物

模版pet_navbar.htm
查查找
<!--{if $adminid <> 1 }-->
改成
<!--{if $adminid == 1 }-->

里面就有添加宠物,不过有问题,啥也不输就能添加

原帖由 oldsword 于 2006-1-5 14:01 发表
模版pet_navbar.htm
查查找
<!--{if $adminid <> 1 }-->
改成
<!--{if $adminid == 1 }-->

里面就有添加宠物,不过有问题,啥也不输就能添加

支持..希望能你来完善下

晚上如果没事的话,再整理一下,发这几天的修订版

原帖由 lj80117 于 2006-1-5 14:59 发表
晚上如果没事的话,再整理一下,发这几天的修订版

支持你,顶到完美为止

Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('alife,2','0','999','700,200','复活之羽2级','让死掉的宠物复活,并回复少量hp和sp','store,user,useable','','0','+dead,1,+hp,300,+sp,100') ;
Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('alife,3','0','999','900,200','复活之羽3级','让死掉的宠物复活,并回复大量hp和少量sp','store,user,useable','','0','+dead,1,+hp,500,+sp,200') ;

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') ;
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') ;

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') ;
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') ;


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');
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');
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');
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');

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') ;
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') ;
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') ;
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') ;

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') ;
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') ;
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') ;
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') ;

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') ;
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') ;

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') ;

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') ;
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') ;
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') ;
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') ;
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') ;



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') ;
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') ;
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') ;
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') ;
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') ;
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') ;
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') ;
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') ;


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') ;
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') ;
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') ;
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') ;
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') ;

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') ;
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') ;
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') ;
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') ;

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') ;
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') ;
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') ;
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') ;

Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('armor,11','11','1','15000,50','鳞甲','鳞甲','store,user,armable,fixable','body','0','+def,30,+maxhp,5-20,-spd,1-5,+rebound,1-5,+restore,1-5,+dur,300-500') ;
Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('armor,12','11','1','15000,80','胸甲','胸甲','store,user,armable,fixable','body','0','+def,40,+maxhp,10-40,-spd,1-5,+rebound,6-10,+restore,5-10,+dur,300-500') ;
Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('armor,13','11','1','15000,100','环甲','环甲','store,user,armable,fixable','body','0','+def,60,+maxhp,20-50,+rebound,12,+restore,15-20,+dur,300-500') ;
Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('armor,14','11','1','15000,150','轻板甲','轻板甲','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') ;
Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('armor,15','11','1','15000,200','哥特式盔甲','哥特式盔甲','store,user,armable,fixable','body','0','+def,50-70,+maxhp,70-90,+mag,1-6,+rebound,15-20,+restore,30-40,+dur,300-500') ;
Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('armor,16','11','1','15000,250','野战板甲','野战板甲','store,user,armable,fixable','body','0','+def,60-85,+maxhp,100,+mag,5-10,+rebound,10-22,+restore,40-50,+dur,300-500') ;
Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('armor,17','11','1','15000,300','全板甲','全板甲','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') ;
Insert into cdb_mypetitemdata(itemtype,itemlevel,itemmaxnum,itemcost,itemname,itemtext,trade,armposition,createtime,itemplus) values('armor,18','11','1','15000,350','战神的战衣','传说中战神战斗时所穿的盔甲','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') ;

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') ;
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') ;
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') ;
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') ;
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') ;
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') ;

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') ;
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') ;
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') ;
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') ;
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') ;

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') ;
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') ;
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') ;
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') ;
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') ;

Discuz! info: MySQL Query Error

User: 头发酷乱
Time: 2006-1-5 7:25pm
Script: /pet.php

SQL: INSERT INTO (msgfrom, msgfromid,msgtoid, folder, new, subject, dateline, message)
VALUES('头发酷乱','422','2160', 'inbox', '1', '你的宝宝被 PK 结果', '1136460334', '自不量力的宠物主动PK你的宠物，结果被杀死。对方愚蠢的主人是头发酷乱。')
Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(msgfrom, msgfromid,msgtoid, folder, new, subject, dateline, me
Errno.: 1064

An error report has been dispatched to our administrator

为什么和别人宠物PK结束显示是这样？ 我想问问大家遇到这样的情况没？