vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Integration with vBulletin - vBTwitter (https://vborg.vbsupport.ru/showthread.php?t=204694)

Joe Gronlund 02-12-2009 04:20 PM

Quote:

Originally Posted by King Kovifor (Post 1741293)
I'll be posting updates using the @vBTwit account on Twitter. So follow me here:

http://twitter.com/vBTwit


Great MOD,, splitting into two MySQL queries to DROP did work to uninstall BTW..

Are you going to be making an option to tweet not just what is in the thread, but just a personal tweet we may want to add, or a standalone tweet all together???

Keep up the great work,,

Joe

King Kovifor 02-12-2009 07:05 PM

Quote:

Originally Posted by Joe Gronlund (Post 1742049)
Great MOD,, splitting into two MySQL queries to DROP did work to uninstall BTW..

Are you going to be making an option to tweet not just what is in the thread, but just a personal tweet we may want to add, or a standalone tweet all together???

Keep up the great work,,

Joe

Yeah. Most likely in v1.1 which is the next feature update. And I've placed the uninstall error into my log and will get it fixed for v1.0.1 which I'm working on finishing up.

To anyone interested, public bug and feature tracker located at http://www.smnlikdat.org/project.php?projectid=5.

ArnyVee 02-12-2009 11:44 PM

This mod has some pretty good potential....thanks for this one KK! :D

*tagged*

ludomatic 02-13-2009 03:20 AM

Hi! i can't find the name of this addons inside my vB. Which's the name of this addon?
and somebody could write the troubleshooting from this addon inside the vB. Thank so much and sorry for my poor English.-

https://vborg.vbsupport.ru/

King Kovifor 02-13-2009 06:58 PM

Quote:

Originally Posted by ludomatic (Post 1742501)
Hi! i can't find the name of this addons inside my vB. Which's the name of this addon?
and somebody could write the troubleshooting from this addon inside the vB. Thank so much and sorry for my poor English.-

http://img.skitch.com/20090213-kx87a...w6djkewhmf.png

This add-on does not add any options at this time. So, it will not appear there. What do you need help with this?

ludomatic 02-13-2009 11:04 PM

Quote:

Originally Posted by King Kovifor (Post 1743171)
This add-on does not add any options at this time. So, it will not appear there. What do you need help with this?

I don't know where input the "twitter account" :S This is my only problem. Thank you for you help

King Kovifor 02-14-2009 03:04 AM

Quote:

Originally Posted by ludomatic (Post 1743334)
I don't know where input the "twitter account" :S This is my only problem. Thank you for you help

User CP -> Edit Options -> vBTwitter (at the far bottom)

King Kovifor 02-14-2009 11:47 PM

v1.0.1 is nearing completion. Some of the highlights:
  • Bug Fixes
    • Ability to uninstall (I fixed the SQL query)
    • Added missing ; in the Tweet this Thread!
  • Completely phrased.
  • New vBTwitter source parameter, any tweets show as coming from this mod (instead of web).
  • Removed extra query on updating options.
  • mcrypt integration (encrypted password)
There is also a new minor but major new feature coming along with v1.0.1!

Joe Gronlund 02-15-2009 12:25 AM

Very nice..

Installing....

Brandon Sheley 02-15-2009 12:40 AM

Quote:

Originally Posted by King Kovifor (Post 1744345)
v1.0.1 is nearing completion. Some of the highlights:
  • Bug Fixes
    • Ability to uninstall (I fixed the SQL query)
    • Added missing ; in the Tweet this Thread!
  • Completely phrased.
  • New vBTwitter source parameter, any tweets show as coming from this mod (instead of web).
  • Removed extra query on updating options.
  • mcrypt integration (encrypted password)
There is also a new minor but major new feature coming along with v1.0.1!

nice :up:

King Kovifor 02-15-2009 12:50 AM

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 02-15-2009 12:55 AM

While installing

Code:

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 02-15-2009 01:00 AM

Quote:

Originally Posted by Joe Gronlund (Post 1744407)
While installing

Code:

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 02-15-2009 03:37 AM

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 02-15-2009 03:55 AM

Quote:

Originally Posted by King Kovifor (Post 1744414)
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 02-15-2009 10:15 AM

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 02-15-2009 02:33 PM

Quote:

Originally Posted by DebtFree (Post 1744688)
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.

Quote:

Originally Posted by Joe Gronlund (Post 1744533)
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 02-15-2009 06:42 PM

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 02-15-2009 08:08 PM

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 02-15-2009 08:59 PM

In which file do I do this? Thanks!

ragtek 02-15-2009 09:03 PM

You don't need to edit a file;) You can manage the phrases in your acp
http://www.vbulletin.com/docs/html/l...es_and_phrases

King Kovifor 02-15-2009 09:08 PM

ACP -> Language & Phrases -> Search in Phrases -> twitter_ -> Varname only -> search -> edit next to the "check this out". Add what you want in the English box.

hmccaig 02-15-2009 09:16 PM

perfect! thanks!

mykkal 02-15-2009 10:09 PM

Is there a demo anywhere?

King Kovifor 02-15-2009 11:25 PM

Actually no, Ill be sure to get some screenshots out. :)

itsbobtista 02-16-2009 01:18 AM

I do have one issue...

