Anony MouS
Kayıtlı Üye
- Katılım
- 6 Ekim 2015
- Mesajlar
- 417
[HIDE-REPLY]exec OTO RES
USE [kn_online]
GO
/****** Object: StoredProcedure [dbo].[OTO_RESET] Script Date: 9.6.2014 12:22:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[OTO_RES] AS
exec UPDATE_KNIGHTS_RATING
exec UPDATE_USER_KNIGHTS_RANK
exec UPDATE_USER_PERSONAL_RANK
--güncellemeleri yaptık
--User temizledik
--clanları royal yaptık.
update USERDATA set Loyalty='0', LoyaltyMonthly='0' where Authority='255'
update USERDATA set Loyalty='1', LoyaltyMonthly='0' where Authority='0'
--banlıların np sıfırladık.
update userdata set level = 83 where level >83 or level < 83
update userdata set exp = 8999999999
update KNIGHTS_USER set nDonatedNP = '0'
--UPDATE KNIGHTS SET RANKING = 1
--UPDATE KNIGHTS SET FLAG = 12
--update KNIGHTS set Points = '999999'
--update KNIGHTS set Flag ='12'
--update KNIGHTS set ClanPointFund ='100000000'[/HIDE-REPLY]
USE [kn_online]
GO
/****** Object: StoredProcedure [dbo].[OTO_RESET] Script Date: 9.6.2014 12:22:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[OTO_RES] AS
exec UPDATE_KNIGHTS_RATING
exec UPDATE_USER_KNIGHTS_RANK
exec UPDATE_USER_PERSONAL_RANK
--güncellemeleri yaptık
--User temizledik
--clanları royal yaptık.
update USERDATA set Loyalty='0', LoyaltyMonthly='0' where Authority='255'
update USERDATA set Loyalty='1', LoyaltyMonthly='0' where Authority='0'
--banlıların np sıfırladık.
update userdata set level = 83 where level >83 or level < 83
update userdata set exp = 8999999999
update KNIGHTS_USER set nDonatedNP = '0'
--UPDATE KNIGHTS SET RANKING = 1
--UPDATE KNIGHTS SET FLAG = 12
--update KNIGHTS set Points = '999999'
--update KNIGHTS set Flag ='12'
--update KNIGHTS set ClanPointFund ='100000000'[/HIDE-REPLY]