Db Sıfırlama [Geniş Kapsamlı]

CuceAdmin

Yönetici
Kocuce
Kayıtlı Üye
Administrator
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.

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

JamesTepay

Kayıtlı Üye
8 Eyl 2025
29
0
В нашем интернет-магазине вы можете купить энтеогены высокого качества: сальвию дивинорум, кратом, рапэ и калею закатичи. Мы предлагаем широкий выбор этноботанических растений и натуральных средств для практик и исследований. Удобный заказ, доступные цены и быстрая доставка.
семена коки цена
.
 
Geri
Üst