我兄弟杀手收集的SQL命令要看就回个帖|老数据合并综合服务端发布区 - 梦想仙境中文官方社区论坛

离线angerne

新手上路

发帖: 78

祝福宝石: -1

威望: -1

玛雅之石: 0

创造宝石: 0

只看楼主倒序阅读使用道具楼主发表于: 2006-07-16

Update item_Rare SET [Max] = [Max]*10 修改所有属性上限的一句话

[post] 下面是100级以上战绩组队，理论上可以混到298级，
我是以不打乱数据库里面数据为准哲，倒回去就可以回到你原来的设置。
这样的设置方法是最理想的。
下面是100级以上战绩组队的执行语句
Update NPC_Lv2Exp SET max_tactic = max_tactic*3
Update NPC_Lv2Exp_old SET max_tactic = max_tactic*3
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

update BasicItemBage set
BasicItemPercentTableNo = BasicItemPercentTableNo*3

update RareItemBab set
RareItemPercentTableNo = RareItemPercentTableNo*4

FALL表凋落*2
update ItemFallPercent set
per1 = per1 *2 ,
per2 = per2 *2 ,
per3 = per3 *2 ,
per4 = per4 *2 ,
per5 = per5 *2 ,
per6 = per6 *2 ,
per7 = per7 *2 ,
per8 = per8 *2 ,
per9 = per9 *2 ,
per10 = per10 *2 ,
per11 = per11 *2 ,
per12 = per12 *2 ,
per13 = per13 *2 ,
per14 = per14 *2 ,
per15 = per15 *2 ,
per16 = per16 *2 ,
per17 = per17 *2 ,
per18 = per18 *2 ,
per19 = per19 *2 ,
per20 = per20 *2

这是查你想知道的ID里所拥有的角色名
select [name] from chr_info
where login_id = 'ID号'

设置每30秒定时发公告内容为XXX
update event_message set
[time] = 30
message = 'XXX'

Update Chr_Info

SET tac_skillEXP = 0x219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D
Where (name = 'XXX')
战绩到顶

Update NPC_Generation_SP SET NpcExp = NpcExp*10
战绩到顶
SET tac_skillEXP = 0x219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D
Where (name = 'CHARNAME')

