Удаленные пользователи
-
Krill A. Fomin
- Сообщения: 41
- Зарегистрирован: Пт авг 26, 2005 14:51
Удаленные пользователи
Кто нибудь пытался востановить сабж?
Код: Выделить всё
#!/usr/bin/php -f
<?
$do_actual_job = false;
$mysql_user = "";
$mysql_pass = "";
$mysql_host = "localhost";
$mysql_db = "UTM";
$restore_rid = 1;
$link = mysql_connect($mysql_host, $mysql_user, $mysql_pass) or die (mysql_error());
$db = mysql_select_db($mysql_db) or die (mysql_error());
$query = "SET NAMES cp1251";
$result = mysql_query($query) or die (mysql_error());
$query = "SELECT login, password, full_name, ip, bill, bill_abs, credit, block, comments, reg_date, priv_level, sys_message, ip_type, email, ab_pstart, ab_pend, ab_ldiscount, lang, tariff, tariff_next, auth_req, discount_eq, is_juridical, juridical_address, actual_address, tax_number, current_bank_account, bank_name, bank_account, bank_bic, start_page, mac, fw_on, contract, id FROM users_history WHERE rid = ".$restore_rid;
$result = mysql_query($query) or die (mysql_error());
while($row = mysql_fetch_array($result))
{
$query = "INSERT INTO users(login, password, full_name, ip, bill, bill_abs, credit, block, comments, reg_date, priv_level, sys_message, ip_type, email, ab_pstart, ab_pend, ab_ldiscount, lang, tariff, tariff_next, auth_req, discount_eq, is_juridical, juridical_address, actual_address, tax_number, current_bank_account, bank_name, bank_account, bank_bic, start_page, mac, fw_on, contract, id) VALUES ('".$row['login']."', '".$row['password']."', '".$row['full_name']."', '".$row['ip']."', '".$row['bill']."', '".$row['bill_abs']."', '".$row['credit']."', '".$row['block']."', '".$row['comments']."', '".$row['reg_date']."', '".$row['priv_level']."', '".$row['sys_message']."', '".$row['ip_type']."', '".$row['email']."', '".$row['ab_pstart']."', '".$row['ab_pend']."', '".$row['ab_ldiscount']."', '".$row['lang']."', '".$row['tariff']."', '".$row['tariff_next']."', '".$row['auth_req']."', '".$row['discount_eq']."', '".$row['is_juridical']."', '".$row['juridical_address']."', '".$row['actual_address']."', '".$row['tax_number']."', '".$row['current_bank_account']."', '".$row['bank_name']."', '".$row['bank_account']."', '".$row['bank_bic']."', '".$row['start_page']."', '".$row['mac']."', '".$row['fw_on']."', '".$row['contract']."', '".$row['id']."')";
if($do_actual_job == false)
{
echo $query;
}
else
{
mysql_query($query) or die (mysql_error());
echo "1-st QUERY OK!\n";
mysql_query("UPDATE users_history SET is_deleted = '0' WHERE rid = ".$restore_rid) or die (mysql_error());
echo "2-nd QUERY OK!\n";
}
}
?>
NetUP UTM 4.0 [1 +update 17 may 2004], NetUP RADIUS SERVER [], RH Linux 9.0
-
Krill A. Fomin
- Сообщения: 41
- Зарегистрирован: Пт авг 26, 2005 14:51
Или в мускуле совсем не ферштейн?-
Krill A. Fomin
- Сообщения: 41
- Зарегистрирован: Пт авг 26, 2005 14:51
