Some Help Please

[joshy9]

Originally Posted by x123x123x

result:

thanks just need the reset database so there is no accounts and characters etc so its a clean database.

[x123x123x]

USE AT_AccountDB;
GO
DBCC CHECKIDENT ('tbl_Account', RESEED, 0);
GO

USE AT_GameDB01;
GO
DBCC CHECKIDENT ('tbl_Person', RESEED, 0);
GO

Create first account ID = 1, first Person ID = 1.

[kesttutiss25]

When rewriting tables there were errors with sending on an foreign key. I haven't risked to delete this key and have just cleared tables of contents. Because of it some counters weren't nullified.
There is a lot of such keys, about 20 pieces. They in fact create dependences of tables among themselves.

-------
In the procedure the StoredProcedure [dbo].[rsp_MarketTrade] (AT_GameDB01) noticed an error. The variable with an error in her name is used.
It isn't sure that the mistake in the register of a symbol can create a problem (Ee).

Original:
Quote:
...
SELECT @BankMoney = [Money] FROM [tbl_BankAccount] WHERE [PersonID] =@DstPersonID
...
Fixed:
Quote:
...
SELECT @BankMoney = [Money] FROM [tbl_BankAccount] WHERE [PersonID] =@DstPersonID
...
Quote:
No declare: @BankMoney; Declare: @BankMoney.
If "E=е" in a name, then it doesn't influence result. And if a name unique, then as a result there can be errors in a market.
I haven't noticed a difference in a game so far.



Can`t find this Market trade

[x123x123x]

Can`t find this Market trade

I recovered the original database, specially to show.

[kesttutiss25]

Quote:
USE AT_AccountDB;
GO
DBCC CHECKIDENT ('tbl_Account', RESEED, 0);
GO

USE AT_GameDB01;
GO
DBCC CHECKIDENT ('tbl_Person', RESEED, 0);
GO
Create first account ID = 1, first Person ID = 1.


and this don

Quote:
USE AT_AccountDB;
GO
DBCC CHECKIDENT ('tbl_Account', RESEED, 0);
GO

USE AT_GameDB01;
GO
DBCC CHECKIDENT ('tbl_Person', RESEED, 0);
GO
Create first account ID = 1, first Person ID = 1.


and this don`t work for me

[joshy9]

Originally Posted by x123x123x

Create first account ID = 1, first Person ID = 1.

thanks but does this include all the characters items and guilds and nations?

[kesttutiss25]

wer u hawe this dbo.rsp in sql ? i only can find dbo.tbl.market

[x123x123x]

Originally Posted by joshy9

thanks but does this include all the characters items and guilds and nations?

No, it is only accounts and characters as an example. It is necessary too most to make with tables of the nations and guilds. To specify the database and to specify the name of the table.
My nation was created with NationUnique=1 without dumping of an index at once.
Guilds probably need to dump an index.

Originally Posted by kesttutiss25

wer u hawe this dbo.rsp in sql ? i only can find dbo.tbl.market

Programmability -> Stored Procedures

Originally Posted by kesttutiss25

Quote:
USE AT_AccountDB;
GO
DBCC CHECKIDENT ('tbl_Account', RESEED, 0);
GO

USE AT_GameDB01;
GO
DBCC CHECKIDENT ('tbl_Person', RESEED, 0);
GO
Create first account ID = 1, first Person ID = 1.


and this don

Quote:
USE AT_AccountDB;
GO
DBCC CHECKIDENT ('tbl_Account', RESEED, 0);
GO

USE AT_GameDB01;
GO
DBCC CHECKIDENT ('tbl_Person', RESEED, 0);
GO
Create first account ID = 1, first Person ID = 1.


and this don`t work for me

There can be a problem if the table not empty. For example the index in the table indicates already existing account with this index. The table needs to be cleared before dumping of an index.

[kesttutiss25]

X123x123x mayby u know how make bank the can put more money ? now only can put max 20b how change the be no limit or more ?

[joshy9]

Originally Posted by x123x123x

No, it is only accounts and characters as an example. It is necessary too most to make with tables of the nations and guilds. To specify the database and to specify the name of the table.
My nation was created with NationUnique=1 without dumping of an index at once.
Guilds probably need to dump an index.


Programmability -> Stored Procedures



There can be a problem if the table not empty. For example the index in the table indicates already existing account with this index. The table needs to be cleared before dumping of an index.

how do you dump of an index?

its a shame there isnt a query to refresh database deleting all kinds of usage so when you go to use it for the first time everything starts with id1

[x123x123x]

Correct the procedure:

