Database modifications

[killerasp]

I am working on an app and i wanted to use WHMCS to handle the ticketing and billing system.

 

i havent used the actual product yet but from what i gather from the API functions, the basic field in the client table include:

 

clientid

firstname

lastname

companyname

email

address1

address2

city

state

postcode

country

phonenumber

password2

currency

 

Is this accurate as to the columns in the client table? What if i wanted to add a new column to the client table? Would that be possible without breaking WHMCS?

[m00]

I am working on an app and i wanted to use WHMCS to handle the ticketing and billing system.

 

i havent used the actual product yet but from what i gather from the API functions, the basic field in the client table include:

 

clientid

firstname

lastname

companyname

email

address1

address2

city

state

postcode

country

phonenumber

password2

currency

 

Is this accurate as to the columns in the client table? What if i wanted to add a new column to the client table? Would that be possible without breaking WHMCS?

 

I attached a dump from the tblclients table. As you can see the fields that you name up are correct.

 

I don't recommend you to create new fields to the current table. I advise to create an extra table and store the userid so you can link information from both tables, without damaging your WHMCS environment.

dump.txt

[killerasp]

this helps alot! thanks for the mysql dump. You are correct, i can just create a corresponding table with the information i need to add and link it to the client table.

[freedombi]

You could also just add a custom client field from within WHMCS.

[rmccny]

From a developers perspective custom fields in WHMCS are very clunky to work with, so I tend not to use them on any of my add-ons. Yes, they have their place and work well for what their intended to do.

 

I would also avoid making any changes to any of the WHMCS. Such changes could cause problems with upgrading WHMCS down the road. MySQL is a relational database; use that to your advantage, create an indexed field for clientid, accountid., or whatever unique WHMCS field you need to establish the relation to your own database tables.