[Help Thread] Please post your questions here.

[g_d_dragon]

Originally Posted by PetTrainer

och nöööö -.-

was für querys hast du davor gemacht?

^^

[TheOnlyOneRaskim]

Originally Posted by PetTrainer

och nöööö -.-

in 5 min geb ich dir nen fix dafür. wird hier als edit reingehauen dann

einfach diesen code kopieren und ausführen

check_purchased_item

 Spoiler

USE [Telecaster]
GO

IF (OBJECT_ID('smp_check_purchased_item') IS NOT NULL)
  DROP PROCEDURE smp_check_purchased_item
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE PROCEDURE [dbo].[smp_check_purchased_item]
@IN_ACCOUNT_ID			INT,
@IN_CHARACTER_ID		INT,
@OUT_TOTAL_ITEM_COUNT	INT		OUTPUT,
@OUT_NEW_ITEM_COUNT		INT		OUTPUT,
@OUT_PREMIUM_TICKET		INT		OUTPUT,
@OUT_PREMIUM_REST_TIME	INT		OUTPUT,
@OUT_STAMINA_REGEN_TIME	INT		OUTPUT

 
AS
SET NOCOUNT ON

	SET @OUT_PREMIUM_TICKET  = 0
	SET @OUT_PREMIUM_REST_TIME = 0
	SET @OUT_STAMINA_REGEN_TIME = 0

	SELECT @OUT_PREMIUM_TICKET = COUNT(*), @OUT_PREMIUM_REST_TIME = DATEDIFF( second, GETDATE(), MAX( valid_time ) ) FROM dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code = 910000 AND valid_time > GETDATE() AND isCancel = 0

	IF @OUT_PREMIUM_TICKET < 1
	BEGIN
		SET @OUT_PREMIUM_REST_TIME = 0

		DECLARE @LOGOUT_TIME		DATETIME
		SET @LOGOUT_TIME = GETDATE()

		SELECT @LOGOUT_TIME = logout_time FROM Character WITH (NOLOCK) WHERE account_id = @IN_ACCOUNT_ID AND sid = @IN_CHARACTER_ID
		SELECT @OUT_STAMINA_REGEN_TIME = DATEDIFF( minute, @LOGOUT_TIME, MAX( valid_time ) ) FROM dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code = 910000 AND valid_time > @LOGOUT_TIME AND isCancel = 0

		IF @OUT_STAMINA_REGEN_TIME < 1 OR @OUT_STAMINA_REGEN_TIME IS NULL
		BEGIN
			SET @OUT_STAMINA_REGEN_TIME = 0
		END
END
	SELECT @OUT_TOTAL_ITEM_COUNT = COUNT(*) from dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code <> 910000 AND rest_item_count > 0  AND valid_time > GETDATE() AND isCancel = 0
	SELECT @OUT_NEW_ITEM_COUNT   = COUNT(*) from dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code <> 910000 AND rest_item_count > 0  AND confirmed = 0 AND valid_time > GETDATE() AND isCancel = 0

RETURN @@ERROR

GO

read_purchased_item_list

 Spoiler

USE [Telecaster]
GO

IF (OBJECT_ID('smp_read_purchased_item_list') IS NOT NULL)
  DROP PROCEDURE smp_read_purchased_item_list
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE PROCEDURE [dbo].[smp_read_purchased_item_list]

@IN_ACCOUNT_ID		INT
 
AS
SET NOCOUNT ON

UPDATE dbo.PaidItem SET confirmed = 1, confirmed_time = GETDATE() WHERE taken_account_id = @IN_ACCOUNT_ID AND confirmed = 0 AND isCancel = 0

SELECT  sid,                 
        account_id,           
        avatar_id,            
        avatar_name,           
        server_name,			
        item_code,            
        item_count,            
        rest_item_count,		  
        bought_time,           
        valid_time             
        FROM dbo.PaidItem WHERE taken_account_id =@IN_ACCOUNT_ID AND rest_item_count > 0 AND item_code <> 910000 AND isCancel = 0 ORDER BY sid

RETURN @@ERROR
 


GO

update_takeout_info

 Spoiler

USE [Telecaster]
GO

