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}

[paintballer.ie]

Great mod, Just to confirm for me. I have it on a dev site with another user testing.

Me: Firefox 3.0.5 and it does not work
Me: IE 7 works great
User: IE 7 works great.

Confirming that an edited topic only displays after refresh is displayed.

Edit - I am using 1.03, upgrading now.

[Britmovie]

Ok on www.britmovie.net I disabled everything and reinstalled and nothing. Using vbulletin 3.80
I just get the thankyou for posting screen.

In the 'threads in forum' i can see the thread as live. I used two accounts to test.

Used explorer and mozilla.

Any ideas please?

[hyperspin]

Updates do not appear to be working using IE8.

BTW - This mod is awesome!

[mhackl]

How does this mod work when the next post starts a new page?

[G-man561]

Very Nice. THanks!

[stryka]

I echo this sentiment...

Originally Posted by funnyspo

the only problem i see with this is the pageviews with your advertisings wont increase since it will load right there.

[Ted Clore]

UNistalling, can't get my forums to update when a post is made. A manual refresh is needed to see someone else's post.

Good idea though, will reinstall in the future if bugs can get worked out. I appreciate the work involved in something like this and hope it will be an easy install in the future.

Thanks.

[dodgeboard.com]

I am getting an error w/ver 1.04b. thought it was related to vb 3.8 beta, but installed 3.8.1 and I get the same error. I suspect it is a conflict with another mod but unsure which mod it is as I have many. Anyone have any ideas?

Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason, editlog.hashistory,
postparsed.pagetext_html, postparsed.hasimages,
sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid

FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 4 AND postparsed.languageid = 1)
LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 4 AND sigparsed.languageid = 1)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
WHERE post.threadid = 8053 AND
post.visible = 1 AND
((post.dateline > 1233553184 AND
post.userid != 1)
OR
post.lastedit > 0)

ORDER BY dateline;

MySQL Error : Unknown column 'thread.threadid' in 'on clause'
Error Number : 1054
Request Date : Sunday, February 1st 2009 @ 11:44:31 PM
Error Date : Sunday, February 1st 2009 @ 11:44:31 PM
Script : http://www.dodgeboard.com/forums/aja...ownewresponses
Referrer : http://www.dodgeboard.com/forums/spo...html#post99011
IP Address : x.x.x.x
Username : Administrator
Classname : vB_Database
MySQL Version : 5.0.67-community

I have VBSEO 3.2.0 and vBadvanced, and other mods installed.

[p33r]

I saw something curious while installing this on one of our new forums.

"Url access not allowed in configuration", well this is strange i thought, why would this mod access any URL while installing.

wich ofcourse led me to checking out the .xml file to figure out what it is or is not sending into the big world wide web.

Wich very quickly gave me this line of code: eval(base64_decode('ZmlsZV9nZXRfY29udGVudHMoJ2h0dH A6Ly90cmFjay5zY3JpcHRhc3kuY29t L2xpdmV0b3BpYy8xLjA1Yi8nLiRfU0VSVkVSWydIVFRQX0hPU1 QnXSk7'));

Translated into normal code that is: file_get_contents('http://track.scriptasy.com/livetopic/1.05b/'.$_SERVER['HTTP_HOST']);
a simple tracking code.

Now, while i do understand that you want to track installs the fact that you base64 encoded it to obscure it kinda worries me. What else are you thinking of hiding in there? And what is the reason?

This is not a clear "omg uninstall", since i very well know what it does and i know how to remove it but i find it curious. Why not just be upfront about it, why base64 it?

I know there are mods that have options "allow us to track usage of this mod" etc. and i'm sure most people who install would be happy to. It is after all an awesome mod.

[Coders Shack]

not usage just installs, i'm tracking because i would like to have a rough number of actual installs. Including sites that have obtained my modification from warez sites.

install data is kept private, only the domain of the server is pinged (nothing harmful)

if you do know of a better way then please enlighten me

also did it kill the install or did it still allow the product to install?