127 lines
5.0 KiB
PHP
127 lines
5.0 KiB
PHP
<?php
|
|
require_once ("admin-header.php");
|
|
if (!(isset($_SESSION[$OJ_NAME . '_' . 'administrator']) || isset($_SESSION[$OJ_NAME . '_problem_importer']))) {
|
|
echo "<a href='../loginpage.php'>Please Login First!</a>";
|
|
exit(1);
|
|
}
|
|
if (isset($OJ_LANG)) {
|
|
require_once ("../lang/$OJ_LANG.php");
|
|
}
|
|
require_once ("../include/const.inc.php");
|
|
require_once ("../include/my_func.inc.php");
|
|
?>
|
|
|
|
<?php
|
|
function get_extension($file) {
|
|
$info = pathinfo($file);
|
|
return $info['extension'];
|
|
}
|
|
function import_user($filename) {
|
|
$check=false;
|
|
if (($h = fopen("{$filename}", "r")) !== FALSE) {
|
|
// 文件中的每一行数据都被转换为我们调用的单个数组$data
|
|
// 数组的每个元素以逗号分隔
|
|
while (($data = fgetcsv($h, 1000, ",")) !== FALSE) {
|
|
// 每个单独的数组都被存入到嵌套的数组中
|
|
if ($data[0] == "学号") {
|
|
$check=true;
|
|
echo "导入名单：<hr>\n";
|
|
$gb2312=false;
|
|
continue;
|
|
}else if (iconv("gb2312","utf-8",$data[0])=="学号") {
|
|
$check=true;
|
|
$gb2312=true;
|
|
continue;
|
|
}
|
|
if($check){
|
|
echo $data[0] . "<br>\n";
|
|
$user_id = mb_trim($data[0]);
|
|
$nick = $data[1];
|
|
$password = pwGen(trim($data[2]));
|
|
$school = "";
|
|
$email = "";
|
|
$group_name="";
|
|
if (isset($data[3])) $school = $data[3];
|
|
if (isset($data[4])) $email = $data[4];
|
|
if (isset($data[5])) $group_name = $data[5];
|
|
if($gb2312) {
|
|
$nick=iconv("gb2312","utf-8",$nick);
|
|
$school=iconv("gb2312","utf-8",$school);
|
|
$group_name=iconv("gb2312","utf-8",$group_name);
|
|
}
|
|
if (mb_strlen($nick, 'utf-8') > 20) {
|
|
$new_len = mb_strlen($nick, 'utf-8');
|
|
if ($new_len > $max_length) {
|
|
$max_length = $new_len;
|
|
$longer = "ALTER TABLE `users` MODIFY COLUMN `nick` varchar($max_length) NULL DEFAULT '' ";
|
|
pdo_query($longer);
|
|
}
|
|
}
|
|
|
|
$ip = "127.0.0.1";
|
|
$sql = "INSERT INTO `users`(" . "`user_id`,`email`,`ip`,`accesstime`,`password`,`reg_time`,`nick`,`school`,`group_name`)" . "VALUES(?,?,?,NOW(),?,NOW(),?,?,?)on DUPLICATE KEY UPDATE `email`=?,`ip`=?,`accesstime`=NOW(),`password`=?,`reg_time`=now(),nick=?,`school`=?,`group_name`=?";
|
|
pdo_query($sql, $user_id, $email, $ip, $password, $nick, $school,$group_name, $email, $ip, $password, $nick, $school,$group_name);
|
|
|
|
}else{
|
|
echo "<h1>请用下载的模板填写，保存为UTF-8编码。</h1>";
|
|
break;
|
|
}
|
|
}
|
|
// 关闭文件
|
|
fclose($h);
|
|
}
|
|
}
|
|
|
|
if (isset($_FILES["fps"])) {
|
|
if ($_FILES["fps"]["error"] > 0) {
|
|
echo " - Error: " . $_FILES["fps"]["error"] . "File size is too big, change in PHP.ini<br />";
|
|
} else {
|
|
$tempfile = $_FILES["fps"]["tmp_name"];
|
|
if (get_extension($_FILES["fps"]["name"]) == "zip") {
|
|
echo " - zip file, only fps/xml files in root dir are supported";
|
|
$resource = zip_open($tempfile);
|
|
$i = 1;
|
|
$tempfile = tempnam("/tmp", "fps");
|
|
while ($dir_resource = zip_read($resource)) {
|
|
if (zip_entry_open($resource, $dir_resource)) {
|
|
$file_name = $path . zip_entry_name($dir_resource);
|
|
$file_path = substr($file_name, 0, strrpos($file_name, "/"));
|
|
if (!is_dir($file_name)) {
|
|
$file_size = zip_entry_filesize($dir_resource);
|
|
$file_content = zip_entry_read($dir_resource, $file_size);
|
|
file_put_contents($tempfile, $file_content);
|
|
import_user($tempfile);
|
|
}
|
|
zip_entry_close($dir_resource);
|
|
}
|
|
}
|
|
zip_close($resource);
|
|
unlink($_FILES["fps"]["tmp_name"]);
|
|
} else {
|
|
import_user($tempfile);
|
|
unlink($_FILES["fps"]["tmp_name"]);
|
|
}
|
|
}
|
|
} else {
|
|
?>
|
|
|
|
<br>
|
|
<br>
|
|
<h1>导入用户csv文件</h1>
|
|
<form class='form-inline' action='user_import.php' method=post enctype="multipart/form-data">
|
|
<div class='form-group'>
|
|
<input class='form-control' type=file name='fps' >
|
|
</div>
|
|
<br><br>
|
|
<br><br><br>
|
|
<center>
|
|
<div class='form-group'>
|
|
<button class='btn btn-default btn-sm' type=submit>Upload to HUSTOJ</button>
|
|
</div>
|
|
</center>
|
|
<?php require_once ("../include/set_post_key.php"); ?>
|
|
</form>
|
|
<a href="users.csv">下载模板</a>
|
|
<?php
|
|
} ?>
|