--Delete Banned Users From UserData
delete userdata where authority = '255'
------
--View Banned Users(0=Gm,1=Normal,2=Mute)
select * from userdata
where authority = '255'
------
--Write ip and find account info[View Account info]
Select * from tb_user
where ip = ' ip '
------
--Write Char and Find Account Info[View Account info]
declare @name varchar(21)
set @name = 'Write CharId'
SELECT * from ACCOUNT_CHAR
where struserid = @name
------
--Find Bronze Premium Users
Select * from tb_user
where premiumtype = '0'
------
--Clean currentuser
DeLeTe CuRReNTuSeR
--------
--Write Char id and show friends
select * from friend_list
where struserid = 'Please write char id here'
-------
--Delete Npc
delete from K_npc
where sSid = 'Write Npc sSid'
---------
--Delete Npc (Two and More)
DELETE FROM K_NPC
WHERE (sSid = Write Npc1 sSid) OR (sSid = Write NPC2 sSid)
---------
--Delete Monster
Delete from K_Monster
where sSid = 'Write Monster sSid'
---------
--Delete Monster (Two and More)
Delete From K_Monster
where (sSid = Write Monster1 sSid) or ( sSid = Write Monster2 sSid)
------------------------
and Some Query codes For Beginners Program:D
Download : http://trfuntr.tr.funpic.de/sqlcodes...20Beginner.exe
This Program have codes in here.i add some codes near for beginners.after i write middle class codes.Bad English :((
Update Button is Enabled! Enter Update and wait few seconds.(3-4 seconds wait)
-----------------------------------------
Türkçesi : Programda Burda Bulunan Kodlar var.Yakında beginnerler için yeni kodlar ekleyeceğim.Ondan sonra orta düzey query codları yazmaya başlıyacağım.Ingilizcem Kötü kusura bakmayın.Update Buton Düzeltildi.Sizde Çalışmıyorsa Programı Yeniden Yükleyin.Update Butonuna basın biraz bekleyin Yazı çıkacaktır.
Ingilizce tam yazamadıgım için türkçesini yazdim.Düzgün editlerseniz sevinirim.
-----------------------------------------
Seecren Shoots
Download : http://trfuntr.tr.funpic.de/sqlcodes...20Beginner.exe
i write this program for empirequest.
-----
This Program english Version.Turkish version is writing for FRMTR .This Message not advert.
------------
earthsname |
