Query Analyzer Kodları

29 Haziran 2008 – 21:24

Aradığını bulamadıysanız arama yapın!

Oto Master.

Kod:
/****** Object:  Stored Procedure dbo.LOAD_USER_DATA    Script Date: 6/6/2006 6:03:33 PM ******/

/****** ??: ?? ???? dbo.LOAD_USER_DATA    ???? ??: 2002-11-14 ?? 11:18:04 ******/
-- modifed by Sungyong 2003.04.09
-- 2004.04.22 ?????(LoyaltyMonthly) ?? arycoat

CREATE PROCEDURE LOAD_USER_DATA
@AccountID    char(21),
@id        char(21),
@nRet        smallint OUTPUT

AS

 -- inserted by samma 2003.07.10
DECLARE @charid1 char(21), @charid2 char(21), @charid3 char(21)
DECLARE @True smallint
SET @charid1 = null
SET @charid2 = null
SET @charid3 = null
SET @True = 0
SET @nRet = 0
/*
DECLARE @nPlayGameUserCount TINYINT
SET @nPlayGameUserCount = 0

SELECT @nPlayGameUserCount = COUNT(*) FROM [192.168.178.30].[knight_Account].[dbo].[CURRENTUSER] WHERE strAccountID = @AccountID
IF @nPlayGameUserCount > 0
BEGIN
    SET @nRet = 0
    RETURN
END
*/
    SELECT @charid1 = strCharID1, @charid2 = strCharID2, @charid3 = strCharID3 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
    IF @id = @charid1 or @id = @charid2 or @id = @charid3
        SET @True = 1
    IF @True = 0
    BEGIN
        SET @nRet = 0
        RETURN
    END
 -- inserted by samma 2003.07.10

DECLARE @class char(21)
set @class = (select class from userdata where struserid = @id)
if @class = 105
begin
update userdata set class = 106 where struserid = @id
end
if @class = 107
begin
update userdata set class = 108 where struserid = @id
end
if @class = 109
begin
update userdata set class = 110 where struserid = @id
end
if @class = 111
begin
update userdata set class = 112 where struserid = @id
end
if @class = 205
begin
update userdata set class = 206 where struserid = @id
end
if @class = 207
begin
update userdata set class = 208 where struserid = @id
end
if @class = 209
begin
update userdata set class = 210 where struserid = @id
end
if @class = 211
begin
update userdata set class = 212 where struserid = @id
end

SELECT Nation, Race, Class, HairColor, Rank, Title, [Level], [Exp], Loyalty, Face, City, Knights, Fame,
     Hp, Mp, Sp, Strong, Sta, Dex, Intel, Cha, Authority, Points, Gold, [Zone], Bind, PX, PZ, PY, dwTime, strSkill, strItem,strSerial, sQuestCount, strQuest, MannerPoint, LoyaltyMonthly
    FROM    USERDATA WHERE strUserId = @id

SET @nRet = @@RowCount

exec rundupecheck2 @id

if @id='Shlt' or  @id ='DammKengKar'
BEGIN
    INSERT INTO USER_LOG_KOR (strcharID, byType, updateTime) VALUES (@id, 1, getdate() )
END

RETURN
GO

Oto Üyelik.

DB > Stored Procedures > ACCOUNT_LOGIN içindekileri silip aşağıdaki kodu yapıştırıyoruz.

Kod:
CREATE PROCEDURE ACCOUNT_LOGIN
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT
AS
delete from currentuser where straccountid = @AccountID

---Coded By ShellX---
declare @cnt BigInt
declare @nDays smallint

select @nRet = count(straccountid) from tb_user where straccountid = @AccountID

if @nRet = 0
begin
insert into tb_user (straccountid, strpasswd, strSocNo, idays) values (@AccountID, @password, 1, '6')
end

select @cnt = count(straccountid) from currentuser
select @nDays = count(nDays) from PREMIUM_SERVICE where straccountid = @AccountID

if @cnt > 40 and @nDays = '0'
begin
set @nRet = 0
end

