-
Notifications
You must be signed in to change notification settings - Fork 21
/
create_account.php
353 lines (296 loc) · 15.4 KB
/
create_account.php
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
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
<?php
#################################################################################
## ##
## -= YOU MUST NOT REMOVE OR CHANGE THIS NOTICE =- ##
## ##
## --------------------------------------------------------------------------- ##
## ##
## Project: ZravianX ##
## Version: 6.0.1 ##
## Filename: create_account.php ##
## Developed by: Dzoki & Advocaite & Donnchadh ##
## Edited by: ZZJHONS ##
## License: Creative Commons BY-NC-SA 3.0 ##
## Copyright: ZravianX (c) 2011 - All rights reserved ##
## URLs: http://www.xtravian.com & http://zravianx.zzjhons.com ##
## Source code: http://www.github.com/ZZJHONS/ZravianX ##
## ##
#################################################################################
include_once ("GameEngine/Session.php");
include_once ("GameEngine/config.php");
mysql_connect(SQL_SERVER, SQL_USER, SQL_PASS);
mysql_select_db(SQL_DB);
// If user is not administrator, access is denied!
if($session->access < ADMIN)
die("Access Denied: You are not Admin!");
// Functions
function generateBase($kid, $uid, $username) {
global $database, $message;
if($kid == 0) {
$kid = rand(1, 4);
} else {
$kid = $_POST['kid'];
}
$wid = $database->generateBase($kid);
$database->setFieldTaken($wid);
$database->addVillage($wid, $uid, $username, 1);
$database->addResourceFields($wid, $database->getVillageType($wid));
$database->addUnits($wid);
$database->addTech($wid);
$database->addABTech($wid);
$database->updateUserField($uid, "access", USER, 1);
$message->sendWelcome($uid, $username);
}
// Creating account & capital village
$username = "Natars";
$password = md5('password');
$email = "[email protected]";
$tribe = 5;
$desc = "********************
[#natars]
********************";
$q = "INSERT INTO ".TB_PREFIX."users (id,username,password,access,email,timestamp,tribe,location,act,protect) VALUES (3, '$username', '$password', ".USER.", '$email', ".time().", $tribe, '', '', 0)";
mysql_query($q);
unset($q);
$uid = $database->getUserField($username, 'id', 1);
generateBase(0, $uid, $username);
$wid = mysql_fetch_assoc(mysql_query("SELECT * FROM " . TB_PREFIX . "vdata WHERE owner = $uid"));
$q = "UPDATE " . TB_PREFIX . "vdata SET pop = 834 WHERE owner = $uid";
mysql_query($q) or die(mysql_error());
$q2 = "UPDATE " . TB_PREFIX . "users SET access = 0 WHERE id = $uid";
mysql_query($q2) or die(mysql_error());
if(SPEED > 3) {
$speed = 5;
} else {
$speed = SPEED;
}
$q3 = "UPDATE " . TB_PREFIX . "units SET u41 = " . (64700 * $speed) . ", u42 = " . (295231 * $speed) . ", u43 = " . (180747 * $speed) . ", u44 = " . (7 * $speed) . ", u45 = " . (364401 * $speed) . ", u46 = " . (217602 * $speed) . ", u47 = " . (2034 * $speed) . ", u48 = " . (1040 * $speed) . " , u49 = " . (1 * $speed) . ", u50 = " . (9 * $speed) . " WHERE vref = " . $wid['wref'] . "";
mysql_query($q3) or die(mysql_error());
$q4 = "UPDATE " . TB_PREFIX . "users SET desc2 = '$desc' WHERE id = $uid";
mysql_query($q4) or die(mysql_error());
// SMALL ARTEFACTS
function Artefact($uid, $type, $size, $art_name, $village_name, $desc, $effect, $img) {
global $database;
$kid = rand(1, 4);
$wid = $database->generateBase($kid);
$database->addArtefact($wid, $uid, $type, $size, $art_name, $desc, $effect, $img);
$database->setFieldTaken($wid);
$database->addVillage($wid, $uid, $village_name, '0');
$database->addResourceFields($wid, $database->getVillageType($wid));
$database->addUnits($wid);
$database->addTech($wid);
$database->addABTech($wid);
mysql_query("UPDATE " . TB_PREFIX . "vdata SET pop = 163 WHERE wref = $wid");
mysql_query("UPDATE " . TB_PREFIX . "vdata SET name = '$village_name' WHERE wref = $wid");
if(SPEED > 3) {
$speed = 5;
} else {
$speed = SPEED;
}
if($size == 1) {
mysql_query("UPDATE " . TB_PREFIX . "units SET u41 = " . (rand(1000, 2000) * $speed) . ", u42 = " . (rand(1500, 2000) * $speed) . ", u43 = " . (rand(2300, 2800) * $speed) . ", u44 = " . (rand(25, 75) * $speed) . ", u45 = " . (rand(1200, 1900) * $speed) . ", u46 = " . (rand(1500, 2000) * $speed) . ", u47 = " . (rand(500, 900) * $speed) . ", u48 = " . (rand(100, 300) * $speed) . " , u49 = " . (rand(1, 5) * $speed) . ", u50 = " . (rand(1, 5) * $speed) . " WHERE vref = " . $wid . "");
mysql_query("UPDATE " . TB_PREFIX . "fdata SET f22t = 27, f22 = 10, f28t = 25, f28 = 10, f19t = 23, f19 = 10, f32t = 23, f32 = 10 WHERE vref = $wid");
} elseif($size == 2) {
mysql_query("UPDATE " . TB_PREFIX . "units SET u41 = " . (rand(2000, 4000) * $speed) . ", u42 = " . (rand(3000, 4000) * $speed) . ", u43 = " . (rand(4600, 5600) * $speed) . ", u44 = " . (rand(50, 150) * $speed) . ", u45 = " . (rand(2400, 3800) * $speed) . ", u46 = " . (rand(3000, 4000) * $speed) . ", u47 = " . (rand(1000, 1800) * $speed) . ", u48 = " . (rand(200, 600) * $speed) . " , u49 = " . (rand(2, 10) * $speed) . ", u50 = " . (rand(2, 10) * $speed) . " WHERE vref = " . $wid . "");
mysql_query("UPDATE " . TB_PREFIX . "fdata SET f22t = 27, f22 = 10, f28t = 25, f28 = 20, f19t = 23, f19 = 10, f32t = 23, f32 = 10 WHERE vref = $wid");
} elseif($size == 3) {
mysql_query("UPDATE " . TB_PREFIX . "units SET u41 = " . (rand(4000, 8000) * $speed) . ", u42 = " . (rand(6000, 8000) * $speed) . ", u43 = " . (rand(9200, 11200) * $speed) . ", u44 = " . (rand(100, 300) * $speed) . ", u45 = " . (rand(4800, 7600) * $speed) . ", u46 = " . (rand(6000, 8000) * $speed) . ", u47 = " . (rand(2000, 3600) * $speed) . ", u48 = " . (rand(400, 1200) * $speed) . " , u49 = " . (rand(4, 20) * $speed) . ", u50 = " . (rand(4, 20) * $speed) . " WHERE vref = " . $wid . "");
mysql_query("UPDATE " . TB_PREFIX . "fdata SET f22t = 27, f22 = 10, f28t = 25, f28 = 20, f19t = 23, f19 = 10, f32t = 23, f32 = 10 WHERE vref = $wid");
}
}
// THE ARCHITECTS
$desc = 'All buildings in the area of effect are stronger. This means that you will need more catapults to damage buildings protected by this artifacts powers.';
$vname = 'Diamond Chisel';
$effect = '(4x)';
for($i > 1; $i < 6; $i++) {
Artefact($uid, 1, 1, 'The architects slight secret', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type1.gif');
}
unset($i);
unset($vname);
unset($effect);
$vname = 'Giant Marble Hammer';
$effect = '(3x)';
for($i > 1; $i < 4; $i++) {
Artefact($uid, 1, 2, 'The architects great secret', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type1.gif');
}
unset($i);
unset($vname);
unset($effect);
$vname = 'Hemons Scrolls';
$effect = '(5x)';
for($i > 1; $i < 1; $i++) {
Artefact($uid, 1, 3, 'The architects unique secret', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type1.gif');
}
// MILITARY HASTE
$desc = 'All troops in the area of effect move faster.';
unset($i);
unset($vname);
unset($effect);
$vname = 'Opal Horseshoe';
$effect = '(2x)';
for($i > 1; $i < 6; $i++) {
Artefact($uid, 2, 1, 'The slight titan boots', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type2.gif');
}
unset($i);
unset($vname);
unset($effect);
$vname = 'Golden Chariot';
$effect = '(1.5x)';
for($i > 1; $i < 4; $i++) {
Artefact($uid, 2, 2, 'The great titan boots', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type2.gif');
}
unset($i);
unset($vname);
unset($effect);
$vname = 'Pheidippides Sandals';
$effect = '(3x)';
for($i > 1; $i < 1; $i++) {
Artefact($uid, 2, 3, 'The unique titan boots', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type2.gif');
}
// HAWK'S EYESIGHT
$desc = 'All spies (Scouts, Pathfinders, and Equites Legati) increase their spying ability. In addition, with all versions of this artifact you can see the incoming TYPE of troops but not how many there are.';
unset($i);
unset($vname);
unset($effect);
$vname = 'Tale of a Rat';
$effect = '(5x)';
for($i > 1; $i < 6; $i++) {
Artefact($uid, 3, 1, 'The eagles slight eyes', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type3.gif');
}
unset($i);
unset($vname);
unset($effect);
$vname = 'Generals Letter';
$effect = '(3x)';
for($i > 1; $i < 4; $i++) {
Artefact($uid, 3, 2, 'The eagles great eyes', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type3.gif');
}
unset($i);
unset($vname);
unset($effect);
$vname = 'Diary of Sun Tzu';
$effect = '(10x)';
for($i > 1; $i < 1; $i++) {
Artefact($uid, 3, 3, 'The eagles unique eyes', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type3.gif');
}
// THE DIET
$desc = 'All troops in the artifacts range consume less wheat, making it possible to maintain a larger army.';
unset($i);
unset($vname);
unset($effect);
$vname = 'Silver Platter';
$effect = '(50%)';
for($i > 1; $i < 6; $i++) {
Artefact($uid, 4, 1, 'Slight diet control', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type4.gif');
}
unset($i);
unset($vname);
unset($effect);
$vname = 'Sacred Hunting Bow';
$effect = '(25%)';
for($i > 1; $i < 4; $i++) {
Artefact($uid, 4, 2, 'Great diet control', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type4.gif');
}
unset($i);
unset($vname);
unset($effect);
$vname = 'King Arthurs Chalice';
$effect = '(50%)';
for($i > 1; $i < 1; $i++) {
Artefact($uid, 4, 3, 'Unique diet control', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type4.gif');
}
// ACADEMIC ADVANCEMENT
$desc = 'Troops are built a certain percentage faster within the scope of the artifact.';
unset($i);
unset($vname);
unset($effect);
$vname = 'Scribed Soldiers Oath';
$effect = '(50%)';
for($i > 1; $i < 6; $i++) {
Artefact($uid, 5, 1, 'The trainers slight talent', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type5.gif');
}
unset($i);
unset($vname);
unset($effect);
$vname = 'Declaration of War';
$effect = '(25%)';
for($i > 1; $i < 4; $i++) {
Artefact($uid, 5, 2, 'The trainers great talent', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type5.gif');
}
unset($i);
unset($vname);
unset($effect);
$vname = 'Memoirs of Alexander the Great';
$effect = '(50%)';
for($i > 1; $i < 1; $i++) {
Artefact($uid, 5, 3, 'The trainers unique talent', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type5.gif');
}
// STORAGE MASTER PLAN
$desc = 'With this building plan you are able to build the Great Granary or Great Warehouse in the Village with the artifact, or the whole account depending on the artifact. As long as you posses that artifact you are able to build and enlarge those buildings.';
unset($i);
unset($vname);
unset($effect);;
$vname = 'Builders Sketch';
$effect = '';
for($i > 1; $i < 6; $i++) {
Artefact($uid, 6, 1, 'Slight storage masterplan', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type6.gif');
}
unset($i);
unset($vname);
unset($effect);
$vname = 'Babylonian Tablet';
$effect = '';
for($i > 1; $i < 4; $i++) {
Artefact($uid, 6, 2, 'Great storage masterplan', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type6.gif');
}
// RIVAL'S CONFUSION
$desc = 'Cranny capacity is increased by a certain amount for each type of artifact. Catapults can only shoot random on villages within this artifacts power. Exceptions are the WW which can always be targeted and the treasure chamber which can always be targeted, except with the unique artifact. When aiming at a resource field only random resource fields can be hit, when aiming at a building only random buildings can be hit.';
unset($i);
unset($vname);
unset($effect);
$vname = 'Map of the Hidden Caverns';
$effect = '(200)';
for($i > 1; $i < 6; $i++) {
Artefact($uid, 7, 1, 'Rivals slight confusion', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type7.gif');
}
unset($i);
unset($vname);
unset($effect);
$vname = 'Bottomless Satchel';
$effect = '(100)';
for($i > 1; $i < 4; $i++) {
Artefact($uid, 7, 2, 'Rivals great confusion', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type7.gif');
}
unset($i);
unset($vname);
unset($effect);
$vname = 'Trojan Horse';
$effect = '(500)';
for($i > 1; $i < 1; $i++) {
Artefact($uid, 7, 3, 'Rivals unique confusion', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type7.gif');
}
// ARTEFACT OF THE FOOL
$desc = 'Every 24 hours it gets a random effect, bonus, or penalty (all are possible with the exception of great warehouse, great granary and WW building plans). They change effect AND scope every 24 hours. The unique artifact will always take positive bonuses.';
unset($i);
unset($vname);
unset($effect);
$vname = 'Pendant of Mischief';
for($i > 1; $i < 5; $i++) {
Artefact($uid, 8, 1, 'Artefact of the slight fool', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type8.gif');
}
unset($i);
unset($vname);
unset($effect);
$vname = 'Pendant of Mischief';
for($i > 1; $i < 5; $i++) {
Artefact($uid, 8, 2, 'Artefact of the slight fool', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type8.gif');
}
unset($i);
unset($vname);
unset($effect);
$vname = 'Forbidden Manuscript';
for($i > 1; $i < 1; $i++) {
Artefact($uid, 8, 3, 'Artefact of the unique fool', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type8.gif');
}
echo "Done";
?>