USE [AT_GameDB01]
GO
/****** Object: StoredProcedure [dbo].[rasp_BankMoneyInput] Script Date: 03.03.2017 22:54:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/*================================================= ============================
ÇÁ·Î½ÃÀú¸í : rasp_BankMoneyInput
ÀÛ¼ºÀÚ : Çѵ¿Èñ
ÀÛ¼ºÀÏ : 2003.12.04 04:09
ÃÖÁ¾¼öÁ¤ÀÚ : Çѵ¿Èñ
ÃÖÁ¾¼öÁ¤ÀÏ : 2004.09.13 12:54
¼³¸í : ÅëÀå¿¡ µ·À» ÀÔ±ÝÇÑ´Ù.
================================================== ===========================*/
ALTER PROCEDURE [dbo].[rasp_BankMoneyInput]
@PersonID int
, @InputMoney bigint
, @AfterBankMoney bigint output
AS

SET NOCOUNT ON
SET XACT_ABORT ON

SET @AfterBankMoney = 0

/* ½Ã½ºÅÛÀÎ °æ¿ì´Â ¹«Á¶°Ç ¼º°ø */
IF @PersonID = 0
RETURN 1

/* ¾÷µ¥ÀÌÆ®¿¡ ¼º°øÇϸé @AfterBankMoney°¡ »õ°ªÀ» °¡Áö°í, ½ÇÆÐÇϸé 0À» °¡Áö°Ô µÈ´Ù */
UPDATE [dbo].[tbl_BankAccount]
SET @AfterBankMoney = [Money] = [Money] + @InputMoney, [Date] = dbo.rf_ReplaceMCheck([Money] + @InputMoney)
WHERE PersonID = @PersonID and VillageUnique > 0 and ( ([Money]+@InputMoney) <= 20000000000 )
IF dbo.rf_CheckError( @@ROWCOUNT, @@ERROR ) = 1
begin
RETURN 1
end
ELSE
RETURN 0

<= 20000000000 your limit.
modify -> Execute (F5) -> close window -> you agree to change and file recording, the file can be thrown out then.
Theoretically has to work if other restrictions aren't imposed. Didn't check. Is Bank, no person.

[kesttutiss25]

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

USE [AT_GameDB01]
GO
/****** Object: StoredProcedure [dbo].[rasp_BankMoneyInput] Script Date: 2017-03-03 22:08:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/*================================================= ============================
ÇÁ·Î½ÃÀú¸í : rasp_BankMoneyInput
ÀÛ¼ºÀÚ : Çѵ¿Èñ
ÀÛ¼ºÀÏ : 2003.12.04 04:09
ÃÖÁ¾¼öÁ¤ÀÚ : Çѵ¿Èñ
ÃÖÁ¾¼öÁ¤ÀÏ : 2004.09.13 12:54
¼³¸í : ÅëÀå¿¡ µ·À» ÀÔ±ÝÇÑ´Ù.
================================================== ===========================*/
ALTER PROCEDURE [dbo].[rasp_BankMoneyInput]
@ID int
, @Money bigint
, @BankMoney bigint output
AS

SET NOCOUNT ON
SET XACT_ABORT ON

SET @BankMoney = 0

/* ½Ã½ºÅÛÀÎ °æ¿ì´Â ¹«Á¶°Ç ¼º°ø */
IF @ID = 0
RETURN 1

/* ¾÷µ¥ÀÌÆ®¿¡ ¼º°øÇϸé @BankMoney°¡ »õ°ªÀ» °¡Áö°í, ½ÇÆÐÇϸé 0À» °¡Áö°Ô µÈ´Ù */
UPDATE [dbo].[tbl_BankAccount]
SET @BankMoney = [Money] = [Money] + @Money, [Date] = dbo.rf_ReplaceMCheck([Money] + @Money)
WHERE PersonID = @ID and VillageUnique > 0 and ( ([Money] @Money) <= 900000000000 )
IF dbo.rf_CheckError( @@ROWCOUNT, @@ERROR ) = 1
begin
RETURN 1
end
ELSE
RETURN 0

mayby any know how make register in game
#Login
Password for registration.
and after no need # for login

mayby any know how make register in game
#Login
Password for registration.
and after no need # for login

mayby any know how make register in game
#Login
Password for registration.
and after no need # for login

[x123x123x]

Originally Posted by joshy9

how do you dump of an index?

its a shame there isnt a query to refresh database deleting all kinds of usage so when you go to use it for the first time everything starts with id1

I will try to demonstrate.
There are here such guilds:

We delete them:

We apply a request of resetting to zero of an index to this table:

We create guild:

result:

[joshy9]

Originally Posted by x123x123x

I will try to demonstrate.
There are here such guilds:

We delete them:

We apply a request of resetting to zero of an index to this table:

We create guild:

result:

ah ok so i do the same for accounts, Characters(persons) and nations?

[x123x123x]

Originally Posted by joshy9

ah ok so i do the same for accounts, Characters(persons) and nations?

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.