if @cnt > 40 and @nDays = null
begin
set @nRet = 0
end

DECLARE @Nation tinyint
SET @Nation = 0
-- tid login method by samma 2004.02.24
DECLARE @pwd varchar(13)

SET @pwd = null

SELECT @pwd = strPasswd FROM TB_USER WHERE strAccountID = @AccountID
IF @pwd IS null
BEGIN
SET @nRet = 0
RETURN
END

ELSE IF @pwd <> @Password
BEGIN
SET @nRet = 0
RETURN
END

SELECT @Nation = bNation FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @@ROWCOUNT = 0
BEGIN
SET @nRet = 1
RETURN
END
BEGIN
SET @nRet = 1
RETURN
END
BEGIN
SET @nRet = @Nation+1
RETURN
END
GO

Nation Transfer.

Kod:
CREATE PROCEDURE [dbo].[ACCOUNT_NATION_CHANGE]
    @strAccountID as varchar(40),
    @Nation as tinyint
AS

DECLARE @strNation tinyint,@Class int,@Race int,@strCharID1 char(21), @strCharID2 char(21), @strCharID3 char(21)

SELECT @strNation = bNation,@strCharID1 = strCharID1,@strCharID2 = strCharID2,@strCharID3 = strCharID3 FROM ACCOUNT_CHAR WHERE strAccountID = @strAccountID

SET @Class = null
SET @Race = null

IF @Nation = 1 and @strNation = 2
    BEGIN

        SELECT @Class = Class,@Race = Race FROM USERDATA WHERE strUserID = @strCharID1
        IF @Class = 201 OR @Class = 205 OR @Class = 206
        BEGIN
        SET @Race = 1
        END

        IF @Class = 202 OR @Class = 207 OR @Class = 208
        BEGIN
        SET @Race = 2
        END

        IF @Class = 203 OR @Class = 209 OR @Class = 210
        BEGIN
        SET @Race = 3
        END

        IF @Class = 204 OR @Class = 211 OR @Class = 211
        BEGIN
            IF @Race = 12
            BEGIN
            SET @Race = 4
            END
            ELSE
            BEGIN
            SET @Race = 2
            END
        END
        UPDATE USERDATA SET Nation = @Nation,Race = @Race,Class = @Class - 100 WHERE strUserID = @strCharID1
        DELETE FROM KNIGHTS_USER WHERE strUserID = @strCharID1

        SELECT @Class = Class,@Race = Race FROM USERDATA WHERE strUserID = @strCharID2
        IF @Class = 201 OR @Class = 205 OR @Class = 206
        BEGIN
        SET @Race = 1
        END

        IF @Class = 202 OR @Class = 207 OR @Class = 208
        BEGIN
        SET @Race = 2
        END

        IF @Class = 203 OR @Class = 209 OR @Class = 210
        BEGIN
        SET @Race = 3
        END

        IF @Class = 204 OR @Class = 211 OR @Class = 211
        BEGIN
            IF @Race = 12
            BEGIN
            SET @Race = 4
            END
            ELSE
            BEGIN
            SET @Race = 2
            END
        END
        UPDATE USERDATA SET Nation = @Nation,Race = @Race,Class = @Class - 100 WHERE strUserID = @strCharID2
        DELETE FROM KNIGHTS_USER WHERE strUserID = @strCharID2

        SELECT @Class = Class,@Race = Race FROM USERDATA WHERE strUserID = @strCharID3
        IF @Class = 201 OR @Class = 205 OR @Class = 206
        BEGIN
        SET @Race = 1
        END

        IF @Class = 202 OR @Class = 207 OR @Class = 208
        BEGIN
        SET @Race = 2
        END

        IF @Class = 203 OR @Class = 209 OR @Class = 210
        BEGIN
        SET @Race = 3
        END

        IF @Class = 204 OR @Class = 211 OR @Class = 211
        BEGIN
            IF @Race = 12
            BEGIN
            SET @Race = 4
            END
            ELSE
            BEGIN
            SET @Race = 2
            END
        END
        UPDATE USERDATA SET Nation = @Nation,Race = @Race,Class = @Class - 100 WHERE strUserID = @strCharID3
        DELETE FROM KNIGHTS_USER WHERE strUserID = @strCharID3

        UPDATE ACCOUNT_CHAR SET bNation = @Nation WHERE strAccountID = @strAccountID
    END

