Help find Webshop 97-99i

[taria]

Please help find WebShop version 97-99. I found Shop DT Atualizado. But cannot login in. (cannot install)

[MentaL]

[Dope Boy One]

Please next time use prefix [Help] on your topic
View the Rules of each section you post please,

[Help] fixed

Regards Dope.

[karipidis]

$webshop['mssq']['host'] = 'localhost'; // Server Address (Host\ip)
$webshop['mssq']['user'] = 'sa'; // Username used for a connection
$webshop['mssq']['pass'] = 'password'; // Username's password
$webshop['mssq']['db'] = 'database'; // Database name
$webshop['mssq']['dbacc'] = ''; // If you are using 6databases - set this to 'Me_MuOnline' or whatever your account database is named. (v0.4)
$webshop['mssq']['use_md5'] = false; // Use md5 encrypted passwords (true/false)

something bad you added on configuartions..
also you have to install the SQL queries 1 time per file..AND then install every line 1 by 1 from create tables.sql for example:

-- Drop table WebShop if it exists
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WebShop]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[WebShop];

CREATE TABLE [dbo].[MEMB_CREDITS] ([memb___id] [varchar] (10) COLLATE Modern_Spanish_CI_AS NOT NULL ,[credits] [int] NOT NULL) ON [PRIMARY];
CREATE TABLE [dbo].[WebShop] ([uid] [int] IDENTITY (1, 1) NOT NULL ,[id] [int] NOT NULL ,[type] [int] NOT NULL ,[ex_type] [int] NOT NULL ,[name] [varchar] (51) COLLATE Modern_Spanish_CI_AS NOT NULL ,[credits] [int] NOT NULL ,[X] [int] NULL ,[Y] [int] NULL ,[luck] [int] NULL ,[skill] [int] NULL ,[hasLevel] [int] NULL ,[default_durability] [int] NULL ,[hasOption] [int] NOT NULL ,[optionType] [int] NOT NULL ,[category] [int] default 14,[stickLevel] [int] default 0,[maxitop] [int] default 0,[maxitlv] [int] default 0,[maxitxl] [int] default 0) ON [PRIMARY];
CREATE TABLE [dbo].[WebShop_Feedback] ([id] [int] IDENTITY (1, 1) NOT NULL ,[username] [varchar] (10) COLLATE Modern_Spanish_CI_AS NOT NULL ,[feedback] [nvarchar] (4000) COLLATE Modern_Spanish_CI_AS NOT NULL ,	[ts] [bigint] NOT NULL ) ON [PRIMARY];
CREATE TABLE [dbo].[WebShop_LOG] ([id] [int] IDENTITY (1, 1) NOT NULL ,[accountid] [varchar] (10) COLLATE Modern_Spanish_CI_AS NOT NULL ,[details] [text] COLLATE Modern_Spanish_CI_AS NOT NULL ,[dateline] [int] NOT NULL) ON [PRIMARY];
CREATE TABLE [dbo].[WebShop_UI] ([item] [varchar] (32) COLLATE Modern_Spanish_CI_AS NOT NULL ,	[credits] [int] NOT NULL) ON [PRIMARY];
CREATE TABLE [dbo].[WebShop_IPBlock] ([id] [int] IDENTITY (1, 1) NOT NULL ,[iprange] [varchar] (31) COLLATE Modern_Spanish_CI_AS NOT NULL ,[name] [varchar] (50) COLLATE Modern_Spanish_CI_AS NULL ,[displtxt] [nvarchar] (4000) COLLATE Modern_Spanish_CI_AS NULL,[attempts] [int] NOT NULL) ON [PRIMARY];
CREATE TABLE [dbo].[WebShop_Groups] ([id] [int] NOT NULL ,[name] [varchar] (30) COLLATE Modern_Spanish_CI_AS NOT NULL ,[credits] [int] NOT NULL ,[basedon] [int] NOT NULL ) ON [PRIMARY];
ALTER TABLE [dbo].[MEMB_CREDITS] WITH NOCHECK ADD CONSTRAINT [DF_MEMB_CREDITS_credits] DEFAULT (0) FOR [credits];
ALTER TABLE [dbo].[MEMB_CREDITS] WITH NOCHECK ADD CONSTRAINT [PK_MEMB_CREDITS] PRIMARY KEY  CLUSTERED ([memb___id]) ON [PRIMARY];
ALTER TABLE [dbo].[WebShop] WITH NOCHECK ADD CONSTRAINT [PK_WebShop_1] PRIMARY KEY  CLUSTERED ([uid]) ON [PRIMARY];
ALTER TABLE [dbo].[WebShop_LOG] WITH NOCHECK ADD CONSTRAINT [PK_WebShop_LOG] PRIMARY KEY  CLUSTERED ([id]) ON [PRIMARY];
ALTER TABLE [dbo].[WebShop_UI] WITH NOCHECK ADD CONSTRAINT [PK_WebShop_UI] PRIMARY KEY  CLUSTERED ([item])  ON [PRIMARY];
ALTER TABLE [dbo].[WebShop_UI] WITH NOCHECK ADD CONSTRAINT [DF_WebShop_UI_credits] DEFAULT (0) FOR [credits];
ALTER TABLE [dbo].[WebShop_IPBlock] WITH NOCHECK ADD CONSTRAINT [PK_WebShop_IPBlock] PRIMARY KEY  CLUSTERED ([id])  ON [PRIMARY];
ALTER TABLE [dbo].[WebShop_IPBlock] WITH NOCHECK ADD CONSTRAINT [DF_WebShop_IPBlock_name] DEFAULT ('IpBan') FOR [name],CONSTRAINT [DF_WebShop_IPBlock_displtxt] DEFAULT (N'You are not permited to access this area.') FOR [displtxt],CONSTRAINT [DF_WebShop_IPBlock_attempts] DEFAULT (0) FOR [attempts];
ALTER TABLE [dbo].[WebShop_Groups] WITH NOCHECK ADD CONSTRAINT [PK_WebShop_Groups] PRIMARY KEY  CLUSTERED ([id])  ON [PRIMARY];
ALTER TABLE [dbo].[WebShop_Groups] WITH NOCHECK ADD CONSTRAINT [DF_WebShop_Groups_credits] DEFAULT (0) FOR [credits],CONSTRAINT [DF_WebShop_Groups_basedon] DEFAULT (0) FOR [basedon];
ALTER TABLE [dbo].[WebShop_Feedback] WITH NOCHECK ADD CONSTRAINT [PK_WebShop_Feedback] PRIMARY KEY  CLUSTERED ([id])  ON [PRIMARY];

All these you have to install them and press ok 1 by 1 so you will add the first table
CREATE TABLE [dbo].[MEMB_CREDITS] ([memb___id] [varchar] (10) COLLATE Modern_Spanish_CI_AS NOT NULL ,[credits] [int] NOT NULL) ON [PRIMARY];
and press ok/run
then the second line only:
CREATE TABLE [dbo].[WebShop] ([uid] [int] IDENTITY (1, 1) NOT NULL ,[id] [int] NOT NULL ,[type] [int] NOT NULL ,[ex_type] [int] NOT NULL ,[name] [varchar] (51) COLLATE Modern_Spanish_CI_AS NOT NULL ,[credits] [int] NOT NULL ,[X] [int] NULL ,[Y] [int] NULL ,[luck] [int] NULL ,[skill] [int] NULL ,[hasLevel] [int] NULL ,[default_durability] [int] NULL ,[hasOption] [int] NOT NULL ,[optionType] [int] NOT NULL ,[category] [int] default 14,[stickLevel] [int] default 0,[maxitop] [int] default 0,[maxitlv] [int] default 0,[maxitxl] [int] default 0) ON [PRIMARY];
Then the third line only: CREATE TABLE [dbo].[WebShop_Feedback] ([id] [int] IDENTITY (1, 1) NOT NULL ,[username] [varchar] (10) COLLATE Modern_Spanish_CI_AS NOT NULL ,[feedback] [nvarchar] (4000) COLLATE Modern_Spanish_CI_AS NOT NULL , [ts] [bigint] NOT NULL ) ON [PRIMARY];

one by one the lines.. because most of the times they stop because of some errors you will understand if you try it.
Is great webshop i was using it almost 1 year for 97d version, works GREAT.