Orjinal Sorunsuz +5 +10 Pk Database Para İle Satılan- Özel Paylaşım(KO-FOX)

ergun35 · 24 Eylül 2019

bu doğru bişe olsa bari

CheSeT3333 · 4 Ekim 2019

+++++++

memo03 · 12 Ekim 2019

Genel Özellikler

+5 +10 FULL BAŞLANGIC + BANKA + TÜM JOBLAR KROWAZ İTEM BAŞLAR

SPEACİAL EVENT

GEMİ SAVAŞI

OTO GRADE

EVENT MANAGER 1VS BDW JR

SNOW WAR

DARK LUNAR

DELOS

LUNAR

%100 SORUNSUZ HERŞEY FİX

Resimler

Banka Başlangıç İçim Prosödur Kod :

Kod:

CREATE PROCEDURE CREATE_NEW_CHAR





@nRet smallint OUTPUT,

@AccountID char(21),

@index tinyint,

@CharID char(21),

@Race tinyint,

@Class smallint,

@Hair tinyint,

@Face tinyint,

@Str tinyint,

@Sta tinyint,

@Dex tinyint,

@Intel tinyint,

@Cha tinyint





AS





DECLARE @Row tinyint, @Nation tinyint, @Zone tinyint, @PosX int, @PosZ int

SET @Row = 0 SET @Nation = 0 SET @Zone = 0 SET @PosX = 0 SET @PosZ = 0





SELECT @Nation = bNation, @Row = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID





IF @Row >= 5 SET @nRet = 1





IF @Nation = 1 AND @Race > 10 SET @nRet = 2

ELSE IF @Nation = 2 AND @Race < 10 SET @nRet = 2

ELSE IF @Nation <>1 AND @Nation <> 2 SET @nRet = 2





IF @nRet > 0

RETURN





SELECT @Row = COUNT(*) FROM USERDATA WHERE strUserId = @CharID

IF @Row > 0

BEGIN

SET @nRet = 3

RETURN

END









SET @Zone=21

SELECT @PosX = InitX, @PosZ = InitZ FROM ZONE_INFO WHERE ZoneNo = @Zone





select @row = 3

if @CharID like '%___%'

if @CharID like '%_%'

if @CharID like '%__%'

if @CharID like '%:%'

if @CharID like '%::%'

if @CharID like '%asd%'

if @CharID like '%gm%'

if @CharID like '%ananı%'

if @CharID like '%____%'





begin

SET @nRet = 3

RETURN









END

BEGIN TRAN

IF @index = 0

UPDATE ACCOUNT_CHAR SET strCharID1 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 1

UPDATE ACCOUNT_CHAR SET strCharID2 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 2

UPDATE ACCOUNT_CHAR SET strCharID3 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 3

UPDATE ACCOUNT_CHAR SET strCharID4 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 4

UPDATE ACCOUNT_CHAR SET strCharID5 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID









INSERT INTO USERDATA (strUserId, Nation, Race, Class, HairColor, Face, Strong, Sta, Dex, Intel, Cha, Zone, PX, PZ )

VALUES (@CharID, @Nation, @Race, @Class, @Hair, @Face, @Str, @Sta, @Dex, @Intel, @Cha, @Zone, @PosX, @PosZ )





exec baslangicitem @CharID





update userdata set Class = 106 , strong = '255' , sta = '180' ,strskill = '”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 101

update userdata set Class = 108 , strong = '71' , dex = '255' , sta = '169' ,strskill ='”' , [level] = '83' , hp ='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 102

update userdata set Class = 110 , strong = '71' , sta = '100' , cha = '194' , intel = '162' ,strskill ='”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 103

update userdata set Class = 112 , strong = '110' , sta = '120' , intel = '230' ,strskill ='”' , [level] = '83' where struserid = @CharID and @Class = 104

update userdata set Class = 206 , strong = '255' , sta = '180' ,strskill ='”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 201

update userdata set Class = 208 , strong = '71' , dex = '255' , sta = '169' ,strskill ='”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 202

update userdata set Class = 210 , strong = '71' , sta = '100' , cha = '194' , intel = '162' ,strskill ='”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 203

update userdata set Class = 212 , strong = '110' , sta = '120' , intel = '230' ,strskill ='”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 204









update userdata set Class = 106 where struserid = @CharID and @Class = 101

update userdata set Class = 108 where struserid = @CharID and @Class = 102

update userdata set Class = 110 where struserid = @CharID and @Class = 103

