public static function isSaved($addon, $save = true) { $sql = new sql(); $num = $sql->num('SELECT 1 FROM ' . sql::table('addons') . ' WHERE `name` = "' . $addon . '"'); if (!$num && $save) { $save = new sql(); $save->setTable('addons'); $save->addPost('name', $addon); $save->save(); } return $num; }
<?php } else { if (isset($_POST['sendNew'])) { $new = new sql(); $new->setTable('user'); $admin = isset($_POST['admin']) ? 1 : 0; $salt = userLogin::generateSalt(); $new->addPost('salt', $salt); $new->addPost('firstname', type::post('firstname')); $new->addPost('name', type::post('name')); $new->addPost('email', type::post('email')); $new->addPost('admin', $admin); $new->addPost('username', type::post('username')); $new->addPost('password', userLogin::hash(type::post('password'), $salt)); $new->save(); echo message::success(lang::get('user_added')); } if (isset($_POST['delete'])) { $ids = type::post('ids'); if (is_array($ids) && count($ids) >= 1) { if (in_array(rp::get('user')->get('id'), $ids)) { echo message::danger(lang::get('user_delete_own')); } else { foreach ($ids as $var) { $sql = new sql(); $sql->setTable('user'); $sql->setWhere("id=" . $var); $sql->delete(); } echo message::success(lang::get('user_deleted'));
public static function newInstall() { $sql = new sql(); $sql->query('DROP TABLE `' . sql::table('module') . '`'); $sql->query('CREATE TABLE `' . sql::table("module") . '` ( `id` int(16) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL, `input` text NOT NULL, `output` text NOT NULL, `sort` int(16) unsigned NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;'); $sql->query('DROP TABLE `' . sql::table('structure') . '`'); $sql->query('CREATE TABLE `' . sql::table("structure") . '` ( `id` int(16) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL, `template` varchar(255) NOT NULL, `sort` int(16) unsigned NOT NULL, `parent_id` int(16) unsigned NOT NULL, `online` int(1) unsigned NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;'); $sql->query('DROP TABLE `' . sql::table('user') . '`'); $sql->query('CREATE TABLE `' . sql::table("user") . '` ( `id` int(11) unsigned NOT NULL auto_increment, `firstname` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `perms` varchar(255) NOT NULL, `admin` int(1) unsigned NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;'); $sql->setTable('user'); $sql->addPost('firstname', type::post('firstname')); $sql->addPost('name', type::post('name')); $sql->addPost('email', type::post('email')); $sql->addPost('password', userLogin::hash(type::post('password'))); $sql->addPost('admin', 1); $sql->save(); $sql->query('DROP TABLE `' . sql::table('structure_area') . '`'); $sql->query('CREATE TABLE `' . sql::table("structure_area") . '` ( `id` int(16) unsigned NOT NULL auto_increment, `structure_id`int(16) unsigned NOT NULL, `sort` int(16) unsigned NOT NULL, `modul` int(16) unsigned NOT NULL, `online` int(1) unsigned NOT NULL, `value1` text NOT NULL, `value2` text NOT NULL, `value3` text NOT NULL, `value4` text NOT NULL, `value5` text NOT NULL, `value6` text NOT NULL, `value7` text NOT NULL, `value8` text NOT NULL, `value9` text NOT NULL, `value10` text NOT NULL, `value11` text NOT NULL, `value12` text NOT NULL, `value13` text NOT NULL, `value14` text NOT NULL, `value15` text NOT NULL, `link1` int(11) NOT NULL, `link2` int(11) NOT NULL, `link3` int(11) NOT NULL, `link4` int(11) NOT NULL, `link5` int(11) NOT NULL, `link6` int(11) NOT NULL, `link7` int(11) NOT NULL, `link8` int(11) NOT NULL, `link9` int(11) NOT NULL, `link10` int(11) NOT NULL, `linklist1` varchar(255) NOT NULL, `linklist2` varchar(255) NOT NULL, `linklist3` varchar(255) NOT NULL, `linklist4` varchar(255) NOT NULL, `linklist5` varchar(255) NOT NULL, `linklist6` varchar(255) NOT NULL, `linklist7` varchar(255) NOT NULL, `linklist8` varchar(255) NOT NULL, `linklist9` varchar(255) NOT NULL, `linklist10` varchar(255) NOT NULL, `php1` text NOT NULL, `php2` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;'); $sql->query('DROP TABLE `' . sql::table('addons') . '`'); $sql->query('CREATE TABLE `' . sql::table("addons") . '` ( `id` int(11) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL, `active` int(1) NOT NULL, `install` int(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;'); $sql->query('DROP TABLE `' . sql::table('slots') . '`'); $sql->query('CREATE TABLE `' . sql::table("slots") . '` ( `id` int(11) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL, `description` varchar(255) NOT NULL, `template` varchar(255) NOT NULL, `modul` int(11) unsigned NOT NULL, `is-structure`int(1) unsigned NOT NULL DEFAULT "1", `structure` varchar(255) NOT NULL, `value1` text NOT NULL, `value2` text NOT NULL, `value3` text NOT NULL, `value4` text NOT NULL, `value5` text NOT NULL, `value6` text NOT NULL, `value7` text NOT NULL, `value8` text NOT NULL, `value9` text NOT NULL, `value10` text NOT NULL, `value11` text NOT NULL, `value12` text NOT NULL, `value13` text NOT NULL, `value14` text NOT NULL, `value15` text NOT NULL, `link1` int(11) NOT NULL, `link2` int(11) NOT NULL, `link3` int(11) NOT NULL, `link4` int(11) NOT NULL, `link5` int(11) NOT NULL, `link6` int(11) NOT NULL, `link7` int(11) NOT NULL, `link8` int(11) NOT NULL, `link9` int(11) NOT NULL, `link10` int(11) NOT NULL, `linklist1` varchar(255) NOT NULL, `linklist2` varchar(255) NOT NULL, `linklist3` varchar(255) NOT NULL, `linklist4` varchar(255) NOT NULL, `linklist5` varchar(255) NOT NULL, `linklist6` varchar(255) NOT NULL, `linklist7` varchar(255) NOT NULL, `linklist8` varchar(255) NOT NULL, `linklist9` varchar(255) NOT NULL, `linklist10` varchar(255) NOT NULL, `php1` text NOT NULL, `php2` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;'); }
<?php if (isset($_POST['check'])) { $DB = rp::get('DB'); sql::connect($DB['host'], $DB['user'], $DB['password'], $DB['database']); unset($DB); $sql = new sql(); $salt = userLogin::generateSalt(); $sql->setTable('user'); $sql->addPost('firstname', type::post('firstname')); $sql->addPost('name', type::post('name')); $sql->addPost('username', type::post('username')); $sql->addPost('email', type::post('email')); $sql->addPost('password', userLogin::hash(type::post('password'), $salt)); $sql->addPost('salt', $salt); $sql->addPost('admin', 1); $sql->save(); rp::add('setup', false, true); rp::save(); header('Location: ?page=finish'); exit; } ?> <div class="input row"> <label class="col-sm-4"><?php echo lang::get('firstname'); ?> </label> <div class="col-sm-8"> <input type="text" name="firstname" value="<?php echo type::post('firstname');
$auth = $_POST['auth']; $authKey = ""; if ($auth != $authKey) { header("HTTP/1.1 403 Forbidden"); die(json_encode(array('code' => 'error', 'comment' => 'auth failed with authkey: ' . $auth))); } $db = new sql('host', 'db', 'table', 'user', 'password'); switch ($function) { case 'listall': echo $db->listall(); break; case 'save': if ($db->exists($itemName)) { echo $db->update($itemName, $itemCount); } else { echo $db->save($itemName, $itemCount); } break; case 'update': echo $db->update($itemName, $itemCount); break; case 'delete': echo $db->delete($itemName); break; case 'clear': echo $db->clear(); break; default: die(json_encode(array('code' => 'error', 'comment' => 'function not specified'))); } ?>