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}

[AcidX]

I got a DB Error when importing the product:

Database error in vBulletin 3.8.0:

Invalid SQL:
ALTER TABLE `postforumv_` ADD `lastedit` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `dateline`;

MySQL Error   : Table 'web1_db1.postforumv_' doesn't exist
Error Number  : 1146
Request Date  : Tuesday, January 13th 2009 @ 12:41:33 PM
Error Date    : Tuesday, January 13th 2009 @ 12:41:33 PM
Script        : http://forum.kajgana.com/admincp/plugin.php?do=productimport
Referrer      : http://forum.kajgana.com/admincp/plugin.php?do=productadd
IP Address    : xx.xx.xx.xx
Username      : Acid
Classname     : vB_Database_MySQLi
MySQL Version : 5.0.22

You have a problem in the installer.
In all the hurry, I suppouse you made a mistake in the ALTER tables command and PREFIX positions... Lemme fix it

Edit: Fixed! (not entirely, don't download)
Attachment 92524

Edit2: Note that the product install proccess might take a while..
Since "`post" is the largest table in the forum - it takes a while untill the SQL changes take effect.

Edit3: Works like a charm so far!

Edit4: Post editing doesn't work. There's a new DB Error... I'll try to fix it now.
I suggest that you don't need to rush and install the new version yet, untill Coders Shack updates the installer.

Final edit:
Done! I've got all the errors in the installer fixed. Post editing works too.
If you want to, you can download and test the product untill Coders Shack posts the final version.
Attachment 92528

Anyways, how do I translate this text? Do I have to edit livetopic.js?
Attachment 92527

[christicehurst]

I was the first person to say this would be a big mod and looks like I was right. Good update, keep it up!

[AcidX]

Ideas for 1.03b:

Limit the modification to certain forums (or threads) only.
- I'm not sure if this is possible, but it's worth a try.

Make the page scroll down along with new posts.
- When I'm typing in the QuickReply editor and a new post arrives - the editor goes bellow and I can't see the text. I think the page focus should go to the QR editor, not the latest post.

[nascartr]

So does anyone have any issues with Coders Shack update or should I download AcidX's fix?

[KevinL]

I downloaded it and then used AcidX's fix. Worked mint.

[Vinyljunky]

Am I right in thinking this wont work with vB Optimise 1.3.2 ?

I ask because this mod doesnt seem to be working for me


Thanks

VJ

[KevinL]

Originally Posted by Vinyljunky

Am I right in thinking this wont work with vB Optimise 1.3.2 ?

I ask because this mod doesnt seem to be working for me


Thanks

VJ

Works fine with it

[Coders Shack]

ohh man lol

sorry about that... GAH

[Coders Shack]

Originally Posted by AcidX

I got a DB Error when importing the product:

Database error in vBulletin 3.8.0:

Invalid SQL:
ALTER TABLE `postforumv_` ADD `lastedit` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `dateline`;

MySQL Error   : Table 'web1_db1.postforumv_' doesn't exist
Error Number  : 1146
Request Date  : Tuesday, January 13th 2009 @ 12:41:33 PM
Error Date    : Tuesday, January 13th 2009 @ 12:41:33 PM
Script        : http://forum.kajgana.com/admincp/plugin.php?do=productimport
Referrer      : http://forum.kajgana.com/admincp/plugin.php?do=productadd
IP Address    : xx.xx.xx.xx
Username      : Acid
Classname     : vB_Database_MySQLi
MySQL Version : 5.0.22

You have a problem in the installer.
In all the hurry, I suppouse you made a mistake in the ALTER tables command and PREFIX positions... Lemme fix it

Edit: Fixed! (not entirely, don't download)
Attachment 92524

Edit2: Note that the product install proccess might take a while..
Since "`post" is the largest table in the forum - it takes a while untill the SQL changes take effect.

Edit3: Works like a charm so far!

Edit4: Post editing doesn't work. There's a new DB Error... I'll try to fix it now.
I suggest that you don't need to rush and install the new version yet, untill Coders Shack updates the installer.

Final edit:
Done! I've got all the errors in the installer fixed. Post editing works too.
If you want to, you can download and test the product untill Coders Shack posts the final version.
Attachment 92528

Anyways, how do I translate this text? Do I have to edit livetopic.js?
Attachment 92527

so what was the issue with post editing?

[AcidX]

Originally Posted by Coders Shack

ohh man lol

sorry about that... GAH

let me fix that an also phrase it

Sure. Just download mine's lol

Originally Posted by Coders Shack

so after everything how was the serverload?

I can't tell yet. It needs some testing period... Usually it's around 1.5, and now it's going from 1.7 to 2.7. But, all users seem to be playing with it (chatting), so that might be the reason why the load raised...

Also, if you're administrating a large board as mine, I suggest you turn of your forum while importing the product - because it take a minute or two while editing the "post" table. I also need to mention that the load went from 1.5 to 36 while I was importing the product!