vb.org Archive - Add Who's Online locations from Admin CP

Page 2 of 23

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - Add Who's Online locations from Admin CP (https://vborg.vbsupport.ru/showthread.php?t=32849)

SirSteve

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

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

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

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

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

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: :eek:

Crinos

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

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

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

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.

All times are GMT. The time now is 07:57 AM.

Page 2 of 23

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01195 seconds Memory Usage 1,737KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: