PHP Framework::getDb方法代码示例

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