It seems as though I can't tweet other people's posts. Any way to enable the user to tweet other people's posts?

King Kovifor 02-16-2009 01:24 AM

You sir, have found a major bug in v1.0.0! I to discovered that yesterday as I was writing a new feature. I was using the wrong set of data. Changing $post to $vbulletin->userinfo within the template edits (postbit & postbit_legacy) will fix it.

itsbobtista 02-16-2009 01:31 AM

Quote:

Originally Posted by King Kovifor (Post 1745486)
You sir, have found a major bug in v1.0.0! I to discovered that yesterday as I was writing a new feature. I was using the wrong set of data. Changing $post to $vbulletin->userinfo within the template edits (postbit & postbit_legacy) will fix it.

Will do :) Thanks for the fix. Great mod; I nominated it!

Have a good one.

King Kovifor 02-16-2009 01:42 AM

Yep. ;)

itsbobtista 02-16-2009 01:49 AM

One more question...

PHP Code:

<if condition="$post to $vbulletin->userinfo['twitter_username']"><a href="tweet.php?do=post&amp;id=$post[postid]&amp;c=$post[postid]">Tweet this post!</a></if> 

Are you saying it should look like that? Or should it look like this...


PHP Code:

<if condition="$post to $vbulletin->userinfo['twitter_username']"><a href="tweet.php?do=post&amp;id=$vbulletin->userinfo[postid]&amp;c=$vbulletin->userinfo[postid]">Tweet this post!</a></if> 


King Kovifor 02-16-2009 01:55 AM

In your first one, you have $post to $vbulletin. Remove "$post to" and it should work.

itsbobtista 02-16-2009 02:04 AM

Quote:

Originally Posted by King Kovifor (Post 1745510)
In your first one, you have $post to $vbulletin. Remove "$post to" and it should work.

D'oh. That was a typo on my part. I copied+pasted what you told us to add and I accidentally copied the "to" :-P Let me try that...

So, now it's set as:
PHP Code:

<if condition="$vbulletin->userinfo['twitter_username']"><a href="tweet.php?do=post&amp;id=$post[postid]&amp;c=$post[postid]">Tweet this post!</a></if> 

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.

itsbobtista 02-16-2009 02:07 AM

It would look fine if the link I clicked from Twitter opened in a new window that sized itself, but it opens as a new tab and it kind of messes up the width on the tables cause it's not meant to be that wide. See what I mean?

King Kovifor 02-16-2009 02:27 AM

Yes, that code is correct. Also, it was designed to use the single post view. Since (1) it gives you the content you wanted and (2) it includes a link to the original thread. Of course, you could set it up to redirect to the thread view instead.

itsbobtista 02-16-2009 02:36 AM

Quote:

Originally Posted by King Kovifor (Post 1745530)
Yes, that code is correct. Also, it was designed to use the single post view. Since (1) it gives you the content you wanted and (2) it includes a link to the original thread. Of course, you could set it up to redirect to the thread view instead.

Ah, you're right. I wish I knew more about coding :-P I am slowly learning though. Alright, I will stop bugging you now! Thanks again King Kovifor.

ijob 02-16-2009 07:28 AM

Hi,

when trying to submit a thread I get this message:

Quote:

We're sorry, but this post or thread could not be tweeted because you have not specified an ID. Please try again.

hmccaig 02-16-2009 12:45 PM

Okay, one more quick question on this. I changed it so now it says: This is a great read in our forums!http://www.pinkinkstudios.net/discus...hp?i=369&c=369


But, as you can see, it doesn't put a space after the "!" and therefore, the link isn't clickable. I only added the text change - and nothing more...then, I tried putting a space after. Thanks for all your help!

dvsDave 02-16-2009 01:21 PM

Could you add support for a hashtag that the admin can define so we can find the tweets in the twitterverse ?

Brandon Sheley 02-16-2009 05:24 PM

Quote:

Originally Posted by dvsDave (Post 1745886)
Could you add support for a hashtag that the admin can define so we can find the tweets in the twitterverse ?

oo, good idea :)

King Kovifor 02-16-2009 06:51 PM

Quote:

Originally Posted by ijob (Post 1745690)
Hi,

when trying to submit a thread I get this message:

There's a bug in which I forgot to add the ";" in the template. This is fixed in v1.0.1.

Quote:

Originally Posted by hmccaig (Post 1745868)
Okay, one more quick question on this. I changed it so now it says: This is a great read in our forums!http://www.pinkinkstudios.net/discus...hp?i=369&c=369


But, as you can see, it doesn't put a space after the "!" and therefore, the link isn't clickable. I only added the text change - and nothing more...then, I tried putting a space after. Thanks for all your help!

You should place a space after the "!" in the phrase so it reads: "This is a great read in our forums! ". I purposely didn't place a space in the code, that's located inside of the phrase.

Quote:

Originally Posted by dvsDave (Post 1745886)
Could you add support for a hashtag that the admin can define so we can find the tweets in the twitterverse ?

I will see about that. ;) Added to the feature tracker.

EDIT: After second thought, though I don't have this as a specific feature, you can do this by adding a hash tag into the phrase.


All times are GMT. The time now is 02:35 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01731 seconds
  • Memory Usage 1,849KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (3)bbcode_php_printable
  • (18)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete