CREATE PROCEDURE guncelle_kurtaricidb
--- Bana Ulaşmak SKYPE : byherqeleehckr
--- Kullanım : exec guncelle_kurtaricidb
--- Kurtarici Databaseleri
AS
BEGIN
print 'Islem Basariyla Tamamlandi, Yapilanlar : '
print ' '
print '- Butun Oyuncular Maradona Atildi '
print ' '
print '- Butun Oyuncularin Sembolleri Guncellendi '
print ' '
print '- Butun Clanlar Guncellenip, Grade 1 Yapildi ( Ilk 10 Clanin Kollugu Yaniyor ) '
print ' '
print '* Bana Ulasmak Icin SKYPE : byherqeleehckr '
print ' '
print ' *** Kurtarici Database *** '
print ' '
print ' '
print ' '
print ' '
print ' '
print ' '
print ' '
print ' '
print ' '
---- Kurtarici ----
update Userdata set zone = '21'
EXEC USER_KNIGHTS_RATING_UPDATE
EXEC UPDATE_PERSONAL_RANK
update Knights set Points = '999999'
update 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)
END
GO
