You last visited: Today at 21:47
Advertisement
[Help please!]
Discussion on [Help please!] within the Rappelz Private Server forum part of the Rappelz category.
08/01/2012, 13:45
#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 ...
Sorry for bad English. Write a translator
08/01/2012, 13:50
#2
elite*gold: 0
Join Date: Oct 2011
Posts: 275
Received Thanks: 266
It requires dbcondig.php while in folder u have dbconfig.php just rename it
08/01/2012, 13:58
#3
elite*gold: 0
Join Date: Sep 2008
Posts: 1,606
Received Thanks: 1,210
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.
08/01/2012, 14:20
#4
elite*gold: 0
Join Date: Jul 2012
Posts: 18
Received Thanks: 1
Quote:
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.
08/01/2012, 14:28
#5
elite*gold: 0
Join Date: Oct 2011
Posts: 275
Received Thanks: 266
Use these to add the right tables in your Auth
Code:
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
Code:
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
Use [Auth]id , N'NAME ' , Item ID , N'Description ' , N'icon name ' , price , 1 , 1 , 1 , 1)
Change whats in
green
08/01/2012, 17:01
#6
elite*gold: 0
Join Date: Oct 2011
Posts: 225
Received Thanks: 12
Vllt. ein insert beispiel? ^^
08/01/2012, 17:12
#7
elite*gold: 0
Join Date: Nov 2011
Posts: 978
Received Thanks: 1,011
Quote:
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....
08/01/2012, 17:46
#8
elite*gold: 0
Join Date: Sep 2008
Posts: 1,606
Received Thanks: 1,210
Use [Auth]
08/01/2012, 18:37
#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!
08/01/2012, 18:58
#10
elite*gold: 0
Join Date: Nov 2011
Posts: 978
Received Thanks: 1,011
Weil das die dbo.Paiditem regelt.
08/01/2012, 19:40
#11
elite*gold: 0
Join Date: Oct 2011
Posts: 275
Received Thanks: 266
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
08/02/2012, 11:56
#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.
08/02/2012, 18:45
#13
elite*gold: 0
Join Date: Oct 2011
Posts: 225
Received Thanks: 12
jop funzt. Thanks
08/03/2012, 12:02
#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.
All times are GMT +2. The time now is 21:48 .
![[Help please!]](https://www.elitepvpers.com/forum/iconimages/rappelz-private-server/help-please_ltr.gif){kind=small}
The sight did not seem to complain, and so did not notice ...
