The Arcive of Official vBulletin Modifications Site.

About Developer · **Released**: 11-30-2001

This hack was requested on vBulletin.com.

It lets you add possible locations to Who's Online, directly from the Admin CP.
This is good if you are using external hacks, that use vBulletin's system. You probably know that users browsing these external files have Unknown Location (or Main Index for non-admin viewers) next to them.

With this hack, you can easily add a new custom location with ease!
It's also designed in a way that won't let you overwrite existing locations. ('dummy protection' as I like to call it

)

The locations you add are not stored in their own table, because I really felt that would be waste of space and resource.
Instead, I store the locations in the template table, in one special template dedicated to this data.
It was a lot harder to do it this way, btw.

Please let me know if you find any bugs, or if this script doesn't work with files in child folders (this is my main concern).
This can be easily remove (just undo changes to online.php), so please don't fear to try it out!

A nice screen shot is in my next post.

SirSteve · #12 12-01-2001, 05:07 PM

I got this a few times:

Database error in vBulletin 2.2.1:

Invalid SQL: SELECT user.username, session.location, session.lastactivity, user.userid, user.usergroupid, user.invisible, session.host, user.showemail, user.receivepm
FROM session
LEFT JOIN user USING (userid)
WHERE session.lastactivity >

ORDER BY user.username

mysql error: You have an error in your SQL syntax near 'ORDER BY user.username
' at line 6

mysql error number: 1064

Hooper · #13 12-01-2001, 05:15 PM

Hi SirSteve,

I'm not sure why this would create a problem as such. You may want to upload the online.php and overwrite your hacked one. then see if you get the error. If you don't, then you probably copy and pasted a boo boo.

Crinos · #14 12-01-2001, 07:10 PM

Hmmm, seems to be working fine now after I downloaded that new attachment a few moments ago ... I could add/edit/delete just fine, so far ... no bugs yet

Hey FF, if I wanted to include main sections within the site that are non VB-powered, should I just include the global.php and specify them in the admin_online script so that people see who are viewing these sections in who's online?

I got a quiz script in PHP and I kinda wanted to include it in who's online too, but it ain't VB-powered

Thanks!

Hooper · #15 12-01-2001, 07:40 PM

Hmmm. I used a new online.php and rehacked and still have the same problem.

/community/admin/online.php?action=edit&locnum=1

The links are still pointing to /admin/online.php.

If I ../ before this It still doesn't work. The edit delete functions are still not correct for me.

See a problem...?

<html><head>
<meta content="text/html; charset=windows-1252" http-equiv="Content-Type">
<meta http-equiv="MSThemeCompatible" content="Yes">
<link rel="stylesheet" href="../cp.css">
<title>Who's Online - Location Manager</title></head>
<body leftmargin="10" topmargin="10" marginwidth="10" marginheight="10">
<form action=".php" name="name" method="post">
<input type="hidden" name="s" value=""><input type="hidden" name="action" value="">
<br><table cellpadding='1' cellspacing='0' border='0' align='center' width='90%' class='tblborder'><tr><td>
<table cellpadding='4' cellspacing='0' border='0' width='100%'>
<tr class='tblhead'>
<td><p><b><span class='tblhead'>Filename</span></b></p></td>
<td><p><b><span class='tblhead'>Description for it</span></b></p></td>
<td><p><b><span class='tblhead'>Options</span></b></p></td>

Crinos · #16 12-01-2001, 07:56 PM

fwiw, I was using a VB 2.0.3 online.php file (coz the 2.2.0 version was buggy back then), and that's what I modified for this hack. I didn't upgrade to 2.2.1 coz of the amount of hacks I installed on my forums, and it being a very minor release, I didn't need it (made lots of fixes to 2.2.0 via the Bug Section of vb.com) ...

And with the admin_online.php I downloaded just a couple of hours ago, it is now putting the correct filename on the form (admin_online.php instead of online.php) ... so I guess that fixed it

Hooper · #17 12-01-2001, 07:59 PM

Ah,,,

Well, I have 2.2.1. I went ahead and uploaded a fresh online.php to work with since you posted that yours was working. Rehacked with the same results. Look at the above code. :stupid:

Crinos · #18 12-01-2001, 08:01 PM

Hey Hooper, I said "fwiw" because I don't think the version of online.php was important to the hack ... but anyway...

Look at the code just below what you posted ... it should have another set of form tags, which should look like this:

Code:

<form action="admin_online.php"  name="name" method="post">

Last night it was "online.php", and I think that was the only problem I had ... have you tried redownloading the attachment above?

Hooper · #19 12-01-2001, 08:03 PM

Yes sir,

I've downloaded the new attatchment 3 times today.
I had the online.php pretty hacked up before. That's why I used a fresh one this morning after seeing it posted that you had it working.

Nope. Here is the whole code I get.

<edited>by Hooper</edited>

Crinos · #20 12-01-2001, 08:09 PM

Hmmm, strange, well I can tell you that it does work pretty well ... I think it'll only give you a 404 if it's not pointing to the correct file in the form ...

I'm attaching the raw admin_online.php file that I am using, just to be sure ... if this is not allowed FF, feel free to delete it

Hooper · #21 12-01-2001, 08:12 PM

WORKED!!!!!!!!!!!!!!!!!!!!!!!!!

Why the heck am I getting the same file all day that I downloaded early this morning? I must be getting the old file over and over or something.

Go try a download. Rename your good one on the server and install what you download. Please try that.

Thanks. Your file worked.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04673 seconds Memory Usage 2,311KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)bbcode_code (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!