---

$userpostcount = $DB->query_first("SELECT posts AS value FROM " . $forum_info_arr['forum_table_prefix'] . "members WHERE ID_MEMBER = $user_info[user_id]");

---

---

$userpostcount = $DB->query_first("SELECT money AS value FROM " . $forum_info_arr['forum_table_prefix'] . "members WHERE ID_MEMBER = $user_info[user_id]");

---

---

if($points_spent = $DB->query_first("SELECT points_spent AS value FROM {points_spent} WHERE user_id = $user_info[user_id]"))
  {
    $user_info['points_spent'] = $points_spent['value'];
  }
  else
  {
    $user_info['points_spent'] = 0;
  }
 
  $user_info['points'] = $userpostcount['value'] - $user_info['points_spent'];

---

---

$user_info['points'] = $userpostcount['value'];

---

---

if($previous_purchaser = $DB->query_first("SELECT * FROM {points_spent} WHERE user_id = $user_info[user_id]"))
    {
      $DB->query("UPDATE {points_spent} SET points_spent = points_spent + $item[cost]
                  WHERE user_id = $user_info[user_id]");
    }
    else
    {
      $DB->query("INSERT INTO {points_spent} (user_id, points_spent)
                  VALUES ($user_info[user_id], $item[cost])");
    }

---

---

$DB->query("UPDATE $forum_info_arr['forum_table_prefix'] . "members SET money = money - $item[cost] WHERE ID_MEMBER = $user_info[user_id]");

---

Attached Images

header_292x136.jpg (24.0 KB)