Some Help Please

Page 3 of 3

03/04/2017 00:01 joshy9#31

Quote:

Originally Posted by x123x123x

Make a backup of the database before its changes. If something goes to a case not so.

Purified database.
Remove all accounts, characters, all records of achievements, guilds, etc.
Created 1 GM account with 1 character (GM GuitarFX).
Login = test
Password = test
+ script (create linked servers)
[Only registered and activated users can see links. Click Here To Register...]

Delete the single character and the account. Clear numbering of guilds, characters and accounts.
In the AT_AccountDB database
Add to the table MasterIP local or external IP.
Add local or external IP to the table ManagerIP.
Edit the table dbo.tbl_LinkedServerName in the AT_Community database
[ServerID] = 100 [ServerCode] = AT_Sikyon [ServerName] = Sikyon [LinkedServer] = AT_GAMEDB01 [DBName] = AT_GAMEDB01
[ServerID] = 700 [ServerCode] = AT_Titan [ServerName] = Titan [LinkedServer] = INTERDB [DBName] = AT_InterDB01
Everything shall work.
The empty database will turn out. Without accounts, without characters, without guilds and records about them.
Nearly forgot, at linked servers it is necessary to include RPC (true) again.

i will give this a go. thank you soo much i will reply to see if all works well again thank you so much

03/04/2017 00:32 x123x123x#32

Process delete database:
1.delete all linked servers.
2. restart mssql server.
3. delete all database.
Further normal process of recovery of the database of backups and creation of linked servers. That there was no error on transaction when deleting the database.

--------------------------

Quote:

now in my back i can put 900.000.000.000 / before only 20.000.000.000

Yes. Not work.

Quote:

USE [AT_GameDB01]
GO

ALTER TABLE [dbo].[tbl_BankAccount] DROP CONSTRAINT [CK_tbl_BankAccount]
GO

ALTER TABLE [dbo].[tbl_BankAccount] WITH NOCHECK ADD CONSTRAINT [CK_tbl_BankAccount] CHECK (([Money]>=(-9000000000000.) AND [Money]<=(9000000000000.)))
GO

ALTER TABLE [dbo].[tbl_BankAccount] NOCHECK CONSTRAINT [CK_tbl_BankAccount]
GO

and

Quote:

USE [AT_GameDB01]
GO

ALTER TABLE [dbo].[tbl_Bank] DROP CONSTRAINT [DF_tbl_Bank_TotalInputMoney]
GO

ALTER TABLE [dbo].[tbl_Bank] ADD CONSTRAINT [DF_tbl_Bank_TotalInputMoney] DEFAULT ((9000000000000.)) FOR [BankMoney]
GO

Change of a constant of the table. But too doesn't help. The data type in tables has the size from -2^63 (-9 223 372 036 854 775 808) to 2^63-1 (9 223 372 036 854 775 807). Too corrected procedures where there is a restriction. It is necessary to watch then a game server, it is possible in it there is some setup.

03/04/2017 07:11 nephren#33

Please note: I may forgot some Database in there.

To Set Keys to 0 run:

Code:

