Page 13 of 18

Re: Ban List Mod

Posted: Mon Jul 27, 2009 5:25 am
by brett05
OK I got it worked out. Same problem as here -->
http://www.phpbb.com/community/viewtopi ... 0#p8037775

Re: Ban List Mod

Posted: Sun Aug 02, 2009 1:14 am
by XeloX
I cant get it to show up in the acp :S could it have anything to do with that i have a dutch version of the adm panel?

i included the acp_board file.. if anybody could check it out? i want to eb able to change it to be publicly viewable.

Greetings,

XeloX

Founder/webdesigner of demonhacks.com

EDIT : for some weird reason it shows up now...
Didnt change a thing, ah well it works tyvm!

Re: Ban List Mod

Posted: Thu Aug 06, 2009 6:22 pm
by Lisbon
I

I have this error. whem i bam a e-mail:
Erro Geral
SQL ERROR [ mysql4 ]

Data too long for column 'ban_give_reason' at row 1 [1406]

SQL

INSERT INTO cetos_banlist (ban_email, ban_start, ban_end, ban_exclude, ban_reason, ban_give_reason, ban_banner) VALUES ('quecena@hotmail.com', 1249582870, 0, 0, 'bbfdsd', 'Este e-mail já esteve associado a um registo anterior. Apesar de ter tido a conta activa não frequentou o Fórum e passada uma semana o e-mail foi banido tal como escrito aqui: http://www.cetos.info/forum/viewtopic.php?f=1&t=1056 TENTE COM OUTRO E-MAIL', 3)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/db/dbal.php
LINE: 450
CALL: dbal_mysql->sql_query()

FILE: includes/functions_user.php
LINE: 1019
CALL: dbal->sql_multi_insert()

FILE: includes/acp/acp_ban.php
LINE: 63
CALL: user_ban()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_ban->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
Tks for help

Re: Ban List Mod

Posted: Fri Aug 07, 2009 9:07 pm
by RMcGirr83
Nothing to do with this mod...ban_give_reason is part of phpBB already. I would suggest you open a topic in the support forum.

Re: Ban List Mod

Posted: Tue Aug 11, 2009 7:29 am
by gregdg1
this is a great mod installed and working great i have one prob and im not sure any one can help i also have
warnban1.0.0 mod on my forum my forum is 3.0.5 when you warn someone 3 times it bans them like its supposed to but i get about 7 to 10 erras that only last for about 5 to 6 sec. and then all is fine im sure it has somthing to do with my warnban because if i go into acp and ban someone from there its all fine
thx for any help or input into this this is a great mod

thx
greg

Re: Ban List Mod

Posted: Tue Aug 11, 2009 11:47 am
by RMcGirr83
greg,

Got a link to the mod you are using?

Re: Ban List Mod

Posted: Tue Aug 11, 2009 8:32 pm
by gregdg1
yes i do here it is and thx for trying to help

Code: Select all

http://www.phpbb.com/community/viewtopic.php?f=69&t=597284

Re: Ban List Mod

Posted: Fri Aug 14, 2009 7:46 am
by gregdg1
ok after about a day in a half i have been able to get a pic of it and i do not know if its safe to post it here
this is kinda what it says
1 line
[phpbb debug] and then its got alot of stuff there
and then its got 4 dif lines and thay all start out like this
warning cannot modify header information
and then it goes on giving info if its safe to post the pic here i will i just did not know if that
give out to much info

thx

greg

Re: Ban List Mod

Posted: Fri Aug 14, 2009 10:27 am
by RMcGirr83
gregdg1 wrote:ok after about a day in a half i have been able to get a pic of it and i do not know if its safe to post it here
this is kinda what it says
1 line
[phpbb debug] and then its got alot of stuff there
and then its got 4 dif lines and thay all start out like this
warning cannot modify header information
and then it goes on giving info if its safe to post the pic here i will i just did not know if that
give out to much info

thx

greg
Post up the pic...that's fine.

Re: Ban List Mod

Posted: Fri Aug 14, 2009 11:04 am
by sypher01
Theres an error on line 172 of ban_list.php

u do this:

$result2 = $db->sql_build_query('SELECT', $sql_ary);

and then u treat the $result2 as a result, but it isnt. its just the plain text query.

replace that line with this:

$result2 = $db->sql_query($db->sql_build_query('SELECT', $sql_ary));

then the total count of the users in the ban_list page will work as expected.

Re: Ban List Mod

Posted: Fri Aug 14, 2009 11:24 am
by RMcGirr83
sypher01 wrote:Theres an error on line 172 of ban_list.php

u do this:

$result2 = $db->sql_build_query('SELECT', $sql_ary);

and then u treat the $result2 as a result, but it isnt. its just the plain text query.

replace that line with this:

$result2 = $db->sql_query($db->sql_build_query('SELECT', $sql_ary));

then the total count of the users in the ban_list page will work as expected.
No comment about these lines of code?

Code: Select all

while ($row2 = $db->sql_fetchrow($result2))
{
	$banned_users[] = $row2['ban_userid'];
}
Note the $db->sql_fetchrow ;)

Re: Ban List Mod

Posted: Fri Aug 14, 2009 11:33 am
by sypher01
RMcGirr83 wrote:

Code: Select all

while ($row2 = $db->sql_fetchrow($result2))
{
	$banned_users[] = $row2['ban_userid'];
}
Note the $db->sql_fetchrow ;)
Yep, but the sql query must be executed first.

Re: Ban List Mod

Posted: Fri Aug 14, 2009 12:59 pm
by RMcGirr83
GAH!! :roll:

Thanks...I'll submit an update to the MODDB.

Re: Ban List Mod

Posted: Fri Aug 14, 2009 7:14 pm
by gregdg1
ok here is the pic i hope it helps in some way

Image

for some reason i cant get the hole pic to show so here is a link to the full pic

http://i298.photobucket.com/albums/mm24 ... 3-30AM.png

line 686 refers to this here is what the mod from the ban list says to do
Find
Tip: This may be a partial find and not the whole line.

Code: Select all

function user_ban($mode, $ban, $ban_len, $ban_len_other, $ban_exclude, $ban_reason, $ban_give_reason = ''
In-line Find
Tip: This is a partial match of a line for in-line operations.

Code: Select all

$ban_give_reason = ''
In-line Add after

Code: Select all

, $ban_banner
so this is the way my line 686 looks if there is any thing eles you need just let know thx

Code: Select all

function user_ban($mode, $ban, $ban_len, $ban_len_other, $ban_exclude, $ban_reason, $ban_give_reason = '', $ban_banner)

Fix for Ban List Ban users by x warnings conflict

Posted: Fri Aug 14, 2009 7:32 pm
by RMcGirr83
Try this

OPEN

includes/mcp/mcp_warn.php

FIND

Code: Select all

		user_ban('user', array($user_row['username']), $config['warnings_ban_expire'], false, 0, $user->lang['AUTO_WARN_BAN']);
REPLACE WITH

Code: Select all

		user_ban('user', array($user_row['username']), $config['warnings_ban_expire'], false, 0, $user->lang['AUTO_WARN_BAN'], $user->lang['AUTO_WARN_BAN_REASON'], $user->data['user_id']);
OPEN

language/en/mcp.php

FIND

Code: Select all

'AUTO_WARN_BAN'	=> 'User has reached maximum warnings and has been automatically banned.',
AFTER ADD

Code: Select all

'AUTO_WARN_BAN_REASON'	=> 'Maximum warnings reached',
Will state a reason to the banned user (that being "Maximum warnings reached") as well as the users name that issued the final warning to the user causing them to get banned.