<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv='Content-Type' content='text/html; charset=utf-8'/>
<title>File Source for DBWorker.class.php</title>
<link rel="stylesheet" href="../media/stylesheet.css" />
</head>
<body>
<h1>Source for file DBWorker.class.php</h1>
<p>Documentation is available at <a href="../energine/core/_framework---DBWorker.class.php.html">DBWorker.class.php</a></p>
<div class="src-code">
<div class="src-code"><ol><li><div class="src-line"><a name="a1"></a><span class="src-php"><?php</span></div></li>
<li><div class="src-line"><a name="a2"></a><span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a3"></a><span class="src-doc"> * ÐлаÑÑ DBWorker.</span></div></li>
<li><div class="src-line"><a name="a4"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a5"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@package</span><span class="src-doc"> energine</span></div></li>
<li><div class="src-line"><a name="a6"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@subpackage</span><span class="src-doc"> core</span></div></li>
<li><div class="src-line"><a name="a7"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@author</span><span class="src-doc"> 1m.dm</span></div></li>
<li><div class="src-line"><a name="a8"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@copyright</span><span class="src-doc"> ColoCall 2006</span></div></li>
<li><div class="src-line"><a name="a9"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@version</span><span class="src-doc"> $Id: fsource_energine_core_frameworkDBWorker.class.php.html,v 1.1 2007/10/24 16:10:04 pavka Exp $</span></div></li>
<li><div class="src-line"><a name="a10"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a11"></a> </div></li>
<li><div class="src-line"><a name="a12"></a><span class="src-inc">require_once </span><span class="src-str">'core/framework/SystemConfig.class.php'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a13"></a><span class="src-inc">require_once </span><span class="src-str">'core/framework/QAL.class.php'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a14"></a> </div></li>
<li><div class="src-line"><a name="a15"></a><span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a16"></a><span class="src-doc"> * ÐÑедоÑÑавлÑÐµÑ Ð¿ÑоизводнÑм клаÑÑам ÑÑÑÐ»ÐºÑ Ð½Ð° обÑÐµÐºÑ Ð´Ð»Ñ ÑабоÑÑ Ñ ÐÐ.</span></div></li>
<li><div class="src-line"><a name="a17"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a18"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@package</span><span class="src-doc"> energine</span></div></li>
<li><div class="src-line"><a name="a19"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@subpackage</span><span class="src-doc"> core</span></div></li>
<li><div class="src-line"><a name="a20"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@abstract</span></div></li>
<li><div class="src-line"><a name="a21"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a22"></a><span class="src-key">abstract </span><span class="src-key">class </span><a href="../energine/core/DBWorker.html">DBWorker</a> <span class="src-key">extends </span><a href="../energine/core/SystemConfig.html">SystemConfig</a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a23"></a> </div></li>
<li><div class="src-line"><a name="a24"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a25"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@access</span><span class="src-doc"> protected</span></div></li>
<li><div class="src-line"><a name="a26"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@static</span></div></li>
<li><div class="src-line"><a name="a27"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@var </span><span class="src-doc-type">QAL </span><span class="src-doc">единÑй Ð´Ð»Ñ Ð²ÑеÑ
ÑкземплÑÑов клаÑÑа обÑÐµÐºÑ QAL</span></div></li>
<li><div class="src-line"><a name="a28"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a29"></a> <span class="src-key">protected </span><span class="src-key">static </span><span class="src-var">$dbhInstance</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a30"></a> </div></li>
<li><div class="src-line"><a name="a31"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a32"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@access</span><span class="src-doc"> protected</span></div></li>
<li><div class="src-line"><a name="a33"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@var </span><span class="src-doc-type">QAL </span><span class="src-doc">ÑÑÑлка на self::$dbhInstance (Ð´Ð»Ñ Ð¿ÑоизводнÑÑ
клаÑÑов)</span></div></li>
<li><div class="src-line"><a name="a34"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a35"></a> <span class="src-key">protected </span><a href="../energine/core/DBWorker.html#var$dbh">$dbh</a><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a36"></a> </div></li>
<li><div class="src-line"><a name="a37"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a38"></a><span class="src-doc"> * ÐонÑÑÑÑкÑÐ¾Ñ ÐºÐ»Ð°ÑÑа.</span></div></li>
<li><div class="src-line"><a name="a39"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a40"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@access</span><span class="src-doc"> public</span></div></li>
<li><div class="src-line"><a name="a41"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">void </span></div></li>
<li><div class="src-line"><a name="a42"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a43"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../energine/core/DBWorker.html#method__construct">__construct</a><span class="src-sym">(</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a44"></a> <span class="src-id">parent</span><span class="src-sym">::</span><a href="../energine/core/SystemConfig.html#method__construct">__construct</a><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a45"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-sym">!</span>isset<span class="src-sym">(</span><span class="src-id">self</span><span class="src-sym">::</span><span class="src-var">$dbhInstance</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a46"></a> <span class="src-var">$dsn </span>= <span class="src-id">sprintf</span><span class="src-sym">(</span><span class="src-str">'mysql:host=%s;dbname=%s'</span><span class="src-sym">, </span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../energine/core/SystemConfig.html#methodgetConfigValue">getConfigValue</a><span class="src-sym">(</span><span class="src-str">'database.host'</span><span class="src-sym">)</span><span class="src-sym">, </span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../energine/core/SystemConfig.html#methodgetConfigValue">getConfigValue</a><span class="src-sym">(</span><span class="src-str">'database.name'</span><span class="src-sym">))</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a47"></a> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-var">$dbhInstance </span>= <span class="src-key">new </span><span class="src-id">QAL</span><span class="src-sym">(</span></div></li>
<li><div class="src-line"><a name="a48"></a> <span class="src-var">$dsn</span><span class="src-sym">,</span></div></li>
<li><div class="src-line"><a name="a49"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../energine/core/SystemConfig.html#methodgetConfigValue">getConfigValue</a><span class="src-sym">(</span><span class="src-str">'database.username'</span><span class="src-sym">)</span><span class="src-sym">,</span></div></li>
<li><div class="src-line"><a name="a50"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../energine/core/SystemConfig.html#methodgetConfigValue">getConfigValue</a><span class="src-sym">(</span><span class="src-str">'database.password'</span><span class="src-sym">)</span><span class="src-sym">,</span></div></li>
<li><div class="src-line"><a name="a51"></a> <span class="src-key">array</span><span class="src-sym">(</span></div></li>
<li><div class="src-line"><a name="a52"></a> <span class="src-id">PDO</span><span class="src-sym">::</span><span class="src-id">ATTR_PERSISTENT </span>=> <span class="src-id">false</span><span class="src-sym">,</span></div></li>
<li><div class="src-line"><a name="a53"></a> <span class="src-id">PDO</span><span class="src-sym">::</span><span class="src-id">ATTR_EMULATE_PREPARES </span>=> <span class="src-id">true</span><span class="src-sym">,</span></div></li>
<li><div class="src-line"><a name="a54"></a> <span class="src-id">PDO</span><span class="src-sym">::</span><span class="src-id">MYSQL_ATTR_USE_BUFFERED_QUERY </span>=> <span class="src-id">true</span></div></li>
<li><div class="src-line"><a name="a55"></a> <span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a56"></a> <span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a57"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a58"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../energine/core/DBWorker.html#var$dbh">dbh</a> = <span class="src-id">self</span><span class="src-sym">::</span><span class="src-var">$dbhInstance</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a59"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a60"></a> </div></li>
<li><div class="src-line"><a name="a61"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a62"></a><span class="src-doc"> * ÐозвÑаÑÐ°ÐµÑ Ð¿ÐµÑевод ÑекÑÑовой конÑÑанÑÑ Ð¸Ð· ÑаблиÑÑ Ð¿ÐµÑеводов длÑ</span></div></li>
<li><div class="src-line"><a name="a63"></a><span class="src-doc"> * Ñказанного ÑзÑка. ÐÑли ÑзÑк Ñвно не Ñказан - иÑполÑзÑеÑÑÑ ÑекÑÑий ÑзÑк.</span></div></li>
<li><div class="src-line"><a name="a64"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a65"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@access</span><span class="src-doc"> public</span></div></li>
<li><div class="src-line"><a name="a66"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@static</span></div></li>
<li><div class="src-line"><a name="a67"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$const </span><span class="src-doc">ÑекÑÑÐ¾Ð²Ð°Ñ ÐºÐ¾Ð½ÑÑанÑа</span></div></li>
<li><div class="src-line"><a name="a68"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">int </span><span class="src-doc-var">$langId </span><span class="src-doc">ÑзÑк Ð´Ð»Ñ Ð¿ÐµÑевода</span></div></li>
<li><div class="src-line"><a name="a69"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">string </span></div></li>
<li><div class="src-line"><a name="a70"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a71"></a> <span class="src-key">public </span><span class="src-key">static </span><span class="src-key">function </span><a href="../energine/core/DBWorker.html#method_translate">_translate</a><span class="src-sym">(</span><span class="src-var">$const</span><span class="src-sym">, </span><span class="src-var">$langId </span>= <span class="src-id">null</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a72"></a> <span class="src-var">$result </span>= <span class="src-var">$const</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a73"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-sym">!</span>isset<span class="src-sym">(</span><span class="src-var">$langId</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a74"></a> <span class="src-var">$langId </span>= <span class="src-id">Language</span><span class="src-sym">::</span><span class="src-id">getInstance</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">-></span><span class="src-id">getCurrent</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a75"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a76"></a> </div></li>
<li><div class="src-line"><a name="a77"></a> <span class="src-var">$res </span>= <span class="src-id">self</span><span class="src-sym">::</span><span class="src-var">$dbhInstance</span><span class="src-sym">-></span><span class="src-id">selectRequest</span><span class="src-sym">(</span></div></li>
<li><div class="src-line"><a name="a78"></a> <span class="src-str">'SELECT trans.ltag_value_rtf AS result FROM share_LangTags ltag '</span>.</div></li>
<li><div class="src-line"><a name="a79"></a> <span class="src-str">'LEFT JOIN share_LangTags_translation trans ON trans.ltag_id = ltag.ltag_id '</span>.</div></li>
<li><div class="src-line"><a name="a80"></a> <span class="src-str">'WHERE ltag.ltag_name = '</span>.<span class="src-id">self</span><span class="src-sym">::</span><span class="src-var">$dbhInstance</span><span class="src-sym">-></span><span class="src-id">quote</span><span class="src-sym">(</span><span class="src-id">strtoupper</span><span class="src-sym">(</span><span class="src-var">$result</span><span class="src-sym">))</span>.<span class="src-str">' AND lang_id = '</span>.<a href="http://www.php.net/intval">intval</a><span class="src-sym">(</span><span class="src-var">$langId</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a81"></a> <span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a82"></a> </div></li>
<li><div class="src-line"><a name="a83"></a> <span class="src-key">if </span><span class="src-sym">(</span><a href="http://www.php.net/is_array">is_array</a><span class="src-sym">(</span><span class="src-var">$res</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a84"></a> <span class="src-var">$result </span>= <a href="../energine/core/_framework---utils.func.php.html#functionsimplifyDBResult">simplifyDBResult</a><span class="src-sym">(</span><span class="src-var">$res</span><span class="src-sym">, </span><span class="src-str">'result'</span><span class="src-sym">, </span><span class="src-id">true</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a85"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a86"></a> </div></li>
<li><div class="src-line"><a name="a87"></a> <span class="src-key">return </span><span class="src-var">$result</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a88"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a89"></a> </div></li>
<li><div class="src-line"><a name="a90"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a91"></a><span class="src-doc"> * ÐеÑÑаÑиÑеÑкий меÑод-обÑÑÑка над DBWorker::_translate -</span></div></li>
<li><div class="src-line"><a name="a92"></a><span class="src-doc"> * Ð´Ð»Ñ ÑдобÑÑва иÑполÑÐ·Ð¾Ð²Ð°Ð½Ð¸Ñ Ð²Ð½ÑÑÑи пÑоизводнÑÑ
клаÑÑов.</span></div></li>
<li><div class="src-line"><a name="a93"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a94"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@access</span><span class="src-doc"> public</span></div></li>
<li><div class="src-line"><a name="a95"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$const </span><span class="src-doc">ÑекÑÑÐ¾Ð²Ð°Ñ ÐºÐ¾Ð½ÑÑанÑа</span></div></li>
<li><div class="src-line"><a name="a96"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">int </span><span class="src-doc-var">$langId </span><span class="src-doc">ÑзÑк Ð´Ð»Ñ Ð¿ÐµÑевода</span></div></li>
<li><div class="src-line"><a name="a97"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">string </span></div></li>
<li><div class="src-line"><a name="a98"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@see</span><span class="src-doc"> DBWorker::_translate()</span></div></li>
<li><div class="src-line"><a name="a99"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a100"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../energine/core/DBWorker.html#methodtranslate">translate</a><span class="src-sym">(</span><span class="src-var">$const</span><span class="src-sym">, </span><span class="src-var">$langID </span>= <span class="src-id">null</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a101"></a> <span class="src-key">return </span><span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">_translate</span><span class="src-sym">(</span><span class="src-var">$const</span><span class="src-sym">, </span><span class="src-var">$langID</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a102"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a103"></a><span class="src-sym">}</span></div></li>
</ol></div>
</div>
<p class="notes" id="credit">
Documentation generated on Mon, 17 Sep 2007 13:27:22 +0300 by <a href="http://www.phpdoc.org" target="_blank">phpDocumentor 1.4.0a2</a>
</p>
</body>
</html>