IF (OBJECT_ID('smp_update_takeout_info') IS NOT NULL)
  DROP PROCEDURE smp_update_takeout_info
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[smp_update_takeout_info]

@IN_CID				INT,
@IN_ACCOUNT_ID		INT,
@IN_COUNT			INT,
@IN_AVATAR_ID		INT,
@IN_AVATAR_NAME		VARCHAR(61),
@IN_SERVER_NAME		VARCHAR(30)

AS
SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED  

UPDATE dbo.PaidItem SET

    rest_item_count = ( rest_item_count - @IN_COUNT ),
    taken_avatar_id = @IN_AVATAR_ID,
    taken_avatar_name = @IN_AVATAR_NAME,
    taken_server_name = @IN_SERVER_NAME,
    taken_time = GETDATE()

    WHERE sid = @IN_CID AND taken_account_id = @IN_ACCOUNT_ID

GO

takeout_commercial_item

 Spoiler

USE [Telecaster]
GO

IF (OBJECT_ID('smp_takeout_commercial_item') IS NOT NULL)
  DROP PROCEDURE smp_takeout_commercial_item
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE PROCEDURE [dbo].[smp_takeout_commercial_item]
@OUT_ITEM_CODE		INT OUTPUT,
@IN_CID				INT,
@IN_COUNT			BIGINT,
@IN_ACCOUNT_ID		INT,
@IN_AVATAR_ID		INT,
@IN_AVATAR_NAME		VARCHAR(61),
@IN_SERVER_NAME		VARCHAR(30),
@IN_SID				INT,
@IN_REMAIN_TIME		INT

AS
SET NOCOUNT ON

SET @OUT_ITEM_CODE = 0

DECLARE @RET INT
SET @RET = 0

IF @IN_COUNT < 1
BEGIN
	SET @RET = -1
    GOTO ON_END
END

DECLARE @REST_ITEM_COUNT INT
SET @REST_ITEM_COUNT = -1

SELECT @REST_ITEM_COUNT = rest_item_count FROM dbo.PaidItem WITH (NOLOCK) WHERE sid = @IN_CID AND isCancel = 0;
IF @@ERROR <> 0
BEGIN
	SET @RET = -11
    GOTO ON_END
END

IF @REST_ITEM_COUNT < @IN_COUNT
BEGIN
	SET @RET = -2
    GOTO ON_END
END

DECLARE @ACCOUNT_ID INT
SET @ACCOUNT_ID = -1

SELECT @OUT_ITEM_CODE = item_code, @ACCOUNT_ID = taken_account_id FROM dbo.PaidItem WITH (NOLOCK) WHERE sid = @IN_CID;
IF @@ERROR <> 0
BEGIN
	SET @RET = -12
    GOTO ON_END
END

IF @OUT_ITEM_CODE = 910000
BEGIN
	SET @RET = -3
    GOTO ON_END
END

IF @ACCOUNT_ID <> @IN_ACCOUNT_ID
BEGIN
    SET @OUT_ITEM_CODE = 0
	SET @RET = -4
    GOTO ON_END
END

EXEC dbo.smp_update_takeout_info @IN_CID, @IN_ACCOUNT_ID, @IN_COUNT, @IN_AVATAR_ID, @IN_AVATAR_NAME, @IN_SERVER_NAME

IF @@ERROR <> 0
BEGIN
	SET @RET = 1
    GOTO ON_END
END