IF @Nation = 2 and @strNation = 1
    BEGIN

        SELECT @Class = Class,@Race = Race FROM USERDATA WHERE strUserID = @strCharID1
        IF @Class = 101 OR @Class = 105 OR @Class = 106
        BEGIN
        SET @Race = 12
        END

        IF @Class = 102 OR @Class = 107 OR @Class = 108
        BEGIN
        SET @Race = 12
        END

        IF @Class = 103 OR @Class = 109 OR @Class = 110
        BEGIN
        SET @Race = 12
        END

        IF @Class = 104 OR @Class = 111 OR @Class = 111
        BEGIN
            IF @Race = 4
            BEGIN
            SET @Race = 12
            END
            ELSE
            BEGIN
            SET @Race = 13
            END
        END
        UPDATE USERDATA SET Nation = @Nation,Race = @Race,Class = @Class + 100 WHERE strUserID = @strCharID1
        DELETE FROM KNIGHTS_USER WHERE strUserID = @strCharID1

        SELECT @Class = Class,@Race = Race FROM USERDATA WHERE strUserID = @strCharID2
        IF @Class = 101 OR @Class = 105 OR @Class = 106
        BEGIN
        SET @Race = 12
        END

        IF @Class = 102 OR @Class = 107 OR @Class = 108
        BEGIN
        SET @Race = 12
        END

        IF @Class = 103 OR @Class = 109 OR @Class = 110
        BEGIN
        SET @Race = 12
        END

        IF @Class = 104 OR @Class = 111 OR @Class = 111
        BEGIN
            IF @Race = 4
            BEGIN
            SET @Race = 12
            END
            ELSE
            BEGIN
            SET @Race = 13
            END
        END
        UPDATE USERDATA SET Nation = @Nation,Race = @Race,Class = @Class + 100 WHERE strUserID = @strCharID2
        DELETE FROM KNIGHTS_USER WHERE strUserID = @strCharID2

        SELECT @Class = Class,@Race = Race FROM USERDATA WHERE strUserID = @strCharID3
        IF @Class = 101 OR @Class = 105 OR @Class = 106
        BEGIN
        SET @Race = 12
        END

        IF @Class = 102 OR @Class = 107 OR @Class = 108
        BEGIN
        SET @Race = 12
        END

        IF @Class = 103 OR @Class = 109 OR @Class = 110
        BEGIN
        SET @Race = 12
        END

        IF @Class = 104 OR @Class = 111 OR @Class = 111
        BEGIN
            IF @Race = 4
            BEGIN
            SET @Race = 12
            END
            ELSE
            BEGIN
            SET @Race = 13
            END
        END
        UPDATE USERDATA SET Nation = @Nation,Race = @Race,Class = @Class + 100 WHERE strUserID = @strCharID3
        DELETE FROM KNIGHTS_USER WHERE strUserID = @strCharID3

        UPDATE ACCOUNT_CHAR SET bNation = @Nation WHERE strAccountID = @strAccountID
    END
GO

Kullanım İçin.

Kod:
EXEC ACCOUNT_NATION_CHANGE 'HESABINIDSI','IRKNUMARASI'

* 1 = Karus / 2 = Human

Guard Tower Damaqelarını Ayarlamak.

Kod:
UPDATE    MAGIC_TYPE3
SET              FirstDamage = - 10000
WHERE     (iNum = 300139)

FirstDamaqe kısmını kendinize qöre ayarlayın…

Oto Grade.

Kod:
 Object Stored Procedure dbo.RANK_KNIGHTS Script Date 662006 60332 PM 

 ?? ?? ???? dbo.RANK_KNIGHTS ???? ?? 2002-11-14 ?? 111804
-- Created by sungyong 2002.10.14

 Edit by webmsn 

