Changing a package billing type
From ISPWiki
(Redirected from How to change a package billing type)
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 };
Consider the following values:
abPeriod=4, abDaily=5, abMonthly=6, abYearly=7.
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;
