DevBox Work - Online Users Today, Latest Threads, Top Posters, Newest Members

This is another one of my 'all in one' hacks, this time without the 'latest posts' part.

Features

• Turn on/off each option. An individual setting
• Alter the amount of rows to retrieve (ie. only get 10 recent threads)
• Easy access to used SQL queries, so advanced users can alter the SQL to get extra information.
• Uses phrase system
• Fully customizable templates
• Latest Threads can be from only forums you specify, or from forums that the current user has permission to see. Deleted threads are not shown.
• Online Users Today shows invisible marks to those who can see them, and shows open/close tag (ie. admins are bold and italic).
• Dates uses vbdate function, which uses your date string in vboptions
• Installer for phrases and templates!
• + more

Support
I can offer limited support for this hack. I wrote it for my forum, and its workin' pretty good. If you find any problems, post'em here and I might find some time to help you out. Just back up all your data before you apply anything, as goes with all hacks!

Demo
Online demo (with some template edits, I might add!): http://www.DevBoxForums.com

Notes
I didn't have the time to edit the default templates, so I don't think it's too pleasing out-of-the-box. If someone would like to spice it up a notch and submit it here, I'd be glad to include it in the actual package.

Installation
Upload devbox_work.php to your forum root path, as well as the devbox_install directory. Navigate your browser to devbox_install/install.php and follow onscreen instructions. You will need your database username and password simply for authentication to start the installer.

Should I install this hack? Is it buggy? Etc
I've been making the installer for a little while and I must've run it at least a dozen times throughout and I haven't had any errors. But thats only me. Before people can install it for themselves and see how it goes, I can't say much.

Troubleshooting / Common Problems
If you end up running the phrase step or template step more then once, you'll probably get mysql errors complaining about duplicate entries. You can go in phpMyAdmin into the phrase/template tables, sort by the primary key so oldest is first, and delete all the devbox related rows.


Template Variables
Since this hack is obviously lacking some default-template looks, I thought I'd go over all of the variables you can use. If you want more, you'll have to edit the SQL queries under 'Section 2'. All variables are accessed through the $data array. Example: $data[threadid]

• Latest Threads
  • threadid - The ThreadID. Used in URL's mostly
  • title - Thread title
  • replycount - The number of replies the thread has
  • views - The number of views the thread has
  • lastposter - The username of the last poster
  • posterusername - The username of the thread starter
  • posteruserid - The UserID of the thread starter
  • forumid - The ForumID of the the forum the thread resides in
  • forumtitle - The forum name the thread resides in
• Newest Members
  
  
  • userid - The UserID of the member. Usually used in URL's
  • username - The username of the member
  • date - The readable joindate of the user. If for some reason you wanted the timestamp, use joindate
  • posts - The number of posts this member has
  • opentag/closetag - The open/close HTML tags for this member. (ie. Admins are generally bold and italic)
• Top Posters
  
  
  • userid - See above
  • username - See above
  • posts - See above
  • opentag/closetag - See above
• Online Today
  
  
  • userid - See above
  • username - See above
  • invisible - The invisible mark shown next to invisible users. Set to '*' to members that are hidden users, and set to '' (nothing) to those who are not. Note: Hidden users are only shown on the list if the user viewing the page has permission to see them.
  • opentag/closetag - See above

Attachments

• devbox_work.zip contains all the files neede
• installer.gif is a screenshot of the install script

[???`S?LV?R???`]

nice job

[Dean C]

Looks great on your site !

[Chroder]

Thanks guys. Just editted my first post and included a little 'template variable overview'.

[NyCwill]

ehh there doesnt seem to be anything on the zip

[Chroder]

There i when I download it...

[Codeman05]

any chance you could give me a hand getting the new tables onto the right like on your site?

Great hack btw!

[dethfire]

for some reason this displays on the bottom, is it supposed to?

[Chroder]

Out-of-the-box, yes. You'll have to modify the templates on your own if you want it to look like mine (On the side, that is). If I have time I'll write an addon that will make the side bar.

[dethfire]

I call false advertising!! :disappointed: