Digital Point Spy Feature

[danthorpe2002]

What php does this use to keep getting the latest posts from the databases?

http://forums.digitalpoint.com/spy.php

I would like to create a chatroom feature with the same sort of refresh?

Thanks :)

[zerxer]

It uses AJAX, which is utilized using JavaScript. I just checked it out and it grabs an XML document of recent topics (a bunch at once) then slowly displays them and like ~30-60 seconds later, it grabs the file again with new results (so it's not actually showing everything every second.. it's showing the past X amount every minute or so).

As for the PHP it uses to actually grab the topics to output as the XML data that is returned to this page, I'm sure it's just simple database queries to grab the last X amount of posts.

[danthorpe2002]

Does anyone know how i can refresh an sql query every few seconds for a chat room?

[Shazz]

DP got it from here: http://www.vbulletin.org/forum/showthread.php?t=125947