Register for your free account! | Forgot your password?

You last visited: Today at 06:00

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

 

[Help please!]

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jul 2012
Posts: 18
Received Thanks: 1
[Help please!]

I can not configure the Donut Shop. Displays an error ...
You must register and activate your account in order to view images.
Sorry for bad English. Write a translator http://translate.google.com



sokolikov is offline  
Old   #2
 
elite*gold: 0
Join Date: Oct 2011
Posts: 275
Received Thanks: 265
It requires dbcondig.php while in folder u have dbconfig.php just rename it


→Striker← is offline  
Thanks
2 Users
Old   #3
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
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.
c1ph3r is offline  
Old   #4
 
elite*gold: 0
Join Date: Jul 2012
Posts: 18
Received Thanks: 1
Quote:
Originally Posted by →Striker← View Post
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.


sokolikov is offline  
Old   #5
 
elite*gold: 0
Join Date: Oct 2011
Posts: 275
Received Thanks: 265
Use these to add the right tables in your Auth


Cash/Points


and this query to Add Items


Change whats in green
→Striker← is offline  
Thanks
2 Users
Old   #6
 
elite*gold: 0
Join Date: Oct 2011
Posts: 225
Received Thanks: 12
Vllt. ein insert beispiel? ^^
struppi is offline  
Old   #7
 
elite*gold: 0
Join Date: Nov 2011
Posts: 980
Received Thanks: 1,007
Quote:
Originally Posted by struppi View Post
Vllt. ein insert beispiel? ^^
Also jetzt gehts wohl los, oder?

Das ist ne Insert Query, du brauchst nur deine values benutzen....
TheOnlyOneRaskim is offline  
Old   #8
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
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...
c1ph3r is offline  
Old   #9
 
elite*gold: 0
Join Date: Oct 2011
Posts: 225
Received Thanks: 12
Ok soweit funzt das Teil
Aber wenn man was gekauft hat, ist das bestimmte Item nicht im Inventar obwohl es erfolgreich gekauft wurde!
struppi is offline  
Old   #10
 
elite*gold: 0
Join Date: Nov 2011
Posts: 980
Received Thanks: 1,007
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!
TheOnlyOneRaskim is offline  
Old   #11
 
elite*gold: 0
Join Date: Oct 2011
Posts: 275
Received Thanks: 265
I had this issue before then i found out i had no dbo.smp_takeout_commercial_item
Use this query to create it

Code:
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
→Striker← is offline  
Thanks
1 User
Old   #12
 
elite*gold: 0
Join Date: Jul 2012
Posts: 18
Received Thanks: 1
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
sokolikov is offline  
Old   #13
 
elite*gold: 0
Join Date: Oct 2011
Posts: 225
Received Thanks: 12
jop funzt. Thanks
struppi is offline  
Old   #14
 
elite*gold: 0
Join Date: Jul 2012
Posts: 18
Received Thanks: 1
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


sokolikov is offline  
Reply



« Previous Thread | Next Thread »



All times are GMT +2. The time now is 06:00.


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

Support | Contact Us | FAQ | Advertising | Privacy Policy
Copyright ©2017 elitepvpers All Rights Reserved.