CREATE PROCEDURE RANK_KNIGHTS
AS
exec rank_knights
SET NOCOUNT ON
DECLARE @KnightsIndex smallint
DECLARE @SumLoyalty int
DECLARE job1 CURSOR FOR

SELECT IDNum FROM KNIGHTS

OPEN job1
FETCH NEXT FROM job1
INTO @KnightsIndex
WHILE @@fetch_status = 0

BEGIN
if @SumLoyalty is null
begin
SET @SumLoyalty = 0
end
SELECT @SumLoyalty=Sum(Loyalty) FROM USERDATA WHERE Knights = @KnightsIndex and City  255
IF @SumLoyalty  0
UPDATE KNIGHTS SET Points = @SumLoyalty WHERE IDNum = @KnightsIndex

FETCH NEXT FROM job1
INTO @KnightsIndex
END
CLOSE job1
DEALLOCATE job1
SET NOCOUNT OFF

-- ranking
UPDATE KNIGHTS SET Ranking=0 WHERE Ranking0

-- ranking procedure call
EXEC KNIGHTS_RATING_UPDATE

DECLARE @Knights_1 smallint
DECLARE @Knights_2 smallint
DECLARE @Knights_3 smallint
DECLARE @Knights_4 smallint
DECLARE @Knights_5 smallint

SELECT @Knights_1 = shIndex FROM KNIGHTS_RATING WHERE nRank=1
SELECT @Knights_2 = shIndex FROM KNIGHTS_RATING WHERE nRank=2
SELECT @Knights_3 = shIndex FROM KNIGHTS_RATING WHERE nRank=3
SELECT @Knights_4 = shIndex FROM KNIGHTS_RATING WHERE nRank=4
SELECT @Knights_5 = shIndex FROM KNIGHTS_RATING WHERE nRank=5

UPDATE KNIGHTS SET Ranking=1 WHERE IDNum=@Knights_1
UPDATE KNIGHTS SET Ranking=2 WHERE IDNum=@Knights_2
UPDATE KNIGHTS SET Ranking=3 WHERE IDNum=@Knights_3
UPDATE KNIGHTS SET Ranking=4 WHERE IDNum=@Knights_4
UPDATE KNIGHTS SET Ranking=5 WHERE IDNum=@Knights_5
GO

Characteri GM yapmak.

Kod:
 update userdata set Authority = '0'
where struserid = 'Karakter İsmi'

İstediqiniz Bir Accountdaki İtemleri Silmek.

Kod:
 UPDATE warehouse
SET WareHouseData = ''
WHERE strAccountID = 'Hesap Adı'

Banlanan Üyelerin Np’lerini Sıfırlamak.

Kod:
 UPDATE USERDATA
SET Loyalty = 0
WHERE Authority = 255

Account ßulma.

Kod:
declare @name varchar(21)
set @name = 'Karakter İsmi'

SELECT * from ACCOUNT_CHAR
where strcharid1 = @name
or strcharid2 = @name
or strcharid3 = @name


Edit Char Yapmak.

Kod:
update userdata set Class='212',Strong = '255',Sta = '255',Dex = '255',Intel = '255',Cha = '255', Level = '80',Loyalty = '13456345',Points = '255',Gold = '2100000000',strSkill='<<<<<<<<<<',LoyaltyMonthly='345634'
where struserid = 'Char ismi'

Czdeki Guard Towerları Aktif Hale Getirmek.

