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!

[rjerina]

I tried searching but didn't find anything, but instead of storing password or prompting for a password, how do sites like Twitpic etc authenticate? They somehow pick up your authentication to twitter and they just work, I assume with something through the API.

Forgive me if this was posted already. I am interested in this but don't want to store any passwords unencrypted if possible and very little use integration.

[johnbmtl]

When I click on the link in th euser options "Setup integration by clicking here."

I get the following from the twitter site:

Woah there!
This page is no longer valid. It looks like someone already used the token information you provided. Please return to the site that sent you to this page and try again … it was probably an honest mistake.

Did I miss something in the installation?

------------------
Update: Yes I did miss something in the installation.
The instructions to register an OAuth Application which appear under the Upgrading instructions also apply to new installations.

Everything works fine now.

[ClipBucket]

To post the title for threads to Twitter, edit tweet.php
Find the section that starts with:

PHP Code:

if($_GET['do'] == 'thread')
{ 


Find:

PHP Code:

$twitter->OAuthRequest('https://twitter.com/statuses/update.xml', array('status' => $vbphrase['twitter_checkout'] . $vbulletin->options['bburl'] . '/tt.php?i=' . $vbulletin->GPC['id']), 'POST'); 


Change to:

PHP Code:

$thread = $db->query_first("SELECT title FROM " . TABLE_PREFIX . "thread WHERE threadid = " . $vbulletin->GPC['id']);
$twitter->OAuthRequest('https://twitter.com/statuses/update.xml', array('status' => $thread['title'] .' - '. $vbulletin->options['bburl'] . '/tt.php?i=' . $vbulletin->GPC['id']), 'POST'); 


This only works when Twittering a thread.
I have not looked into sending post titles yet, though it should also be trivial.

[ClipBucket]

This is not tested.

To post the title for posts to Twitter, edit tweet.php
Find the section that starts with:

PHP Code:

if($_GET['do'] == 'post')
{ 


Find:

PHP Code:

$twitter->OAuthRequest('https://twitter.com/statuses/update.xml', array('status' => $thread['title'] .' - '. $vbulletin->options['bburl'] . '/tp.php?i=' . $vbulletin->GPC['id'] . '&c=' . $vbulletin->GPC['c']), 'POST'); 


Change to:

PHP Code:

        $post = $db->query_first("SELECT title FROM " . TABLE_PREFIX . "post WHERE postid = " . $vbulletin->GPC['id']);
        $twitter->OAuthRequest('https://twitter.com/statuses/update.xml', array('status' => $post['title'] .' - '. $vbulletin->options['bburl'] . '/tp.php?i=' . $vbulletin->GPC['id'] . '&c=' . $vbulletin->GPC['c']), 'POST'); 


[King Kovifor]

Originally Posted by rjerina

I tried searching but didn't find anything, but instead of storing password or prompting for a password, how do sites like Twitpic etc authenticate? They somehow pick up your authentication to twitter and they just work, I assume with something through the API.

Forgive me if this was posted already. I am interested in this but don't want to store any passwords unencrypted if possible and very little use integration.

Well, this doesn't prompt for a password. And twit pic, does. If you go to their site, they prompt for a username / password.

Originally Posted by johnbmtl

When I click on the link in th euser options "Setup integration by clicking here."

I get the following from the twitter site:

Woah there!
This page is no longer valid. It looks like someone already used the token information you provided. Please return to the site that sent you to this page and try again ? it was probably an honest mistake.

Did I miss something in the installation?

------------------
Update: Yes I did miss something in the installation.
The instructions to register an OAuth Application which appear under the Upgrading instructions also apply to new installations.

Everything works fine now.

Guess I missed something their. *wonders why I screwed that up*.

Originally Posted by ClipBucket

To post the title for threads to Twitter, edit tweet.php
Find the section that starts with:

PHP Code:

if($_GET['do'] == 'thread')
{ 


Find:

PHP Code:

$twitter->OAuthRequest('https://twitter.com/statuses/update.xml', array('status' => $vbphrase['twitter_checkout'] . $vbulletin->options['bburl'] . '/tt.php?i=' . $vbulletin->GPC['id']), 'POST'); 


Change to:

PHP Code:

$thread = $db->query_first("SELECT title FROM " . TABLE_PREFIX . "thread WHERE threadid = " . $vbulletin->GPC['id']);
$twitter->OAuthRequest('https://twitter.com/statuses/update.xml', array('status' => $thread['title'] .' - '. $vbulletin->options['bburl'] . '/tt.php?i=' . $vbulletin->GPC['id']), 'POST'); 


This only works when Twittering a thread.
I have not looked into sending post titles yet, though it should also be trivial.

Originally Posted by ClipBucket

This is not tested.

To post the title for posts to Twitter, edit tweet.php
Find the section that starts with:

PHP Code:

if($_GET['do'] == 'post')
{ 


Find:

PHP Code:

$twitter->OAuthRequest('https://twitter.com/statuses/update.xml', array('status' => $thread['title'] .' - '. $vbulletin->options['bburl'] . '/tp.php?i=' . $vbulletin->GPC['id'] . '&c=' . $vbulletin->GPC['c']), 'POST'); 


Change to:

PHP Code:

        $post = $db->query_first("SELECT title FROM " . TABLE_PREFIX . "post WHERE postid = " . $vbulletin->GPC['id']);
        $twitter->OAuthRequest('https://twitter.com/statuses/update.xml', array('status' => $post['title'] .' - '. $vbulletin->options['bburl'] . '/tp.php?i=' . $vbulletin->GPC['id'] . '&c=' . $vbulletin->GPC['c']), 'POST'); 


I thank you for writing this, but it has the problems within itself. It doesn't do character checking. Which is what I have done extensively for the next version.

[ClipBucket]

Originally Posted by King Kovifor

I thank you for writing this....

Thanks & thanks for the original hack.

Originally Posted by King Kovifor

...but it has the problems within itself. It doesn't do character checking. Which is what I have done extensively for the next version.

It should be trivial to escape the characters.
I just threw this together quick to see if it would work.

[King Kovifor]

Yes, I have several shortening steps. It first checks it using a full URL, then shortens the URL, then the title. It should work rather well. I am stuck with v1.1 because I came to depend on AJAX a lot and my AJAX developer left.

[ClipBucket]

Depending on AJAX for what exactly?
By character checking, I'm assuming you meant for checking the title length?

I recommend you put the code on a service like OpenSVN, Google Code or GitHub.
PM me credentials for commit access & I will assist w/ coding.

[ClipBucket]

OK, well I just setup the project on Google Code.
Join Google Code & send me your username, so that I can give you ownership of the project.

[King Kovifor]

Originally Posted by ClipBucket

Depending on AJAX for what exactly?
By character checking, I'm assuming you meant for checking the title length?

I recommend you put the code on a service like OpenSVN, Google Code or GitHub.
PM me credentials for commit access & I will assist w/ coding.

v1.1 is drastically different, and includes AJAX throughout the new features.

Originally Posted by ClipBucket

OK, well I just setup the project on Google Code.
Join Google Code & send me your username, so that I can give you ownership of the project.

Technically, since my project isn't open source, that would be copyright infringement, but, I will just politely ask you to remove it. I have the files in a SVN repository over at CodeSpaces, it is just different as my code isn't open source. If you would like to help, please PM me.