diff --git a/html/bin/db-site-insert-all.php b/html/bin/db-site-insert-all.php new file mode 100644 index 0000000..e3604f2 --- /dev/null +++ b/html/bin/db-site-insert-all.php @@ -0,0 +1,87 @@ + the name/path of this script +//$id = $argv[1]; +//$isTest = $argv[2]; + +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/db_name\', 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 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/site_name\', 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(); +} + +?>