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!

[ludomatic]

Originally Posted by dvsDave

The developer is aware of this issue. It's being worked on. In the meantime... what theme are you using? It looks nice!

Is a theme that created the ex-admin of the site, the complete name is "MacAdicto Grey". I guess him has used other theme base and created this last. Hugs from Argentina and sorry for my poor English!

[King Kovifor]

Originally Posted by ludomatic

Hi! i can do work the vBTwitter....but in the "Thread Tool" i see 2 times the same option :S
I looking inside the code I did not find any reason to appear 2 times, somebody help me!! Thank you so much again!

You didn't remove the template edits. They are listed in the first post for you to remove.

Originally Posted by tr03bor

Can you add this to the registration page to? So new members can fill it in?

I can see about it.

Originally Posted by tr03bor

Also having this issue!

I'm working on it.

[Joe Gronlund]

I still cannot reinstall, i uninstalled the last version with no errors at all?? KK ?? Do you need my admin user, pass???

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  : Tuesday, February 17th 2009 @ 03:39:52 PM
Error Date    : Tuesday, February 17th 2009 @ 03:39:52 PM
Script        : http://www.windows7liveforums.com/admincp/plugin.php?do=productimport
Referrer      : http://www.windows7liveforums.com/admincp/plugin.php?do=productadd
IP Address    : 99.247.xxx.xxx
Username      : Joe Gronlund
Classname     : vB_Database
MySQL Version : 5.0.67-community

[ragtek]

Originally Posted by Joe Gronlund

I still cannot reinstall, i uninstalled the last version with no errors at all?? KK ?? Do you need my admin user, pass???

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  : Tuesday, February 17th 2009 @ 03:39:52 PM
Error Date    : Tuesday, February 17th 2009 @ 03:39:52 PM
Script        : http://www.windows7liveforums.com/admincp/plugin.php?do=productimport
Referrer      : http://www.windows7liveforums.com/admincp/plugin.php?do=productadd
IP Address    : 99.247.xxx.xxx
Username      : Joe Gronlund
Classname     : vB_Database
MySQL Version : 5.0.67-community

your true
there's something missing in the deinstallcode

[King Kovifor]

Originally Posted by Joe Gronlund

I still cannot reinstall, i uninstalled the last version with no errors at all?? KK ?? Do you need my admin user, pass???

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  : Tuesday, February 17th 2009 @ 03:39:52 PM
Error Date    : Tuesday, February 17th 2009 @ 03:39:52 PM
Script        : http://www.windows7liveforums.com/admincp/plugin.php?do=productimport
Referrer      : http://www.windows7liveforums.com/admincp/plugin.php?do=productadd
IP Address    : 99.247.xxx.xxx
Username      : Joe Gronlund
Classname     : vB_Database
MySQL Version : 5.0.67-community

This is still remnant of your original install (as with the bug you originally posted). Run this query and do the install again.

Also, be sure to add your prefix before user.

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

[dvsDave]

Alright, I finally got mcrypt installed.

mcrypt
mcrypt support
enabled
Version
2.5.8
Supported ciphers
cast-128 gost rijndael-128 twofish arcfour cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes
Supported modes
cbc cfb ctr ecb ncfb nofb ofb stream

But I get a warning message at the top of the edit options page:

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 2

Update: I should note that everything appears to work, but the error is still there even after logging in to twitter.

Update 2: After I posted one tweet, the message went away.

Update 3: I'm also getting the multiplying "Tweet This Post!" issue.

[King Kovifor]

Originally Posted by dvsDave

Alright, I finally got mcrypt installed.

mcrypt
mcrypt support
enabled
Version
2.5.8
Supported ciphers
cast-128 gost rijndael-128 twofish arcfour cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes
Supported modes
cbc cfb ctr ecb ncfb nofb ofb stream

But I get a warning message at the top of the edit options page:

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 2

Known error, add a password and it'll be fixed.

[dvsDave]

Originally Posted by King Kovifor

Known error, add a password and it'll be fixed.

okay. Is there anyway to suppress that message if the twitter_password field is NULL ?

[King Kovifor]

Yes, I just haven't got it codes yet.

[RedeemedWarrior]

I'm getting that multi tweet message too