necrotic — Mon, 28 Oct 2002 21:03:41 +0000

Ah, thanks

How would I return all columns? All I get is the first column. There are 8 columns: id,name,price,attack,defense,special,forw,type.

Mark Hensler — Mon, 28 Oct 2002 20:48:05 +0000

In vBulletin, $db->query_first returns the array of the first result.

You see exactly what it does in ~admin/db_mysql.php

<?php
if ($action == \"store\") {
  // Get Items For Sale
  $sitems   = $DB_site->query(\"SELECT * FROM rpg_items WHERE type='item'\");
  $sweapons = $DB_site->query(\"SELECT * FROM rpg_items WHERE type='weapon'\");
  $sarmor   = $DB_site->query(\"SELECT * FROM rpg_items WHERE type='armor'\");

  // Get User Gil
  $gil = $DB_site->query_first(\"SELECT gil FROM user WHERE userid='$bbuserinfo[userid]'\");

  // Sale bits
    // Weapons
    while($weapons = $DB_site->fetch_array($sweapons)) { // Line 148
      eval(\"\$wdisp = \\"\".gettemplate(\"rpg_store_weaponbit\").\"\\";\");
    }
    // Armor
    while($armor = $DB_site->fetch_array($sarmor)) { // Line 152
      eval(\"\$adisp = \\"\".gettemplate(\"rpg_store_armorbit\").\"\\";\");
    }
    // Items
    while($items = $DB_site->fetch_array($sitems)) { // Line 156
      eval(\"\$idisp = \\"\".gettemplate(\"rpg_store_itembit\").\"\\";\");
    }

  eval(\"dooutput(\\"\".gettemplate('rpg_main_store').\"\\");\");
}
?>