axiccjLX

1<?php
2
3include "config.php";
4 $query ='set names cp1251';
5 	$result = mysqli_query($link, $query) or die(mysqli_error($link));
6
7if ($_POST['method']=='kill')
8{
9    $query =  "CREATE TABLE IF NOT EXISTS `".$_POST['prefix']."_kills` (`id_victim` INT NULL, `faction_id_victim` INT NULL, `id_killer` INT NULL, `faction_id_killer` INT NULL) DEFAULT CHARACTER SET = cp1251 COLLATE = cp1251_general_ci";
10	$result = mysqli_query($link, $query) or die(mysqli_error($link));
11	$query = "INSERT INTO `".$_POST['prefix']."_kills` (`id_victim`, `faction_id_victim`, `id_killer`, `faction_id_killer`) VALUES (".$_POST['a']." , ".$_POST['b']." , ".$_POST['c'].",  ".$_POST['d'].")";
12	$result = mysqli_query($link, $query) or die(mysqli_error($link));
13}
14
15
16if ($_POST['method']=='creg')
17{
18    $query = "CREATE TABLE IF NOT EXISTS `".$_POST['prefix']."_chars` (`id` INT NULL,  `name` VARCHAR(16) NULL) DEFAULT CHARACTER SET = cp1251 COLLATE = cp1251_general_ci";
19    $result = mysqli_query($link, $query) or die(mysqli_error($link));
20	$query = "INSERT INTO `".$_POST['prefix']."_chars` (`id`, `name`) VALUES (".$_POST['a']." , '".$_POST['b']."')";
21	$result = mysqli_query($link, $query) or die(mysqli_error($link));
22}
23
24if ($_POST['method']=='freg')
25{   $query =  "CREATE TABLE IF NOT EXISTS `".$_POST['prefix']."_factions` (`id` INT NULL,  `name` VARCHAR(32) NULL) DEFAULT CHARACTER SET = cp1251 COLLATE = cp1251_general_ci";
26	$result = mysqli_query($link, $query) or die(mysqli_error($link));
27	$query = "INSERT INTO `".$_POST['prefix']."_factions` (`id`, `name`) VALUES (".$_POST['a']." , '".$_POST['b']."')";
28	$result = mysqli_query($link, $query) or die(mysqli_error($link));
29}
30
31if ($_POST['method']=='reinit')
32{   $query = "DROP TABLE `".$_POST['prefix']."_chars`";
33	$result = mysqli_query($link, $query) or die(mysqli_error($link));
34    $query = "DROP TABLE `".$_POST['prefix']."_factions";
35	$result = mysqli_query($link, $query) or die(mysqli_error($link));
36    $query = "CREATE TABLE IF NOT EXISTS `".$_POST['prefix']."_chars` (`id` INT NULL,  `name` VARCHAR(16) NULL)  DEFAULT CHARACTER SET = cp1251 COLLATE = cp1251_general_ci";
37    $result = mysqli_query($link, $query) or die(mysqli_error($link));
38	$query =  "CREATE TABLE IF NOT EXISTS `".$_POST['prefix']."_factions` (`id` INT NULL,  `name` VARCHAR(32) NULL) DEFAULT CHARACTER SET = cp1251 COLLATE = cp1251_general_ci";
39	$result = mysqli_query($link, $query) or die(mysqli_error($link));
40	$query =  "CREATE TABLE IF NOT EXISTS `".$_POST['prefix']."_kills` (`id_victim` INT NULL, `faction_id_victim` INT NULL, `id_killer` INT NULL, `faction_id_killer` INT NULL) DEFAULT CHARACTER SET = cp1251 COLLATE = cp1251_general_ci";
41	$result = mysqli_query($link, $query) or die(mysqli_error($link));
42	$query =  "CREATE TABLE IF NOT EXISTS `".$_POST['prefix']."_quests` (`quest_name_rus` VARCHAR(32) NULL, `quest_name_eng` VARCHAR(32) NULL, `id_taker` INT NULL, `id_performer` INT NULL, `time` INT NULL, `kd_from` INT NULL, `kd_to` INT NULL) DEFAULT CHARACTER SET = cp1251 COLLATE = cp1251_general_ci";
43	$result = mysqli_query($link, $query) or die(mysqli_error($link));
44}
45
46print_r($_POST);
47
48?>