Volcom880
Grandmaster Cheater
 Reputation: 0
Joined: 16 Jan 2007
Posts: 942
|
 Posted: Fri Nov 28, 2008 4:04 pm Post subject: Making Item Shop |
 |
|
1.payments go into paypal_payment_info, if they are new their aid is null, if they are activated the AID is set to the account AID of who bought it, and paypal_activedonations gets a new entry for the active donation
2.Donation_Shop hat a player can buy if its an item, it has a specific type code, and the items they get are read from donation_items
3.donation_purchases has a record for everything a player has bought.
Here is what I have so far.
| Code: | USE [GunZDB]
GO
CREATE TABLE [dbo].[paypal_payment_info](
[PrimaryKey] [bigint] IDENTITY(395,1) NOT NULL,
[firstname] [varchar](100) NOT NULL,
[lastname] [varchar](100) NOT NULL,
[buyer_email] [varchar](100) NOT NULL,
[street] [varchar](100) NOT NULL,
[city] [varchar](50) NOT NULL,
[state] [char](3) NOT NULL,
[zipcode] [varchar](11) NOT NULL,
[memo] [varchar](255) NULL,
[itemname] [varchar](255) NULL,
[itemnumber] [varchar](50) NULL,
[os0] [varchar](20) NULL,
[on0] [varchar](50) NULL,
[os1] [varchar](20) NULL,
[on1] [varchar](50) NULL,
[quantity] [char](3) NULL,
[paymentdate] [varchar](50) NOT NULL,
[paymenttype] [varchar](10) NOT NULL,
[txnid] [varchar](30) NOT NULL,
[mc_gross] [varchar](6) NOT NULL,
[mc_fee] [varchar](5) NOT NULL,
[paymentstatus] [varchar](15) NOT NULL,
[pendingreason] [varchar](10) NULL,
[txntype] [varchar](10) NOT NULL,
[tax] [varchar](10) NULL,
[mc_currency] [varchar](5) NOT NULL,
[reasoncode] [varchar](20) NOT NULL,
[custom] [varchar](255) NOT NULL,
[country] [varchar](20) NOT NULL,
[datecreation] [datetime] NOT NULL,
[AID] [bigint] NULL,
[parenttxnid] [varchar](30) NULL,
CONSTRAINT [PK_paypal_payment_info] PRIMARY KEY CLUSTERED
(
[PrimaryKey] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE [dbo].[paypal_activedonations](
[donationID] [bigint] IDENTITY(280,1) NOT NULL,
[Amount] [float] NOT NULL,
[AID] [bigint] NOT NULL,
[TXNID] [varchar](50) NULL,
[dateadded] [datetime] NOT NULL,
CONSTRAINT [PK_paypal_activedonations] PRIMARY KEY CLUSTERED
(
[donationID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE [dbo].[donation_shop](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [text] NULL,
[type] [int] NULL,
[price] [float] NULL,
[description] [text] NULL,
[serviceid] [int] NULL,
[deactivated] [int] NOT NULL,
[sex] [int] NULL,
[gm] [int] NULL,
CONSTRAINT [PK_donation_shop] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
CREATE TABLE [dbo].[donation_purchases](
[id] [bigint] IDENTITY(1,1) NOT NULL,
[shopid] [bigint] NULL,
[accountid] [bigint] NULL,
[charid] [bigint] NULL,
[datecreated] [datetime] NOT NULL,
[amount] [float] NOT NULL,
CONSTRAINT [PK_donation_purchases] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE [dbo].[donation_items](
[id] [bigint] IDENTITY(1,1) NOT NULL,
[setid] [bigint] NULL,
[itemid] [bigint] NULL,
[description] [varchar](100) NULL,
[name] [varchar](50) NULL,
[type] [int] NULL,
[hp] [int] NULL,
[ap] [int] NULL,
[weight] [int] NULL,
[picsource] [varchar](50) NULL,
[damage] [int] NULL,
[speed] [int] NULL,
CONSTRAINT [PK_donation_items] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] |
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
