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-
Seçimi Prosedürü ;
Oldukça Basit Bir Prosedür Sadece Kullanmak
İsteyenler İçin Küçük Bir Paylaşım. Kolay Gelsin
PHP-
- Kod:
[color=#0000BB]Update KING_SYSTEM Set StrKingName [/color][color=#007700]= ([/color][color=#0000BB]Select top 1 strUserID from USERDATA where nation[/color][color=#007700]=[/color][color=#DD0000]'1' [/color][color=#0000BB]order by LoyaltyMonthly desc[/color][color=#007700]) [/color][color=#0000BB]where ByNation[/color][color=#007700]=[/color][color=#DD0000]'1'
[/color][color=#0000BB]Update KING_SYSTEM Set StrKingName [/color][color=#007700]= ([/color][color=#0000BB]Select top 1 strUserID from USERDATA where nation[/color][color=#007700]=[/color][color=#DD0000]'2' [/color][color=#0000BB]order by LoyaltyMonthly desc[/color][color=#007700])[/color][color=#0000BB]where bynation[/color][color=#007700]=[/color][color=#DD0000]'2'
[/color][color=#0000BB]Update KING_ELECTION_LIST Set StrName [/color][color=#007700]= ([/color][color=#0000BB]select top 1 strUserID from USERDATA where nation[/color][color=#007700]=[/color][color=#DD0000]'1' [/color][color=#0000BB]order by LoyaltyMonthly desc[/color][color=#007700])[/color][color=#0000BB]where bynation[/color][color=#007700]=[/color][color=#DD0000]'1'
[/color][color=#0000BB]Update KING_ELECTION_LIST Set StrName [/color][color=#007700]= ([/color][color=#0000BB]select top 1 strUserID from USERDATA where nation[/color][color=#007700]=[/color][color=#DD0000]'2' [/color][color=#0000BB]order by LoyaltyMonthly desc[/color][color=#007700])[/color][color=#0000BB]where bynation[/color][color=#007700]=[/color][color=#DD0000]'2'
[/color][color=#0000BB]Update KING_CANDIDACY_NOTICE_BOARD Set StrUserID [/color][color=#007700]= ([/color][color=#0000BB]select top 1 strUserID from USERDATA where nation[/color][color=#007700]=[/color][color=#DD0000]'2' [/color][color=#0000BB]order by LoyaltyMonthly desc[/color][color=#007700])[/color][color=#0000BB]where bynation[/color][color=#007700]=[/color][color=#DD0000]'2'
[/color][color=#0000BB]Update KING_CANDIDACY_NOTICE_BOARD Set StrUserID [/color][color=#007700]= ([/color][color=#0000BB]select top 1 strUserID from USERDATA where nation[/color][color=#007700]=[/color][color=#DD0000]'1' [/color][color=#0000BB]order by LoyaltyMonthly desc[/color][color=#007700])[/color][color=#0000BB]where bynation[/color][color=#007700]=[/color][color=#DD0000]'1' [/color]