exe 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'