View file install.php

<?php
include_once '../sys/inc/start.php';
include_once '../sys/inc/compress.php';
include_once '../sys/inc/sess.php';
include_once '../sys/inc/home.php';
include_once '../sys/inc/settings.php';
include_once '../sys/inc/db_connect.php';
include_once '../sys/inc/ipua.php';
include_once '../sys/inc/fnc.php';
include_once '../sys/inc/user.php';


$set['title']='Установка';
include_once '../sys/inc/thead.php';
title();
aut();



$query = "CREATE TABLE viktorina (
  num int(10) NOT NULL auto_increment,
  vopros text,
  otvet int(1) default NULL,
  otvet1 varchar(200) default NULL,
  otvet2 varchar(200) default NULL,
  otvet3 varchar(200) default NULL,
  otvet4 varchar(200) default NULL,
  PRIMARY KEY  (num)
);";

$sort=@mysql_query($query);

$query = "CREATE TABLE viktorina_users (
  num int(10) NOT NULL auto_increment,
  user varchar(200) default NULL,
  email varchar(200) default NULL,
  ip varchar(40) default NULL,
  ball int(10) default NULL,
  date_a int(20) default NULL,
  date_b int(20) default NULL,
  vopros int(6) default NULL,
  v1 int(1) default NULL,
  v2 int(1) default NULL,
  v3 int(1) default NULL,
  v4 int(1) default NULL,
  v5 int(1) default NULL,
  v6 int(1) default NULL,
  v7 int(1) default NULL,
  v8 int(1) default NULL,
  v9 int(1) default NULL,
  v10 int(1) default NULL,
  v11 int(1) default NULL,
  v12 int(1) default NULL,
  v13 int(1) default NULL,
  v14 int(1) default NULL,
  v15 int(1) default NULL,
  o1 int(1) default NULL,
  o2 int(1) default NULL,
  o3 int(1) default NULL,
  o4 int(1) default NULL,
  o5 int(1) default NULL,
  o6 int(1) default NULL,
  o7 int(1) default NULL,
  o8 int(1) default NULL,
  o9 int(1) default NULL,
  o10 int(1) default NULL,
  o11 int(1) default NULL,
  o12 int(1) default NULL,
  o13 int(1) default NULL,
  o14 int(1) default NULL,
  o15 int(1) default NULL,
  y1 int(1) default NULL,
  y2 int(1) default NULL,
  y3 int(1) default NULL,
  y4 int(1) default NULL,
  y5 int(1) default NULL,
  y6 int(1) default NULL,
  y7 int(1) default NULL,
  y8 int(1) default NULL,
  y9 int(1) default NULL,
  y10 int(1) default NULL,
  y11 int(1) default NULL,
  y12 int(1) default NULL,
  y13 int(1) default NULL,
  y14 int(1) default NULL,
  y15 int(1) default NULL,
  yes int(4) default NULL,
  no int(4) default NULL,
  session varchar(34) NOT NULL default '',
  PRIMARY KEY  (num)
);";
$sort=@mysql_query($query);  
$ff=file("base.txt");
while (list($key, $value) = each($ff)) { 
list($a, $b, $c, $d, $e, $f) = explode('|', $value);
echo "$a, $b, $c, $d, $e, $f<br>";
$f=preg_replace(array("'\|'", "'[\r|\n]'", "'\"'"),array("\|", "", "''"), $f);
$a=preg_replace(array("'\|'", "'[\r|\n]'", "'\"'"),array("\|", "", "''"), $a);
$b=preg_replace(array("'\|'", "'[\r|\n]'", "'\"'"),array("\|", "", "''"), $b);
$c=preg_replace(array("'\|'", "'[\r|\n]'", "'\"'"),array("\|", "", "''"), $c);
$d=preg_replace(array("'\|'", "'[\r|\n]'", "'\"'"),array("\|", "", "''"), $d);
$e=preg_replace(array("'\|'", "'[\r|\n]'", "'\"'"),array("\|", "", "''"), $e);

$query = "INSERT INTO viktorina (num, vopros, otvet, otvet1, otvet2, otvet3, otvet4) VALUES (\"\", \"$b\", \"$a\", \"$c\", \"$d\", \"$e\", \"$f\");";
$sort=@mysql_query($query) or die ("$query");  

}


echo "Если ошибок не видно значит установили <br>удалите файлы install.php";
include_once '../sys/inc/tfoot.php';
?>