public static function getTweetsPostedBy($idUser)
 {
     $connection = new dbconnection();
     $sql = "select * from jabaianb.tweet where emetteur='" . $idUser . "'";
     $res = $connection->doQueryObject($sql, "tweet");
     return $res === false ? false : $res;
 }

 public static function getPostbyId($id)
 {
     $connection = new dbconnection();
     $sql = "select * from jabaianb.post where id='" . $id . "'";
     $res = $connection->doQueryObject($sql, "post");
     return $res === false ? false : $res;
 }

 public function save()
 {
     $connection = new dbconnection();
     if ($this->id) {
         $sql = "update jabaianb." . get_class($this) . " set ";
         $set = array();
         foreach ($this->data as $att => $value) {
             if ($att != 'id' && $value) {
                 $set[] = "{$att} = '" . $value . "'";
             }
         }
         $sql .= implode(",", $set);
         $sql .= " where id=" . $this->id;
     } else {
         $sql = "insert into jabaianb." . get_class($this) . " ";
         $sql .= "(" . implode(",", array_keys($this->data)) . ") ";
         $sql .= "values ('" . implode("','", array_values($this->data)) . "')";
     }
     $connection->doExec($sql);
     /*
      *  Sans cette modiffication, on recevait une erreur après un UPDATE:
      *      Object not in prerequisite state: 7 ERROR: currval of sequence "post_id_seq" is not yet defined in this session
      */
     if (!$this->id) {
         $this->id = $connection->getLastInsertId("jabaianb." . get_class($this));
     }
     return $this->id == false ? NULL : $this->id;
 }

 public static function getLike($id)
 {
     $connection = new dbconnection();
     $sql = "select count(*) from jabaianb.vote where tweet='" . $id . "'";
     $res = $connection->doQuery($sql);
     return $res === false ? false : $res;
 }

 public static function getUsers()
 {
     $connection = new dbconnection();
     $sql = "select * from jabaianb.utilisateur";
     $res = $connection->doQueryObject($sql, "utilisateurTable");
     return $res === false ? false : $res;
 }

 public static function getCountLastTweets($startDate)
 {
     $connection = new dbconnection();
     $sql = "SELECT COUNT(*) FROM jabaianb.tweet T\n\t\t            INNER JOIN jabaianb.post P ON (T.post = P.id)\n\t\t        WHERE P.date > '" . $startDate . "'";
     $res = $connection->doQuery($sql);
     if ($res === false) {
         return null;
     }
     return $res[0]["count"];
 }

 public static function getCountLikesById($tweetId)
 {
     $connection = new dbconnection();
     $sql = "SELECT COUNT(*) FROM jabaianb.vote WHERE message = " . $tweetId;
     $res = $connection->doQuery($sql);
     if ($res === false) {
         return 0;
     }
     return $res[0]["count"];
 }

 public static function getUsersWhoLikeTweetById($tweetId)
 {
     $connection = new dbconnection();
     $sql = "SELECT U.* FROM jabaianb.utilisateur U\r\n\t\t\t\t\tINNER JOIN jabaianb.vote V ON (U.id = V.utilisateur)\r\n\t\t\t\tWHERE V.message = " . $tweetId;
     $res = $connection->doQueryObject($sql, "utilisateur");
     if ($res === false) {
         return null;
     }
     return $res;
 }

