Additional backup options

backup / restore has a lot to be desired ...

Milestone 2.3 deleted

See also: #1661

see also #3280

see also #2358

see also #1661

see also #2867

(In [8742]) re #1386; inital checking of majpr backup improvements. This probobly isnt done just yet, although simple testing seems rather posotive. Basicly, this seeks to move all the backup settings from amportal.conf in to the gui. DB structure is something along these lines, this MAY OR MAY NOT WORK for simple migration, so BU first!:

CREATE TABLE IF NOT EXISTS backup ( name varchar(50) default NULL, voicemail  varchar(50) 
default NULL, recordings varchar(50) default NULL, configurations  varchar(50) default 
NULL, cdr varchar(55) default NULL, fop varchar(50)  default NULL, minutes varchar(50) 
default NULL, hours varchar(50) default NULL,  days varchar(50) default NULL, months 
varchar(50) default NULL, weekdays  varchar(50) default NULL, command varchar(200) default 
NULL, method varchar(50)  default NULL, id int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY 
(ID) );
insert into backup select * from Backup;
alter table backup add ftpuser varchar(50), add ftppass varchar(50), add ftphost  
varchar(50), add ftpdir  varchar(150), add sshuser  varchar(50), add sshkey  varchar(150), 
add sshhost  varchar(50), add sshdir  varchar(150), add emailaddr  varchar(75), add 
emailmaxsize  varchar(25), add emailmaxtype varchar(5),add admin  varchar(10), add include 
blob, add exclude blob, add sudo varchar(25);
drop table Backup;

following if a partial changelog up untill this point:

• Add support for new db schema
• Rename functions to make them more freepbx complient
• Clean and disinfect code so that it doesnt look like it was the result of an accident

between nitroglycerine-powered penny-farthing bicycles, spring-loaded notebooks, bulletproof chainmails, flying machines, steam tanks, and giant mechanical spiders

• Sort backups alphabeticaly
• More code cleenup
• More readable save query
• More readable cron string + bug fixes
• rename gui element names
• Handel missing backup names gracefully
• parts of the gui to enter additional settings
• update backup script to reflect new db/variable structure
• naming changes
• dont insert blank values in to the db, so that the db sets them to null
• Make 'now' backups use the db as its source of info
• fix admin setting not being saved
• fix email max type typo's

TODO:

• proper migration, taking in to account that sqlite cant alter table
• add all current amportal var settings in to migrated (pre-exisitngs) backups

(In [8752]) closes #1386;

• removing schedule_functions - moving all functions to functions.inc.php
• fixes ftp backup temp file
• imrpove handeling of includes, widen textarea for include/exclude names
• better handeling of excludes
• add migration script
• update uninstall script to reflect new db schema
• version bump

(In [8753]) re #1386; remove old Backup table after migraton

(In [8758]) re #1386; fix inital migrate insert

(In [8773]) re #1386; further tweaks to install script, versiovbump