UPDATE `hb_configuration` SET `value` = '4.5.8' WHERE `setting`= 'Version'; ########## ALTER TABLE `hb_invoices` ADD `rate2` DECIMAL( 10, 4 ) NOT NULL DEFAULT '0.0000' AFTER `rate`; ########## REPLACE INTO `hb_configuration` (`setting`, `value`) VALUES ('StorePDFInvoice', 'off'), ('AttachPDFCopy', 'off'), ('StorePDFPath', ''); ########## CREATE TABLE IF NOT EXISTS `hb_currency_cache` ( `id` int(11) NOT NULL AUTO_INCREMENT, `currency_id` int(11) NOT NULL, `rate` DECIMAL( 10, 4 ) NOT NULL DEFAULT '0.0000', `comment` varchar(127) NOT NULL, `date` date NOT NULL, PRIMARY KEY (`id`,`currency_id`,`date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ########## REPLACE INTO `hb_templates` (`id`, `parent_id`, `name`, `target`, `created`, `updated`) VALUES (100, 0, 'EU Invoicing', 'invoice', '2013-05-16 03:30:01', '2013-05-16 03:30:01'); ########## REPLACE INTO `hb_template_content` (`id`, `template_id`, `name`, `content`, `checksum`, `updated`) VALUES (100, 100, 'EU Invoicing', '\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
{$invoice.number}
{$lang.original}
{$lang.invoice_date}: {$invoice.date}
 
{$lang.invoice_from} {$lang.invoice_to}
{if $client.companyname}{$client.companyname}, {/if}{$client.firstname} {$client.lastname}
{$client.address1} {if $client.address2}, {$client.address2}{/if}{if $client.postcode}, {$client.postcode}{/if} {$client.city} {if $client.country}, {$client.country}{/if}{if $client.vateu}
{$lang.vateu}: {$client.vateu}{/if}
 
