public static function updateFromPOST()
{
$conn = Database::getHandle();
$statement = $conn->prepare("UPDATE `" . TH_DB_PREFIX . "content` SET weight = ?, parent_id = ? WHERE content_id = ?");
$conn->beginTransaction();
$order = json_decode($_POST['order'], true);
foreach ($order as $id => $arr) {
$parent_id = $arr['parent_id'];
$weight = $arr['weight'];
if (!$statement->execute(array($weight, $parent_id, $id))) {
print_r(Database::getHandle()->errorInfo());
}
}
$conn->commit();
echo "ok";
exit;
}
function saveData()
{
$dbarray = array();
foreach (self::$mappings as $todb => $fromclassvar) {
$dbarray[$todb] = $this->{$fromclassvar};
}
if ($this->inited == 1) {
$a = Database::update('plugins', $dbarray, null, array('pid = ?', $this->id));
} else {
unset($dbarray['pid']);
// auto increment
$dbarray['padded_date'] = date('Y-m-d H:i:s');
$a = Database::insert('plugins', $dbarray);
if ($a == 1) {
$this->id = Database::getHandle()->lastInsertId();
}
}
return $a == 1 ? true : false;
}
public function __construct($action, $params)
{
$this->_db = Database::getHandle();
$this->_action = $action;
$this->_params = $params;
$this->_smarty = new Smarty();
$this->_smarty->template_dir = 'app/templates';
$this->_smarty->compile_dir = 'app/templates/compiled';
session_name('sess_gfuserdb');
session_start();
if (!$this->_db->_connectionID) {
$this->_handleDbFailure();
die;
}
if (isset($_SESSION['num_added']) && isset($_COOKIE['login']) && !empty($_COOKIE['login'])) {
$this->_addUserScore($_COOKIE['login'], $_SESSION['num_added']);
unset($_SESSION['num_added']);
}
}
if ($dbr->rowCount() != 1) {
Log::add('Database did not return a row');
Content::setContent($activationError);
} else {
$uid = $dbr->fetchColumn();
Log::add('Database returned a row. UID: ' . $uid);
unset($dbr);
if ($slug == 'activate') {
// ugh, annoying database class.
$dbh = Database::getHandle();
$dbr = $dbh->prepare('UPDATE users SET validate_key = NULL, status = 1 WHERE uid = ?');
if ($dbr->execute(array($uid))) {
Log::add('Account activation successful.');
Content::setContent(Message::success('Your account has been activated successfully!'));
} else {
Log::add('Activation error. Database says: ' . print_r(Database::getHandle()->errorInfo(), true));
Content::setContent(Message::error('An error occurred during account activation. Please contact an hRepo administrator.'));
}
} else {
// now I've got to delete their account...
if (Database::delete('users', array('uid = ?', $uid), 1)) {
Log::add('Account deletion successful.');
Content::setContent(Message::success('The account has been deleted successfully.'));
} else {
Log::add('Deletion error. Database says: ' . print_r(Database::getHandle()->errorInfo(), true));
Content::setContent(Message::error('An error occurred during account deletion. Please contact an hRepo administrator.'));
}
}
}
}
}
/**
* Stores a database handle from the static getHanle()
* method from the Database class
*/
public function __construct()
{
$this->db = Database::getHandle();
}
