static function register()
{
if (!LoginManager::isRegistered()) {
$login = sqlite_escape_string(LoginManager::getLogin());
$email = sqlite_escape_string(LoginManager::getEmail());
DatabaseManager::setQuery("INSERT INTO users VALUES(\n '{$login}',\n '',\n '{$email}',\n 0\n );");
}
}
function execute()
{
$this->content = '
<h1>' . _('Logout') . '</h1>';
if (LoginManager::isLogged()) {
$this->content .= '
<p>' . sprintf(_('Logout from \'%s\' success.'), LoginManager::getLogin()) . '</p>';
} else {
$this->content .= '
<p>' . _('You are not logged.') . '</p>';
}
$this->content .= '
<p><a href="' . RessourceManager::getInnerUrl('index') . '">' . _('Return to index') . '</a></p>';
LoginManager::logout();
}
function displayContent()
{
$content = '';
$content .= '
<h2>' . _('Current propositions') . '</h2>';
$user = LoginManager::getLogin();
$results = DatabaseManager::getQuery("SELECT * FROM proposed_exercises WHERE (state='waiting' OR state='processing')");
while ($result = $results->fetchArray()) {
$content .= '<div class="subblock" ><ul>';
$content .= '<li>' . _('Name: ') . $result['name'] . '</li>';
$content .= '<li>' . _('Description: ') . $result['description'] . '</li>';
$content .= '<li>' . _('Links: ') . $result['links'] . '</li>';
$content .= '<li>' . _('Proposer: ') . $result['user'] . '</li>';
$state = $result['state'];
$stateStr = _('Unknown state');
if ($state == 'waiting') {
$stateStr = _('Waiting for processing');
} elseif ($state == 'processing') {
$stateStr = _('Processing');
} elseif ($state == 'accepted') {
$stateStr = _('Accepted');
}
$content .= '<li>' . _('State: ') . $stateStr . '</li>';
$content .= '</ul></div>';
}
$content .= '
<h2>' . _('Old propositions') . '</h2>';
$results = DatabaseManager::getQuery("SELECT * FROM proposed_exercises WHERE not (state='waiting' OR state='processing')");
while ($result = $results->fetchArray()) {
$content .= '<div class="subblock" ><ul>';
$content .= '<li>' . _('Name: ') . $result['name'] . '</li>';
$content .= '<li>' . _('Description: ') . $result['description'] . '</li>';
$content .= '<li>' . _('Links: ') . $result['links'] . '</li>';
$content .= '<li>' . _('Proposer: ') . $result['user'] . '</li>';
$state = $result['state'];
$stateStr = _('Unknown state');
if ($state == 'waiting') {
$stateStr = _('Waiting for processing');
} elseif ($state == 'processing') {
$stateStr = _('Processing');
} elseif ($state == 'accepted') {
$stateStr = _('Accepted');
}
$content .= '<li>' . _('State: ') . $stateStr . '</li>';
$content .= '</ul></div>';
}
return $content;
}
function execute()
{
if (isset($_POST['propose_name']) && $_SESSION['form_enabled']) {
LoginManager::register();
$name = sqlite_escape_string($_POST['propose_name']);
$description = sqlite_escape_string($_POST['propose_description']);
$links = sqlite_escape_string($_POST['propose_links']);
$user = sqlite_escape_string(LoginManager::getLogin());
$state = 'waiting';
DatabaseManager::setQuery("INSERT INTO proposed_exercises VALUES(\n NULL,\n '{$name}',\n '{$description}',\n '{$links}',\n '{$user}',\n '{$state}',\n '',\n '',\n NULL,\n NULL,\n NULL,\n NULL,\n NULL,\n NULL,\n NULL,\n NULL,\n NULL,\n NULL,\n NULL,\n NULL\n );");
$this->message = "Exercise proposed.";
$_SESSION['form_enabled'] = false;
} else {
$_SESSION['form_enabled'] = true;
}
}
