Item Mall - Full Pkosite TopII Template Mall

Go down

Item Mall - Full Pkosite TopII Template Mall

Post  Admin on Sun Oct 23, 2011 8:31 pm

Here, i decided to release full item mall.
This version of item mall is the one used by http://one-hit.net

If you decide to donate: http://one-hit.net/donate.html
Any amount is welcomed.

Website link:
multiupload.com BUU8LJCAJ7

Database:

IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'Auction')
DROP DATABASE [Auction]
GO
CREATE DATABASE [Auction] ON (NAME = N'Auction_Data', FILENAME = N'C:\xampp\htdocs\data\Auction_Data.MDF' , SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME = N'Auction_Log', FILENAME = N'C:\xampp\htdocs\data\Auction_Log.LDF' , SIZE = 5, MAXSIZE = 2097152, FILEGROWTH = 10%)
COLLATE SQL_Latin1_General_CP1_CI_AS
GO
exec sp_dboption N'Auction', N'autoclose', N'false'
GO
exec sp_dboption N'Auction', N'bulkcopy', N'false'
GO
exec sp_dboption N'Auction', N'trunc. log', N'false'
GO
exec sp_dboption N'Auction', N'torn page detection', N'true'
GO
exec sp_dboption N'Auction', N'read only', N'false'
GO
exec sp_dboption N'Auction', N'dbo use', N'false'
GO
exec sp_dboption N'Auction', N'single', N'false'
GO
exec sp_dboption N'Auction', N'autoshrink', N'false'
GO
exec sp_dboption N'Auction', N'ANSI null default', N'false'
GO
exec sp_dboption N'Auction', N'recursive triggers', N'false'
GO
exec sp_dboption N'Auction', N'ANSI nulls', N'false'
GO
exec sp_dboption N'Auction', N'concat null yields null', N'false'
GO
exec sp_dboption N'Auction', N'cursor close on commit', N'false'
GO
exec sp_dboption N'Auction', N'default to local cursor', N'false'
GO
exec sp_dboption N'Auction', N'quoted identifier', N'false'
GO
exec sp_dboption N'Auction', N'ANSI warnings', N'false'
GO
exec sp_dboption N'Auction', N'auto create statistics', N'true'
GO
exec sp_dboption N'Auction', N'auto update statistics', N'true'
GO
use [Auction]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ItemMall]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ItemMall]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[StorageBox]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[StorageBox]
GO
CREATE TABLE [dbo].[ItemMall] (
[ItemName] [char] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[ItemPrice] [int] NOT NULL ,
[ItemDesc] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Quota] [int] NOT NULL ,
[Icon] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[cType] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[ItemID] [int] NOT NULL ,
[quantity] [int] NOT NULL ,
[category] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[MallID] [int] IDENTITY (1, 1) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[StorageBox] (
[storage_id] [int] IDENTITY (1, 1) NOT NULL ,
[act_id] [int] NOT NULL ,
[item_id] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[assigned] [int] NOT NULL ,
[assigned_char] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[assigned_date] [datetime] NULL ,
[Icon] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[itemName] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[quantity] [int] NOT NULL
) ON [PRIMARY]
GO
avatar
Admin
Admin

Posts : 23
Join date : 2011-10-23

View user profile http://bloodyserverguide.forumotion.com

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum