• Mike •

 
.....................
        $published = $only_published ? 'c.published = 1' : '1=1';
 
        $sql = "SELECT c.*, g.id AS gid, g.title AS gtitle, g.alias AS galias,
                    IFNULL(u.nickname, 0) as nickname,
                    IFNULL(u.login, 0) as login,
                    IFNULL(u.is_deleted, 0) as is_deleted,
                    IFNULL(p.imageurl, 0) as imageurl,
                    IFNULL(p.gender, 0) as gender
                FROM cms_comments c
                LEFT JOIN cms_users u ON u.id = c.user_id
                LEFT JOIN cms_user_profiles p ON p.user_id = u.id
                LEFT JOIN cms_user_groups g ON u.group_id = g.id
                WHERE {$published}
                    {$this->inDB->where}
                    {$this->inDB->group_by}
                    {$this->inDB->order_by}\n";
 
        if ($this->inDB->limit){
            $sql .= "LIMIT {$this->inDB->limit}";
        }
 
        $result = $this->inDB->query($sql);
 
        $this->inDB->resetConditions();
 
        if (!$this->inDB->num_rows($result)) { return array(); }
 
        while($comment = $this->inDB->fetch_assoc($result)){
............
 

Error_Reporting(E_ALL & ~E_NOTICE & ~E_WARNING);

 
//Error_Reporting( E_ALL & ~E_NOTICE & ~E_WARNING );
Error_Reporting( E_ALL | E_STRICT );
 

 
function get_user_params( $user_id ){
 
    $inDB = cmsDatabase::getInstance();
 
    $sql = "SELECT p_date, parameters FROM cms_user_param WHERE user_id = '$user_id';";
 
    if ( !$result = $inDB-> query( $sql ) ) { return cmsCore::error404(); }; 
 
    $row = $inDB-> fetch_assoc( $result );
    $row['parameters'] = cmsCore::yamlToArray( $row['parameters'] );
 
    echo '<pre>';
    print_r( $row ); // чтобы проверить что возвращается и с какими ключами
    echo '</pre>';
 
    return $row;
}
 

 
{if $pagebar_on}
    <div class="shop_pages"> {$pagebar} </div>
{/if}
 

 
{if $pages>1 AND $cat_id != $root_cat_id}
    <div class="shop_pages"> {$pagebar} </div>
{/if}
 

 
{$graph[1].parameters[1]}
 

assign->( 'graph', $graph );

{$graph[1][parameters][1]}

 
echo '<pre>';
print_r( $test_var );
echo '</pre>';
 

 
$test = array(
    'field_name_in_db_table' => $updated_value,
    'other_field_name_in_db_table' => $other_updated_value.. 
);