Awkward loop problem.

[Beffic]

So I have been trying to debug this. I have even copied an pasted from a exact match of this script and still come out of the fight empty handed.

So characters can get blessings from level one Might to level five. And speed does the same thing, just gives towards a different stat. So whenever Speed II is called the game freezes up where it needs to load this script so it can count all the Speed II blessings they have an add them up.

Every other script looks exactly like this except the name is different. Huh, so you would think it would be a database problem then in that area. Well I would think not. In the same case it looks exactly like all of the rest. I have quad checked myself. Help please and tank you! =)

Let me know if you need anymore additional information.

if (in_array('Speed II', $blessingStats)) 
{ 
    $result = mysql_query("SELECT level FROM affinity WHERE name='Speed II'"); 
    $level = mysql_fetch_assoc($result); 
    $foo = 0; 
    for($i = 0, $count = count($blessingStats); $i < $count; $i++) 
    { 
        if($blessingStats[$i] == 'Speed II') 
        { 
            $foo += $level['level']; 
        } 
    } 
    $equation = $foo / 10; 
    $totaldex += $chardex * $equation; 

}

[NogDog]

Have you checked your PHP error log, or turned on all error reporting in order to see if/what PHP is complaining about? (For instance, you do not check if the call to mysql_query() returns false, so for all we know there is a SQL error trashing things for you.)

[Weedpacket]

I'm wondering why the loop in the first place. Surely that's just:

$foo = $level['level'] * count(array_keys($blessingStats, 'Speed II'));

[Beffic]

Error Logs are clean, I have added die statements to a javascript alert to locate any problem with the database and fail to see any.

I tried what WeedPacket said to do, which by the way would shorten my script ultimately so I love the idea thank you, but still same problem. Script just freezes up after Speed II is applied to the character.

<?php

$blessingStats = explode(', ', $char['blessing']);

