Tổng Hợp Các Query Cho Mu
- Xem thông tin nhân vật
Code:
use MuOnline
select * from character
where name ='ten nhan vat'
- Tăng giảm 10 Reset và Relife cho nhân vật
Code:
use MuOnline
update character
set Resets = Resets + 10,Clevel = 400
where name ='ten nhan vat'

use MuOnline
update character
set Relifes = Relifes + 10
where name ='ten nhan vat'
- Xóa toàn bộ để lại db trống
Code:
delete character

Delete AccountCharacter

Delete GuildMember

Delete Guild

Delete MEMB_INFO

Delete MEMB_STAT

Delete T_CGuid

Delete T_CurCharName

Delete T_FriendList

Delete T_FriendMail

Delete T_FriendMain

Delete T_MasterLevelSystem

Delete warehouse

Delete VI_CURR_INFO
- Xóa hết chỉ chừa lại tài khoản trống
Code:
delete character

Delete AccountCharacter

Delete GuildMember

Delete Guild

Delete MEMB_STAT

Delete T_CGuid

Delete T_CurCharName

Delete T_FriendList

Delete T_FriendMail

Delete T_FriendMain

Delete T_MasterLevelSystem

Delete warehouse

Delete VI_CURR_INFO
- Tăng điểm master cho nhân vật
Code:
use MuOnline
update T_MasterLevelSystem
set MASTER_LEVEL = 200,ML_EXP = 200,ML_NEXTEXP = 200,ML_POINT = 200
where CHAR_NAME = 'tên nhân vật'
- - Tăng điểm master cho cả Server
Code:
use MuOnline
update T_MasterLevelSystem
set MASTER_LEVEL = 200,ML_EXP = 200,ML_NEXTEXP = 200,ML_POINT = 200
- Chỉnh số điểm cộng cho nhân vật về 0
Code:
UPDATE Character
SET LevelUpPoints=('0')
WHERE LevelUpPoints>0
- Tự động reset
Code:
UPDATE Character
SET cLevel=('1') , experience=('0')
WHERE cLevel>349
-Chỉnh tài khoản admin thành tài khoản thường
Code:
UPDATE Character
SET CtlCode=('0')
WHERE CtlCode='32' OR CtlCode='8'
-Mở khóa tài khoản cho tất cả nhân vật
Code:
UPDATE Character
SET CtlCode=('0')
WHERE CtlCode=('1')
-Chỉnh lại toàn bộ số lần reset về 0
Code:
UPDATE Character
SET Resets=('0')
WHERE Resets>0
- Xóa thùng đồ
Code:
UPDATE warehouse
SET Items=('')
- Xóa thùng đồ cá nhân
Code:
UPDATE Character
SET Inventory=('')
- Sửa lỗi hiển thị gamer online trên web
Code:
UPDATE MEMB_STAT
SET Connect_Stat='0'
WHERE Connect_Stat>0
- Sửa lỗi kẹt map
Code:
UPDATE Character
SET MapNumber=('0'), MapPosX=('125'), MapPosY=('125')
WHERE MapNumber=('5')
- Sửa lỗi âm điểm Guild
Code:
UPDATE Guild
SET G_Score=('0')
WHERE G_Score<-1
-Tăng điểm point cho thành viên
Code:
UPDATE Character
SET Strength='số point'
WHERE strength<18

UPDATE Character
SET Dexterity='số point'
WHERE Dexterity<16

UPDATE Character
SET Vitality='số point'
WHERE Vitality<16

