Some Help Please

Page 2 of 3 1 2 3
03/03/2017 19:23 joshy9#16
Quote:
Originally Posted by x123x123x View Post
result: [Only registered and activated users can see links. Click Here To Register...]
thanks just need the reset database so there is no accounts and characters etc so its a clean database.
03/03/2017 19:38 x123x123x#17
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.
03/03/2017 19:39 kesttutiss25#18
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 @[Only registered and activated users can see links. Click Here To Register...]BankMoney = [Money] FROM [tbl_BankAccount] WHERE [PersonID] =@DstPersonID
...
Fixed:
Quote:
...
SELECT @[Only registered and activated users can see links. Click Here To Register...]BankMoney = [Money] FROM [tbl_BankAccount] WHERE [PersonID] =@DstPersonID
...
Quote:
No declare: @[Only registered and activated users can see links. Click Here To Register...]BankMoney; Declare: @[Only registered and activated users can see links. Click Here To Register...]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
03/03/2017 19:53 x123x123x#19
Quote:
Can`t find this Market trade
I recovered the original database, specially to show.
[Only registered and activated users can see links. Click Here To Register...]
03/03/2017 20:04 kesttutiss25#20
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 :(
03/03/2017 20:06 joshy9#21
Quote:
Originally Posted by x123x123x View Post
Create first account ID = 1, first Person ID = 1.
thanks but does this include all the characters items and guilds and nations?
03/03/2017 20:10 kesttutiss25#22
wer u hawe this dbo.rsp in sql ? i only can find dbo.tbl.market
03/03/2017 20:22 x123x123x#23
Quote:
Originally Posted by joshy9 View Post
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.

Quote:
Originally Posted by kesttutiss25 View Post
wer u hawe this dbo.rsp in sql ? i only can find dbo.tbl.market
Programmability -> Stored Procedures

Quote:
Originally Posted by kesttutiss25 View Post
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.
03/03/2017 20:35 kesttutiss25#24
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 ?
03/03/2017 20:52 joshy9#25
Quote:
Originally Posted by x123x123x View Post
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
03/03/2017 21:04 x123x123x#26
Correct the procedure:
Quote:
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.
03/03/2017 21:06 kesttutiss25#27
:) 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]
@[Only registered and activated users can see links. Click Here To Register...]ID int
, @[Only registered and activated users can see links. Click Here To Register...]Money bigint
, @[Only registered and activated users can see links. Click Here To Register...]BankMoney bigint output
AS

SET NOCOUNT ON
SET XACT_ABORT ON

SET @[Only registered and activated users can see links. Click Here To Register...]BankMoney = 0

/* ½Ã½ºÅÛÀÎ °æ¿ì´Â ¹«Á¶°Ç ¼º°ø */
IF @[Only registered and activated users can see links. Click Here To Register...]ID = 0
RETURN 1

/* ¾÷µ¥ÀÌÆ®¿¡ ¼º°øÇϸé @[Only registered and activated users can see links. Click Here To Register...]BankMoney°¡ »õ°ªÀ» °¡Áö°í, ½ÇÆÐÇϸé 0À» °¡Áö°Ô µÈ´Ù */
UPDATE [dbo].[tbl_BankAccount]
SET @[Only registered and activated users can see links. Click Here To Register...]BankMoney = [Money] = [Money] + @[Only registered and activated users can see links. Click Here To Register...]Money, [Date] = dbo.rf_ReplaceMCheck([Money] + @[Only registered and activated users can see links. Click Here To Register...]Money)
WHERE PersonID = @[Only registered and activated users can see links. Click Here To Register...]ID and VillageUnique > 0 and ( ([Money] @[Only registered and activated users can see links. Click Here To Register...]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
03/03/2017 21:51 x123x123x#28
Quote:
Originally Posted by joshy9 View Post
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:
[Only registered and activated users can see links. Click Here To Register...]
We delete them:
[Only registered and activated users can see links. Click Here To Register...]
We apply a request of resetting to zero of an index to this table:
[Only registered and activated users can see links. Click Here To Register...]
We create guild:
[Only registered and activated users can see links. Click Here To Register...]
result:
[Only registered and activated users can see links. Click Here To Register...]
03/03/2017 22:02 joshy9#29
Quote:
Originally Posted by x123x123x View Post
I will try to demonstrate.
There are here such guilds:
[Only registered and activated users can see links. Click Here To Register...]
We delete them:
[Only registered and activated users can see links. Click Here To Register...]
We apply a request of resetting to zero of an index to this table:
[Only registered and activated users can see links. Click Here To Register...]
We create guild:
[Only registered and activated users can see links. Click Here To Register...]
result:
[Only registered and activated users can see links. Click Here To Register...]
ah ok so i do the same for accounts, Characters(persons) and nations?
03/03/2017 23:28 x123x123x#30
Quote:
Originally Posted by joshy9 View Post
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)
[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.
Page 2 of 3 1 2 3