/** * Install module * -------------- * Create the `users` table */ public function install() { if (DB::getOption("admin_installed") == null && \Lobby::$installed) { /** * Install Module */ $salt = \Helper::randStr(15); $cookie = \Helper::randStr(15); DB::saveOption("admin_secure_salt", $salt); DB::saveOption("admin_secure_cookie", $cookie); $prefix = DB::getPrefix(); /** * Create `users` TABLE */ $sql = DB::getDBH()->prepare("CREATE TABLE IF NOT EXISTS `{$prefix}users` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `username` varchar(10) NOT NULL,\n `password` varchar(255) NOT NULL,\n `name` varchar(30) NOT NULL,\n `created` datetime NOT NULL,\n `attempt` varchar(15) NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`)\n ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;"); if ($sql->execute() != 0) { DB::saveOption("admin_installed", "true"); } } }
<?php class logSysLobbyDB { public function prepare($query) { $obj = \Lobby\DB::getDBH()->prepare($query); return $obj; } } require_once __DIR__ . "/class.logsys.php"; $salt = Lobby\DB::getOption("admin_secure_salt"); $cookie = Lobby\DB::getOption("admin_secure_cookie"); \Fr\LS::config(array("db" => array("table" => \Lobby\DB::getPrefix() . "users"), "features" => array("auto_init" => false, "start_session" => false, "email_login" => false), "keys" => array("cookie" => $cookie, "salt" => $salt)));
public function clearData() { $sql = \Lobby\DB::getDBH()->prepare("DELETE FROM `" . \Lobby\DB::getPrefix() . "data` WHERE `app` = ?"); $sql->execute(array($this->app)); return true; }