[Nullifi3d]

PHP Code:

$armysys = $vbulletin->db->query_read("SELECT strike_action, defense_action, spy_rating, sentry_rating, attack_soldiers, defense_soldiers, untrained_soldiers, spies, sentries FROM " . TABLE_PREFIX . "armysys"); 


If I use Query_first it doesn't work.

Sorry, it's suppose to be:

PHP Code:

while ($armyinfo = $vbulletin->db->fetch_array($armysys)) { 


I use this code elsewhere and it works fine:

PHP Code:

$links = $db->query_read("SELECT pl_href AS href, pl_title AS title, pl_anchor AS anchor FROM " . TABLE_PREFIX . "user WHERE pl_href != ''");
while ($link = $db->fetch_array($links)) eval('$premium_links .= "' . fetch_template('directory_premium_links') . '";'); 


This works fine to print out each row that $links stores. Why doesn't this query (whether or not I use query_read or query_first):

PHP Code:

 $armysys = $vbulletin->db->query_read("SELECT strike_action, defense_action, spy_rating, sentry_rating, attack_soldiers, defense_soldiers, untrained_soldiers, spies, sentries FROM " . TABLE_PREFIX . "armysys");
while ($armyinfo = $vbulletin->db->fetch_array($armysys)) {
    $rank = ( ($armyinfo['strike_action'] + $armyinfo['defense_action'] + $armyinfo['spy_rating'] + $armyinfo['sentry_rating']) / (4) );
    $gold = ( ($armyinfo['attack_soldiers'] * 15) + ($armyinfo['defense_soldiers'] * 15) + ($armyinfo['untrained_soldiers'] * 5) + ($armyinfo['spies'] * 10) + ($armyinfo['sentries'] * 10) );
    $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "armysys SET rank = '$rank', gold = gold + '$gold'");
}