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(); }
/** * Crea un tag. * @param string $tag * @return TRUE se il tag è stato creato, FALSE altrimenti. */ static function createTag($tag) { require_once "query.php"; $db = new DBManager(); if (!$db->connect_errno()) { define_tables(); defineTagColumns(); $table = Query::getDBSchema()->getTable(TABLE_TAG); $data = array(TAG_NAME => $tag); $db->execute($s = Query::generateInsertStm($table, $data), $table->getName(), $tag); if ($db->affected_rows() == 1) { return true; } else { return false; } } else { $db->display_connect_error("TagManager::createTag()"); } }
/** * @deprecated * Enter description here ... * @param unknown_type $type * @param unknown_type $id */ static function getAccessCount($type, $id) { if ($type == null || $type == "" || $id == null) { return 0; } $db = new DBManager(); if (!$db->connect_errno()) { define_tables(); defineLogColumns(); $table = Query::getDBSchema()->getTable("AccessLog"); $exists = false; if ($type == "Post") { require_once 'post/PostManager.php'; return 0; $exists = PostManager::postExists($id); } else { if ($type == "User") { require_once 'user/UserManager.php'; return 0; $exists = UserManager::userExists($id); } elseif ($type == "Partner") { //TODO: implementa Partner // require_once 'post/PartnerManager.php'; // $exists = PartnerManager::partnerExists($id); } } if ($exists) { $wheres = array(new WhereConstraint($table->getColumn("alog_type"), Operator::EQUAL, $type), new WhereConstraint($table->getColumn("alog_id"), Operator::EQUAL, $id)); $db->execute($s = Query::generateSelectStm(array($table), array(), $wheres, array())); if ($db->num_rows() == 1) { $row = $db->fetch_result(); $data = array("alog_count" => ++$row["alog_count"]); $db->execute($s = Query::generateUpdateStm($table, $data, $wheres), null, LOGMANAGER); if ($db->affected_rows() == 1) { return $row["alog_count"]; } } else { $data = array("alog_type" => $type, "alog_id" => $id); $db->execute($s = Query::generateInsertStm($table, $data)); if ($db->affected_rows() == 1) { } return 1; } } return 0; } }
function delete() { require_once "query.php"; $db = new DBManager(); if (!$db->connect_errno()) { define_tables(); defineUserColumns(); $table = Query::getDBSchema()->getTable(TABLE_USER); $rs = $db->execute($s = Query::generateDeleteStm($table, array(new WhereConstraint($table->getColumn(USER_ID), Operator::EQUAL, $this->getID()))), $table->getName(), $this); //echo "<br />" . serialize($db->affected_rows()) . $s; //DEBUG if ($db->affected_rows() == 1) { return $this; } else { $db->display_error("User::delete()"); } } else { $db->display_connect_error("User::delete()"); } return false; }
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>"; } $db->execute("INSERT INTO `MailDirectory` VALUES(1, '" . TRASH . "', 1)", "MailDirectory", null); $ra = $db->affected_rows(); $db->execute("INSERT INTO `MailDirectory` VALUES(2, '" . MAILBOX . "', 1)", "MailDirectory", null);
function save() { require_once "query.php"; $db = new DBManager(); if (!$db->connect_errno()) { define_tables(); defineMailColumns(); $table = Query::getDBSchema()->getTable(TABLE_MAIL); $data = array(); if (isset($this->subject) && !is_null($this->getSubject())) { $data[MAIL_SUBJECT] = $this->getSubject(); } if (isset($this->from) && !is_null($this->getFrom())) { $data[MAIL_FROM] = intval($this->getFrom()); } if (isset($this->to) && !is_null($this->getTo())) { $data[MAIL_TO] = $this->getTo(); } if (isset($this->text) && !is_null($this->getText())) { $data[MAIL_TEXT] = $this->getText(); } if (isset($this->repliesTo) && !is_null($this->getRepliesTo())) { $data[MAIL_REPLIES_TO] = intval($this->getRepliesTo()); } $rs = $db->execute($s = Query::generateInsertStm($table, $data), $table->getName(), $this); //echo "<br />" . $s; //DEBUG //echo "<br />" . $db->affected_rows(); //DEBUG if ($db->affected_rows() == 1) { $this->setID(intval($db->last_inserted_id())); //echo "<br />" . serialize($this->ID); //DEBUG $rs = $db->execute($s = Query::generateSelectStm(array($table), array(), array(new WhereConstraint($table->getColumn(MAIL_ID), Operator::EQUAL, $this->getID())), array()), $table->getName(), $this); //echo "<br />" . $s; //DEBUG if ($db->num_rows() == 1) { $row = $db->fetch_result(); $this->setCreationDate(date_timestamp_get(date_create_from_format("Y-m-d G:i:s", $row[MAIL_CREATION_DATE]))); //echo "<br />" . serialize($row[MAIL_CREATION_DATE]); //DEBUG //inserisce il messaggio nelle mailbox dei $to $toes = explode("|", $this->getTo()); //echo serialize($toes); //DEBUG require_once "mail/MailManager.php"; for ($i = 0; $i < count($toes); $i++) { $dir = MailManager::loadDirectoryFromName(MAILBOX, intval($toes[$i])); MailManager::addMailToDir($this, $dir); } //echo "<br />" . $this; //DEBUG return $this; } else { $db->display_error("Mail::save()"); } } else { $db->display_error("Mail::save()"); } } else { $db->display_connect_error("Mail::save()"); } return false; }
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(); }
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; }