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