Newer
Older
backup-commander / html / bin / db-site-insert-all.php
<?php

include_once __DIR__.'/../inc/paths.php';

// $argv[0] => the name/path of this script
//$id = $argv[1];
//$isTest = $argv[2];

insertAllEmails();
//insertAllSites();
//insertAllDbs();


function insertAllDbs( ){
	global $g_database_path;
	$db = new SQLite3( __DIR__."/../$g_database_path" );
	$db_st = $db->prepare('insert into BULIST ( BUName, Dir_Src, Dir_Dest, BuType ) values( :bun, :bus, \'/mnt/H710-PERC-17TB/backup-pearcey-UI\', 1 )');

	insertSite_BU( $db_st, 'adult_xcc DB', 'adult_xcc' );
	insertSite_BU( $db_st, 'aipdata DB', 'aipdata' );
	insertSite_BU( $db_st, 'bklser DB', 'bklser' );
	insertSite_BU( $db_st, 'c4pdata DB', 'c4pdata' );
	insertSite_BU( $db_st, 'c4sidev DB', 'c4sidev' );
	insertSite_BU( $db_st, 'intinewsitelars024 DB', 'intinewsitelars024' );
	insertSite_BU( $db_st, 'lespovam DB', 'lespovam' );
	insertSite_BU( $db_st, 'lezpov DB', 'lezpov' );
	insertSite_BU( $db_st, 'mabd DB', 'mabd' );
	insertSite_BU( $db_st, 'mfadmin2_mfvideo DB', 'mfadmin2_mfvideo' );
	insertSite_BU( $db_st, 'mfcustom DB', 'mfcustom' );
	insertSite_BU( $db_st, 'mfdesam DB', 'mfdesam' );
	insertSite_BU( $db_st, 'mfdesires DB', 'mfdesires' );
	insertSite_BU( $db_st, 'mfdomiamember DB', 'mfdomiamember' );
	insertSite_BU( $db_st, 'mfdominan DB', 'mfdominan' );
	insertSite_BU( $db_st, 'mffeetamember DB', 'mffeetamember' );
	insertSite_BU( $db_st, 'mffeetdata DB', 'mffeetdata' );
	insertSite_BU( $db_st, 'mffightamem DB', 'mffightamem' );
	insertSite_BU( $db_st, 'mflarsmffight DB', 'mflarsmffight' );
	insertSite_BU( $db_st, 'mflesbianamember DB', 'mflesbianamember' );
	insertSite_BU( $db_st, 'mflesbiancom DB', 'mflesbiancom' );
	insertSite_BU( $db_st, 'modelbra DB', 'modelbra' );
	insertSite_BU( $db_st, 'roundcube DB', 'roundcube' );
	insertSite_BU( $db_st, 'travelclub DB', 'travelclub' );
	
	if( $db->lastErrorCode()!==0){
		return $db->lastErrorCode();
	}
}


function insertAllEmails( ){
	
	global $g_database_path;
	$db = new SQLite3( __DIR__."/../$g_database_path" );
	$db_st = $db->prepare('insert into BULIST ( BUName, Dir_Src, Dir_Dest, BuType ) values( :bun, :bus, \'/mnt/H710-PERC-17TB/backup-pearcey-UI\', 0 )');

	insertSite_BU( $db_st, 'cash4partners.com email', '/var/www/adult/data/email/cash4partners.com' );
	insertSite_BU( $db_st, 'xcamclips.com email', '/var/www/adult/data/email/xcamclips.com' );	
	insertSite_BU( $db_st, 'xcamclips.com email', '/var/www/adult/data/email/respectliberty.com' );	
	insertSite_BU( $db_st, 'allinpoker.io email', '/var/www/aip-admin/data/email/allinpoker.io' );		
	insertSite_BU( $db_st, 'mfvideoxxx.com email', '/var/www/mfadmin2018/data/email/mfvideoxxx.com' );	
	insertSite_BU( $db_st, 'myadultbiz.com email', '/var/www/mab-admin/data/email/myadultbiz.com' );	
	insertSite_BU( $db_st, 'lesbianpov.live email', '/var/www/lesbianpov_live/data/email/lesbianpov.live' );	
	insertSite_BU( $db_st, 'mfdesires_com email', '/var/www/mfdesires_com/data/email/mfdesires.com' );
	insertSite_BU( $db_st, 'mfdominance_com email', '/var/www/mfdominance_com/data/email/mfdominance.com' );	
	insertSite_BU( $db_st, 'mffeet_com email', '/var/www/mffeet_com/data/email/mffeet.com' );	
	insertSite_BU( $db_st, 'mffight_com email', '/var/www/mffight_com/data/email/mffight.com' );	
	insertSite_BU( $db_st, 'mflesbian_com email', '/var/www/mflesbian_com/data/email/mflesbian.com' );
	
	
	if( $db->lastErrorCode()!==0){
		return $db->lastErrorCode();
	}
}

