Codezwiz >> Forums >> Codezwiz PHP Nuke Help >> SQL Question

In one of the mods I am trying to install the install instructions say this...

############[SQL]###############################################################
##

alter table nuke_users add user_items TEXT;
create table nuke_shopitems (`id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `name` CHAR (32) NOT NULL, `shop` CHAR (32) NOT NULL, `sdesc` CHAR (80) NOT NULL, `ldesc` TEXT NOT NULL, `cost` INT (20) UNSIGNED DEFAULT '100', `startprice` INT (20) UNSIGNED DEFAULT '100', `raise` INT (20) UNSIGNED DEFAULT '100', `stock` TINYINT (3) UNSIGNED DEFAULT '10', `startstock` TINYINT (3) UNSIGNED DEFAULT '100', `maxstock` TINYINT (3) UNSIGNED DEFAULT '100', `sold` INT (5) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY(`id`), INDEX(`name`));
create table nuke_shops (`id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `shopname` CHAR (32) NOT NULL, `shoptype` CHAR (32) NOT NULL, PRIMARY KEY(`id`), `type` char (32) NOT NULL, `restocktime` INT (20) UNSIGNED DEFAULT '86400', `restockedtime` INT (20) UNSIGNED DEFAULT '0', `restockamount` INT (4) UNSIGNED DEFAULT '5', `amountearnt` INT (20) UNSIGNED DEFAULT '0', INDEX(`shopname`));
insert into nuke_bbconfig values ('multibuys', 'on');
insert into nuke_bbconfig values ('restocks', 'off');
insert into nuke_bbconfig values ('sellrate', '75');
insert into nuke_bbconfig values ('viewtopic', 'images');
insert into nuke_bbconfig values ('viewprofile', 'images');
insert into nuke_bbconfig values ('viewinventory', 'grouped');
insert into nuke_bbconfig values ('specialshop', '�store�disabled�name�Effects Store�off�1�off�1�off�1�off�1�off�1�off�1');
alter table nuke_users add `user_effects` CHAR (255);
alter table nuke_users add `user_privs` CHAR (255);
alter table nuke_users add `user_custitle` TEXT;
alter table nuke_users add `user_specmsg` TEXT;
update nuke_bbconfig set config_value='�store�disabled�name�Effects Store�off�1�off�1�off�1�off�1�off�1�off�1�off�1�off�1�off�1�off�1�off�1�off�1�off�1' where config_name='specialshop';
insert into nuke_bbconfig values ('viewtopiclimit', '5');

So...what do I do?
Where do I add this at?
Thanks, Proxy

If you're using CPanel here's a demo:
[ Register or login to view links on this board.]

Just make sure you click on the nuke database on the left before you run the sql file you have.