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 mykkal

Yes they are encrypted. I see all kinds of weird characters in tables twitter_password and twitter_character

twitter_character?

[mykkal]

Originally Posted by King Kovifor

twitter_character?

Sorry, i was mistaken.

There are three tables:
twiiter_username
twitter_character (encrypted)
twitter_size (encrypted)

Any ideas?

[King Kovifor]

You have a twitter_character table?

[mykkal]

no there is no character table. Not even sure why I wrote that. Sorry. It's just the three I mentioned above. I was thinking... There are funny characters there in that table and actually typed it. lol.

I can give you access to admin panel and database if you need to see yourself.

There are three tables:
twiiter_username
twitter_password (encrypted)
twitter_size (encrypted)

Somehow it seems that the vBulletin mod is either sending the wrong authentication information to twitter, is encoding that information wrong, or is not sending it at all.

Again, this is the error I get when I try to tweet the thread.

We're sorry, but the Username and Password provided within your User CP could not be authenticated. Please modify either your Username or Password to match your current Twitter Username / Password and try again.

Another question...Do forum permissions matter?

Another FYI. I just upgraded to php 5.2.8 a few days ago. Does it work on this version? All of my web applications are functioning fine.

[King Kovifor]

mykkal, vBTwitter is working fine. I believe I have narrowed this down to a show stopping bug in the twitter API that has stopped working. I will try to find a fix today or tomorrow, and either rewrite the authentication methods of the twitter class, my authentication verification, or work with Twitter to fix this problem. I've already @twitterapi'd the account to see if it's a bug. This now makes sense in my mind as it stopped working on my dev site, and several other sites have reported it since then. If you are having trouble, I hate to say it, but please be patient as I attempt to work with Twitter and myself and ragtek to solve this!

[mykkal]

Originally Posted by King Kovifor

mykkal, vBTwitter is working fine. I believe I have narrowed this down to a show stopping bug in the twitter API that has stopped working. I will try to find a fix today or tomorrow... This now makes sense in my mind as it stopped working on my dev site, and several other sites have reported it since then.

This is good actually. Then that means I have no unique problems on my side. That's less headache for you and me.

Thanks a bunch. Let me know.

[King Kovifor]

You and me both. I was getting tired of trying to figure out why multiple people were having this exact same problem, at the exact same time after it had worked fine! Disabling the product will prevent any users from utilizing this.

[mykkal]

Do you think this will take weeks or days?

[King Kovifor]

Days. I think I'll be rewriting this to use XML... So, that'll be my top development priority. I'll leave 1.1 to ragtek for now.

[mykkal]

Originally Posted by King Kovifor

Days. I think I'll be rewriting this to use XML... So, that'll be my top development priority. I'll leave 1.1 to ragtek for now.

thats awesome man..