工作经验150
Update skill_lvexp SET F2 = F2*50
Update skill_lvexp SET F3 = F3*50
Update skill_lvexp SET F4 = F4*50
Update skill_lvexp SET F5 = F5*50
Update skill_lvexp SET F6 = F6*50
Update skill_lvexp SET F7 = F7*50
Update skill_lvexp SET F8 = F8*50
Update skill_lvexp SET F9 = F9*50
Update skill_lvexp SET F10 = F10*50
Update skill_lvexp SET F11 = F11*50
Update skill_lvexp SET F12 = F12*50
Update skill_lvexp SET F13 = F13*50
Update skill_lvexp SET F14 = F14*50
Update skill_lvexp SET F15 = F15*50
Update skill_lvexp SET F16 = F16*50
Update skill_lvexp SET F17 = F17*50
Update skill_lvexp SET F18 = F18*50
Update skill_lvexp SET F19 = F19*50
Update skill_lvexp SET F20 = F20*50
Update skill_lvexp SET F21 = F21*50
Update skill_lvexp SET F22 = F22*50
Update skill_lvexp SET F23 = F23*50
Update skill_lvexp SET F24 = F24*50
Update skill_lvexp SET F25 = F25*50
Update skill_lvexp SET F26 = F26*50
Update skill_lvexp SET F27 = F27*50
Update skill_lvexp SET F28 = F28*50
Update skill_lvexp SET F29 = F29*50
Update skill_lvexp SET F30 = F30*50
Update skill_lvexp SET F31 = F31*50
Update skill_lvexp SET F32 = F32*50
Update skill_lvexp SET F33 = F33*50
Update skill_lvexp SET F34 = F34*50
Update skill_lvexp SET F35 = F35*50
Update skill_lvexp SET F36 = F36*50
Update skill_lvexp SET F37 = F37*50
Update skill_lvexp SET F38 = F38*50
Update skill_lvexp SET F39 = F39*50
Update skill_lvexp SET F40 = F40*50
Update skill_lvexp SET F41 = F41*50
Update skill_lvexp SET F42 = F42*50
Update skill_lvexp SET F43 = F43*50
Update skill_lvexp SET F44 = F44*50
Update skill_lvexp SET F45 = F45*50
Update skill_lvexp SET F46 = F46*50
Update skill_lvexp SET F47 = F47*50
Update skill_lvexp SET F48 = F48*50
Update skill_lvexp SET F49 = F49*50
Update skill_lvexp SET F50 = F50*50
Update skill_lvexp SET F51 = F51*50
Update skill_lvexp SET F52 = F52*50
Update skill_lvexp SET F53 = F53*50
Update skill_lvexp SET F54 = F54*50
Update skill_lvexp SET F55 = F55*50
Update skill_lvexp SET F56 = F56*50
Update skill_lvexp SET F57 = F57*50
Update skill_lvexp SET F58 = F58*50
Update skill_lvexp SET F59 = F59*50
Update skill_lvexp SET F60 = F60*50
Update skill_lvexp SET F61 = F61*50
Update skill_lvexp SET F62 = F62*50
Update skill_lvexp SET F63 = F63*50
Update skill_lvexp SET F64 = F64*50
Update skill_lvexp SET F65 = F65*50
Update skill_lvexp SET F66 = F66*50
Update skill_lvexp SET F67 = F67*50
Update skill_lvexp SET F68 = F68*50
Update skill_lvexp SET F69 = F69*50
Update skill_lvexp SET F70 = F70*50
Update skill_lvexp SET F71 = F71*50
Update skill_lvexp SET F72 = F72*50
Update skill_lvexp SET F73 = F73*50
Update skill_lvexp SET F74 = F74*50
Update skill_lvexp SET F75 = F75*50
Update skill_lvexp SET F76 = F76*50
Update skill_lvexp SET F77 = F77*50
Update skill_lvexp SET F78 = F78*50
Update skill_lvexp SET F79 = F79*50
Update skill_lvexp SET F80 = F80*50
Update skill_lvexp SET F81 = F81*50
Update skill_lvexp SET F82 = F82*50
Update skill_lvexp SET F83 = F83*50
Update skill_lvexp SET F84 = F84*50
Update skill_lvexp SET F85 = F85*50
Update skill_lvexp SET F86 = F86*50
Update skill_lvexp SET F87 = F87*50
Update skill_lvexp SET F88 = F88*50
Update skill_lvexp SET F89 = F89*50
Update skill_lvexp SET F90 = F90*50
Update skill_lvexp SET F91 = F91*50
Update skill_lvexp SET F92 = F92*50
Update skill_lvexp SET F93 = F93*50
Update skill_lvexp SET F94 = F94*50
Update skill_lvexp SET F95 = F95*50
Update skill_lvexp SET F96 = F96*50
Update skill_lvexp SET F97 = F97*50
Update skill_lvexp SET F98 = F98*50
Update skill_lvexp SET F99 = F99*50
Update skill_lvexp SET F100 = F100*50
Update skill_lvexp SET F101 = F101*50
Update skill_lvexp SET F102 = F102*50
服务器经验
在NPC_Generation_SP表上点右键选择设计表，然后找到NpcExp列，旁边是不是有个int啊，下拉找到float，然后关闭表存盘
Update NPC_Generation_SP SET NpcExp = NpcExp*10000
查找指定ID
select * from chr_info
where login_id = '这里写ID'
公会仓库
select * from guild_item
where guild_code = 这里写公会代码
order by cn

清空人物銀行的句法

Update Chr_Info2 SET bankitem = 0

清空人物裝備的句法

Update Chr_Info SET equip = 0