[VB.NET] Kurtarici - Veritabanı Server Kontrol Programı (Proje)

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