Miscellaneous Hacks - Live Topic

. . . . . . . . Brought to you by scriptasy.com

. . . http://www.Scriptasy.com

Live Demo:

Live Topic 1.07b Demo (you must be logged in, and the topic must be "live")

Videos: 1.00b 1.06b

watch the damn videos... ^_^

Description:

This product is different from anything you have seen before, it raises the bar for forums. It will make your forums much more interactive, and also reduce server load.

Technical Details:

If a thread has been posted in X seconds then its now Live, if other users are viewing the Live topic and are on the last page they will experience a clean ajax experience while talking to other members. Once the thread is older than X seconds its no longer Live and it will now act like a normal thread. Also if a user edits one of their posts that's inside of the thread, it will be updated too so there is no longer a reason to ever have to refresh.

There is also logic for the viewer, the viewer of the thread has to be in an active state to see responses. An active user state is determined upon the users actions, if no actions were made in X seconds then the user is marked as inactive.

Also you may wonder why this could save your server bandwidth and CPU. If a user is refreshing to talk to another members the queries on a normal thread load are way more intense than the ajax call that this modification makes. So if you have 5 people talking to each other none of them have to refresh the page, all they are doing is simple page requests and one intense request when there has actual change.

You can test Live Topic with two users, you will see how amaizing this is... And probably spontaneously combust.

Found a bug? Want to request a feature?

Live Topic - Project Manager

Installation:

This is take less than 3 minutes to install, takes longer to notice its amazing feature. (you need multiple people to be active in the same topic)

Upgrade:

[1.01b to 1.XXb] Uninstall the product, then reinstall it. Overwrite all old files with new files and you should be fine.

[1.02b to 1.03b] Overwrite files, upgrade product (dont install product)

[1.03b to 1.04b] Uninstall the product, then reinstall it. Overwrite all old files with new files and you should be fine.

[1.04b to 1.05b, 1.05b to 1.06b,1.06b to 1.07b] Upgrade the product. Overwrite all old files with new files and you should be fine.

Works With (FF2, FF3, IE6, IE7, IE8, SF2, SF3, CHROME):

vBulletin [3.8.X]

get the vBulletin [3.7.X] version here

INCOMPATIBLE HACKS:

• USC
• PassiveVid (1.x)
• gXboxLive
• Topic (incl. Blog) of the Week
• Marquee Text

Versions:

1.01b
1.02b

fixes

safari 2 support
safari 3 support
google chrome support
added live topic icon on new posts page
fixed security issue, strongly suggest upgrading!

changes

added live edit (to avoid a performance hit i had to add two rows to two tables in the database)
added external style sheet

1.03b

fixes

fix double post
phrase notification
fixed an edit bug for people with table prefixes

changes

ability to change interval in ACP

1.04b

fixes

javascript error for guests
fixed live topic activation (first poster to raise a dead topic)

changes

auto quick reply focus after post

1.05b

fixes

css flaw
js error for unsupported browsers (random)
fixed chrome issue

changes

edit notification - thanks to nso
rebuilding some of the original logic to hopefully prevent product conflicts

1.06b

fixes

fixed a little javascript issue that had to do with displaying posts
uses GPC cleaner now

changes

limit the number of ajax posts on the live topic (example 40) and fade them away.
changed the way the hooks are used
tightened up everything a bit

1.07b

fixes

fixed a bug where the live topic notification always making an ajax call

changes

support user ignore list
changed the way the javascript logic worked (hopefully there are less compatibly issues) added support for IE6 and IE8

1.10

hmm

{Mark As Installed}

{Don't forget to vote for Modification of the Month}

[Cybertims]

Where can we edit the little popup notification ? The text and background is white for me so you lose some of the text altogether.

Cheers

[DASP]

I have attempted to use Live Topic twice.
Each time my vBulletin admin's mail account receives a dozen or so identical messages.
(I commented out the private information with asterisks in the following quote.)

Database error in vBulletin 3.8.0:

Invalid SQL:

SELECT COUNT(*) AS count
FROM vb_post AS post
WHERE threadid =
AND visible = 1
AND dateline >
AND userid != ******;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND visible = 1
AND dateline >
AND userid != ******' at line 4
Error Number : 1064
Request Date : Monday, January 12th 2009 @ 06:52:05 PM
Error Date : Monday, January 12th 2009 @ 06:52:05 PM
Script : http://forum.******.com/ajax.php?do=shownewresponses
Referrer : http://forum.******.com/showthread.php?p=167
IP Address : ******
Username : ******
Classname : vB_Database_MySQLi
MySQL Version : 5.0.67-community

As you can see, both threadid and dateline have missing values.
I should also mention that the product is listed within Admin Control Panel as version 0.90, not version 1.01b.
I downloaded it again and verified product-livetopic.xml is marked as version 0.90.

[AMailer]

For some odd reason, this is how its working for me, an admin user.

If I make a reply, new replies (with quick edit) from other users will get displayed.

If I do NOT make a reply (with quick edit), no new replies from other users get displayed.

Though according to some users, it works fine. If they make a reply or NOT, it still updates the topic with new replies from users. Two different results, both using the same browser, Firefox.

Oh, someone stated something about VBSEO. I have that installed as well. The Live Icon works, I can see it and etc, however the rest of the...main feature... dosn't. I do not get any "pop-up" box, though some users reported that they do. Strange.

[Coders Shack]

ok, i strongly suggest upgrading to 1.02b

hope you all like the updates

[Coders Shack]

Originally Posted by Cybertims

Where can we edit the little popup notification ? The text and background is white for me so you lose some of the text altogether.

Cheers

in 1.02b I put the css in a file:

clientscript/vbulletin_css/livetopic.css

[Coders Shack]

feedback from users that were experiencing issues with 1.01b please I'm wondering if i fixed it for you guys

id also love feedback from sites that have a large number of concurrent user.

[logicuk]

Originally Posted by Coders Shack

feedback from users that were experiencing issues with 1.01b please I'm wondering if i fixed it for you guys

id also love feedback from sites that have a large number of concurrent user.

Released a vb 3.7 version and ill test it on a site with 400users online

[Coders Shack]

really pushing a 3.7 one aren't you :P

let me iron everything out in the 3.8 then you will have your 3.7 version

[Vinyljunky]

Video demo is a great idea :up:

[AcidX]

Originally Posted by logicuk

Released a vb 3.7 version and ill test it on a site with 400users online

LOL

I'll test it in a 1200+ online users forum now. If it works, that is.

I'll post some feedback in a couple of minutes.