boardom Forum Index boardom
b2 message board
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

i need help with Comment Blacklist hack

 
Post new topic   Reply to topic    boardom Forum Index -> Hacks
View previous topic :: View next topic  
Author Message
Tonya



Joined: 27 Oct 2004
Posts: 4
PostPosted: Wed Oct 27, 2004 11:19 pm    Post subject: i need help with Comment Blacklist hack Reply with quote
I'm a complete idiot when it comes to SQL, so be paitient with me

Okay, for step 1, it says to run the following SQL statement within your b2 database via phpMyAdmin (CPanel>Database):


Quote:
CREATE TABLE b2blacklist (
ID tinyint(4) NOT NULL auto_increment,
IP varchar(20) NOT NULL,
name tinytext NULL,
PRIMARY KEY (ID),
UNIQUE KEY IP (IP)
) TYPE=MyISAM;


I'm using phpMyAdmin 2.6.0-pl2 so I'm not sure if this was done with the same version or a different one. Underneath where all the tables are listed ( b2catagories, b2comments...), there is the option to make a new table. In the 'name' box I'm assuming that I would put b2blacklist here. Where 'fields' is, would I put from ID tinyint to TYPE=MyISAM there or am I doing this wrong?
Back to top
View user's profile Send private message MSN Messenger
stevem



Joined: 15 Mar 2003
Posts: 323
PostPosted: Wed Oct 27, 2004 11:44 pm    Post subject: Reply with quote
It's easier than that. Where you are looking, click on SQL (next to Structure) at the top of that frame. In the large box that opens paste in all of
Code:
CREATE TABLE b2blacklist (
ID tinyint(4) NOT NULL auto_increment,
IP varchar(20) NOT NULL,
name tinytext NULL,
PRIMARY KEY (ID),
UNIQUE KEY IP (IP)
) TYPE=MyISAM;
then press Go and it will work like magic!
Back to top
View user's profile Send private message
Tonya



Joined: 27 Oct 2004
Posts: 4
PostPosted: Wed Oct 27, 2004 11:50 pm    Post subject: Reply with quote
yay! it works! thanks a lot for the help Smile
Back to top
View user's profile Send private message MSN Messenger
Display posts from previous:   
Post new topic   Reply to topic    boardom Forum Index -> Hacks All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB 2 © 2001, 2002 phpBB Group