UPDATE Character
SET Energy='số point'
WHERE Energy<16
- Xóa Pk
Code:
UPDATE Character
SET PkLevel = ('0'), PkTime = ('0'), PkCount = ('0')
Where PkLevel>2
-Chỉnh tiền cho thành viên
Code:
UPDATE Character
SET Money='2000000000'
WHERE Money<-1
- Loại bỏ số ID cá nhân
Code:
UPDATE MEMB_INFO
SET sno__numb=('')
WHERE sno__numb>1
- Xóa thành viên không có Guild (bang hội chỉ có 1 GM)
Code:
alter table guild nocheck constraint all
alter table guildmember nocheck constraint all
delete from guild
where EXISTS (
SELECT m.G_Name,count(*) as memb from GuildMember m
where guild.g_name=m.G_name
group by m.G_Name
having count(*) <2
)
- Xóa guildmember với guild không (khi bạn chỉnh sửa sai sau đó làm cho lỗi)
Code:
alter table guild nocheck constraint all
alter table guildmember nocheck constraint all
delete from guildmember
where NOT EXISTS (
SELECT * from Guild
where guild.g_name=guildmember.G_name
)
- Top 10 Guild(thành viên)
Code:
SELECT top 10 g.g_name,count(all m.g_name)as thanhvien from Guild as g join Guildmember as m
on g.g_name like m.g_name
group by g.g_Name
having count(*) > 20
order by count(*) DESC
- Top 5 guild tính theo số lần rs của thành viên trong G
Code:
select top 5 g.g_name,sum(c.resets) as reset from guildmember g join character c
on g.name like c.name
group by g.g_name
order by reset desc
-Top 5 online
Code:
select top 10 c.name,resets,s.onlinehours from character c full join memb_stat s
on c.accountid=s.memb___id
where (c.accountid in ( select top 10 memb___id from memb_stat
order by onlinehours desc ))
and (c.name in ( select top 1 c.name from character c where c.accountid=s.memb___id order by resets desc))
order by onlinehours desc
- Top reset trung bình (mỗi người chơi trong guild). Chỉnh sửa 10 đến giá trị mà bạn muốn. Đó là giá trị của các thành viên của guild
Code:
select top 5 g.g_name,sum(c.resets)/count(all g.g_name) as reset from guildmember g join character c
on g.name like c.name
group by g.g_name
having count(all g.g_name)>10
order by reset desc
- Đổi tên tài khoản (account )
Code:
select * from accountcharacter
where id='9242085'

update accountcharacter
set id='ha1710'
where id='9242085'

select * from accountcharacter
where id='ha1710'
-----------------------
select * from character
where accountid='9242085'

update character
set accountid='ha1710'
where accountid='9242085'

select * from character
where accountid='ha1710'
----------------------
select * from memb_info
where memb___id='9242085'

update memb_info
set memb___id='ha1710'
where memb___id='9242085'

select * from memb_info
where memb___id='ha1710'
----------------------
select * from memb_stat
where memb___id='9242085'

update memb_stat
set memb___id='ha1710'
where memb___id='9242085'

select * from memb_stat
where memb___id='ha1710'
-----------------------
select * from warehouse
where accountid='9242085'

update warehouse
set accountid='ha1710'
where accountid='9242085'

select * from warehouse
where accountid='ha1710'
- Xóa tài khoản không có nhiều kết nối từ 01/06/2010
Code:
delete from memb_info
where memb___id in (
select memb___id from memb_stat where disconnecttm<'2010-06-01')

delete from accountcharacter
where id in (
select memb___id from memb_stat where disconnecttm<'2010-06-01')

delete from character
where accountid in (
select memb___id from memb_stat where disconnecttm<'2010-06-01')

delete from warehouse
where accountid in (
select memb___id from memb_stat where disconnecttm<'2010-06-01')
- xóa tài khoản mà không có connect (tài khoản trống) hoặc lâu năm không có connect
Code:
delete from memb_info
where memb___id not in (
select memb___id from memb_stat)

delete from accountcharacter
where id not in (
select memb___id from memb_stat)

delete from character
where accountid not in (
select memb___id from memb_stat)

delete from warehouse
where accountid not in (
select memb___id from memb_stat)
- Character không có trong tài khoản
Code:
select accountid,character.name from character where accountid in (
select accountid from character
where name not in (select gameid1 from accountcharacter where id=accountid )
and name not in (select gameid2 from accountcharacter where id=accountid )
and name not in (select gameid3 from accountcharacter where id=accountid )
and name not in (select gameid4 from accountcharacter where id=accountid )
and name not in (select gameid5 from accountcharacter where id=accountid )
)
- Back up server
Code:
BACKUP LOG muonline WITH NO_LOG

USE [Muonline]
GO
--shrinking
DBCC SHRINKDATABASE(N'Muonline')

Declare @dateBackup Varchar(100)
Set @dateBackup = 'c:\muonline_' +
Convert(varchar, datepart( year , Getdate() )) + '-'+
Convert( varchar , datepart( month , Getdate() ) ) + '-'+
Convert( varchar, datepart( day , Getdate() ) ) + '.bak'
--saving backup with name and date.
BACKUP DATABASE [Muonline] TO DISK = @dateBackup WITH NOFORMAT, NOINIT, NAME = N'Muonline-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
- xóa guild, thành viên guild mà bị sai
Code:
alter table guild nocheck constraint all
alter table guildmember nocheck constraint all
delete from guild
where g_master not in ( select name from character )
delete from guildmember
where name not in ( select name from character )
delete from guildmember
where G_Name not in ( select G_name from guild )
- Tạo tài khoản
Code:
--Tao account
use MuOnline
insert into MEMB_INFO (memb___id,memb__pwd,mail_addr,sno__numb,ctl1_code,bloc_code,memb_name)
VALUES('abc123','matkhau','abc123@yahoo.com',123456789123456789,0,0,'proab')
--Kích 1 tài khoản bi treo
Code:
-- Kick 1 tai khoan bi treo acc - hoac 1 tai khoan dang Online
use MuOnline
update MEMB_STAT
set ConnectStat = 0
where memb___id = 'adminpro'
-- Up điểm Master cho nhân vật ở Server SCF có tên ...
Code:
UPDATE Character
SET SCFMasterLevel = 200, SCFMasterPoints = 200
where name='Tên Nhân Vật'
--Tặng điểm master cho tất cả nhân vật ở Server SCF
Code:
UPDATE Character
SET SCFMasterLevel = 200, SCFMasterPoints = 200
-- DK có combo ko phải làm nv khi lên 220
Code:
UPDATE Character set Quest=0xAAFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
WHERE NAME ='tên nv' and class ='18'
--DW có Nova ko phải làm nv khi lên 220
Code:
UPDATE Character set Quest=0xEAFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
WHERE NAME ='tên nv' and class ='2'
@: nếu là SCF thì thay chữ Quest = SCFCustomQuest
-- Block 1 nhân vật nào đó
Code:
UPDATE Character
SET CtlCode=('1')
WHERE NAME ='tên nv'
-- skill cuồng nộ sum
Code:
use MuOnline
update DefaultClassType
set MagicList= 0xDA0000FF0000FF0000FF0000FF0000FF0000FF0000FF0000 FF0000FF0000FF0000FF0000FF0000FF0000FF0000FF0000FF 0000FF0000FF0000FF0000FF0000FF0000FF0000FF0000FF00 00FF0000FF0000FF0000FF0000FF0000FF0000FF0000FF0000 FF0000FF0000FF0000FF0000FF0000FF0000FF0000FF0000FF 0000FF00
where class='80'
-- Tìm Đồ Full Trong Server
Code:
select * from warehouse
where (charindex (0xbf, items) %16=
or (charindex (0xff, items) %16=
or (charindex (0x7f, items) %16=
or (charindex (0x3f, items) %16=
or (charindex (0x9f, items) %16=
or (charindex (0x8f, items) %16=
or (charindex (0x9e, items) %16=
or (charindex (0x9d, items) %16=
or (charindex (0xbd, items) %16=
or (charindex (0xbc, items) %16=
or (charindex (0xba, items) %16=
or (charindex (0xbb, items) %16=
or (charindex (0xb7, items) %16=
or (charindex (0xaf, items) %16=
select * from extwarehouse
where (charindex (0xbf, items) %16=
or (charindex (0xff, items) %16=
or (charindex (0x7f, items) %16=
or (charindex (0x3f, items) %16=
or (charindex (0x9f, items) %16=
or (charindex (0x8f, items) %16=
or (charindex (0x9e, items) %16=
or (charindex (0x9d, items) %16=
or (charindex (0xbd, items) %16=
or (charindex (0xbc, items) %16=
or (charindex (0xba, items) %16=
or (charindex (0xbb, items) %16=
or (charindex (0xb7, items) %16=
or (charindex (0xaf, items) %16=
select * from character
where (charindex (0xbf, inventory) %16=
or (charindex (0xff, inventory) %16=
or (charindex (0x7f, inventory) %16=
or (charindex (0x3f, inventory) %16=
or (charindex (0x9f, inventory) %16=
or (charindex (0x8f, inventory) %16=
or (charindex (0x9e, inventory) %16=
or (charindex (0x9d, inventory) %16=
or (charindex (0xbd, inventory) %16=
or (charindex (0xbc, inventory) %16=
or (charindex (0xba, inventory) %16=
or (charindex (0xbb, inventory) %16=
or (charindex (0xb7, inventory) %16=
or (charindex (0xaf, inventory) %16=8