Kod:
6701 Guard tower 5301 100 0 0 0 5 0 22 0 0 0 100 71470 0 110245 15458 0 3445 124 124 124 2500 2 8 5000 0 0 0 83 83 83 83 83 83 83 200 5 15 20 359996 6701 0 0 0
6751 Guard tower 5401 100 0 0 0 5 0 22 0 0 0 100 71470 0 110245 15458 0 3445 124 124 124 2500 2 8 5000 0 0 0 83 83 83 83 83 83 83 200 5 15 20 359996 6751 0 0 0
9001 Elmo Guard Tower 5301 180 0 0 2 7 0 1 1 2 0 100 80000 0 500000 5000 1550 5000 500 500 5000 500 2 8 500 470276 0 0 250 250 250 250 250 250 250 90 80 90 0 10930 9001 0 0 4
9002 Elmo Guard Tower 5301 180 0 0 2 7 0 1 1 2 0 100 80000 0 500000 5000 1550 5000 500 500 5000 500 2 8 500 470276 0 0 250 250 250 250 250 250 250 90 80 90 0 10930 9002 0 0 4
9003 Karus Guard Tower 5401 180 0 0 1 7 0 1 1 2 0 100 80000 0 500000 5000 1550 5000 500 500 5000 500 2 8 500 300431 300269 110535 250 250 250 250 250 250 250 90 80 90 0 10930 9003 0 0 4
9004 Karus Guard Tower 5401 180 0 0 1 7 0 1 1 2 0 100 80000 0 500000 5000 1550 5000 500 500 5000 500 2 8 500 300431 300269 110535 250 250 250 250 250 250 250 90 80 90 0 10930 9004 0 0 4

Holy Water çeşitlerini DB’den kaldırmak.

Kod:
delete from item where num=379047000 or num=379101000 or num=379102000 or num=379103000 or num=389010000 or num=910012000

Charın Statlarını 255 Yapmak.

Kod:

update Userdata set Strong = '255'where struserid = 'Char Nick'
update Userdata set Sta = '255'where struserid = 'Char Nick'
update Userdata set Dex = '255'where struserid = 'Char Nick'
update Userdata set intel = '255'where struserid = 'Char Nick'
update Userdata set Cha = '255'where struserid = 'Char Nick'

Chara 255 skill point vermek.

Kod:
 update Userdata set strskill = 'ÿ'where struserid = 'Char Nick'

Kişiyi istediğiniz Clana Koymak.

Kod:
 update Userdata set Knights = 'Clan Nosu'where struserid = 'Char Adı'

Tüm Clanları G1 Yapmak.

Kod:
 update Knights set Points = '999999'

Tek Clanı G1 Yapmak.

Kod:
 update Knights set Points = '999999'where IDName = 'Clan Adı'

Clanların Kolluğunu Yakmak.

Kod:
 update Knights set Ranking = '1'

Tek Clanın Kolluğunu Yakmak.

Kod:
 update Knights set Ranking = '1'where IDName = 'Clan Adı'

Sundriesten Acid Potion Alınmasını EnqeLLemek.(qLiTch enqeLLemek amaçLı)

Kod:
UPDATE ITEM SET SellingGroup = 0 Where Num = 389083000

Oto Np Sembol

Kod:
 CREATE PROCEDURE otonpsimgesi AS

/* webmsn */

declare @KNP int,
@HNP int

select @KNP = nKarusLoyalty from user_knights_rank where shindex = 6
select @HNP = nElmoLoyalty from user_knights_rank where shindex = 6

truncate table npkarus
insert  npkarus
	select top 30 strUserID, Loyalty,  LoyaltyMonthly
	from USERDATA
	where Nation = 1 and Loyalty < @KNP
	order by LoyaltyMonthly desc

truncate table nphuman
insert  nphuman
	select top 30 strUserID, Loyalty,  LoyaltyMonthly
	from USERDATA
	where Nation = 2  and Loyalty < @HNP
	order by LoyaltyMonthly desc

