MySQL Field Type Plugin

medaacek wrote:

In my jos_comprofiler database table there is a field "cb_recordedspecies" that contains all the recorded bird species of the user, the species are substituted by a simple code:

b1|*|b2|*|b3|*|b4|*|b5|*|b6|*|b7|*|b8|*|b9|*|b10

each b is different bird

thanks for sharing man

but this bit 'the species are substituted by a simple code'... how can this be done? Ive checked out cb substitutions etc, but this refers to something else. Is this substituting done with backend code? if so, any tips on how it can be done (from anyone) would be much appreciated.

my query is also species related, but fish not birds. so very similar in the functioning, i would think.

from the front end, users must see the actual species, but for counting from the backend i can see the value in having it substituted with a simple code - but dont know how to do it! lol

any ideas? thanks folks

You may be able to do something like this (untested):

This should count the number of * which is used to separate each fish. Then add 1 as there is always 1 more fish then separator.

The only problem I could see with this approach is if cb_species2010 was not a required field. Then people with 0 ticks will be shown as having 1 because of the +1.

I hope this helps!

Hi,
I would love to use this fantastic plugin, but somehow it seems not compatible with CB 1.3.1
Has this ever been updated to work in the latest CB version?
Can anyone else confirm this?

Thank you

serjo wrote: Hi,
I would love to use this fantastic plugin, but somehow it seems not compatible with CB 1.3.1
Has this ever been updated to work in the latest CB version?
Can anyone else confirm this?

Thank you

I depend upon this plugin, so when I saw a note that it wasn't working with CB 1.3.1, I stopped upgrading CB and have stopped at 1.3. I too am looking for some hard confirmation of whether this really doesn't work with 1.3.1 or when it will work with CB again.

I have just upgraded a site using 4 MySQL fields to CB 1.3.1 and they are all still working fine. I cant see any problems or errors.

Let me know if anyone has any problems after upgrading.

Well,

using those fields in user list always gives an 500 error on the page.
They don´t seem to work anymore.
I made a single select from a table and wanted to display that field in a user list. Does not work anymore on 1.3.1 when using php5.3. An Installation with 5.2.9 is still working.


Any ideas?


Regards
Some1new