function insertAllSites( ){
	
	global $g_database_path;
	$db = new SQLite3( __DIR__."/../$g_database_path" );
	$db_st = $db->prepare('insert into BULIST ( BUName, Dir_Src, Dir_Dest, BuType ) values( :bun, :bus, \'/mnt/H710-PERC-17TB/backup-pearcey-UI\', 0 )');
	
	insertSite_BU( $db_st, 'allinpoker.io files', '/var/www/aip-admin/data/www/allinpoker.io' );
	insertSite_BU( $db_st, 'bklservice.dk files', '/var/www/non-adult/data/www/bklservice.dk' );	
	insertSite_BU( $db_st, 'cash4partners.com files', '/var/www/adult/data/www/cash4partners.com' );
	insertSite_BU( $db_st, 'xcamclips.com files', '/var/www/adult/data/www/xcamclips.com' );	
	insertSite_BU( $db_st, 'intimacytours.com files', '/var/www/intim-adm/data/www/intimacytours.com' );	
	insertSite_BU( $db_st, 'mfcustomvideo.com files', '/var/www/custom-adm/data/www/mfcustomvideo.com' );
	insertSite_BU( $db_st, 'mftravel.club files', '/var/www/travel-adm/data/www/mftravel.club' );
	insertSite_BU( $db_st, 'mfvideoxxx.com files', '/var/www/mfadmin2018/data/www/mfvideoxxx.com' );
	insertSite_BU( $db_st, 'modeloadultobrasil.com.br files', '/var/www/model-adm/data/www/modeloadultobrasil.com.br' );
	insertSite_BU( $db_st, 'myadultbiz.com files', '/var/www/mab-admin/data/www/myadultbiz.com' );
	insertSite_BU( $db_st, 'lesbiancasting.com files', '/var/www/travel-adm/data/www/lesbiancasting.com' );	// <-- ? Not listed
	
	insertSite_BU( $db_st, 'lesbianpov.live files', '/var/www/lesbianpov_live/data/www/lesbianpov.live' );
	insertSite_BU( $db_st, 'mfdesires_com files', '/var/www/mfdesires_com/data/www/mfdesires.com' );
	insertSite_BU( $db_st, 'mfdominance_com files', '/var/www/mfdominance_com/data/www/mfdominance.com' );
	insertSite_BU( $db_st, 'mffeet_com files', '/var/www/mffeet_com/data/www/mffeet.com' );
	insertSite_BU( $db_st, 'mffight_com files', '/var/www/mffight_com/data/www/mffight.com' );
	insertSite_BU( $db_st, 'mflesbian_com files', '/var/www/mflesbian_com/data/www/mflesbian.com' );
	
	
	if( $db->lastErrorCode()!==0){
		return $db->lastErrorCode();
	}
}

function insertSite_BU( &$p, $bu_name, $src ){
	$p->bindValue(':bun', $bu_name );
	$p->bindValue(':bus', $src );
	$p->execute();
}

?>