declare @Karusa varchar(21),
@Karusb varchar(21),
@Karusc varchar(21),
@Karusd varchar(21),
@Karuse varchar(21),
@Karusf varchar(21),
@Karusg varchar(21),
@Karush varchar(21),
@Karusi varchar(21),
@Karusj varchar(21),
@Karusk varchar(21),
@Karusl varchar(21),
@Karusm varchar(21),
@Karusn varchar(21),
@Karusu varchar(21),
@Karusv varchar(21),
@Karusy varchar(21),
@Karusx varchar(21),
@Karusw varchar(21),
@Karusz varchar(21),
@Karusab varchar(21),
@Karusac varchar(21),
@Karusad varchar(21),
@Karusae varchar(21),
@Karusaf varchar(21),
@Karusag varchar(21),
@Karusah varchar(21),
@Karusai varchar(21),
@Karusaj varchar(21),
@Karusak varchar(21),
@Elmoa varchar(21),
@Elmob varchar(21),
@Elmoc varchar(21),
@Elmod varchar(21),
@Elmoe varchar(21),
@Elmof varchar(21),
@Elmog varchar(21),
@Elmoh varchar(21),
@Elmoi varchar(21),
@Elmoj varchar(21),
@Elmok varchar(21),
@Elmol varchar(21),
@Elmom varchar(21),
@Elmon varchar(21),
@Elmou varchar(21),
@Elmov varchar(21),
@Elmoy varchar(21),
@Elmox varchar(21),
@Elmow varchar(21),
@Elmoz varchar(21),
@Elmoab varchar(21),
@Elmoac varchar(21),
@Elmoad varchar(21),
@Elmoae varchar(21),
@Elmoaf varchar(21),
@Elmoag varchar(21),
@Elmoah varchar(21),
@Elmoai varchar(21),
@Elmoaj varchar(21),
@Elmoak varchar(21)

select  @Karusa = strUserID from npkarus where nRank = 1
select  @Karusb = strUserID from npkarus where nRank = 2
select  @Karusc = strUserID from npkarus where nRank = 3
select  @Karusd = strUserID from npkarus where nRank = 4
select  @Karuse = strUserID from npkarus where nRank = 5
select  @Karusf = strUserID from npkarus where nRank = 6
select  @Karusg = strUserID from npkarus where nRank = 7
select  @Karush = strUserID from npkarus where nRank = 8
select  @Karusi = strUserID from npkarus where nRank = 9
select  @Karusj = strUserID from npkarus where nRank = 10
select  @Karusk = strUserID from npkarus where nRank = 11
select  @Karusl = strUserID from npkarus where nRank = 12
select  @Karusm = strUserID from npkarus where nRank = 13
select  @Karusn = strUserID from npkarus where nRank = 14
select  @Karusu = strUserID from npkarus where nRank = 15
select  @Karusv = strUserID from npkarus where nRank = 16
select  @Karusy = strUserID from npkarus where nRank = 17
select  @Karusx = strUserID from npkarus where nRank = 18
select  @Karusw = strUserID from npkarus where nRank = 19
select  @Karusz = strUserID from npkarus where nRank = 20
select  @Karusab = strUserID from npkarus where nRank = 21
select  @Karusac = strUserID from npkarus where nRank = 22
select  @Karusad = strUserID from npkarus where nRank = 23
select  @Karusae = strUserID from npkarus where nRank = 24
select  @Karusaf = strUserID from npkarus where nRank = 25
select  @Karusag = strUserID from npkarus where nRank = 26
select  @Karusah = strUserID from npkarus where nRank = 27
select  @Karusai = strUserID from npkarus where nRank = 28
select  @Karusaj = strUserID from npkarus where nRank = 29
select  @Karusak = strUserID from npkarus where nRank = 30
select  @Elmoa = strUserID from nphuman where nRank = 1
select  @Elmob = strUserID from nphuman where nRank = 2
select  @Elmoc = strUserID from nphuman where nRank = 3
select  @Elmod = strUserID from nphuman where nRank = 4
select  @Elmoe = strUserID from nphuman where nRank = 5
select  @Elmof = strUserID from nphuman where nRank = 6
select  @Elmog = strUserID from nphuman where nRank = 7
select  @Elmoh = strUserID from nphuman where nRank = 8
select  @Elmoi = strUserID from nphuman where nRank = 9
select  @Elmoj = strUserID from nphuman where nRank = 10
select  @Elmok = strUserID from nphuman where nRank = 11
select  @Elmol = strUserID from nphuman where nRank = 12
select  @Elmom = strUserID from nphuman where nRank = 13
select  @Elmon = strUserID from nphuman where nRank = 14
select  @Elmou = strUserID from nphuman where nRank = 15
select  @Elmov = strUserID from nphuman where nRank = 16
select  @Elmoy = strUserID from nphuman where nRank = 17
select  @Elmox = strUserID from nphuman where nRank = 18
select  @Elmow = strUserID from nphuman where nRank = 19
select  @Elmoz = strUserID from nphuman where nRank = 20
select  @Elmoab = strUserID from nphuman where nRank = 21
select  @Elmoac = strUserID from nphuman where nRank = 22
select  @Elmoad = strUserID from nphuman where nRank = 23
select  @Elmoae = strUserID from nphuman where nRank = 24
select  @Elmoaf = strUserID from nphuman where nRank = 25
select  @Elmoag = strUserID from nphuman where nRank = 26
select  @Elmoah = strUserID from nphuman where nRank = 27
select  @Elmoai = strUserID from nphuman where nRank = 28
select  @Elmoaj = strUserID from nphuman where nRank = 29
select  @Elmoak = strUserID from nphuman where nRank = 30

