Codezwiz >> Forums >> BBtoNuke Mods Help >> Shop Mod sql Help need real bad

Hi guys, Iv spent ages trying to make the shop mod work but I cant. The reason is because I cant even install the SQL.
This is for the nuke 7.5 version

I downloaded it from ported mods and the problem is I dont know how to install the sql entries.

It says I have to make a table and some stuff but I dont know anything about that.

Can someone please kindly help me.
Also here is the script.

Please guys help!!!

My msn is [ Register or login to view links on this board. ]

You have to go to phpmyadmin. Once there select your database. Across the top of the page you will see a tab(link) that says SQL click that and paste this in the text area:

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');

Error

SQL-query :

ALTER TABLE nuke_users ADD user_items TEXT

MySQL said:

#1060 - Duplicate column name 'user_items'

I did that and this is the error I got. :'(

That means you already have the database part installed.