Mod Name / Version: Advanced Banning <br /> <br />Description: This hack advances/replaces the normal ban masks. You can set different ban levels and edit existing bans. <br /> <br />Working Under: UBB.Threads 6.2 <br /> <br />Mod Status: Finished <br /> <br />Any pre-requisites: <br /> <br />Author(s): Astaran <br /> <br />Date: 02/15/03 <br /> <br />Credits: Dave_L, this hack is based on his user privilieges hack <br /> <br />HISTORY: <br />2003-02-07 Dave_L - 1.0.0 Original release of User privileges <br />2003-02-15 Astaran - 1.0.0 Original release of Advanced banning <br />2003-03-02 Astaran - 1.0.1 Updated "Upgrading Instructions" - added missing field in altertable command <br /> <br />Files Altered: addpost.php, doratethread.php, dorateuser.php, editpost.php, <br />mess_handler.php, newpost.php, newreply.php, sendprivate.php, <br />ubbt.inc.php, admin/menu.php, admin/banuser.php, admin/dobanuser.php <br /> <br />New Files: admin/editbanusers.php, admin/doeditbanusers.php <br /> <br />Database Altered: Yes <br /> <br />Info/Instructions: If you already installed Dave_L's user restrictions hack, only follow the upgrading instructions at the end of the file. <br /> <br />Disclaimer: Please backup every file that you intend to modify. <br />If the modification modifies the database, it's a good idea to backup your database before doing so. <br /> <br />Note: If you modify your UBB.Threads code, you may be giving up your right for "official" support from Infopop.If you need official support, you'll need to restore unmodified files. <br /> <br />

Ok... I'm going to bite the bullet on this and ask what I'm sure you will think the ultimate stupid question.<br /><br />This is the first mod that I'm going to try that involves altering the database (I think?). <br /><br />The instructions for this mod have this:<br /><br />[]********<br />Database<br />********<br /><br />Replace "w3t_" by your custom table prefix, if applicable:<br /><br /> ALTER TABLE w3t_Banned <br /> ADD B_X_NoEditPost CHAR(1) NOT NULL DEFAULT '1', <br /> ADD B_X_NoEditProfile CHAR(1) NOT NULL DEFAULT '1', <br /> ADD B_X_NoMessage CHAR(1) NOT NULL DEFAULT '1', <br /> ADD B_X_NoPost CHAR(1) NOT NULL DEFAULT '1', <br /> ADD B_X_NoRate CHAR(1) NOT NULL DEFAULT '1',<br /> ADD B_X_NoLogin CHAR(1) NOT NULL DEFAULT '1', <br /> ADD B_Comment TEXT;[/]<br /><br />Is this something that I actually have to go into the database and do or is this something that just happens on it's own once I've modified the subsequent files?<br /><br />If this is something that I have to go into my database and do, please give me step by step instructions on how to do that? I have never messed with my database before... it scares the hell out of me!!<br /><br />Thanks in advance!<br />

Backup your database first.....<br /><br />Then go to Admin -> SQL Command<br />Then paste this in the box:<br /><br /> ALTER TABLE w3t_Banned<br />ADD B_X_NoEditPost CHAR(1) NOT NULL DEFAULT '1',<br />ADD B_X_NoEditProfile CHAR(1) NOT NULL DEFAULT '1',<br />ADD B_X_NoMessage CHAR(1) NOT NULL DEFAULT '1',<br />ADD B_X_NoPost CHAR(1) NOT NULL DEFAULT '1',<br />ADD B_X_NoRate CHAR(1) NOT NULL DEFAULT '1',<br />ADD B_X_NoLogin CHAR(1) NOT NULL DEFAULT '1',<br />ADD B_Comment TEXT;<br /><br /><br />Then you should be set. <img src="/forum/images/graemlins/smile.gif" alt="" />

Josh... Thank you... VERY much! <img src="/forum/images/graemlins/bow.gif" alt="" /><br /><br />I scoped it out and I can do it. I'm going to give a heads up to my members though and shut down the board for the back up. If you don't hear back from me, you'll know that all went well... <img src="/forum/images/graemlins/cool.gif" alt="" />

I'm afraid you're going to have to hold my hand again, Josh... if you wouldn't mind? <img src="/forum/images/graemlins/crazy.gif" alt="" /><br /><br />I went to do the back up (I haven't done this before either as my server does regular back ups for me) and this is the error message that I got for each of the tables I tried to back up:<br /><br />[]Warning: stat failed for /w3t_Banned.sql (errno=2 - No such file or directory) in usr/the address to my board/ubbthreads/admin/dodbbackup.php on line 78<br />w3t_Banned.sql is 0 bytes or did not get created.<br /><br />You will need to verify that this command actually backed up the selected table(s). [/]<br /><br />Now what? <img src="/forum/images/graemlins/confused.gif" alt="" />

I believe that means you don't have a table called w3t_Banned

That's a warning cause the new table is still empty. It should go away when you have banned the first user.

<img src="/forum/images/graemlins/yeahthat.gif" alt="" />

