function sendLoginDetails($email)
{
global $sitename;
global $logo;
$query = MYSQL_QUERY("SELECT `Username`,`Password` FROM `ChallengeMembers` WHERE `Email` = '" . $email . "' ") or die(MYSQL_ERROR());
if ($query) {
if (MYSQL_NUM_ROWS($query)) {
while ($row = MYSQL_FETCH_ARRAY($query)) {
$userpassword = $row['Password'];
$username = $row['Username'];
}
/*send email*/
include 'email_class.php';
$em = new EmailTemplate();
$subject = ucfirst($sitename) . " Login Details";
$headers = "From: " . ucwords($sitename) . " <*****@*****.**> \r\n" . 'X-Mailer: PHP/' . phpversion();
$headers .= 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$email_message = $username . ",<br /><br /> Thank you for your interest in joining our challenges.\n\t\t\t\t\t\t\t\t\t<br /><br />\n\t\t\t\t\t\t\t\t\tThe following are your login data:\n\t\t\t\t\t\t\t\t\t<br>\n\t\t\t\t\t\t\t\t\tUsername : <b>" . $username . "</b><br />\n\t\t\t\t\t\t\t\t\tPassword : <b>" . $userpassword . "</b>\n\t\t\t\t\t\t\t\t\t<br /><br />\n\t\t\t\t\t\t\t\t\tThank you.<br />\n\t\t\t\t\t\t\t\t\t<b>" . $sitename . "</b>";
$emailmessage = $em->get($logo, $sitename, $email_message);
/*first send to guest */
$sentmail = mail($email, $subject, $emailmessage, $headers);
/*end of send email*/
return "OK";
} else {
return $email . "not found in database.";
}
} else {
return "Email not found in database.";
}
}
function sendNewsletter($from, $newsTitle, $newsBody)
{
$sql = "SELECT * FROM mailing_list WHERE active='1'";
$result = MYSQL_QUERY($sql);
$numberOfRows = MYSQL_NUMROWS($result);
$i = 0;
while ($i < $numberOfRows) {
$thisEmail = MYSQL_RESULT($result, $i, "email");
$thisUid = MYSQL_RESULT($result, $i, "uid");
$thisName = MYSQL_RESULT($result, $i, "full_name");
/* recipients */
$to = $thisEmail;
// note the comma
/* subject */
$subject = $newsTitle;
/* message */
$message = "Dear {$thisName} <br>";
$message .= $newsBody . '<br><br><a href="' . _PREF . 'modules/mailing_ilst/deleteMailing_list.php?thisEmailField=' . $thisEmail . '&thisUidField=' . $thisUid . '">
To unsubscribe please click here</a>';
/* To send HTML mail, you can set the Content-type header. */
$headers = "MIME-Version: 1.0\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n";
/* additional headers */
$headers .= "To:" . $thisEmail . "\r\n";
$headers .= "From: " . $from;
/* and now mail it */
$s = mail($to, $subject, $message, $headers);
$i++;
}
if ($s) {
echo '<script>correctMessage("Message Sent successfuly");</script>';
} else {
echo '<script>errorMessage("Sorry message has not been sent, an error has occurred");</script>';
}
}
function add($section, $text)
{
global $flouser;
if (!MYSQL_QUERY("INSERT INTO flobase_log (section, timestamp, currentuser, currentip, logvalue) VALUES('" . mysql_real_escape_string($section) . "', '" . date("U") . "', '" . $flouser->userid . "', '" . mysql_real_escape_string($_SERVER['REMOTE_ADDR']) . "', '" . mysql_real_escape_string($text) . "')")) {
return false;
}
return mysql_insert_id();
}
function signencode($sign)
{
MYSQL_QUERY("CREATE TABLE IF NOT EXISTS `cache_languagesigns` (\n\t\t`id` int(11) NOT NULL auto_increment,\n\t\t`signs` text NOT NULL,\n\t\tPRIMARY KEY (`id`)\n\t\t)");
MYSQL_QUERY("INSERT INTO cache_languagesigns (signs) VALUES('" . mysql_real_escape_string($sign) . "')");
$signs = MYSQL_FETCH_ARRAY(MYSQL_QUERY("SELECT signs FROM cache_languagesigns ORDER BY id DESC LIMIT 1"));
MYSQL_QUERY("TRUNCATE TABLE cache_languagesigns");
return $signs['signs'];
}
function getTotalMonetarySponsorship($challenger_id){
$total_sponsorship = 0;
$query = MYSQL_QUERY("SELECT SUM(Amount) AS total_sponsorship FROM SponsorContact WHERE SponsorId = '".$challenger_id."'");
if($row = MYSQL_FETCH_ARRAY($query)){
$total_sponsorship = $row['total_sponsorship'];
}
return $total_sponsorship;
}
function set($query)
{
$queryResponse = MYSQL_QUERY($query) or die($query . " " . mysql_error());
if (is_resource($queryResponse)) {
return mysql_fetch_array($queryResponse);
} else {
return $queryResponse;
}
}
function get_valid_languages()
{
global $florensia;
$queryquesttexttables = MYSQL_QUERY("SHOW TABLES FROM {$florensia->dbname} LIKE 'server_questtext_%'");
while ($questtexttables = MYSQL_FETCH_ARRAY($queryquesttexttables)) {
//if (strtr($questtexttables[0], array('server_questtext_'=>''))=="TR") continue;
$this->languagearray[strtr($questtexttables[0], array('server_questtext_' => ''))] = strtr($questtexttables[0], array('server_questtext_' => ''));
}
}
function displayCollapseListKeyed($id = '0', $idFull = '0', $note = null, $pageName = 'main', $key = null, $htmlXtra = null)
{
// Find this $key object
$sql = "SELECT *, objects.id AS objectsId FROM wires, objects ";
$sql .= "WHERE wires.fromid = {$id} AND wires.toid = objects.id ";
$sql .= "AND objects.name1 LIKE '{$key}' ";
$sql .= "AND wires.active=1 AND objects.active=1 ";
$sql .= "LIMIT 1";
$result = MYSQL_QUERY($sql);
// Find connected objects
if ($myrow = MYSQL_FETCH_ARRAY($result)) {
$foundObjectId = $myrow['objectsId'];
$sql = "SELECT *, objects.id AS objectsId FROM wires, objects ";
$sql .= "WHERE wires.fromid = {$foundObjectId} AND wires.toid = objects.id ";
$sql .= "AND wires.active=1 AND objects.active=1 ";
$sql .= "ORDER BY rank ASC";
$result = MYSQL_QUERY($sql);
// Output collapseList
$i = 0;
$notes = explode(",", $note);
echo "\n\t<!-- collapseList -->";
echo "\n\n\t<ul class = 'ieFix'>";
while ($myrow = MYSQL_FETCH_ARRAY($result)) {
$name = $myrow["name1"];
if (substr($name, 0, 1) != "." && substr($name, 0, 1) != "_") {
for ($ii = 0; $ii < count($notes); $ii++) {
if ($notes[$ii] == $myrow['objectsId']) {
$notesOut[$ii] = null;
} else {
$notesOut[$ii] = $notes[$ii];
}
}
$notesOutFiltered = array_filter($notesOut);
$noteOut = implode(",", $notesOutFiltered);
$noteOutStub = $noteOut ? $noteOut . "," : "";
echo in_array($myrow['objectsId'], $notes) ? "\n\t\t<li class = 'collapseListOpen'>\n\t\t\t\t\t\t\t- <a href='" . $pageName . ".html?id=" . $idFull . "&note=" . $noteOut . "'>" . $myrow["name1"] . "</a>" : "\n\t\t<li class = 'collapseListClosed'>\n\t\t\t\t\t\t\t+ <a href='" . $pageName . ".html?id=" . $idFull . "&note=" . $noteOutStub . $myrow['objectsId'] . "'>" . $myrow["name1"] . "</a>";
if ($htmlXtra) {
// Hack for Objectif
// $htmlXtra = "Download the complete <a href='MEDIA/PDF/Deball.pdf' target='_new'>PDF here</a>.<br/>";
$htmlXtra = "Download the <a href=\"javascript: windowPop('" . $myrow['url'] . "','poppdf', '450', '550')\">PDF</a>.<br/>";
$htmlXtra .= "View the <a href=\"javascript: windowPop('popimage.html?id=" . $myrow['objectsId'] . "','popimage', '800', '533')\">installation images</a>.<br/>";
$htmlXtra .= "Read the <a href=\"javascript: windowPop('poptext.html?id=" . $myrow['objectsId'] . "','poptext', '450', '800')\">exhibition text</a>.<br/><br/>";
//echo "\n <br /><br />".$myrow["deck"]."<br/>" . $htmlXtra . "</li>";
echo nl2br("\n\t<br />" . $myrow["deck"] . "<br/><br />" . $htmlXtra . "</li>");
// End hack
} else {
echo nl2br("\n\t<br />" . $myrow["deck"] . "<br/><br /></li>");
}
$i++;
}
}
echo "\n\t</ul>";
}
}
function user_detail($username)
{
$user = array();
$result = MYSQL_QUERY("SELECT username, user_dir, aktiv, last_login, dl_bytes, ul_bytes, count FROM users WHERE username = '******'") or die("DB-Fehler-Nummer" . mysql_errno() . "|| Meldung: " . mysql_error());
while ($row = mysql_fetch_row($result)) {
for ($i = 0; $i < mysql_num_fields($result); $i++) {
array_push($user, $row[$i]);
}
}
return $user;
}
function CheckIfVerified($code)
{
$query = MYSQL_QUERY("SELECT `ChallengeMemberId` FROM `ChallengeMembers` WHERE VerificationCode = '" . $code . "' ") or die(MYSQL_ERROR());
if (MYSQL_NUM_ROWS($query) > 0) {
while ($row = MYSQL_FETCH_ARRAY($query)) {
$member_id = $row['ChallengeMemberId'];
$result = MYSQL_QUERY("UPDATE `ChallengeMembers` SET `Verified` = '1' WHERE `ChallengeMemberId` = '" . $member_id . "' ") or die(MYSQL_ERROR());
}
return true;
} else {
return false;
}
}
function lookupField($table, $id_field, $lookup_field, $id_value)
{
$sql_lookup = "SELECT `{$lookup_field}` from `{$table}` where `{$id_field}` = '{$id_value}'";
$result_lookup = MYSQL_QUERY($sql_lookup);
$rows_lookup = MYSQL_NUM_ROWS($result_lookup);
if ($rows_lookup == null || ($rows_lookup = 0)) {
return 0;
} else {
$filds = explode(",", $lookup_field);
$ind = 0;
$value = "";
while ($ind < count($filds)) {
$value .= stripslashes(MYSQL_RESULT($result_lookup, 0, $filds[$ind]) . " ");
$ind++;
}
return trim($value);
}
}
function systemCommand()
{
// Get ".System" object
$sql = "SELECT objects.id AS objectsId FROM wires, objects ";
$sql .= "WHERE wires.fromid = 0 AND wires.toid = objects.id AND objects.name1 LIKE '.System' ";
$sql .= "AND wires.active = 1 AND objects.active = 1 ";
$sql .= "ORDER BY objects.modified DESC LIMIT 1";
$res = MYSQL_QUERY($sql);
$row = MYSQL_FETCH_ARRAY($res);
global $systemObjectId;
$systemObjectId = $row["objectsId"];
// Get "documentBase"
$sql = "SELECT * FROM wires, objects ";
$sql .= "WHERE wires.fromid = {$systemObjectId} AND wires.toid = objects.id AND objects.name1 LIKE 'documentBase' ";
$sql .= "AND wires.active = 1 AND objects.active = 1 ";
$sql .= "ORDER BY objects.modified DESC LIMIT 1";
$res = MYSQL_QUERY($sql);
$row = MYSQL_FETCH_ARRAY($res);
global $documentBase;
$documentBase = $row['body'];
// echo $documentBase;
// Establish page
global $pageName;
$pageName = basename($PHP_SELF, ".html");
if (!$pageName) {
$pageName = "index";
}
// Set document title
global $documentTitle;
$documentTitle = $documentTitle ? $documentBase . " | " . $documentTitle : $documentBase;
// Parse object commands
global $objects;
global $object;
global $id;
$objects = explode(",", $id);
$object = $objects[sizeof($objects) - 1];
if (!$object) {
$object = 0;
}
if (sizeof($objects) == 1 && empty($objects[sizeof($objects) - 1])) {
unset($objects);
}
}
function DB_Query($sql)
{
global $footer;
$result = MYSQL_QUERY($sql);
if (!$result) {
$message = "数据库访问错误代码如下:\r\n";
$message .= $sql . " \r\n";
$message .= "错误内容: " . mysql_error() . " \r\n";
$message .= "错误代码: " . mysql_errno() . " \r\n";
$message .= "时间: " . gmdate('Y-m-d H:i:s', time() + 3600 * 8) . "\r\n";
$message .= "文件: http://" . $_SERVER['HTTP_HOST'] . $_SERVER['PHP_SELF'];
echo '<center><font class=red><b>数据库访问错误!</b></font><br /><p><textarea rows="26" style="width:100%;font-size:12px;">' . htmlspecialchars($message) . '</textarea></p>
<input type="button" name="back" value=" 返 回 " onclick="history.back();return false;" />
</center>';
echo $footer;
exit;
} else {
return true;
}
}
function exportfile($filename, $langid)
{
global $florensia;
$langfile = $florensia->language_abs . "/{$langid}/{$filename}.lang.php";
if (!rename($langfile, $langfile . '_backup_' . date("Y.m.d-H.i.s"))) {
$florensia->notice("Cannot rename old file for backup. Please verify your chmod settings!", "warning");
return false;
}
if (!($newfile = fopen($langfile, 'a'))) {
$florensia->notice("Cannot create new file. Please verify your chmod settings!", "warning");
return false;
}
$newlangfile = new SimpleXMLElement("<{$filename} createdate=\"" . date("Y-m-d H:i:s / U") . "\"></{$filename}>");
$querylangvar = MYSQL_QUERY("SELECT varname, lang_{$langid} FROM flobase_languagefiles WHERE filename='" . mysql_real_escape_string($filename) . "'");
while ($langvar = MYSQL_FETCH_ARRAY($querylangvar)) {
$newlangfile->{$langvar}['varname'] = $langvar['lang_' . $langid];
}
$newlangfile->asXML($langfile);
$florensia->notice("Language file and backup for {$langid}/{$filename} successfully created", "successful");
return true;
}
function displayCollapseList($id = '0', $idFull = '0', $note = null, $pageName = 'main')
{
// Find this .Notes object
$sql = "SELECT *, objects.id AS objectsId FROM wires, objects ";
$sql .= "WHERE wires.fromid = {$id} AND wires.toid = objects.id ";
$sql .= "AND objects.name1 LIKE '.Notes' ";
$sql .= "AND wires.active=1 AND objects.active=1 ";
$sql .= "LIMIT 1";
$result = MYSQL_QUERY($sql);
// Find connected objects
if ($myrow = MYSQL_FETCH_ARRAY($result)) {
$foundObjectId = $myrow['objectsId'];
$sql = "SELECT *, objects.id AS objectsId FROM wires, objects ";
$sql .= "WHERE wires.fromid = {$foundObjectId} AND wires.toid = objects.id ";
$sql .= "AND wires.active=1 AND objects.active=1 ";
$sql .= "ORDER BY rank ASC";
$result = MYSQL_QUERY($sql);
// Output collapseList
$i = 0;
$notes = explode(",", $note);
echo "\n\t<!-- collapseList -->";
echo "\n\n\t<ul class = 'ieFix'>";
while ($myrow = MYSQL_FETCH_ARRAY($result)) {
for ($ii = 0; $ii < count($notes); $ii++) {
if ($notes[$ii] == $myrow['objectsId']) {
$notesOut[$ii] = null;
} else {
$notesOut[$ii] = $notes[$ii];
}
}
$notesOutFiltered = array_filter($notesOut);
$noteOut = implode(",", $notesOutFiltered);
$noteOutStub = $noteOut ? $noteOut . "," : "";
echo in_array($myrow['objectsId'], $notes) ? "\n\t\t<li class = 'collapseListOpen'>\n\t\t\t\t\t\t- <a href='" . $pageName . ".html?id=" . $idFull . "&note=" . $noteOut . "'>" . $myrow["name1"] . "</a>" : "\n\t\t<li class = 'collapseListClosed'>\n\t\t\t\t\t\t+ <a href='" . $pageName . ".html?id=" . $idFull . "&note=" . $noteOutStub . $myrow['objectsId'] . "'>" . $myrow["name1"] . "</a>";
echo "\n\t<br /><br />" . $myrow["body"] . "<br/></li>";
$i++;
}
echo "\n\t</ul>";
}
}
function get_maplist_source($parentmap = "init", $substring = FALSE)
{
global $flocache;
if ($parentmap == "init") {
$parentmapquery = MYSQL_QUERY("SELECT mappicture, LTWH, mapid FROM server_map WHERE parentmap=''");
} else {
$parentmapquery = MYSQL_QUERY("SELECT mappicture, LTWH, mapid FROM server_map WHERE parentmap='{$parentmap}'");
}
while ($map = MYSQL_FETCH_ARRAY($parentmapquery)) {
if ($map['mapid'] == "BARRACK_000" or $map['mapid'] == "XC0_DK_000" or $map['mapid'] == "DOCK_000" or $map['mapid'] == "LOGIN_000") {
continue;
}
if (!$substring) {
$cachesubstring = $map['mapid'];
} else {
$cachesubstring = "{$substring},submaps,{$map['mapid']}";
}
$flocache->write_cache("maplist,{$cachesubstring},mapid", $map['mapid']);
$flocache->write_cache("maplist,{$cachesubstring},mappicture", $map['mappicture']);
$flocache->write_cache("maplist,{$cachesubstring},LTWH", $map['LTWH']);
$trashvar = $this->get_maplist_source($map['mapid'], $cachesubstring);
}
}
function createComboBox_tow($tables, $id_field, $value_field, $id_value, $field_name, $required = "", $actions = "", $cond = "")
{
$result = '<select name="' . $field_name . '" id="' . $field_name . '" class="' . $required . '" ' . $actions . ' >\\n';
if ($required == '') {
$result .= "<option></option>\n";
}
$arr_tables = explode(',', $tables);
foreach ($arr_tables as $table) {
$result .= "<optgroup label='{$table}'>";
$sql_combo = "SELECT {$id_field} , {$value_field} from {$table} {$cond} ORDER BY {$value_field}";
$def = substr($table, 0, 1);
$result_combo = MYSQL_QUERY($sql_combo);
checkError($result_combo, $sql_combo);
$rows_combo = MYSQL_NUM_ROWS($result_combo);
$i = 0;
while ($i < $rows_combo) {
$id = MYSQL_RESULT($result_combo, $i, $id_field);
$filds = explode(",", $value_field);
$ind = 0;
$value = "";
while ($ind < count($filds)) {
$value .= MYSQL_RESULT($result_combo, $i, $filds[$ind]) . " ";
$ind++;
}
$result .= "<option ";
if ($id_value != null && $id_value != "" && $id_value == $def . $id) {
$result .= "selected ";
}
$result .= "value=\"{$def}{$id}\">" . stripslashes($value) . "</option>\n";
$i++;
}
$result .= "</optgroup>";
}
$result .= "</select>\n";
return $result;
}
include_once "../common/dbConnection.php";
include_once "../common/header.php";
// Retreiving Form Elements from Form
$thisCONSTRAINT_CATALOG = addslashes($_REQUEST['thisCONSTRAINT_CATALOGField']);
$thisCONSTRAINT_SCHEMA = addslashes($_REQUEST['thisCONSTRAINT_SCHEMAField']);
$thisCONSTRAINT_NAME = addslashes($_REQUEST['thisCONSTRAINT_NAMEField']);
$thisUNIQUE_CONSTRAINT_CATALOG = addslashes($_REQUEST['thisUNIQUE_CONSTRAINT_CATALOGField']);
$thisUNIQUE_CONSTRAINT_SCHEMA = addslashes($_REQUEST['thisUNIQUE_CONSTRAINT_SCHEMAField']);
$thisUNIQUE_CONSTRAINT_NAME = addslashes($_REQUEST['thisUNIQUE_CONSTRAINT_NAMEField']);
$thisMATCH_OPTION = addslashes($_REQUEST['thisMATCH_OPTIONField']);
$thisUPDATE_RULE = addslashes($_REQUEST['thisUPDATE_RULEField']);
$thisDELETE_RULE = addslashes($_REQUEST['thisDELETE_RULEField']);
$thisTABLE_NAME = addslashes($_REQUEST['thisTABLE_NAMEField']);
$thisREFERENCED_TABLE_NAME = addslashes($_REQUEST['thisREFERENCED_TABLE_NAMEField']);
$sqlQuery = "INSERT INTO REFERENTIAL_CONSTRAINTS (CONSTRAINT_CATALOG , CONSTRAINT_SCHEMA , CONSTRAINT_NAME , UNIQUE_CONSTRAINT_CATALOG , UNIQUE_CONSTRAINT_SCHEMA , UNIQUE_CONSTRAINT_NAME , MATCH_OPTION , UPDATE_RULE , DELETE_RULE , TABLE_NAME , REFERENCED_TABLE_NAME ) VALUES ('{$thisCONSTRAINT_CATALOG}' , '{$thisCONSTRAINT_SCHEMA}' , '{$thisCONSTRAINT_NAME}' , '{$thisUNIQUE_CONSTRAINT_CATALOG}' , '{$thisUNIQUE_CONSTRAINT_SCHEMA}' , '{$thisUNIQUE_CONSTRAINT_NAME}' , '{$thisMATCH_OPTION}' , '{$thisUPDATE_RULE}' , '{$thisDELETE_RULE}' , '{$thisTABLE_NAME}' , '{$thisREFERENCED_TABLE_NAME}' )";
$result = MYSQL_QUERY($sqlQuery);
?>
A new record has been inserted in the database. Here is the information that has been inserted :- <br><br>
<table>
<tr height="30">
<td align="right"><b>CONSTRAINT_CATALOG : </b></td>
<td><?php
echo $thisCONSTRAINT_CATALOG;
?>
</td>
</tr>
<tr height="30">
<td align="right"><b>CONSTRAINT_SCHEMA : </b></td>
<td><?php
echo $thisCONSTRAINT_SCHEMA;
$querystring = "SELECT itemid FROM server_item_idtable WHERE tableid!='cloakitem' AND tableid!='hatitem' AND tableid!='upgradehelpitem' AND tableid!='sealhelpbreakitem' AND " . join(" AND ", $searchstring) . " ORDER BY name_{$stringtable->language}";
$formlink = $florensia->outlink(array("npcdetails", $_GET['npcid'], $stringtable->get_string($_GET['npcid'])), array(), array("anchor" => "droplist"));
$dropentryaddtolist = "\n\t\t\t<input type='hidden' value='" . $florensia->escape($_GET['npcid']) . "' name='npcid'>\n\t\t\t<input type='submit' value='{$flolang->droplist_search_item}'>\n\t\t";
}
$querystringlist = MYSQL_QUERY($querystring);
for ($i = 1; $entrylist = MYSQL_FETCH_ARRAY($querystringlist); $i++) {
if ($_GET['itemid']) {
list($amount) = MYSQL_FETCH_ARRAY(MYSQL_QUERY("SELECT COUNT(d.dropid) FROM flobase_droplist as d, flobase_droplist_ratings as r WHERE d.dropid=r.dropid AND d.npcid='" . $entrylist[$florensia->get_columnname("npcid", "npc")] . "' AND d.itemid='" . mysql_real_escape_string($_GET['itemid']) . "' AND r.userid='{$flouser->userid}'"));
if ($amount) {
continue;
}
$npc = new floclass_npc($entrylist[$florensia->get_columnname("npcid", "npc")]);
$entryshortinfo = $npc->shortinfo();
$checkbox = "droplist_thumpsup_" . $florensia->escape($_GET['itemid']) . "_" . $entrylist[$florensia->get_columnname("npcid", "npc")] . "_x";
} else {
list($amount) = MYSQL_FETCH_ARRAY(MYSQL_QUERY("SELECT COUNT(d.dropid) FROM flobase_droplist as d, flobase_droplist_ratings as r WHERE d.dropid=r.dropid AND d.npcid='" . mysql_real_escape_string($_GET['npcid']) . "' AND d.itemid='" . $entrylist['itemid'] . "' AND r.userid='{$flouser->userid}'"));
if ($amount) {
continue;
}
$item = new floclass_item($entrylist['itemid']);
$entryshortinfo = $item->shortinfo();
$checkbox = "droplist_thumpsup_" . $entrylist['itemid'] . "_" . $florensia->escape($_GET['npcid']) . "_x";
}
$content .= $florensia->adsense(10);
$colorchange = $florensia->change();
$content .= "\n\t\t\t\t\t<div style='margin-bottom:5px;'>\n\t\t\t\t\t\t<table style='width:100%' class='small'>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td class='shortinfo_{$colorchange}' style='text-align:center; vertical-align:middle; width:50px;'>\n\t\t\t\t\t\t\t\t\t<input type='checkbox' value='1' name='{$checkbox}'>\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t<td style='width:10px;'></td>\n\t\t\t\t\t\t\t\t<td class='shortinfo_{$colorchange}' style='vertical-align:top;'>\n\t\t\t\t\t\t\t\t\t{$entryshortinfo}\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t</table>\n\t\t\t\t\t</div>\n\t\t\t";
if ($i > 30) {
$content .= "<div style='text-align:center' class='warning'>{$flolang->droplist_addform_toomanyresults}</div>";
break;
}
}
// SMTP connection will not close after each email sent
$mail->Host = "mail.yourdomain.com";
// sets the SMTP server
$mail->Port = 26;
// set the SMTP port for the GMAIL server
$mail->Username = "******";
// SMTP account username
$mail->Password = "******";
// SMTP account password
$mail->SetFrom('*****@*****.**', 'List manager');
$mail->AddReplyTo('*****@*****.**', 'List manager');
$mail->Subject = "PHPMailer Test Subject via smtp, basic with authentication";
@MYSQL_CONNECT("localhost", "root", "password");
@mysql_select_db("my_company");
$query = "SELECT full_name, email, photo FROM employee WHERE id={$id}";
$result = @MYSQL_QUERY($query);
while ($row = mysql_fetch_array($result)) {
$mail->AltBody = "To view the message, please use an HTML compatible email viewer!";
// optional, comment out and test
$mail->MsgHTML($body);
$mail->AddAddress($row["email"], $row["full_name"]);
$mail->AddStringAttachment($row["photo"], "YourPhoto.jpg");
if (!$mail->Send()) {
echo "Mailer Error (" . str_replace("@", "@", $row["email"]) . ') ' . $mail->ErrorInfo . '<br />';
} else {
echo "Message sent to :" . $row["full_name"] . ' (' . str_replace("@", "@", $row["email"]) . ')<br />';
}
// Clear all addresses and attachments for next loop
$mail->ClearAddresses();
$mail->ClearAttachments();
}
$connect = mysql_connect($host, $us, $ps);
if ($connect) {
$db = 'filmidid';
mysql_select_db($db);
$query = "select id from user_login where eMail='{$eMail}'";
$result = MYSQL_QUERY($query);
$numberOfRows4name = MYSQL_NUM_ROWS($result);
$id4login = MYSQL_RESULT($result, 0, "id");
$query1 = "select * from blog_details where id='{$id4login}'";
$result1 = MYSQL_QUERY($query1);
$rows = mysql_num_rows($result1);
$query4job = "select * from jobs where id='{$id4login}'";
$result4job = MYSQL_QUERY($query4job);
$rows4job = mysql_num_rows($result4job);
$query4video = "select * from video_details where id='{$id4login}'";
$result4video = MYSQL_QUERY($query4video);
$rows4video = mysql_num_rows($result4video);
}
?>
<table width="980" class="up_nav" align="center" height="auto" cellspacing="0">
<tr>
<td class="nav_cur">Add Film</td>
<td>Add Question</td>
<td>Post a Job</td>
</tr>
</table>
<form method="post" action="includes/filmsucc.php" >
<script src="scripts/jquery-ui-1.10.3.custom.js"></script>
<div class="upload" style="display:block;">
<label>Paste your Video URL here:<br/><br/>
for ($x = 0; $x <= count($line); $x = $x + 2) {
if ($line[$x + 1] == 0) {
continue;
}
if (!preg_match('/^svop([0-9]+)$/', $line[$x], $effectid)) {
continue;
}
$effectquery = MYSQL_QUERY("SELECT name_" . $flolang->language . " FROM flobase_item_effect WHERE effectid='" . intval($effectid[1]) . "'");
$effect = MYSQL_FETCH_ARRAY($effectquery);
$attributestable[$i]['list'] .= "<tr><td class='small' style='width:150px;'>" . $effect['name_' . $flolang->language] . "</td><td class='small' style='text-align:right;'>" . bcdiv($line[$x + 1], 100) . "%</td></tr>";
}
}
for ($x = 0; $x <= $i; $x = $x + 2) {
$sealoptiontable .= "\n\t\t\t<tr><td style='width:50%;'>" . $attributestable[$x]['title'] . "</td><td style='width:50%;'>" . $attributestable[$x + 1]['title'] . "</td></tr>\n\t\t\t<tr><td><table style='border-collapse:0px; border-spacing:0px; padding:0px;'>" . $attributestable[$x]['list'] . "</table></td><td><table style='border-collapse:0px; border-spacing:0px; padding:0px;'>" . $attributestable[$x + 1]['list'] . "</table></td></tr>\n\t\t";
}
$seallistquery = MYSQL_QUERY("SELECT * FROM server_seal_breakcost");
while ($seallist = MYSQL_FETCH_ARRAY($seallistquery)) {
unset($needitem, $comma, $viewcount);
for ($i = 1; $i <= 5; $i++) {
if ($seallist['needitem' . $i] != "#") {
$needitem .= $comma . $seallist['needitem' . $i . 'count'] . " <a href='" . $florensia->outlink(array("itemdetails", $seallist['needitem' . $i], $stringtable->get_string($seallist['needitem' . $i]))) . "'>" . $stringtable->get_string($seallist['needitem' . $i], array('protectionlink' => 1, 'protectionsmall' => 1)) . "</a>";
$comma = ", ";
$viewcount++;
if ($viewcount == 3) {
$viewcount = 0;
$needitem .= "<br />";
unset($comma);
}
}
}
$costtable .= "<div class='shortinfo_" . $florensia->change() . " small'><table style='width:100%;'><tr><td style='width:60px;'><b>Level: " . $seallist['itemlevel'] . "</b></td><td style='width:70px; text-align:right; padding-right:20px;'>" . number_format($seallist['cost'], 0, '.', ',') . " Gelt</td><td>{$needitem}</td></tr></table></div>";
function get_entry($noteid)
{
global $flouser, $flouserdata, $stringtable, $classquest, $florensia, $flolang, $parser, $flolog;
$noteid = intval($noteid);
$querynotes = MYSQL_QUERY("SELECT id, section, sectionid, userid, language, dateline, writeip, moderated, commenttext, lastupdate FROM flobase_usernotes WHERE id={$noteid}");
if ($notes = MYSQL_FETCH_ARRAY($querynotes)) {
if ($flouser->get_permission("mod_usernotes", $notes['language']) && !($_POST['do_update_' . $noteid] && $_POST['delete_usernote_' . $noteid] && $_POST['delete_usernote_' . $noteid . '_verify'])) {
//check first if something has changes... moderated
if ($_POST['do_update_' . $noteid] && $_POST['moderated_usernote_' . $noteid]) {
if (!MYSQL_QUERY("UPDATE flobase_usernotes SET moderated='{$flouser->userid}," . date("U") . "' WHERE id='{$notes['id']}'")) {
$flolog->add("error:usernote", "MySQL-Update-Error while set {usernote:{$notes['id']}} from {user:{$notes['userid']}} written on {timestamp:{$notes['dateline']}} as moderated on {{$notes['section']}:{$notes['sectionid']}}");
$florensia->notice("An error occurred while set note ({$notes['id']}) to moderated", "warning");
} else {
$flolog->add("usernote:moderate", "{user:{$flouser->userid}} set {usernote:{$notes['id']}} from {user:{$notes['userid']}} written on {timestamp:{$notes['dateline']}} as moderated on {{$notes['section']}:{$notes['sectionid']}}");
$florensia->notice("Successful set note ({$notes['id']}) to moderated", "successful");
//set changed variables
$notes['moderated'] = "{$flouser->userid}," . date("U");
}
}
if ($flouser->get_permission("watch_log")) {
$adminipadress = " (<a href='{$florensia->root}/adminlog?currentip={$notes['writeip']}' target='_blank'>{$notes['writeip']}</a>)";
} else {
$adminipadress = " ({$notes['writeip']})";
}
if (!$notes['moderated']) {
$adminquickmod = "\n\t\t\t\t\t\t<span style='margin-left:10px;'>{$flolang->usernotes_moderate_title}: <input type='checkbox' name='moderated_usernote_" . $notes['id'] . "' value='1' style='vertical-align:middle; padding:0px; margin:0px;'></span>\n\t\t\t\t\t";
} else {
list($moduser, $modtime) = explode(",", $notes['moderated']);
$adminquickmod = "<span style='margin-left:10px;'>{$flolang->usernotes_moderate_title} " . date("m.d.y", $modtime) . " (" . $flouserdata->get_username($moduser) . ")</span>";
}
}
if ($notes['userid'] == $flouser->userid or $flouser->get_permission("mod_usernotes", $notes['language'])) {
//check first if something has changes... delete, update
if ($_POST['do_update_' . $noteid] && $_POST['delete_usernote_' . $noteid] && $_POST['delete_usernote_' . $noteid . '_verify']) {
if (!MYSQL_QUERY("DELETE FROM flobase_usernotes WHERE id='{$notes['id']}'")) {
$flolog->add("error:usernote", "MySQL-Delete-Error while delete {usernote:{$notes['id']}} from {user:{$notes['userid']}} written on {timestamp:{$notes['dateline']}} on {{$notes['section']}:{$notes['sectionid']}}");
$florensia->notice($flolang->usernotes_delete_error_notice, "warning");
} else {
$flolog->add("usernote:delete", "{user:{$flouser->userid}} deleted {usernote:{$notes['id']}} from {user:{$notes['userid']}} written on {timestamp:{$notes['dateline']}} on {{$notes['section']}:{$notes['sectionid']}}");
$florensia->notice($flolang->usernotes_delete_successful_notice, "successful");
//break and return nothing
return;
}
}
if ($_POST['do_update_' . $noteid] && strlen(trim($_POST['commenttext_update_' . $noteid])) && $flolang->lang[$_POST['noteslanguage']] && ($_POST['commenttext_update_' . $noteid] != $notes['commenttext'] or $_POST['noteslanguage'] != $notes['language'])) {
if (!MYSQL_QUERY("UPDATE flobase_usernotes SET language='{$_POST['noteslanguage']}', lastupdate='{$flouser->userid}," . date("U") . "', commenttext='" . mysql_real_escape_string($_POST['commenttext_update_' . $noteid]) . "' WHERE id='{$notes['id']}'")) {
$flolog->add("error:usernote", "MySQL-Update-Error while update {usernote:{$notes['id']}} from {user:{$notes['userid']}} written on {timestamp:{$notes['dateline']}} on {{$notes['section']}:{$notes['sectionid']}}");
$florensia->notice($flolang->usernotes_edit_error_notice, "warning");
} else {
$flolog->add("usernote:update", "{user:{$flouser->userid}} updated {usernote:{$notes['id']}} from {user:{$notes['userid']}} written on {timestamp:{$notes['dateline']}} on {{$notes['section']}:{$notes['sectionid']}}");
$florensia->notice($flolang->usernotes_edit_successful_notice, "successful");
//set changed variables
$notes['language'] = $_POST['noteslanguage'];
$notes['lastupdate'] = "{$flouser->userid}," . date("U");
$notes['commenttext'] = $_POST['commenttext_update_' . $noteid];
}
}
//----
$editlink = "<a href='javascript:switchlayer(\"usernotetext_{$noteid},usernotetext_{$noteid}_edit\", \"usernotetext_{$noteid}_edit\")'>[{$flolang->usernotes_editlink}]</a>";
$editform = "\n\t\t\t\t\t<div class='small' id='usernotetext_{$noteid}_edit' style='display:none;'>\n\t\t\t\t\t\t<div>" . $this->language_select($notes['language']) . " <span style='margin-left:10px;'>{$flolang->usernotes_delete_title}: <input type='checkbox' name='delete_usernote_" . $notes['id'] . "' value='1' style='vertical-align:middle; padding:0px; margin:0px 3px 0px 0px;'><input type='checkbox' name='delete_usernote_" . $notes['id'] . "_verify' value='1' style='vertical-align:middle; padding:0px; margin:0px;'></span>{$adminquickmod}</div>\n\t\t\t\t\t\t<div style='text-align:center;'>\n\t\t\t\t\t\t\t<textarea name='commenttext_update_{$noteid}' style='width:99%; height:100px;'>" . $florensia->escape($notes['commenttext']) . "</textarea>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t<div><table style='width:100%;'><tr>\n\t\t\t\t\t\t\t<td><input type='submit' name='do_update_{$noteid}' value='{$flolang->usernotes_savechanges_submit}'></td>\n\t\t\t\t\t\t\t<td style='text-align:right; font-weight:bold;'><a href='javascript:switchlayer(\"usernotetext_{$noteid},usernotetext_{$noteid}_edit\", \"usernotetext_{$noteid}\")'>[{$flolang->usernotes_cancellink}]</a></td>\n\t\t\t\t\t\t</tr></table></div>\n\t\t\t\t\t</div>\n\t\t\t\t";
}
if ($flouser->get_permission("mod_usernotes", $notes['language'])) {
switch ($notes['section']) {
case "quest":
$usernotelink = "Quest: <a href='" . $florensia->outlink(array("questdetails", $notes['sectionid'], $classquest->get_title($notes['sectionid'])), array("usernotes" => $notes['language']), array('anchor' => 'usernotes')) . "' target='_blank'>" . $classquest->get_title($notes['sectionid']) . "</a>";
break;
case "npc":
$usernotelink = "NPC: <a href='" . $florensia->outlink(array("npcdetails", $notes['sectionid'], $stringtable->get_string($notes['sectionid'])), array("usernotes" => $notes['language']), array('anchor' => 'usernotes')) . "' target='_blank'>" . $stringtable->get_string($notes['sectionid'], array('protectionlink' => 1, 'protectionsmall' => 1)) . "</a>";
break;
case "item":
$usernotelink = "Item: <a href='" . $florensia->outlink(array("itemdetails", $notes['sectionid'], $stringtable->get_string($notes['sectionid'])), array("usernotes" => $notes['language']), array('anchor' => 'usernotes')) . "' target='_blank'>" . $stringtable->get_string($notes['sectionid'], array('protectionlink' => 1, 'protectionsmall' => 1)) . "</a>";
break;
case "map":
$usernotelink = "Map: <a href='" . $florensia->outlink(array("mapdetails", $notes['sectionid'], $stringtable->get_string($notes['sectionid'])), array("usernotes" => $notes['language']), array('anchor' => 'usernotes')) . "' target='_blank'>" . $stringtable->get_string($notes['sectionid'], array('protectionlink' => 1, 'protectionsmall' => 1)) . "</a>";
break;
case "gallery":
$image = MYSQL_FETCH_ARRAY(MYSQL_QUERY("SELECT name FROM flobase_gallery WHERE galleryid='" . intval($notes['sectionid']) . "'"));
if (!strlen($image['name'])) {
$image['name'] = "-";
}
$usernotelink = "Image: <a href='" . $florensia->outlink(array("gallery", "i", $notes['sectionid'], $image['name']), array("usernotes" => $notes['language'])) . "' target='_blank'>" . $florensia->escape($image['name']) . "</a>";
break;
default:
$usernotelink = "--";
}
$usernotelink .= "<br />";
} else {
unset($usernotelink);
}
if ($notes['lastupdate']) {
list($luser, $ltime) = explode(",", $notes['lastupdate']);
$lastupdate = "<div class='small' style='text-align:right; margin-top:7px; font-style:italic;'>" . $flolang->sprintf($flolang->usernotes_lastupdate_notice, $flouserdata->get_username($luser), date("m.d.y", $ltime)) . "</div>";
}
return "\n\t\t\t<div>\n\t\t\t\t<form action='" . $florensia->escape($florensia->request_uri(array(), 'usernotes')) . "' method='post'>\n\t\t\t\t<div class='small subtitle' style='margin-top:10px;'>\n\t\t\t\t\t<table style='width:100%'>\n\t\t\t\t\t\t<tr><td style='vertical-align:top;'>\n\t\t\t\t\t\t\t<img src='{$florensia->layer_rel}/flags/png/" . $flolang->lang[$notes['language']]->flagid . ".png' alt='" . $flolang->lang[$notes['language']]->languagename . "' border='0'>\n\t\t\t\t\t\t\t" . $flouserdata->get_username($notes['userid']) . "{$adminipadress}<br />\n\t\t\t\t\t\t\t" . date("m.d.y - H:i", $notes['dateline']) . "\n\t\t\t\t\t\t</td><td style='text-align:right; vertical-align:top;'>\n\t\t\t\t\t\t\t{$usernotelink}\n\t\t\t\t\t\t\t{$editlink}\n\t\t\t\t\t\t</td></tr>\n\t\t\t\t\t</table>\n\t\t\t\t</div>\n\t\t\t\t<div class='shortinfo_1'>\n\t\t\t\t\t<div id='usernotetext_{$noteid}'>" . $parser->parse_message($notes['commenttext'], $this->parser_options) . "{$lastupdate}</div>\n\t\t\t\t\t{$editform}\n\t\t\t\t</div>\n\t\t\t\t</form>\n\t\t\t</div>\n\t\t\t";
}
return false;
}
<?php
require_once "./init.php";
if (!defined('is_florensia')) {
die('Hacking attempt');
}
MYSQL_QUERY("UPDATE flobase_sessions SET lastcaptcha='" . bcadd(date("U"), 86400) . "', antibot='1' WHERE sessionid = '{$mybb->cookies['sid']}'");
header("Location: " . $florensia->root);
$amountnotes = MYSQL_NUM_ROWS($querynoteslist);
$tabbar['usernotes']['desc'] = $flolang->sprintf($flolang->contributed_tabbar_desc_usernotes, $amountnotes);
$pageselect = $florensia->pageselect($amountnotes, array("contributed", $userid, $username), array('anchor' => 'usernotes'), 10);
$querynotes = MYSQL_QUERY($querystring . " ORDER BY section, dateline DESC LIMIT " . $pageselect['pagestart'] . ",10");
while ($notes = MYSQL_FETCH_ARRAY($querynotes)) {
$noteslistcontent .= $classusernote->get_entry($notes['id']);
}
$noteslistcontent = "\n <a name='usernotes'></a>\n <div name='usernotes' class='small'>\n <div style='margin-top:10px;'>" . $pageselect['selectbar'] . "</div>\n {$noteslistcontent}\n <div style='margin-top:10px;'>" . $pageselect['selectbar'] . "</div>\n </div>\n ";
}
if ($userid == $flouser->userid or $flouser->get_permission("watch_log")) {
$querystring = "SELECT class, classid FROM flobase_addition WHERE entrystatus LIKE '%,{$userid},%'";
$flagsquery = MYSQL_QUERY($querystring);
$amountflags = MYSQL_NUM_ROWS($flagsquery);
$tabbar['flags']['desc'] = $flolang->sprintf($flolang->contributed_tabbar_desc_flags, $amountflags);
$pageselect = $florensia->pageselect($amountflags, array("contributed", $userid, $username), array('anchor' => 'flags'), 20);
$flagsquery = MYSQL_QUERY($querystring . " ORDER BY class LIMIT " . $pageselect['pagestart'] . ",20");
while ($flags = MYSQL_FETCH_ARRAY($flagsquery)) {
switch ($flags['class']) {
case "npc":
$npc = new floclass_npc($flags['classid']);
$flagscontent .= "<div class='shortinfo_" . $florensia->change() . "'>" . $npc->shortinfo() . "</div>";
break;
case "item":
$item = new floclass_item($flags['classid']);
$flagscontent .= "<div class='shortinfo_" . $florensia->change() . "'>" . $item->shortinfo() . "</div>";
break;
case "quest":
$flagscontent .= "<div class='shortinfo_" . $florensia->change() . "'>" . $classquest->get_shortinfo($flags['classid']) . "</div>";
break;
}
}
$florensia->sitetitle("Characterverification");
$florensia->sitetitle($florensia->escape($_GET['verify']));
$florensia->output_page($content);
}
//$florensia->notice("<div class='warning' style='margin-bottom:10px;'>{$flolang->signature_api_failnotice}</div>");
if (!is_file("{$florensia->charapi}/ranking.keepup2date.pid")) {
$running = "<div class='warning subtitle' style='padding:2px;'>{$flolang->character_api_notice_notrunning}</div>";
$forcedupdated = "<div class='warning' style='padding:2px;'>{$flolang->character_api_notice_notrunning}</div>";
} else {
$running = "<div class='successful subtitle' style='padding:2px;'>{$flolang->character_api_notice_running}</div>";
$queryforced = MYSQL_QUERY("SELECT charname FROM flobase_character WHERE forceupdate='1' ORDER BY lastupdate DESC LIMIT 15");
for ($i = 1; $forced = MYSQL_FETCH_ARRAY($queryforced); $i++) {
$forcedupdated .= "<a href='" . $florensia->outlink(array('characterdetails', $forced['charname'])) . "'>" . $florensia->escape($forced['charname']) . "</a><br />";
if ($i >= 15) {
$forcedupdated .= "...";
}
}
if (!$forcedupdated) {
$forcedupdated = $flolang->character_api_notice_forcedupdatechars_noentry;
}
}
$faqs = array('de' => 5604, 'en' => 5605, 'fr' => 5610, 'es' => 5624, 'pt' => 5714);
foreach ($faqs as $lang => $tid) {
$tid = MYSQL_FETCH_ARRAY(MYSQL_QUERY("SELECT tid, subject FROM forum_threads WHERE tid={$tid}"));
if (!$tid) {
continue;
}
$faqlist .= "<div><img src='{$florensia->layer_rel}/flags/png/" . $flolang->lang[$lang]->flagid . ".png' alt='" . $flolang->lang[$lang]->languagename . "' title='" . $flolang->lang[$lang]->languagename . "' border='0'> - <a href='{$florensia->forumurl}/thread-{$tid['tid']}.html' target='_blank'>{$tid['subject']}</a></div>";
}
$content = "\n <div class='small'>\n {$running}\n <div style='height:10px;'></div>\n <div class='bordered' style='float:right; width:200px; padding:6px; margin:0px 0px 10px 10px;'>\n <b>{$flolang->character_api_title_forcedupdatechars}</b><br />\n {$forcedupdated}\n </div>\n {$faqlist}\n </div>\n \n";
$florensia->output_page($content);
return date("H:i:s", strtotime("1980-01-01 00:00:00") + ($time1 - $time2));
}
include "../include/data.php";
$connect = mysql_connect($host, $us, $ps);
if ($connect) {
$db = 'vitbifi';
mysql_select_db($db);
}
$sqlQuery4menu = "select DISTINCT menuId, orderTime from menu where 1";
$result4menu = MYSQL_QUERY($sqlQuery4menu);
$numberOfRows4menu = MYSQL_NUM_ROWS($result4menu);
$sqlQuery4avail = "select DISTINCT menuId, time, link from delivery_time";
$result4avail = MYSQL_QUERY($sqlQuery4avail);
$numberOfRows4avail = MYSQL_NUM_ROWS($result4avail);
$sqlQuery4qty = "select DISTINCT link from quantity;";
$result4qty = MYSQL_QUERY($sqlQuery4qty);
$numberOfRows4qty = MYSQL_NUM_ROWS($result4qty);
$i = 0;
while ($i < $numberOfRows4qty) {
$menuQty[$i]['link'] = MYSQL_RESULT($result4qty, $i, "link");
$i++;
}
$i = 0;
while ($i < $numberOfRows4avail) {
$menuAvail[$i]['menuId'] = MYSQL_RESULT($result4avail, $i, "menuId");
$menuAvail[$i]['deliveryTime'] = MYSQL_RESULT($result4avail, $i, "time");
$menuAvail[$i]['link'] = MYSQL_RESULT($result4avail, $i, "link");
$i++;
}
$i = 0;
while ($i < $numberOfRows4menu) {
case "damagereflectionpercent":
$details[$columns['code_korean']] = $details[$columns['code_korean']] * 100;
$write = write($columns['name_' . $flolang->language], $details[$columns['code_korean']] . $columns['endvalue'], $columns['code_english']);
break;
default:
$write = write($columns['name_' . $flolang->language], $details[$columns['code_korean']] . $columns['endvalue'], $columns['code_english']);
break;
}
}
}
//Additional infos for skillbooks
if (isset($itemtable['tableid']) && $itemtable['tableid'] == "skillbookitem") {
//for ($i=1; $i<3; $i++) {
// if ($i==1) $querydescription = MYSQL_QUERY("SELECT * FROM server_skill WHERE ".$florensia->get_columnname("bookid", "skill")."='".$details[$florensia->get_columnname("description", "item")]."' ORDER BY ".$florensia->get_columnname("skillid", "skill")."");
// else $querydescription = MYSQL_QUERY("SELECT * FROM server_spell WHERE ".$florensia->get_columnname("bookid", "skill")."='".$details[$florensia->get_columnname("description", "item")]."' ORDER BY ".$florensia->get_columnname("skillid", "skill")."");
$querydescription = MYSQL_QUERY("SELECT " . $florensia->get_columnname("masterlevel", "skill") . "," . $florensia->get_columnname("classid", "skill") . " FROM server_skill WHERE " . $florensia->get_columnname("bookid", "skill") . "='" . $details[$florensia->get_columnname("description", "item")] . "' ORDER BY " . $florensia->get_columnname("skillid", "skill") . "");
if ($description = MYSQL_FETCH_ARRAY($querydescription)) {
foreach ($florensia->get_classname($description[$florensia->get_columnname("classid", "skill")], "land") as $key => $classid) {
$write = write("Class", $classid, "skillclass");
}
foreach ($florensia->get_classname($description[$florensia->get_columnname("classid", "skill")], "sea") as $key => $classid) {
$write = write("Class", $classid, "skillclass");
}
$write = write("Max. Level", $description[$florensia->get_columnname("masterlevel", "skill")], "skillmasterlevel");
//break;
}
//}
}
} else {
$columnall_y += $steps;
$column['Error'] = "Error: No details were found.";
if ($sortOrder == "") {
$sortOrder = "DESC";
}
if ($sortOrder == "DESC") {
$newSortOrder = "ASC";
} else {
$newSortOrder = "DESC";
}
$limitQuery = " LIMIT " . $startLimit . "," . $numberOfRows;
$nextStartLimit = $startLimit + $limitPerPage;
$previousStartLimit = $startLimit - $limitPerPage;
if ($sortBy != "") {
$orderByQuery = " ORDER BY " . $sortBy . " " . $sortOrder;
}
$sql = "SELECT * FROM INNODB_BUFFER_POOL_STATS" . $orderByQuery . $limitQuery;
$result = MYSQL_QUERY($sql);
$numberOfRows = MYSQL_NUM_ROWS($result);
if ($numberOfRows == 0) {
?>
Sorry. No records found !!
<?php
} else {
if ($numberOfRows > 0) {
$i = 0;
?>
<br>
<?php
$droplist = "\n\t\t\t\t\t<div name='droplist' style='margin-bottom:15px; margin-top:15px;'>" . $classdroplist->get_droplist($item->data[$florensia->get_columnname("itemid", "item")], "item") . "</div>\n\t\t\t\t";
$tabbar['droplist']['desc'] = $classdroplist->get_tabdesc($item->data[$florensia->get_columnname("itemid", "item")], "item");
} else {
unset($tabbar['droplist']);
}
//usernotes
$usernotes = $classusernote->display($item->data[$florensia->get_columnname("itemid", "item")], "item");
$tabbar['usernotes']['desc'] = $classusernote->get_tabdesc($item->data[$florensia->get_columnname("itemid", "item")], "item");
//market
//set var first because add/delete is performed while functions run. so it need to runs first
$marketquickform = $classusermarket->quickform($item->data[$florensia->get_columnname("itemid", "item")]);
$sellers = 0;
$buyers = 0;
$querytradelist = MYSQL_QUERY("SELECT userid, createtime, charname, timeout, itemid, itemamount, server, exchangetype, exchange, exchangegelt, marketlanguage FROM flobase_usermarket as m, flobase_character as c WHERE itemid='" . mysql_real_escape_string($item->data[$florensia->get_columnname("itemid", "item")]) . "' AND m.characterid=c.characterid ORDER BY createtime");
while ($tradelist = MYSQL_FETCH_ARRAY($querytradelist)) {
$queryforumuser = MYSQL_QUERY("SELECT username FROM forum_users WHERE uid='" . $tradelist['userid'] . "'");
if (!($forumuser = MYSQL_FETCH_ARRAY($queryforumuser))) {
continue;
}
unset($marketlanguage);
$marketlanguagelist = explode(",", $tradelist['marketlanguage']);
foreach ($marketlanguagelist as $languageid) {
$marketlanguage .= "<img src='{$florensia->layer_rel}/flags/png/" . $flolang->lang[$languageid]->flagid . ".png' alt='" . $flolang->lang[$languageid]->languagename . "' title='" . $flolang->lang[$languageid]->languagename . "' border='0'> ";
}
if ($tradelist['exchange'] != "") {
$tradelist['exchange'] = "<tr><td>{$flolang->market_details_info_exchange}</td><td>" . $parser->parse_message($tradelist['exchange'], array("allow_mycode" => 1, "filter_badwords" => 1)) . "</td></tr>";
} else {
unset($tradelist['exchange']);
}
if ($tradelist['exchangegelt']) {
$tradelist['exchangegelt'] = "<tr><td>Gelt:</td><td>" . get_geltstring($tradelist['exchangegelt'], $tradelist['itemamount']) . " Gelt</td></tr>";
