[RESOLVED] Cron reset not working appropriately

[Beffic]

So I have a daily reset on my website and I have it working with a cron job and I can't quite get this code to work.

When the game does its reset, it selects from users where affinity equals so much. Default is two Affinities. Well I gave my character three Affinities but still when reset occurs the display still comes out as only two affinities(None, None, Buy, Buy, Buy).

<?php
$getcharacters = mysql_query("SELECT * FROM characters");
while($characters = mysql_fetch_array($getcharacters))
{
    $blessing = explode(', ', $characters['blessing']);

if($characters['affinitys'] >= '1')
{
    $blessing[0] = "None";
}
if($characters['affinitys'] >= '2')
{
    $blessing[1] = "None";
}
if($characters['affinitys'] >= '3')
{
    $blessing[2] = "None";
}
if($characters['affinitys'] >= '4')
{
    $blessing[3] = "None";
}
if($characters['affinitys'] >= '5')
{
    $blessing[4] = "None";
}

$updatedBlessings = "".$blessing[0].", ".$blessing[1].", ".$blessing[2].", ".$blessing[3].", ".$blessing[4]."";
$runblessingReset = mysql_query("UPDATE characters SET blessing='".$updatedBlessings."'");
}

[Beffic]

Anyone?

[dagon]

echo the query, is it right?

[Beffic]

Well it looks like it echo's right. Cause I would be the first part with "None, None, None, Buy, Buy".

But all I see is, "None, None, Buy, Buy, Buy".

None, None, None, Buy, Buy
None, None, Buy, Buy, Buy
None, None, Buy, Buy, Buy
None, None, Buy, Buy, Buy
None, None, Buy, Buy, Buy
None, None, Buy, Buy, Buy
None, None, Buy, Buy, Buy
None, None, Buy, Buy, Buy
None, None, Buy, Buy, Buy
None, None, Buy, Buy, Buy
None, None, Buy, Buy, Buy
None, None, Buy, Buy, Buy
None, None, Buy, Buy, Buy
None, None, Buy, Buy, Buy
None, None, Buy, Buy, Buy
None, None, Buy, Buy, Buy
None, None, Buy, Buy, Buy
None, None, Buy, Buy, Buy
None, None, Buy, Buy, Buy
None, None, Buy, Buy, Buy
None, None, Buy, Buy, Buy
None, None, Buy, Buy, Buy
None, None, Buy, Buy, Buy
None, None, Buy, Buy, Buy
None, None, Buy, Buy, Buy

[Beffic]

I looked at the database and it comes back "None, None, Buy, Buy, Buy".

I have thought about maybe adding a update query for every time the if statement is true. Example:

if($characters['affinitys'] >= '1') 
    { 
        $updatedBlessings = "None, Buy, Buy, Buy, Buy";
        $runblessingReset = mysql_query("UPDATE characters SET blessing='".$updatedBlessings."' WHERE affinitys='1'");
    } 
    if($characters['affinitys'] >= '2') 
    { 
        $updatedBlessings = "None, None, Buy, Buy, Buy";
        $runblessingReset = mysql_query("UPDATE characters SET blessing='".$updatedBlessings."' WHERE affinitys='2'");
    } 

etc... Of course this would be a way doing things but I am looking for simplicity and don't want to run my bandwidth across the earth every time I want to run reset.

[Beffic]

Well if you guys have nothing more to do to help I will just use my alternative way.

Thanks...