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>";