- rewrite of sql queries to new form

Marius Cramer

2015-04-07 cc7a82756b4f4d7ab18e928527c37489adbaf564

 interface/web/mailuser/index.php

@@ -17,8 +17,8 @@
include $lng_file;
$app->tpl->setVar($wb);

$sql = "SELECT * FROM mail_user WHERE mailuser_id = ".$app->functions->intval($_SESSION['s']['user']['mailuser_id']);
$rec = $app->db->queryOneRecord($sql);
$sql = "SELECT * FROM mail_user WHERE mailuser_id = ?";
$rec = $app->db->queryOneRecord($sql, $_SESSION['s']['user']['mailuser_id']);

if($rec['quota'] == 0) {
   $rec['quota'] = $wb['unlimited_txt'];
@@ -30,8 +30,8 @@

$app->tpl->setVar($rec);

$sql2 = "SELECT * FROM server WHERE server_id = ".$app->functions->intval($rec['server_id']);
$rec2 = $app->db->queryOneRecord($sql2);
$sql2 = "SELECT * FROM server WHERE server_id = ?";
$rec2 = $app->db->queryOneRecord($sql2, $rec['server_id']);

$app->tpl->setVar($rec2);