{$lang.paymethod}: {$invoice.paymentgw}
{$lang.dateofsale}: {$invoice.date}
\r\n{foreach from=$transactions item=trans}{$lang.trans_id} {$trans.trans_id}{break}{/foreach}{if $invoice.notes}{/if}\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
{$lang.invoice_desc}{$lang.qty}{$lang.unitcost}{$lang.netprice}{$lang.tax}{$lang.taxamount}{$lang.grossprice}
{$item.description}{$item.qty}{$item.amount}{$item.linetotal}{if !$item.tax_rate}{$lang.nottaxed}{else}{$item.tax_rate}%{/if}{$item.tax_amount}{$item.linetaxed}
{$lang.invoicedue}: {$invoice.total}{$lang.total}{$invoice.subtotal} {$invoice.tax}{$invoice.total}
 
 {if $smarty.foreach.taxloop.first}{$lang.including}{/if}{$taxitm.subtotal}{if !$taxitm.name}{$lang.nottaxed}{else}{$taxitm.name}%{/if}{$taxitm.tax}{$taxitm.total}
{$lang.Paid}: {$totalpaid}
{$lang.leftunpaid}: {$transbalance}		 
 {$lang.notes}
{$invoice.notes}
\r\n\r\n\r\n\r\n\r\n\r\n\r\n
{$lang.pdfagreement}
\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Invoice footer text
\r\n
', 'b3d83359bb9fd7290243d07b6a9a8176', '2013-05-16 13:04:47'); ########## REPLACE INTO `hb_language_locales` (`language_id`,`section`,`keyword`,`value`) SELECT id, 'configuration', 'StorePDFInvoice','Store PDF invoice' FROM hb_language WHERE target='admin' UNION SELECT id, 'global', 'dateofsale','Date of sale' FROM hb_language UNION SELECT id, 'global', 'vateu','VAT' FROM hb_language UNION SELECT id, 'global', 'pdfagreement','Sent in PDF form, as agreed in Terms and Conditions' FROM hb_language UNION SELECT id, 'global', 'taxamount','Tax Amount' FROM hb_language UNION SELECT id, 'global', 'grossprice','Total gross price' FROM hb_language UNION SELECT id, 'global', 'netprice','Total net price' FROM hb_language UNION SELECT id, 'global', 'original','Original' FROM hb_language UNION SELECT id, 'global', 'copy','Copy' FROM hb_language UNION SELECT id, 'global', 'invoicedue','Total due' FROM hb_language UNION SELECT id, 'global', 'nottaxed','-' FROM hb_language UNION SELECT id, 'global', 'leftunpaid','Left to pay' FROM hb_language UNION SELECT id, 'global', 'including','Including' FROM hb_language UNION SELECT id, 'configuration', 'StorePDFInvoice_descr','store final PDF invoice under: ' FROM hb_language WHERE target='admin' UNION SELECT id, 'configuration', 'AttachPDFCopy_descr1','only original should go into PDF' FROM hb_language WHERE target='admin' UNION SELECT id, 'configuration', 'AttachPDFCopy_descr','add copy as second invoice page' FROM hb_language WHERE target='admin' UNION SELECT id, 'configuration', 'AttachPDFCopy','Original and copy in one pdf' FROM hb_language WHERE target='admin' UNION SELECT id, 'configuration', 'StorePDFInvoice_descr1','dont store, generate pdf each time its requested' FROM hb_language WHERE target='admin' UNION SELECT id, 'configuration', 'StorePDFInvoice_descr2','Provide full path to folder where HostBill should store your PDF invoices, it should have same chmod/owner as templates_c folder' FROM hb_language WHERE target='admin' UNION SELECT id, 'clientarea', 'haenabled','HA-Enabled' FROM hb_language WHERE target='user' UNION SELECT id, 'clientarea', 'newrootpasword','Click here to generate root pasword' FROM hb_language WHERE target='user' UNION SELECT id, 'clientarea', 'snapshots','Snapshots' FROM hb_language WHERE target='user' UNION SELECT id, 'clientarea', 'snapshotconversion_description','Snapshot conversion lets you create a Template from an existing Virtual Machine configuration, which you can then use to redeploy new Virtual Machines. To convert your Backup, enter a Label name for your new template and click the Convert Backup button.' FROM hb_language WHERE target='user' UNION SELECT id, 'clientarea', 'alocateaddresserror','Can\'t alocate IP address' FROM hb_language WHERE target='user' UNION SELECT id, 'clientarea', 'noavailablenetworks','No available networks' FROM hb_language WHERE target='user' UNION SELECT id, 'clientarea', 'nobuckups','Backups not available for this VPS' FROM hb_language WHERE target='user' UNION SELECT id, 'clientarea', 'resourcelimitreached','Resource limit reached' FROM hb_language WHERE target='user' UNION SELECT id, 'clientarea', 'firewallrulecheduledrem','Selected firewall rule has been scheduled for removal' FROM hb_language WHERE target='user' UNION SELECT id, 'clientarea', 'rulebeenscheduledcreation','Rule has been scheduled for creation' FROM hb_language WHERE target='user' UNION SELECT id, 'clientarea', 'rulescheduledremoval','Selected rule has been scheduled for removal' FROM hb_language WHERE target='user' UNION SELECT id, 'clientarea', 'associateaddresserror','Could not associate ip address' FROM hb_language WHERE target='user' UNION SELECT id, 'clientarea', 'obitainassociatederror','Could not obitain associated ip address' FROM hb_language WHERE target='user' UNION SELECT id, 'clientarea', 'removeaddresserror','Could not remove ip address' FROM hb_language WHERE target='user' UNION SELECT id, 'clientarea', 'disablestaticnaterror','Could not disable Static NAT' FROM hb_language WHERE target='user' UNION SELECT id, 'clientarea', 'pickfirst','Pick VM first' FROM hb_language WHERE target='user' UNION SELECT id, 'clientarea', 'networkinterfacebeenupdated','Selected network interface has been updated' FROM hb_language WHERE target='user' UNION SELECT id, 'clientarea', 'networkinterfacewillremoved','Selected network interface will be removed shortly' FROM hb_language WHERE target='user' UNION SELECT id, 'clientarea', 'vmbeenscheduledreboot','VM has been scheduled for reboot.' FROM hb_language WHERE target='user' UNION SELECT id, 'clientarea', 'backupbeenscheduledremoval','Backup has been scheduled for removal' FROM hb_language WHERE target='user' UNION SELECT id, 'clientarea', 'templatecreationbeenscheduled','Template creation has been scheduled' FROM hb_language WHERE target='user' UNION SELECT id, 'clientarea', 'vmbeenscheduledstartup','VM has been scheduled for startup.' FROM hb_language WHERE target='user' UNION SELECT id, 'clientarea', 'templatescheduledremoval','Template is scheduled for removal' FROM hb_language WHERE target='user' UNION SELECT id, 'clientarea', 'diskbeenscheduledbackup','Disk has been scheduled for backup' FROM hb_language WHERE target='user' UNION SELECT id, 'clientarea', 'vmbeeensheduledstop','Virtual machine will be stopped shortly' FROM hb_language WHERE target='user' UNION SELECT id, 'clientarea', 'vmbeenscheduleddestruction','VM has been scheduled for destruction.' FROM hb_language WHERE target='user' UNION SELECT id, 'clientarea', 'vmrebuildbeenscheduled','VM Rebuild has been scheduled' FROM hb_language WHERE target='user' UNION SELECT id, 'clientarea', 'creatingrootpassword','Creating root password' FROM hb_language WHERE target='user'; ########## CREATE TABLE `hb_notes` ( `id` INT(10) NOT NULL AUTO_INCREMENT, `type` ENUM('client','account','domain','order') NOT NULL, `rel_id` INT(10) NOT NULL, `admin_id` INT(10) NOT NULL, `date` DATETIME NOT NULL, `note` TEXT NOT NULL, PRIMARY KEY (`id`), INDEX `type` (`type`), INDEX `rel_id` (`rel_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ########## INSERT INTO `hb_notes` (`type`, `rel_id`, `admin_id`, `note`) SELECT 'account', a.id, 1, a.notes FROM hb_accounts a WHERE a.notes!='' UNION SELECT 'domain', d.id, 1, d.notes FROM hb_domains d WHERE d.notes!='' UNION SELECT 'client', c.id, 1, c.notes FROM hb_client_details c WHERE c.notes!='' UNION SELECT 'order', o.id, 1, o.notes FROM hb_orders o WHERE o.notes!=''; ########## INSERT INTO `hb_email_templates` (`id`, `tplname`, `group`, `for`, `language_id`, `subject`, `message`, `send`, `plain`, `system`, `hidden`) VALUES (NULL, 'Notes:Change', 'General', 'Admin', 1, 'Notes for {$type}: #{$id} updated', 'Note has just been updated for {$type} #{$id}\r\n\r\n{if $notes}\r\n{foreach from=$notes item=entry}\r\n----------------------------------------------------------------\r\n{$entry.date|dateformat:$date_format}\r\n{$entry.note}\r\n{/foreach}\r\n----------------------------------------------------------------\r\n{/if}\r\n\r\n{if $note}\r\n{if $note.action==\'add\'}New note:{else}Updated note:{/if}\r\n----------------------------------------------------------------\r\n{$note.date|dateformat:$date_format}\r\n{$note.note}\r\n{/if}\r\nURL: {$url}', 1, 1, 1, 0);