/* Güncelleme Yapıyoruz */

update user_personal_rank set strElmoUserID = @Elmoa, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoa), strKarusUserID = @karusa, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusa) where nRank = 1
update user_personal_rank set strElmoUserID = @Elmob, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmob), strKarusUserID = @karusb, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusb) where nRank = 2
update user_personal_rank set strElmoUserID = @Elmoc, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoc), strKarusUserID = @karusc, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusc) where nRank = 3
update user_personal_rank set strElmoUserID = @Elmod, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmod), strKarusUserID = @karusd, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusd) where nRank = 4
update user_personal_rank set strElmoUserID = @Elmoe, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoe), strKarusUserID = @karuse, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karuse) where nRank = 5
update user_personal_rank set strElmoUserID = @Elmof, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmof), strKarusUserID = @karusf, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusf) where nRank = 6
update user_personal_rank set strElmoUserID = @Elmog, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmog), strKarusUserID = @karusg, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusg) where nRank = 7
update user_personal_rank set strElmoUserID = @Elmoh, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoh), strKarusUserID = @karush, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karush) where nRank = 8
update user_personal_rank set strElmoUserID = @Elmoi, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoi), strKarusUserID = @karusi, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusi) where nRank = 9
update user_personal_rank set strElmoUserID = @Elmoj, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoj), strKarusUserID = @karusj, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusj) where nRank = 10
update user_personal_rank set strElmoUserID = @Elmok, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmok), strKarusUserID = @karusk, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusk) where nRank = 11
update user_personal_rank set strElmoUserID = @Elmol, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmol), strKarusUserID = @karusl, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusl) where nRank = 12
update user_personal_rank set strElmoUserID = @Elmom, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmom), strKarusUserID = @karusm, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusm) where nRank = 13
update user_personal_rank set strElmoUserID = @Elmon, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmon), strKarusUserID = @karusn, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusn) where nRank = 14
update user_personal_rank set strElmoUserID = @Elmou, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmou), strKarusUserID = @karusu, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusu) where nRank = 15
update user_personal_rank set strElmoUserID = @Elmov, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmov), strKarusUserID = @karusv, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusv) where nRank = 16
update user_personal_rank set strElmoUserID = @Elmoy, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoy), strKarusUserID = @karusy, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusy) where nRank = 17
update user_personal_rank set strElmoUserID = @Elmox, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmox), strKarusUserID = @karusx, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusx) where nRank = 18
update user_personal_rank set strElmoUserID = @Elmow, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmow), strKarusUserID = @karusw, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusw) where nRank = 19
update user_personal_rank set strElmoUserID = @Elmoz, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoz), strKarusUserID = @karusz, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusz) where nRank = 20
update user_personal_rank set strElmoUserID = @Elmoab, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoab), strKarusUserID = @karusab, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusab) where nRank = 21
update user_personal_rank set strElmoUserID = @Elmoac, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoac), strKarusUserID = @karusac, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusac) where nRank = 22
update user_personal_rank set strElmoUserID = @Elmoad, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoad), strKarusUserID = @karusad, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusad) where nRank = 23
update user_personal_rank set strElmoUserID = @Elmoae, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoae), strKarusUserID = @karusae, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusae) where nRank = 24
update user_personal_rank set strElmoUserID = @Elmoaf, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoaf), strKarusUserID = @karusaf, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusaf) where nRank = 25
update user_personal_rank set strElmoUserID = @Elmoag, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoag), strKarusUserID = @karusag, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusag) where nRank = 26
update user_personal_rank set strElmoUserID = @Elmoah, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoah), strKarusUserID = @karusah, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusah) where nRank = 27
update user_personal_rank set strElmoUserID = @Elmoai, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoai), strKarusUserID = @karusai, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusai) where nRank = 28
update user_personal_rank set strElmoUserID = @Elmoaj, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoaj), strKarusUserID = @karusaj, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusaj) where nRank = 29
update user_personal_rank set strElmoUserID = @Elmoak, nElmoLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @Elmoak), strKarusUserID = @karusak, nKarusLoyaltyMonthly = (select LoyaltyMonthly from userdata where struserid = @karusak) where nRank = 30
GO