INSERT INTO Item
	(
	sid,					-- 0
			owner_id,				-- 1
			account_id,				-- 2
			summon_id,				-- 3
			auction_id,				-- 4
			keeping_id,				-- 5
			previous_sid,			-- 6
			code,					-- 7
			flag,					-- 8
			cnt,					-- 9
			level,					-- 10
			enhance,				-- 11
			ethereal_durability,	-- 12
			endurance,				-- 13
			gcode,					-- 14
			create_time,			-- 15
			wear_info,				-- 16
			socket_0,				-- 17
			socket_1,				-- 18
			socket_2,				-- 19
			socket_3,				-- 20
			awaken_sid,				-- 21
			random_option_sid,		-- 22
			remain_time,			-- 23
			elemental_effect_type,	-- 24
			elemental_effect_expire_time,	-- 25
			elemental_effect_attack_point,	-- 26
			elemental_effect_magic_point,	-- 27
			appearance_code,		-- 28
			update_time,			-- 29
			summon_code				-- 30
	)
	VALUES
	(
			@IN_SID,				-- 0
			@IN_AVATAR_ID,			-- 1
			@IN_ACCOUNT_ID,			-- 2
			0,			-- 3
			0,			-- 4
			0,			-- 5
			0,		-- 6
			@OUT_ITEM_CODE,				-- 7
			0,				-- 8
			@IN_COUNT,				-- 9
			1,				-- 10
			0,			-- 11
			0,	-- 12
			0,			-- 13
			0,				-- 14
			GETDATE(),				-- 15	
			-1,						-- 16
			0,			-- 17
			0,			-- 18
			0,			-- 19
			0,			-- 20
			0,						-- 21
			0,						-- 22
			@IN_REMAIN_TIME,		-- 23
			0,	-- 24
			0,	-- 25
			0,	-- 26
			0,	-- 27
			0,	-- 28
			GETDATE(),				-- 29
			0);

IF @@ERROR <> 0
BEGIN
	SET @RET = 2
    GOTO ON_END
END

SET @RET = 0

ON_END:
RETURN @RET


GO

dbo.PaidItem

 Spoiler

USE [Telecaster]
GO

ALTER TABLE [dbo].[PaidItem] DROP CONSTRAINT [DF__PaidItem__isCanc__607D3EDD]
GO

ALTER TABLE [dbo].[PaidItem] DROP CONSTRAINT [DF__PaidItem__taken___5F891AA4]
GO

ALTER TABLE [dbo].[PaidItem] DROP CONSTRAINT [DF__PaidItem__valid___5E94F66B]
GO

ALTER TABLE [dbo].[PaidItem] DROP CONSTRAINT [DF__PaidItem__confir__5DA0D232]
GO

ALTER TABLE [dbo].[PaidItem] DROP CONSTRAINT [DF__PaidItem__confir__5CACADF9]
GO

ALTER TABLE [dbo].[PaidItem] DROP CONSTRAINT [DF__PaidItem__rest_i__5BB889C0]
GO

ALTER TABLE [dbo].[PaidItem] DROP CONSTRAINT [DF__PaidItem__type__5AC46587]
GO

ALTER TABLE [dbo].[PaidItem] DROP CONSTRAINT [DF__PaidItem__taken___59D0414E]
GO

ALTER TABLE [dbo].[PaidItem] DROP CONSTRAINT [DF__PaidItem__taken___58DC1D15]
GO

ALTER TABLE [dbo].[PaidItem] DROP CONSTRAINT [DF__PaidItem__taken___57E7F8DC]
GO

ALTER TABLE [dbo].[PaidItem] DROP CONSTRAINT [DF__PaidItem__taken___56F3D4A3]
GO

ALTER TABLE [dbo].[PaidItem] DROP CONSTRAINT [DF__PaidItem__server__55FFB06A]
GO

ALTER TABLE [dbo].[PaidItem] DROP CONSTRAINT [DF__PaidItem__avatar__550B8C31]
GO

ALTER TABLE [dbo].[PaidItem] DROP CONSTRAINT [DF__PaidItem__avatar__541767F8]
GO

/****** Object:  Table [dbo].[PaidItem]    Script Date: 22.12.2015 22:49:55 ******/
DROP TABLE [dbo].[PaidItem]
GO

