 |
 |
 |
 |
Registered: 06/23/06
Posts: 827
|
|
|
 |
 |
 |
 |
|
 |
 |
 |
 |
|
Express Hosting
"We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
|
|
|
 |
 |
 |
 |
 |
 |
 |
 |
#190812 - 07/11/07 10:31 PM
Re: Access to Admin log data
[Re: Gizmo]
|
enthusiast
|
Registered: 06/19/07
Posts: 249
|
|
That is an app supplied by the host provider, has phpMyAdmin - 2.9.0.2 I got it functional but I do not see date/time here either such as example one in referer_log 1,"1183780091","http://www.ls1tech.com/forums/showthread.php?t=743763" PHPMyAdmin comes with many webhosts pre-installed, generally mentioned as "MySQL Admin"; you can also install it from their site here.
_________________________
JR Team ZR-1 Corvette Racer's
|
|
Top
|
|
|
|
|
 |
 |
 |
 |
 |
 |
 |
 |
#190813 - 07/11/07 10:39 PM
Re: Access to Admin log data
[Re: teamzr1]
|
|
Registered: 04/19/07
Posts: 4056
Loc: SoCal, USA
|
|
I figured it out, you used lowercase and it has to be ADMIN_LOG but I found I needed was SELECT * FROM ubbt_REFERER_LOG was the data I wanted but, kinda a pain since as mentioned I would have to copy paste that data to my PC my bad, i have a doze box (local wamp) that i didn't maintain upper case on.. glad you caught that. 1,"1183780091","http://www.ls1tech.com/forums/showthread.php?t=743763"
1st field is date/time... use: FROM_UNIXTIME(REFERRER_DATE ,'%M %e, %Y - %h:%i %p') AS Time for that field  SELECT FROM_UNIXTIME(REFERER_DATE ,'%M %e, %Y - %h:%i %p')
AS Time, REFERER_URL
FROM `ubbt_REFERER_LOG`
|
|
Top
|
|
|
|
|
 |
 |
 |
 |
|
|