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!

[King Kovifor]

OK. After spending the last hour trying to figure out Mcrypt (which I did get to work, rather fast too) it's still not decrypting and encrypting values as expected... So it most likely won't be done tonight.

[Joe Gronlund]

While installing

Importing Product, Please Wait...

[:]
Database Error     Database error
The Windowsliveforums.com database has encountered a problem.

Database error in vBulletin 3.8.1:

Invalid SQL:
ALTER TABLE `user` ADD (`twitter_username` VARCHAR( 255 ) NOT NULL ,`twitter_password` VARCHAR( 255 ) NOT NULL);

MySQL Error   : Duplicate column name 'twitter_username'
Error Number  : 1060
Request Date  : Saturday, February 14th 2009 @ 09:53:24 PM
Error Date    : Saturday, February 14th 2009 @ 09:53:24 PM
Script        : http://www.windows7liveforums.com/admincp/plugin.php?do=productimport
Referrer      : http://www.windows7liveforums.com/admincp/plugin.php?do=productadd
IP Address    : 99.xxx.xxx.xxx
Username      : Joe Gronlund
Classname     : vB_Database
MySQL Version : 5.0.67-community

[King Kovifor]

Originally Posted by Joe Gronlund

While installing

Importing Product, Please Wait...

[:]
Database Error     Database error
The Windowsliveforums.com database has encountered a problem.

Database error in vBulletin 3.8.1:

Invalid SQL:
ALTER TABLE `user` ADD (`twitter_username` VARCHAR( 255 ) NOT NULL ,`twitter_password` VARCHAR( 255 ) NOT NULL);

MySQL Error   : Duplicate column name 'twitter_username'
Error Number  : 1060
Request Date  : Saturday, February 14th 2009 @ 09:53:24 PM
Error Date    : Saturday, February 14th 2009 @ 09:53:24 PM
Script        : http://www.windows7liveforums.com/admincp/plugin.php?do=productimport
Referrer      : http://www.windows7liveforums.com/admincp/plugin.php?do=productadd
IP Address    : 99.xxx.xxx.xxx
Username      : Joe Gronlund
Classname     : vB_Database
MySQL Version : 5.0.67-community

That's cause your trying to install v1.0.0 again. I haven't updated the product yet. I just said it was nearing completion. Installing now, you'll get no added features. And that's where your problem is coming from -- you already have it installed (or uninstalled and the tables weren't dropped, if that's the case tell me), so the tables it's trying to add in 1.0.0 are already in the database.

[King Kovifor]

It is now also gonna have an image beside "Tweet this Thread!" It's not the best, but I think it looks rather good!

[Joe Gronlund]

Originally Posted by King Kovifor

That's cause your trying to install v1.0.0 again. I haven't updated the product yet. I just said it was nearing completion. Installing now, you'll get no added features.

It was actually uninstalled when I tried to reinstall it when I received that error, but I will wait for the next release..

[DebtFree]

Great looking idea and I will keep following this hack.

One suggestion I have though is to use Custom Profile Fields for the twitter details and enter the field ID in an ACP option. The reason for this is that I already have a hack which places the users latest tweets in their profile. To do this they need to enter their twitter id in a custom profile fileds ... so it seems silly to ask them for the same thing again.

[King Kovifor]

Originally Posted by DebtFree

Great looking idea and I will keep following this hack.

One suggestion I have though is to use Custom Profile Fields for the twitter details and enter the field ID in an ACP option. The reason for this is that I already have a hack which places the users latest tweets in their profile. To do this they need to enter their twitter id in a custom profile fileds ... so it seems silly to ask them for the same thing again.

That's going to be in the next version.

Originally Posted by Joe Gronlund

It was actually uninstalled when I tried to reinstall it when I received that error, but I will wait for the next release..

I will post up proper queries later (I don't have access here).

[hmccaig]

Where can I change the default that it leaves on Twitter: "Check this out!" - to something else? Something like, "Read this topic in our forums!"

[King Kovifor]

hmccaig, search for the phrase twitter_check I believe. If that isn't it, search for twitter_ in car names and one will say "Check this out!".

[hmccaig]

In which file do I do this? Thanks!