UPDATE `hb_configuration` SET `value` = '4.0.8' WHERE `setting`= 'Version';
##########
REPLACE INTO `hb_language_locales` (`language_id`,`section`,`keyword`,`value`)
SELECT id, 'global', 'statisticssince','Statistics since' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'diskspace','Disk Space' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'sure_to_power_on','Are you sure you want to Power ON this VM' FROM hb_language WHERE target='user'
UNION SELECT id, 'global', 'for','for' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'convert2template','Convert to template' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'backupconversion_desc','Backup 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', 'addschedule','Add new schedule' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'backupevery','Backup every' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'nextinvoice','Next invoice' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'hourlybilledupdateddaily','hourly billed, updated daily' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'cpuspeed','CPU Speed' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'cpus','CPUs' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'startport','Start Port' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'endport','End Port' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'code','Code' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'ingress','Ingress' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'engress','Engress' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'icmptype','ICMP type' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'icmpcode','ICMP code' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'publicport','Public port' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'privateport','Private port' FROM hb_language WHERE target='user'
UNION SELECT id, 'global', 'unlimited','Unlimited' FROM hb_language WHERE target='user'
UNION SELECT id, 'global', 'publicip','Public IP' FROM hb_language WHERE target='user'
UNION SELECT id, 'global', 'sourcenat','Source NAT' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'staticnat','Static NAT' FROM hb_language WHERE target='user'
UNION SELECT id, 'global', 'disable','Disable' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'portfowarding','Port fowarding' FROM hb_language WHERE target='user'
UNION SELECT id, 'global', 'enable','Enable' FROM hb_language WHERE target='user'
UNION SELECT id, 'global', 'invoicegenerated','Invoice generated' FROM hb_language WHERE target='user'
UNION SELECT id, 'global', 'avg','Avg' FROM hb_language WHERE target='user'
UNION SELECT id, 'global', 'distribution','Distribution' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'rebuild','Rebuild' FROM hb_language WHERE target='user'
UNION SELECT id, 'global', 'view','view' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'zones','Zones' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'extendedinfo','Extended Info' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'certificate','Certificate' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'organizationdetails','Organization Details' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'edityourorganizationdetails','Edit your Organization details' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'contactdetails','Contact Details' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'edityourcontactsdetails','Edit your Contacts details' FROM hb_language WHERE target='user'
UNION SELECT id, 'affiliates', 'newcustommers','New customers' FROM hb_language WHERE target='user'
UNION SELECT id, 'affiliates', 'allcustommers','All customers' FROM hb_language WHERE target='user'
UNION SELECT id, 'affiliates', 'existingcustommers','Existing customers' FROM hb_language WHERE target='user'
UNION SELECT id, 'affiliates', 'audience','Audience' FROM hb_language WHERE target='user';