示例#1
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);
 }
示例#2
0
 function loadFollows()
 {
     require_once "query.php";
     $db = new DBManager();
     if (!$db->connect_errno()) {
         define_tables();
         defineFollowColumns();
         $table = Query::getDBSchema()->getTable(TABLE_FOLLOW);
         $db->execute($s = Query::generateSelectStm(array($table), array(), array(new WhereConstraint($table->getColumn(FOLLOW_FOLLOWER), Operator::EQUAL, $this->getID())), array()));
         if ($db->num_rows() > 0) {
             $fols = array();
             while ($row = $db->fetch_result()) {
                 define_tables();
                 defineFollowColumns();
                 $f = self::loadFromDatabase(intval($row[FOLLOW_SUBJECT]), false);
                 if ($f !== false) {
                     $fols[$f->getID()] = $f;
                 }
             }
             return $this->setFollows($fols);
         } else {
             if ($db->errno()) {
                 $db->display_error("User::loadFollows()");
             }
         }
     } else {
         $db->display_connect_error("User::loadFollows()");
     }
     return $this->setFollows(array());
 }
示例#3
0
文件: Mail.php 项目: Esisto/IoEsisto
 function loadMails()
 {
     require_once "query.php";
     $db = new DBManager();
     if (!$db->connect_errno()) {
         define_tables();
         defineMailColumns();
         defineMailInDirColumns();
         $table = Query::getDBSchema()->getTable(TABLE_MAIL_IN_DIRECTORY);
         $table1 = Query::getDBSchema()->getTable(TABLE_MAIL);
         //echo "<p>" . $table . "</p>"; //DEBUG
         $rs = $db->execute($s = Query::generateSelectStm(array($table, $table1), array(new JoinConstraint($table->getColumn(MAIL_IN_DIRECTORY_MAIL), $table1->getColumn(MAIL_ID))), array(new WhereConstraint($table->getColumn(MAIL_IN_DIRECTORY_DIRECTORY), Operator::EQUAL, $this->getID())), array()), $table->getName(), $this);
         //echo "<p>" . $s . "</p>"; //DEBUG
         //echo "<p>" . $db->num_rows() . "</p>"; //DEBUG
         $mails = array();
         if ($rs !== false && $db->num_rows() > 0) {
             while ($row = $db->fetch_result()) {
                 $m = new Mail(array("from" => $row[MAIL_FROM], "to" => $row[MAIL_TO], "text" => $row[MAIL_TEXT], "subject" => $row[MAIL_SUBJECT], "repliesTo" => $row[MAIL_REPLIES_TO]));
                 $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>" . serialize($q->hasNext()) ."</p>";
                 //echo count($mails) . "-" . $db->num_rows() . "/"; //DEBUG
             }
             //TODO salvare il read status
             if ($db->num_rows() == count($mails)) {
                 return $this->setMails($mails);
             } else {
                 $db->display_error("MailDirectory::loadMails()");
             }
         } else {
             if ($db->errno()) {
                 $db->display_error("MailDirectory::loadMails()");
             }
         }
     } else {
         $db->display_connect_error("MailDirectory::loadMails()");
     }
     return false;
 }
示例#4
0
文件: Post.php 项目: Esisto/IoEsisto
 /**
  * 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;
 }
示例#5
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;
 }