ctgwglzc 发表于 2008-5-24 21:39:25

Some Query Codes For Beginners and Program （送给新手的一些查询代码和程序）

--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
Select * from tb_user
where ip = ' ip '
------
--Write Char and Find 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
http://img209.imageshack.us/img209/69/34803083ax8.png
http://img209.imageshack.us/img209/7358/34815585jb5.jpg
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

ctgwglzc 发表于 2008-5-24 21:45:35

下载地址2

文件名: Some Query Codes For Beginner.rar
描述: Some Query Codes For Beginner.rar
下载地址: http://www.fs2you.com/files/dbceda4c-2997-11dd-9b24-00142218fc6e/

天剑风小流 发表于 2008-5-25 06:03:12

都是E文，咋用啊？

ctgwglzc 发表于 2008-5-25 15:13:40

原帖由 天剑风小流 于 2008-5-25 06:03 发表 http://www.kofans.cn/bbs/static/image/common/back.gif
都是E文，咋用啊？
数据库里都是E文？你还不是一样用了

xz7323746 发表于 2009-6-7 02:18:28

汗``CT老爱弄些E文的,别人怎么懂啊

v123 发表于 2009-9-26 11:05:47

多少给个解释下撒- -

leonjaykai 发表于 2010-9-2 13:51:33

好東西謝謝
页: [1]
查看完整版本: Some Query Codes For Beginners and Program （送给新手的一些查询代码和程序）