UBB.threads PHP Forum Software Community Forums UBB.threads Version 7/8 Support Access to Admin log data

I assume in V7.25b there is no method to export the admin logs ?

If not where are these files located and are they just ascii files I can copy to my PC to make use of ?

Thanks

7.2 stores the access logs in the MySQL database; you can use a tool such as PHPMyAdmin to export data.

or just paste:

SELECT *
FROM `ubbt_admin_log`

into your SQL textarea and execute, then copy to clipboard

*replace 'ubbt_' with your boards' prefix

or you could take his route ... mine would actually ask you if youw anted to save it to a file, and if you wanted that file compressed (which could be useful for some users)

When I copied and pasted your content I get

SELECT * FROM ubbt_admin_log

Table 'teamzron_zc1.ubbt_admin_log' doesn't exist

I did this from the datebase SQL command window

-----------

Where do I get this tool ?

Thanks

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

Also I notice important is the time/date is missing in the data

PHPMyAdmin comes with many webhosts pre-installed, generally mentioned as "MySQL Admin"; you can also install it from their site here.

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"

my bad, i have a doze box (local wamp) that i didn't maintain upper case on.. glad you caught that.



1st field is date/time...

use: FROM_UNIXTIME(REFERRER_DATE ,'%M %e, %Y - %h:%i %p') AS Time

for that field

Dates are stored in the database as "Seconds Since the Unix Epoch" clicky clicky

This allows for dates to be offset for timezone differentials, different formats, etc clicky

Sheesh, why cannot they just give a simple formula so I could convert the values on another column in Excel to get the human time/date

Because the data in the backend database isn't meant for humans? That's what the php frontend is for, to convert the time into your timezone/specified format...

simple:

assume A1 contains that funky number:

paste '=A1/86400+"1/1/70"' into B1 and format the cell for date/time..

thus: 1183780091 becomes 7/7/07 3:48 AM

*poof* done

You're too quick SD - Was going to say that Excel Excels at that sort of stuff

Yeh, what he said...

Hmm,
Excel allows for a date or time format but not both so if I take the unix value and use that formula get this at date only format

1183780091 7/5/1937

I found a date time format but then get
1183780091 7/5/37 4:08 AM

day/month right but year wrong

you sure you pasted it exactly ?

:shrug:

ps: i'm using m/d/y .. usa-ite .. dunno..

Yes it was a cut and paste

with excel that I am using and US date/time format
I used your timestamp as a test and also get 1937

here is cut and paste from excel =B1/86400+"1"/1/70
B1 is where the raw data is

Don't set the cell type to be a date, set it to be a standard cell (no set format) then you can dump any set of data there.

Gizmo do not understand that for if cell is formatted the answer becomes 13701.17275

your quotes are wrong ... use "1/1/70" and not "1"/1/70



^^ see my formula and where the quotes are

That was the fix for now get

1183780091 7/7/07 3:48 AM
1183782164 7/7/07 4:22 AM
1183782270 7/7/07 4:24 AM
1183790397 7/7/07 6:39 AM
1183800199 7/7/07 9:23 AM
1183801869 7/7/07 9:51 AM
1183802583 7/7/07 10:03 AM
1183804040 7/7/07 10:27 AM
1183806865 7/7/07 11:14 AM
1183808433 7/7/07 11:40 AM

Not sure how excel did that as I pasted your's directly in
maybe when a format was done excel assumed something ?
In any case thanks that what I needed