CabalToolz V3.1

[benng]

I'm using CabalToolz 3.1 currently and most of it works fine for me.
However, I still can't figure out how to get the Ranking on frontpage working (mod.tophero.php)

It basically doesn't show any characters.
Pretty weird since the normal Ranking, does work fine.

btw, I did add the new columns to SQL etc ;)

hi i am having the same problem with you.If happens that you had solved it pls let me know

[zimiro]

I am in error in the script cabal cash
when I run query he does not accept


use CabalCash;
CREATE TABLE [dbo].[WebShop](
[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,
[Options] [int] NOT NULL,
[Image] [varchar](200) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Cash] [int] NULL,
[Alz] [int] NULL,
[Category] [int] NOT NULL,
[Available] [int] NOT NULL,
[TimeLimit] [int] NOT NULL,
[Total] [int] NOT NULL CONSTRAINT [DF_WebShop_Total] DEFAULT ((0)))

CREATE TABLE [dbo].[WebShop_Category](
[ID] [smallint] IDENTITY(1,1) NOT NULL,
[Category] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Access] [smallint] NOT NULL)

[Nadiell]

@zimiro,don't copy even "use CabalCash;"
copy and execute follow in your query :
CREATE TABLE [dbo].[WebShop](
[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,
[Options] [int] NOT NULL,
[Image] [varchar](200) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Cash] [int] NULL,
[Alz] [int] NULL,
[Category] [int] NOT NULL,
[Available] [int] NOT NULL,
[TimeLimit] [int] NOT NULL,
[Total] [int] NOT NULL CONSTRAINT [DF_WebShop_Total] DEFAULT ((0)))

-------- this is first query ,this is secon :

CREATE TABLE [dbo].[WebShop_Category](
[ID] [smallint] IDENTITY(1,1) NOT NULL,
[Category] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Access] [smallint] NOT NULL)

maybe u understand,thanks

[Acnathon]

@zimiro,don't copy even "use CabalCash;"
copy and execute follow in your query :
CREATE TABLE [dbo].[WebShop](
[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,
[Options] [int] NOT NULL,
[Image] [varchar](200) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Cash] [int] NULL,
[Alz] [int] NULL,
[Category] [int] NOT NULL,
[Available] [int] NOT NULL,
[TimeLimit] [int] NOT NULL,
[Total] [int] NOT NULL CONSTRAINT [DF_WebShop_Total] DEFAULT ((0)))

-------- this is first query ,this is secon :

CREATE TABLE [dbo].[WebShop_Category](
[ID] [smallint] IDENTITY(1,1) NOT NULL,
[Category] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Access] [smallint] NOT NULL)

maybe u understand,thanks

If im not wrong this should be [ID] [int] IDENTITY(1,1) NOT NULL

[busternr]

very cool