Mysidia Adoptables Support Forum  

Home Community Mys-Script Creative Off-Topic
Go Back   Mysidia Adoptables Support Forum > Mysidia Adoptables > Suggestions and Feature Requests

Notices

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #9  
Old 01-18-2011, 05:50 PM
PTGigi's Avatar
PTGigi PTGigi is offline
Crazily Friendly~HoF
 
Join Date: Jul 2009
Location: Somewhere >.>
Posts: 370
Gender: Female
Credits: 37,986
PTGigi
Default

Quote:
Originally Posted by Hall of Famer View Post
Database Structure Change:
New tables:
PHP Code:
$query "CREATE TABLE ".$prefix."shoutbox (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, user varchar(50), date varchar(30), comment varchar(2500))";
mysql_query($query);

$query "CREATE TABLE ".$prefix."trades (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, userrequestingtrade varchar(50), tradetype varchar(20), adoptableoffered INT, cashoffered INT, adoptabledesired INT, custommessage varchar(150), offerstatus varchar(30), tradeto varchar(40))";
mysql_query($query);

$query "CREATE TABLE ".$prefix."cash_logs (to varchar(40), from varchar(40), type varchar(40), amount int(10), date varchar(25))";
mysql_query($query); 
Also add the column 'gender'(VARCHAR) in table 'owned_adoptables', and 'dollar'(INT) in table 'user'
After this is done, insert the following three rows in the table 'settings':
PHP Code:
$query "INSERT INTO ".$prefix."settings (name, value) VALUES ('enabletrades', 'yes')";
mysql_query($query);

$query "INSERT INTO ".$prefix."settings (name, value) VALUES ('tradecost', '0')";
mysql_query($query);

$query "INSERT INTO ".$prefix."settings (name, value) VALUES ('tradeoffercost', '0')";
mysql_query($query); 


Oh thank you! I've been looking for that
__________________


"I see now that the circumstances of one's birth are irrelevant; it is what you do with the gift of life that determines who you are."~Mewtwo
My Adoptables|Nuzlocke Webcomic
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
insert flash / .swf files voni Questions and Supports 7 06-15-2014 10:55 AM
Uploading files!? EpicEquestrian Questions and Supports 3 05-27-2012 07:54 PM
css files superdude44 Questions and Supports 5 05-06-2012 05:46 PM
How to get a PHP file to be included in the files in different directories? robertson Other Chat 4 11-09-2010 10:20 AM


All times are GMT -5. The time now is 03:43 AM.

Currently Active Users: 4192 (0 members and 4192 guests)
Threads: 4,081, Posts: 32,032, Members: 2,016
Welcome to our newest members, jolob.
BETA





What's New?

What's Hot?

What's Popular?


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
vBCommerce I v2.0.0 Gold ©2010, PixelFX Studios
vBCredits I v2.0.0 Gold ©2010, PixelFX Studios
Emoticons by darkmoon3636