Home Community Mys-Script Creative Off-Topic |
|
|
Thread Tools | Display Modes |
#2
|
|||
|
|||
RE: Mod Template - Information for Mod Creators of the Rusnak PHP Adoptables Script
SQL Tables:
This post contains information about some key SQL tables that the script uses. Settings Table Structure and Contents: Code:
CREATE TABLE adopts_settings (name varchar(20), value varchar(350)); INSERT INTO adopts_settings (name, value) VALUES ('themeurl', 'templates/default/template.html'); INSERT INTO adopts_settings (name, value) VALUES ('browsertitle', 'This is the site title as pulled from the DB'); INSERT INTO adopts_settings (name, value) VALUES ('sitename', 'Your site name goes here.'); INSERT INTO adopts_settings (name, value) VALUES ('admincontact', 'admin@email.com'); INSERT INTO adopts_settings (name, value) VALUES ('slogan', 'Test Slogan'); INSERT INTO adopts_settings (name, value) VALUES ('gdimages', 'yes'); INSERT INTO adopts_settings (name, value) VALUES ('usealtbbcode', 'yes'); INSERT INTO adopts_settings (name, value) VALUES ('systememail', 'admin@email.com'); Code:
CREATE TABLE adopts_users (uid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, username varchar(20) UNIQUE, password varchar(100), email varchar(60), usergroup INT, newmessagenotify varchar(10), membersince varchar(20), isbanned INT, website varchar(80), profilepic varchar(80), aim varchar(80), yahoo varchar(80), msn varchar(80)); Code:
CREATE TABLE adopts_groups (gid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, groupname varchar(20) UNIQUE, canadopt varchar(10), canpm varchar(10), cancp varchar(10), canmanageadopts varchar(10), canmanagecontent varchar(10), canmanageads varchar(10), canmanagesettings varchar(10), canmanageusers varchar(10)); INSERT INTO adopts_groups VALUES ('', 'rootadmins', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes'); INSERT INTO adopts_groups VALUES ('', 'admins', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes'); INSERT INTO adopts_groups VALUES ('', 'registered', 'yes', 'yes', 'no', 'no', 'no', 'no', 'no', 'no'); INSERT INTO adopts_groups VALUES ('', 'artists', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'no'); Code:
CREATE TABLE adopts_adoptables (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, type varchar(40), description varchar(300), eggimage varchar(120), whenisavail varchar(50), promocode varchar(50), freqcond varchar(50), number INT, datecond varchar(50), date varchar(20), adoptscond varchar(20), moreless varchar(20), morelessnum INT, levelgrle varchar(25), grlelevel INT, alternates varchar(10), altoutlevel INT, altchance INT); Code:
CREATE TABLE adopts_owned_adoptables (aid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, type varchar(40), name varchar(40), owner varchar(40), currentlevel INT, totalclicks INT, code INT, imageurl varchar(120), usealternates varchar(10), tradestatus varchar(15), isfrozen varchar(10)); Code:
CREATE TABLE adopts_levels (adoptiename varchar(50), thisislevel INT, requiredclicks INT, primaryimage varchar(120), alternateimage varchar(120), rewarduser varchar(10), promocode varchar(25)); |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Dechiphering the Adoptables Script | Ansem717 | Questions and Supports | 1 | 01-15-2011 06:58 PM |
Adoptables Script + MyBB | Blues | Questions and Supports | 3 | 08-05-2009 06:24 PM |
What can be done with the PHP Adoptables Script! | Seapyramid | Suggestions and Feature Requests | 11 | 07-19-2009 11:16 AM |
Can you put a flash template with a easy adoptable script? | Tezna | Questions and Supports | 2 | 05-26-2009 07:28 PM |
Choosing Adoptables Type [EASY ADOPTABLES SCRIPT ONLY] | Ashje | Addons/Mods Graveyard | 2 | 05-24-2009 03:17 AM |
What's New? |
What's Hot? |
What's Popular? |