Codezwiz >> Forums >> Codezwiz BBtoNuke Mods Help >> state flags

this mod about putting the state flags in your profile
in the sql it says to add to your sql the phpbb now do i have to change that to nuke or what

change it to your table prefix

so instead of phpbb i would change it to nuke_bb

Correct

nuke_bbflags

ok will try this one

#
# Table structure for table 'phpbb_state_flags'
#

ALTER TABLE phpbb_users ADD user_from_state_flag varchar(25) NULL AFTER user_from_flag;

CREATE TABLE phpbb_state_flags (
flag_id int(10) NOT NULL auto_increment,
flag_name varchar(25),
flag_image varchar(25),
PRIMARY KEY (flag_id)
);

not sure what to edit here

ALTER TABLE nuke_users ADD user_from_state_flag varchar(25) NULL AFTER user_from_flag;

CREATE TABLE nuke_bbstate_flags (
flag_id int(10) NOT NULL auto_increment,
flag_name varchar(25),
flag_image varchar(25),
PRIMARY KEY (flag_id)
);

when i try to add this to my sql i am getting this error

Database stealths_nuke running on localhost
Error

SQL-query :

ALTER TABLE nuke_users ADD user_from_state_flag varchar( 25 ) NULL AFTER user_from_flag

MySQL said:

#1054 - Unknown column 'user_from_flag' in 'nuke_users'

just wondering do i have to change the instert phpbb_state_flag to nuke_bbstate_flag

because that is what i did to.

You didnt import the first table correctly. Try to stick to one post too Im getting confused chasing you around.