Mysidia Adoptables Support Forum  

Home Community Mys-Script Creative Off-Topic
Go Back   Mysidia Adoptables Support Forum > Mysidia Adoptables > Questions and Supports

Notices

Reply
 
Thread Tools Display Modes
  #1  
Old 01-22-2010, 06:09 PM
Tkrules Tkrules is offline
Member
 
Join Date: Jan 2010
Posts: 3
Credits: 442
Tkrules
Default Adding a column to owned_adoptables?

Hello all. I recently installed the adoptable script on our site. I need to add a column to 'owned_adoptables' but I cannot find it and have no idea where it could be or how to edit it. If anyone could help I'd be grateful.
Reply With Quote
  #2  
Old 01-22-2010, 10:02 PM
powerchaos's Avatar
powerchaos powerchaos is offline
WebMaster
 
Join Date: May 2008
Posts: 130
Gender: Male
Credits: 10,116
powerchaos
Send a message via AIM to powerchaos Send a message via MSN to powerchaos
Default RE: Adding a column to owned_adoptables?

doesnt the script does it for you ?? the installer ??

els open install.sql and find that rule in there , copy that rule and edit a little so it fits your database
then enter it into your database (dont forget to take the first lines to , to inport the file manual then it looks like this )

NOTE : THIS IS A EXAMPLE AND CAN NOT BE USED
PHP Code:
--
-- 
table structures for table `styles`
--

DROP TABLE IF EXISTS `styles`;
CREATE TABLE IF NOT EXISTS `styles` (
  `
idint(100NOT NULL auto_increment,
  `
activechar(1NOT NULL default '',
  `
namevarchar(100NOT NULL default '',
  `
dirvarchar(40NOT NULL default '',
  
PRIMARY KEY  (`id`)
ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=;

--
-- 
data get executed for table `styles`
--

INSERT INTO `styles` (`id`, `active`, `name`, `dir`) VALUES
(1'1''Elite Ladders Default''default');

-- -------------------------------------------------------- 
now , get that second part and change it to the right value's so you see like it is

if it got a table prefix , make it then like this
PHP Code:
INSERT INTO `PREFIX_styles` (`id`, `active`, `name`, `dir`) VALUES
(1'1''Elite Ladders Default''default'); 
and it will be fine :D

Greets From PowerChaos
Reply With Quote
Reply


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
Item 'Rarity' Column Kyttias Questions and Supports 3 11-08-2014 05:51 PM
Adding Databases Kesstryl Questions and Supports 4 06-08-2012 06:47 AM
Adding new adoptables? Slix Questions and Supports 0 07-05-2011 11:12 AM
adding images Nemesis Questions and Supports 11 04-10-2011 11:00 AM
A 2-column table? Quillink Suggestions and Feature Requests 8 09-23-2010 02:26 PM


All times are GMT -5. The time now is 01:13 AM.

Currently Active Users: 1818 (0 members and 1818 guests)
Threads: 4,080, Posts: 32,024, 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 - 2024, vBulletin Solutions Inc.
vBCommerce I v2.0.0 Gold ©2010, PixelFX Studios
vBCredits I v2.0.0 Gold ©2010, PixelFX Studios
Emoticons by darkmoon3636