WeBid Bug Tracking

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0000411WeBidAdmin Control Panelpublic2013-01-21 23:112013-01-23 15:20
Reporterandre88uk 
Assigned To 
Priority@0@SeverityminorReproducibilityhave not tried
StatusresolvedResolutionfixed 
PlatformOSOS Version
Product Version1.0.6 
Target VersionFixed in Version1.1.0 
Summary0000411: Slightly Annoying Admin access reports bug
DescriptionHi every... I have seen a little bug in admin view stats page where the order of the days is messed up on the day view.



To fix this simply run the following SQL query:



ALTER TABLE  `webid_currentaccesses` CHANGE  `day`  `day` INT( 2 ) NOT NULL DEFAULT  '0',

CHANGE `month` `month` INT( 2 ) NOT NULL DEFAULT '0',

CHANGE `year` `year` INT( 4 ) NOT NULL DEFAULT '0'




Also on admin/viewaccessstats.php it will mess up if the site has run for more than one year (it will show the days from this month every year in operation.



To fix this simply change

[PHP] $month = gmdate('m');

    $query = "SELECT * FROM " . $DBPrefix . "currentaccesses WHERE month = " . $month . " ORDER BY day ASC";[/PHP]



to:



[PHP] $month = gmdate('m');

    $year = gmdate('Y');

    $query = "SELECT * FROM " . $DBPrefix . "currentaccesses WHERE month = " . $month . " AND year = " . $year . " ORDER BY day ASC";[/PHP]



On or around line 48
TagsNo tags attached.
import_id412
Thread
Attached Files

- Relationships

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2015-04-01 13:17 renlok New Issue
2015-04-01 13:17 renlok import_id => 412
2015-04-01 13:17 renlok Date Submitted 2015-04-01 13:17 => 2013-01-21 23:11
2015-04-01 13:17 renlok Last Update 2015-04-01 13:17 => 2013-01-23 15:20


Copyright © 2000 - 2017 MantisBT Team
Powered by Mantis Bugtracker