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()");
}
}
/**
* 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;
}
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);
}
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;
}
/**
* 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;
}
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;
}
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();
}
/**
* Crea un voto caricando i dati dal database.
* È come fare una ricerca sul database e poi fare new Vote().
*
* @param $id: l'ID del voto da caricare.
* @return: il voto caricato o FALSE se non lo trova.
*/
static function loadFromDatabase($author, $post)
{
require_once "query.php";
$db = new DBManager();
if (!$db->connect_errno()) {
require_once 'strings/strings.php';
define_tables();
defineVoteColumns();
$table = Query::getDBSchema()->getTable(TABLE_VOTE);
$rs = $db->execute($s = Query::generateSelectStm(array($table), array(), array(new WhereConstraint($table->getColumn(VOTE_AUTHOR), Operator::EQUAL, $author), new WhereConstraint($table->getColumn(VOTE_POST), Operator::EQUAL, $post)), array()), $table->getName(), null);
if ($db->num_rows() == 1) {
$row = $db->fetch_result();
$v = new Vote(intval($row[VOTE_AUTHOR]), intval($row[VOTE_POST]), $row[VOTE_VOTE] > 0);
$v->setCreationDate(date_timestamp_get(date_create_from_format("Y-m-d G:i:s", $row[VOTE_CREATION_DATE])));
return $v;
}
//else $db->display_error("Vote::loadFromDatabase()");
} else {
$db->display_connect_error("Vote::LoadFromDatabase()");
}
return false;
}
