[MOD] Ban v1.7

[Leo64]

Hi!

Where is pack "ban v1.7.zip"?

This link from post March 28, 2005, 05:32:31 AM is bad.

Regards,
Leo64

[Rembrandt]

Welcome to the Forum!

the file is in the first post..

http://www.4homepages.de/forum/index.php?action=dlattach;topic=7066.0;attach=975

mfg Andi

[Leo64]

Hi!

I'm using a Firefox. This are'nt download.

Only Opera good downloading.

Thank you for !

Leo64

[Lucifix]

I've one little question, which might sound stupid 

Can member somehow reactivate account if it's been deactivated by admins?

[tutton]

V@NO YOU RULE MY FRIEND 

[mseifer]

In the "Ban" show me something like this:

DB Error: Bad SQL Query: SELECT count (id) as num FROM BAN_TABLE WHERE (type = 0 OR type = BAN_IP BAN_HOSTNAME OR type = type = BAN_NAME OR OR OR BAN_EMAIL type = type = BAN_USERID) AND date <= 1294662712 OR date> 1294662712 OR (expire AND expire <= 1294662712)
Table 'm05571mu_1.BAN_TABLE'does not exist

DB Error: Bad SQL Query: SELECT * FROM BAN_TABLE WHERE (type = 0 OR type = BAN_IP BAN_HOSTNAME OR type = type = BAN_NAME OR OR OR BAN_EMAIL type = type = BAN_USERID) AND date <= 1294662712 OR date> 1294662712 OR (AND expire expire <= 1294662712) ORDER BY type asc LIMIT 0, 30
Table 'm05571mu_1.BAN_TABLE'does not exist

In the "Logs" in this modification show me:

DB Error: Bad SQL Query: SELECT count (id) as num FROM BAN_TABLE
Table 'm05571mu_1.BAN_TABLE'does not exist

DB Error: Bad SQL Query: SELECT b. *, l *, u.user_name, u.user_level FROM BAN_LOGS_TABLE BAN_TABLE l LEFT JOIN b ON (b.id = l.ban_id) LEFT JOIN 4images_users u ON (u.user_id = l.user_id) ORDER BY desc LIMIT 0 l.date, 30
Table 'm05571mu_1.BAN_LOGS_TABLE'does not exist

How do I fix this?

[V@no]

re-do Step 2 and/or 7.1

[wassimo]

it's amazing mood really  thanks V@no ~, but , how i can  show that , user denied to all users and guest who look on his profile ?
i mean same ban message appears to all not only user  ^-^  


other suggestion,  if user baned , none can comment on his  images o profile etc.... ^-^ is it possible  ?

[Peedy1703]

Sorry mein erstes Posting hier.

Ich hab alles schritt für schritt gemacht, aber nun hab ich mich wohl selbst ausgesperrt.
ich kann mich selber nicht mehr anmelden.

wie kann so was sein?

[MrAndrew]

I`m sorry but:

This is a recent discover and its probably because your server has magic_quotes_gpc is turned on (check in phpinfo()).
To fix that, uncomment this line from includes/functions.php:
//  $ban_banned = stripslashes($ban_banned); //uncomment this line if magic_quotes_gpc is turned on on your server
Since v1.6.1 added auto check if magic_quotes_gpc is enabled

This solution was succesfully work for me, after fully uncomment  this line: $ban_banned = ($ban_banned) ? unserialize($ban_banned) : "";

Auto check is not work correctly

[exorotika]

Help please..
Installed everything duplicate times, read this entire forum.

DB Error: Bad SQL Query: CREATE TABLE 4images_ban (id mediumint(12) NOT NULL auto_increment, `type` tinyint(1) NOT NULL default '0', active tinyint(1) NOT NULL default '0', ip1_start tinyint(3) unsigned NOT NULL default '0', ip1_end tinyint(3) unsigned NOT NULL default '0', ip2_start tinyint(3) unsigned NOT NULL default '0', ip2_end tinyint(3) unsigned NOT NULL default '0', ip3_start tinyint(3) unsigned NOT NULL default '0', ip3_end tinyint(3) unsigned NOT NULL default '0', ip4_start tinyint(3) unsigned NOT NULL default '0', ip4_end tinyint(3) unsigned NOT NULL default '0', user_id mediumint(10) NOT NULL default '0', name varchar(255) NOT NULL default '', hostname tinytext NOT NULL, email tinytext NOT NULL, `date` int(11) NOT NULL default '0', expire int(11) NOT NULL default '0', message text NOT NULL, reason text NOT NULL, PRIMARY KEY (id), KEY active (active)) TYPE=MyISAM
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1

DB Error: Bad SQL Query: CREATE TABLE 4images_ban_logs ( id mediumint(10) NOT NULL auto_increment, `date` int(11) NOT NULL default '0', ban_id mediumint(12) NOT NULL default '0', user_id mediumint( NOT NULL default '0', ip tinytext NOT NULL, uri varchar(255) NOT NULL default '', PRIMARY KEY (id)) TYPE=MyISAM
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1

why do I keep getting that error?


Ok so I got the above situation solved, everything seems to be working but I tested it - doesn't work.
Even had two other people I know try it - it doesn't ban them..

what isn't it working?