[MOD] Ban v1.7

[martrix]

LOOKUP (buscar)
Looking up an IP address from its name in DNS or looking up a name from its IP address.
HOSTNAME (denominación de computador)
The name given to an individual computer attached to the Internet.

if set to yes = more work for the server = slower
if set to no  = less work for the server = faster

[b.o.fan]

Hello. I´ve got this Error, when i do the ban_install.php:

Code: [Select]

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)) ENGINE=MyISAM
You have an error in your SQL syntax near 'ENGINE=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(8) NOT NULL default '0', ip tinytext NOT NULL, uri varchar(255) NOT NULL default '', PRIMARY KEY (id)) ENGINE=MyISAM
You have an error in your SQL syntax near 'ENGINE=MyISAM' at line 1

   1. Error
        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)) ENGINE=MyISAM

   2. Error
        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(8) NOT NULL default '0', ip tinytext NOT NULL, uri varchar(255) NOT NULL default '', PRIMARY KEY (id)) ENGINE=MyISAM

   3. Done
        INSERT INTO `4images_settings` ( `setting_name` , `setting_value` ) VALUES ('look_hostname', '1')

   4. Done
        INSERT INTO `4images_settings` ( `setting_name` , `setting_value` ) VALUES ('ban_update', '0')
Why??!??

help me please...


b.o.fan

[Josef Florian]

Hello. I´ve got this Error, when i do the ban_install.php:

Code: [Select]

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)) ENGINE=MyISAM
You have an error in your SQL syntax near 'ENGINE=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(8) NOT NULL default '0', ip tinytext NOT NULL, uri varchar(255) NOT NULL default '', PRIMARY KEY (id)) ENGINE=MyISAM
You have an error in your SQL syntax near 'ENGINE=MyISAM' at line 1

   1. Error
        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)) ENGINE=MyISAM

   2. Error
        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(8) NOT NULL default '0', ip tinytext NOT NULL, uri varchar(255) NOT NULL default '', PRIMARY KEY (id)) ENGINE=MyISAM

   3. Done
        INSERT INTO `4images_settings` ( `setting_name` , `setting_value` ) VALUES ('look_hostname', '1')

   4. Done
        INSERT INTO `4images_settings` ( `setting_name` , `setting_value` ) VALUES ('ban_update', '0')
Why??!??

help me please...


b.o.fan

Ich habe das selbe Problem! Hängt es irgendwie mit der MyISAM zusammen?  // I have the same problem! 

[Josef Florian]

Ich habe das Problem behoben!

Da bei meiner SQL-Datenbank sowieso standardmäßig der Typ MyISAM ist, habe ich einfach statt:

CREATE TABLE fotos1_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(8) NOT NULL default '0', ip tinytext NOT NULL, uri varchar(255) NOT NULL default '', PRIMARY KEY (id)) ENGINE=MyISAM

CREATE TABLE fotos1_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(8) NOT NULL default '0', ip tinytext NOT NULL, uri varchar(255) NOT NULL default '', PRIMARY KEY (id))

Ich habe also " ENGINE=MyISAM" gelöscht!


Das gleiche habe ich mit dem 2. Fehler gemacht:

statt:

CREATE TABLE fotos1_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)) ENGINE=MyISAM

CREATE TABLE fotos1_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))

Ich habe also " ENGINE=MyISAM" gelöscht!



einfach mit phpMyAdmin bequem ausgeführt und mein Ban v1.6 läuft einwandfrei!  :D


Liebe Grüße
Josef Florian Glatz

[b.o.fan]

ja. danke
@Josef Florian Glatz

here is my ban_install.php:

Code: [Select]

REMOVEDthe half of the ban_install.php is oky but than: Look @ the screenshot
die hälfte des ban_install.php lief auch. aber dann:


B.o.fan

[V@no]

and what is your MySQL version?

@b.o.fan:
dont worry about the errors from the screenshot, your database was successfuly updated.


[EDIT]
I just found out that ENGINE syntax is availiable in MySQL v4.1.x and later versions
And I updated the installer.

[b.o.fan]

oki.

thankx.

i will look.


b.o.fan

[universal]

OK, i`ve installed succefully, no error apeared during installation. BUT there is one BUT
Script doesnt work. Or i cant understand how it works.
So I add a ban on my host or on my ip but I still can login page, I tryied to login and logout but still nothing happened.
Is there something wrong or what?

[b.o.fan]

@universal

yes. thats my problem too.

i give in a other User. but he can loggin.



MfG

b.o.fan

[V@no]

Ok, how about this idea: ban my IP: 65.35.35.155 or 65.35.35.*
I'll come back in 9 hours and check it out, also, please post a screenshot of your ban list.

[universal]

Here you go
http://www.pramoga.net

Added ban for IP: 65.35.35.*

[b.o.fan]

here you can test.

i´ve got 4images 1.71.



http://www.wartenaufden15.de --> look there

the screenshot look under this...

[V@no]

@universal:
ok it didnt work for me...


@b.o.fan:
It worked first time I opened the site, after refresh the ban was gone..

So, try replace in includes/functions.php:

Code: [Select]

$force = false; with:

Code: [Select]

$force = true;it will force query the database each time someone opens a page. if it works, then there is something wrong with the way your 4images stores some sessions...
if it works, then restore that line, clear your cookies, then put your site domain into "black list" in your browser so it would block any cookies from your site and try to login. if u be able login and browse the site without problem, then we'll go from there, otherwise there is something wrong with your server and u should contact your hoster about it...

[waleed]

how can i ban ppl using proxy
if i ban someone he can use proxy to login again
so ?

[V@no]

sorry, there is no a "real" sollution for a proxy...if someone really wants to get to your site, the only way to stop them is close up your site intirely.