Changing a package billing type

From ISPWiki

Jump to: navigation, search

Changing a package billing type directly from BILLmanager may cause many problems. You can make changes manually in the pricelist table -> the billtype field of the BILLmanager database.
Do not change this field for all the table's records, as the package contents are kept in the same table, and this field acquires another values for them.

Possible values:
enum addBill { abUnknown, abNone, abOrdered, abStat, abPeriod, abDaily, abMonthly, abYearly, abCalendar};

Consider the following values:

abPeriod=4, abDaily=5, abMonthly=6, abYearly=7, abCalendar=8'.

If you are changing a billing type into daily, you need to make the SQL request for the package which billing type you are modifying:

update item set billdate=expiredate where price=PACKAGE_ID;

Restart BILLmanager upon completion.

Was this helpful? Yes | No
Personal tools