[Help please!]

[sokolikov]

I can not configure the Donut Shop. Displays an error ...

Sorry for bad English. Write a translator

[→Striker←]

It requires dbcondig.php while in folder u have dbconfig.php just rename it

[c1ph3r]

look into the error. In the CS Files there are many different writings of dbconfig.php The Server can't find the file because the name is written wrong.

[sokolikov]

Originally Posted by →Striker←

It requires dbcondig.php while in folder u have dbconfig.php just rename it

Thank you very much The sight did not seem to complain, and so did not notice ...
But the shop is empty .. It's sad.

[→Striker←]

Use these to add the right tables in your Auth

 Spoiler

USE [Auth]
GO

/****** Object:  Table [dbo].[items_shop]    Script Date: 30/07/2012 00:27:03 Baha Striker******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[items_shop](
	[id] [int] NOT NULL,
	[item_name] [text] NULL,
	[item_id] [int] NULL,
	[item_desc] [text] NULL,
	[item_image] [varchar](256) NULL,
	[item_price] [int] NULL,
	[item_price_p] [int] NULL,
	[count] [int] NULL,
	[valide] [int] NULL,
	[item_categ] [int] NULL,
	[priorite] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

Cash/Points

 Spoiler

USE [Auth]
GO

/****** Object:  Table [dbo].[membre]    Script Date: 30/07/2012 00:29:54 Baha Striker ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[membre](
	[id] [int] NULL,
	[cash] [int] NULL
) ON [PRIMARY]

GO

and this query to Add Items

 Spoiler

Use [Auth]
Go

INSERT [dbo].[items_shop] ([id], [item_name], [item_id], [item_desc], [item_image], [item_price], [item_price_p], [count], [valide], [item_categ]) VALUES (id, N'NAME' , Item ID , N'Description' , N'icon name' , price , 1 , 1 , 1 , 1)

Change whats in green

[struppi]

Vllt. ein insert beispiel? ^^

[TheOnlyOneRaskim]

Originally Posted by struppi

Vllt. ein insert beispiel? ^^

Also jetzt gehts wohl los, oder?

Das ist ne Insert Query, du brauchst nur deine values benutzen....

[c1ph3r]

Use [Auth]
Go

INSERT [dbo].[items_shop] ([id], [item_name], [item_id], [item_desc], [item_image], [item_price], [item_price_p], [count], [valide], [item_categ]) VALUES (1, N'Meine Mudda' , 540004 , N'Meine Mudda stinkt nach Fisch' , N'meinemudda.jpg' , 99 , 1 , 1 , 1 , 1)


So wird die Asta Karte mit Namen "Meine Mudda" und der Beschreibung "Meine Mudda stinkt nach Fisch" und Icon meinemudda.jpg für 99 Whatever mit der ID 1 hinzugefügt. Hoffe das is jetzt idiotensicher...

[struppi]

Ok soweit funzt das Teil
Aber wenn man was gekauft hat, ist das bestimmte Item nicht im Inventar obwohl es erfolgreich gekauft wurde!

[TheOnlyOneRaskim]

Weil das die dbo.Paiditem regelt.


Also echt, willst sicher nen CS server auf die Beine stellen, wo andre die Arbeit für dich machen.

Lass es einfach sein, du bist nicht geschaffen für Sachen, die ein Hirn oder Eigeninitiative erfordern!

[→Striker←]

I had this issue before then i found out i had no dbo.smp_takeout_commercial_item
Use this query to create it

USE [Telecaster]
GO

/****** Object:  StoredProcedure [dbo].[smp_takeout_commercial_item]    Script Date: 8/1/2012 9:38:40 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO




CREATE PROCEDURE [dbo].[smp_takeout_commercial_item]

@OUT_ITEM_CODE          INT OUTPUT,
@IN_SID                 INT,
@IN_COUNT               INT,
@IN_ACCOUNT_ID          INT,
@IN_AVATAR_ID           INT,
@IN_AVATAR_NAME         VARCHAR(61),
@IN_SERVER_NAME         VARCHAR(30),
@IN_TRANSACTION_CODE	INT,
@IN_IDX					INT
 
AS
SET NOCOUNT ON

SET @OUT_ITEM_CODE = 0

DECLARE @RET INT
SET @RET = -1

DECLARE @REST_ITEM_COUNT INT
SET @REST_ITEM_COUNT = -1

-- °¹¼ِ ہج»َ
IF @IN_COUNT < 1
BEGIN
    GOTO ON_END
END

BEGIN TRANSACTION

	SELECT @REST_ITEM_COUNT = rest_item_count FROM dbo.PaidItem WHERE sid = @IN_SID;

	IF @REST_ITEM_COUNT < @IN_COUNT
	BEGIN
		ROLLBACK TRANSACTION
        GOTO ON_END
	END

	-- Remove item(s) from Item Box
	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_SID and taken_account_id = @IN_ACCOUNT_ID;
    SET @RET = 0

	DECLARE @ACCOUNT_ID INT
	SET @ACCOUNT_ID = -1

	SELECT @OUT_ITEM_CODE = item_code, @ACCOUNT_ID = taken_account_id from dbo.PaidItem where sid = @IN_SID;

	IF @ACCOUNT_ID <> @IN_ACCOUNT_ID
		BEGIN
			SET @OUT_ITEM_CODE = 0
			ROLLBACK TRANSACTION
			GOTO ON_END
		END

	-- Add the item(s) to the character
	INSERT INTO dbo.Item (

		sid,							-- 0
		owner_id,						-- 1
		account_id,						-- 2
		summon_id,						-- 3
		auction_id,						-- 4
		keeping_id,						-- 5
		idx,							-- 6
		code,							-- 7
		flag,							-- 8
		cnt,							-- 9
		[level],						-- 10
		enhance,
		ethereal_durability,						-- 11
		endurance,						-- 12
		gcode,							-- 13
		create_time,						-- 14
		wear_info,						-- 15
		socket_0,						-- 16
		socket_1,						-- 17
		socket_2,						-- 18
		socket_3,						-- 19
		remain_time,						-- 20
		elemental_effect_type,					-- 21
		elemental_effect_expire_time,				-- 22
		elemental_effect_attack_point,				-- 23
		elemental_effect_magic_point,				-- 24
		update_time						-- 25

	)
	VALUES (
	
		@IN_TRANSACTION_CODE,					-- 0
		@IN_AVATAR_ID,						-- 1
		@IN_ACCOUNT_ID,						-- 2
		0,							-- 3
		0,							-- 4
		0,							-- 5
		@IN_IDX,						-- 6
		@OUT_ITEM_CODE,						-- 7
		0,							-- 8
		@IN_COUNT,						-- 9
		0,							-- 10
		0,
		0,							-- 11
		0,							-- 12
		0,							-- 13
		GETDATE(),						-- 14	
		-1,							-- 15
		0,							-- 16
		0,							-- 17
		0,							-- 18
		0,							-- 19
		0,							-- 20
		0,							-- 21
		0,							-- 22
		0,							-- 23
		0,							-- 24
		GETDATE()						-- 25
	);

	SET @RET = @@ERROR

	IF @RET <> 0
	BEGIN
		ROLLBACK TRANSACTION
        GOTO ON_END
	END

COMMIT TRANSACTION

ON_END:
RETURN @RET



GO

[sokolikov]

Excellent! I put the bottle fairy goddess, click "buy", but she never appears. In the backpack, no, no to the store.
Again, sorry for my English

[struppi]

jop funzt. Thanks

[sokolikov]

I've already figured out, but now another problem. Things that do not appear in the store to pick up. The procedures that you have given above, found the table did.
Sorry for my english