Selamlar ;
LoyaltyMonthly (Sağ NP) Sıralamasına Göre Krallık Seçimi Prosedürü ;
Oldukça Basit Bir Prosedür Sadece Kullanmak İsteyenler İçin Küçük Bir Paylaşım. Kolay Gelsin
PHP- Kodu:
Update KING_SYSTEM Set StrKingName = (Select top 1 strUserID from USERDATA where nation='1' order by LoyaltyMonthly desc) where ByNation='1'
Update KING_SYSTEM Set StrKingName = (Select top 1 strUserID from USERDATA where nation='2' order by LoyaltyMonthly desc)where bynation='2'
Update KING_ELECTION_LIST Set StrName = (select top 1 strUserID from USERDATA where nation='1' order by LoyaltyMonthly desc)where bynation='1'
Update KING_ELECTION_LIST Set StrName = (select top 1 strUserID from USERDATA where nation='2' order by LoyaltyMonthly desc)where bynation='2'
Update KING_CANDIDACY_NOTICE_BOARD Set StrUserID = (select top 1 strUserID from USERDATA where nation='2' order by LoyaltyMonthly desc)where bynation='2'
Update KING_CANDIDACY_NOTICE_BOARD Set StrUserID = (select top 1 strUserID from USERDATA where nation='1' order by LoyaltyMonthly desc)where bynation='1'
Anasayfa 
Kayıt Ol 
Giriş yap ![[PAYLAŞIM] LoyaltyMonthly Rank King System Icon_minitime](https://2img.net/i/fa/subsilver/icon_minitime.gif){kind=icon}
Paz Mayıs 09, 2010 9:21 am