- 6 Haz 2024
- 134
- 2
Tüm herşeyi sıfırlar kiralık itemler, krallar, krallık seçimleri adayları vs. güle güle kullanın.
Hata verirse ALTER yerine CREATE yazınız arkadaşlar.
Hata verirse ALTER yerine CREATE yazınız arkadaşlar.
EXEC DB_SIFIRLA |
USE [kn_online] GO /****** Object: Script Date: 07/25/2017 18:03:12 Author: MOMENTUM Kodevelopers.com ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROC [dbo].[DB_SIFIRLA] AS TRUNCATE TABLE ACCOUNT_CHAR TRUNCATE TABLE CURRENTUSER TRUNCATE TABLE KNIGHTS TRUNCATE TABLE KNIGHTS_RATING TRUNCATE TABLE KNIGHTS_USER TRUNCATE TABLE TB_USER TRUNCATE TABLE USERDATA TRUNCATE TABLE KING_ELECTION_LIST TRUNCATE TABLE KING_SYSTEM TRUNCATE TABLE KING_CANDIDACY_NOTICE_BOARD TRUNCATE TABLE ITEMLER TRUNCATE TABLE GOKHAN TRUNCATE TABLE HERO_USER TRUNCATE TABLE USER_RACECHANGELOG TRUNCATE TABLE WAREHOUSE TRUNCATE TABLE USERDATA_SKILLSHORTCUT TRUNCATE TABLE USER_SAVED_MAGIC TRUNCATE TABLE USER_RENTAL_ITEM TRUNCATE TABLE KNIGHTS_ALLIANCE TRUNCATE TABLE RENTAL_ITEM TRUNCATE TABLE RENTAL_ITEM_LIST TRUNCATE TABLE USER_PERSONAL_RANK TRUNCATE TABLE USER_KNIGHTS_RANK TRUNCATE TABLE PREMIUM_SERVICE TRUNCATE TABLE KING_BALLOT_BOX TRUNCATE TABLE HARDWARELOG DECLARE @Day tinyint DECLARE @Month tinyint DECLARE @Year smallint SET @Day = DAY(GETDATE()) SET @Month = MONTH(GETDATE()) SET @Year = YEAR(GETDATE()) INSERT INTO KING_SYSTEM VALUES(1,7,@Year,@Month,@Day,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,2100000000,2100000000,NULL,NULL) INSERT INTO KING_SYSTEM VALUES(2,7,@Year,@Month,@Day,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,2100000000,2100000000,NULL,NULL) print 'Database Basari ile Sifirlandi > MOMENTUM! < ' |