DBCC CHECKIDENT ('AT_AccountDB.dbo.tbl_Account', RESEED, 0)
DBCC CHECKIDENT ('AT_AccountDB.dbo.tbl_PersonMakeCount', RESEED, 0)
DBCC CHECKIDENT ('AT_AccountDB.dbo.tbl_PassSecondKey', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_Person', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_SolMain', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_SolEmployMakeSkill', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_SolEmploy', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_SolID', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_SolMarket', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_SolList', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_SolHall', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_SolItem', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_SolMail', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_SolIndependence', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_SolMarketItem', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_SolMarketSkill', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_SolSkill', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_FightBatting', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonBonusPoint', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonCollection', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonBuf', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonKillerList', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonEvent', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonEMO', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonEMOAttrib', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonCount', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonCountServer', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_Post', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonTitleItem', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonShapePart', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonTimer', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonItem', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonWarItem', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PostMoney', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PostMSG', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_Quest', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_QuestCondition', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_Quest2', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_SolCraft', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_Angel', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_AuctionItem', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_AuctionTender', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_BankAccount', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_BattleFieldCharInfo', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_BattleFieldLastUse', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_BattleFieldResult', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_ExtraInven', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_ExtraInvenItem', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_FavoriteInfo', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_FolloWer', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_Guilty', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_Letter', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_LifeSkill', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_MakeSkill', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_Market', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonBonusPoint', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonCollection', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonCount', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonCountChangeDate', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonCountServer', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonIndunLimitTime', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonIndunMax', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonItem', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonKillerList', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonLgbattle', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonLgClass', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonMapKillNum', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonMonster', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonPlaySecond', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonRecommend', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonScene', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonShapePart', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonStatus', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonTitleItem', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonTimer', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonTimerInfo', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_Post', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PostItem', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_Account', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_BattleFieldUseNumber', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_BattleRank', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_FightRank', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_HappyBeanRank', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_House', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_HouseFacility', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_HouseFurniture', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_HousePopularityRankLog', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_HousePresent', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_HouseSolHall', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_HouseSolHallPresent', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonSystemInfo', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbla_DeletePerson', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_HouseFurnitureItem', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_PersonFindMap', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_QuestSpecial', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_RaidGroupIndunLimitTime', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_SolEmployWorkLevel', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_Tournament', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_TournamentLog', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_WareHouseItem', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbla_LevelLog', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbla_PersonName', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbla_PersonStatistics', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbla_rank_7', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbla_SolIndependence', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbla_rank_9', RESEED, 0)
DBCC CHECKIDENT ('AT_Community.dbo.tbl_BFFamePoint', RESEED, 0)
DBCC CHECKIDENT ('AT_Community.dbo.tbl_FriendList', RESEED, 0)
DBCC CHECKIDENT ('AT_Community.dbo.tbl_GuildIndunNewRecord', RESEED, 0)
DBCC CHECKIDENT ('AT_Community.dbo.tbl_PersonName', RESEED, 0)
DBCC CHECKIDENT ('AT_NGMDB.dbo.tbl_Account', RESEED, 0)
DBCC CHECKIDENT ('Bridge.dbo.AT_Member', RESEED, 0)
DBCC CHECKIDENT ('ATLANTICA.dbo.NGM_BUY_ITEM', RESEED, 0)
DBCC CHECKIDENT ('ATLANTICA.dbo.GE_EVENT_20080822_LEAGUE', RESEED, 0)
DBCC CHECKIDENT ('ATLANTICA.dbo.GAME_WORLD_CHAMPION_9', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_SPError', RESEED, 0)
DBCC CHECKIDENT ('AT_NGMDB.dbo.tbl_GMLog', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbla_rank_9', RESEED, 0)
DBCC CHECKIDENT ('AT_Community.dbo.tbl_BFFamePoint', RESEED, 0)
DBCC CHECKIDENT ('AT_Community.dbo.tbl_FriendList', RESEED, 0)
DBCC CHECKIDENT ('AT_Community.dbo.tbl_GuildIndunNewRecord', RESEED, 0)
DBCC CHECKIDENT ('AT_Community.dbo.tbl_GuildInfo', RESEED, 0)
DBCC CHECKIDENT ('AT_Community.dbo.tbl_GuildMember', RESEED, 0)
DBCC CHECKIDENT ('AT_Community.dbo.tbl_GuildNotice', RESEED, 0)
DBCC CHECKIDENT ('AT_Community.dbo.tbl_GuildHistory', RESEED, 0)
DBCC CHECKIDENT ('AT_Community.dbo.tbl_GuildActivityPoint', RESEED, 0)
DBCC CHECKIDENT ('AT_Community.dbo.tbl_PersonName', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_Guild', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_Grank', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_GuildDailyPoint', RESEED, 0)
DBCC CHECKIDENT ('AT_GameDB01.dbo.tbl_GuildIndunLimitTime', RESEED, 0)
DBCC CHECKIDENT ('AT_Community.tbl_GuildMember', RESEED, 0)
DBCC CHECKIDENT ('AT_Community.dbo.tbl_Guild', RESEED, 0)
DBCC CHECKIDENT ('AT_Community.dbo.tbl_Grank', RESEED, 0)
DBCC CHECKIDENT ('AT_Community.dbo.tbl_GuildDailyPoint', RESEED, 0)
DBCC CHECKIDENT ('AT_Community.dbo.tbl_GuildIndunLimitTime', RESEED, 0)
DBCC CHECKIDENT ('AT_Community.dbo.tbl_GuildIndunMax', RESEED, 0)
DBCC CHECKIDENT ('AT_Community.dbo.tbl_PersonName', RESEED, 0)
DBCC CHECKIDENT ('AT_NGMDB.dbo.tbl_Account', RESEED, 0)

To Clean the Database:

Code:

DELETE FROM AT_AccountDB.dbo.tbl_Account
DELETE FROM AT_AccountDB.dbo.tbl_PersonMakeCount
DELETE FROM AT_AccountDB.dbo.tbl_PassSecondKey
DELETE FROM AT_GameDB01.dbo.tbl_Person
DELETE FROM AT_GameDB01.dbo.tbl_SolMain
DELETE FROM AT_GameDB01.dbo.tbl_SolEmployMakeSkill
DELETE FROM AT_GameDB01.dbo.tbl_SolEmploy
DELETE FROM AT_GameDB01.dbo.tbl_SolID
DELETE FROM AT_GameDB01.dbo.tbl_SolMarket
DELETE FROM AT_GameDB01.dbo.tbl_SolList
DELETE FROM AT_GameDB01.dbo.tbl_SolHall
DELETE FROM AT_GameDB01.dbo.tbl_SolItem
DELETE FROM AT_GameDB01.dbo.tbl_SolMail
DELETE FROM AT_GameDB01.dbo.tbl_SolIndependence
DELETE FROM AT_GameDB01.dbo.tbl_SolMarketItem
DELETE FROM AT_GameDB01.dbo.tbl_SolMarketSkill
DELETE FROM AT_GameDB01.dbo.tbl_SolSkill
DELETE FROM AT_GameDB01.dbo.tbl_FightBatting
DELETE FROM AT_GameDB01.dbo.tbl_PersonBonusPoint
DELETE FROM AT_GameDB01.dbo.tbl_PersonCollection
DELETE FROM AT_GameDB01.dbo.tbl_PersonBuf
DELETE FROM AT_GameDB01.dbo.tbl_PersonKillerList
DELETE FROM AT_GameDB01.dbo.tbl_PersonEvent
DELETE FROM AT_GameDB01.dbo.tbl_PersonEMO
DELETE FROM AT_GameDB01.dbo.tbl_PersonEMOAttrib
DELETE FROM AT_GameDB01.dbo.tbl_PersonCount
DELETE FROM AT_GameDB01.dbo.tbl_PersonCountServer
DELETE FROM AT_GameDB01.dbo.tbl_Post
DELETE FROM AT_GameDB01.dbo.tbl_PersonTitleItem
DELETE FROM AT_GameDB01.dbo.tbl_PersonShapePart
DELETE FROM AT_GameDB01.dbo.tbl_PersonTimer
DELETE FROM AT_GameDB01.dbo.tbl_PersonItem
DELETE FROM AT_GameDB01.dbo.tbl_PersonWarItem
DELETE FROM AT_GameDB01.dbo.tbl_PostMoney
DELETE FROM AT_GameDB01.dbo.tbl_PostMSG
DELETE FROM AT_GameDB01.dbo.tbl_Quest
DELETE FROM AT_GameDB01.dbo.tbl_QuestCondition
DELETE FROM AT_GameDB01.dbo.tbl_Quest2
DELETE FROM AT_GameDB01.dbo.tbl_SolCraft
DELETE FROM AT_GameDB01.dbo.tbl_Angel
DELETE FROM AT_GameDB01.dbo.tbl_AuctionItem
DELETE FROM AT_GameDB01.dbo.tbl_AuctionTender
DELETE FROM AT_GameDB01.dbo.tbl_BankAccount
DELETE FROM AT_GameDB01.dbo.tbl_BattleFieldCharInfo
DELETE FROM AT_GameDB01.dbo.tbl_BattleFieldLastUse
DELETE FROM AT_GameDB01.dbo.tbl_BattleFieldResult
DELETE FROM AT_GameDB01.dbo.tbl_ExtraInven
DELETE FROM AT_GameDB01.dbo.tbl_ExtraInvenItem
DELETE FROM AT_GameDB01.dbo.tbl_FavoriteInfo
DELETE FROM AT_GameDB01.dbo.tbl_FolloWer
DELETE FROM AT_GameDB01.dbo.tbl_Guilty
DELETE FROM AT_GameDB01.dbo.tbl_Letter
DELETE FROM AT_GameDB01.dbo.tbl_LifeSkill
DELETE FROM AT_GameDB01.dbo.tbl_MakeSkill
DELETE FROM AT_GameDB01.dbo.tbl_Market
DELETE FROM AT_GameDB01.dbo.tbl_PersonBonusPoint
DELETE FROM AT_GameDB01.dbo.tbl_PersonCollection
DELETE FROM AT_GameDB01.dbo.tbl_PersonCount
DELETE FROM AT_GameDB01.dbo.tbl_PersonCountChangeDate
DELETE FROM AT_GameDB01.dbo.tbl_PersonCountServer
DELETE FROM AT_GameDB01.dbo.tbl_PersonIndunLimitTime
DELETE FROM AT_GameDB01.dbo.tbl_PersonIndunMax
DELETE FROM AT_GameDB01.dbo.tbl_PersonItem
DELETE FROM AT_GameDB01.dbo.tbl_PersonKillerList
DELETE FROM AT_GameDB01.dbo.tbl_PersonLgbattle
DELETE FROM AT_GameDB01.dbo.tbl_PersonLgClass
DELETE FROM AT_GameDB01.dbo.tbl_PersonMapKillNum
DELETE FROM AT_GameDB01.dbo.tbl_PersonMonster
DELETE FROM AT_GameDB01.dbo.tbl_PersonPlaySecond
DELETE FROM AT_GameDB01.dbo.tbl_PersonRecommend
DELETE FROM AT_GameDB01.dbo.tbl_PersonScene
DELETE FROM AT_GameDB01.dbo.tbl_PersonShapePart
DELETE FROM AT_GameDB01.dbo.tbl_PersonStatus
DELETE FROM AT_GameDB01.dbo.tbl_PersonTitleItem
DELETE FROM AT_GameDB01.dbo.tbl_PersonTimer
DELETE FROM AT_GameDB01.dbo.tbl_PersonTimerInfo
DELETE FROM AT_GameDB01.dbo.tbl_Post
DELETE FROM AT_GameDB01.dbo.tbl_PostItem
DELETE FROM AT_GameDB01.dbo.tbl_Account
DELETE FROM AT_GameDB01.dbo.tbl_BattleFieldUseNumber
DELETE FROM AT_GameDB01.dbo.tbl_BattleRank
DELETE FROM AT_GameDB01.dbo.tbl_FightRank
DELETE FROM AT_GameDB01.dbo.tbl_HappyBeanRank
DELETE FROM AT_GameDB01.dbo.tbl_House
DELETE FROM AT_GameDB01.dbo.tbl_HouseFacility
DELETE FROM AT_GameDB01.dbo.tbl_HouseFurniture
DELETE FROM AT_GameDB01.dbo.tbl_HousePopularityRankLog
DELETE FROM AT_GameDB01.dbo.tbl_HousePresent
DELETE FROM AT_GameDB01.dbo.tbl_HouseSolHall
DELETE FROM AT_GameDB01.dbo.tbl_HouseSolHallPresent
DELETE FROM AT_GameDB01.dbo.tbl_PersonSystemInfo
DELETE FROM AT_GameDB01.dbo.tbla_DeletePerson
DELETE FROM AT_GameDB01.dbo.tbl_HouseFurnitureItem
DELETE FROM AT_GameDB01.dbo.tbl_PersonFindMap
DELETE FROM AT_GameDB01.dbo.tbl_QuestSpecial
DELETE FROM AT_GameDB01.dbo.tbl_RaidGroupIndunLimitTime
DELETE FROM AT_GameDB01.dbo.tbl_SolEmployWorkLevel
DELETE FROM AT_GameDB01.dbo.tbl_Tournament
DELETE FROM AT_GameDB01.dbo.tbl_TournamentLog
DELETE FROM AT_GameDB01.dbo.tbl_WareHouseItem
DELETE FROM AT_GameDB01.dbo.tbla_LevelLog
DELETE FROM AT_GameDB01.dbo.tbla_PersonName
DELETE FROM AT_GameDB01.dbo.tbla_PersonStatistics
DELETE FROM AT_GameDB01.dbo.tbla_rank_7
DELETE FROM AT_GameDB01.dbo.tbla_SolIndependence
DELETE FROM AT_GameDB01.dbo.tbla_rank_9
DELETE FROM AT_Community.dbo.tbl_BFFamePoint
DELETE FROM AT_Community.dbo.tbl_FriendList
DELETE FROM AT_Community.dbo.tbl_GuildIndunNewRecord
DELETE FROM AT_Community.dbo.tbl_GuildInfo
DELETE FROM AT_Community.dbo.tbl_GuildMember
DELETE FROM AT_Community.dbo.tbl_GuildNotice
DELETE FROM AT_Community.dbo.tbl_GuildHistory
DELETE FROM AT_Community.dbo.tbl_GuildActivityPoint
DELETE FROM AT_Community.dbo.tbl_GuildCraft

DELETE FROM AT_Community.dbo.tbl_PersonName
DELETE FROM AT_GameDB01.dbo.tbl_Guild
DELETE FROM AT_GameDB01.dbo.tbl_Grank
DELETE FROM AT_GameDB01.dbo.tbl_GuildDailyPoint
DELETE FROM AT_GameDB01.dbo.tbl_GuildIndunLimitTime
DELETE FROM AT_GameDB01.dbo.tbl_GuildMember
DELETE FROM AT_GameDB01.dbo.tbl_GuildIndunMax
DELETE FROM AT_Community.dbo.tbl_PersonName
DELETE FROM AT_NGMDB.dbo.tbl_Account
DELETE FROM Bridge.dbo.AT_Member
DELETE FROM ATLANTICA.dbo.NGM_BUY_ITEM
DELETE FROM ATLANTICA.dbo.GE_EVENT_20080822_LEAGUE
DELETE FROM ATLANTICA.dbo.GAME_WORLD_CHAMPION_9
DELETE FROM AT_GameDB01.dbo.tbl_SPError
DELETE FROM AT_NGMDB.dbo.tbl_GMLog

03/04/2017 11:18 x123x123x#34

The list of tables can be received such inquiry:

Quote:

USE AT_GameDB01;
GO
SELECT * FROM INFORMATION_SCHEMA.TABLES

where the line 'AT_GameDB01' is the database which address for the list.

______________
It is perhaps necessary to nullify at first data in tables, differently here so:

Spoiler

Quote:

Checking identity information: current identity value '0'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 2
'tbl_PersonMakeCount' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 3
'tbl_PassSecondKey' does not contain an identity column.
Checking identity information: current identity value '0'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 5
'tbl_SolMain' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 6
'tbl_SolEmployMakeSkill' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 7
'tbl_SolEmploy' does not contain an identity column.
Checking identity information: current identity value '10851'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 9
'tbl_SolMarket' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 10
'tbl_SolList' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 11
'tbl_SolHall' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 12
'tbl_SolItem' does not contain an identity column.
Checking identity information: current identity value '4891'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Checking identity information: current identity value '27'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 15
'tbl_SolMarketItem' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 16
'tbl_SolMarketSkill' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 17
'tbl_SolSkill' does not contain an identity column.
Checking identity information: current identity value '4327'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 19
'tbl_PersonBonusPoint' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 20
'tbl_PersonCollection' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 21
'tbl_PersonBuf' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 22
'tbl_PersonKillerList' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 23
'tbl_PersonEvent' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 24
'tbl_PersonEMO' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 25
'tbl_PersonEMOAttrib' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 26
'tbl_PersonCount' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 27
'tbl_PersonCountServer' does not contain an identity column.
Checking identity information: current identity value '1065570'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 29
'tbl_PersonTitleItem' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 30
'tbl_PersonShapePart' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 31
'tbl_PersonTimer' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 32
'tbl_PersonItem' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 33
'tbl_PersonWarItem' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 34
'tbl_PostMoney' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 35
'tbl_PostMsg' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 36
'tbl_Quest' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 37
'tbl_QuestCondition' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 38
'tbl_Quest2' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 39
'tbl_SolCraft' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 40
'tbl_Angel' does not contain an identity column.
Checking identity information: current identity value '578'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 42
'tbl_AuctionTender' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 43
'tbl_BankAccount' does not contain an identity column.
Checking identity information: current identity value '12'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 45
'tbl_BattleFieldLastUse' does not contain an identity column.
Checking identity information: current identity value '5'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 47
'tbl_ExtraInven' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 48
'tbl_ExtraInvenItem' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 49
'tbl_FavoriteInfo' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 50
'tbl_FolloWer' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 51
'tbl_Guilty' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 52
'tbl_Letter' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 53
'tbl_LifeSkill' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 54
'tbl_MakeSkill' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 55
'tbl_Market' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 56
'tbl_PersonBonusPoint' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 57
'tbl_PersonCollection' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 58
'tbl_PersonCount' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 59
'tbl_PersonCountChangeDate' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 60
'tbl_PersonCountServer' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 61
'tbl_PersonIndunLimitTime' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 62
'tbl_PersonIndunMax' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 63
'tbl_PersonItem' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 64
'tbl_PersonKillerList' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 65
'tbl_PersonLgbattle' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 66
'tbl_PersonLgClass' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 67
'tbl_PersonMapKillNum' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 68
'tbl_PersonMonster' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 69
'tbl_PersonPlaySecond' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 70
'tbl_PersonRecommend' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 71
'tbl_PersonScene' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 72
'tbl_PersonShapePart' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 73
'tbl_PersonStatus' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 74
'tbl_PersonTitleItem' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 75
'tbl_PersonTimer' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 76
'tbl_PersonTimerInfo' does not contain an identity column.
Checking identity information: current identity value '0'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 78
'tbl_PostItem' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 79
'tbl_Account' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 80
'tbl_BattleFieldUseNumber' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 81
'tbl_BattleRank' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 82
'tbl_FightRank' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 83
'tbl_HappyBeanRank' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 84
'tbl_House' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 85
'tbl_HouseFacility' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 86
'tbl_HouseFurniture' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 87
'tbl_HousePopularityRankLog' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 88
'tbl_HousePresent' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 89
'tbl_HouseSolHall' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 90
'tbl_HouseSolHallPresent' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 91
'tbl_PersonSystemInfo' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 92
'tbla_DeletePerson' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 93
'tbl_HouseFurnitureItem' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 94
'tbl_PersonFindMap' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 95
'tbl_QuestSpecial' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 96
'tbl_RaidGroupIndunLimitTime' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 97
'tbl_SolEmployWorkLevel' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 98
'tbl_Tournament' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 99
'tbl_TournamentLog' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 100
'tbl_WareHouseItem' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 101
'tbla_LevelLog' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 102
'tbla_PersonName' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 103
'tbla_PersonStatistics' does not contain an identity column.
Checking identity information: current identity value '0'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 105
'tbla_SolIndependence' does not contain an identity column.
Checking identity information: current identity value '0'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 107
'tbl_BFFamePoint' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 108
'tbl_FriendList' does not contain an identity column.
Checking identity information: current identity value '24'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 110
'tbl_PersonName' does not contain an identity column.
Checking identity information: current identity value '12'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 112
'AT_Member' does not contain an identity column.
Checking identity information: current identity value '2071'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Checking identity information: current identity value '9290'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 115
'GAME_WORLD_CHAMPION_9' does not contain an identity column.
Checking identity information: current identity value '187'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Checking identity information: current identity value '498'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Checking identity information: current identity value '0'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 119
'tbl_BFFamePoint' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 120
'tbl_FriendList' does not contain an identity column.
Checking identity information: current identity value '0'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Checking identity information: current identity value '1100'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7997, Level 16, State 1, Line 123
'tbl_GuildMember' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 124
'tbl_GuildNotice' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 125
'tbl_GuildHistory' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 126
'tbl_GuildActivityPoint' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 127
'tbl_PersonName' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 128
'tbl_Guild' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 129
'tbl_Grank' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 130
'tbl_GuildDailyPoint' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 131
'tbl_GuildIndunLimitTime' does not contain an identity column.
Msg 2501, Level 16, State 45, Line 132
Cannot find a table or object with the name "AT_Community.tbl_GuildMember". Check the system catalog.
Msg 2501, Level 16, State 45, Line 133
Cannot find a table or object with the name "AT_Community.dbo.tbl_Guild". Check the system catalog.
Msg 2501, Level 16, State 45, Line 134
Cannot find a table or object with the name "AT_Community.dbo.tbl_Grank". Check the system catalog.
Msg 2501, Level 16, State 45, Line 135
Cannot find a table or object with the name "AT_Community.dbo.tbl_GuildDailyPoint". Check the system catalog.
Msg 7997, Level 16, State 1, Line 136
'tbl_GuildIndunLimitTime' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 137
'tbl_GuildIndunMax' does not contain an identity column.
Msg 7997, Level 16, State 1, Line 138
'tbl_PersonName' does not contain an identity column.
Checking identity information: current identity value '0'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

______________
Not everything is so simple during removal of data, some of them demand the sequence.
For example:
To clear the table (DELETE FROM AT_Community.dbo.tbl_GuildInfo), it is necessary to clear at first Craft_logs of guilds ([AT_Community]. [dbo]. [tbl_GuildCraftWorkLog]) then to clear ([AT_Community]. [dbo]. [tbl_GuildCraft]) and will turn out to clear only after that primary table.
______________
As the result can be told the following:
1. It is necessary to process a script of zeroing of counters (many tables of the counters which don't have these).
2. The script of cleaning of base needs to be structured (to delete information consistently, considering dependences of tables).

03/05/2017 17:30 nephren#35

As already mentioned, I was scirpting it quickly for you. You are free to change or adjust the script to work as perfect as it shoud for you.

It may encounters errors or missing table-structures.

03/06/2017 09:50 joshy9#36

all is good at clearing and resetting database now so thanks guys.

also how to activate santa villa, fishing and other events?

03/06/2017 10:52 x123x123x#37

Look at the ../serverinfo/eng/EventInfo.ndt file.
Look at the ../serverinfo/eng/EventMapInfo.ndt file.

03/06/2017 22:41 joshy9#38

Quote:

Originally Posted by x123x123x

Look at the ../serverinfo/eng/EventInfo.ndt file.
Look at the ../serverinfo/eng/EventMapInfo.ndt file.

thanks i looked into it and this is whats inside EventMapInfo.ndt, when i go to northern Europe where santa villa is but theres no NPCs or Portal to santa villa there? GOONZUWORLD works ok. but not santa villa.

EvnetMapInfo
2009-02-06
H.G. Kong
이벤트 던전 설정
요일 및 시간은 최대 10개까지 세팅 가능
"WEEKDAY - -1: Non, 0: Sunday, 1: Monday, 2: Tuesday, 3: Wednesday, 4: Thursday, 5: Friday, 6: Saturday"
맵과 인던은 최대 5개씩 설정 가능하며 마지막에는 꼭 -1을 넣어준다.
돌아가는 마을은 최대 3개까지 설정가능 없는건 -1을 넣어준다.

<Data>

Type: GOONZUWORLD
TextIndex GateUnique LimitWarpLevel
380 973 90
ReturnVillage
1 2 3
MapIndex
288 289 290 -1 -1
IndunUnique
-1 -1 -1 -1 -1
StartWeekday StartHour EndWeekDay EndHour
0 0 0 24
1 0 0 24
2 0 0 24
3 0 0 24
4 0 0 24
5 0 0 24
6 0 0 24
-1

Type: SANTA
TextIndex GateUnique LimitWarpLevel
330 899 20
ReturnVillage
31 57 60
MapIndex
277 278 279 308 -1
IndunUnique
-1 -1 -1 -1 -1
StartWeekday StartHour EndWeekDay EndHour
0 0 0 24
1 0 0 24
2 0 0 24
3 0 0 24
4 0 0 24
5 0 0 24
6 0 0 24
-1
<End>

03/08/2017 18:00 x123x123x#39

Possibly it because of limits, try to remove them. At me Santa Villa isn't started at all, I can't check.
../server/lang/eng/limitinfo/MapLimitInfo_Eng.ndt

03/09/2017 19:15 joshy9#40

Quote:

Originally Posted by x123x123x

Possibly it because of limits, try to remove them. At me Santa Villa isn't started at all, I can't check.
../server/lang/eng/limitinfo/MapLimitInfo_Eng.ndt

i have no idea how to activate santa villa.

does anyone know how to remove the numbers on npcs when a GM? - [Only registered and activated users can see links. Click Here To Register...]

03/09/2017 20:24 x123x123x#41

Doesn't clean up. It is easier to make 2 scripts, to allow one the rights of GM, the second to cancel.

Quote:

USE [AT_AccountDB]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
UPDATE dbo.tbl_Account SET MasterLevelValue = 120, MasterLevelExpireTime = '2100-12-06 21:33:00.000' WHERE ID = 'test'

MasterLevelValue > 100 - is GM. (120 is Developer_Level)
MasterLevelValue < 100 - not GM. (default user MasterLevel = 0)
WHERE ID = 'you login'
Save one file with the name GMlvl120.sql (is MasterLevelValue = 120)
The second with the name GMlvl0.sql (is MasterLevelValue = 0)
It seems to me to use a script more conveniently.
Relogin client game.

03/09/2017 20:36 joshy9#42

Quote:

Originally Posted by x123x123x

Doesn't clean up. It is easier to make 2 scripts, to allow one the rights of GM, the second to cancel.

MasterLevelValue > 100 - is GM. (120 is Developer_Level)
MasterLevelValue < 100 - not GM. (default user MasterLevel = 0)
WHERE ID = 'you login'
Save one file with the name GMlvl120.sql (is MasterLevelValue = 120)
The second with the name GMlvl0.sql (is MasterLevelValue = 0)
It seems to me to use a script more conveniently.
Relogin client game.

i wanted to know how to hide the npc numbers etc while been a GM wondering if there is a setting or something to hide the numbers (4736) etc

03/09/2017 20:46 x123x123x#43

I haven't found such opportunity, probably it for all GM-mode is made.

Page 3 of 3