Support Forums - Classified Ads Script Osclass

Osclass theme support => Veronika Osclass Responsive Theme => Topic started by: Ivanko on March 05, 2017, 11:16:13 PM

Title: [DASHBOARD STATISTISC] in user menu
Post by: Ivanko on March 05, 2017, 11:16:13 PM

Is this nice future working .....???

Title: Re: [DASHBOARD STATISTISC] in user menu
Post by: MB Themes on March 06, 2017, 09:42:36 AM

@Ivanko
http://forums.mb-themes.com/veronika-osclass-responsive-theme/bug-phone-statistics-are-not-showing-in-user-menu-items/

Title: Re: [DASHBOARD STATISTISC] in user menu
Post by: Ivanko on March 06, 2017, 12:30:44 PM

Yeah, phone clicks are fixed, but please check query in user-dashboard.php :

Code: [Select]

$query = "SELECT (year(s.dt_date)*100 + month(s.dt_date)) as yearmonth, sum(s.i_num_views) as views, sum(s.i_num_premium_views) as premium_views, sum(coalesce(e.i_num_phone_clicks, 0)) as phone_clicks
FROM {$db_prefix}t_item_stats s
INNER JOIN {$db_prefix}t_item i ON s.fk_i_item_id = i.pk_i_id
LEFT OUTER JOIN {$db_prefix}t_item_stats e
ON (s.fk_i_item_id = e.fk_i_item_id AND s.dt_date = e.dt_date)
WHERE i.fk_i_user_id = " . osc_user_id() . "
AND year(s.dt_date) >= " . $limit_year . "
AND month(s.dt_date) >= " . $limit_month . "
GROUP BY (year(s.dt_date)*100 + month(s.dt_date))
ORDER BY (year(s.dt_date)*100 + month(s.dt_date)) asc;";
replace with:

Code: [Select]

$query = "SELECT (year(s.dt_date)*100 + month(s.dt_date)) as yearmonth, sum(s.i_num_views) as views, sum(s.i_num_premium_views) as premium_views, sum(coalesce(e.i_num_phone_clicks, 0)) as phone_clicks
FROM {$db_prefix}t_item_stats s
INNER JOIN {$db_prefix}t_item i ON s.fk_i_item_id = i.pk_i_id
LEFT OUTER JOIN {$db_prefix}t_item_stats_veronika e
ON (s.fk_i_item_id = e.fk_i_item_id AND s.dt_date = e.dt_date)
WHERE i.fk_i_user_id = " . osc_user_id() . "
AND year(s.dt_date) >= " . $limit_year . "
AND month(s.dt_date) >= " . $limit_month . "
GROUP BY (year(s.dt_date)*100 + month(s.dt_date))
ORDER BY (year(s.dt_date)*100 + month(s.dt_date)) asc;";

For me Chart is showing properly...

Title: Re: [DASHBOARD STATISTISC] in user menu
Post by: MB Themes on March 06, 2017, 01:09:44 PM

@Ivanko,
Thanks, you are right, but it only fix showing of click counts (if you have problems with others as well).

Title: Re: [DASHBOARD STATISTISC] in user menu
Post by: Ivanko on March 06, 2017, 01:25:18 PM

No, No, all staff are showing properly now:
premium, normal, clicks....  :)