function getpost($id)
{
$query = "SELECT * FROM Post WHERE idpost = '" . $id . "'";
$result = newQuery("Usuarios", "", $query);
if ($result != false || $result > 0) {
foreach ($result as $value) {
return $value;
}
} else {
return false;
}
}
function getUser($id)
{
$query = "SELECT * FROM ConfigUsuarios WHERE idconfigUsuarios = '" . $id . "'";
$result = newQuery("Usuarios", "", $query);
if ($result != false || $result > 0) {
foreach ($result as $value) {
return $value;
}
} else {
return false;
}
}
function reOrderItems($tabl, $ar_where, $indx, $ordr, $sortby, $start, $inc)
{
$strng = "SELECT {$indx},{$ordr} FROM {$tabl} ";
if ($wh_str = where_list($ar_where)) {
$strng .= " WHERE {$wh_str} ";
}
$orderby = $sortby ? " ORDER BY {$sortby} " : " ORDER BY {$ordr} ";
$strng .= "{$orderby} ;";
$rX = newQuery($strng, 0);
$ar = pg_fetch_assoc($rX);
$v = $start;
while ($ar) {
$rU = newQuery("UPDATE {$tabl} SET {$ordr}={$v} WHERE {$indx}=" . $ar["{$indx}"], 0);
pg_free_result($rU);
$v += $inc;
$ar = pg_fetch_assoc($rX);
}
pg_free_result($rX);
}
