help vitth Chumpy's.CashShop.v1.5

[eragons]

I dont understand how to set that shop i know how to config it but the databese is the problem plz canenybody plz give me cashshop database??

[MentaL]

[robson10]

post screen shoot of your problem

[eragons]

http://www.bildem.lv/public/view/full/639
http://www.bildem.lv/public/view/full/640
there is them

[jm_lapido]

You did not follow this instruction:

Create a new database called "CashShop" and run database/db.sql on it.

[eragons]

but I dont understand how to run on it that descripcion is small and many dont understand specialy me :p D:D so plz help

[eragons]

but cant you yust give me plz that databaze?? I will try to do what you wrote but still plz give me that databaze
and another question how to add image to items??

[Helvis]

Setting clear. How do I add cashshop items?
Sorry for my bad english

[cypher]

read the effing readme!

[chumpywumpy]

but cant you yust give me plz that databaze?? I will try to do what you wrote but still plz give me that databaze
and another question how to add image to items??

People struggle with restoring databases even more which is why i did it as a query. Just create a new db and run that query on it and it will create the db tables.

Setting clear. How do I add cashshop items?
Sorry for my bad english

Log into the cash shop with an account that has at least 1 GM (nation=3) and you will get an admin button on the left.

[eragons]

yes I know that now thanks I just didn't know obout that how to het those storedprocedures :p

[chumpywumpy]

Find the "New Query" button on the toolbar. In SQL2005/2008 is is called literally "New Query" in the management studio and in SQL2000 it is the leftmost icon that looks like a text document. Run the query below and it will create the DB and tables for you.

CREATE DATABASE cashshop
GO
USE cashshop
GO

CREATE TABLE [dbo].[Bank] (
[UserNum] [int] NOT NULL ,
[Alz] [bigint] NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ShopItems] (
[Id] [int] IDENTITY (1, 1) NOT NULL ,
[Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Description] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ItemIdx] [int] NOT NULL ,
[DurationIdx] [int] NOT NULL ,
[ItemOpt] [int] NOT NULL ,
[Image] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Honour] [int] NULL ,
[Alz] [int] NULL ,
[Category] [int] NOT NULL ,
[Available] [int] NOT NULL
) ON [PRIMARY]
GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO


CREATE PROCEDURE SetBankAlz( @UserNum int, @Alz bigint)
AS
BEGIN
BEGIN TRAN
IF NOT EXISTS( SELECT UserNum
FROM Bank
WHERE UserNum = @UserNum )
BEGIN
INSERT Bank (UserNum, Alz)
VALUES ( @UserNum, 0)
END
ELSE
BEGIN
UPDATE Bank
SET Alz = @Alz
WHERE UserNum = @UserNum
END
COMMIT TRAN
END


GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO

CREATE PROCEDURE [dbo].[GetBankAlz]( @UserNum int ) AS
BEGIN
if ( SELECT UserNum FROM Bank WHERE UserNum = @UserNum ) is Null
BEGIN
INSERT Bank ( UserNum, Alz)
VALUES( @UserNum, 0)
END
SELECT UserNum, Alz
FROM Bank
WHERE UserNum = @UserNum
END

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO