Thread Whois

This was requested at this link.

https://vborg.vbsupport.ru/showthrea...threadid=32134

Yes I know it will take up a huge amount of space in the database, but I added a fuction so that after 6 hours it will be deleted. from the database...

I cant really show you a image of it.. but you will see it if you install it.

Have fun

updated: 04/03/03

(Look Below a few posts)

[Admin]

Twig Deez, that's correct. You *always* need to addslashes() when storing strings in database.

[Neo]

Ok Twig.

Instead of

PHP Code:

$timeoutsecondswhois = 260000; 
$timestampwhois = time(); 
$timeoutwhois = $timestampwhois-$timeoutsecondswhois; 

$DB_site->query("INSERT INTO threadwhois SET timestamp='$timestampwhois',threadid='$thread[threadid]',threadname='".addslashes($thread[title])."',username='".addslashes($bbuserinfo[username])."', ip='$REMOTE_ADDR'");
$DB_site->query("DELETE FROM threadwhois WHERE timestamp<$timeoutwhois"); 


use

PHP Code:

if ($bbuserinfo[usergroupid]==XX) {
$timeoutsecondswhois = 260000; 
$timestampwhois = time(); 
$timeoutwhois = $timestampwhois-$timeoutsecondswhois; 

$DB_site->query("INSERT INTO threadwhois SET timestamp='$timestampwhois',threadid='$thread[threadid]',threadname='".addslashes($thread[title])."',username='".addslashes($bbuserinfo[username])."', ip='$REMOTE_ADDR'");
$DB_site->query("DELETE FROM threadwhois WHERE timestamp<$timeoutwhois");
} 


Make the XX the number of the group id you want to have use this.

[Twig Deez]

Originally posted by FireFly
Twig Deez, that's correct. You *always* need to addslashes() when storing strings in database.

thanks firefly. i hadn't even read thru the code that thoroughly,
and i ended up with something like 400 database errors in my inbox from overnight, heh.
i remember the addslashes thing from a fix for another hack anyway,
so that's sorted that out. thanks for the confirmation!

and neo, thanks a lot for that addition! perfect for what i was thinking of.
i can also now figure out how to restrict the output to one particular user,
since i have it in mind to do something with that also.

again, thanks!

[Joshua Clinard]

This looks like a pretty good hack, with the exception of the load, and that's not your fault. Does anyone know if there would be a way to do this hack without adding so much to the database?

[Neo]

Twig Deez: No problem man.

Joshua Clinard: Make it for a specific user group, (like above)

[LaNder]

hi,

i found out, that the function "sort by Thread Name" or "sort by IP" isn't working.

it's always sorted by Username. is there a fix possible?

LaNder

[Neo]

I believe this is sorted by start date

[Jawelin]

Neo, very nice hack. Very very cool!
Simple but great idea.

I implemented it with a couple of enhancements. Just to give you an extend-idea...
- stored a little bit more infos coming from user and thread (for example: forumid, number of posts in thread that moment, proxyip, etc).
- I already have a weekly scheduled "dump, archive and flush" of all four (now five) log tables. So I removed the in-code delete timeout.
- To make that table not too fast grown up, I added a field to forum tables (managed in forum.php) to choose either if log accesses to that particular forum or not.
This way, I could focus the logging to most 'sensitive' areas of my board.

If someone needed, I could post the delta instructions.
Any way, many thanks to your idea and clear implementation.

Bye

[StarBuG]

Hmmm!

This hack could be usefull but not in this way for me!
Is it possible to change the hack to this?

If a user clicks on the Hit counter of a thread that a popup opens and shows the users who viewed this thread?

That is what I realy need!

Greetings

StarBuG

[NeRilkA]

Thanks a lot i was just looking for this hack !! great