<?php /*
--
-- Структура таблицы `millioner`
-- CREATE TABLE `millioner` (
`id` int(11) NOT NULL auto_increment,
`question` text NOT NULL,
`answer1` varchar(255) NOT NULL,
`answer2` varchar(255) NOT NULL,
`answer3` varchar(255) NOT NULL,
`answer4` varchar(255) NOT NULL,
`type` int(11) NOT NULL,
`correct` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
*/
$host = "localhost";
$dbname = "chat";
$username = "test";
$password = "test";
$connect = mysql_connect( $host, $username, $password );
if (!$connect) {
die( Could not connect: . mysql_error());
}
$db = mysql_select_db($dbname);
$dh = "questions"; //Путь к файлам вопросов от игры миллионер
if (!is_dir($dh)){
print "Неверный путь к файлам вопроса!";
return;
}
print "Поехали...
";
$dir = opendir($dh);
while ($file = readdir($dir)){
$type =0;
switch($file){
case 100:
$type=1;
break;
case 200:
$type=2;
break;
case 300:
$type=3;
break;
case 500:
$type=4;
break;
case 1000:
$type=5;
break;
case 2000:
$type=6;
break;
case 4000:
$type=7;
break;
case 8000:
$type=8;
break;
case 16000:
$type=9;
break;
case 32000:
$type=10;
break;
case 64000:
$type=11;
break;
case 125000:
$type=12;
break;
case 250000:
$type=13;
break;
case 500000:
$type=14;
break;
case 1000000:
$type=15;
break;
default:
$type=0;
}
if ($type!=0){
$f = fopen($dh."/".$file,"r");
print "Парсим файл ".$file.", номер сложности вопроса ".$type."
";
fgets($f, 4096);
fgets($f, 4096);
while (! feof($f)){
$otvet = 0;
for ($i=0;$i<5;$i++){
$a$i = fgets($f, 4096);
if ( $a$i0 == "+"){
$otvet =$i;
}
}
$sql = "INSERT INTO `millioner` VALUES ( , ".trim(substr($a0,1))." , ".trim(substr($a1,1))." , ".trim(substr($a2,1))." , ".trim(substr($a3,1))." , ".trim(substr($a4,1))." , ".$type." , ".$otvet." )";
mysql_query($sql);
//print $sql;
unset($a);
fgets($f, 4096);
}
fclose($f);
}
}
mysql_close($connect);
print "Все...";
?>