/**
* 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;
}
