在楼主尚未完善后台前,这些SQL语句都很有用的哦~~
1. 琵琶行宠物数据库备份
步骤一: 先后台升级数据表,批量把表pet_改为cdb_pet_
RENAME TABLE `discuz`.`pet_bankrecord` TO `discuz`.`cdb_pet_bankrecord` ;
RENAME TABLE `discuz`.`pet_giverecord` TO `discuz`.`cdb_pet_giverecord` ;
RENAME TABLE `discuz`.`pet_item` TO `discuz`.`cdb_pet_item` ;
RENAME TABLE `discuz`.`pet_itemadd` TO `discuz`.`cdb_pet_itemadd` ;
RENAME TABLE `discuz`.`pet_itembuy` TO `discuz`.`cdb_pet_itembuy` ;
RENAME TABLE `discuz`.`pet_itemmarket` TO `discuz`.`cdb_pet_itemmarket` ;
RENAME TABLE `discuz`.`pet_itemtype` TO `discuz`.`cdb_pet_itemtype` ;
RENAME TABLE `discuz`.`pet_itemwear` TO `discuz`.`cdb_pet_itemwear` ;
RENAME TABLE `discuz`.`pet_magic` TO `discuz`.`cdb_pet_magic` ;
RENAME TABLE `discuz`.`pet_map` TO `discuz`.`cdb_pet_map` ;
RENAME TABLE `discuz`.`pet_mypetatk` TO `discuz`.`cdb_pet_mypetatk` ;
RENAME TABLE `discuz`.`pet_mypetdata` TO `discuz`.`cdb_pet_mypetdata` ;
RENAME TABLE `discuz`.`pet_npcdata` TO `discuz`.`cdb_pet_npcdata` ;
RENAME TABLE `discuz`.`pet_petconfig` TO `discuz`.`cdb_pet_petconfig` ;
RENAME TABLE `discuz`.`pet_petjobdata` TO `discuz`.`cdb_pet_petjobdata` ;
RENAME TABLE `discuz`.`pet_petshopdata` TO `discuz`.`cdb_pet_petshopdata` ;
RENAME TABLE `discuz`.`pet_storage` TO `discuz`.`cdb_pet_storage` ;
RENAME TABLE `discuz`.`pet_teammate` TO `discuz`.`cdb_pet_teammate` ;
步骤二: 然后然后到后台系统工具→资料备份 在类型里点自定义备份,Ctrl+F查找cdb_pet_的所有表扣上,再其它操作然后提交.
步骤三: 备份完后,再把琵琶行宠物数据表cdb_pet_改回原来pet_ ,后台升级数据库执行..
RENAME TABLE `discuz`.`cdb_pet_bankrecord` TO `discuz`.`pet_bankrecord` ;
RENAME TABLE `discuz`.`cdb_pet_giverecord` TO `discuz`.`pet_giverecord` ;
RENAME TABLE `discuz`.`cdb_pet_item` TO `discuz`.`pet_item` ;
RENAME TABLE `discuz`.`cdb_pet_itemadd` TO `discuz`.`pet_itemadd` ;
RENAME TABLE `discuz`.`cdb_pet_itembuy` TO `discuz`.`pet_itembuy` ;
RENAME TABLE `discuz`.`cdb_pet_itemmarket` TO `discuz`.`pet_itemmarket` ;
RENAME TABLE `discuz`.`cdb_pet_itemtype` TO `discuz`.`pet_itemtype` ;
RENAME TABLE `discuz`.`cdb_pet_itemwear` TO `discuz`.`pet_itemwear` ;
RENAME TABLE `discuz`.`cdb_pet_magic` TO `discuz`.`pet_magic` ;
RENAME TABLE `discuz`.`cdb_pet_map` TO `discuz`.`pet_map` ;
RENAME TABLE `discuz`.`cdb_pet_mypetatk` TO `discuz`.`pet_mypetatk` ;
RENAME TABLE `discuz`.`cdb_pet_mypetdata` TO `discuz`.`pet_mypetdata` ;
RENAME TABLE `discuz`.`cdb_pet_npcdata` TO `discuz`.`pet_npcdata` ;
RENAME TABLE `discuz`.`cdb_pet_petconfig` TO `discuz`.`pet_petconfig` ;
RENAME TABLE `discuz`.`cdb_pet_petjobdata` TO `discuz`.`pet_petjobdata` ;
RENAME TABLE `discuz`.`cdb_pet_petshopdata` TO `discuz`.`pet_petshopdata` ;
RENAME TABLE `discuz`.`cdb_pet_storage` TO `discuz`.`pet_storage` ;
RENAME TABLE `discuz`.`cdb_pet_teammate` TO `discuz`.`pet_teammate` ;
2. 给会员添加装备
INSERT INTO `pet_storage` ( `id` , `username` , `itemname` , `nums` )
VALUES
('1', '无心', 'yxtk', '1'),
('2', '无心', 'k2book', '1');
('1', '无心', 'hbook', '1'), 指 ('其装备在数据表的ID(执行前请先到phpMyAdmin查询一下pet_storage表最后ID是多少,这里就填下一个数)', '会员用户名', '其装备号(不懂的就打开升级文件pet_install.php查询,如我这里填的yxtk,就是装备英雄头盔)', '数量'),
注意,如果你是批量添加的,除最后一项用;外,其它都用,
3. 二手市场增加物品
INSERT INTO `pet_itemmarket` ( `id` , `itemname` , `itemnum` , `itemmoney` , `itemuser` , `itemtime` )
VALUES
('1','lets1','22','5000','无心','1168597710'),
('2','defitem2','3','5000','无心','1169041208');
[ 本帖最后由 羽翼时空 于 2007-1-24 16:59 编辑 ] |
|