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]

Originally Posted by RedeemedWarrior

I'm getting that multi tweet message too

I'll try to have a fix out by the end of the week. If you want to disable this to go back to the direct edit disable the "Add "Tweet this Post"" plugin.

[RedeemedWarrior]

sounds good

[King Kovifor]

Originally Posted by itsbobtista

But when I check my Twitter, the URL it goes to is:
http://www.atxscene.com/forums/showp...&postcount=414

Which looks funky. Shouldn't it go to forums/showthread.php?p=414&postcount=414 so that it shows the thread and just automatically scrolls to that post? It just makes my style look funky lol you can check it out.

I've added a code switch in v1.0.2 that'll allow you to change this.

[Joe Gronlund]

KK , I still can not install this since I un-installedl it when it had very few features..

Is there some tables I can drop manually to get this installed???

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

See Screenshot


Thank you...

[King Kovifor]

Originally Posted by Joe Gronlund

KK , I still can not install this since I un-installedl it when it had very few features..

Is there some tables I can drop manually to get this installed???

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

See Screenshot


Thank you...

This was on the last page. Guess you missed it, but I don't mind.

Be sure to add your prefix before user.

[sql]ALTER TABLE `user` DROP COLUMN `twitter_password`, DROP COLUMN `twitter_username`[/sql]

[Joe Gronlund]

Originally Posted by King Kovifor

This was on the last page. Guess you missed it, but I don't mind.

Be sure to add your prefix before user.

SQL Query: (how to run queries)
ALTER TABLE `user` DROP COLUMN `twitter_password`, DROP COLUMN `twitter_username`

Worked perfect!~!!

Thank you....

[Mukashi]

Getting this error on users options pages, after users have entered in their passwords for twitter accounts.

Warning: mcrypt_decrypt() [function.mcrypt-decrypt]: The IV parameter must be as long as the blocksize in [path]/profile.php(1873) : eval()'d code on line 5

PHPInfo confirms Mcrypt 2.5.8 installed on the server.

[King Kovifor]

Joe, your welcome.

Mukashi, I know. It was an oversight on my part as during testing I had already had a password. It will be rectified in v1.0.2.

[Capper5016]

When can we expect the updated release?

[King Kovifor]

Originally Posted by Capper5016

When can we expect the updated release?

I didn't have time to work on it today, so hopefully tomorrow.