Integration with vBulletin - vBTwitter

Description

This modification adds basic Twitter integration to vBulletin. Once a user defines their Twitter username & password within their vB Options (User CP -> Edit Options), the Tweet This X links will appear.

It automatically adds a tweet to their account with the default text of "Check this out! " (which can be edited editing the "twitter_checkout" phrase) and uses your forum URL with either tp or tt.php as the link. These redirect to the thread / post that was tweeted.

Installation

1. Upload files in the /upload/ folder of the .zip into the directories as is.
2. Install product file.
3. Register an OAuth Application here, using:
   • Application Name: Your Site!
   • Description: Site Integration into Twitter.
   • (I request this one not be changed!) Application Website: https://vborg.vbsupport.ru/showthread.php?t=204694
   • Website: Your URL!
   • Application Type: Browser
   • (change url) Callback URL: http://www.yoururl.com/twitter_auth.php
   • Default Access type: Read & Write
4. Click Install on vB.org
5. Tell Your users.
6. Enjoy

Upgrading to v1.0.4

• Upload all files, overwrite everything.
• Install product file.
• Register an OAuth Application here, using:
  • Application Name: Your Site!
  • Description: Site Integration into Twitter.
  • (I request this one not be changed!) Application Website: https://vborg.vbsupport.ru/showthread.php?t=204694
  • Website: Your URL!
  • Application Type: Browser
  • (change url) Callback URL: http://www.yoururl.com/twitter_auth.php
  • Default Access type: Read & Write
• Gain and copy the Consumer Key & Secret into vBulletin Options.

Upgrading to v1.0.3 or before.

• Upload all files, overwrite everything.
• install product file.
• Remove template edits. For the record, they are here:
  • Open the postbit or postbit_legacy template (depending on what you use). Find:
    

    <if condition="$show['postcount']">#<a href="showpost.php?$session[sessionurl]p=$post[postid]&amp;postcount=$post[postcount]" target="new" rel="nofollow" id="postcount$post[postid]" name="$post[postcount]"><strong>$post[postcount]</strong></a></if>

    Add before that:
    

    <if condition="$post['twitter_username']"><a href="tweet.php?do=post&amp;id=$post[postid]&amp;c=$post[postid]">Tweet this post!</a></if>

  • Open the SHOWTHREAD template.
    Find:
    

    	<if condition="$show['addpoll']">
    	<tr>
    		<td class="vbmenu_option"><img class="inlineimg" src="$stylevar[imgdir_button]/addpoll.gif" alt="$vbphrase[add_a_poll]" /> <a href="poll.php?$session[sessionurl]do=newpoll&amp;t=$threadinfo[threadid]">$vbphrase[add_a_poll_to_this_thread]</a></td>
    	</tr>
    	</if>

    Add After:
    

    	<if condition="$vbulletin->userinfo['twitter_username']">
    	<tr>
    		<td class="vbmenu_option">
    			<a href="tweet.php?do=thread&ampid=$threadinfo[threadid]">Tweet This  Thread!</a>
    		</td>
    	</tr>
    	</if>

    Find:
    

    		<if condition="!$show['search_engine']">
    
    			<div><img class="inlineimg" src="$stylevar[imgdir_button]/printer.gif" alt="$vbphrase[show_printable_version]" vspace="1" /> <a href="printthread.php?$session[sessionurl]t=$threadid" rel="nofollow">$vbphrase[show_printable_version]</a></div>
    			<div><img class="inlineimg" src="$stylevar[imgdir_button]/sendtofriend.gif" alt="$vbphrase[email_this_page]" vspace="1" /> <a href="sendmessage.php?$session[sessionurl]do=sendtofriend&amp;t=$threadid" rel="nofollow">$vbphrase[email_this_page]</a></div>
    		</if>

    Add After:
    

    		<if condition="$vbulletin->userinfo['twitter_username']"><a href="tweet.php?do=thread&amp;id=$threadinfo[threadid]">Tweet This  Thread!</a></if>

