function escapeString($string) { if (Framework::getDb() != null) { return mysql_real_escape_string($string, Framework::getDb()->getLink()); } return mysql_escape_string($string); }
public function loadHits() { $page = $_SERVER['REQUEST_URI']; $rowAll = Framework::getDb()->getFirstRow("SELECT SUM(hits) AS hits FROM page_hits WHERE page = '" . esc($page) . "'"); $rowToday = Framework::getDb()->getFirstRow("SELECT SUM(hits) AS hits FROM page_hits WHERE page = '" . esc($page) . "' AND added >= DATE_FORMAT('Y-m-d', NOW())"); $rowMonth = Framework::getDb()->getFirstRow("SELECT SUM(hits) AS hits FROM page_hits WHERE page = '" . esc($page) . "' AND added >= DATE_FORMAT('Y-m', NOW())"); $rowYear = Framework::getDb()->getFirstRow("SELECT SUM(hits) AS hits FROM page_hits WHERE page = '" . esc($page) . "' AND added >= DATE_FORMAT('Y', NOW())"); $this->PageHits = array('all' => $rowAll ? $rowAll['hits'] : 0, 'today' => $rowToday ? $rowToday['hits'] : 0, 'month' => $rowMonth ? $rowMonth['hits'] : 0, 'hits' => $rowYear ? $rowYear['hits'] : 0); }
public function save() { // Add vender to the database or set to online $query = "SELECT char_id FROM " . self::TABLE . " WHERE char_id = '" . esc($this->id) . "'"; $row = Framework::getDb()->getFirstRow($query); if ($row != null) { // Vender found, update it // Note: update name incase of name-change $query = "\n\t\t\t\t\tUPDATE " . self::TABLE . " SET \n\t\t\t\t\t\tname = '" . esc($this->name) . "', \n\t\t\t\t\t\tshopname = '" . esc($this->shopname) . "',\n\t\t\t\t\t\tposX = '" . esc($this->posX) . "', \n\t\t\t\t\t\tposY = '" . esc($this->posY) . "', \n\t\t\t\t\t\tposMap = '" . esc($this->posMap) . "', \n\t\t\t\t\t\tonline = 1,\n\t\t\t\t\t\tseen = NOW()\n\t\t\t\t\tWHERE char_id = '" . esc($this->id) . "'\n\t\t\t\t"; } else { // New entry $query = "\n\t\t\t\t\tINSERT INTO " . self::TABLE . "\n\t\t\t\t\t\t(char_id, name, shopname, posX, posY, posMap, seen, online)\n\t\t\t\t\tVALUES\n\t\t\t\t\t\t('" . esc($this->id) . "', '" . esc($this->name) . "', '" . esc($this->shopname) . "', '" . esc($this->posX) . "', '" . esc($this->posY) . "', '" . esc($this->posMap) . "', NOW(), '1')\n\t\t\t\t"; } Framework::getDb()->query($query); }
private function updateAvg() { // Check if the item exists (item_id, refine, slots) $query = "SELECT * FROM " . self::TABLE_PRICE . " WHERE item_hash = '" . esc($this->getHash()) . "'"; $row = Framework::getDb()->getFirstRow($query); if ($row != null) { // Found, update price sum (single price) $query = "UPDATE " . self::TABLE_PRICE . " SET price_sum = price_sum + " . esc($this->price_one) . ", `count` = `count` + 1 WHERE item_hash = '" . esc($this->getHash()) . "'"; Framework::getDb()->query($query); } else { // Add new $query = "\n\t\t\t\t\t\tINSERT INTO `" . self::TABLE_PRICE . "` \n\t\t\t\t\t\t\t(`item_hash`, `item_id`, `price_sum`, `count`, `last_update`) \n\t\t\t\t\t\tVALUES \n\t\t\t\t\t\t\t('" . esc($this->getHash()) . "', '" . esc($this->id) . "', '" . esc($this->price_one) . "', '1', NOW())"; Framework::getDb()->query($query); } }
public static function resultToXML($result, $tagName, $filepath) { $doc = new DOMDocument(); $doc->formatOutput = true; $items = $doc->createElement('items'); $doc->appendChild($items); while ($row = Framework::getDb()->fetch($result)) { $item = $doc->createElement($tagName); foreach ($row as $key => $value) { $item->appendChild($doc->createElement($key, $value)); } $items->appendChild($item); } if (@file_exists($filepath) == true) { unlink($filepath); } $doc->save($filepath); }
<?php set_time_limit(0); error_reporting(E_ALL); define('NO_SESSION', true); require_once '../../global.php'; // French $data_fr = loadDescription('D:/Games/data/french/idnum2itemdesctable.txt'); // English (not yet done by fRO? Oo) //$data_en = loadDescription('D:/Games/data/english/idnum2itemdesctable.txt'); // Import French foreach ($data_fr as $ID => $lines) { echo '[FR] update #' . $ID . '<br />'; $text = formatText($lines); Framework::getDb()->query("UPDATE item_db SET description_fr = '" . esc($text) . "' WHERE id = '" . esc($ID) . "'"); } // Import english /* foreach ($data_en as $ID => $lines) { echo '[EN] update #' . $ID . '<br />'; $text = implode("\n", $lines); Framework::getDb()->query("UPDATE item_db SET description_en = '" . esc($text) . "' WHERE id = '" . esc($ID) . "'"); } */ exit('done'); function loadDescription($filepath) { $data = array(); $lines = file($filepath); $currentID = null; foreach ($lines as $line) {
<?php require_once dirname(__FILE__) . '/../../global.php'; $t = '##||##'; $vender = base64_encode(1) . $t . base64_encode('GodLesZ') . $t . base64_encode('ROPrice test') . $t . base64_encode(159) . $t . base64_encode(159) . $t . base64_encode('prontera'); $result = Framework::getDb()->fetchAll("SELECT * FROM item_db WHERE id >= 501 AND id <= 510"); foreach ($result as $row) { $h = fopen('data/data_' . date('Y-m-d_H-i') . '_' . rand() . '.txt', 'w+'); // Build random $price = $row['price_buy'] + (rand(1, 2) == 1 ? rand(10, 100) : 0); $amount = rand(10, 100); $price *= $amount; // In RO we get the price for all items $refine = 0; $card0 = 0; $card1 = 0; $card2 = 0; $card3 = 0; $item = base64_encode($row['id']) . $t . base64_encode($row['name_japanese']) . $t . base64_encode($price) . $t . base64_encode($amount) . $t . base64_encode($refine) . $t . base64_encode($card0) . $t . base64_encode($card1) . $t . base64_encode($card2) . $t . base64_encode($card3); $line = $vender . "\t" . $item . "\n"; fwrite($h, $line); fclose($h); }
public function getDb() { return Framework::getDb(); }
public function updateDatabase($debug = false) { $keys = array(); $values = array(); $query = ''; if ($this->ID == null) { foreach ($this->_Params as $key => $propertie) { if ($this->{$propertie} != null) { $keys[] = '`' . $key . '`'; $values[] = "'" . escapeString($this->{$propertie}) . "'"; } } $query = "INSERT INTO `" . $this->getDBName() . "` (" . implode(', ', $keys) . ") VALUES (" . implode(', ', $values) . ")"; Framework::getDb()->query($query); if (($lastID = Framework::getDb()->getLastID()) != 0) { $this->ID = $lastID; } } else { foreach ($this->_Params as $key => $propertie) { if ($key != 'id') { $values[] = "`" . $key . "` = '" . escapeString($this->{$propertie}) . "'"; } } $query = "UPDATE `" . $this->getDBName() . "` SET " . implode(', ', $values) . " WHERE `id` = '" . escapeString($this->ID) . "'"; if ($debug == true) { echo '<pre>'; //print_r($this); echo '<strong>Query</strong>: ' . $query . '<br />'; echo '</pre>'; } Framework::getDb()->query($query); } return true; }