Код: Выделить всё
<?
$link = mysql_connect("localhost", "*********", "***********") or die("No connect");
mysql_select_db('UTM5', $link) or die ("No db");
$fd = fopen("login.csv", "r");
$nomer=1;
while (($arr = fgetcsv($fd, 1024, ";")) !== FALSE)
{
//добавление пользователя в базу
$sql="Select UNIX_TIMESTAMP(NOW())";
$datee=mysql_query($sql);
while( $row=mysql_fetch_array($datee))
{
$dat= $row[0];
};
$sql="INSERT INTO users (login,password,basic_account,advance_payment,create_date,last_change_date,who_create,
who_change,is_juridical,full_name,juridical_address,actual_address,work_telephone,home_telephone,
mobile_telephone,web_page,icq_number,tax_number,kpp_number,bank_id,bank_account,email,house_id,flat_number,
entrance,floor,district,building,passport,comments,personal_manager,connect_date,remote_switch_id,port_number,
binded_currency_code,is_send_invoice) VALUES ('$arr[0]','123456','0','0','$dat','$dat',
'0','0','0','','','','','','','','','','','0','','','0','','','','','','','','','$dat','0','0','0','0')";
$result = mysql_query($sql);
//добавляем аккаунт
$sql="INSERT INTO
accounts(balance,credit,flags,int_status,block_recalc_abon,block_recalc_prepaid) VALUES('0','0','3','1','0','0')";
$result = mysql_query($sql);
$sql="INSERT INTO users_accounts (uid,account_id) VALUES ('$nomer','$nomer')";
$result = mysql_query($sql);
$sql="UPDATE users SET basic_account='$nomer' WHERE id='$nomer'";
$result = mysql_query($sql);
$sql="INSERT INTO account_tariff_link(account_id,tariff_id,next_tariff_id,discount_period_id,link_date)
VALUES('$nomer','1','1','2','$dat')";
$result = mysql_query($sql);
//генерация айпи
$ip="192.168.0.".$nomer;
$sql="select inet_aton('$ip')";
$result=mysql_query($sql);
while ($row=mysql_fetch_array($result))
{
$ipcifr=$row[0];
};
$ip=$ipcifr-4294967296;
$sql="INSERT INTO ip_groups(ip_group_id,ip,mask,uname,upass,mac,allowed_cid,create_date,ip_type,router_id)
VALUES('$nomer','$ip','-1','$arr[0]','','','','$dat','0','0')";
$result=mysql_query($sql);
//$sql="UPDATE temp_ip SET is_deleted=1 WHERE ip='ip'";
//$result=mysql_query($sql);
$sql="INSERT INTO service_links(user_id,account_id,service_id,tariff_link_id) VALUES('$nomer', '$nomer', '3', '$nomer')";
$result=mysql_query($sql);
$sql="INSERT INTO periodic_service_links(id,discount_period_id,discounted_in_curr_period,start_date,is_planned,
expire_date,need_del,unprepay_period,unabon_period, is_invoice_set)
VALUES('$nomer', '2', '0', '$dat', '0', '2000000000', '0', '0', '0', '0')";
$result=mysql_query($sql);
$sql="INSERT INTO downloaded(downloaded_id,tclass_id) VALUES('$nomer', '0')";
$result=mysql_query($sql);
$sql="INSERT INTO iptraffic_service_links(id,ip_group_id,downloaded_id) VALUES('$nomer', '$nomer', '$nomer')";
$result=mysql_query($sql);
$sql="UPDATE accounts SET int_status='1' WHERE id='$nomer'";
$result=mysql_query($sql);
$nomer++;
echo ($nomer);
}
fclose($fd);
?>