· 8 years ago · Mar 31, 2018, 12:50 PM
1<?php
2// DROP TABLE `serv18_chars`, `serv18_factions`, `serv18_kills`, `serv18_quests`;
3include "config_.php";
4$result = mysqli_query($link, 'set names cp1251') or die(mysqli_error($link));
5
6$debug = false;
7if(isset($_REQUEST['debug']))
8 $debug = true;
9
10if(isset($_REQUEST['method']) && isset($_REQUEST['prefix'])) {
11 $method = $_REQUEST['method'];
12 $prefix = $_REQUEST['prefix'];
13 if ($method=='kill') { // ?method=kill&prefix=serv18&a=1&b=0&c=2&d=33&debug
14 $query = "INSERT INTO `{$prefix}_kills` (`id_victim`, `faction_id_victim`, `id_killer`, `faction_id_killer`)
15 VALUES ('".$_REQUEST['a']."' , '".$_REQUEST['b']."' , '".$_REQUEST['c']."', '".$_REQUEST['d']."')";
16 if($debug) echo "<pre>".$query."</pre>";
17 $result = mysqli_query($link, $query) or die(mysqli_error($link));
18 }
19 else if ($method=='creg') { // ?method=creg&prefix=serv18&a=1&b=Admin&debug
20 $query = "INSERT INTO `{$prefix}_chars` (`id`, `name`) VALUES (".$_REQUEST['a']." , '".$_REQUEST['b']."')";
21 if($debug) echo "<pre>".$query."</pre>";
22 $result = mysqli_query($link, $query) or die(mysqli_error($link));
23 }
24 else if ($method=='freg') { // ?method=freg&prefix=serv18&a=33&b=%D0%94%D1%80%D0%B0%D0%B9%D1%84%D0%B8%D0%BB%D0%B4&debug
25 $query = "INSERT INTO `{$prefix}_factions` (`id`, `name`) VALUES (".$_REQUEST['a']." , '".$_REQUEST['b']."')";
26 if($debug) echo "<pre>".$query."</pre>";
27 $result = mysqli_query($link, $query) or die(mysqli_error($link));
28 }
29 else if ($method=='reinit') { // ?method=reinit&prefix=serv18&debug
30 $query = "DROP TABLE IF EXISTS `{$prefix}_chars`;
31CREATE TABLE `{$prefix}_chars` (
32 `id` int(11) NOT NULL,
33 `name` varchar(16) DEFAULT NULL
34) ENGINE=InnoDB DEFAULT CHARSET=cp1251;
35ALTER TABLE `{$prefix}_chars`
36 ADD PRIMARY KEY (`id`),
37 ADD UNIQUE KEY `id` (`id`);
38DROP TABLE IF EXISTS `{$prefix}_factions`;
39CREATE TABLE `{$prefix}_factions` (
40 `id` int(11) NOT NULL,
41 `name` varchar(32) DEFAULT NULL
42) ENGINE=InnoDB DEFAULT CHARSET=cp1251;
43ALTER TABLE `{$prefix}_factions`
44 ADD PRIMARY KEY (`id`),
45 ADD UNIQUE KEY `id` (`id`);\n";
46 $chrtbl = mysqli_query($link, "SHOW TABLES LIKE '{$prefix}_kills'") or die(mysqli_error($link));
47 if(mysqli_num_rows($chrtbl) == 0) {
48 $query .= "CREATE TABLE `{$prefix}_kills` (
49 `id_victim` int(11) DEFAULT NULL,
50 `faction_id_victim` int(11) DEFAULT NULL,
51 `id_killer` int(11) DEFAULT NULL,
52 `faction_id_killer` int(11) DEFAULT NULL
53) ENGINE=InnoDB DEFAULT CHARSET=cp1251;
54ALTER TABLE `{$prefix}_kills`
55 ADD KEY `id_victim` (`id_victim`),
56 ADD KEY `faction_id_victim` (`faction_id_victim`),
57 ADD KEY `id_killer` (`id_killer`),
58 ADD KEY `faction_id_killer` (`faction_id_killer`);\n";
59 }
60
61 $chrtbl = mysqli_query($link, "SHOW TABLES LIKE '{$prefix}_quests'") or die(mysqli_error($link));
62 if(mysqli_num_rows($chrtbl) == 0) {
63 $query .= "CREATE TABLE IF NOT EXISTS `{$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;";
64 }
65 if($debug) echo "<pre>".$query."</pre>";
66 $result = mysqli_multi_query($link, $query) or die(mysqli_error($link));
67 }
68}
69if($debug) print_r($_REQUEST);