update userdata set Class = 112 where struserid = @CharID and @Class = 104

update userdata set Class = 206 where struserid = @CharID and @Class = 201

update userdata set Class = 208 where struserid = @CharID and @Class = 202

update userdata set Class = 210 where struserid = @CharID and @Class = 203

update userdata set Class = 212 where struserid = @CharID and @Class = 204





IF @@ERROR <> 0

BEGIN

ROLLBACK TRAN

SET @nRet = 4

RETURN

END





COMMIT TRAN

SET @nRet = 0





GO

Dowuland : :***Hidden content cannot be quoted.***

tesekkurlet denıyecegım

fenaki · 17 Ekim 2019

saol lan

KingRoyaL · 24 Ekim 2019

sadddddddddddddddddddddddddddd

c6273567 · 26 Ekim 2019

teşekkürler

alptunga · 28 Ekim 2019

aqoRa' Alıntı:

Genel Özellikler

+5 +10 FULL BAŞLANGIC + BANKA + TÜM JOBLAR KROWAZ İTEM BAŞLAR

SPEACİAL EVENT

GEMİ SAVAŞI

OTO GRADE

EVENT MANAGER 1VS BDW JR

SNOW WAR

DARK LUNAR

DELOS

LUNAR

%100 SORUNSUZ HERŞEY FİX

Resimler

Banka Başlangıç İçim Prosödur Kod :

Kod:

CREATE PROCEDURE CREATE_NEW_CHAR





@nRet smallint OUTPUT,

@AccountID char(21),

@index tinyint,

@CharID char(21),

@Race tinyint,

@Class smallint,

@Hair tinyint,

@Face tinyint,

@Str tinyint,

@Sta tinyint,

@Dex tinyint,

@Intel tinyint,

@Cha tinyint





AS





DECLARE @Row tinyint, @Nation tinyint, @Zone tinyint, @PosX int, @PosZ int

SET @Row = 0 SET @Nation = 0 SET @Zone = 0 SET @PosX = 0 SET @PosZ = 0





SELECT @Nation = bNation, @Row = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID





IF @Row >= 5 SET @nRet = 1





IF @Nation = 1 AND @Race > 10 SET @nRet = 2

ELSE IF @Nation = 2 AND @Race < 10 SET @nRet = 2

ELSE IF @Nation <>1 AND @Nation <> 2 SET @nRet = 2





IF @nRet > 0

RETURN





SELECT @Row = COUNT(*) FROM USERDATA WHERE strUserId = @CharID

IF @Row > 0

BEGIN

SET @nRet = 3

RETURN

END









SET @Zone=21

SELECT @PosX = InitX, @PosZ = InitZ FROM ZONE_INFO WHERE ZoneNo = @Zone





select @row = 3

if @CharID like '%___%'

if @CharID like '%_%'

if @CharID like '%__%'

if @CharID like '%:%'

if @CharID like '%::%'

if @CharID like '%asd%'

if @CharID like '%gm%'

if @CharID like '%ananı%'

if @CharID like '%____%'





begin

SET @nRet = 3

RETURN









END

BEGIN TRAN

IF @index = 0

UPDATE ACCOUNT_CHAR SET strCharID1 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 1

UPDATE ACCOUNT_CHAR SET strCharID2 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 2

UPDATE ACCOUNT_CHAR SET strCharID3 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 3

UPDATE ACCOUNT_CHAR SET strCharID4 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 4

UPDATE ACCOUNT_CHAR SET strCharID5 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID









INSERT INTO USERDATA (strUserId, Nation, Race, Class, HairColor, Face, Strong, Sta, Dex, Intel, Cha, Zone, PX, PZ )

VALUES (@CharID, @Nation, @Race, @Class, @Hair, @Face, @Str, @Sta, @Dex, @Intel, @Cha, @Zone, @PosX, @PosZ )





exec baslangicitem @CharID





update userdata set Class = 106 , strong = '255' , sta = '180' ,strskill = '”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 101

update userdata set Class = 108 , strong = '71' , dex = '255' , sta = '169' ,strskill ='”' , [level] = '83' , hp ='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 102

update userdata set Class = 110 , strong = '71' , sta = '100' , cha = '194' , intel = '162' ,strskill ='”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 103

update userdata set Class = 112 , strong = '110' , sta = '120' , intel = '230' ,strskill ='”' , [level] = '83' where struserid = @CharID and @Class = 104

update userdata set Class = 206 , strong = '255' , sta = '180' ,strskill ='”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 201