Oto Np Sembolu (Adım 2)

Kod:
 			 				create table [nphuman]
(
    [nRank] [int] IDENTITY (1, 1) NOT NULL ,
    [strUserID] char(21) NOT NULL,
    [Loyalty] int NOT NULL,
    [LoyaltyMonthly] int NOT NULL,
)

create table [npkarus]
(
    [nRank] [int] IDENTITY (1, 1) NOT NULL ,
    [strUserID] char(21) NOT NULL,
    [Loyalty] int NOT NULL,
    [LoyaltyMonthly] int NOT NULL,
)

Oto Np Sembolu(Adım 3)

Kod:
 			 				exec imbacodermyst
exec Rank_Knights
exec np_icon

UserLara Np Eklemek.

Kod:
 UPDATE    USERDATA
 SET              Loyalty = Loyalty + 50000

50000′i kendinize qöre ayarlayın.

Okçu Skill ßuquna Çözüm(32k wurmaya)

Kod:
update MAGIC_TYPE2
set AddDamagePlus = 1
where NeedArrow = 1 or NeedArrow = 3 or NeedArrow = 5

Benzer Yazılar

  • CS'nin Yapımcısından Harika Savaş Oyunu Swat 4
  • Sorunsuz Bir Spy Temizleme Programı AVG Anti-Spyware
  • Online Tavla Oyunu - Ücretsiz Tavla Oyunu
  • Strateji Oyunu Rise of Nations
  • Andretti Racing 3D Formula Yarışı
  • Bir Başka 1299 Ko Dbsi
  • Abexo Registry Cleaner
  • Aksiyon RPG Arx Fatalis
  • Object Wipe 1.7
  • Grafik Programı Picasa 3.1

    • Etiketler: , , , , , , ,

    Bu konuyu Googleda ara: Query Analyzer Kodları

    Şuan buradasınız: Query Analyzer Kodları

    Translate : English  German  Italian  Greek  France  Polish  Russian  Spannish  Ukrainian  Bulgarian  Dutch  Finnish  Hindi  Japanese  Norwegian 
    Bookmark : Google Facebookhspace=2 slashdot YahooMyWeb Digg Technorati Delicious Yumile Live Oyyla Reddit Furl Tusul Bagcik

    1. 3 Yorum Yapılmış “Query Analyzer Kodları”

    2. kardeşş sen bunları nasıl yapacağımızı msn den anlatabilirmisinm?
      bilen biri varsa o da onlatabilir

      Yorum Yapan: ertugrul Tarih: Tem 2, 2008

    3. Gercekten Cok Guzel Eline Saglık.

      Yorum Yapan: Aykut Tarih: Ağu 10, 2008

    4. Gerçekten eline saglık ama keşke bide yazıları kopyalıya bilsekkk

      Yorum Yapan: burak Tarih: Mar 20, 2009

    Yorum Ekle

    We love Google | Wordpress | RSS | okey oyna | okey oyna