Requirements

THIS MODIFICATION REQUIRES PHP 5 DUE TO THE CLASS THAT IS USED!

PHP'S CURL EXTENSION IS ALSO USED! THE API CALLS ARE COMPLETELY DEPENDENT ON THEM!

This modification should work on vBulletin v3.5+, but was only tested on a vB 3.8 install.

Using the "tp.php" switch added in v1.0.2

With the release of v1.0.2, a switch between showpost.php?p=ID&postcount=COUNT and showthread.php?p=ID#postID has been added. Using it is simple, but requires a code edit (Note: This is a SUPPORTED code edit!). Open up tp.php and find this line:

PHP Code:

define('SHOWPOST', true); 


Change that line to this:

PHP Code:

define('SHOWPOST', false); 


This will automatically trigger the change any time it is loaded. This works retroactively and any links will automatically use the new settings once changed!

[Joe Gronlund]

I really like this mod, but I get many errors when testing it to uninstall, if I ever need too..

Upon uninstalling errors:

Invalid SQL:
ALTER TABLE `user`  DROP `twitter_password`, `twitter_username`;

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 '`twitter_username`' at line 1
Error Number  : 1064
Request Date  : Tuesday, February 10th 2009 @ 10:00:54 PM
Error Date    : Tuesday, February 10th 2009 @ 10:00:54 PM
Script        : http://www.windows7liveforums.com/admincp/plugin.php?do=productkill

Thanks,,

[King Kovifor]

Your getting errors while testing it? But thanks for the uninstall errors.

[Joe Gronlund]

Originally Posted by King Kovifor

Your getting errors while testing it? But thanks for the uninstall errors.

No, I was making sure it would uninstall, and it won't.. I was trying to remove it..

[King Kovifor]

Quick fix. Split it up into 2 queries: both same front with a single table name at the end. I'll see about getting a fix out tomorrow.

[Joe Gronlund]

Originally Posted by King Kovifor

Quick fix. Split it up into 2 queries: both same front with a single table name at the end. I'll see about getting a fix out tomorrow.

Okay,, thank you.....

[King Kovifor]

Anytime.

[DotSauce]

This is cool, I can't wait to try it out cause I have a Twitter vB community (http://TweetSocial.com)

I would love to see an additional feature where users can Tweet *anything* at all directly from the forum. Also Twitter API allows you to define where the tweet is coming from and would give a backlink to the forum for each tweet a user sends out.

Like instead of "from web" or "from twitterific" it would be "from TweetSocial" or "from YourForum"

Thanks for this!

[Joe Gronlund]

Originally Posted by DotSauce

This is cool, I can't wait to try it out cause I have a Twitter vB community (http://TweetSocial.com)

I would love to see an additional feature where users can Tweet *anything* at all directly from the forum. Also Twitter API allows you to define where the tweet is coming from and would give a backlink to the forum for each tweet a user sends out.

Like instead of "from web" or "from twitterific" it would be "from TweetSocial" or "from YourForum"

Thanks for this!

Great site you have there, being Twitter/Tweet based, and the look/style..

[ragtek]

Originally Posted by DotSauce

Also Twitter API allows you to define where the tweet is coming from and would give a backlink to the forum for each tweet a user sends out.

realy?

i thought this is not possible for communities, because i also wanted that my add-on have it's own name!

thats from the faq:

How do I get ?from [MyApp]? appended to updates sent from my API application?

Just fill out this handy form! Note that you must have a Twitter account and must be signed in to submit the form. We only approve applications and sites that appear legitimate and in the best interest of Twitter, Inc. and our community. We do not approve requests to link to personal sites and weblogs, marketing materials, or anything that rubs us the wrong way.

[King Kovifor]

I'll be posting updates using the @vBTwit account on Twitter. So follow me here:

http://twitter.com/vBTwit