Beispiel #1
0
 function addFeedbackFrom($user, $value)
 {
     require_once "query.php";
     $db = new DBManager();
     if (!$db->connect_errno()) {
         define_tables();
         defineFeedbackColumns();
         $table = Query::getDBSchema()->getTable(TABLE_FEEDBACK);
         $db->execute($s = Query::generateInsertStm($table, array(FEEDBACK_CREATOR => $user->getID(), FEEDBACK_SUBJECT => $this->getID(), FEEDBACK_VALUE => $value ? 1 : 0)), $table->getName(), $this);
         if ($db->affected_rows() != 1) {
             $db->display_error("User::addFeedbackFrom()");
         }
         //Genera un errore ma ritorna comunque $this
     } else {
         $db->display_connect_error("User::addFeedbackFrom()");
     }
     return $this->loadFeedback();
 }
Beispiel #2
0
 /**
  * Aggiunge una entry al Log.
  *
  * @param $user: l'utente che ha fatto l'azione.
  * @param $action: l'azione eseguita dall'utente, fa parte delle chiavi di LogManager::$actions.
  * @param $object: l'oggetto che subisce l'azione (prima che venga eseguita).
  *
  * @return: l'id della entry inserita, false se non c'è riuscito.
  */
 static function addLogEntry($user, $action, $tablename, $object)
 {
     if ($object == LOGMANAGER) {
         return;
     }
     //echo $user. $action. $tablename . serialize(is_object($object)); //DEBUG
     if (!isset($user) || !is_numeric($user) || !isset($action) || $action != self::$DELETE && $action != self::$INSERT && $action != self::$UPDATE || !isset($object) || is_null($object) || !is_object($object)) {
         return false;
     }
     $db = new DBManager();
     if (!$db->connect_errno()) {
         define_tables();
         defineLogColumns();
         $table = Query::getDBSchema()->getTable(TABLE_LOG);
         //echo "<br />" . $tablename; //DEBUG
         $sha1ed = sha1(serialize($object));
         $id = sha1($sha1ed . $action . $table . $user . time());
         $data = array(LOG_ID => $id, LOG_ACTION => $action, LOG_TABLE => $tablename, LOG_SUBJECT => $user, LOG_OBJECT => $sha1ed);
         $s = Query::generateInsertStm($table, $data);
         //echo "<br />" . $s; //DEBUG
         $rs = mysql_query($s, $db->dblink);
         //devo fare così è non usare DBManager::execute() perché non avrei affected_rows.
         if (mysql_affected_rows($db->dblink)) {
             return $id;
         } else {
             $db->display_error("LogManager::addLogEntry()");
         }
     } else {
         $db->display_connect_error("LogManager::addLogEntry()");
     }
     return false;
 }
Beispiel #3
0
 function loadFeedback()
 {
     require_once "query.php";
     $db = new DBManager();
     if (!$db->connect_errno()) {
         define_tables();
         defineFeedbackColumns();
         $table = Query::getDBSchema()->getTable(TABLE_FEEDBACK);
         $db->execute($s = Query::generateSelectStm(array($table), array(), array(new WhereConstraint($table->getColumn(FEEDBACK_SUBJECT), Operator::EQUAL, $this->getID())), array()));
         if ($db->num_rows() > 0) {
             require_once "strings/strings.php";
             $fb = FEEDBACK_INITIAL_VALUE;
             while ($row = $db->fetch_result()) {
                 $fb += intval($row[FEEDBACK_VALUE]) > 0 ? 1 : -1;
                 //se sul DB è 0 allora è -1 se è positivo allora +1;
             }
             return $this->setFeedback($fb);
         } else {
             if ($db->errno()) {
                 $db->display_error("User::loadFeedback()");
             }
         }
     } else {
         $db->display_connect_error("User::loadFeedback()");
     }
     return $this->setFeedback(FEEDBACK_INITIAL_VALUE);
 }
Beispiel #4
0
 static function loadMailsFromUser($user)
 {
     require_once "query.php";
     $db = new DBManager();
     if (!$db->connect_errno()) {
         define_tables();
         defineMailColumns();
         $table = Query::getDBSchema()->getTable(TABLE_MAIL);
         $db->execute($s = Query::generateSelectStm(array($table), array(), array(new WhereConstraint($table->getColumn(MAIL_FROM), Operator::EQUAL, $user)), array()), $table->getName(), $this);
         //echo "<p>" . $s . "</p>"; //DEBUG
         //echo "<p>" . $db->num_rows() . "</p>"; //DEBUG
         if ($db->num_rows() == 1) {
             // echo serialize(mysql_fetch_assoc($rs)); //DEBUG
             $mails = array();
             while ($row = $db->fetch_result()) {
                 $data = array("text" => $row[MAIL_TEXT], "subject" => $row[MAIL_SUBJECT], "from" => intval($row[MAIL_FROM]), "to" => $row[MAIL_TO], "repliesTo" => $row[MAIL_REPLIES_TO]);
                 $m = new Mail($data);
                 $m->setID(intval($row[MAIL_ID]))->setCreationDate(date_timestamp_get(date_create_from_format("Y-m-d G:i:s", $row[MAIL_CREATION_DATE])));
                 $mails[] = $m;
             }
             //echo "<p>" .$m ."</p>";
             return $mails;
         } else {
             $db->display_error("Mail::loadMailsFromUser()");
         }
     } else {
         $db->display_connect_error("Mail::loadMailsFromUser()");
     }
     return false;
 }