Hmmmm... I have several banned persons. And they keep editing their profiles and posts and such. That's why I need this mod. Help?

Can you run this sql command under Admin -> SQL Command:<br /><br />SELECT * FROM w3t_Banned;<br /><br /><br />and post the results here?

Here ya go:<br /><br />[]B_Uid B_Hostname B_Reason <br />69 NULL Ban imported from old UBB installation <br />347 NULL Ban imported from old UBB installation <br />414 NULL Ban imported from old UBB installation <br />812 NULL Ban imported from old UBB installation <br />1978 NULL Ban imported from old UBB installation <br />2177 NULL Ban imported from old UBB installation <br />2194 NULL Ban imported from old UBB installation <br />2263 NULL Ban imported from old UBB installation <br />2298 NULL Ban imported from old UBB installation <br />3680 NULL <br />2895 NULL Ban imported from old UBB installation <br />3226 NULL Ban imported from old UBB installation <br />3870 NULL <br />3871 NULL <br />1031 NULL Trolling/Baiting/General disruption <br />4047 NULL disturbing emails <br />2205 NULL Trolling/Baiting/General disruption <br />3345 NULL <br />0 65.69.154.179 <br />0 67.64.147.240 tkl <br />4365 NULL tkl <br />0 64.123.190.94 tkl <br />4373 NULL tkl <br />4381 NULL tkl <br />4389 NULL tkl <br />4399 NULL tkl <br />3657 NULL flaming <br />4278 NULL general rudeness <br />2735 NULL not complying with policy <br />2480 NULL unresolve flaming/baiting behavior <br />4616 NULL baiting <br />4687 NULL tkl <br />17 NULL Baiting <br />4779 NULL spamming/non-sponsor <br />4781 NULL <br />4783 NULL <br />[/]

Looks all good.<br />Can you please also run a "CHECK TABLE `w3t_Banned`;" to see if the table is corrupted in any way?<br /><br /><br />Do you have phpMyAdmin installed on your server so that you can try to make a backup with it? You could do a backup via command line also if you have shell access to your server.

[]Here are the results of your command: "CHECK TABLE `w3t_Banned`;".<br />Resource id #3 row(s) affected by your query. <br />[/]<br /><br />Yes, I have phpMyAdmin and I have full access. Again, I don't touch things in there 'cuz it scares me. <img src="/forum/images/graemlins/crazy.gif" alt="" /> <br /><br />BTW... I'm just using the w3t_Banned table as an example but every single one of my tables returns the same exact error when I try to do a back up. My first thought is that the path is incorrect? The tables are in a different path? Maybe? I checked line 78 in dodbbackup.php and this is what it says:<br /><br /><br /><br />Any help there?

[]I'm just using the w3t_Banned table as an example but every single one of my tables returns the same exact error when I try to do a back up. My first thought is that the path is incorrect? The tables are in a different path? Maybe? I[/]<br /><br />Yes, that should be the reason.<br />For testing purposes you can enter the same path as for the mysql log function.<br /><br />The directory should be outside of your web root and needs to be writeable.

Which directory?<br /><br />(sorry... <img src="/forum/images/graemlins/crazy.gif" alt="" /> I really appreciate your help in this. I'm just really really ignorant right now with this software. )

Make sure the path for:<br /> Path to mysql. Only necessary for using the database restore function in the admin section.<br /><br />is correct. I was getting errors like these when my path was wrong. <br /><br />Also, make sure this path:<br /> Path to mysqldump. Only necessary for using the database backup function in the admin section<br />is correct.<br /><br />Make sure this path is correct and world writable:<br />Directory to store database backups in. Only necessary for using the database backup/restore function in the admin section. This directory will need to be writeable by the webserver.<br /><br />If the directory that is pointing to isn't writable the backup will fail. This is probally the mostly likely cause of the problem you are having now.<br /><br />These are all in config. Hope this helps

Ok... I finally got around to getting this done and all went well. I did the database backup from mysqladmin. MUCH easier!! <br /><br />I modified all of the files and everything went smooth. I didn't blow up my board. I haven't tested it out yet by banning someone and seeing just what they can do from there... I'll be working on that later. But first, there is a glaring problem with my sendprivate.php .... as in, it's not there! Or rather when I try to send a PM, I get a blank page. This seems to be the same for everyone. I can still read the PM's that I have in my in and out boxes but can't get anything but a blank page when I try to send.<br /><br />Anyone else have this problem and how do I fix it? I didn't realize that I had even done anything to that file with this mod?!?! <img src="/forum/images/graemlins/confused.gif" alt="" />

A blank page is usually either a missing language file or you accidentally uploaded the language file in place of the script.

I'm sorry... how could I have uploaded the language file in place of the script? I uploaded exactly what the directions told me to upload... <img src="/forum/images/graemlins/confused.gif" alt="" />

Wait... found my mistake. I didn't modify the sendprivate.php file... and I should have. Ignore me please. Sorry... <img src="/forum/images/graemlins/crazy.gif" alt="" />