/****** Object:  Table [dbo].[PaidItem]    Script Date: 22.12.2015 22:49:55 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[PaidItem](
	[sid] [int] IDENTITY(1,1) NOT NULL,
	[buy_id] [int] NOT NULL,
	[account_id] [int] NOT NULL,
	[avatar_id] [int] NOT NULL,
	[avatar_name] [varchar](61) NOT NULL,
	[server_name] [varchar](30) NOT NULL,
	[taken_account_id] [int] NOT NULL,
	[taken_avatar_id] [int] NOT NULL,
	[taken_avatar_name] [varchar](61) NOT NULL,
	[taken_server_name] [varchar](30) NOT NULL,
	[item_code] [int] NOT NULL,
	[item_count] [int] NOT NULL,
	[type] [tinyint] NOT NULL,
	[rest_item_count] [int] NOT NULL,
	[confirmed] [bit] NOT NULL,
	[confirmed_time] [datetime] NOT NULL,
	[bought_time] [datetime] NOT NULL,
	[valid_time] [datetime] NOT NULL,
	[taken_time] [datetime] NOT NULL,
	[isCancel] [bit] NOT NULL,
PRIMARY KEY NONCLUSTERED 
(
	[sid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[PaidItem] ADD  DEFAULT ((0)) FOR [avatar_id]
GO

ALTER TABLE [dbo].[PaidItem] ADD  DEFAULT ('') FOR [avatar_name]
GO

ALTER TABLE [dbo].[PaidItem] ADD  DEFAULT ('') FOR [server_name]
GO

ALTER TABLE [dbo].[PaidItem] ADD  DEFAULT ((0)) FOR [taken_account_id]
GO

ALTER TABLE [dbo].[PaidItem] ADD  DEFAULT ((0)) FOR [taken_avatar_id]
GO

ALTER TABLE [dbo].[PaidItem] ADD  DEFAULT ('') FOR [taken_avatar_name]
GO

ALTER TABLE [dbo].[PaidItem] ADD  DEFAULT ('') FOR [taken_server_name]
GO

ALTER TABLE [dbo].[PaidItem] ADD  DEFAULT ((0)) FOR [type]
GO

ALTER TABLE [dbo].[PaidItem] ADD  DEFAULT ((0)) FOR [rest_item_count]
GO

ALTER TABLE [dbo].[PaidItem] ADD  DEFAULT ((0)) FOR [confirmed]
GO

ALTER TABLE [dbo].[PaidItem] ADD  DEFAULT ('9999-12-31') FOR [confirmed_time]
GO

ALTER TABLE [dbo].[PaidItem] ADD  DEFAULT ('9999-12-31') FOR [valid_time]
GO

ALTER TABLE [dbo].[PaidItem] ADD  DEFAULT ('9999-12-31') FOR [taken_time]
GO

ALTER TABLE [dbo].[PaidItem] ADD  DEFAULT ((0)) FOR [isCancel]
GO

und als kleines goody eine smp die von mir selbst erstellt wurde
mit dieser kannst du jedem account ein item in die shopbox packen

 Spoiler

USE [Telecaster]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE PROCEDURE [dbo].[insert_shopbox_to_all_from_globalvariable]
@item_id	INT,
@anzahl	INT
AS

DECLARE @index int,@max int,@account_id int,@buy_id int

set @max = (Select count(*) from Auth.dbo.Accounts)
set @index = 0
set @account_id = 0

WHILE @index < @max
BEGIN
	IF EXISTS(SELECT account_id from Auth.dbo.Accounts where account_id = @index)
		BEGIN
			set @buy_id = (select ISNULL(max(buy_id)+1, 0) from dbo.PaidItem)
			IF EXISTS(SELECT * FROM dbo.PaidItem WHERE account_id = @index AND item_code = @item_id)
				BEGIN
					UPDATE dbo.Paiditem set item_count = item_count+@anzahl,rest_item_count = rest_item_count+@anzahl where account_id = @index and item_code = @item_id
				END
			ELSE
				BEGIN
					INSERT INTO [dbo].[PaidItem]([buy_id],[account_id],[avatar_id],[avatar_name],[server_name],[taken_account_id],[taken_avatar_id],[taken_avatar_name],[taken_server_name],[item_code],[item_count],[type],[rest_item_count],[confirmed],[confirmed_time],[bought_time],[valid_time],[taken_time],[isCancel])
					VALUES(@buy_id,@index,0,'','',@index,0,'','',@item_id,@anzahl,0,@anzahl,1,GETDATE(),GETDATE(),GETDATE()+300,GETDATE(),0)
				END
			set @index = @index + 1
		END
	ELSE
		BEGIN
			set @index = @index + 1
		END
END

RETURN @@ERROR


GO

ausführen kann man sie auf folgende weise:

Use Telecaster
exec insert_shopbox_to_all_from_globalvariable item_id,anzahl

[Kuchen31]

servus, hat mal grad jemand den namen+model name von der kreatur, indie sich gms mal ganz gerne verwandeln ?

[Sherock]

2015/12/26 15:08:34 DB COM ERROR(Thread:2, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateGlobalVariable(dbo.smp_set_global_variable) : Transaction (Process ID 67) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2015/12/26 15:08:48 DB COM ERROR(Thread:2, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_DeleteAuctionInfo(dbo.smp_delete_auction_info) : Transaction (Process ID 92) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2015/12/26 15:08:52 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_DeleteAuctionInfo(dbo.smp_delete_auction_info) : Transaction (Process ID 103) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2015/12/26 15:08:54 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_DeleteAuctionInfo(dbo.smp_delete_auction_info) : Transaction (Process ID 66) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2015/12/26 15:08:58 DB COM ERROR(Thread:1, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_DeleteAuctionInfo(dbo.smp_delete_auction_info) : Transaction (Process ID 67) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2015/12/26 15:08:59 DB COM ERROR(Thread:2, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_DeleteAuctionInfo(dbo.smp_delete_auction_info) : Transaction (Process ID 96) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2015/12/26 15:09:00 DB COM ERROR(Thread:1, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_DeleteAuctionInfo(dbo.smp_delete_auction_info) : Transaction (Process ID 79) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2015/12/26 15:09:01 DB COM ERROR(Thread:2, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_DeleteAuctionInfo(dbo.smp_delete_auction_info) : Transaction (Process ID 109) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2015/12/26 15:09:38 DB COM ERROR(Thread:3, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_DeleteAuctionInfo(dbo.smp_delete_auction_info) : Transaction (Process ID 128) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2015/12/26 15:11:25 DB COM ERROR(Thread:3, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_DeleteAuctionInfo(dbo.smp_delete_auction_info) : Transaction (Process ID 110) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2015/12/26 15:12:24 DB COM ERROR(Thread:2, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_DeleteAuctionInfo(dbo.smp_delete_auction_info) : Transaction (Process ID 74) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2015/12/26 15:12:45 DB COM ERROR(Thread:3, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_DeleteAuctionInfo(dbo.smp_delete_auction_info) : Transaction (Process ID 81) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2015/12/26 17:51:10 DB COM ERROR(Thread:1, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_DeleteAuctionInfo(dbo.smp_delete_auction_info) : Transaction (Process ID 90) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2015/12/26 17:51:15 DB COM ERROR(Thread:2, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_DeleteAuctionInfo(dbo.smp_delete_auction_info) : Transaction (Process ID 79) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2015/12/26 17:51:18 DB COM ERROR(Thread:1, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_DeleteAuctionInfo(dbo.smp_delete_auction_info) : Transaction (Process ID 86) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2015/12/26 17:51:19 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_DeleteAuctionInfo(dbo.smp_delete_auction_info) : Transaction (Process ID 78) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2015/12/26 17:51:20 DB COM ERROR(Thread:1, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_DeleteAuctionInfo(dbo.smp_delete_auction_info) : Transaction (Process ID 90) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2015/12/26 17:51:21 DB COM ERROR(Thread:1, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_DeleteAuctionInfo(dbo.smp_delete_auction_info) : Transaction (Process ID 96) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2015/12/26 17:51:23 DB COM ERROR(Thread:1, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_DeleteAuctionInfo(dbo.smp_delete_auction_info) : Transaction (Process ID 168) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2015/12/26 17:51:25 DB COM ERROR(Thread:1, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_DeleteAuctionInfo(dbo.smp_delete_auction_info) : Transaction (Process ID 116) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2015/12/26 17:51:25 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_DeleteAuctionInfo(dbo.smp_delete_auction_info) : Transaction (Process ID 91) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

where is the problem ?

[ThunderNikk]

Another process won.

[.BlackCat.]

It's being long time since I didn't touch Rappelz developement so take it easy on me please .
So I'm using the files from Ghost informatics release however when I try to open the ItemShop Inventory (from my In game inventory) , nothing really happens ?

I'm pretty sure it's related to GameServer.opt , I thought it's (game.cash_usable_server:1) but seems like it's not . ?

GRACIAS !

[Sooperman130]

Hello,

Having issues with Private server, i have searched the forums and seen alot of people getting flamed for it but not many answers given

I have tried a few but still no luck

I have the server running and i can connect to it myself and play but cant get anyone on lan network or hamachi or with my isp ip

Auth.opt

 Spoiler

#Database configuration
auth.db.server:127.0.0.1
auth.db.port:1433
auth.db.name:auth
auth.db.account:sa

auth.clients.maxpublicserveridx:10

#Server Index Offset Column Name
sql.db_account.column.serveridxoffset:server_list_ mask

#include config in common.opt
%include:common.opt

common.opt

 Spoiler

#Write trace log messages to file and show only info log messages on console
core.log.level:trace
core.log.consolelevel:info

#Enable traffic dump, will be in traffic_log folder (default off)
#trafficdump.enable:true

#The password is in plain text if you have one
auth.db.password:******
auth.db.salt:5dd23
#You can make auth.dbo.Accounts.[password] by visiting:
# (KEY+PASSWORD = hashed password)[No spaces between KEY and PASSWORD]
# Copy the resulting md5 into the password field of your account entry


#Where clients will connect (this is default values)
auth.clients.ip:127.0.0.1
auth.clients.port:58422
auth.clients.des_key:MERONG

#Where the gameserver will connect (this is default values)
auth.gameserver.ip:127.0.0.1
auth.gameserver.port:4502

#Upload configuration, use "upload" directory for guild icons
upload.dir=upload
upload.clients.ip=127.0.0.1
upload.clients.port=32214
#Use port 5000 for the guild icon mini webserver (the listen ip is also upload.clients.ip)
upload.clients.webport:5000

#Where the gameserver will connect (this is default values)
upload.gameserver.ip:127.0.0.1
upload.gameserver.port:4616

#Only for SQL Server: speed up selects with NOLOCK
sql.db_account.query:SELECT * FROM Accounts WITH(NOLOCK) WHERE login_name = ? AND password = ?;

gameserver.opt

 Spoiler

S:app.name3thSquad
T:auth.server_idx:1
S:auth.server_name3thSquad

S:db.c.server:127.0.0.1
S:db.c.name:arcadia
S:db.c.account:********
S:db.c._password:******
S:db.user.server:127.0.0.1
S:db.user.name:telecaster
S:db.user.account:*******
S:db.user._password:********

N:io.port:15574
S:io.auth.ip:127.0.0.1
S:io.ip_address:25.147.100.194 <----- Hamchi IP, also tried ISP IP and 127.0.0.1, nobody can connect
S:log.chat.ip:127.0.0.1
S:log.ip:127.0.0.1

T:log.chat.working:0
T:log.working:0
T:log.disable:1
S:game.mem_usage_info_save_interval:9999999
F:game.base_ethereal_durability_consumption_on_dam age:.1
F:game.base_ethereal_durability_consumption_on_ski ll_attack:.1
F:game.base_ethereal_durability_consumption_on_nor mal_attack:.1
F:game.pvp_damage_rate_for_summon:.12
F:game.pvp_damage_rate_for_player:.08
S game.exp_rate:5
S game.item_drop_rate:1
S game.gold_drop_rate:1
S game.chaos_drop_rate:2
T game.apply_stamina_bonus_in_premium_pcb:1
F game.premium_pcbang_bonus_rate:.1
F game.premium_pcbang_chaos_bonus_rate:.1
F game.premium_pcbang_gold_bonus_drop_rate:.1
F game.premium_pcbang_item_bonus_drop_rate:.1
F game.premium_pcbang_chaos_bonus_drop_rate:.1
F game.ally_pcbang_bonus_rate:.1
S game.ally_pcbang_chaos_bonus_rate:.1
T:game.update.version:24
T:game.max_level:180
T:game.PKServer:0
T:game.AdultServer:0
T:game.cash_usable_server:1
S:game.local_flag:4
T:game.min_global_chat_usable_level:10
T:game.use_auto_trap:0
T:game.use_auto_jail:0
T:game.ServiceServer:0
N:console.port:44554
S:console.allow_ip:127.0.0.1
S:console._password:****
S:io.upload.ip:127.0.0.1
S:io.upload.port:4616


S:game.guild_icon_base_url:
S:game.url_list:guild.url|
S:game.server_screenshot_url:
S:game.helpdesk_url:
S:game.newbiehelp_asura_url:
S:game.newbiehelp_deva_url:
S:game.newbiehelp_gaia_url:
S:game.local_setting_list:log.ip|log.chat.ip|io.au th.ip|io.ip_address|db.c.server|db.user.server|N game.periodical_npc_adjustment
T:game.disable_trade:0
T:game.disable_booth:0
S:game.enhance_fail_type:2
T:game.monster_pathfinding:1
T:game.monster_wandering:1
T:game.no_collision_check:0
T:game.no_skill_cooltime:0
N:game.item_hold_time:2500
T:db.user.thread:4

Launcher

 Spoiler

RappelzCmdLauncher.exe sframe.exe /auth_ip:25.147.100.194 /auth_port:58422 /use_nprotect:0 /help_url_w:611 /help_url_h:625 /locale:ASCII /country:US /cash /commercial_shop /layout_dir:6 /layout_auto:0 /cash_url_w:800 /cash_url_h:631

I have tried /auth_ip = Hamachi, ISP IP, and 127.0.0.1
I can only connect when its 127.0.0.1
but nobody else can

I have forwarded [Ports: 58422, 32214, 15574] through my router for ISP IP setting still no avail

any help would be appreciated thanks

[ThunderNikk]

Originally Posted by .BlackCat.

It's being long time since I didn't touch Rappelz developement so take it easy on me please .
So I'm using the files from Ghost informatics release however when I try to open the ItemShop Inventory (from my In game inventory) , nothing really happens ?

I'm pretty sure it's related to GameServer.opt , I thought it's (game.cash_usable_server:1) but seems like it's not . ?

GRACIAS !

Did you perform the billing fixes in the "How to set up 9.1" guide?

Just make sure you set total_jp to bigint instead of int though.

@Sooperman130

You have set all of the listening IPs to 127.0.0.1 and only the local computer running the servers will be able to connect to auth.

In the default file they are listening IPs wich should be set to 0.0.0.0

Take a look at the preconfigured auth.opt and include again.

[Sooperman130]

Its now working with hamachi thank you

[Sand Dragon]

Hi all, studying taking up most of my time but on holiday now and looking at this tread I noticed some custom monsters and wanted to know,
All custom files need to be hashed and put into client resource
Updated monster resource bd hashed and put into client resource.

Do I need to put anything into the server side to make this work

Cheers guys and thanks

[mohammad0011]

Hi,
Is there a way to monitor the GM codes executed in the server?
Does the server log the GM cods executed by GM?

Thanks in advance.

[TheOnlyOneRaskim]

Originally Posted by mohammad0011

Hi,
Is there a way to monitor the GM codes executed in the server?
Does the server log the GM cods executed by GM?

Thanks in advance.

Using the LogServer, yes.

[bertie2008]

Originally Posted by Sand Dragon

Hi all, studying taking up most of my time but on holiday now and looking at this tread I noticed some custom monsters and wanted to know,
All custom files need to be hashed and put into client resource
Updated monster resource bd hashed and put into client resource.

Do I need to put anything into the server side to make this work

Cheers guys and thanks

Nothing needs to be done on server side other than create a new entry into your monster resource data base

[Sooperman130]

Ive been playing around with creating my own markets in the database for custom npc's but alot of my database is in arabic for item names, any way of fixing this?

EDIT****
with a little more messing around and using my brain i figured it out

in database rename
StringResource to StringResource_AR

and rename StringResource_EN to StringResource

It fixed the item names

[TheOnlyOneRaskim]

Originally Posted by Sooperman130

Ive been playing around with creating my own markets in the database for custom npc's but alot of my database is in arabic for item names, any way of fixing this?

EDIT****
with a little more messing around and using my brain i figured it out

in database rename
StringResource to StringResource_AR

and rename StringResource_EN to StringResource

It fixed the item names

Or simple import Datas from desired rdb to stringresource table..