Mysidia Adoptables Support Forum

Mysidia Adoptables Support Forum (http://www.mysidiaadoptables.com/forum/index.php)
-   Questions and Supports (http://www.mysidiaadoptables.com/forum/forumdisplay.php?f=18)
-   -   Adding a column to owned_adoptables? (http://www.mysidiaadoptables.com/forum/showthread.php?t=1276)

Tkrules 01-22-2010 06:09 PM

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.

powerchaos 01-22-2010 10:02 PM

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


All times are GMT -5. The time now is 09:36 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.