if (defined('DEV') && DEV) {
                $db->exec('SET SQL_MODE="ANSI_QUOTES,ONLY_FULL_GROUP_BY,STRICT_ALL_TABLES"');
                $db->exec("SET NAMES '" . $charset . "'");
            }
            static::$instance = $db;
        }
 
        return static::$instance;
    }
 
    /**
     * @param $query
     *
     * @return \PDOStatement
     */
    public function getQuery($query){
        $query = str_replace( [ "\n", "\r\n", "\r"], " ", $query );
        $query = trim($query);
        return $this->query( $query );
    }
 
    /**
     * @param $query
     *
     * @return \PDOStatement
     */
    public function limitOne( $query ){
        return $this->query( $query );
    }
}
 
function mysql_query( $query ){
    return db::i()->getQuery( $query );
}
 
function mysql_fetch_object( $query ){
    if( !($query instanceof \PDOStatement ) ){
        $query = db::i()->getQuery( $query );
    }

     * @return \PDOStatement
     */
    public function getQuery($query){
        $query = str_replace( [ "\n", "\r\n", "\r"], " ", $query );
        $query = trim($query);
        return $this->query( $query );
    }
 
    /**
     * @param $query
     *
     * @return \PDOStatement
     */
    public function limitOne( $query ){
        return $this->query( $query );
    }
}
 
function mysql_query( $query ){
    return db::i()->getQuery( $query );
}
 
function mysql_fetch_object( $query ){
    if( !($query instanceof \PDOStatement ) ){
        $query = db::i()->getQuery( $query );
    }
 
    return $query->fetch();
}
 
function mysql_num_rows( $query ){
    if( !($query instanceof \PDOStatement ) ) {
        $query = db::i()->getQuery($query);
    }
    return $query->rowCount();
}
 
function  mysql_fetch_assoc( $query ){
    if( !($query instanceof \PDOStatement ) ){
        $query = db::i()->getQuery( $query );

                    $curl = ($add ? $CHILDREN->id : '?p=category&cat=' . $CHILDREN->id);
                }
                $string .= '<option value="' . $curl . '"' . (isset($_POST[ 'cat' ]) && $_POST[ 'cat' ] == $CHILDREN->id ? ' selected="selected"' : '') . '>- ' . cleanData($CHILDREN->catname) . '</option>' . defineNewline();
            }
        }
 
        return $string;
    }
 
// Displays other recipes in a given category..
    function otherRecipesInThisCategory($txt, $cat)
    {
        $string = '';
        $query = mysql_query("SELECT * FROM " . $this->prefix . "recipes
           WHERE enRecipe  = 'yes'
           AND isApproved  = 'no'
           AND cat         = '$cat'
           AND id          != '" . (int)$_GET[ 'recipe' ] . "'
           ORDER BY rand()
           LIMIT " . OTHER_RECIPES_IN_CAT_DISPLAY_LIMIT . "
           ") or die(mysql_error());
        while ($RECIPES = mysql_fetch_object($query)) {
            // Build link data..
            if ($this->settings->modr == 'yes') {
                $CAT = getTableData('categories', 'id', $RECIPES->cat);
                $link = $this->settings->install_path . 'tarifler/' . seoUrl($CAT->catname) . '/' . seoUrl($RECIPES->name) . '/' . $RECIPES->id . '/index.html';
            }
            else {
                $link = $this->settings->install_path . '?p=recipe&amp;recipe=' . $RECIPES->id;
            }
            $string .= str_replace(['{link}', '{recipe}'], [$link, cleanData($RECIPES->name)],
                file_get_contents(PATH . 'templates/html/latest-popular-link.htm'));
        }
 
        return ($string ? $string : $txt);
    }
 
// Increments count for hit counter..
    function hitCounter()
    {

   $tpl->assign('SHOW_PICTURES', $MRREC->buildRecipePictures($ps_recipe18));
   $tpl->assign('VISITOR_COMMENTS', ($CAT->enComments=='yes' && $RECIPE->enComments=='yes' ? $MRREC->buildRecipeComments($ps_recipe15,$ps_recipe16,$ps_recipe7) : ''));
   $tpl->assign('CLOUD_TAGS', ($SETTINGS->enCloudTags=='yes' ? $MRREC->buildRecipeCloudTags($ps_recipe17) : ''));
   $tpl->assign('HITS_TXT', (ENABLE_HIT_COUNT ? $ps_recipe19 : ' '));
   $tpl->assign('HITS', (ENABLE_HIT_COUNT ? $MRREC->buildRecipeHitCount($RECIPE->hits) : ''));
   $tpl->assign('CONTACT_US_TXT', $ps_recipe8);
   $tpl->assign('PRINT_FRIENDLY_TXT', $ps_recipe10);
   $tpl->assign('TELL_A_FRIEND_TXT', $ps_recipe9);
   $tpl->assign('DATE_BAR_TXT', ($RECIPE->submitted_by ? $ps_recipe34.' <span class="highlight"><a href="'.$conUrl.'" title="'.cleanData($RECIPE->submitted_by).'">'.cleanData($RECIPE->submitted_by).'</a></span> | ' : '').$ps_recipe35.' <span class="highlight">'.$RECIPE->adate.'</span><br />'.$breadCrumbs);
   $tpl->assign('INGREDIENTS_TXT', $ps_recipe11);
   $tpl->assign('INSTRUCTIONS_TXT', $ps_recipe12);
   $tpl->assign('SUBMIT_TXT', $ps_recipe14);
   $tpl->assign('S_URL', $SETTINGS->install_path.($SETTINGS->modr=='yes' ? 'add-recipe/'.$RECIPE->cat.'/index.html' : '?p=add-recipe&amp;cat='.$RECIPE->cat));
   $tpl->assign('C_URL', $SETTINGS->install_path.($SETTINGS->modr=='yes' ? 'contact-recipe/'.$_GET['recipe'].'/index.html' : '?p=contact-recipe&amp;recipe='.$_GET['recipe']));
   $tpl->assign('F_URL', $SETTINGS->install_path.($SETTINGS->modr=='yes' ? 'tell-a-friend/'.$_GET['recipe'].'/index.html' : '?p=tell-a-friend&amp;recipe='.$_GET['recipe']));
   $tpl->assign('P_URL', $SETTINGS->install_path.($SETTINGS->modr=='yes' ? 'print/'.$_GET['recipe'].'/index.html' : '?p=print&amp;recipe='.$_GET['recipe']));
   $tpl->assign('LOAD_CATEGORIES', $MRREC->loadCategorySelect());
   include(PATH.'classes/video.php');
   $tpl->assign('VIDEO_URL', ($RECIPE->video ? videoUrlParser($RECIPE->video) : ''));
   $tpl->assign('OTHER_RECIPES_IN_CATEGORY', $MRREC->otherRecipesInThisCategory($ps_recipe13,$RECIPE->cat));
   $tpl->display('templates/recipe.tpl.php');
 
   include(PATH.'control/footer.inc.php');
   break;
   
   // templates/category.tpl.php
   case 'dizin':
   
   // Check query var digit..
   checkDigit($_GET['cat']);
   
   // Get cat data..
   $CAT = getTableData('categories','id',$_GET['cat']);
   
   // Does cat exist..
   if (!isset($CAT->id)) {
     header("Location: ".$SETTINGS->install_path.($SETTINGS->modr=='yes' ? '404.html' : 'index.php?p=404'));
     exit;
   }