1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
|
<?php
/******************************
* EQdkp
* Copyright 2002-2003
* Licensed under the GNU GPL. See COPYING for full terms.
* ------------------
* WoW.php
* Began: Fri May 13 2005
*
* $Id: WoW.php 8 2006-05-08 17:15:20Z tsigo $
*
******************************/
if ( !defined('EQDKP_INC') )
{
die('Hacking attempt');
}
class Manage_Game extends EQdkp_Admin
{
function do_it()
{
global $db, $eqdkp, $user;
global $SID, $dbname, $table_prefix;
parent::eqdkp_admin();
$queries = array(
"DELETE FROM ". $table_prefix ."classes;",
"UPDATE " . $table_prefix . "members SET member_level = 60 WHERE member_level > 60;",
"ALTER TABLE " . $table_prefix . "members MODIFY member_level tinyint(2) NOT NULL default '60';",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_armor_type, class_min_level, class_max_level) VALUES (0, 'Unknown', 'Plate',0,60);",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_armor_type, class_min_level, class_max_level) VALUES (1, 'Warrior', 'Mail',0,39);",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_armor_type, class_min_level, class_max_level) VALUES (2, 'Rogue', 'Leather',0,60);",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_armor_type, class_min_level, class_max_level) VALUES (3, 'Hunter', 'Leather',0,39);",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_armor_type, class_min_level, class_max_level) VALUES (4, 'Hunter', 'Mail',40,60);",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_armor_type, class_min_level, class_max_level) VALUES (5, 'Paladin', 'Mail',0,39);",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_armor_type, class_min_level, class_max_level) VALUES (6, 'Priest', 'Cloth',0,60);",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_armor_type, class_min_level, class_max_level) VALUES (7, 'Druid', 'Leather',0,60);",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_armor_type, class_min_level, class_max_level) VALUES (8, 'Shaman', 'Leather',0,39);",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_armor_type, class_min_level, class_max_level) VALUES (9, 'Shaman', 'Mail',40,60);",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_armor_type, class_min_level, class_max_level) VALUES (10, 'Warlock', 'Cloth',0,60);",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_armor_type, class_min_level, class_max_level) VALUES (11, 'Mage', 'Cloth',0,60);",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_armor_type, class_min_level, class_max_level) VALUES (12, 'Warrior', 'Plate',40,60);",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_armor_type, class_min_level, class_max_level) VALUES (13, 'Paladin', 'Plate',40,60);",
"DELETE FROM ". $table_prefix ."races;",
"INSERT INTO ". $table_prefix ."races (race_id, race_name) VALUES (0, 'Unknown');",
"INSERT INTO ". $table_prefix ."races (race_id, race_name) VALUES (1, 'Gnome');",
"INSERT INTO ". $table_prefix ."races (race_id, race_name) VALUES (2, 'Human');",
"INSERT INTO ". $table_prefix ."races (race_id, race_name) VALUES (3, 'Dwarf');",
"INSERT INTO ". $table_prefix ."races (race_id, race_name) VALUES (4, 'Night Elf');",
"INSERT INTO ". $table_prefix ."races (race_id, race_name) VALUES (5, 'Troll');",
"INSERT INTO ". $table_prefix ."races (race_id, race_name) VALUES (6, 'Undead');",
"INSERT INTO ". $table_prefix ."races (race_id, race_name) VALUES (7, 'Orc');",
"INSERT INTO ". $table_prefix ."races (race_id, race_name) VALUES (8, 'Tauren');",
"DELETE FROM ". $table_prefix ."factions;",
"INSERT INTO ". $table_prefix ."factions (faction_id, faction_name) VALUES (1, 'Alliance');",
"INSERT INTO ". $table_prefix ."factions (faction_id, faction_name) VALUES (2, 'Horde');",
"UPDATE ". $table_prefix ."config SET config_value = 'WoW' WHERE config_name = 'default_game';",
);
foreach ( $queries as $sql )
{
$db->query($sql);
}
$redir = "admin/config.php";
redirect($redir);
}
}
$manage = new Manage_Game;
$manage->do_it();
?>
|