I especially like your editors table stats. Is this a custom table?
I can't wait to get this loaded on my Links.
One suggestion, the who's online script you wrote a few days back... this could be included and developed a little for this stats plugin.... like most frequent vistor, or vistors today, or top 10 vistors (obviously registered users, not vistors, cause it does not see unregisterd vistors). This would also allow you to get some sort of idea which of your editors or actually doing work, and which arent.
Are you thinking of including the #of search queries/ most search like in pugdogs, modified search logger? Just wondering.
This is really shaping up to be a great plug-in indeed!
like most frequent vistor, or vistors today, or top 10 vistors (obviously registered users, not vistors, cause it does not see unregisterd vistors). This would also allow you to get some sort of idea which of your editors or actually doing work, and which arent.
Good idea, it got a big vote from me, to know more about visitors...
I explained to sooke via pm about why it's not really viable to do this with Links SQL as opposed to Gossamer Forum due to the way users are tracked with uninformative session files rather than with mysql tables as with GForum.
To do some detailed user tracking with Links SQL wouldn't be an easy task.
I don't know how LSQL uses session files, but I think session files could contain more info to be able to track users. I don't know, so I don't say any silly things more.
Once I will have time to get into sessions, I will check how they works. Until that, I depend on your info.
When you assign an editor more than one category with differing permission, the editor appears more than once in the editors table.... for example you could have 60 editors, but 400 records in this table.
When returning stats for number of editors, it needs to be unique editors. I forget the SQL for this, I am sure you know anyways. Something like... SELECT DISTINCT blah FROM blah..... You probably have already thought of this.... but just want to be sure.
Also,
I really like these stats you put in already:
Editor editing most categoryies: Paul (44) Editor editing least categories: Bill (1)
How easy would it to be able expand on this to include most links and least links..... maybe a view number of categories/links being edited for all editors. I know you might be thinking geesh... give it a break Sooke! This editor stats part is of particular usefulness keeping track of your editors.
As far as most popular category.... just so it isnt misleading, could it be renamed to Category with most links, and maybe have a Category with most hits for most popular?
What ever happened to this plugin? Yes I know there are other plugins available that include a stats function, but I still believe a plugin specifically for showing statistics only would be immensely useful for the Link SQL system.
It seems this program was on the brink of release then nothing.