Newer
Older
backup-commander / html / bin / db-site-insert-all.php
  1. <?php
  2.  
  3. include_once __DIR__.'/../inc/paths.php';
  4. include_once __DIR__.'/../inc/bu-common.php';
  5.  
  6. // $argv[0] => the name/path of this script
  7. //$id = $argv[1];
  8. //$isTest = $argv[2];
  9.  
  10. insertAllEmails();
  11. //insertAllSites();
  12. //insertAllDbs();
  13.  
  14.  
  15. function insertAllDbs( ){
  16. global $g_database_path;
  17. $db = new SQLite3( __DIR__."/../$g_database_path" );
  18. $db_st = $db->prepare('insert into BULIST ( BUName, Dir_Src, Dir_Dest, BuType ) values( :bun, :bus, \'/mnt/H710-PERC-17TB/backup-pearcey-UI\', 1 )');
  19.  
  20. insertSite_BU( $db_st, 'adult_xcc DB', 'adult_xcc' );
  21. insertSite_BU( $db_st, 'aipdata DB', 'aipdata' );
  22. insertSite_BU( $db_st, 'bklser DB', 'bklser' );
  23. insertSite_BU( $db_st, 'c4pdata DB', 'c4pdata' );
  24. insertSite_BU( $db_st, 'c4sidev DB', 'c4sidev' );
  25. insertSite_BU( $db_st, 'intinewsitelars024 DB', 'intinewsitelars024' );
  26. insertSite_BU( $db_st, 'lespovam DB', 'lespovam' );
  27. insertSite_BU( $db_st, 'lezpov DB', 'lezpov' );
  28. insertSite_BU( $db_st, 'mabd DB', 'mabd' );
  29. insertSite_BU( $db_st, 'mfadmin2_mfvideo DB', 'mfadmin2_mfvideo' );
  30. insertSite_BU( $db_st, 'mfcustom DB', 'mfcustom' );
  31. insertSite_BU( $db_st, 'mfdesam DB', 'mfdesam' );
  32. insertSite_BU( $db_st, 'mfdesires DB', 'mfdesires' );
  33. insertSite_BU( $db_st, 'mfdomiamember DB', 'mfdomiamember' );
  34. insertSite_BU( $db_st, 'mfdominan DB', 'mfdominan' );
  35. insertSite_BU( $db_st, 'mffeetamember DB', 'mffeetamember' );
  36. insertSite_BU( $db_st, 'mffeetdata DB', 'mffeetdata' );
  37. insertSite_BU( $db_st, 'mffightamem DB', 'mffightamem' );
  38. insertSite_BU( $db_st, 'mflarsmffight DB', 'mflarsmffight' );
  39. insertSite_BU( $db_st, 'mflesbianamember DB', 'mflesbianamember' );
  40. insertSite_BU( $db_st, 'mflesbiancom DB', 'mflesbiancom' );
  41. insertSite_BU( $db_st, 'modelbra DB', 'modelbra' );
  42. insertSite_BU( $db_st, 'roundcube DB', 'roundcube' );
  43. insertSite_BU( $db_st, 'travelclub DB', 'travelclub' );
  44. if( $db->lastErrorCode()!==0){
  45. return $db->lastErrorCode();
  46. }
  47. }
  48.  
  49.  
  50. function insertAllEmails( ){
  51. global $g_database_path;
  52. $db = new SQLite3( __DIR__."/../$g_database_path" );
  53. $db_st = $db->prepare('insert into BULIST ( BUName, Dir_Src, Dir_Dest, BuType ) values( :bun, :bus, \'/mnt/H710-PERC-17TB/backup-pearcey-UI\', 0 )');
  54.  
  55. insertSite_BU( $db_st, 'cash4partners.com email', '/var/www/adult/data/email/cash4partners.com' );
  56. insertSite_BU( $db_st, 'xcamclips.com email', '/var/www/adult/data/email/xcamclips.com' );
  57. insertSite_BU( $db_st, 'xcamclips.com email', '/var/www/adult/data/email/respectliberty.com' );
  58. insertSite_BU( $db_st, 'allinpoker.io email', '/var/www/aip-admin/data/email/allinpoker.io' );
  59. insertSite_BU( $db_st, 'mfvideoxxx.com email', '/var/www/mfadmin2018/data/email/mfvideoxxx.com' );
  60. insertSite_BU( $db_st, 'myadultbiz.com email', '/var/www/mab-admin/data/email/myadultbiz.com' );
  61. insertSite_BU( $db_st, 'lesbianpov.live email', '/var/www/lesbianpov_live/data/email/lesbianpov.live' );
  62. insertSite_BU( $db_st, 'mfdesires_com email', '/var/www/mfdesires_com/data/email/mfdesires.com' );
  63. insertSite_BU( $db_st, 'mfdominance_com email', '/var/www/mfdominance_com/data/email/mfdominance.com' );
  64. insertSite_BU( $db_st, 'mffeet_com email', '/var/www/mffeet_com/data/email/mffeet.com' );
  65. insertSite_BU( $db_st, 'mffight_com email', '/var/www/mffight_com/data/email/mffight.com' );
  66. insertSite_BU( $db_st, 'mflesbian_com email', '/var/www/mflesbian_com/data/email/mflesbian.com' );
  67. if( $db->lastErrorCode()!==0){
  68. return $db->lastErrorCode();
  69. }
  70. }
  71.  
  72. function insertAllSites( ){
  73. global $g_database_path;
  74. $db = new SQLite3( __DIR__."/../$g_database_path" );
  75. $db_st = $db->prepare('insert into BULIST ( BUName, Dir_Src, Dir_Dest, BuType ) values( :bun, :bus, \'/mnt/H710-PERC-17TB/backup-pearcey-UI\', 0 )');
  76. insertSite_BU( $db_st, 'allinpoker.io files', '/var/www/aip-admin/data/www/allinpoker.io' );
  77. insertSite_BU( $db_st, 'bklservice.dk files', '/var/www/non-adult/data/www/bklservice.dk' );
  78. insertSite_BU( $db_st, 'cash4partners.com files', '/var/www/adult/data/www/cash4partners.com' );
  79. insertSite_BU( $db_st, 'xcamclips.com files', '/var/www/adult/data/www/xcamclips.com' );
  80. insertSite_BU( $db_st, 'intimacytours.com files', '/var/www/intim-adm/data/www/intimacytours.com' );
  81. insertSite_BU( $db_st, 'mfcustomvideo.com files', '/var/www/custom-adm/data/www/mfcustomvideo.com' );
  82. insertSite_BU( $db_st, 'mftravel.club files', '/var/www/travel-adm/data/www/mftravel.club' );
  83. insertSite_BU( $db_st, 'mfvideoxxx.com files', '/var/www/mfadmin2018/data/www/mfvideoxxx.com' );
  84. insertSite_BU( $db_st, 'modeloadultobrasil.com.br files', '/var/www/model-adm/data/www/modeloadultobrasil.com.br' );
  85. insertSite_BU( $db_st, 'myadultbiz.com files', '/var/www/mab-admin/data/www/myadultbiz.com' );
  86. insertSite_BU( $db_st, 'lesbiancasting.com files', '/var/www/travel-adm/data/www/lesbiancasting.com' ); // <-- ? Not listed
  87. insertSite_BU( $db_st, 'lesbianpov.live files', '/var/www/lesbianpov_live/data/www/lesbianpov.live' );
  88. insertSite_BU( $db_st, 'mfdesires_com files', '/var/www/mfdesires_com/data/www/mfdesires.com' );
  89. insertSite_BU( $db_st, 'mfdominance_com files', '/var/www/mfdominance_com/data/www/mfdominance.com' );
  90. insertSite_BU( $db_st, 'mffeet_com files', '/var/www/mffeet_com/data/www/mffeet.com' );
  91. insertSite_BU( $db_st, 'mffight_com files', '/var/www/mffight_com/data/www/mffight.com' );
  92. insertSite_BU( $db_st, 'mflesbian_com files', '/var/www/mflesbian_com/data/www/mflesbian.com' );
  93. if( $db->lastErrorCode()!==0){
  94. return $db->lastErrorCode();
  95. }
  96. }
  97.  
  98. function insertSite_BU( &$p, $bu_name, $src ){
  99. $p->bindValue(':bun', $bu_name );
  100. $p->bindValue(':bus', $src );
  101. $p->execute();
  102. }
  103.  
  104. ?>