Server Tanitimi , Ko Tanitimi , Silkroad Pvp Serverler , Metin2 Pvp Serverler

Tek Kodla Serveri Güncel TUTMA

Konu Bilgileri

Kategori Adı Prosedür & Kod Paylaşımları
Konu Başlığı Tek Kodla Serveri Güncel TUTMA
Konbuyu başlatan Stark
Başlangıç tarihi
Cevaplar
Görüntüleme
İlk mesaj tepki puanı
Son Mesaj Yazan Stark

Stark

K.Destek Yöneticisi
27 May 2013
2,664
2
0
Kod:

CREATE PROCEDURE Guncelle



--- Kullanım : EXEC GUNCELLE

AS

BEGIN

--------------------------------------------------------------------------------------------------

update userdata set Knights=0,Fame=0 where Authority=255

--------------------------------------------------------------------------------------------------

EXEC USER_KNIGHTS_RATING_UPDATE

--------------------------------------------------------------------------------------------------

EXEC UPDATE_PERSONAL_RANK

--------------------------------------------------------------------------------------------------

truncate table CURRENTUSER

--------------------------------------------------------------------------------------------------

UPDATE USERDATA

SET Loyalty = 0

WHERE Authority = 255

update userdata set Loyalty = '0'where Authority = '255'

update userdata set LoyaltyMonthly = '0'where Authority = '255'

-----------------------------------------------------------------------

update userdata set authority = '255' where strUserID = (select userid from gokhan)

update userdata set stritem = '' where authority = '255'

-----------------------------------------------------------------------

update userdata set Knights = '0'where Level = '1'

EXEC GmClan

EXEC GmNP

EXEC MuteNPBanNP

UPDATE USERDATA

SET Loyalty = 0

WHERE Authority = 255

---------------------------------------------------------------------------------------------------

update userdata set zone ='21' where zone='201'

update userdata set zone ='21' where zone='202'

update userdata set zone ='21' where zone='11'

update userdata set zone ='21' where zone='12'

update userdata set zone='21' where zone='1'

update userdata set zone='21' where zone='2'

update userdata set zone='21' where zone='61'

update userdata set zone='21' where zone='62'

update userdata set zone='21' where zone='81'

update userdata set zone='21' where zone='87'

update userdata set zone='21' where zone='88'

---------------------------------------------------------------------------------------------------

EXEC UPDATE_CLAN_RANK

---------------------------------------------------------------------------------------------------

EXEC RANK_KNIGHTS

EXEC USER_KNIGHTS_RATING_UPDATE

EXEC UPDATE_PERSONAL_RANK

EXEC GmClan

EXEC GmNP

EXEC MuteNPBanNP

----------------------------------------------------------------------------------------------------

update userdata set Knights = '0'where Level = '1'

update userdata set Knights = '0'where Level = '2'

update userdata set Knights = '0'where Level = '3'

update userdata set Knights = '0'where Level = '4'

update userdata set Knights = '0'where Level = '5'

update userdata set Knights = '0'where Level = '6'

update userdata set Knights = '0'where Level = '7'

update userdata set Knights = '0'where Level = '8'

update userdata set Knights = '0'where Level = '9'

update userdata set Knights = '0'where Level = '10'

update userdata set Knights = '0'where Level = '11'

update userdata set Knights = '0'where Level = '12'

update userdata set Knights = '0'where Level = '13'

update userdata set Knights = '0'where Level = '14'

update userdata set Knights = '0'where Level = '15'

update userdata set Knights = '0'where Level = '16'

update userdata set Knights = '0'where Level = '17'

update userdata set Knights = '0'where Level = '18'

update userdata set Knights = '0'where Level = '19'

update userdata set Knights = '0'where Level = '20'

----------------------------------------------------------------------------------------------------

END

GO



Ne İşe Yarar ?







Oyunda Yaptıgınız Resler Grade Kodları Vs.
 

Users Who Are Viewing This Konu (Users: 0, Guests: 1)

Üst Alt