SQL Query Help Needed.

[Guest Michael Dray]

Hi guys I need sum1's help I made a but of a mistake. I was running an mod and the 1st bit said

> Run these queries before implementing the file changes below:

> ALTER TABLE CubeCart_category ADD catDisplayOrderID int(11) NOT NULL

> default '0';

> ALTER TABLE CubeCart_inventory ADD productDisplayOrderID int(11) NOT NULL

> default '0';

However me bein the genius that I am and no knowing how to run an SQL Query I just ignored it.

Now my whole site dont work. :-(

I can supply any details of datebase anything etc. Can any1 just run these 2 queries for me.

Thanks in advace.

Mike

[convict]

Paste following code to a new text file, name it whatever but extension php, upload to your root store folder and 'run'.

<?php

include_once("includes/global.inc.php");

include_once("classes/db.inc.php");

$db = new db();

$db->misc("ALTER TABLE `".$glob['dbprefix']."CubeCart_category` ADD catDisplayOrderID int(11) NOT NULL  default '0'");

$db->misc("ALTER TABLE `".$glob['dbprefix']."CubeCart_inventory` ADD productDisplayOrderID int(11) NOT NULL  default '0'");

?>

DONE!

FYI: it is always prefered to contact the mod author first