function preload_lists()
{
    $db = new dbconnection();
    $db->dbconnect();
    $db->query = "select listid,listname from " . TABLE_LISTS . " where active=1";
    $db->execute();
    $rowcount = $db->rowcount();
    if ($rowcount > 0) {
        for ($x = 0; $x < $rowcount; $x++) {
            $row = $db->fetchrow($x);
            $list[$x] = $row;
        }
    }
    return $list;
}

 public static function getColors($pack)
 {
     $sql_colors = dbconnection::queryObject("SELECT * FROM colors WHERE colors_id = '{$pack->colors_id}' LIMIT 1");
     if (!$sql_colors) {
         return new return_package(2, NULL, "The colors you've requested do not exist");
     }
     return new return_package(0, colors::colorsObjectFromSQL($sql_colors));
 }

 public function getCategoryHints($q)
 {
     $query = "select categoryid,name from couponcategories where name LIKE '" . htmlspecialchars($q) . "%'" . " limit 1";
     $dbinstance = dbconnection::getinstance();
     $connhandle = $dbinstance->connhandle;
     $result = $connhandle->query($query);
     return $result;
 }

 public static function getinstance()
 {
     if (!isset(self::$instance)) {
         self::$instance = new dbconnection();
     } else {
         //echo "singleton construct not called";
     }
     return self::$instance;
 }

 public static function removeEditorFromGame($pack)
 {
     $pack->auth->game_id = $pack->game_id;
     $pack->auth->permission = "read_write";
     if (!editors::authenticateGameEditor($pack->auth)) {
         return new return_package(6, NULL, "Failed Authentication");
     }
     //note $pack->user_id is DIFFERENT than $pack->auth->user_id
     dbconnection::query("DELETE FROM user_games WHERE user_id = '{$pack->user_id}' AND game_id = '{$pack->game_id}'");
     games::bumpGameVersion($pack);
     return new return_package(0);
 }

 function changepassword($userid, $oldpass, $newpass, $newpassrepeat)
 {
     if ($newpass == $newpassrepeat) {
         $enc = new Encryption();
         $db = new dbconnection();
         $db->dbconnect();
         //check oldpass, update password if ok, send message if not
         $password = $enc->oneway_encode($oldpass);
         $db->query = "select userid from " . TABLE_USERS . " where userid={$userid} and password='{$password}'";
         $db->execute();
         if ($db->rowcount() > 0) {
             $newpass = $enc->oneway_encode($newpass);
             $db->query = "update " . TABLE_USERS . " set password='{$newpass}' where userid={$userid}";
             $db->execute();
             $msg = 'Password updated.';
         } else {
             $msg = 'Incorrect old password.';
         }
     } else {
         $msg = 'New password does not match.';
     }
     return $msg;
 }

 public static function deleteGroup($pack)
 {
     $group = dbconnection::queryObject("SELECT * FROM groups WHERE group_id = '{$pack->group_id}'");
     $pack->auth->game_id = $group->game_id;
     $pack->auth->permission = "read_write";
     if (!editors::authenticateGameEditor($pack->auth)) {
         return new return_package(6, NULL, "Failed Authentication");
     }
     dbconnection::query("DELETE FROM groups WHERE group_id = '{$pack->group_id}' LIMIT 1");
     //cleanup
     dbconnection::query("UPDATE game_user_groups SET group_id = 0 WHERE game_id = '{$group->game_id}' AND group_id = '{$group->group_id}';");
     games::bumpGameVersion($pack);
     return new return_package(0);
 }

 public function save()
 {
     $connection = new dbconnection();
     if (isset($this->id)) {
         $sql = "update jabaianb." . get_class($this) . " set ";
         $set = array();
         foreach ($this->data as $att => $value) {
             if ($att != 'id' && $value) {
                 $set[] = "{$att} = '" . $value . "'";
             }
         }
         $sql .= implode(",", $set);
         $sql .= " where id=" . $this->id;
     } else {
         $sql = "insert into jabaianb." . get_class($this) . " ";
         $sql .= "(" . implode(",", array_keys($this->data)) . ") ";
         $sql .= "values ('" . implode("','", array_values($this->data)) . "')";
     }
     //print_r($sql);
     $connection->doExec($sql);
     $id = $connection->getLastInsertId("jabaianb." . get_class($this));
     //print_r($id);
     return $id == false ? NULL : $id;
 }

 private static function applyUpgrade($user_id, $maj, $min)
 {
     $file = "db/upgrades/" . $maj . "." . $min . ".sql";
     $upgrade = fopen($file, "r");
     while (!feof($upgrade)) {
         $query = fgets($upgrade);
         if (preg_match("@^\\s*\$@is", $query)) {
             continue;
         }
         //ignore whitespace
         dbconnection::query($query);
     }
     fclose($upgrade);
     dbconnection::queryInsert("INSERT INTO db_upgrades (user_id, version_major, version_minor, timestamp) VALUES ('{$user_id}', '{$maj}', '{$min}', CURRENT_TIMESTAMP)");
 }

 public static function deleteOverlay($pack)
 {
     $overlay = dbconnection::queryObject("SELECT * FROM overlays WHERE overlay_id = '{$pack->overlay_id}'");
     $pack->auth->game_id = $overlay->game_id;
     $pack->auth->permission = "read_write";
     if (!editors::authenticateGameEditor($pack->auth)) {
         return new return_package(6, NULL, "Failed Authentication");
     }
     dbconnection::query("DELETE FROM overlays WHERE overlay_id = '{$pack->overlay_id}' LIMIT 1");
     //cleanup
     $reqPack = dbconnection::queryObject("SELECT * FROM requirement_root_packages WHERE requirement_root_package_id = '{$overlay->requirement_root_package_id}'");
     if ($reqPack) {
         $pack->requirement_root_package_id = $reqPack->requirement_root_package_id;
         requirements::deleteRequirementPackage($pack);
     }
     games::bumpGameVersion($pack);
     return new return_package(0);
 }

 public static function getConnection()
 {
     if (dbconnection::$dbconnection === NULL) {
         // database access credentials stored in variables
         $host = "localhost";
         $database = "n00143888playground";
         //            $username = "N00143888";
         //            $password = "N00143888";
         $username = "root";
         $password = "";
         $dsn = "mysql:host=" . $host . ";dbname=" . $database;
         dbconnection::$dbconnection = new PDO($dsn, $username, $password);
         if (!dbconnection::$dbconnection) {
             die("Database connection failed");
         }
     }
     return dbconnection::$dbconnection;
 }

 public static function getLeaderboard($pack)
 {
     $insts = dbconnection::queryArray("SELECT * FROM instances WHERE game_id = '{$pack->game_id}' AND object_type = 'ITEM' AND object_id = '{$pack->item_id}' AND owner_type = 'USER' ORDER BY qty DESC LIMIT 10;");
     $entries = array();
     for ($i = 0; $i < count($insts); $i++) {
         $inst = $insts[$i];
         $user = dbconnection::queryObject("SELECT * FROM users WHERE user_id = '{$inst->owner_id}';");
         $entries[$i] = new stdClass();
         $entries[$i]->qty = $inst->qty;
         if ($user) {
             $entries[$i]->user_id = $user->user_id;
             $entries[$i]->user_name = $user->user_name;
             $entries[$i]->display_name = $user->display_name;
         } else {
             $entries[$i]->user_id = 0;
             $entries[$i]->user_name = "(user not found)";
             $entries[$i]->display_name = "(user not found)";
         }
     }
     return new return_package(0, $entries);
 }