update userdata set Class = 208 , strong = '71' , dex = '255' , sta = '169' ,strskill ='”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 202

update userdata set Class = 210 , strong = '71' , sta = '100' , cha = '194' , intel = '162' ,strskill ='”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 203

update userdata set Class = 212 , strong = '110' , sta = '120' , intel = '230' ,strskill ='”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 204









update userdata set Class = 106 where struserid = @CharID and @Class = 101

update userdata set Class = 108 where struserid = @CharID and @Class = 102

update userdata set Class = 110 where struserid = @CharID and @Class = 103

update userdata set Class = 112 where struserid = @CharID and @Class = 104

update userdata set Class = 206 where struserid = @CharID and @Class = 201

update userdata set Class = 208 where struserid = @CharID and @Class = 202

update userdata set Class = 210 where struserid = @CharID and @Class = 203

update userdata set Class = 212 where struserid = @CharID and @Class = 204





IF @@ERROR <> 0

BEGIN

ROLLBACK TRAN

SET @nRet = 4

RETURN

END





COMMIT TRAN

SET @nRet = 0





GO

Dowuland : :***Hidden content cannot be quoted.***

tolghn59 · 2 Kasım 2019

güzel paylaşım

bufyoktur0 · 6 Kasım 2019

Cevap: Sorunsuz Kurulum İçin Tüm Gerekli Dosyalar l

Cevap: Sorunsuz Kurulum İçin Tüm Gerekli Dosyalar l

konetwork · 8 Kasım 2019

teşekkürlerer

KingRoyaL · 8 Aralık 2019

wwwwwwwwwwwwwwwwwwwww

eastanbul06 · 12 Aralık 2019

fallen06 · 17 Aralık 2019

TEŞEKKÜRLER

Mromar · 21 Aralık 2019

huohuyiuyiuy

VedatY · 5 Şubat 2020

+++++++++++++++++++

muhammet2008 · 29 Kasım 2023

aqoRa' Alıntı:

Genel Özellikler

+5 +10 FULL BAŞLANGIC + BANKA + TÜM JOBLAR KROWAZ İTEM BAŞLAR

SPEACİAL EVENT

GEMİ SAVAŞI

OTO GRADE

EVENT MANAGER 1VS BDW JR

SNOW WAR

DARK LUNAR

DELOS

LUNAR

%100 SORUNSUZ HERŞEY FİX

Resimler

Banka Başlangıç İçim Prosödur Kod :

Kod:

CREATE PROCEDURE CREATE_NEW_CHAR





@nRet smallint OUTPUT,

@AccountID char(21),

@index tinyint,

@CharID char(21),

@Race tinyint,

@Class smallint,

@Hair tinyint,

@Face tinyint,

@Str tinyint,

@Sta tinyint,

@Dex tinyint,

@Intel tinyint,

@Cha tinyint





AS





DECLARE @Row tinyint, @Nation tinyint, @Zone tinyint, @PosX int, @PosZ int

SET @Row = 0 SET @Nation = 0 SET @Zone = 0 SET @PosX = 0 SET @PosZ = 0





SELECT @Nation = bNation, @Row = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID





IF @Row >= 5 SET @nRet = 1





IF @Nation = 1 AND @Race > 10 SET @nRet = 2

ELSE IF @Nation = 2 AND @Race < 10 SET @nRet = 2

ELSE IF @Nation <>1 AND @Nation <> 2 SET @nRet = 2





IF @nRet > 0

RETURN





SELECT @Row = COUNT(*) FROM USERDATA WHERE strUserId = @CharID

IF @Row > 0

BEGIN

SET @nRet = 3

RETURN

END









SET @Zone=21

SELECT @PosX = InitX, @PosZ = InitZ FROM ZONE_INFO WHERE ZoneNo = @Zone





select @row = 3

if @CharID like '%___%'

if @CharID like '%_%'

if @CharID like '%__%'

if @CharID like '%:%'

if @CharID like '%::%'

if @CharID like '%asd%'

if @CharID like '%gm%'

if @CharID like '%ananı%'

if @CharID like '%____%'





begin

SET @nRet = 3

RETURN









END

BEGIN TRAN

IF @index = 0

UPDATE ACCOUNT_CHAR SET strCharID1 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 1

UPDATE ACCOUNT_CHAR SET strCharID2 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 2

UPDATE ACCOUNT_CHAR SET strCharID3 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 3

