Where does the data comming from within custom field db table "show_in"

This topic contains 4 replies, has 2 voices, and was last updated by  Stiofan O’Connor 8 years, 6 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • #265600

    wci
    Expired Member
    Post count: 1035

    Hi Support team,

    I need to know how this new table tab works within geodir_custom_fields table.

    Where does the data comes from because after upgrade there are data existing in the fields?

    I know that within backend I will be able to add those data by choosing them out on settings.
    > http://screencast.com/t/IVOrzDepb97
    but I need to know where the data comes from stated on existing fields within database > http://screencast.com/t/32obwqhxRf.

    eg. show_on_detail = 1 means then in show_in [moreinfo]
    is_default = 1 means then in show_in [detail]
    show_on_listing =1 means then in show_in [listing]

    What does show_in [mapbubble] mean and which field in db table does the setting 0 or 1 at?

    Where does the [owntab] setting comes from within Database table?

    Looking forward to your advices.

    Thanks Alex

    #265628

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hi Alex,

    These are just names for the standard locations we have in the plugin for example mapbubble means show in the map popup bubble infowindow.

    I am not sure what you are trying to do, these are standard locations from an array in code, you can extend it if you want but i am not sure that is what you mean?

    Stiofan

    #265649

    wci
    Expired Member
    Post count: 1035

    Hi Steofan,

    for my multiple custom fields creation I have established a excel template to setup the data via formula according field_types and settings form GD backend by export/re-import into database.

    1. I create custom fields in backend
    2. I export the custom fields data table
    3. I use the excel table with furmula to create and add changes of the settings e.g. price categories and data values to copy paste
    4. then I re-import the settings as csv file.

    For this I need to know if the existing table columns are used to create those new settings in the column “show_in”.

    e.g. the column “field_type_key” is same as “field_type” data so I can copy paste those settings within.

    Using now same idea for column “show_in” data I would use then a formula to create those data settings to setup the data in excel template.

    That is why I come to this conclusion:

    eg. show_on_detail = 1 means then in show_in [moreinfo]
    is_default = 1 means then in show_in [detail]
    show_on_listing =1 means then in show_in [listing]

    AND

    Where does the [owntab] setting comes from within Database table?

    Regards, Alex

    #265700

    wci
    Expired Member
    Post count: 1035

    P.S. In other words, are the columns show_on_listing, show_on_detail; show_as_tab depreciated now or are these still in use?

    I mean are those 0 / 1 settings still in use or is the show_in with dropdown now favorite to be used instead.

    Screen shot > http://screencast.com/t/ZlVmVLNU1s5K

    #266178

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    They are depreciated, this conversion function should make things clearer:
    https://github.com/GeoDirectory/geodirectory/blob/master/upgrade.php#L275

    Thanks,

    Stiofan

Viewing 5 posts - 1 through 5 (of 5 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount