View Single Post
  #1  
Old 03-22-2010, 03:42 PM
mapleblade mapleblade is offline
Epicness sausage
 
Join Date: May 2009
Posts: 180
Gender: Male
Credits: 6,583
mapleblade
Default Adoptable shop new version! [UPDATED!]

Hey!

here were some bugs, i fixed em, and now the shop will be the normal adopt.php :D


the fixed version can be seen at: http://miromotel.0fees.net/adoptables/adopt.php

Im to lazy to explain all code so ill just put the files in a zip and show the SQL


NOTE: YOUR CURRENCY MUST BE NAMED "coins" OR IT WONT WORK!

SQL including users:
PHP Code:


CREATE TABLE 
IF NOT EXISTS `adopts_adoptables` (
  `
idint(11NOT NULL AUTO_INCREMENT,
  `
typevarchar(40) DEFAULT NULL,
  `
descriptionvarchar(300) DEFAULT NULL,
  `
eggimagevarchar(120) DEFAULT NULL,
  `
whenisavailvarchar(50) DEFAULT NULL,
  `
promocodevarchar(50) DEFAULT NULL,
  `
freqcondvarchar(50) DEFAULT NULL,
  `
numberint(11) DEFAULT NULL,
  `
datecondvarchar(50) DEFAULT NULL,
  `
datevarchar(20) DEFAULT NULL,
  `
adoptscondvarchar(20) DEFAULT NULL,
  `
morelessvarchar(20) DEFAULT NULL,
  `
morelessnumint(11) DEFAULT NULL,
  `
levelgrlevarchar(25) DEFAULT NULL,
  `
grlelevelint(11) DEFAULT NULL,
  `
alternatesvarchar(10) DEFAULT NULL,
  `
altoutlevelint(11) DEFAULT NULL,
  `
altchanceint(11) DEFAULT NULL,
  `
priceint(11NOT NULL DEFAULT '0',
  
PRIMARY KEY (`id`)
ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=;


CREATE TABLE IF NOT EXISTS `adopts_users` (
  `
uidint(11NOT NULL AUTO_INCREMENT,
  `
usernamevarchar(20) DEFAULT NULL,
  `
passwordvarchar(100) DEFAULT NULL,
  `
emailvarchar(60) DEFAULT NULL,
  `
usergroupint(11) DEFAULT NULL,
  `
newmessagenotifyvarchar(10) DEFAULT NULL,
  `
membersincevarchar(20) DEFAULT NULL,
  `
isbannedint(11) DEFAULT NULL,
  `
websitevarchar(80) DEFAULT NULL,
  `
profilepicvarchar(80) DEFAULT NULL,
  `
aimvarchar(80) DEFAULT NULL,
  `
yahoovarchar(80) DEFAULT NULL,
  `
msnvarchar(80) DEFAULT NULL,
  `
coinsint(11NOT NULL DEFAULT '0',
  
PRIMARY KEY (`uid`),
  
UNIQUE KEY `username` (`username`)
ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=
Okay now the files:

ATTACHED FILES IN ZIP:
adopt.php
doadopt.php
admin.php
nadopt.php
levelup.php (gives at levelup random between 100 and 200 coins)


Hope u guys like it :D

(for admin.php, only changed function is new (new adopt) for ppl who have other stuff in it)
Attached Files
File Type: zip Fixed.zip (26.2 KB, 14 views)