| BirdOPrey5 |
10-28-2011 10:21 AM |
If you open the product XML file, near the top of the file are the MySQL Statements:
PHP Code:
$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS`". TABLE_PREFIX ."post_thanks` (
`id` INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`userid` INT(10) NOT NULL,
`username` VARCHAR(50) NOT NULL,
`date` INT(10) NOT NULL,
`postid` INT(10) NOT NULL)
");
$vbulletin->db->query_write("ALTER TABLE `". TABLE_PREFIX ."post_thanks` ADD INDEX ( `postid` )");
$vbulletin->db->query_write("ALTER TABLE `". TABLE_PREFIX ."user` ADD `post_thanks_user_amount` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL");
$vbulletin->db->query_write("ALTER TABLE `". TABLE_PREFIX ."post` ADD `post_thanks_amount` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL");
$vbulletin->db->query_write("ALTER TABLE `". TABLE_PREFIX ."user` ADD `post_thanks_thanked_posts` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL");
$vbulletin->db->query_write("ALTER TABLE `". TABLE_PREFIX ."user` ADD `post_thanks_thanked_times` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL");
$db->show_errors();]]></installcode>
As you can see there are quite a few... You will need to remove the `". TABLE_PREFIX ." from each one and replace it with your actual table prefix, if any.
They need to be run in the order they are shown.
The queries are the code between the quotes, you would ignore everything in red in this example:
Code:
$vbulletin->db->query_write("ALTER TABLE `". TABLE_PREFIX ."post_thanks` ADD INDEX ( `postid` )");
And of course it goes without saying- be ABSOLUTELY SURE you have a recent and verified backup of the database before attempting manual edits. |
More Information