Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Atlantica Online
Some Help Please Some Help Please
You last visited: Today at 23:56

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

Some Help Please

Discussion on Some Help Please within the Atlantica Online forum part of the MMORPGs category.

Reply
Page 3 of 3 12 3
 
Old 03/04/2017, 00:01   #31
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Dec 2016
Posts: 81
Received Thanks: 0
Quote:
Originally Posted by x123x123x View Post
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)


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
joshy9 is offline  
Old 03/04/2017, 00:32   #32
 
elite*gold: 0
The Black Market: 1/0/0
Join Date: Apr 2015
Posts: 827
Received Thanks: 243
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.
x123x123x is offline  
Thanks
1 User
Old 03/04/2017, 07:11   #33

 
nephren's Avatar
 
elite*gold: 92
The Black Market: 3/0/0
Join Date: Aug 2009
Posts: 739
Received Thanks: 976
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
nephren is offline  
Thanks
1 User
Old 03/04/2017, 11:18   #34
 
elite*gold: 0
The Black Market: 1/0/0
Join Date: Apr 2015
Posts: 827
Received Thanks: 243
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:

______________
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).
x123x123x is offline  
Old 03/05/2017, 17:30   #35

 
nephren's Avatar
 
elite*gold: 92
The Black Market: 3/0/0
Join Date: Aug 2009
Posts: 739
Received Thanks: 976
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.
nephren is offline  
Old 03/06/2017, 09:50   #36
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Dec 2016
Posts: 81
Received Thanks: 0
all is good at clearing and resetting database now so thanks guys.

also how to activate santa villa, fishing and other events?
joshy9 is offline  
Old 03/06/2017, 10:52   #37
 
elite*gold: 0
The Black Market: 1/0/0
Join Date: Apr 2015
Posts: 827
Received Thanks: 243
Look at the ../serverinfo/eng/EventInfo.ndt file.
Look at the ../serverinfo/eng/EventMapInfo.ndt file.
x123x123x is offline  
Old 03/06/2017, 22:41   #38
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Dec 2016
Posts: 81
Received Thanks: 0
Quote:
Originally Posted by x123x123x View Post
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>
joshy9 is offline  
Old 03/08/2017, 18:00   #39
 
elite*gold: 0
The Black Market: 1/0/0
Join Date: Apr 2015
Posts: 827
Received Thanks: 243
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
x123x123x is offline  
Old 03/09/2017, 19:15   #40
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Dec 2016
Posts: 81
Received Thanks: 0
Quote:
Originally Posted by x123x123x View Post
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? -
joshy9 is offline  
Old 03/09/2017, 20:24   #41
 
elite*gold: 0
The Black Market: 1/0/0
Join Date: Apr 2015
Posts: 827
Received Thanks: 243
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.
x123x123x is offline  
Old 03/09/2017, 20:36   #42
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Dec 2016
Posts: 81
Received Thanks: 0
Quote:
Originally Posted by x123x123x View Post
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
joshy9 is offline  
Old 03/09/2017, 20:46   #43
 
elite*gold: 0
The Black Market: 1/0/0
Join Date: Apr 2015
Posts: 827
Received Thanks: 243
I haven't found such opportunity, probably it for all GM-mode is made.
x123x123x is offline  
Reply
Page 3 of 3 12 3

« is there any arena of atlantis bot? | Atlantica Online Commentator Seeking Opinions »



All times are GMT +1. The time now is 23:56.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.