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)

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!


All times are GMT. The time now is 11:10 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.01379 seconds
  • Memory Usage 1,746KB
  • 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
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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