| 文章来源：haomusf奇迹私服网 发布时间：2009-2-6 3:47:18 |
奇迹私服卡号踢人的方法(踢谁都行)
卡号踢人的方法：
1.点开任务栏启动项目的第4个标题为[Authe..]
2.点击菜单栏[Control]->[User]
3.在[AllListRefresh]下面的空格处填上玩家的帐号，点下面的[Search];
4.如果真正卡号了在[Account][Description]下面会出现那个帐号；
5.单击那个帐号点右边[CompulsoryUserDisconnect(*Caution*)]就踢了；
6.可以再次点[Search]查不到就说明踢了！
霹雳后台密码找回SQL语句
霹雳后台密码遗忘找回方式
霹雳将真诚的为大家服务为大家提供更好的游戏服务端管理平台。
霹雳软件产品：
1.霹雳奇迹WEB管理平台。
2.如果密码忘了请在查询分析器里运行以下语句帐号即为admin密码:admin：
usemuonline
go
deletefromweb_admin
insertintoweb_admin(acc,pass,qx)values(admin,21232f297a57a5a743894a0e4a801fc3,▼ABCE◥D」∫⊥⊥『∈』F≯G▲◆△←∝〃※ˇ∵∑◢IJK→∠↑①◤P∏○□●Q「‖￠R②S≡≈≌◣YZ¨「⒈⒉1)
MUONLINE数据库日志收缩语句短而精悍
BACKUPLOGMuOnlineWITHNO_LOG
DBCCSHRINKDATABASE(MuOnline,10)
1.新人注册送500点
CREATETRIGGER新人送点ONCharacter
AFTERINSERT
AS
SETNOCOUNTON
UPDATECharacterSETCharacter.LevelUpPoint=500
FROMInserted
WHERECharacter.name=Inserted.name
SETNOCOUNTOFF
修改上面那个500就是送的点数
运行查询分析器把这段代码对准muonline数据库查询
看到查询成功就可以关闭
如果需要更改送的点数:到muonline-用户表-dbo.Character-触发器-dbo.新人送点(按右键编辑)
修改500的数字为你要的点数再查询一次就行了
2.圣导送９９９９统率：
CREATETRIGGER[Leadership]ON[dbo].[Character]
afterInsert
as
Update[Character]set[Character].Leadership=9999
FromInserted
WhereInserted.Class=64and[Character].accountid=inserted.accountid
and[Character].name=inserted.name
修改下面那个9999就是送的点数
运行查询分析器复制这段代码对准muonline数据库查询
看到查询成功就可以关闭
如果需要更改送的点数:到muonline-用户表-dbo.Character-触发器-dbo.Leadership(按右键编辑)
修改9999的数字为你要的点数再查询一次就行了
新人上线400级
CREATETRIGGER[Restrict_IntLUP]ON[dbo].[Character]
afterInsert
as
Update[Character]set[Character].cLevel=400FromInserted
Where[Character].accountid=inserted.accountid
and[Character].name=inserted.name
多区数据库解决帐号重复SQL语句
updatememb_infosetservercode=1whereservercode=2
玩家角色达到条件以后自动专职SQL语句
CREATETRIGGER战士自动一转ONCharacter
AFTERINSERT
AS
SETNOCOUNTON
UPDATECharacterSETCharacter.Class=17
FROMInserted
WhereInserted.cLevel=150andInserted.Class=16
SETNOCOUNTOFF
CREATETRIGGER法师自动一转ONCharacter
AFTERINSERT
AS
SETNOCOUNTON
UPDATECharacterSETCharacter.Class=1
FROMInserted
WhereInserted.cLevel=150andInserted.Class=0
SETNOCOUNTOFF
CREATETRIGGER妹妹自动一转ONCharacter
AFTERINSERT
AS
SETNOCOUNTON
UPDATECharacterSETCharacter.Class=33
FROMInserted
WhereInserted.cLevel=150andInserted.Class=32
SETNOCOUNTOFF
CREATETRIGGER战士自动三转ONCharacter
AFTERINSERT
AS
SETNOCOUNTON
UPDATECharacterSETCharacter.Class=18
FROMInserted
WhereInserted.cLevel=380andInserted.Class=17
SETNOCOUNTOFF
CREATETRIGGER法师自动三转ONCharacter
AFTERINSERT
AS
SETNOCOUNTON
UPDATECharacterSETCharacter.Class=2
FROMInserted
WhereInserted.cLevel=380andInserted.Class=1
SETNOCOUNTOFF
CREATETRIGGER妹妹自动三转ONCharacter
AFTERINSERT
AS
SETNOCOUNTON
UPDATECharacterSETCharacter.Class=34
FROMInserted
WhereInserted.cLevel=380andInserted.Class=33
SETNOCOUNTOFF
CREATETRIGGER魔剑自动三转ONCharacter
AFTERINSERT
AS
SETNOCOUNTON
UPDATECharacterSETCharacter.Class=50
FROMInserted
WhereInserted.cLevel=380andInserted.Class=48
SETNOCOUNTOFF
CREATETRIGGER圣导自动三转ONCharacter
AFTERINSERT
AS
SETNOCOUNTON
UPDATECharacterSETCharacter.Class=64
FROMInserted
WhereInserted.cLevel=150andInserted.Class=66
SETNOCOUNTOFF
--进入MuOnline数据库，选择存储过程，找到WZ_CONNECT_MEMB右键属性，然后拖到最后面找到end上面加上下面语句即可
--自动更新所有圣导师的统率为9999
Update[Character]set[Character].Leadership=9999Where[Character].Class=64
end
GO
取消新人注册送点
CREATETRIGGER[Restrict_IntLUP]ON[dbo].[Character]
afterInsert
as
Update[Character]set[Character].LevelUpPoint=0FromInserted
Where[Character].accountid=inserted.accountid
and[Character].name=inserted.name
新手送3333点(具体送多少修改LevelUpPoint=3333FromInserted)
CREATETRIGGER[Restrict_IntLUP]ON[dbo].[Character]
afterInsert
as
Update[Character]set[Character].LevelUpPoint=3333FromInserted
Where[Character].accountid=inserted.accountid
and[Character].name=inserted.name
圣导送统率
CREATETRIGGER[Leadership]ON[dbo].[Character]
afterInsert
as
Update[Character]set[Character].Leadership=99
FromInserted
WhereInserted.Class=64and[Character].accountid=inserted.accountid
and[Character].name=inserted.name
33人战盟带旗(具体送多少修改havingcount(*)>32))),比如35就修改havingcount(*)>34)
usemuonline
updateextchrdatasetstat=3wherenamein(selectG_masterfromguildwhereG_namein(selectG_namefromguildmemberwhereG_namein(selectg_namefromguildmembergroupbyg_namehavingcount(*)>32)))
更改角色名
usemuonline
declare@oldnamenvarchar(10),@newnamenvarchar(10)
--在单引号里面输入要查询的角色名，前是老名字，后是新名字。
set@oldname=老名字
set@newname=新名字
if@newnamein(selectnamefromcharacterwherename=@newname)
print数据库里已有相同角色名，不进行更名操作！
else
begin
updateaccountcharactersetgameid1=@newnamewheregameid1=@oldname
updateaccountcharactersetgameid2=@newnamewheregameid2=@oldname
updateaccountcharactersetgameid3=@newnamewheregameid3=@oldname
updateaccountcharactersetgameid4=@newnamewheregameid4=@oldname
updateaccountcharactersetgameid5=@newnamewheregameid5=@oldname
updateaccountcharactersetgameidc=@newnamewheregameidc=@oldname
updatecharactersetname=@newnamewherename=@oldname
updateguildsetg_master=@newnamewhereg_master=@oldname
updateguildmembersetname=@newnamewherename=@oldname
updateoptiondatasetname=@newnamewherename=@oldname
end
清空有全属装备的仓库
updatewarehousesetItems=nullwhere(charindex(0xbf,items)%10=8)or(charindex(0xff,items)%10=8)
or(charindex(0x7f,items)%10=8)or(charindex(0x3f,items)%10=8)
罗兰攻城
ifexists(select*fromdbo.sysobjectswhereid=object_id(N[dbo].[GCGuild])andOBJECTPROPERTY(id,NIsUserTable)=1)
droptable[dbo].[GCGuild]
GO
CREATETABLE[dbo].[GCGuild](
[IDX][int]NOTNULL,
[GuildName][varchar](10)COLLATEChinese_PRC_CI_ASNOTNULL,
[GuildIdx][int]NOTNULL,
[GuildMZName][varchar](10)NOTNULL
)ON[PRIMARY]
GO
insertintogcguild(IDX,GuildName,GuildIdx,GuildMZName)VALUES(100,,0,)
insertintogcguild(IDX,GuildName,GuildIdx,GuildMZName)VALUES(101,,0,)
insertintogcguild(IDX,GuildName,GuildIdx,GuildMZName)VALUES(102,,0,)
insertintogcguild(IDX,GuildName,GuildIdx,GuildMZName)VALUES(103,,0,)
insertintogcguild(IDX,GuildName,GuildIdx,GuildMZName)VALUES(104,,0,)
insertintogcguild(IDX,GuildName,GuildIdx,GuildMZName)VALUES(200,,0,)
insertintogcguild(IDX,GuildName,GuildIdx,GuildMZName)VALUES(201,,0,)
insertintogcguild(IDX,GuildName,GuildIdx,GuildMZName)VALUES(202,,0,)
insertintogcguild(IDX,GuildName,GuildIdx,GuildMZName)VALUES(203,,0,)
insertintogcguild(IDX,GuildName,GuildIdx,GuildMZName)VALUES(204,,0,)
GO
删除空仓库
deletefromwarehouse
where(itemsisnull)and(money=500000)
--删除空仓库(500000是注册送的钱,我送了50万)
解封
usemuonline
UPDATE[MuOnline].[dbo].[Character]
SET[CtlCode]=0
WHEREName=名字
新人送２转
CREATETRIGGER[zscount]ON[dbo].[Character]
afterInsert
as
Update[Character]set[Character].zs_count=2
FromInserted
WhereInserted.zs_count=0and[Character].accountid=inserted.accountid
and[Character].name=inserted.name
减少SQL日志的方法
backuplogMuOnlinewithNO_LOG
backuplogMuOnlinewithTRUNCATE_ONLY
DBCCSHRINKDATABASE(MuOnline)
--将上面的语句多次执行，直到日志文件缩小。
删除申请帐号后从未上过线
deletefrommemb_infowherememb___idin(selectmemb___idfrommemb_stat)
删除没有100级人物的帐号
deletefrommemb_infowherememb___idnotin(selectDISTINCTaccountidfromcharacterwhereclevel>=100)
deletefromwarehousewhereaccountidnotin(selectDISTINCTaccountidfromcharacterwhereclevel>=100)
deletefromcharacterwhereaccountidnotin(selectmemb___idfrommemb_info)
注册帐号送戒指
CREATETRIGGER[1]ON[dbo].[Character]
afterInsert
as
Update[Character]set[Character].Inventory=0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFB408FFFFFFFEED8000FBB410FFFFFFFEEC80007CFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFromInserted
Where[Character].accountid=inserted.accountid
and[Character].name=inserted.name
淡淡网络内部防复制SQL代码(支持最新996X)
SETQUOTED_IDENTIFIERON
GO
SETANSI_NULLSON
GO
CREATETRIGGER[dbo].[clear_copyitems]ON[dbo].[warehouse]
FORUPDATE
AS
BEGIN
IFUPDATE(items)
BEGIN
DECLARE@al_acidvarchar(10)
DECLARE@al_namevarchar(10)
DECLARE@whItemsASbinary(1200)
DECLARE@bdItemsASbinary(760)
DECLARE@bItemASbinary(1)
DECLARE@wItemASbinary(1)
DECLARE@bItemIdASbinary(4)
DECLARE@WItemIdASbinary(4)
DECLARE@iASint
DECLARE@iiASint
DECLARE@findASint
SET@find=0
SELECT@al_acid=inserted.accountid,@whItems=inserted.itemsFROMinserted
SELECT@al_name=GameIDCFROMAccountCharacterWHEREid=@al_acid
SELECT@bdItems=inventoryFROMcharacterWHEREaccountid=@al_acidANDname=@al_name
SET@i=0
WHILE@i<120
BEGIN
SET@wItem=SUBSTRING(@whItems,@i*10+1,1)
SET@wItemId=SUBSTRING(@whItems,@i*10+4,4)
IF@wItem<>0xFFAND@wItemId<>0x00000000AND@wItemISNOTNULLAND@wItemIdISNOTNULL
BEGIN
SET@ii=0
WHILE@ii<76
BEGIN
SET@bItem=SUBSTRING(@bdItems,@ii*10+1,1)
SET@bItemId=SUBSTRING(@bdItems,@ii*10+4,4)
IF@bItem<>0xFFAND@bItemId<>0x00000000
BEGIN
IF@bItem=@wItemAND@bItemId=@wItemId
BEGIN
SET@whitems=SUBSTRING(@whitems,1,@i*10)+0xFFFFFFFFFFFFFFFFFFFF+SUBSTRING(@whitems,(1+@i)*10+1,(76-1-@i)*10)
SET@find=1
SET@ii=76
END
SET@ii=@ii+1
END
END
SET@i=@i+1
END
END
IF@find=1
BEGIN
UPDATEwarehouseSETitems=@whitemsWHEREaccountid=@al_acid
END
END
END
GO
SETQUOTED_IDENTIFIEROFF
GO
SETANSI_NULLSON
GO
sql清除库
如果你运行建议备份后否自后果自负
useMuOnline
DELETEFROM[dbo].[Character]
DELETEFROM[dbo].[vCharacterPreview]
DELETEFROM[dbo].[AccountCharacter]
DELETEFROM[dbo].[Admit_Info]
DELETEFROM[dbo].[Guild]
DELETEFROM[dbo].[GuildMember]
DELETEFROM[dbo].[MANG_INFO]
DELETEFROM[dbo].[MEMB_DETA]
DELETEFROM[dbo].[MEMB_INFO]
DELETEFROM[dbo].[MUMNG_AUTH_SKILL]
DELETEFROM[dbo].[MUMNG_MANG_INFO]
DELETEFROM[dbo].[MUMNG_SKILL_INFO]
DELETEFROM[dbo].[OptionData]
DELETEFROM[dbo].[UseLog]
DELETEFROM[dbo].[VI_CURR_INFO]
DELETEFROM[dbo].[warehouse] |
|