php script for usergroup promotion = users gets banned !!!

[NeXuM]

The cron jobs stopped working since a long time on my vbulletin 3.6.4 forum for an unknown reason, so i wrote my own script to promote the users to specific usergroups depending on their post number

<?php
include("../db.php");
$current = time();
$unmois = 2629743;
$abc = $current - $unmois;
// membres actifs
$query = "UPDATE vb_user SET usergroupid=9 WHERE posts BETWEEN 14 AND 150 AND usergroupid != 8";
$res = mysql_query($query) or die(mysql_error());
// comit? autogestion
$query = "UPDATE vb_user SET usergroupid=13 WHERE posts > 99 AND joindate < $abc AND usergroupid != 8";
$res = mysql_query($query) or die(mysql_error());
?>

Problem is that all the users gets banned after being promoted !!!

So:

1) What's wrong with my script and why does the users gets banned ?

2) How can i unban all users that were banned for no reason ?
- In ModCP it doesn't show any information about the bans : ban date not available, "banned by" not available, lift date not available
- In vb_userban table, only the users banned by my moderators are shown. The users that got banned automatically after being promoted by my php script are NOT displayed in this table.

--------------- Added [DATE]1377018829[/DATE] at [TIME]1377018829[/TIME] ---------------

Apparently lots of my users are saying that they are on the banlist but they can still post on the forum so i'm not sure what's happenning...

Anyway, how can i promote users to a new group through a php script without putting the users on the banlist ?

[NeXuM]

I think it would be better suited for the "coding forum" can a moderator move it to this forum ?

[Max Taxable]

Originally Posted by NeXuM

The cron jobs stopped working since a long time on my vbulletin 3.6.4 forum for an unknown reason,

I bet'cha this is because for some reason, you might have inadvertently removed the cronimage from the footer. That will make cron stop working, every time.

[Zachery]

Why wouldn't you fix the scheduled tasks instead of writing a custom script to only do one of the many things they do?

[NeXuM]

Originally Posted by Max Taxable

I bet'cha this is because for some reason, you might have inadvertently removed the cronimage from the footer. That will make cron stop working, every time.

No.

Why wouldn't you fix the scheduled tasks instead of writing a custom script to only do one of the many things they do?

I tried...

https://vborg.vbsupport.ru/showthread.php?t=299778

[Max Taxable]

Originally Posted by NeXuM

No.

I looked at your source code, didn't see the cronimage.

[NeXuM]

Originally Posted by Max Taxable

I looked at your source code, didn't see the cronimage.

It's here. http://www.pirate-punk.net/index.php

<img src="http://www.pirate-punk.net/cron.php?&amp;rand=920528" alt="" width="1" height="1" border="0" />

Even if i reset the skin to default, cron jobs still aren't working. http://www.pirate-punk.net/index.php?styleid=5

This is the first thing i tried when i had problems with crons. I gave up and i wrote my own scripts. Just need to figure why the users end up being banned (and how to remove the users that were mass banned because of this script)

I'm sure there is a vbulletin file i can include in my php script to use a vb function to promote my users to a new group without having them end up on the banlist.

[Max Taxable]

cron.php?&amp;rand=920528" alt="" width="1" height="1" border="0"

In the code, the bolded should not be there. This breaks the string.

And what you should actually have is a hook called, like this:

<!-- Do not remove $cronimage or your scheduled tasks will cease to function -->
	$cronimage
	<!-- Do not remove $cronimage or your scheduled tasks will cease to function -->

[NeXuM]

The code in my footer is

$cronimage

i don't control how vbulletin outputs it.

[snakes1100]

What kind of trouble shooting have you done so far to see why the cron isnt running?

Is this a dedicate/vps server?