Share full WEB + Server SS2 10.00.16 full event và CTC

[hailee]

@DIEULINH

Rảnh rỗi ngồi cắt cho bạn đây,cắt cả ngang và dọc nhé,vì k biết yêu cầu của bạn là ngang hay dọc.
[Only registered and activated users can see links. ]

[DieuNinh]

@DIEULINH

Rảnh rỗi ngồi cắt cho bạn đây,cắt cả ngang và dọc nhé,vì k biết yêu cầu của bạn là ngang hay dọc.
[Only registered and activated users can see links. ]

cảm ơn cậu nhiều baner này cắt dọc
cảm ơn cậu đã giúp Thanks

[MrKubjn]

bản này đã onl chưa ,có ổn không hả anh DieuNinh

[k0y1a]

bản này sài main nào vậy mọi người

[nh0xpy]

ai cho tớ xin odbc 64bit win server 2008 đc k
jonserver.exe chẳng thấy đâu
connect server bị lỗi ai giúp vs

[codohue]

anh dieuninh..hướng dẫn cài cái wed này ni

[divine9966]

cho hỏi code này là j` vậy query hay j`

update character set Resets = Resets + 1, NoResetInMonth = NoResetInMonth + 1 where name = 'ThanhHuyen'update character set SCFMasterLevel = SCFMasterLevel + 1, SCFMasterPoints = SCFMasterPoints + 200 where name = 'Vkiu'update character set NoResetInMonth = 0
update character set Resets = 100, cLevel = 400 where name = 'ThanhHuyen'

select * from MEMB_INFO where memb___id = 'dkmay'


update character set Inventory = 0x16EF8433C6B6007F0008AD000000000016EF84866055007F00085D00000000001D6F88970EA1007F00787D00000000001D6F88A012E0007F00887D00000000001D6F88E55A23007F00987D00000000001D6F88C0E85A007F00A87D00000000001D6F889BAFB5007F00B87D0000000000056FE35E56A4007F00C0000000000000 where name = 'Handsomes'


update character set SCFMasterPoints = 200 where name = 'ngocse7en'
----select Id from AccountCharacter
select Inventory from character where name ='abc'select Items from warehouse where AccountID ='abc'
update warehouse set items=0x014C6100C7BBFD020070000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0500C800BB2A660000C0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF1C200500B24B9F0000E00000000000001C200500A28A8A0000E0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0E000100C7BA9C0000E00000000000000F000000C825770000C000000000000010005900AA929E080090000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF16000100C7FFFD0000E00000000000000A008D00C2FED10000D0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0E000100C829CA0000E00000000000000100FF000000000000D0000000000000014861009797A20800B0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0E000100C7FF9B0000E00000000000000F000000C8046E0000C0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF15096600A4B553240090000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF144C6F00C7E4D7010080000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF12496000C80193040070000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0D000100C7FFDD0000E0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF034C4700C800A1110090000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0E000100C829CF0000E00000000000000E000100C7FF8A0000E00000000000000D000100C8025A0000E0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF1228FF000000000000D0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0F000000C845B00000C00000000000000F000000C7BFA90000C0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0F000000C7BFAA0000C00000000000000F000000C825790000C0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0D000100C829BD0000E00000000000000F000000C845AF0000C00000000000000F000000C8274D0000C0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0E000100C7BA6F0000E00000000000000F000000C845B10000C00000000000000F000000C7BFA80000C0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0D000100C7BA770000E00000000000000F000000C825780000C00000000000000F000000C8046F0000C0000000000000 where AccountID = 'nightmare3'
update character set Inventory = 0x16EF8EB92F37007F0008AD000000000016EF8EC0FC50007F0008AD00000000001D6F8960C9D3007F00787D00000000001D6F8971A64A007F00887D00000000001D6F89E3E5E5007F00987D00000000001D6F890F3414007F00A87D00000000001D6F89A5D087007F00B87D0000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF where name='abc'----
update character set PkCount = 0select PkCount, name from character order by PkCount DESC

select tel__numb from MEMB_INFO
select mail_addr from MEMB_INFO
$query = "select Name,sum(menhgia) as tien from CardPhone where status = 2  and ngay >= '4/17/2012' group by Name order by sum(menhgia) DESC";
select NoResetInMonth from character where name = 'AnhTanTB'
select * from AccountCharacter where Id = 'vancoity'update AccountCharacter set GameID1 = 'BachLong1' ,GameID2 = 'bachlong' ,GameID3 = 'fsfsdf' ,GameID4 = 'fsdfsgdfg' ,GameID5 = 'gdfgdfgdfg' where Id = 'kiemma28'
delete MEMB_STAT

update character set Resets =  300,cLevel = 400, Relifes = 1 where name = 'KK6789'
select * from GuildMember where G_Name = '1Chap10'



update character set Clevel = 400, LevelUpPoint= 335, Resets = 4, Experience = 0, Strength = 0, Dexterity = 0, Vitality = 0, Energy = 0



update character set Clevel = 400, LevelUpPoint= 300, Resets = 14, Experience = 0, Strength = 0, Dexterity = 0, Vitality = 0, Energy = 0

