Skip to Content Skip to Menu

🌲 Merry Christmas! Great savings on Professional and Developer Memberships! Get 25% off now with code XMAS-2024!

MySQL Field Type Plugin

12 years 3 months ago #209190 by Ptit Philippe
Replied by Ptit Philippe on topic Re: MySQL Field Type Plugin
works perfectly !
THANKS

Please Log in or Create an account to join the conversation.

  • klrogers
  • klrogers
  • OFFLINE
  • Posts: 3
  • Thanks: 1
  • Karma: 1
12 years 2 months ago #211018 by klrogers
Replied by klrogers on topic Re: MySQL Field Type Plugin
Hello! I'm writing to ask for advice because I can't get this plugin to work, and it would be GREAT if it did. I'm just trying to do a very simple test query:
SELECT usertype FROM j25_users WHERE id={USERID}
The field should appear on the "Additional Information" tab in a user's Community Builder profile. It is the only thing on that tab.
Well, the tab doesn't even appear; it's as if the query never took place, and the field was never created. I've tried every variation of the query I can think of.
My server reports this error, but I don't know if it's related:
[Thu Sep 27 13:40:35 2012] [error] [client ---.---.--.--] File does not exist: /home/.../public_html/administrator/js, referer: http://.../administrator/index.php?option=com_comprofiler&task=showField
Any advice?
THANK YOU!
Krista

Please Log in or Create an account to join the conversation.

  • Aadriak
  • Aadriak
  • OFFLINE
  • Posts: 1
  • Thanks: 0
  • Karma: 0
11 years 11 months ago #218012 by Aadriak
Replied by Aadriak on topic Re: MySQL Field Type Plugin
Hi I currently have a field called cb_gamertag, I want to use the info entered into this field in another field called cb_servicerecord. This service record needs to basically output url.com/cb_gamertag . Can I do that with this plug in?

Please Log in or Create an account to join the conversation.

  • sputum
  • sputum
  • OFFLINE
  • Posts: 26
  • Thanks: 0
  • Karma: 0
11 years 8 months ago #223827 by sputum
Replied by sputum on topic Re: MySQL Field Type Plugin
hi,

i want to calculate a value from 3 fields ((cb_td)*6, cb_ep1, cb_ep2)

but it doesnt work. can somebody help me to get this thing started?!

regards, peter

Please Log in or Create an account to join the conversation.

11 years 8 months ago #224138 by mauriestate
Replied by mauriestate on topic MySQL Field Type Plugin
Hi,

We are trying to get ZOO items to get displayed in the user profile using this plugin but we cannot make it working as, to be honest, we are not that good with mysql, can you please help us to get it working? We are using CB 1.9 and Joomla 2.5.9. Thanks.

Please Log in or Create an account to join the conversation.

  • fribse2011
  • fribse2011
  • OFFLINE
  • Posts: 921
  • Thanks: 79
  • Karma: 8
11 years 8 months ago #224896 by fribse2011
Replied by fribse2011 on topic MySQL Field Type Plugin
Don't understand why I can't make it work, I have the JoomlaPolis plugin running at the moment, but I would love to use the feature that it can store the result in a field.
The Joomlapolis plugin has this query:
SELECT `by` FROM `kef_postnumre` WHERE `nr` = '[cb_postnummer]'
The setup I've entered in this plugin are:



But when I view the profile, it doesn't show anything?

Best regards
Fribse

Frømandsklubben Nikon, www.nikondyk.dk
We're a volunteer driven diving club in Ishøj, Denmark.
Har du brug for en dykkerklub der rummer alle, så kom ned til os.
Attachments:

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum