İlk 15 Clan'ın Kolluklarını Bu kodlar İle Yakabılırsınız..
Res Atıldıkdan Sonra ise Bu kod u yazın
- Kod:
CREATE PROCEDURE clan ASexec rank_knightsupdate knights set points = '999999',ranking = '0'update knights set points = '999999',ranking = '1'where idname = (Select strname from KNIGHTS_RATING where nrank = 1)update knights set points = '999999',ranking = '1'where idname = (Select strname from KNIGHTS_RATING where nrank = 2)update knights set points = '999999',ranking = '1'where idname = (Select strname from KNIGHTS_RATING where nrank = 3)update knights set points = '999999',ranking = '1'where idname = (Select strname from KNIGHTS_RATING where nrank = 4)update knights set points = '999999',ranking = '1'where idname = (Select strname from KNIGHTS_RATING where nrank = 5)update knights set points = '999999',ranking = '1'where idname = (Select strname from KNIGHTS_RATING where nrank = 6)update knights set points = '999999',ranking = '1'where idname = (Select strname from KNIGHTS_RATING where nrank = 7)update knights set points = '999999',ranking = '1'where idname = (Select strname from KNIGHTS_RATING where nrank = 8)update knights set points = '999999',ranking = '1'where idname = (Select strname from KNIGHTS_RATING where nrank = 9)update knights set points = '999999',ranking = '1'where idname = (Select strname from KNIGHTS_RATING where nrank = 10)update knights set points = '999999',ranking = '1'where idname = (Select strname from KNIGHTS_RATING where nrank = 11)update knights set points = '999999',ranking = '1'where idname = (Select strname from KNIGHTS_RATING where nrank = 12)update knights set points = '999999',ranking = '1'where idname = (Select strname from KNIGHTS_RATING where nrank = 13)update knights set points = '999999',ranking = '1'where idname = (Select strname from KNIGHTS_RATING where nrank = 14)update knights set points = '999999',ranking = '1'where idname = (Select strname from KNIGHTS_RATING where nrank = 15)GOresetten sonra
Res Atıldıkdan Sonra ise Bu kod u yazın
- Kod:
'exec clan'