update warehouse set Items = 0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
update DoanhThu set money =  where id = 
delete AccountCharacterdelete Characterdelete GuildMemberdelete Guilddelete T_FriendListdelete T_FriendMaildelete T_FriendMaindelete T_WaitFrienddelete warehousedelete CardPhonedelete MEMB_STATdelete MEMB_INFO

INSERT INTO CardPhone (acc,Name,card_type,menhgia,card_num,card_serial,ngay,timenap,status) VALUES ('xuyenph','2Tay2Sung','GATE','500000','1111111111','PB00120820','9/7/2012','1318420773','2')
INSERT INTO CardPhone (acc,Name,card_type,menhgia,card_num,card_serial,ngay,timenap,status) VALUES ('baosaolon','ToiDaGia','MobiPhone','20000','272820420663','008322000039391','11/11/2012','1318420773','2')



select * from warehousewhere (charindex (0xbf, items) %16=8)or (charindex (0xff, items) %16=8)or (charindex (0x7f, items) %16=8)or (charindex (0x3f, items) %16=8)or (charindex (0x9f, items) %16=8)or (charindex (0x8f, items) %16=8)or (charindex (0x9e, items) %16=8)or (charindex (0x9d, items) %16=8)or (charindex (0xbd, items) %16=8)or (charindex (0xbc, items) %16=8)or (charindex (0xba, items) %16=8)or (charindex (0xbb, items) %16=8)or (charindex (0xb7, items) %16=8)or (charindex (0xaf, items) %16=8)select * from extwarehousewhere (charindex (0xbf, items) %16=8)or (charindex (0xff, items) %16=8)or (charindex (0x7f, items) %16=8)or (charindex (0x3f, items) %16=8)or (charindex (0x9f, items) %16=8)or (charindex (0x8f, items) %16=8)or (charindex (0x9e, items) %16=8)or (charindex (0x9d, items) %16=8)or (charindex (0xbd, items) %16=8)or (charindex (0xbc, items) %16=8)or (charindex (0xba, items) %16=8)or (charindex (0xbb, items) %16=8)or (charindex (0xb7, items) %16=8)or (charindex (0xaf, items) %16=8)select * from characterwhere (charindex (0xbf, inventory) %16=8)or (charindex (0xff, inventory) %16=8)or (charindex (0x7f, inventory) %16=8)or (charindex (0x3f, inventory) %16=8)or (charindex (0x9f, inventory) %16=8)or (charindex (0x8f, inventory) %16=8)or (charindex (0x9e, inventory) %16=8)or (charindex (0x9d, inventory) %16=8)or (charindex (0xbd, inventory) %16=8)or (charindex (0xbc, inventory) %16=8)or (charindex (0xba, inventory) %16=8)or (charindex (0xbb, inventory) %16=8)or (charindex (0xb7, inventory) %16=8)or (charindex (0xaf, inventory) %16=8) 

[mrthanh2k11]

ai cho e hỏi cái data chuẩn kia copy vào thư mục MUsv àk

[nh0xpy]

ai cho xin main vs nào
30 charrrrrrrrrrrrrrrrrrrrrrrr

[cuocdoisp]

cho hỏi code này là j` vậy query hay j`

update character set Resets = Resets + 1, NoResetInMonth = NoResetInMonth + 1 where name = 'ThanhHuyen'update character set SCFMasterLevel = SCFMasterLevel + 1, SCFMasterPoints = SCFMasterPoints + 200 where name = 'Vkiu'update character set NoResetInMonth = 0
update character set Resets = 100, cLevel = 400 where name = 'ThanhHuyen'

select * from MEMB_INFO where memb___id = 'dkmay'


update character set Inventory = 0x16EF8433C6B6007F0008AD000000000016EF84866055007F00085D00000000001D6F88970EA1007F00787D00000000001D6F88A012E0007F00887D00000000001D6F88E55A23007F00987D00000000001D6F88C0E85A007F00A87D00000000001D6F889BAFB5007F00B87D0000000000056FE35E56A4007F00C0000000000000 where name = 'Handsomes'


update character set SCFMasterPoints = 200 where name = 'ngocse7en'
----select Id from AccountCharacter
select Inventory from character where name ='abc'select Items from warehouse where AccountID ='abc'
update warehouse set items=0x014C6100C7BBFD020070000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0500C800BB2A660000C0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF1C200500B24B9F0000E00000000000001C200500A28A8A0000E0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0E000100C7BA9C0000E00000000000000F000000C825770000C000000000000010005900AA929E080090000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF16000100C7FFFD0000E00000000000000A008D00C2FED10000D0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0E000100C829CA0000E00000000000000100FF000000000000D0000000000000014861009797A20800B0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0E000100C7FF9B0000E00000000000000F000000C8046E0000C0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF15096600A4B553240090000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF144C6F00C7E4D7010080000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF12496000C80193040070000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0D000100C7FFDD0000E0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF034C4700C800A1110090000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0E000100C829CF0000E00000000000000E000100C7FF8A0000E00000000000000D000100C8025A0000E0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF1228FF000000000000D0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0F000000C845B00000C00000000000000F000000C7BFA90000C0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0F000000C7BFAA0000C00000000000000F000000C825790000C0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0D000100C829BD0000E00000000000000F000000C845AF0000C00000000000000F000000C8274D0000C0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0E000100C7BA6F0000E00000000000000F000000C845B10000C00000000000000F000000C7BFA80000C0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0D000100C7BA770000E00000000000000F000000C825780000C00000000000000F000000C8046F0000C0000000000000 where AccountID = 'nightmare3'
update character set Inventory = 0x16EF8EB92F37007F0008AD000000000016EF8EC0FC50007F0008AD00000000001D6F8960C9D3007F00787D00000000001D6F8971A64A007F00887D00000000001D6F89E3E5E5007F00987D00000000001D6F890F3414007F00A87D00000000001D6F89A5D087007F00B87D0000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF where name='abc'----
update character set PkCount = 0select PkCount, name from character order by PkCount DESC

