Rsa97

SELECT * 
    FROM (SELECT DISTINCT IF(`who1` = 'glados', `who2`, `who1`) AS `name`
            FROM `whois` 
            WHERE (`who1` = 'glados' OR `who2` = 'glados') 
                AND `who1` != `who2`)
        AS `who`
    LEFT JOIN `whereis` AS `where` ON `where`.`author` = `who`.`name`

private function isNormalFileSize($filename) {
    clearstatcache(TRUE, $filename); // сброс кэша
    return (file_exists($filename) && (filesize($filename) < 1048576));
}

function total_price($cart) {
  $total_price = 0.0;
  db_connect();	/* Надо переписать на mysqli */
  if(is_array($cart)){
    $query = $mysqli->prepare("SELECT `price` FROM `sdvd_products` WHERE `id` = ?");
    $query->bind_param('i', $id);
    $query->bind_result($item_price);
    foreach($cart as $id => $qty) {
      $query->execute();
      if ($query->fetch())
        $total_price += $item_price * $qty;
    }
    $query->close();
  }
  return $total_price;
}