Пример #1
0
 function getAllProjects()
 {
     global $TABLE_PREFIX;
     $sql = new sql();
     $sql->query("SELECT * FROM " . $TABLE_PREFIX . "projects;");
     $ret = array();
     while ($row = $sql->getNextRow()) {
         array_push($ret, $row);
     }
     return $ret;
 }
Пример #2
0
 function getAllBugs()
 {
     global $TABLE_PREFIX;
     $sql = new sql();
     $sql->query("SELECT * FROM " . $TABLE_PREFIX . "bugs ORDER BY bID DESC;");
     $ret = array();
     while ($row = $sql->getNextRow()) {
         array_push($ret, $row);
     }
     return $ret;
 }
Пример #3
0
function getRights($id)
{
    if (isset($id)) {
        global $TABLE_PREFIX;
        $sql = new sql();
        $sql->query("SELECT * FROM " . $TABLE_PREFIX . "user_rights WHERE userID = " . $id);
        $ret = $sql->getNextRow();
        return $ret;
    }
}
Пример #4
0
function executeGetAll($table_name)
{
    global $TABLE_PREFIX;
    $sql = new sql();
    $sql->query("SELECT * FROM " . $TABLE_PREFIX . $table_name . ";");
    $ret = array();
    while ($row = $sql->getNextRow()) {
        array_push($ret, $row);
    }
    return $ret;
}