Writing to configuration table

[steelaz]

I'm writing very simple admin module that needs to store one configuration item (property -> value). Is it OK to use WHMCS "configuration" table for this purpose or should I create new table?

[laszlof]

as a general rule of thumb, I tend to create my own tables for configurations. You never know what may or may not happen to those default whmcs tables in the future.

[steelaz]

Thanks, I'll go ahead and create my own table, perhaps there will be more stuff I need to write in the future.

 

One more question, when you read WHMCS tables, do you explicitly enter table name or perhaps table names are defined somewhere in the system? If you enter table name, is prefix always "tbl" or can it be changed somewhere?

[laszlof]

The table names are static. You can use the select_query(), insert_querty(), delete_query(), update_query(), and full_querty() functions to make quick work of sql queries. Take a look at some of the open source modules and reports for examples on their usage.

[steelaz]

Thanks for your help laszlof, I'll do that.