UPDATE ACCOUNT_CHAR SET strCharID4 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 4

UPDATE ACCOUNT_CHAR SET strCharID5 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID









INSERT INTO USERDATA (strUserId, Nation, Race, Class, HairColor, Face, Strong, Sta, Dex, Intel, Cha, Zone, PX, PZ )

VALUES (@CharID, @Nation, @Race, @Class, @Hair, @Face, @Str, @Sta, @Dex, @Intel, @Cha, @Zone, @PosX, @PosZ )





exec baslangicitem @CharID





update userdata set Class = 106 , strong = '255' , sta = '180' ,strskill = '”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 101

update userdata set Class = 108 , strong = '71' , dex = '255' , sta = '169' ,strskill ='”' , [level] = '83' , hp ='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 102

update userdata set Class = 110 , strong = '71' , sta = '100' , cha = '194' , intel = '162' ,strskill ='”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 103

update userdata set Class = 112 , strong = '110' , sta = '120' , intel = '230' ,strskill ='”' , [level] = '83' where struserid = @CharID and @Class = 104

update userdata set Class = 206 , strong = '255' , sta = '180' ,strskill ='”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 201

update userdata set Class = 208 , strong = '71' , dex = '255' , sta = '169' ,strskill ='”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 202

update userdata set Class = 210 , strong = '71' , sta = '100' , cha = '194' , intel = '162' ,strskill ='”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 203

update userdata set Class = 212 , strong = '110' , sta = '120' , intel = '230' ,strskill ='”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 204









update userdata set Class = 106 where struserid = @CharID and @Class = 101

update userdata set Class = 108 where struserid = @CharID and @Class = 102

update userdata set Class = 110 where struserid = @CharID and @Class = 103

update userdata set Class = 112 where struserid = @CharID and @Class = 104

update userdata set Class = 206 where struserid = @CharID and @Class = 201

update userdata set Class = 208 where struserid = @CharID and @Class = 202

update userdata set Class = 210 where struserid = @CharID and @Class = 203

update userdata set Class = 212 where struserid = @CharID and @Class = 204





IF @@ERROR <> 0

BEGIN

ROLLBACK TRAN

SET @nRet = 4

RETURN

END





COMMIT TRAN

SET @nRet = 0





GO

Dowuland : :[Gizli içerik]

gungor1324 · 3 Mart 2024

aqoRa' Alıntı:

Genel Özellikler

+5 +10 FULL BAŞLANGIC + BANKA + TÜM JOBLAR KROWAZ İTEM BAŞLAR

SPEACİAL EVENT

GEMİ SAVAŞI

OTO GRADE

EVENT MANAGER 1VS BDW JR

SNOW WAR

DARK LUNAR

DELOS

LUNAR

%100 SORUNSUZ HERŞEY FİX

Resimler

Banka Başlangıç İçim Prosödur Kod :

Kod:

CREATE PROCEDURE CREATE_NEW_CHAR





@nRet smallint OUTPUT,

@AccountID char(21),

@index tinyint,

@CharID char(21),

@Race tinyint,

@Class smallint,

@Hair tinyint,

@Face tinyint,

@Str tinyint,

@Sta tinyint,

@Dex tinyint,

@Intel tinyint,

@Cha tinyint





AS





DECLARE @Row tinyint, @Nation tinyint, @Zone tinyint, @PosX int, @PosZ int

SET @Row = 0 SET @Nation = 0 SET @Zone = 0 SET @PosX = 0 SET @PosZ = 0





SELECT @Nation = bNation, @Row = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID





IF @Row >= 5 SET @nRet = 1





IF @Nation = 1 AND @Race > 10 SET @nRet = 2

ELSE IF @Nation = 2 AND @Race < 10 SET @nRet = 2

ELSE IF @Nation <>1 AND @Nation <> 2 SET @nRet = 2





IF @nRet > 0

RETURN





SELECT @Row = COUNT(*) FROM USERDATA WHERE strUserId = @CharID

IF @Row > 0

BEGIN

SET @nRet = 3

RETURN

END









SET @Zone=21

SELECT @PosX = InitX, @PosZ = InitZ FROM ZONE_INFO WHERE ZoneNo = @Zone





select @row = 3

if @CharID like '%___%'

if @CharID like '%_%'

if @CharID like '%__%'

if @CharID like '%:%'

if @CharID like '%::%'

if @CharID like '%asd%'

if @CharID like '%gm%'

if @CharID like '%ananı%'

if @CharID like '%____%'





begin

SET @nRet = 3

RETURN









END

BEGIN TRAN

IF @index = 0

UPDATE ACCOUNT_CHAR SET strCharID1 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 1

UPDATE ACCOUNT_CHAR SET strCharID2 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 2

UPDATE ACCOUNT_CHAR SET strCharID3 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 3

UPDATE ACCOUNT_CHAR SET strCharID4 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 4

UPDATE ACCOUNT_CHAR SET strCharID5 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID









INSERT INTO USERDATA (strUserId, Nation, Race, Class, HairColor, Face, Strong, Sta, Dex, Intel, Cha, Zone, PX, PZ )

VALUES (@CharID, @Nation, @Race, @Class, @Hair, @Face, @Str, @Sta, @Dex, @Intel, @Cha, @Zone, @PosX, @PosZ )





exec baslangicitem @CharID





update userdata set Class = 106 , strong = '255' , sta = '180' ,strskill = '”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 101

update userdata set Class = 108 , strong = '71' , dex = '255' , sta = '169' ,strskill ='”' , [level] = '83' , hp ='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 102

update userdata set Class = 110 , strong = '71' , sta = '100' , cha = '194' , intel = '162' ,strskill ='”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 103

update userdata set Class = 112 , strong = '110' , sta = '120' , intel = '230' ,strskill ='”' , [level] = '83' where struserid = @CharID and @Class = 104

update userdata set Class = 206 , strong = '255' , sta = '180' ,strskill ='”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 201

update userdata set Class = 208 , strong = '71' , dex = '255' , sta = '169' ,strskill ='”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 202

update userdata set Class = 210 , strong = '71' , sta = '100' , cha = '194' , intel = '162' ,strskill ='”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 203

update userdata set Class = 212 , strong = '110' , sta = '120' , intel = '230' ,strskill ='”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 204









update userdata set Class = 106 where struserid = @CharID and @Class = 101

update userdata set Class = 108 where struserid = @CharID and @Class = 102

update userdata set Class = 110 where struserid = @CharID and @Class = 103

update userdata set Class = 112 where struserid = @CharID and @Class = 104

update userdata set Class = 206 where struserid = @CharID and @Class = 201

update userdata set Class = 208 where struserid = @CharID and @Class = 202

update userdata set Class = 210 where struserid = @CharID and @Class = 203

update userdata set Class = 212 where struserid = @CharID and @Class = 204





IF @@ERROR <> 0

BEGIN

ROLLBACK TRAN

SET @nRet = 4

RETURN

END





COMMIT TRAN

SET @nRet = 0





GO

Dowuland : :[Gizli içerik]

Teşekkürler.

srcn01 · 13 Nisan 2024

aqoRa' Alıntı:

Genel Özellikler

+5 +10 FULL BAŞLANGIC + BANKA + TÜM JOBLAR KROWAZ İTEM BAŞLAR

SPEACİAL EVENT

GEMİ SAVAŞI

OTO GRADE

EVENT MANAGER 1VS BDW JR

SNOW WAR

DARK LUNAR

DELOS

LUNAR

%100 SORUNSUZ HERŞEY FİX

Resimler

Banka Başlangıç İçim Prosödur Kod :

Kod:

CREATE PROCEDURE CREATE_NEW_CHAR





@nRet smallint OUTPUT,

@AccountID char(21),

@index tinyint,

@CharID char(21),

@Race tinyint,

@Class smallint,

@Hair tinyint,

@Face tinyint,

@Str tinyint,

@Sta tinyint,

@Dex tinyint,

@Intel tinyint,

@Cha tinyint





AS





DECLARE @Row tinyint, @Nation tinyint, @Zone tinyint, @PosX int, @PosZ int

SET @Row = 0 SET @Nation = 0 SET @Zone = 0 SET @PosX = 0 SET @PosZ = 0





SELECT @Nation = bNation, @Row = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID





IF @Row >= 5 SET @nRet = 1





IF @Nation = 1 AND @Race > 10 SET @nRet = 2

ELSE IF @Nation = 2 AND @Race < 10 SET @nRet = 2

ELSE IF @Nation <>1 AND @Nation <> 2 SET @nRet = 2





IF @nRet > 0

RETURN





SELECT @Row = COUNT(*) FROM USERDATA WHERE strUserId = @CharID

IF @Row > 0

BEGIN

SET @nRet = 3

RETURN

END









SET @Zone=21

SELECT @PosX = InitX, @PosZ = InitZ FROM ZONE_INFO WHERE ZoneNo = @Zone





select @row = 3

if @CharID like '%___%'

if @CharID like '%_%'

if @CharID like '%__%'

if @CharID like '%:%'

if @CharID like '%::%'

if @CharID like '%asd%'

if @CharID like '%gm%'

if @CharID like '%ananı%'

if @CharID like '%____%'





begin

SET @nRet = 3

RETURN









END

BEGIN TRAN

IF @index = 0

UPDATE ACCOUNT_CHAR SET strCharID1 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 1

UPDATE ACCOUNT_CHAR SET strCharID2 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 2

UPDATE ACCOUNT_CHAR SET strCharID3 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 3

UPDATE ACCOUNT_CHAR SET strCharID4 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

ELSE IF @index = 4

UPDATE ACCOUNT_CHAR SET strCharID5 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID









INSERT INTO USERDATA (strUserId, Nation, Race, Class, HairColor, Face, Strong, Sta, Dex, Intel, Cha, Zone, PX, PZ )

VALUES (@CharID, @Nation, @Race, @Class, @Hair, @Face, @Str, @Sta, @Dex, @Intel, @Cha, @Zone, @PosX, @PosZ )





exec baslangicitem @CharID





update userdata set Class = 106 , strong = '255' , sta = '180' ,strskill = '”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 101

update userdata set Class = 108 , strong = '71' , dex = '255' , sta = '169' ,strskill ='”' , [level] = '83' , hp ='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 102

update userdata set Class = 110 , strong = '71' , sta = '100' , cha = '194' , intel = '162' ,strskill ='”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 103

update userdata set Class = 112 , strong = '110' , sta = '120' , intel = '230' ,strskill ='”' , [level] = '83' where struserid = @CharID and @Class = 104

update userdata set Class = 206 , strong = '255' , sta = '180' ,strskill ='”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 201

update userdata set Class = 208 , strong = '71' , dex = '255' , sta = '169' ,strskill ='”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 202

update userdata set Class = 210 , strong = '71' , sta = '100' , cha = '194' , intel = '162' ,strskill ='”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 203

update userdata set Class = 212 , strong = '110' , sta = '120' , intel = '230' ,strskill ='”' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 204









update userdata set Class = 106 where struserid = @CharID and @Class = 101

update userdata set Class = 108 where struserid = @CharID and @Class = 102

update userdata set Class = 110 where struserid = @CharID and @Class = 103

update userdata set Class = 112 where struserid = @CharID and @Class = 104

update userdata set Class = 206 where struserid = @CharID and @Class = 201

update userdata set Class = 208 where struserid = @CharID and @Class = 202

update userdata set Class = 210 where struserid = @CharID and @Class = 203

update userdata set Class = 212 where struserid = @CharID and @Class = 204





IF @@ERROR <> 0

BEGIN

ROLLBACK TRAN

SET @nRet = 4

RETURN

END





COMMIT TRAN

SET @nRet = 0





GO

Dowuland : :[Gizli içerik]

çallısıyor mu hala

Orjinal Sorunsuz +5 +10 Pk Database Para İle Satılan- Özel Paylaşım(KO-FOX)

ergun35

Yeni Cüce

CheSeT3333

Yeni Cüce

memo03

Yeni Cüce

fenaki

Yeni Cüce

KingRoyaL

c6273567

Yeni Cüce

alptunga

Kayıtlı Üye

tolghn59

Yeni Cüce

bufyoktur0

Yeni Cüce

konetwork

Kayıtlı Üye

KingRoyaL

eastanbul06

Yeni Cüce

fallen06

Mromar

Yeni Cüce

VedatY

Yeni Cüce

muhammet2008

Kayıtlı Üye

gungor1324

Yeni Cüce

srcn01

Yeni Cüce

Online istatistikleri

Ko-Cuce Links

En yeni üyeler

Orjinal Sorunsuz +5 +10 Pk Database Para İle Satılan- Özel Paylaşım(KO-FOX)

Yeni Cüce

Yeni Cüce

Yeni Cüce

Yeni Cüce

Yeni Cüce

Kayıtlı Üye

Yeni Cüce

Yeni Cüce

Kayıtlı Üye

Yeni Cüce

Yeni Cüce

Yeni Cüce

Kayıtlı Üye

Yeni Cüce

Yeni Cüce

Online istatistikleri

Ko-Cuce Links

En yeni üyeler

KoCuce Sosyal