if (in_array('Might', $blessingStats)) 
{ 
    $result = mysql_query("SELECT level FROM affinity WHERE name='Might'"); 
    $level = mysql_fetch_assoc($result); 
    $foo = 0; 
    for($i = 0, $count = count($blessingStats); $i < $count; $i++) 
    { 
        if($blessingStats[$i] == 'Might') 
        { 
            $foo += $level['level']; 
        } 
    } 
    $equation = $foo / 10; 
    $totalstr += $charstr * $equation; 

}
if (in_array('Might II', $blessingStats)) 
{ 
    $result = mysql_query("SELECT level FROM affinity WHERE name='Might II'"); 
    $level = mysql_fetch_assoc($result); 
    $foo = 0; 
    for($i = 0, $count = count($blessingStats); $i < $count; $i++) 
    { 
        if($blessingStats[$i] == 'Might II') 
        { 
            $foo += $level['level']; 
        } 
    } 
    $equation = $foo / 10; 
    $totalstr += $charstr * $equation; 

}
if (in_array('Might III', $blessingStats)) 
{ 
    $result = mysql_query("SELECT level FROM affinity WHERE name='Might III'"); 
    $level = mysql_fetch_assoc($result); 
    $foo = 0; 
    for($i = 0, $count = count($blessingStats); $i < $count; $i++) 
    { 
        if($blessingStats[$i] == 'Might III') 
        { 
            $foo += $level['level']; 
        } 
    } 
    $equation = $foo / 10; 
    $totalstr += $charstr * $equation; 

}
if (in_array('Might IV', $blessingStats)) 
{ 
    $result = mysql_query("SELECT level FROM affinity WHERE name='Might IV'"); 
    $level = mysql_fetch_assoc($result); 
    $foo = 0; 
    for($i = 0, $count = count($blessingStats); $i < $count; $i++) 
    { 
        if($blessingStats[$i] == 'Might IV') 
        { 
            $foo += $level['level']; 
        } 
    } 
    $equation = $foo / 10; 
    $totalstr += $charstr * $equation; 

}
if (in_array('Might V', $blessingStats)) 
{ 
    $result = mysql_query("SELECT level FROM affinity WHERE name='Might V'"); 
    $level = mysql_fetch_assoc($result); 
    $foo = 0; 
    for($i = 0, $count = count($blessingStats); $i < $count; $i++) 
    { 
        if($blessingStats[$i] == 'Might V') 
        { 
            $foo += $level['level']; 
        } 
    } 
    $equation = $foo / 10; 
    $totalstr += $charstr * $equation; 

}
$stradd = '<font color="#0099FF">+ ' . $totalstr . '</font>';
if (in_array('Speed', $blessingStats)) 
{ 
    $result = mysql_query("SELECT level FROM affinity WHERE name='Speed'"); 
    $level = mysql_fetch_assoc($result); 
    $foo = 0; 
    for($i = 0, $count = count($blessingStats); $i < $count; $i++) 
    { 
        if($blessingStats[$i] == 'Speed') 
        { 
            $foo += $level['level']; 
        } 
    } 
    $equation = $foo / 10; 
    $totaldex += $chardex * $equation; 

}
if (in_array('Speed II', $blessingStats)) 
{ 

$result = mysql_query("SELECT level FROM affinity WHERE name='Speed II'")or die("alert('Mysql Error!');"); 
$level = mysql_fetch_assoc($result)or die("alert('Mysql Error!');"); 
$foo = 0; 
for($i = 0, $count = count($blessingStats); $i < $count; $i++) 
{ 
    if($blessingStats[$i] == 'Speed II') 
    { 
        $foo += $level['level']; 
    } 
} 
$equation = $foo / 10; 
$totaldex += $chardex * $equation; 

}
if (in_array('Speed III', $blessingStats)) 
{ 
    $result = mysql_query("SELECT level FROM affinity WHERE name='Speed III'"); 
    $level = mysql_fetch_assoc($result); 
    $foo = 0; 
    for($i = 0, $count = count($blessingStats); $i < $count; $i++) 
    { 
        if($blessingStats[$i] == 'Speed III') 
        { 
            $foo += $level['level']; 
        } 
    } 
    $equation = $foo / 10; 
    $totaldex += $chardex * $equation; 

}
if (in_array('Speed IV', $blessingStats)) 
{ 
    $result = mysql_query("SELECT level FROM affinity WHERE name='Speed IV'"); 
    $level = mysql_fetch_assoc($result); 
    $foo = 0; 
    for($i = 0, $count = count($blessingStats); $i < $count; $i++) 
    { 
        if($blessingStats[$i] == 'Speed IV') 
        { 
            $foo += $level['level']; 
        } 
    } 
    $equation = $foo / 10; 
    $totaldex += $chardex * $equation; 

}
if (in_array('Speed V', $blessingStats)) 
{ 
    $result = mysql_query("SELECT level FROM affinity WHERE name='Speed V'"); 
    $level = mysql_fetch_assoc($result); 
    $foo = 0; 
    for($i = 0, $count = count($blessingStats); $i < $count; $i++) 
    { 
        if($blessingStats[$i] == 'Speed V') 
        { 
            $foo += $level['level']; 
        } 
    } 
    $equation = $foo / 10; 
    $totaldex += $chardex * $equation; 

}
$dexadd = '<font color="#0099FF">+ ' . $totaldex . '</font>';
if (in_array('Constitution', $blessingStats)) 
{ 
    $result = mysql_query("SELECT level FROM affinity WHERE name='Constitution'"); 
    $level = mysql_fetch_assoc($result); 
    $foo = 0; 
    for($i = 0, $count = count($blessingStats); $i < $count; $i++) 
    { 
        if($blessingStats[$i] == 'Constitution') 
        { 
            $foo += $level['level']; 
        } 
    } 
    $equation = $foo / 10; 
    $totalend += $charend * $equation; 

}
if (in_array('Constitution II', $blessingStats)) 
{ 
    $result = mysql_query("SELECT level FROM affinity WHERE name='Constitution II'"); 
    $level = mysql_fetch_assoc($result); 
    $foo = 0; 
    for($i = 0, $count = count($blessingStats); $i < $count; $i++) 
    { 
        if($blessingStats[$i] == 'Constitution II') 
        { 
            $foo += $level['level']; 
        } 
    } 
    $equation = $foo / 10; 
    $totalend += $charend * $equation; 

}
if (in_array('Constitution III', $blessingStats)) 
{ 
    $result = mysql_query("SELECT level FROM affinity WHERE name='Constitution III'"); 
    $level = mysql_fetch_assoc($result); 
    $foo = 0; 
    for($i = 0, $count = count($blessingStats); $i < $count; $i++) 
    { 
        if($blessingStats[$i] == 'Constitution III') 
        { 
            $foo += $level['level']; 
        } 
    } 
    $equation = $foo / 10; 
    $totalend += $charend * $equation; 

}
if (in_array('Constitution IV', $blessingStats)) 
{ 
    $result = mysql_query("SELECT level FROM affinity WHERE name='Constitution IV'"); 
    $level = mysql_fetch_assoc($result); 
    $foo = 0; 
    for($i = 0, $count = count($blessingStats); $i < $count; $i++) 
    { 
        if($blessingStats[$i] == 'Constitution IV') 
        { 
            $foo += $level['level']; 
        } 
    } 
    $equation = $foo / 10; 
    $totalend += $charend * $equation; 

}
if (in_array('Constitution V', $blessingStats)) 
{ 
    $result = mysql_query("SELECT level FROM affinity WHERE name='Constitution V'"); 
    $level = mysql_fetch_assoc($result); 
    $foo = 0; 
    for($i = 0, $count = count($blessingStats); $i < $count; $i++) 
    { 
        if($blessingStats[$i] == 'Constitution V') 
        { 
            $foo += $level['level']; 
        } 
    } 
    $equation = $foo / 10; 
    $totalend += $charend * $equation; 

}
$endadd = '<font color="#0099FF">+ ' . $totalend . '</font>';

?>

[sneakyimp]

turn up error reporting to full blast and see if anything comes out:

error_reporting(E_ALL);

Whenever you run a query, make sure you check for errors every single time.

When you pull a mysql_fetch_assoc, you may be getting no records. your code doesn't take this into account.

If you can't get an error by turning up error_reporting, then I would try some echo statements after each line to see exactly which line is killing it. or, if you have been clever enough to set up a proper PHP IDE, then you would be able to step through your code and inspect the var values.

[Neville1985]

you might want to create a function that will do this all for you. You've repeated code several times for what is effectively the same job. Won't take much to it and will save you a lot of headaches if you need to change something later on.