public static function saveNav($nav) { $dbh = new CandyDB(); $nav = addslashes($nav); $decode = json_decode($nav); var_dump($decode); $dbh->exec("UPDATE " . DB_PREFIX . "options SET option_value='{$nav}' WHERE option_key='nav'"); }
public static function saveSettings() { $account = $_POST['disqus']; $limit = $_POST['perpage']; $dbh = new CandyDB(); $dbh->exec('UPDATE ' . DB_PREFIX . 'options SET option_value="' . $account . '" WHERE option_key="disqus"'); $dbh->exec('UPDATE ' . DB_PREFIX . 'options SET option_value="' . $limit . '" WHERE option_key="perpage"'); }
public static function setColors($array) { $insert = addslashes(json_encode($array)); $dbh = new CandyDB(); $dbh->exec("UPDATE " . DB_PREFIX . "options SET option_value='{$insert}' WHERE option_key='colors'"); }
public static function resetPassword($email) { $password = ""; $possible = "2346789bcdfghjkmnpqrtvwxyzBCDFGHJKLMNPQRTVWXYZ"; $maxlength = 10; $i = 0; while ($i < $maxlength) { $char = substr($possible, mt_rand(0, $maxlength - 1), 1); if (!strstr($password, $char)) { $password .= $char; $i++; } } $rand = sha1($password . SALT); $dbh = new CandyDB(); $dbh->exec("UPDATE " . DB_PREFIX . "users SET password='******' WHERE email='{$email}'"); mail($email, 'Your New CandyCMS Password', "Your new password is\n\n{$password}\n\nPlease change this after logging in."); }