/**
* @param int $group_id
* @param int $user_id
* @param int $leader
* @param int $pending
* @return bool
*/
public static function add($group_id, $user_id, $leader = 0, $pending = 0) {
$sql = 'INSERT INTO ' . self::getFullTableName() . ' (
group_id,
user_id,
group_leader,
user_pending
) VALUES (
:g_id,
:u_id,
:g_leader,
:pending
)';
$result = SQL::execute(self::getConnection(), $sql, array("g_id" => $group_id, "u_id" => $user_id, "g_leader" => $leader, "pending" => $pending));
if($result !== false) {
// Include libs
require_once(LIB_DIR . DS . 'class.phpbb_account.php');
// Empty permission for creating new
phpbb_account::clearUserPerms($user_id);
// Send PM new Group
if(SEND_PM_GROUPCHANGE)
get_phpbb_info::$instance->sendPM(output::newGroupPM($user_id, phpbb_groups::getGroupName($group_id)), SYSTEM_USER, "Willkommen in der Benutzergruppe " . phpbb_groups::getGroupName($group_id), $user_id);
return true;
}
return false;
}
public function createUser($vars)
{
$db = getDB();
$pw = $this->getRandomPW();
$query = "INSERT INTO user (userUID, userPassword, userEmail, userVorname, userNachname) VALUES (:uUID, PASSWORD(:uPassword), :uEmail, :uVorname, :uNachname);";
$db->prepSQL($query);
$db->sendSQL(array("uUID" => $vars["UID"], "uPassword" => $pw, "uEmail" => $vars["email"], "uVorname" => $vars["Vorname"], "uNachname" => $vars["Nachname"]));
$header = "From: QITS GmbH <*****@*****.**>\r\n";
$newID = $db->lastid();
if ($newID) {
mail($vars["email"], "Ihre Zugangsdaten zum Administrationsportal fuer atWork Kunden", "Hallo " . $vars["Vorname"] . " " . $vars["Nachname"] . ",\n Ihre Zugangsdaten für das Administrationsportal lauten:\n\n\t\t\tBenutzername: " . $vars["UID"] . "\n\t\t\tPasswort: " . $pw . "\n\t\t\t\nBitte beachten Sie, dass nur Sie dieses Passwort kennen und benötigen. Kein Mitarbeiter von WeightWatchers oder der QITS GmbH wird Sie je nach diesem Kennwort fragen. Geben Sie es unter keinen Umständern weiter.\nWeitere Informationen zum Ablauf erhalten Sie von Ihrem Projektleiter.", $header);
output::addNewContentMessage(array("EmailSenden" => "OK"));
if ($newID == 0) {
errorExit(new specificExceptions("DB Write Error", ERR_SAVE_ERROR));
} else {
$this->rolle2user = new rolle2user();
$this->rolle2user->__set("userID", $newID);
$this->rolle2user->__set("rolleID", "1");
$dbSaveId2 = $this->rolle2user->save();
if ($dbSaveId2 = 0) {
errorExit(new specificExceptions("DB Write Error", ERR_SAVE_ERROR));
} else {
output::addNewContentMessage(array("Berechtigung" => "OK"));
}
}
}
}
public function write_data($sqlite3)
{
/**
* Write data to database table "fqdns".
*/
if ($this->fqdn !== '') {
if (($fid = $sqlite3->querySingle('SELECT fid FROM fqdns WHERE fqdn = \'' . $this->fqdn . '\'')) === false) {
output::output('critical', basename(__FILE__) . ':' . __LINE__ . ', sqlite3 says: ' . $sqlite3->lastErrorMsg());
}
if (is_null($fid)) {
$sqlite3->exec('INSERT INTO fqdns (fid, fqdn, tld) VALUES (NULL, \'' . $this->fqdn . '\', \'' . $this->tld . '\')') or output::output('critical', basename(__FILE__) . ':' . __LINE__ . ', sqlite3 says: ' . $sqlite3->lastErrorMsg());
$fid = $sqlite3->lastInsertRowID();
}
}
/**
* Write data to database tables "urls" and "uid_urls".
*/
if (($lid = $sqlite3->querySingle('SELECT lid FROM urls WHERE url = \'' . $sqlite3->escapeString($this->url) . '\'')) === false) {
output::output('critical', basename(__FILE__) . ':' . __LINE__ . ', sqlite3 says: ' . $sqlite3->lastErrorMsg());
}
if (is_null($lid)) {
$sqlite3->exec('INSERT INTO urls (lid, url' . ($this->fqdn !== '' ? ', fid' : '') . ') VALUES (NULL, \'' . $sqlite3->escapeString($this->url) . '\'' . ($this->fqdn !== '' ? ', ' . $fid : '') . ')') or output::output('critical', basename(__FILE__) . ':' . __LINE__ . ', sqlite3 says: ' . $sqlite3->lastErrorMsg());
$lid = $sqlite3->lastInsertRowID();
}
foreach ($this->uses as $key => $values) {
$sqlite3->exec('INSERT INTO uid_urls (uid, lid, datetime) VALUES ((SELECT uid FROM uid_details WHERE csnick = \'' . $values[1] . '\'), ' . $lid . ', DATETIME(\'' . $values[0] . '\'))') or output::output('critical', basename(__FILE__) . ':' . __LINE__ . ', sqlite3 says: ' . $sqlite3->lastErrorMsg());
}
}
public function write_data($sqlite3)
{
/**
* Write data to database table "words".
*/
$sqlite3->exec('INSERT OR IGNORE INTO words (word, length, total) VALUES (\'' . $sqlite3->escapeString($this->word) . '\', ' . $this->length . ', ' . $this->total . ')') or output::output('critical', basename(__FILE__) . ':' . __LINE__ . ', sqlite3 says: ' . $sqlite3->lastErrorMsg());
$sqlite3->exec('UPDATE words SET total = total + ' . $this->total . ' WHERE CHANGES() = 0 AND word = \'' . $sqlite3->escapeString($this->word) . '\'') or output::output('critical', basename(__FILE__) . ':' . __LINE__ . ', sqlite3 says: ' . $sqlite3->lastErrorMsg());
}
/**
* Write data to database tables "topics" and "uid_topics".
*/
public function write_data($sqlite3)
{
if (($tid = $sqlite3->querySingle('SELECT tid FROM topics WHERE topic = \'' . $sqlite3->escapeString($this->topic) . '\'')) === false) {
output::output('critical', basename(__FILE__) . ':' . __LINE__ . ', sqlite3 says: ' . $sqlite3->lastErrorMsg());
}
if (is_null($tid)) {
$sqlite3->exec('INSERT INTO topics (tid, topic) VALUES (NULL, \'' . $sqlite3->escapeString($this->topic) . '\')') or output::output('critical', basename(__FILE__) . ':' . __LINE__ . ', sqlite3 says: ' . $sqlite3->lastErrorMsg());
$tid = $sqlite3->lastInsertRowID();
}
foreach ($this->uses as $key => $values) {
$sqlite3->exec('INSERT INTO uid_topics (uid, tid, datetime) VALUES ((SELECT uid FROM uid_details WHERE csnick = \'' . $values[1] . '\'), ' . $tid . ', DATETIME(\'' . $values[0] . '\'))') or output::output('critical', basename(__FILE__) . ':' . __LINE__ . ', sqlite3 says: ' . $sqlite3->lastErrorMsg());
}
}
/**
* @return string
*/
function getfunctionOutput() {
if(get_phpbb_info::$instance->user_id && mb_strtolower(get_phpbb_info::$instance->username) != 'anonymous') { //todo check server before doing this implement
// Escape Userdata
$_GET = output::escapeALL($_GET);
$_POST = output::escapeALL($_POST);
$_COOKIE = output::escapeALL($_COOKIE);
$_SERVER = output::escapeALL($_SERVER);
//Set URL
$roa_url = "?mod=" . MOD;
switch(MOD) {
case 'control':
//todo
case 'wow_account_info':
// Include Mainfunctions
require_once(ROA_MAINCLASSDIR . DS . 'class.account.php');
// Include Lib
require_once(LIB_DIR . DS . 'class.auth_account.php');
return output::HTMLTemplate("World of Warcraft-Account Status", output::accountInfo());
case 'points_history':
// Include LIB
require_once(LIB_DIR . DS . 'class.user_points.php');
require_once(LIB_DIR . DS . 'class.point_costs.php');
return output::HTMLTemplate("Punkte Log", output::point_management());
case 'points_management':
// Include LIB
require_once(LIB_DIR . DS . 'class.auth_account.php');
require_once(LIB_DIR . DS . 'class.user_points.php');
require_once(LIB_DIR . DS . 'class.point_costs.php');
require_once(LIB_DIR . DS . 'class.code_functions.php');
require_once(LIB_DIR . DS . 'class.points_exchange.php');
return output::HTMLTemplate("Punkte verwalten", output::exchange_points());
}
}
// No-Login req
switch(MOD) {
case 'impressum':
return output::HTMLTemplate("Impressum", output::implementImpressum());
default:
// Default Value
return output::HTMLTemplate("Info", "Unbekannter Modus oder logge dich ein!");
}
}
public static function run(Event $event)
{
$args = $event->getArguments();
define('BASEPATH', 'foobar');
/* for old school file protector */
define('ROOTPATH', realpath('.'));
define('ENVIRONMENT', $_SERVER['SERVER_ENVIRONMENT']);
define('DEBUG', $_SERVER['SERVER_DEBUG']);
require __DIR__ . '/includes/compat.php';
require __DIR__ . '/includes/functions.php';
require __DIR__ . '/includes/output.php';
$output = new \output(true);
$func = new \func();
$methods = get_class_methods($func);
if (!isset($args[0])) {
$methods[] = 'cli +{any codeigniter cli command}';
sort($methods);
$actions = '';
foreach ($methods as $m) {
if ($m[0] != '_') {
$actions .= str_replace('_', ' ', $m) . chr(10);
}
}
$output->e('<blue>Please provide action:<off>' . chr(10) . trim($actions), true);
}
if ($args[0] == 'cli') {
/* shift off cli */
array_shift($args);
/* call codeigniter cli script passthru */
passthru('cd ' . ROOTPATH . '/public;php index.php ' . implode(' ', $args));
exit(0);
}
/* is the command there? */
$command = implode('_', $args);
if (!in_array($command, $methods)) {
$output->e('<red>Unknown Command: ' . $command, true);
}
/* load setup json */
$setup_file = __DIR__ . '/setup.json';
$output->e('<yellow>Setup File ' . $setup_file);
if (!file_exists($setup_file)) {
$output->e('<red>Setup File Missing?', true);
}
$setup = json_decode(file_get_contents($setup_file), true);
/* start the party */
$output->e('<green>Start ' . $args[0]);
$func->_process($command, $setup, $output);
$output->e('<green>Finished');
}
/**
* Parse a line for various chat data.
*/
protected function parse_line($line)
{
/**
* "Normal" lines.
*/
if (preg_match('/^\\[(?<time>\\d{2}:\\d{2}(:\\d{2})?)\\] (?<nick>\\S+): (?<line>.+)$/', $line, $matches)) {
$this->set_normal($matches['time'], $matches['nick'], $matches['line']);
/**
* "Join" lines.
*/
} elseif (preg_match('/^\\[(?<time>\\d{2}:\\d{2}(:\\d{2})?)\\] (?<nick>\\S+) has joined the channel$/', $line, $matches)) {
$this->set_join($matches['time'], $matches['nick']);
/**
* "Part" lines.
*/
} elseif (preg_match('/^\\[(?<time>\\d{2}:\\d{2}(:\\d{2})?)\\] (?<nick>\\S+) has left the channel$/', $line, $matches)) {
$this->set_part($matches['time'], $matches['nick']);
/**
* Skip everything else.
*/
} elseif ($line !== '') {
output::output('debug', __METHOD__ . '(): skipping line ' . $this->linenum . ': \'' . $line . '\'');
}
}
/**
* Set the amount of bits corresponding to the type(s) of output messages
* displayed. By default all but debug messages will be displayed. This can be
* changed in the configuration file.
* 0 Critical events (will always display)
* 1 Notices
* 2 Debug messages
*/
public static function set_outputbits($outputbits)
{
self::$outputbits = $outputbits;
}
public function DoOutput($include_menu = true, $include_header = true)
{
$this->PushOutput('</table></td></tr></table>');
parent::DoOutput();
}
private function make_table_people_timeofday($sqlite3)
{
/**
* Only create the table if there is activity from users other than bots and
* excluded users.
*/
if (($total = $sqlite3->querySingle('SELECT SUM(l_total) FROM ruid_lines JOIN uid_details ON ruid_lines.ruid = uid_details.uid WHERE status NOT IN (3,4)')) === false) {
output::output('critical', basename(__FILE__) . ':' . __LINE__ . ', sqlite3 says: ' . $sqlite3->lastErrorMsg());
}
if (empty($total)) {
return null;
}
$high_value = 0;
$times = ['night', 'morning', 'afternoon', 'evening'];
foreach ($times as $time) {
$query = $sqlite3->query('SELECT csnick, l_' . $time . ' FROM ruid_lines JOIN uid_details ON ruid_lines.ruid = uid_details.uid WHERE status NOT IN (3,4) AND l_' . $time . ' != 0 ORDER BY l_' . $time . ' DESC, ruid_lines.ruid ASC LIMIT ' . $this->maxrows_people_timeofday) or output::output('critical', basename(__FILE__) . ':' . __LINE__ . ', sqlite3 says: ' . $sqlite3->lastErrorMsg());
$i = 0;
while ($result = $query->fetchArray(SQLITE3_ASSOC)) {
$i++;
${$time}[$i]['lines'] = $result['l_' . $time];
${$time}[$i]['user'] = $result['csnick'];
if (${$time}[$i]['lines'] > $high_value) {
$high_value = ${$time}[$i]['lines'];
}
}
}
$tr0 = '<colgroup><col class="pos"><col class="c"><col class="c"><col class="c"><col class="c">';
$tr1 = '<tr><th colspan="5">Most Talkative People by Time of Day';
$tr2 = '<tr><td class="pos"><td class="k">Night<br>0h - 5h<td class="k">Morning<br>6h - 11h<td class="k">Afternoon<br>12h - 17h<td class="k">Evening<br>18h - 23h';
$trx = '';
for ($i = 1; $i <= $this->maxrows_people_timeofday; $i++) {
if (!isset($night[$i]['lines']) && !isset($morning[$i]['lines']) && !isset($afternoon[$i]['lines']) && !isset($evening[$i]['lines'])) {
break;
}
$trx .= '<tr><td class="pos">' . $i;
foreach ($times as $time) {
if (!isset(${$time}[$i]['lines'])) {
$trx .= '<td class="v">';
} else {
$width = round(${$time}[$i]['lines'] / $high_value * 190);
if ($width !== (double) 0) {
$trx .= '<td class="v">' . htmlspecialchars(${$time}[$i]['user']) . ' - ' . number_format(${$time}[$i]['lines']) . '<br><div class="' . $this->color[$time] . '" style="width:' . $width . 'px"></div>';
} else {
$trx .= '<td class="v">' . htmlspecialchars(${$time}[$i]['user']) . ' - ' . number_format(${$time}[$i]['lines']);
}
}
}
}
return '<table class="ppl-tod">' . $tr0 . $tr1 . $tr2 . $trx . '</table>' . "\n";
}
public function DoOutput($include_menu = true, $include_header = true)
{
parent::DoOutput();
}
/**
* Génère la page
* @param boolean,array $include_menu Inclure le menu ? (voir son propre menu)
* @param boolean $include_header Inclure l'entete ?
*/
public function DoOutput($include_menu = true, $include_header = true)
{
$out = <<<ROW
</td>
</tr>
</table>
<SCRIPT type="text/javascript">
masquer("COOROUT",0);
afficher("USER",0);
afficher("EMPIRE",0);
afficher("INFOS",0);
masquer("AddTabRessource",0);
</SCRIPT></body></html>
ROW;
$this->PushOutput($out);
parent::DoOutput($include_menu, $include_header);
}
$warn = $lng['data_error'];
}
} else {
$cleandata = $ownuniverse->get_universe($player);
}
$IsEnabled = $cleandata && is_array($cleandata[0]);
require_once TEMPLATE_PATH . 'ownuniverse.tpl.php';
$tpl = tpl_ownuniverse::getinstance();
$tpl->page_title = $lng['page_title'];
output::Messager($info);
output::Messager('<font color="red">' . $warn . '</font>');
if (!$IsEnabled && !$include_form) {
output::Messager($lng['data_empty']);
}
if (!$IsEnabled && $include_form) {
output::Messager($lng['start_info']);
}
$tpl->Setheader($include_form);
/**
Array (
Name => "MaPlanète"
Coord => xxxx-xx-xx-xx
* => Ressources prod/h
current_* => Ressources dispo
bunker_* => Ressources dans le bunker
total_* => current_* + bunker_*
sell_* => Ressources vendu/j
percent_* => Ratio d'exploitation des ressources
)
"*" => Nom de ressource
**/
/**
* Read the settings from the configuration file and put them into $settings[]
* so they can be passed along to other classes.
*/
private function read_config($file)
{
if (($rp = realpath($file)) === false) {
output::output('critical', __METHOD__ . '(): no such file: \'' . $file . '\'');
}
if (($fp = fopen($rp, 'rb')) === false) {
output::output('critical', __METHOD__ . '(): failed to open file: \'' . $rp . '\'');
}
while (!feof($fp)) {
$line = trim(fgets($fp));
if (preg_match('/^\\s*(?<setting>\\w+)\\s*=\\s*"\\s*(?<value>([^\\s"]+(\\s+[^\\s"]+)*))\\s*"/', $line, $matches)) {
$this->settings[$matches['setting']] = $matches['value'];
}
}
fclose($fp);
/**
* Exit if any crucial setting is missing.
*/
foreach ($this->settings_list_required as $key) {
if (!array_key_exists($key, $this->settings)) {
output::output('critical', __METHOD__ . '(): missing required setting: \'' . $key . '\'');
}
}
/**
* If set, override variables listed in $settings_list[].
*/
foreach ($this->settings_list as $key => $type) {
if (!array_key_exists($key, $this->settings)) {
continue;
}
/**
* Do some explicit type casting because everything is initially a string.
*/
if ($type === 'string') {
$this->{$key} = $this->settings[$key];
} elseif ($type === 'int' && preg_match('/^\\d+$/', $this->settings[$key])) {
$this->{$key} = (int) $this->settings[$key];
} elseif ($type === 'bool') {
if (strtolower($this->settings[$key]) === 'true') {
$this->{$key} = true;
} elseif (strtolower($this->settings[$key]) === 'false') {
$this->{$key} = false;
}
}
}
}
/**
* @param integer $NeededAXX Constante du niveau d'accès
*/
public static function CheckPermsOrDie($NeededAXX = AXX_MEMBER)
{
if (!self::CheckPerms($NeededAXX)) {
$lng = language::getinstance()->GetLngBlock('dataengine');
if (is_numeric($NeededAXX)) {
$perm = self::s_perms();
$NeededAXX = $perm[$NeededAXX];
}
$str = sprintf($lng['minimalpermsneeded'], $NeededAXX);
$out = <<<PERM
<br/><br/>
\t<center>
\t\t<a href='%ROOT_URL%'>
\t\t<font color=red><i>
{$str}
\t\t</i></font></a>
\t</center>
PERM;
output::_DoOutput($out);
}
}
function format_menuitem($url, $caption, $level, $dir = false)
{
$url = Path::linkto($GLOBALS['root'] . $url);
$caption = output::mask($caption);
$m = array('menu_spacer' => array(), 'menu_entry' => array(), 'menu_dir' => array(), 'menu_url' => $url, 'menu_caption' => array(), 'menu_caption_this' => array());
for ($i = 0; $i < $level; $i++) {
$m['menu_spacer'][] = array();
}
if ($dir) {
$m['menu_dir'][] = array();
} else {
$m['menu_entry'][] = array();
}
$document_root = $_SERVER['DOCUMENT_ROOT'];
if (substr($document_root, -1) == '/') {
$document_root = substr($document_root, 0, -1);
}
$a = Path::absolute($url);
$b = sessionurl($a);
$c = $document_root . $_SERVER['REQUEST_URI'];
if ($a == $c || $b == $c) {
$m['menu_caption_this'][0]['menu_caption'] = $caption;
} else {
$m['menu_caption'][0]['menu_caption'] = $caption;
}
return $m;
}
/**
* Constructor
*
* @access public
* @param object ipsRegistry reference
* @return void
*/
public function __construct(ipsRegistry $registry)
{
parent::__construct($registry, TRUE);
$_app = $this->request['app'] ? $this->request['app'] : IPS_APP_COMPONENT;
/* Update paths and such */
$this->settings['base_url'] = $this->settings['_original_base_url'];
$this->settings['public_url'] = $this->settings['_original_base_url'] . '/index.php?';
$this->settings['base_acp_url'] = $this->settings['base_url'] . '/' . CP_DIRECTORY;
$this->settings['skin_acp_url'] = $this->settings['base_url'] . '/' . CP_DIRECTORY . "/skin_cp";
$this->settings['skin_app_url'] = $this->settings['skin_acp_url'];
$this->settings['js_main_url'] = $this->settings['base_url'] . '/' . CP_DIRECTORY . '/js/';
$this->settings['js_app_url'] = $this->settings['base_url'] . '/' . CP_DIRECTORY . '/' . IPSLib::getAppFolder($_app) . '/' . $_app . '/js/';
if (ipsRegistry::$request['app']) {
$this->settings['skin_app_url'] = $this->settings['base_url'] . '/' . CP_DIRECTORY . '/' . IPSLib::getAppFolder($_app) . '/' . $_app . "/skin_cp/";
}
/* Update base URL */
if ($this->member->session_type == 'cookie') {
$this->settings['base_url'] = $this->settings['base_url'] . '/' . CP_DIRECTORY . '/index.php?';
} else {
$this->settings['base_url'] = $this->settings['base_url'] . '/' . CP_DIRECTORY . '/index.php?adsess=' . $this->request['adsess'] . '&';
}
$this->settings['_base_url'] = $this->settings['base_url'];
$this->settings['base_url'] = $this->settings['base_url'] . 'app=' . IPS_APP_COMPONENT . '&';
$this->settings['extraJsModules'] = '';
}
public function emptyFurlCache()
{
self::$furlCache = array();
}
}
if ($validsession !== true && IS_IMG) {
header("Content-Type: image/png");
header("Cache-Control: no-cache, must-revalidate");
// HTTP/1.1
header("Expires: Mon, 16 Jul 2008 04:21:44 GMT");
// HTTP/1.0 Date dans le passé
require_once CLASS_PATH . 'map.class.php';
$Taille = 180;
$image = imagecreate($Taille, 20);
$background_color = imagecolorallocate($image, 0, 0, 0);
imagefilledrectangle($image, 0, 0, $Taille, $Taille, $background_color);
$debug_cl = imagecolorallocate($image, 254, 254, 254);
map::map_debug($lng['session_lost']);
imagepng($image);
imagedestroy($image);
exit;
}
// $validsession
if ($validsession === true && $_SESSION['_Perm'] < AXX_VALIDATING) {
$query = 'INSERT INTO `SQL_PREFIX_Log` (`DATE`,`log`,`IP`) VALUES(NOW(),"login,needvalidation:' . $_SESSION['_login'] . '",\'' . $_SESSION['_IP'] . '\')';
$_SESSION['_login'] = '';
DataEngine::sql($query);
output::_DoOutput('<a href="' . DataEngine::config_key('config', 'ForumLink') . '"><p style="color:red">' . $lng['no_axx'] . '</p></a>');
}
if ($validsession !== true) {
require_once TEMPLATE_PATH . 'login.tpl.php';
$tpl = tpl_login::getinstance();
$tpl->page_title = $lng['login_page_title'];
$tpl->DoOutput($login_msg);
}
function format()
{
$vars['menu'] = week_menu($this->week);
for ($d = 0; $d < 7; $d++) {
$timestamp = $this->timestamp_of_day($d);
$vars['hfield'][$d] = array('cal_dow' => output::mask(date('D', $timestamp)), 'cal_date' => date('d.m.', $timestamp));
}
$vars['time'] = $this->format_time();
$this->output = new tmpl('index.html', $vars);
}
/**
* Parse a line for various chat data.
*/
protected function parse_line($line)
{
/**
* "Normal" lines.
*/
if (preg_match('/^\\d{4}-\\d{2}-\\d{2}T(?<time>\\d{2}:\\d{2}:\\d{2}) <(?<nick>\\S+)> (?<line>.+)$/', $line, $matches)) {
$this->set_normal($matches['time'], $matches['nick'], $matches['line']);
/**
* "Join" lines.
*/
} elseif (preg_match('/^\\d{4}-\\d{2}-\\d{2}T(?<time>\\d{2}:\\d{2}:\\d{2}) \\*\\*\\* (?<nick>\\S+) has joined [#&!+]\\S+$/', $line, $matches)) {
$this->set_join($matches['time'], $matches['nick']);
/**
* "Quit" lines.
*/
} elseif (preg_match('/^\\d{4}-\\d{2}-\\d{2}T(?<time>\\d{2}:\\d{2}:\\d{2}) \\*\\*\\* (?<nick>\\S+) has quit IRC$/', $line, $matches)) {
$this->set_quit($matches['time'], $matches['nick']);
/**
* "Mode" lines.
*/
} elseif (preg_match('/^\\d{4}-\\d{2}-\\d{2}T(?<time>\\d{2}:\\d{2}:\\d{2}) \\*\\*\\* (?<nick_performing>\\S+) sets mode: (?<modes>[-+][ov]+([-+][ov]+)?) (?<nicks_undergoing>\\S+( \\S+)*)$/', $line, $matches)) {
$modenum = 0;
$nicks_undergoing = explode(' ', $matches['nicks_undergoing']);
for ($i = 0, $j = strlen($matches['modes']); $i < $j; $i++) {
$mode = substr($matches['modes'], $i, 1);
if ($mode === '-' || $mode === '+') {
$modesign = $mode;
} else {
$this->set_mode($matches['time'], $matches['nick_performing'], $nicks_undergoing[$modenum], $modesign . $mode);
$modenum++;
}
}
/**
* "Action" and "slap" lines.
*/
} elseif (preg_match('/^\\d{4}-\\d{2}-\\d{2}T(?<time>\\d{2}:\\d{2}:\\d{2}) \\* (?<line>(?<nick_performing>\\S+) ((?<slap>[sS][lL][aA][pP][sS]( (?<nick_undergoing>\\S+)( .+)?)?)|(.+)))$/', $line, $matches)) {
if (!empty($matches['slap'])) {
$this->set_slap($matches['time'], $matches['nick_performing'], !empty($matches['nick_undergoing']) ? $matches['nick_undergoing'] : null);
}
$this->set_action($matches['time'], $matches['nick_performing'], $matches['line']);
/**
* "Nickchange" lines.
*/
} elseif (preg_match('/^\\d{4}-\\d{2}-\\d{2}T(?<time>\\d{2}:\\d{2}:\\d{2}) \\*\\*\\* (?<nick_performing>\\S+) is now known as (?<nick_undergoing>\\S+)$/', $line, $matches)) {
$this->set_nickchange($matches['time'], $matches['nick_performing'], $matches['nick_undergoing']);
/**
* "Part" lines.
*/
} elseif (preg_match('/^\\d{4}-\\d{2}-\\d{2}T(?<time>\\d{2}:\\d{2}:\\d{2}) \\*\\*\\* (?<nick>\\S+) has left [#&!+]\\S+$/', $line, $matches)) {
$this->set_part($matches['time'], $matches['nick']);
/**
* "Topic" lines.
*/
} elseif (preg_match('/^\\d{4}-\\d{2}-\\d{2}T(?<time>\\d{2}:\\d{2}:\\d{2}) \\*\\*\\* (?<nick>\\S+) changes topic to "(?<line>.+)"$/', $line, $matches)) {
if ($matches['line'] !== ' ') {
$this->set_topic($matches['time'], $matches['nick'], $matches['line']);
}
/**
* "Kick" lines.
*/
} elseif (preg_match('/^\\d{4}-\\d{2}-\\d{2}T(?<time>\\d{2}:\\d{2}:\\d{2}) \\*\\*\\* (?<line>(?<nick_undergoing>\\S+) was kicked by (?<nick_performing>\\S+) \\(.*\\))$/', $line, $matches)) {
$this->set_kick($matches['time'], $matches['nick_performing'], $matches['nick_undergoing'], $matches['line']);
/**
* Skip everything else.
*/
} elseif ($line !== '') {
output::output('debug', __METHOD__ . '(): skipping line ' . $this->linenum . ': \'' . $line . '\'');
}
}
<?php
/**
* @author Alex10336
* Dernière modification: $Id$
* @license GNU Public License 3.0 ( http://www.gnu.org/licenses/gpl-3.0.txt )
* @license Creative Commons 3.0 BY-SA ( http://creativecommons.org/licenses/by-sa/3.0/deed.fr )
*
**/
require_once './init.php';
require_once INCLUDE_PATH . 'Script.php';
if (!Members::CheckPerms('CARTOGRAPHIE')) {
if (Members::CheckPerms('CARTE')) {
output::Boink(ROOT_URL . 'Carte.php');
} else {
output::Boink(ROOT_URL . 'Mafiche.php');
}
} else {
output::Boink(ROOT_URL . 'cartographie.php');
}
public function write_data($sqlite3)
{
/**
* Write data to database table "uid_details".
*/
if (($result = $sqlite3->querySingle('SELECT uid, firstseen FROM uid_details WHERE csnick = \'' . $sqlite3->escapeString($this->csnick) . '\'', true)) === false) {
output::output('critical', basename(__FILE__) . ':' . __LINE__ . ', sqlite3 says: ' . $sqlite3->lastErrorMsg());
}
if (empty($result)) {
$sqlite3->exec('INSERT INTO uid_details (uid, csnick' . ($this->firstseen !== '' ? ', firstseen, lastseen' : '') . ') VALUES (NULL, \'' . $sqlite3->escapeString($this->csnick) . '\'' . ($this->firstseen !== '' ? ', DATETIME(\'' . $this->firstseen . '\'), DATETIME(\'' . $this->lastseen . '\')' : '') . ')') or output::output('critical', basename(__FILE__) . ':' . __LINE__ . ', sqlite3 says: ' . $sqlite3->lastErrorMsg());
$uid = $sqlite3->lastInsertRowID();
} else {
$uid = $result['uid'];
/**
* Only update $firstseen if the value stored in the database is zero. We're
* parsing logs in chronological order so the stored value of $firstseen can
* never be lower and the value of $lastseen can never be higher than the parsed
* values. (We are not going out of our way to deal with possible DST nonsense.)
* Secondly, only update $csnick if the nick was seen. We want to avoid it from
* being overwritten by a lowercase $prevnick (streak code) or weirdly cased
* nick due to a slap.
*/
if ($this->firstseen !== '') {
$sqlite3->exec('UPDATE uid_details SET csnick = \'' . $sqlite3->escapeString($this->csnick) . '\'' . ($result['firstseen'] === '0000-00-00 00:00:00' ? ', firstseen = DATETIME(\'' . $this->firstseen . '\')' : '') . ', lastseen = DATETIME(\'' . $this->lastseen . '\') WHERE uid = ' . $uid) or output::output('critical', basename(__FILE__) . ':' . __LINE__ . ', sqlite3 says: ' . $sqlite3->lastErrorMsg());
}
}
/**
* Write data to database table "uid_activity".
*/
if ($this->l_total !== 0) {
$queryparts = $this->get_queryparts($sqlite3, ['l_night', 'l_morning', 'l_afternoon', 'l_evening', 'l_total']);
$sqlite3->exec('INSERT OR IGNORE INTO uid_activity (uid, date, ' . implode(', ', $queryparts['columns']) . ') VALUES (' . $uid . ', \'' . substr($this->firstseen, 0, 10) . '\', ' . implode(', ', $queryparts['values']) . ')') or output::output('critical', basename(__FILE__) . ':' . __LINE__ . ', sqlite3 says: ' . $sqlite3->lastErrorMsg());
$sqlite3->exec('UPDATE uid_activity SET ' . implode(', ', $queryparts['update-assignments']) . ' WHERE CHANGES() = 0 AND uid = ' . $uid . ' AND date = \'' . substr($this->firstseen, 0, 10) . '\'') or output::output('critical', basename(__FILE__) . ':' . __LINE__ . ', sqlite3 says: ' . $sqlite3->lastErrorMsg());
}
/**
* Write data to database table "uid_events".
*/
$queryparts = $this->get_queryparts($sqlite3, ['m_op', 'm_opped', 'm_voice', 'm_voiced', 'm_deop', 'm_deopped', 'm_devoice', 'm_devoiced', 'joins', 'parts', 'quits', 'kicks', 'kicked', 'nickchanges', 'topics', 'ex_kicks', 'ex_kicked']);
if (!empty($queryparts)) {
$sqlite3->exec('INSERT OR IGNORE INTO uid_events (uid, ' . implode(', ', $queryparts['columns']) . ') VALUES (' . $uid . ', ' . implode(', ', $queryparts['values']) . ')') or output::output('critical', basename(__FILE__) . ':' . __LINE__ . ', sqlite3 says: ' . $sqlite3->lastErrorMsg());
$sqlite3->exec('UPDATE uid_events SET ' . implode(', ', $queryparts['update-assignments']) . ' WHERE CHANGES() = 0 AND uid = ' . $uid) or output::output('critical', basename(__FILE__) . ':' . __LINE__ . ', sqlite3 says: ' . $sqlite3->lastErrorMsg());
}
/**
* Try to pick the longest unique line from each of the quote stacks.
*/
$types = ['ex_actions', 'ex_uppercased', 'ex_exclamations', 'ex_questions', 'quote'];
foreach ($types as $type) {
if (empty($this->{$type . '_stack'})) {
continue;
}
/**
* rsort() sorts a multidimensional array on the first value of each contained
* array, highest to lowest.
*/
rsort($this->{$type . '_stack'});
$this->{$type} = $this->{$type . '_stack'}[0]['line'];
if (($type === 'ex_questions' || $type === 'ex_exclamations') && $this->{$type} === $this->ex_uppercased && count($this->{$type . '_stack'}) > 1) {
for ($i = 1, $j = count($this->{$type . '_stack'}); $i < $j; $i++) {
if ($this->{$type . '_stack'}[$i]['line'] !== $this->ex_uppercased) {
$this->{$type} = $this->{$type . '_stack'}[$i]['line'];
break;
}
}
} elseif ($type === 'quote' && ($this->quote === $this->ex_uppercased || $this->quote === $this->ex_exclamations || $this->quote === $this->ex_questions) && count($this->quote_stack) > 1) {
for ($i = 1, $j = count($this->quote_stack); $i < $j; $i++) {
if ($this->quote_stack[$i]['line'] !== $this->ex_uppercased && $this->quote_stack[$i]['line'] !== $this->ex_exclamations && $this->quote_stack[$i]['line'] !== $this->ex_questions) {
$this->quote = $this->quote_stack[$i]['line'];
break;
}
}
}
}
/**
* Write data to database table "uid_lines".
*/
$queryparts = $this->get_queryparts($sqlite3, ['l_00', 'l_01', 'l_02', 'l_03', 'l_04', 'l_05', 'l_06', 'l_07', 'l_08', 'l_09', 'l_10', 'l_11', 'l_12', 'l_13', 'l_14', 'l_15', 'l_16', 'l_17', 'l_18', 'l_19', 'l_20', 'l_21', 'l_22', 'l_23', 'l_night', 'l_morning', 'l_afternoon', 'l_evening', 'l_total', 'l_mon_night', 'l_mon_morning', 'l_mon_afternoon', 'l_mon_evening', 'l_tue_night', 'l_tue_morning', 'l_tue_afternoon', 'l_tue_evening', 'l_wed_night', 'l_wed_morning', 'l_wed_afternoon', 'l_wed_evening', 'l_thu_night', 'l_thu_morning', 'l_thu_afternoon', 'l_thu_evening', 'l_fri_night', 'l_fri_morning', 'l_fri_afternoon', 'l_fri_evening', 'l_sat_night', 'l_sat_morning', 'l_sat_afternoon', 'l_sat_evening', 'l_sun_night', 'l_sun_morning', 'l_sun_afternoon', 'l_sun_evening', 'urls', 'words', 'characters', 'monologues', 'slaps', 'slapped', 'exclamations', 'questions', 'actions', 'uppercased', 'quote', 'ex_exclamations', 'ex_questions', 'ex_actions', 'ex_uppercased']);
if (!empty($queryparts)) {
$sqlite3->exec('INSERT OR IGNORE INTO uid_lines (uid, ' . implode(', ', $queryparts['columns']) . ($this->lasttalked !== '' ? ', lasttalked' : '') . ') VALUES (' . $uid . ', ' . implode(', ', $queryparts['values']) . ($this->lasttalked !== '' ? ', DATETIME(\'' . $this->lasttalked . '\')' : '') . ')') or output::output('critical', basename(__FILE__) . ':' . __LINE__ . ', sqlite3 says: ' . $sqlite3->lastErrorMsg());
$sqlite3->exec('UPDATE uid_lines SET ' . implode(', ', $queryparts['update-assignments']) . ($this->lasttalked !== '' ? ', lasttalked = DATETIME(\'' . $this->lasttalked . '\')' : '') . ' WHERE CHANGES() = 0 AND uid = ' . $uid) or output::output('critical', basename(__FILE__) . ':' . __LINE__ . ', sqlite3 says: ' . $sqlite3->lastErrorMsg());
/**
* Update $topmonologue separately as we want to keep the highest value instead
* of the sum.
*/
if ($this->topmonologue !== 0) {
if (($topmonologue = $sqlite3->querySingle('SELECT topmonologue FROM uid_lines WHERE uid = ' . $uid)) === false) {
output::output('critical', basename(__FILE__) . ':' . __LINE__ . ', sqlite3 says: ' . $sqlite3->lastErrorMsg());
}
if ($this->topmonologue > $topmonologue) {
$sqlite3->exec('UPDATE uid_lines SET topmonologue = ' . $this->topmonologue . ' WHERE uid = ' . $uid) or output::output('critical', basename(__FILE__) . ':' . __LINE__ . ', sqlite3 says: ' . $sqlite3->lastErrorMsg());
}
}
}
/**
* Write data to database table "uid_smileys".
*/
$queryparts = $this->get_queryparts($sqlite3, ['s_01', 's_02', 's_03', 's_04', 's_05', 's_06', 's_07', 's_08', 's_09', 's_10', 's_11', 's_12', 's_13', 's_14', 's_15', 's_16', 's_17', 's_18', 's_19', 's_20', 's_21', 's_22', 's_23', 's_24', 's_25', 's_26', 's_27', 's_28', 's_29', 's_30', 's_31', 's_32', 's_33', 's_34', 's_35', 's_36', 's_37', 's_38', 's_39', 's_40', 's_41', 's_42', 's_43', 's_44', 's_45', 's_46', 's_47', 's_48', 's_49', 's_50']);
if (!empty($queryparts)) {
$sqlite3->exec('INSERT OR IGNORE INTO uid_smileys (uid, ' . implode(', ', $queryparts['columns']) . ') VALUES (' . $uid . ', ' . implode(', ', $queryparts['values']) . ')') or output::output('critical', basename(__FILE__) . ':' . __LINE__ . ', sqlite3 says: ' . $sqlite3->lastErrorMsg());
$sqlite3->exec('UPDATE uid_smileys SET ' . implode(', ', $queryparts['update-assignments']) . ' WHERE CHANGES() = 0 AND uid = ' . $uid) or output::output('critical', basename(__FILE__) . ':' . __LINE__ . ', sqlite3 says: ' . $sqlite3->lastErrorMsg());
}
}
<?php
// Partie standard d'EU2de
require_once '../../init.php';
require_once INCLUDE_PATH . 'Script.php';
require_once TEMPLATE_PATH . 'sample.tpl.php';
$tpl = tpl_sample::getinstance();
// Déclaration variables
$Joueur = $_SESSION['_login'];
require_once 'cnh_fonctions.php';
Init_Addon();
// DEBUT CODE LIBRE
if (!DataEngine::CheckPerms('ZZZ_COMMERCE_TPL_EDIT')) {
output::Boink('./index.php');
}
if (isset($_GET['delid']) && DataEngine::CheckPerms('ZZZ_COMMERCE_TPL_DELETE')) {
$datas_id = $_GET['delid'];
$mysql_result = DataEngine::sql('DELETE FROM `SQL_PREFIX_Modules_Template` WHERE `ID`=' . $datas_id) or die(mysql_error());
$mysql_result = DataEngine::sql('DELETE FROM `SQL_PREFIX_Modules_Users` WHERE `Module_ID`=' . $datas_id) or die(mysql_error());
header('Location: template_list.php?commande=false');
exit;
} elseif (isset($_GET['editid']) && !isset($_POST['ID'])) {
$mysql_result = DataEngine::sql('SELECT `ID`, `Nom`, `Abreviation`, `Description`, `Categorie`, `Taille`, `PAChasseur`, `PAGVG`, `URLIcone`,
`URLMedium`, `URLImage`, `Temps`, `Titane`, `Cuivre`, `Fer`, `Aluminium`, `Mercure`, `Silicium`, `Uranium`, `Krypton`, `Azote`, `Hydrogene`,
`PropImpulsion`, `PropWarp`, `PropConsommation`, `ArmType`, `ArmDegat`, `ArmManiabilite`, `ProtType`, `ProtChasseur`, `ProtGVG`, `EquipType`,
`EquipNiv` FROM `SQL_PREFIX_Modules_Template` WHERE `ID`=' . $_GET['editid']) or die(mysql_error());
$datas = mysql_fetch_array($mysql_result);
$datas['Nom'] = stripslashes($datas['Nom']);
$datas['Abreviation'] = stripslashes($datas['Abreviation']);
$datas['Description'] = stripslashes($datas['Description']);
$datas['URLIcone'] = stripslashes($datas['URLIcone']);
/**
* Parse a line for various chat data.
*/
protected function parse_line($line)
{
/**
* "Normal" lines.
*/
if (preg_match('/^\\S{3} \\d{2} (?<time>\\d{2}:\\d{2}(:\\d{2})?) <(?<nick>\\S+)> (?<line>.+)$/', $line, $matches)) {
$this->set_normal($matches['time'], $matches['nick'], $matches['line']);
/**
* "Join" lines.
*/
} elseif (preg_match('/^\\S{3} \\d{2} (?<time>\\d{2}:\\d{2}(:\\d{2})?) \\* (?<nick>\\S+) \\(\\S+\\) has joined [#&!+]\\S+$/', $line, $matches)) {
$this->set_join($matches['time'], $matches['nick']);
/**
* "Quit" lines.
*/
} elseif (preg_match('/^\\S{3} \\d{2} (?<time>\\d{2}:\\d{2}(:\\d{2})?) \\* (?<nick>\\S+) has quit \\(.*\\)$/', $line, $matches)) {
$this->set_quit($matches['time'], $matches['nick']);
/**
* "Mode" lines.
*/
} elseif (preg_match('/^\\S{3} \\d{2} (?<time>\\d{2}:\\d{2}(:\\d{2})?) \\* (?<nick_performing>\\S+) (?<modesign>gives|removes) (?<mode>channel operator status|voice) (to|from) (?<nicks_undergoing>\\S+( \\S+)*)$/', $line, $matches)) {
$nicks_undergoing = explode(' ', $matches['nicks_undergoing']);
if ($matches['modesign'] === 'gives') {
$modesign = '+';
} else {
$modesign = '-';
}
if ($matches['mode'] === 'channel operator status') {
$mode = 'o';
} else {
$mode = 'v';
}
foreach ($nicks_undergoing as $nick_undergoing) {
$this->set_mode($matches['time'], $matches['nick_performing'], $nick_undergoing, $modesign . $mode);
}
/**
* "Nickchange" lines.
*/
} elseif (preg_match('/^\\S{3} \\d{2} (?<time>\\d{2}:\\d{2}(:\\d{2})?) \\* (?<nick_performing>\\S+) is now known as (?<nick_undergoing>\\S+)$/', $line, $matches)) {
$this->set_nickchange($matches['time'], $matches['nick_performing'], $matches['nick_undergoing']);
/**
* "Part" lines.
*/
} elseif (preg_match('/^\\S{3} \\d{2} (?<time>\\d{2}:\\d{2}(:\\d{2})?) \\* (?<nick>\\S+) \\(\\S+\\) has left [#&!+]\\S+( \\(.*\\))?$/', $line, $matches)) {
$this->set_part($matches['time'], $matches['nick']);
/**
* "Topic" lines.
*/
} elseif (preg_match('/^\\S{3} \\d{2} (?<time>\\d{2}:\\d{2}(:\\d{2})?) \\* (?<nick>\\S+) has changed the topic to: (?<line>.+)$/', $line, $matches)) {
$this->set_topic($matches['time'], $matches['nick'], $matches['line']);
/**
* "Kick" lines.
*/
} elseif (preg_match('/^\\S{3} \\d{2} (?<time>\\d{2}:\\d{2}(:\\d{2})?) \\* (?<line>(?<nick_performing>\\S+) has kicked (?<nick_undergoing>\\S+) from [#&!+]\\S+ \\(.*\\))$/', $line, $matches)) {
$this->set_kick($matches['time'], $matches['nick_performing'], $matches['nick_undergoing'], $matches['line']);
/**
* Skip everything else.
*/
} elseif ($line !== '') {
output::output('debug', __METHOD__ . '(): skipping line ' . $this->linenum . ': \'' . $line . '\'');
}
}
<?php
// Partie standard d'EU2de
require_once '../../init.php';
require_once INCLUDE_PATH . 'Script.php';
require_once TEMPLATE_PATH . 'sample.tpl.php';
$tpl = tpl_sample::getinstance();
// Déclaration variables
$Joueur = $_SESSION['_login'];
require_once 'cnh_fonctions.php';
Init_Addon();
if (!DataEngine::CheckPerms('ZZZ_COMMERCE_INDEX')) {
output::Boink(ROOT_URL . 'index.php');
}
// DEBUT CODE LIBRE
// FIN CODE LIBRE
?>
<HTML>
<HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</HEAD>
<BODY>
<!-- DEBUT CODE LIBRE -->
<?php
if (isset($_GET['sousmenu'])) {
// cnhToolbar(3, "menu_", 128, $_GET['sousmenu']);
cnhTB(1, "menu_", 128, $_GET['sousmenu']);
} elseif (empty($Joueur)) {
$tpl = tpl_sample::getinstance();
$tpl->page_title = 'EU2: Vortex Import';
$BASE_FILE = ROOT_URL . "addons/wormhole_import/index.php";
if (isset($_POST['act']) && $_POST['act'] == 'import') {
// Purge au préalable....
define('CRON_LOADONLY', true);
include INCLUDE_PATH . 'crontab.php';
$cron->GetJob('job_vortex')->RunJob();
$cron->Save();
$vortex = explode("\n", $_POST['data']);
$carto = cartographie::getinstance();
foreach ($vortex as $item) {
list($coordsin, $coordsout) = explode(',', $item);
$carto->add_vortex($coordsin, $coordsout);
}
output::Boink($BASE_FILE, 'Wormhole import done. Enjoy.');
}
$bulle = <<<bulle
L'importation des vortex lance sa tache cron (memet à zéro les vortex)</br>
----<br/>
Import wormhole will run whormhole cron task (reset all previous entry)</br>
bulle;
$bulle = bulle($bulle);
$out .= <<<text
<table class="table_nospacing table_center color_row1">
<tr><td class="color_bigheader text_center">
<img {$bulle} src='%IMAGES_URL%help.png'/> Wormhole import
</td></tr>
<tr><td class="text_center">
<form method="post" action="{$BASE_FILE}">
<textarea name="data" class="color_row1" cols="50" rows="4"></textarea><br/>
public function Boink($url)
{
if ($this->Infos() != '') {
output::Messager($this->Infos());
}
if ($this->Warns() != '') {
output::Messager($this->Warns());
}
if ($this->Erreurs() != '') {
output::Messager($this->Erreurs());
}
if ($url != '') {
output::Boink($url);
}
}
$Order = ' ORDER BY `Date` DESC';
}
} else {
$TriModif = '0';
}
$where = '';
if ($_GET['Joueur'] != '') {
$where = ' AND m.`Joueur`=\'' . sqlesc($_GET['Joueur']) . '\'';
}
$axx = array();
foreach (Members::s_perms() as $k => $v) {
if ($k == AXX_DISABLED) {
continue;
}
if (Members::CurrentPerms() > $k || Members::CurrentPerms() == AXX_ROOTADMIN) {
$axx[$k] = $v;
}
}
require_once TEMPLATE_PATH . 'editmembres.tpl.php';
$tpl = tpl_editmembres::getinstance();
$mysql_result = DataEngine::sql('SELECT m.`Joueur`, m.`Points`, m.`Date`, m.`Economie`, m.`Commerce`, m.`Recherche`, m.`Combat`, m.`Construction`, m.`Navigation`, m.`Grade`, m.`Race`, m.`ship`, u.`Permission` from `SQL_PREFIX_Membres` m, `SQL_PREFIX_Users` u WHERE (m.`Joueur`=u.`Login`)' . $where . $Order);
if (mysql_num_rows($mysql_result) == 0) {
output::Boink('Membres.php');
}
$tpl->header(Get_string(), $TriMembre, $triPermission, $TriPoints, $TriRace, $TriShip, $TriModif);
$i = 0;
while ($ligne = mysql_fetch_assoc($mysql_result)) {
$tpl->row($i++, $ligne, $Grades, $tabrace, $axx);
}
$tpl->footer();
$tpl->DoOutput();
