Warning:

Note: We absolutely, 100% do not recommend doing direct database calls within our software. We often add and remove columns within the database, which may break any sort of custom code that you use. We highly recommend that you use the ElevatedX Template API. More information is here:

https://cs.elevatedx.com/index.php?rp=/knowledgebase/331/Introduction-to-the-PHP-Templating-API.html

However, if the fastest way for you to no longer use these columns is changing the database column that's used, more info on this is below.

Abstract:

In versions of our software dated after February 14th, 2024, our software removes the following columns from the software:

category.PreviewXML_PHP
category.extrafields_PHP

contentgroup.PreviewXML_PHP
contentgroup.extrafields_PHP

plg_contentasc.PreviewXML_PHP
plg_contentasc.extrafields_PHP

plg_dvdasc.PreviewXML_PHP
plg_dvdasc.extrafields_PHP

plg_bonus.PreviewXML_PHP

These database columns were used for the smarty template language within our system, which is no longer supported or present within current builds of the software.

Any of your custom code that refers to any of these colunns will need to be updated to refer to updated columns that the PHP templating engine does use:

category.PreviewXML_PHP => category.info
category.extrafields_PHP => category.extrafields_PH2

contentgroup.PreviewXML_PHP => contentgroup.info
contentgroup.extrafields_PHP => contentgroup.extrafields_PH2

plg_contentasc.PreviewXML_PHP => plg_contentasc.info
plg_contentasc.extrafields_PHP => plg_contentasc.extrafields_PH2

plg_dvdasc.PreviewXML_PHP => plg_dvdasc.info

plg_bonus.PreviewXML_PHP => plg_bonus.info

Notes on the difference between extrafields_PHP and extrafields_PH2:

Both extrafields_PHP and extrafields_PH2 are columns that are serialized using PHP's serialize() function. When you unserialize the data in both of these, the structure is different:

Example of extrafields_PHP

Array
(
    [extras] => Array
        (
            [age] => Array
                (
                    [0] => 18
                )

            [location] => Array
                (
                    [0] => USA
                )

            [haircolor] => Array
                (
                    [0] => Black
                )

            [height] => Array
                (
                    [0] => 5'6"
                )
        )

)

Example of the same data in Extrafields_PH2:

Array
(
    [age] => 18
    [location] => USA
    [haircolor] => Black
    [height] => 5'6"
)

In Extrafields_PH2, there is no ["extras"] array that contains the values. Also, each extrafield is no longer an array where the value is in the first element.

Notes on the difference between PreviewXML_PHP and info:

In PreviewXML_PHP, thumbnail information is stored in ["previewroot"]["element"]["item_attr"]. In info, this is stored in ["thumbs"]

In PreviewXML_PHP, category information is stored in ["previewroot"]["category"]["item_attr"]. In info, this is stored in ["categories"]

In PreviewXML_PHP, content total information is stored in ["previewroot"]["content"] with subarrays ["types"] and ["names"]. In info, this is stored in ["totals"]

In PreviewXML_PHP, models that a set has is stored in ["previewroot"]["sets"]. In info, this is stored in ["models"]