select tel__numb from MEMB_INFO
select mail_addr from MEMB_INFO
$query = "select Name,sum(menhgia) as tien from CardPhone where status = 2  and ngay >= '4/17/2012' group by Name order by sum(menhgia) DESC";
select NoResetInMonth from character where name = 'AnhTanTB'
select * from AccountCharacter where Id = 'vancoity'update AccountCharacter set GameID1 = 'BachLong1' ,GameID2 = 'bachlong' ,GameID3 = 'fsfsdf' ,GameID4 = 'fsdfsgdfg' ,GameID5 = 'gdfgdfgdfg' where Id = 'kiemma28'
delete MEMB_STAT

update character set Resets =  300,cLevel = 400, Relifes = 1 where name = 'KK6789'
select * from GuildMember where G_Name = '1Chap10'



update character set Clevel = 400, LevelUpPoint= 335, Resets = 4, Experience = 0, Strength = 0, Dexterity = 0, Vitality = 0, Energy = 0



update character set Clevel = 400, LevelUpPoint= 300, Resets = 14, Experience = 0, Strength = 0, Dexterity = 0, Vitality = 0, Energy = 0

update warehouse set Items = 0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
update DoanhThu set money =  where id = 
delete AccountCharacterdelete Characterdelete GuildMemberdelete Guilddelete T_FriendListdelete T_FriendMaildelete T_FriendMaindelete T_WaitFrienddelete warehousedelete CardPhonedelete MEMB_STATdelete MEMB_INFO

INSERT INTO CardPhone (acc,Name,card_type,menhgia,card_num,card_serial,ngay,timenap,status) VALUES ('xuyenph','2Tay2Sung','GATE','500000','1111111111','PB00120820','9/7/2012','1318420773','2')
INSERT INTO CardPhone (acc,Name,card_type,menhgia,card_num,card_serial,ngay,timenap,status) VALUES ('baosaolon','ToiDaGia','MobiPhone','20000','272820420663','008322000039391','11/11/2012','1318420773','2')



select * from warehousewhere (charindex (0xbf, items) %16=8)or (charindex (0xff, items) %16=8)or (charindex (0x7f, items) %16=8)or (charindex (0x3f, items) %16=8)or (charindex (0x9f, items) %16=8)or (charindex (0x8f, items) %16=8)or (charindex (0x9e, items) %16=8)or (charindex (0x9d, items) %16=8)or (charindex (0xbd, items) %16=8)or (charindex (0xbc, items) %16=8)or (charindex (0xba, items) %16=8)or (charindex (0xbb, items) %16=8)or (charindex (0xb7, items) %16=8)or (charindex (0xaf, items) %16=8)select * from extwarehousewhere (charindex (0xbf, items) %16=8)or (charindex (0xff, items) %16=8)or (charindex (0x7f, items) %16=8)or (charindex (0x3f, items) %16=8)or (charindex (0x9f, items) %16=8)or (charindex (0x8f, items) %16=8)or (charindex (0x9e, items) %16=8)or (charindex (0x9d, items) %16=8)or (charindex (0xbd, items) %16=8)or (charindex (0xbc, items) %16=8)or (charindex (0xba, items) %16=8)or (charindex (0xbb, items) %16=8)or (charindex (0xb7, items) %16=8)or (charindex (0xaf, items) %16=8)select * from characterwhere (charindex (0xbf, inventory) %16=8)or (charindex (0xff, inventory) %16=8)or (charindex (0x7f, inventory) %16=8)or (charindex (0x3f, inventory) %16=8)or (charindex (0x9f, inventory) %16=8)or (charindex (0x8f, inventory) %16=8)or (charindex (0x9e, inventory) %16=8)or (charindex (0x9d, inventory) %16=8)or (charindex (0xbd, inventory) %16=8)or (charindex (0xbc, inventory) %16=8)or (charindex (0xba, inventory) %16=8)or (charindex (0xbb, inventory) %16=8)or (charindex (0xb7, inventory) %16=8)or (charindex (0xaf, inventory) %16=8) 

nhìn qua là thấy mà ví dụ : INSERT INTO CardPhone