Beispiel #5
0
 /**
  * Carica in this i report recuperati dal database per questo post (deve avere un ID!).
  */
 function loadReports()
 {
     require_once "query.php";
     $db = new DBManager();
     if (!$db->connect_errno()) {
         define_tables();
         defineReportColumns();
         $table = Query::getDBSchema()->getTable(TABLE_REPORT);
         $rs = $db->execute($s = Query::generateSelectStm(array($table), array(), array(new WhereConstraint($table->getColumn(REPORT_POST), Operator::EQUAL, $this->getID())), array()), $table->getName(), $this);
         if ($rs !== false) {
             $reports = array();
             while ($row = $db->fetch_result()) {
                 require_once "common.php";
                 $report = new Report(intval($row[REPORT_USER]), intval($row[REPORT_POST]), $row[REPORT_TEXT]);
                 $report->setID($row[REPORT_ID]);
                 $reports[] = $report;
             }
             $this->setReports($reports);
         } else {
             if ($db->errno()) {
                 $db->display_error("Post::loadReports()");
             }
         }
     } else {
         $db->display_connect_error("Post::loadReports()");
     }
     return $this;
 }
Beispiel #6
0
 function loadWinners()
 {
     require_once "query.php";
     $db = new DBManager();
     if (!$db->connect_errno()) {
         $table = Query::getDBSchema()->getTable(TABLE_CONTEST_SUBSCRIBER);
         $rs = $db->execute($s = Query::generateSelectStm(array($table), array(), array(new WhereConstraint($table->getColumn(CONTEST_SUBSCRIBER_CONTEST), Operator::EQUAL, $this->getID()), new WhereConstraint($table->getColumn(CONTEST_SUBSCRIBER_PLACEMENT), Operator::GREATER, 0)), array()), $table->getName(), $this);
         //echo "<p>" . $s . "</p>"; //DEBUG;
         //echo "<p>" . mysql_num_rows($rs) . "</p>"; //DEBUG;
         if ($db->num_rows() > 0) {
             $win = array();
             while ($row = $db->fetch_result()) {
                 $win[$row[CONTEST_SUBSCRIBER_PLACEMENT]] = $row[CONTEST_SUBSCRIBER_POST];
                 // Con in cs_winner il numero di posizione
                 //$win[] = $row[CONTEST_SUBSCRIBER_POST];  // Con in cs_winner true o false
             }
             $this->setWinners($win);
         } else {
             if ($db->errno()) {
                 $db->display_error("Contest::loadWinners()");
             }
         }
     } else {
         $db->display_connect_error("Contest::loadWinners()");
     }
     return $this;
 }
Beispiel #7
0
//	$mysqli->close();
$db = new DBManager();
require_once "db.php";
$queries = explode("\n\n", $s);
for ($i = 0; $i < count($queries); $i++) {
    $db->execute($queries[$i], null, LOGMANAGER);
    if ($db->result) {
        $ss = explode("`", $queries[$i]);
        echo "<p>TABLE " . $ss[1] . " INSTALLED</p>";
    } else {
        //DEBUG
        $s = str_replace(",", ",<br />", $queries[$i]);
        $s = str_replace(") ENGINE", ")<br />ENGINE", $s);
        echo $s;
        //DEBUG
        echo $db->display_error("Install.php");
    }
}
$db->execute("INSERT INTO `Role` VALUES('admin')", "Role", null);
$ra = $db->affected_rows();
$db->execute("INSERT INTO `Role` VALUES('user')", "Role", null);
$ra += $db->affected_rows();
if ($ra == 2) {
    echo "<p>INSERTED ROLES</p>";
} else {
    $db->display_error("Install.php");
}
// DEBUG
$db->execute("INSERT INTO `User` VALUES(1, 'ioesisto', '*****@*****.**', sha1('ciccia'), 'Io', 'Esisto', 'm', NULL, NULL, NULL, NULL, NULL, NULL, 'admin', '2010-08-27 11:49:28', 1, 1)", "User", null);
if ($db->affected_rows() == 1) {
    echo "<p>INSERTED FAKE USER</p>";
Beispiel #8
0
 function addFollower($user)
 {
     require_once "query.php";
     $db = new DBManager();
     if (!$db->connect_errno()) {
         define_tables();
         defineFollowColumns();
         $table = Query::getDBSchema()->getTable(TABLE_FOLLOW);
         $db->execute($s = Query::generateInsertStm($table, array(FOLLOW_FOLLOWER => $user->getID(), FOLLOW_SUBJECT => $this->getID())), $table->getName(), $this);
         if ($db->affected_rows() != 1) {
             $db->display_error("User::addFollower()");
         }
         //Genera un errore ma ritorna comunque $this
     } else {
         $db->display_connect_error("User::addFollower()");
     }
     return $this->loadFollowers();
 }
Beispiel #9
0
 function delete()
 {
     require_once "query.php";
     $db = new DBManager();
     if (!$db->connect_errno()) {
         define_tables();
         defineVoteColumns();
         $table = Query::getDBSchema()->getTable(TABLE_VOTE);
         $rs = $db->execute($s = Query::generateDeleteStm($table, array(new WhereConstraint($table->getColumn(VOTE_AUTHOR), Operator::EQUAL, $this->getAuthor()), new WhereConstraint($table->getColumn(VOTE_POST), Operator::EQUAL, $this->getPost()))), $table->getName(), $this);
         //echo "<br />" . $s; //DEBUG
         if ($db->affected_rows() == 1) {
             return $this;
         } else {
             $db->display_error("Vote::delete()");
         }
     } else {
         $db->display_connect_error("Vote::delete()");
     }
     return false;
 }