1
<?php
2
/**
3
 *   File functions:
4
 *   Player's equip - wear and drop items, repair, sell and more
5
 *
6
 *   @name                 : equip.php
7
 *   @copyright            : (C) 2004,2005,2006,2007 Vallheru Team based on Gamers-Fusion ver 2.5
8
 *   @author               : thindil <thindil@users.sourceforge.net>
9
 *   @version              : 1.3
10
 *   @since                : 21.02.2007
11
 *
12
 */
13
14
//
15
//
16
//       This program is free software; you can redistribute it and/or modify
17
//   it under the terms of the GNU General Public License as published by
18
//   the Free Software Foundation; either version 2 of the License, or
19
//   (at your option) any later version.
20
//
21
//   This program is distributed in the hope that it will be useful,
22
//   but WITHOUT ANY WARRANTY; without even the implied warranty of
23
//   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
24
//   GNU General Public License for more details.
25
//
26
//   You should have received a copy of the GNU General Public License
27
//   along with this program; if not, write to the Free Software
28
//   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
29
//
30
// $Id: equip.php 890 2007-02-21 19:37:53Z thindil $
31
32
$title = "Ekwipunek";
33
require_once("includes/head.php");
34
require_once("includes/functions.php");
35
36
/**
37
* Get the localization for game
38
*/
39
require_once("languages/".$player -> lang."/equip.php");
40
41
/**
42
* Function to show poisoned equipment.
43
*/
44
function showpoisoned ( $intPoisonPower, $strPoisonType)
45
{
46
    $strPoisonInfo ='';
47
    if ($intPoisonPower > 0)
48
    {
49
        switch ($strPoisonType)
50
        {
51
            case 'D':
52
                $strPoisonInfo = '( '.POISON_TYPE.' Dynallca: +'.$intPoisonPower.') ';
53
                break;
54
            case 'N':
55
                $strPoisonInfo = '( '.POISON_TYPE.' Nutari: +'.$intPoisonPower.') ';
56
                break;
57
            default:
58
                $strPoisonInfo = '( '.POISON_TYPE.' Illani: +'.$intPoisonPower.') ';
59
        }
60
    }
61
    return $strPoisonInfo;
62
}
63
/**
64
* Function show items in backpack
65
*/
66
function backpack($type,$playerid,$nameitems,$type2,$smartyname)
67
{
68
    global $smarty;
69
    global $db;
70
    if (!empty ($type2))
71
    {
72
        $arm = $db -> Execute("SELECT * FROM equipment WHERE owner=".$playerid." AND type='".$type."' AND status='U'");
73
        $arm1 = $db -> Execute("SELECT * FROM equipment WHERE owner=".$playerid." AND type='".$type2."' AND status='U'");
74
    }
75
        else
76
    {
77
        $arm = $db -> Execute("SELECT * FROM equipment WHERE owner=".$playerid." AND type='".$type."' AND status='U'");
78
    }
79
    $arrshow = array();
80
    if (!isset($arm1))
81
    {
82
        $secarm = 0;
83
    }
84
        else
85
    {
86
        $secarm = 1;
87
    }
88
    if ($arm -> fields['id'] || $secarm)
89
    {
90
        $arrshow[0] = "<br /><u>".IN_BACKPACK." ".$nameitems."</u>:<br />\n";
91
    }
92
    $j = 1;
93
    while (!$arm -> EOF)
94
    {
95
        if ($arm -> fields['zr'] < 0)
96
        {
97
            $arm -> fields['zr'] = str_replace("-","",$arm -> fields['zr']);
98
            $agility = "(+".$arm -> fields['zr']." ".EQUIP_AGI.")";
99
        }
100
            elseif ($arm -> fields['zr'] > 0)
101
        {
102
            $agility = "(-".$arm -> fields['zr']."% ".EQUIP_AGI.")";
103
        }
104
            elseif ($arm -> fields['zr'] == 0)
105
        {
106
            $agility = '';
107
        }
108
        if ($arm -> fields['szyb'] > 0 && $arm -> fields['type'] != 'A')
109
        {
110
            $speed = "(+".$arm -> fields['szyb']." ".EQUIP_SPEED.")";
111
        }
112
            else
113
        {
114
            $speed = '';
115
        }
116
        $ckoszt = $arm -> fields['repair'];
117
        if ($arm -> fields['maxwt'] == $arm -> fields['wt'])
118
        {
119
            $ckoszt = 0;
120
        }
121
        if ($arm -> fields['type'] == 'C')
122
        {
123
            $arrshow[$j] = "<b>(".AMOUNT.": ".$arm -> fields['amount']." )</b> ".$arm -> fields['name']." (+".$arm -> fields['power']." % ".EQUIP_MANA.") [ <a href=\"equip.php?equip=".$arm -> fields['id']."\">".A_WEAR."</a> | <A href=\"equip.php?sell=".$arm -> fields['id']."\">".A_SELL."</a> ".FOR_A." ".$arm -> fields['cost']." ".GOLD_COINS." ]<br />";
124
        }
125
            elseif ($arm -> fields['type'] == 'T')
126
        {
127
            $arrshow[$j] = "<b>(".AMOUNT.": ".$arm -> fields['amount']." )</b> ".$arm -> fields['name']." (".SPELL_POWER.") [ <a href=\"equip.php?equip=".$arm -> fields['id']."\">".A_WEAR."</a> | <A href=\"equip.php?sell=".$arm -> fields['id']."\">".A_SELL."</a> ".FOR_A." ".$arm -> fields['cost']." ".GOLD_COINS." ]<br />";
128
        }
129
            else
130
        {
131
            $strWarn = ($arm -> fields['wt'] < 11) ? '<blink>' : '';
132
            $strWarn1 =($arm -> fields['wt'] < 11) ? '</blink>' : '';
133
            $strPoisonType ='';
134
            $arrshow[$j] = $strWarn."<b>(".AMOUNT.": ".$arm -> fields['amount']." )</b> ".$arm -> fields['name']." (+".$arm -> fields['power'].")".showpoisoned($arm -> fields['poison'], $arm -> fields['ptype'])." ".$agility."".$speed." (".$arm -> fields['wt']."/".$arm -> fields['maxwt']." ".DURABILITY.")".$strWarn1." [ <a href=\"equip.php?equip=".$arm -> fields['id']."\">".A_WEAR."</a> | <A href=\"equip.php?sell=".$arm -> fields['id']."\">".A_SELL."</a> ".FOR_A." ".$arm -> fields['cost']." ".GOLD_COINS." | <a href=\"equip.php?napraw=".$arm -> fields['id']."\">".A_REPAIR."</a> ".FOR_A." ".$ckoszt." ".GOLD_COINS." ]<br />";
135
        }
136
        $arm -> MoveNext();
137
        $j = $j + 1;
138
        $menu = 'Y';
139
    }
140
    if ($secarm)
141
    {
142
        while (!$arm1 -> EOF)
143
        {
144
            if ($arm1 -> fields['zr'] < 0)
145
            {
146
                $arm1 -> fields['zr'] = str_replace("-","",$arm1 -> fields['zr']);
147
                $agility = "(+".$arm1 -> fields['zr']." ".EQUIP_AGI.")";
148
            }
149
                elseif ($arm1 -> fields['zr'] > 0)
150
            {
151
                $agility = "(-".$arm1 -> fields['zr']."% ".EQUIP_AGI.")";
152
            }
153
                else
154
            {
155
                $agility = '';
156
            }
157
            if ($arm1 -> fields['szyb'] > 0)
158
            {
159
                $speed = "(+".$arm1 -> fields['szyb']." ".EQUIP_SPEED.")";
160
            }
161
                else
162
            {
163
                $speed = '';
164
            }
165
            $ckoszt = $arm1 -> fields['repair'];
166
            if ($arm1 -> fields['maxwt'] == $arm1 -> fields['wt'])
167
            {
168
                $ckoszt = 0;
169
            }
170
            if ($arm1 -> fields['type'] == 'C')
171
            {
172
                $arrshow[$j] = "<b>(".AMOUNT.": ".$arm1 -> fields['amount']." )</b> ".$arm1 -> fields['name']." (+".$arm1 -> fields['power']." % ".EQUIP_MANA.") [ <a href=\"equip.php?equip=".$arm1 -> fields['id']."\">".A_WEAR."</a> | <A href=\"equip.php?sell=".$arm1 -> fields['id']."\">".A_SELL."</a> ".FOR_A." ".$arm1 -> fields['cost']." ".GOLD_COINS." ]<br />";
173
            }
174
                elseif ($arm -> fields['type'] == 'T')
175
            {
176
                $arrshow[$j] = "<b>(".AMOUNT.": ".$arm1 -> fields['amount']." )</b> ".$arm1 -> fields['name']." (".SPELL_POWER.") [ <a href=\"equip.php?equip=".$arm1 -> fields['id']."\">".A_WEAR."</a> | <A href=\"equip.php?sell=".$arm1 -> fields['id']."\">".A_SELL."</a> ".FOR_A." ".$arm1 -> fields['cost']." ".GOLD_COINS." ]<br />";
177
            }
178
                else
179
            {
180
                $strWarn = ($arm1 -> fields['wt'] < 11) ? '<blink>' : '';
181
                $strWarn1 =($arm1 -> fields['wt'] < 11) ? '</blink>' : '';
182
                $arrshow[$j] = $strWarn."<b>(".AMOUNT.": ".$arm1 -> fields['amount']." )</b> ".$arm1 -> fields['name']." (+".$arm1 -> fields['power'].") ".$agility."".$speed." (".$arm1 -> fields['wt']."/".$arm1 -> fields['maxwt']." ".DURABILITY.")".$strWarn1." [ <a href=\"equip.php?equip=".$arm1 -> fields['id']."\">".A_WEAR."</a> | <A href=\"equip.php?sell=".$arm1 -> fields['id']."\">".A_SELL."</a> ".FOR_A." ".$arm1 -> fields['cost']." ".GOLD_COINS." | <a href=\"equip.php?napraw=".$arm1 -> fields['id']."\">".A_REPAIR."</a> ".FOR_A." ".$ckoszt." ".GOLD_COINS." ]<br />";
183
            }
184
            $arm1 -> MoveNext();
185
            $j = $j + 1;
186
            $menu = 'Y';
187
        }
188
    }
189
    if (isset($menu) && $menu == 'Y')
190
    {
191
        $arrshow[$j] = "(<a href=\"equip.php?sprzedaj=".$type."\">".A_SELL_ALL." ".$nameitems."</a>)<br />\n";
192
    }
193
    $smarty -> assign ($smartyname, $arrshow);
194
    $arm -> Close();
195
    if ($secarm)
196
    {
197
        $arm1 -> Close();
198
    }
199
}
200
201
/**
202
* Assign variables to template
203
*/
204
$smarty -> assign(array("Arrowhead" => '',
205
                        "Action" => '',
206
                        "Potions" => '',
207
                        "Hide" => '',
208
                        "Repairequip" => '',
209
                        "Arrows1" => '',
210
                        "Equipped" => EQUIPPED,
211
                        "Tarrows" => ARROWS,
212
                        "Asell" => A_SELL));
213
214
/**
215
* unwear item
216
*/
217
if (isset($_GET['schowaj']))
218
{
219
    if (!ereg("^[1-9][0-9]*$", $_GET['schowaj']))
220
    {
221
        error (ERROR);
222
    }
223
    $bron = $db -> Execute("SELECT * FROM equipment WHERE id=".$_GET['schowaj']);
224
    if (!$bron -> fields['id'])
225
    {
226
        error (NO_ITEM);
227
    }
228
    if ($player -> id != $bron -> fields['owner'])
229
    {
230
        error (NOT_YOUR);
231
    }
232
    if (isset($arrEquip[6][0]))
233
    {
234
        $test = $db -> Execute("SELECT id FROM equipment WHERE name='".$arrEquip[6][1]."' AND status='U' AND owner=".$player -> id." AND power=".$arrEquip[6][2]." AND poison=".$arrEquip[6][8]." AND ptype='".$arrEquip[6][3]."'");
235
    }
236
    if ($bron -> fields['type'] == 'B')
237
    {
238
        if (!isset($test -> fields['id']))
239
        {
240
            $db -> Execute("UPDATE `equipment` SET `status`='U' WHERE `type`='R' AND `owner`=".$player -> id." AND `status`='E'");
241
        }
242
            else
243
        {
244
            $db -> Execute("UPDATE `equipment` SET `wt`=`wt`+".$arrEquip[6][6]." WHERE `id`=".$test -> fields['id']);
245
            $db -> Execute("DELETE FROM `equipment` WHERE `id`=".$arrEquip[6][0]);
246
        }
247
    }
248
    if ($bron -> fields['type'] == 'R')
249
    {
250
        if (!isset($test -> fields['id']))
251
        {
252
            $db -> Execute("UPDATE `equipment` SET `status`='U' WHERE `type`='R' AND `owner`=".$player -> id." AND `status`='E'");
253
        }
254
            else
255
        {
256
            $db -> Execute("UPDATE `equipment` SET `wt`=`wt`+".$arrEquip[6][6]." WHERE `id`=".$test -> fields['id']);
257
            $db -> Execute("DELETE FROM `equipment` WHERE `id`=".$arrEquip[6][0]);
258
        }
259
    }
260
        else
261
    {
262
        $test = $db -> Execute("SELECT id FROM equipment WHERE name='".$bron -> fields['name']."' AND wt=".$bron -> fields['wt']." AND type='".$bron -> fields['type']."' AND status='U' AND owner=".$player -> id." AND power=".$bron -> fields['power']." AND zr=".$bron -> fields['zr']." AND szyb=".$bron -> fields['szyb']." AND maxwt=".$bron -> fields['maxwt']." AND poison=".$bron -> fields['poison']." AND ptype='".$bron -> fields['ptype']."' AND cost=".$bron -> fields['cost']." AND wzmocnienie = '".$bron -> fields['wzmocnienie']."'");
263
        if ($test -> fields['id'])
264
        {
265
            $db -> Execute("UPDATE equipment SET amount=amount+1 WHERE id=".$test -> fields['id']);
266
        }
267
            else
268
        {
269
            $db -> Execute("INSERT INTO equipment (owner, name, power, type, cost, zr, wt, minlev, maxwt, amount, magic, poison, szyb, twohand, ptype, repair, wzmocnienie) VALUES(".$player -> id.",'".$bron -> fields['name']."',".$bron -> fields['power'].",'".$bron -> fields['type']."',".$bron -> fields['cost'].",".$bron -> fields['zr'].",".$bron -> fields['wt'].",".$bron -> fields['minlev'].",".$bron -> fields['maxwt'].",1,'".$bron -> fields['magic']."',".$bron -> fields['poison'].",".$bron -> fields['szyb'].",'".$bron -> fields['twohand']."', '".$bron -> fields['ptype']."', ".$bron -> fields['repair'].", '".$bron -> fields['wzmocnienie']."')") or error(E_DB);
270
        }
271
        $test -> Close();
272
        $db -> Execute("DELETE FROM equipment WHERE id=".$bron -> fields['id']);
273
    }
274
    $bron -> Close();
275
    $smarty -> assign ("Hide", "<br />(<a href=\"equip.php\">".REFRESH."</a>)<br />\n");
276
}
277
278
/**
279
* Sell one potion
280
*/
281
282
if (isset($_GET['sell_potion']))
283
{
284
    if (!ereg("^[1-9][0-9]*$", $_GET['sell_potion']))
285
    {
286
        error (ERROR);
287
    }
288
    $sell = $db -> Execute("SELECT * FROM `potions` WHERE `id`=".$_GET['sell_potion']);
289
    if (!$sell -> fields['id'])
290
    {
291
        error (NO_ITEM);
292
    }
293
    if ($player -> id != $sell -> fields['owner'])
294
    {
295
        error (NOT_YOUR);
296
    }
297
    if (ereg("(K)",  $sell -> fields['name']) || ereg("(S)",  $sell -> fields['name']))
298
    {
299
        $name = str_replace(" (S)","", str_replace(" (K)","", $sell -> fields['name']));
300
        $mik2 = $db -> Execute("SELECT `illani`, `illanias`, `nutari`, `dynallca` FROM `alchemy_mill` WHERE `name`='".$name."' AND `owner`=0" );
301
     }
302
     else
303
     {
304
     $mik2 = $db -> Execute("SELECT `illani`, `illanias`, `nutari`, `dynallca` FROM `alchemy_mill` WHERE `name`='".$sell -> fields['name']."' AND `owner`=0" );
305
     }
306
    $cost = $mik2 -> fields['illanias']*6 + $mik2 -> fields['illani']*4 + $mik2 -> fields['nutari']*8 + $mik2 -> fields['dynallca']*10;
307
    if ($sell -> fields['amount'] > 0)
308
    {
309
        $db -> Execute("UPDATE `potions` SET `amount`=`amount`-1 WHERE `id`=".$sell -> fields['id']);
310
    }
311
        else
312
    {
313
        $db -> Execute("DELETE FROM `potions` WHERE `id`=".$sell -> fields['id']);
314
    }
315
    $db -> Execute("UPDATE `players` SET `credits`=`credits`+".$cost." WHERE `id`=".$player -> id);
316
    $smarty -> assign ("Action", YOU_SELL." ".$sell -> fields['name']." ".FOR_A." ".$cost." ".GOLD_COINS.". (<A href=\"equip.php\">".REFRESH."</a>)");
317
    $sell -> Close();
318
}
319
320
/**
321
* Sell one item
322
*/
323
if (isset($_GET['sell']))
324
{
325
    if (!ereg("^[1-9][0-9]*$", $_GET['sell']))
326
    {
327
        error (ERROR);
328
    }
329
    $sell = $db -> Execute("SELECT * FROM equipment WHERE id=".$_GET['sell']);
330
    if (!$sell -> fields['id'])
331
    {
332
        error (NO_ITEM);
333
    }
334
    if ($sell -> fields['wt'] < $sell -> fields['maxwt'] && $sell -> fields['type'] != 'R')
335
    {
336
        error (BROKEN_ITEM);
337
    }
338
    if ($player -> id != $sell -> fields['owner'])
339
    {
340
        error (NOT_YOUR);
341
    }
342
    if ($sell -> fields['type'] == 'R')
343
    {
344
        $costone = ($sell -> fields['cost'] / 100);
345
        $sell -> fields['cost'] = ceil($costone * $sell -> fields['wt']);
346
        $db -> Execute("DELETE FROM `equipment` WHERE `id`=".$sell -> fields['id']);
347
    }
348
    if ($sell ->fields['status'] == 'R')
349
    {
350
        error (NOT_YOUR);
351
    }
352
    $db -> Execute("UPDATE `players` SET `credits`=`credits`+".$sell -> fields['cost']." WHERE `id`=".$player -> id);
353
    $amount = $sell -> fields['amount'] - 1;
354
    if ($amount > 0)
355
    {
356
        $db -> Execute("UPDATE `equipment` SET `amount`=`amount`-1 WHERE `id`=".$sell -> fields['id']);
357
    }
358
        else
359
    {
360
        $db -> Execute("DELETE FROM `equipment` WHERE `id`=".$sell -> fields['id']);
361
    }
362
    $smarty -> assign ("Action", YOU_SELL." ".$sell -> fields['name']." ".FOR_A." ".$sell -> fields['cost']." ".GOLD_COINS.". (<A href=\"equip.php\">".REFRESH."</a>)");
363
    $sell -> Close();
364
}
365
366
/**
367
* Sell all potion
368
*/
369
370
if (isset($_GET['sell_allpotion']))
371
{
372
	$cost_potion = $db -> Execute("SELECT * FROM `potions` WHERE `owner`=".$player -> id." AND `status`='K'");
373
	if (!isset($cost_potion -> fields['id']))
374
    {
375
        error (NO_ITEMS2);
376
    }
377
    $profit = 0;
378
    while (!$cost_potion -> EOF)
379
    {
380
        if (ereg("(K)",  $cost_potion -> fields['name']) || ereg("(S)",  $cost_potion -> fields['name']))
381
        {
382
           $name = str_replace(" (S)","", str_replace(" (K)","", $cost_potion -> fields['name']));
383
           $mik2 = $db -> Execute("SELECT `illani`, `illanias`, `nutari`, `dynallca` FROM `alchemy_mill` WHERE `name`='".$name."' AND `owner`=0" );
384
        }
385
        else
386
        {
387
        $mik2 = $db -> Execute("SELECT `illani`, `illanias`, `nutari`, `dynallca` FROM `alchemy_mill` WHERE `name`='".$cost_potion -> fields['name']."' AND `owner`=0" );
388
        }
389
        $profit = $profit + ($mik2 -> fields['illanias']* 6 + $mik2 -> fields['illani']* 4  +$mik2 -> fields['nutari']*8 +$mik2 -> fields['dynallca']*10)* $cost_potion -> fields['amount'];
390
        
391
        $mik2 -> Close();
392
        $cost_potion -> MoveNext();
393
    }
394
    $db -> Execute("DELETE FROM `potions` WHERE `owner`=".$player -> id." AND `status`='K'");
395
    $db -> Execute("UPDATE `players` SET `credits`=`credits`+".$profit." WHERE `id`=".$player -> id);
396
    $smarty -> assign ("Action", YOU_SELL_ALL." ".FOR_A." ".$profit." ".GOLD_COINS.". (<A href=\"equip.php\">".REFRESH."</a>)");
397
    $cost_potion -> Close();
398
399
    
400
}
401
/**
402
* sell all items
403
*/
404
if (isset($_GET['sprzedaj']))
405
{
406
    if ($_GET['sprzedaj'] != 'W')
407
    {
408
        $zysk1 = $db -> Execute("SELECT * FROM `equipment` WHERE `type`='".$_GET['sprzedaj']."' AND `status`='U' AND `owner`=".$player -> id);
409
    }
410
        else
411
    {
412
        $zysk1 = $db -> Execute("SELECT * FROM `equipment` WHERE `type`='W' AND `status`='U' AND `owner`=".$player -> id);
413
        $zysk2 = $db -> Execute("SELECT * FROM `equipment` WHERE `type`='B' AND `status`='U' AND `owner`=".$player -> id);
414
    }
415
    if (!isset($zysk1 -> fields['id']) && !isset($zysk2 -> fields['id']))
416
    {
417
        error (NO_ITEMS2);
418
    }
419
    $arrSell = array('A', 'W', 'H', 'L', 'R', 'C', 'T', 'S', 'I');
420
    $arrType = array(ARMORS, WEAPONS, HELMETS, LEGS2, ARROWS2, CAPES, STAFFS, SHIELDS, RINGS);
421
    $intKey = array_search($_GET['sprzedaj'], $arrSell);
422
    $typ = $arrType[$intKey];
423
    $zysk = 0;
424
    while (!$zysk1 -> EOF)
425
    {
426
        if ($_GET['sprzedaj'] == 'R')
427
        {
428
            $costone = ($zysk1 -> fields['cost'] / 100);
429
            $zysk1 -> fields['cost'] = ceil($costone * $zysk1 -> fields['wt']);
430
            $zysk = $zysk + $zysk1 -> fields['cost'];
431
            $db -> Execute("DELETE FROM equipment WHERE id=".$zysk1 -> fields['id']);
432
        }
433
        if ($zysk1 -> fields['maxwt'] == $zysk1 -> fields['wt'] && $zysk1 -> fields['type'] != 'R')
434
        {
435
            $zysk= $zysk + ($zysk1 -> fields['cost'] * $zysk1 -> fields['amount']);
436
            $db -> Execute("DELETE FROM equipment WHERE id=".$zysk1 -> fields['id']);
437
        }
438
        $zysk1 -> MoveNext();
439
    }
440
    $zysk1 -> Close();
441
    if (isset($zysk2 -> fields['id']))
442
    {
443
        while (!$zysk2 -> EOF)
444
        {
445
            if ($zysk2 -> fields['maxwt'] == $zysk2 -> fields['wt'])
446
            {
447
                $zysk= $zysk + ($zysk2 -> fields['cost'] * $zysk2 -> fields['amount']);
448
                if ($_GET['sprzedaj'] == 'W')
449
                {
450
                    $typ = 'bronie';
451
                }
452
                $db -> Execute("DELETE FROM equipment WHERE id=".$zysk2 -> fields['id']);
453
            }
454
            $zysk2 -> MoveNext();
455
        }
456
        $zysk2 -> Close();
457
    }
458
    $db -> Execute("UPDATE players SET credits=credits+".$zysk." WHERE id=".$player -> id);
459
    $smarty -> assign ("Action", "<br />".YOU_SELL." ".$typ." ".FOR_A." ".$zysk." ".GOLD_COINS.".<br />\n(<a href=\"equip.php\">".REFRESH."</a>)<br />\n");
460
}
461
462
/**
463
 * Repair used items
464
 */
465
if (isset($_GET['napraw_uzywane']))
466
{
467
    $rzecz_wiersz = $db -> Execute("SELECT * FROM equipment WHERE owner = ".$player -> id." AND status = 'E' AND type != 'R' AND type != 'T' AND type != 'C' AND `type`!='I'");
468
    $text = '';
469
    while(!$rzecz_wiersz -> EOF)
470
    {
471
        if ($rzecz_wiersz -> fields['maxwt'] != $rzecz_wiersz -> fields['wt'])
472
        {
473
            if ($rzecz_wiersz -> fields['repair'] > $player -> credits)
474
            {
475
                error (NO_MONEY);
476
            }
477
            $player -> credits = $player -> credits - $rzecz_wiersz -> fields['repair'];
478
            $db -> Execute("UPDATE equipment SET wt=".$rzecz_wiersz -> fields['maxwt']." WHERE id=".$rzecz_wiersz -> fields['id']);
479
            $db -> Execute("UPDATE players SET credits=credits-".$rzecz_wiersz -> fields['repair']." WHERE id=".$player -> id);
480
            $text = $text."<br />".YOU_REPAIR." ".$rzecz_wiersz -> fields['name']." ".AND_COST." ".$rzecz_wiersz -> fields['repair']." ".GOLD_COINS.".<br />";
481
        }
482
        $rzecz_wiersz -> MoveNext();
483
    }
484
    $rzecz_wiersz -> Close();
485
    $smarty -> assign ("Action", $text);
486
}
487
488
/**
489
 * Repair items in backpack
490
 */
491
if (isset($_GET['napraw']))
492
{
493
    if (!ereg("^[1-9][0-9]*$", $_GET['napraw']))
494
    {
495
        error (ERROR);
496
    }
497
    $rzecz = $db -> Execute("SELECT * FROM `equipment` WHERE `id`=".$_GET['napraw']);
498
    if ($rzecz -> fields['wt'] == $rzecz -> fields['maxwt'])
499
    {
500
        error (NO_REPAIR);
501
    }
502
    if (!$rzecz -> fields['id'])
503
    {
504
        error (NO_ITEM);
505
    }
506
    if ($player -> credits < $rzecz -> fields['repair'])
507
    {
508
        error (NO_MONEY);
509
    }
510
    if ($player -> id != $rzecz -> fields['owner'])
511
    {
512
        error (NOT_YOUR);
513
    }
514
    if ($rzecz -> fields['type'] == 'R' || $rzecz -> fields['type'] == 'I')
515
    {
516
        error(E_REPAIR);
517
    }
518
    //equiped item - just set wt to maxwt
519
    if ($rzecz -> fields['status'] == 'E')
520
    {
521
        $db -> Execute("UPDATE `equipment` SET `wt`=`maxwt` WHERE `id`=".($rzecz -> fields['id']));
522
    }
523
    //non-equiped item - checking and changing amount of items before and after repair
524
    else
525
    {
526
        $test = $db -> Execute("SELECT `id` FROM `equipment` WHERE `name`='".$rzecz -> fields['name']."' AND `wt`=".$rzecz -> fields['maxwt']." AND `type`='".$rzecz -> fields['type']."' AND `status`='U' AND `owner`=".$player -> id." AND `power`=".$rzecz -> fields['power']." AND `zr`=".$rzecz -> fields['zr']." AND `szyb`=".$rzecz -> fields['szyb']." AND `maxwt`=".$rzecz -> fields['maxwt']." AND `poison`=".$rzecz -> fields['poison']." AND `ptype`='".$rzecz -> fields['ptype']."' AND `cost`=".$rzecz -> fields['cost']." AND `repair`=".$rzecz -> fields['repair']) or die($db -> ErrorMsg());
527
        if (!$test -> fields['id'])
528
        {
529
            $db -> Execute("INSERT INTO equipment (`owner`, `name`, `power`, `type`, `cost`, `zr`, `wt`, `minlev`, `maxwt`, `amount`, `magic`, `poison`, `szyb`, `ptype`, `repair`, `twohand`) VALUES(".$player -> id.",'".$rzecz -> fields['name']."',".$rzecz -> fields['power'].",'".$rzecz -> fields['type']."',".$rzecz -> fields['cost'].",".$rzecz -> fields['zr'].",".$rzecz -> fields['maxwt'].",".$rzecz -> fields['minlev'].",".$rzecz -> fields['maxwt'].",1,'".$rzecz -> fields['magic']."',".$rzecz -> fields['poison'].",".$rzecz -> fields['szyb'].", '".$rzecz -> fields['ptype']."', ".$rzecz -> fields['repair'].", '".$rzecz -> fields['twohand']."')") or error($db -> ErrorMsg());
530
        }
531
            else
532
        {
533
            $db -> Execute("UPDATE `equipment` SET `amount`=`amount`+1 WHERE `id`=".$test -> fields['id']);
534
        }
535
        $test -> Close();
536
        if ($rzecz -> fields['amount'] > 1)
537
        {
538
            $db -> Execute("UPDATE `equipment` SET `amount`=`amount`-1 WHERE `id`=".$_GET['napraw']);
539
        }
540
            else
541
        {
542
        $db -> Execute("DELETE FROM `equipment` WHERE `id`=".$_GET['napraw']);
543
        }
544
    }
545
    $db -> Execute("UPDATE `players` SET `credits`=`credits`-".$rzecz -> fields['repair']." WHERE `id`=".$player -> id);
546
    $smarty -> assign ("Action", "<br />".YOU_REPAIR." <b>".$rzecz -> fields['name']."</b> ".FOR_A." <b>".$rzecz -> fields['repair']."</b> ".GOLD_COINS.".<br />\n(<a href=\"equip.php\">".REFRESH."</a>)<br />\n");
547
    $rzecz -> Close();
548
}
549
550
/**
551
* Poison weapon
552
*/
553
if (isset ($_GET['poison']))
554
{
555
    if (!ereg("^[1-9][0-9]*$", $_GET['poison']))
556
    {
557
        error (ERROR);
558
    }
559
    $poison = $db -> Execute("SELECT id, power, amount, name FROM potions WHERE id=".$_GET['poison']." AND type='P' AND owner=".$player -> id);
560
    if (!$poison -> fields['id'])
561
    {
562
        error (NO_POTION);
563
    }
564
    $wep = $db -> Execute("SELECT `id`, `name`, `amount` FROM `equipment` WHERE `owner`=".$player -> id." AND (`type`='W' OR `type`='R') AND `status`='U' AND `poison`=0");
565
    $arrname = array();
566
    $arrid = array();
567
    $arramount = array();
568
    $i = 0;
569
    while (!$wep -> EOF)
570
    {
571
        $arrname[$i] = $wep -> fields['name'];
572
        $arrid[$i] = $wep -> fields['id'];
573
        $arramount[$i] = $wep -> fields['amount'];
574
        $i = $i + 1;
575
        $wep -> MoveNext();
576
    }
577
    $wep -> Close();
578
    $smarty -> assign ( array("Poisonitem" => $arrname,
579
        "Poisonid" => $arrid,
580
        "Poisonamount" => $arramount,
581
        "Poisonit" => POISON_IT,
582
        "Tamount" => AMOUNT));
583
    if (isset($_GET['step']) && $_GET['step'] == 'poison')
584
    {
585
        if (!isset($_POST['weapon']) || !ereg("^[1-9][0-9]*$", $_POST['weapon']))
586
        {
587
            error (ERROR);
588
        }
589
        $item = $db -> Execute("SELECT * FROM equipment WHERE id=".$_POST['weapon']);
590
        if (!$item -> fields['id'])
591
        {
592
            error (NO_ITEMS);
593
        }
594
        if ($item -> fields['type'] != 'W' && $item -> fields['type'] != 'R')
595
        {
596
            error (NO_WEAPON);
597
        }
598
        if ($item -> fields['owner'] != $player -> id)
599
        {
600
            error (NOT_YOUR);
601
        }
602
        if ($item -> fields['status'] != 'U')
603
        {
604
            error (NOT_IN);
605
        }
606
        if (ereg("(K)", $poison -> fields['name']))
607
        {
608
            $intRoll = rand(0,100);
609
            if ($intRoll == 1)
610
            {
611
                $amount = $item -> fields['amount'] - 1;
612
                if ($amount < 1)
613
                {
614
                    $db -> Execute("DELETE FROM equipment WHERE id=".$item -> fields['id']);
615
                }
616
                    else
617
                {
618
                    $db -> Execute("UPDATE equipment SET amount=".$amount." WHERE id=".$item -> fields['id']);
619
                }
620
                $amount = $poison -> fields['amount'] - 1;
621
                if ($amount < 1)
622
                {
623
                    $db -> Execute("DELETE FROM potions WHERE id=".$poison -> fields['id']);
624
                }
625
                    else
626
                {
627
                    $db -> Execute("UPDATE potions SET amount=".$amount." WHERE id=".$poison -> fields['id']);
628
                }
629
                error(YOU_DESTROY);
630
            }
631
        }
632
            else
633
        {
634
            $intRoll = 51;
635
        }
636
        if ($intRoll > 50)
637
        {
638
            $name = POISONED." ".$item -> fields['name'];
639
            $intPower = $poison -> fields['power'];
640
            if ($intPower > (7 * $item -> fields['minlev']))
641
            {
642
                $intPower = 7 * $item -> fields['minlev'];
643
            }
644
            if ($item -> fields['type'] == 'R')
645
            {
646
                $intPower = floor($intPower / 4);
647
            }
648
            if ($intPower < 1)
649
            {
650
                $intPower = 1;
651
            }
652
            if (ereg("Dynallca",$poison -> fields['name']))
653
            {
654
                $strPtype = 'D';
655
            }
656
            elseif (ereg("Nutari",$poison -> fields['name']))
657
            {
658
                $strPtype = 'N';
659
            }
660
            elseif (ereg("Illani",$poison -> fields['name']))
661
            {
662
                $strPtype = 'I';
663
            }
664
665
            if ($item -> fields['type'] == 'W')
666
            {
667
                $test = $db -> Execute("SELECT `id` FROM `equipment` WHERE `name`='".$name."' AND `wt`=".$item -> fields['wt']." AND `type`='W' AND `status`='U' AND `owner`=".$player -> id." AND `power`=".$item -> fields['power']." AND `zr`=".$item -> fields['zr']." AND `szyb`=".$item -> fields['szyb']." AND `maxwt`=".$item -> fields['maxwt']." AND `poison`=".$intPower." AND `ptype`='".$strPtype."'");
668
                if (!$test -> fields['id'] )
669
                {
670
                    $db -> Execute("INSERT INTO `equipment` (`owner`, `name`, `power`, `type`, `cost`, `zr`, `wt`, `minlev`, `maxwt`, `amount`, `magic`, `poison`, `szyb`, `ptype`, `repair`, `twohand`) VALUES(".$player -> id.",'".$name."',".$item -> fields['power'].",'W',".$item -> fields['cost'].",".$item -> fields['zr'].",".$item -> fields['wt'].",".$item -> fields['minlev'].",".$item -> fields['maxwt'].",1,'N',".$intPower.",".$item -> fields['szyb'].", '".$strPtype."', ".$item -> fields['repair'].", '".$item -> fields['repair']."')") or error($db -> ErrorMsg());
671
                }
672
                else
673
                {
674
                    $db -> Execute("UPDATE `equipment` SET `amount`=`amount`+1 WHERE `id`=".$test -> fields['id']);
675
                }
676
                $test -> Close();
677
                if ($item -> fields['amount'] > 1)
678
                {
679
                    $db -> Execute("UPDATE `equipment` SET `amount`=`amount`-1 WHERE `id`=".$item -> fields['id']);
680
                }
681
                    else
682
                {
683
                    $db -> Execute("DELETE FROM `equipment` WHERE `id`=".$item -> fields['id']);
684
                }
685
686
            }
687
            else
688
            {
689
                if ($item -> fields['wt'] <= 35)
690
                {
691
                    $test = $db -> Execute("SELECT id, wt FROM equipment WHERE name='".$name."' AND type='R' AND status='U' AND owner=".$player -> id." AND power=".$item -> fields['power']." AND poison=".$intPower." AND ptype='".$strPtype."'");
692
                    if (!$test -> fields['id'] )
693
                    {
694
                        $db -> Execute("INSERT INTO `equipment` (`owner`, `name`, `power`, `type`, `cost`, `zr`, `wt`, `minlev`, `maxwt`, `amount`, `magic`, `poison`, `szyb`, `ptype`, `repair`, `twohand`) VALUES(".$player -> id.",'".$name."',".$item -> fields['power'].",'R',".$item -> fields['cost'].",".$item -> fields['zr'].",".$item -> fields['wt'].",".$item -> fields['minlev'].",".$item -> fields['maxwt'].",1,'N',".$intPower.",".$item -> fields['szyb'].", '".$strPtype."', ".$item -> fields['repair'].", '".$item -> fields['repair']."')") or error($db -> ErrorMsg());
695
                    }
696
                    else
697
                    {
698
                        $newwt=($test -> fields['wt'] + $item -> fields['wt']);
699
                        $db -> Execute("UPDATE equipment SET wt=".$newwt." , maxwt=".$newwt." WHERE id=".$test -> fields['id']);
700
                    }
701
                    $iamount = $item -> fields['amount'] - 1;
702
                    $db -> Execute("DELETE FROM equipment WHERE id=".$item -> fields['id']);
703
                }
704
                else
705
                {
706
                    $test = $db -> Execute("SELECT id, wt FROM equipment WHERE name='".$name."' AND type='R' AND status='U' AND owner=".$player -> id." AND power=".$item -> fields['power']." AND poison=".$intPower." AND ptype='".$strPtype."'");
707
                    if (!$test -> fields['id'] )
708
                    {
709
                        $db -> Execute("INSERT INTO `equipment` (`owner`, `name`, `power`, `type`, `cost`, `zr`, `wt`, `minlev`, `maxwt`, `amount`, `magic`, `poison`, `szyb`, `ptype`, `repair`, `twohand`) VALUES(".$player -> id.",'".$name."',".$item -> fields['power'].",'R',".$item -> fields['cost'].",".$item -> fields['zr'].",
710
                        35 ,".$item -> fields['minlev'].", 35 ,1,'N',".$intPower.",".$item -> fields['szyb'].", '".$strPtype."', ".$item -> fields['repair'].", '".$item -> fields['repair']."')") or error($db -> ErrorMsg());
711
                    }
712
                    else
713
                    {
714
                        $newwt=($test -> fields['wt'] + 35);
715
                        $db -> Execute("UPDATE equipment SET wt=".$newwt." , maxwt=".$newwt." WHERE id=".$test -> fields['id']);
716
                    }
717
                    $db -> Execute("UPDATE equipment SET wt=wt-35, maxwt=maxwt-35 WHERE id=".$item -> fields['id']);
718
                }
719
                $test -> Close();
720
            }
721
722
723
            $smarty -> assign ("Item", YOU_POISON." ".$item -> fields['name'].". <a href=\"equip.php\">".REFRESH."</a>");
724
        }
725
            else
726
        {
727
            $smarty -> assign ("Item", YOU_POISON2." ".$item -> fields['name']." ".BUT_NOT.". <a href=\"equip.php\">".REFRESH."</a>");
728
        }
729
        $amount = $poison -> fields['amount'] - 1;
730
        if ($amount < 1)
731
        {
732
            $db -> Execute("DELETE FROM potions WHERE id=".$poison -> fields['id']);
733
        }
734
            else
735
        {
736
            $db -> Execute("UPDATE potions SET amount=".$amount." WHERE id=".$poison -> fields['id']);
737
        }
738
        $item -> Close();
739
    }
740
    $poison -> Close();
741
}
742
743
/**
744
* Fill equiped arrows
745
*/
746
if (isset($_GET['fill']))
747
{
748
    if (!ereg("^[1-9][0-9]*$", $_GET['fill']))
749
    {
750
        error (ERROR);
751
    }
752
    $objArrows = $db -> Execute("SELECT wt, name, power, id FROM equipment WHERE id=".$_GET['fill']);
753
    if (!$objArrows -> fields['id'])
754
    {
755
        error(NO_ITEMS);
756
    }
757
    if ($objArrows -> fields['wt'] == 35)
758
    {
759
        error(NOT_NEED);
760
    }
761
    $objArrows2 = $db -> Execute("SELECT wt, id FROM equipment WHERE name='".$objArrows -> fields['name']."' AND power=".$objArrows -> fields['power']." AND status='U' AND owner=".$player -> id);
762
    if (!$objArrows2 -> fields['id'])
763
    {
764
        error(NO_ARROWS);
765
    }
766
    $intAmount = 35 - $objArrows -> fields['wt'];
767
    if ($objArrows2 -> fields['wt'] <= $intAmount)
768
    {
769
        $db -> Execute("DELETE FROM equipment WHERE id=".$objArrows2 -> fields['id']);
770
        $intFill = $objArrows2 -> fields['wt'];
771
    }
772
        else
773
    {
774
        $db -> Execute("UPDATE equipment SET wt=wt-".$intAmount." WHERE id=".$objArrows2 -> fields['id']);
775
        $intFill = $intAmount;
776
    }
777
    $objArrows2 -> Close();
778
    $db -> Execute("UPDATE equipment SET wt=wt+".$intFill." WHERE id=".$objArrows -> fields['id']);
779
    $objArrows -> Close();
780
    $smarty -> assign("Hide", "Uzupełniłeś kołczan");
781
}
782
783
/**
784
* Wear equipment
785
*/
786
if (isset($_GET['equip']))
787
{
788
    equip($_GET['equip']);
789
}
790
791
/**
792
* Drink potion
793
*/
794
if (isset($_GET['wypij']))
795
{
796
    drink($_GET['wypij']);
797
}
798
799
/**
800
* Drink potions
801
*/
802
if (isset($_GET['wypijwiele'])) 
803
{       
804
        integercheck($_POST['ile']);
805
        $potion = $db -> Execute("SELECT amount FROM potions WHERE id=".$_POST['potion']);
806
        if ($potion -> fields['amount'] < $_POST['ile']) 
807
        {
808
            error ("Nie masz tylu mikstur!");
809
        }       
810
        if (!isset($_POST['ile'])) 
811
        {
812
            error("Podaj ile mikstur!");
813
        }
814
        if (!ereg("^[1-9][0-9]*$", $_POST['ile'])) 
815
        {
816
            error("Zapomnij o tym!");
817
        }           
818
        $i=0;
819
        while ($i<$_POST['ile'])
820
        {
821
        drink($_POST['potion']);
822
        $i++;
823
        }
824
}
825
826
827
$arrEquip = $player -> equipment();
828
if ($player -> clas != 'Mag')
829
{
830
    if (!$arrEquip[0][0])
831
    {
832
        $arrEquip[0] = $arrEquip[1];
833
    }
834
    if ($arrEquip[0][0])
835
    {
836
        $strWarn = ($arrEquip[0][6] < 11) ? '<blink>' : '';
837
        $strWarn1 =($arrEquip[0][6] < 11) ? '</blink>' : '';
838
        $smarty -> assign ("Weapon", $strWarn."<b>".WEAPON.":</b> ".$arrEquip[0][1]." (+".$arrEquip[0][2].") ".showpoisoned($arrEquip[0][8], $arrEquip[0][3])."(+".$arrEquip[0][7]." ".EQUIP_SPEED.") (".$arrEquip[0][6]."/".$arrEquip[0][9]." ".DURABILITY.")".$strWarn1." [<a href=\"equip.php?schowaj=".$arrEquip[0][0]."\">".HIDE_WEP."</a>][<a href=\"equip.php?napraw=".$arrEquip[0][0]."\">".A_REPAIR."</a>]<br />\n");
839
    }
840
        else
841
    {
842
        $smarty -> assign ("Weapon", "<b>".WEAPON.":</b> ".EMPTY_SLOT."<br />\n");
843
    }
844
}
845
    else
846
{
847
    if (!$arrEquip[0][0])
848
    {
849
        $arrEquip[0] = $arrEquip[1];
850
    }
851
    if ($arrEquip[0][0])
852
    {
853
        $strWarn = ($arrEquip[0][6] < 11) ? '<blink>' : '';
854
        $strWarn1 =($arrEquip[0][6] < 11) ? '</blink>' : '';
855
        $smarty -> assign ("Weapon", $strWarn."<b>".WEAPON.":</b> ".$arrEquip[0][1]." (+".$arrEquip[0][2].") ".(showpoisoned($arrEquip[0][8], $arrEquip[0][3]))." (+".$arrEquip[0][7]." ".EQUIP_SPEED.") (".$arrEquip[0][6]."/".$arrEquip[0][9]." ".DURABILITY.")".$strWarn1." [<a href=\"equip.php?schowaj=".$arrEquip[0][0]."\">".HIDE_WEP."</a>][<a href=\"equip.php?napraw=".$arrEquip[0][0]."\">".A_REPAIR."</a>]<br />\n");
856
    }
857
        else
858
    {
859
        if ($arrEquip[7][0])
860
        {
861
            $smarty -> assign ("Weapon", "<b>".STAFF.":</b> ".$arrEquip[7][1]." (".SPELL_POWER.") [<a href=\"equip.php?schowaj=".$arrEquip[7][0]."\">".HIDE."</a>]<br />\n");
862
        }
863
            else
864
        {
865
            $smarty -> assign ("Weapon", "<b>".WEAPON.":</b> ".EMPTY_SLOT."<br />\n");
866
        }
867
    }
868
}
869
870
if ($arrEquip[1][0])
871
{
872
    if ($arrEquip[6][0])
873
    {
874
        $strWarn = ($arrEquip[6][6] < 11) ? '<blink>' : '';
875
        $strWarn1 =($arrEquip[6][6] < 11) ? '</blink>' : '';
876
        $smarty -> assign ("Arrows", $strWarn."<b>".QUIVER.":</b> ".$arrEquip[6][1]." (+".$arrEquip[6][2].") ".showpoisoned($arrEquip[6][8], $arrEquip[6][3])." (".$arrEquip[6][6]." ".ARROWS.")".$strWarn1." [<a href=\"equip.php?schowaj=".$arrEquip[6][0]."\">".HIDE_ARR."</a>] [<a href=\"equip.php?fill=".$arrEquip[6][0]."\">".A_FILL."</a>]<br />\n");
877
    }
878
        else
879
    {
880
        $smarty -> assign ("Arrows", "<b>".QUIVER.":</b> ".EMPTY_SLOT."<br />\n");
881
    }
882
}
883
    else
884
{
885
    $smarty -> assign ("Arrows", "");
886
}
887
888
if ($arrEquip[2][0])
889
{
890
    $strWarn = ($arrEquip[2][6] < 11) ? '<blink>' : '';
891
    $strWarn1 =($arrEquip[2][6] < 11) ? '</blink>' : '';
892
    $smarty -> assign ("Helmet", $strWarn."<b>".HELMET.":</b> ".$arrEquip[2][1]." (+".$arrEquip[2][2].") (".$arrEquip[2][6]."/".$arrEquip[2][9]." ".DURABILITY.")".$strWarn1." [<a href=\"equip.php?schowaj=".$arrEquip[2][0]."\">".WEAR_OFF."</a>][<a href=\"equip.php?napraw=".$arrEquip[2][0]."\">".A_REPAIR."</a>]<br />\n");
893
}
894
    else
895
{
896
    $smarty -> assign ("Helmet", "<b>".HELMET.":</b> ".EMPTY_SLOT."<br />\n");
897
}
898
899
if ($player -> clas != 'Mag')
900
{
901
    if ($arrEquip[3][0])
902
    {
903
        $agility = '';
904
        if ($arrEquip[3][5] < 0)
905
        {
906
            $arrEquip[3][5] = str_replace("-","",$arrEquip[3][5]);
907
            $agility = "(+".$arrEquip[3][5]." ".EQUIP_AGI.")";
908
        }
909
            elseif ($arrEquip[3][5] > 0)
910
        {
911
            $agility = "(-".$arrEquip[3][5]." ".EQUIP_AGI.")";
912
        }
913
        $strWarn = ($arrEquip[3][6] < 11) ? '<blink>' : '';
914
        $strWarn1 =($arrEquip[3][6] < 11) ? '</blink>' : '';
915
        $smarty -> assign ("Armor", $strWarn."<b>".ARMOR.":</b> ".$arrEquip[3][1]." (+".$arrEquip[3][2].") ".$agility." (".$arrEquip[3][6]."/".$arrEquip[3][9]." ".DURABILITY.")".$strWarn1." [<a href=\"equip.php?schowaj=".$arrEquip[3][0]."\">".WEAR_OFF."</a>][<a href=\"equip.php?napraw=".$arrEquip[3][0]."\">".A_REPAIR."</a>]<br />\n");
916
    }
917
        else
918
    {
919
        $smarty -> assign ("Armor", "<b>".ARMOR.":</b> ".EMPTY_SLOT."<br />\n");
920
    }
921
}
922
    else
923
{
924
    if ($arrEquip[3][0])
925
    {
926
        $agility = '';
927
        if ($arrEquip[3][5] < 0)
928
        {
929
            $arrEquip[3][5] = str_replace("-","",$arrEquip[3][5]);
930
            $agility = "(+".$arrEquip[3][5]." ".EQUIP_AGI.")";
931
        }
932
            elseif ($arrEquip[3][5] > 0)
933
        {
934
            $agility = "(-".$arrEquip[3][5]." ".EQUIP_AGI.")";
935
        }
936
        $strWarn = ($arrEquip[3][6] < 11) ? '<blink>' : '';
937
        $strWarn1 =($arrEquip[3][6] < 11) ? '</blink>' : '';
938
        $smarty -> assign ("Armor", $strWarn."<b>".ARMOR.":</b> ".$arrEquip[3][1]." (+".$arrEquip[3][2].") ".$agility." (".$arrEquip[3][6]."/".$arrEquip[3][9]." ".DURABILITY.")".$strWarn1." [<a href=\"equip.php?schowaj=".$arrEquip[3][0]."\">".WEAR_OFF."</a>][<a href=\"equip.php?napraw=".$arrEquip[3][0]."\">".A_REPAIR."</a>]<br />\n");
939
    }
940
        else
941
    {
942
        if ($arrEquip[8][0])
943
        {
944
            $smarty -> assign ("Armor", "<b>".CAPE.":</b> ".$arrEquip[8][1]." (+".$arrEquip[8][2]." % ".EQUIP_MANA.") [<a href=\"equip.php?schowaj=".$arrEquip[8][0]."\">".WEAR_OFF."</a>][<a href=\"equip.php?napraw=".$arrEquip[8][0]."\">".A_REPAIR."</a>]<br />\n");
945
        }
946
            else
947
        {
948
            $smarty -> assign ("Armor", "<b>".ARMOR.":</b> ".EMPTY_SLOT."<br />\n");
949
        }
950
    }
951
}
952
953
if ($arrEquip[5][0])
954
{
955
    if ($arrEquip[5][5] < 0)
956
    {
957
        $arrEquip[5][5] = str_replace("-","",$arrEquip[5][5]);
958
        $agility1 = "(+".$arrEquip[5][5]." ".EQUIP_AGI.")";
959
    }
960
        elseif ($arrEquip[5][5] > 0)
961
    {
962
        $agility1 = "(-".$arrEquip[5][5]." ".EQUIP_AGI.")";
963
    }
964
        else
965
    {
966
        $agility1 = '';
967
    }
968
    $strWarn = ($arrEquip[5][6] < 11) ? '<blink>' : '';
969
    $strWarn1 =($arrEquip[5][6] < 11) ? '</blink>' : '';
970
    $smarty -> assign ("Shield", $strWarn."<b>".SHIELD.":</b> ".$arrEquip[5][1]." (+".$arrEquip[5][2].") ".$agility1." (".$arrEquip[5][6]."/".$arrEquip[5][9]." ".DURABILITY.")".$strWarn1." [<a href=\"equip.php?schowaj=".$arrEquip[5][0]."\">".WEAR_OFF."</a>][<a href=\"equip.php?napraw=".$arrEquip[5][0]."\">".A_REPAIR."</a>]<br />\n");
971
}
972
    else
973
{
974
    $smarty -> assign ("Shield", "<b>".SHIELD.":</b> ".EMPTY_SLOT."<br />\n");
975
}
976
977
if ($arrEquip[4][0])
978
{
979
    if ($arrEquip[4][5] < 0)
980
    {
981
        $arrEquip[4][5] = str_replace("-","",$arrEquip[4][5]);
982
        $agility2 = "(+".$arrEquip[4][5]." ".EQUIP_AGI.")";
983
    }
984
        elseif ($arrEquip[4][5] > 0)
985
    {
986
        $agility2 = "(-".$arrEquip[4][5]." ".EQUIP_AGI.")";
987
    }
988
        else
989
    {
990
        $agility2 = '';
991
    }
992
    $strWarn = ($arrEquip[4][6] < 11) ? '<blink>' : '';
993
    $strWarn1 =($arrEquip[4][6] < 11) ? '</blink>' : '';
994
    $smarty -> assign ("Legs", $strWarn."<b>".LEGS.":</b> ".$arrEquip[4][1]." (+".$arrEquip[4][2].") ".$agility2." (".$arrEquip[4][6]."/".$arrEquip[4][9]." ".DURABILITY.")".$strWarn1." [<a href=\"equip.php?schowaj=".$arrEquip[4][0]."\">".WEAR_OFF."</a>][<a href=\"equip.php?napraw=".$arrEquip[4][0]."\">".A_REPAIR."</a>]<br />\n");
995
}
996
    else
997
{
998
    $smarty -> assign ("Legs", "<b>".LEGS.":</b> ".EMPTY_SLOT."<br />\n");
999
}
1000
1001
/**
1002
 * Weared rings
1003
 */
1004
if ($arrEquip[9][0])
1005
{
1006
  $smarty -> assign("Ring1", "<b>".RING.":</b> ".$arrEquip[9][1]." (+".$arrEquip[9][2].") [<a href=\"equip.php?schowaj=".$arrEquip[9][0]."\">".WEAR_OFF."</a>]<br />\n");
1007
}
1008
    else
1009
{
1010
    $smarty -> assign("Ring1", "<b>".RING.":</b> ".EMPTY_SLOT."<br />\n");
1011
}
1012
if ($arrEquip[10][0])
1013
{
1014
  $smarty -> assign("Ring2", "<b>".RING.":</b> ".$arrEquip[10][1]." (+".$arrEquip[10][2].") [<a href=\"equip.php?schowaj=".$arrEquip[10][0]."\">".WEAR_OFF."</a>]<br />\n");
1015
}
1016
    else
1017
{
1018
    $smarty -> assign("Ring2", "<b>".RING.":</b> ".EMPTY_SLOT."<br />\n");
1019
}
1020
1021
1022
if ($arrEquip[3][0] || $arrEquip[0][0] || $arrEquip[4][0] || $arrEquip[2][0] || $arrEquip[5][0])
1023
{
1024
    $smarty -> assign ("Repairequip", "[<a href=\"equip.php?napraw_uzywane\">".A_REPAIR2."</a>]<br />\n");
1025
}
1026
1027
backpack('W',$player -> id,WEAPONS,'B','Bweapons');
1028
backpack('T',$player -> id,STAFFS,'','Bstaffs');
1029
1030
$arr = $db -> Execute("SELECT * FROM equipment WHERE owner=".$player -> id." AND type='R' AND status='U'");
1031
$posiada = false;
1032
$arrname = array();
1033
$arrpower = array();
1034
$arrdur = array();
1035
$arrid = array();
1036
$arrcost = array();
1037
$arrpoisontext = array();
1038
$i = 0;
1039
while (!$arr -> EOF)
1040
{
1041
    if(!$posiada)
1042
    {
1043
        $smarty -> assign (array("Arrows1" => "<br /><u>".BACK_QUIVER."</u>:<br />\n",
1044
                                 "Awear" => A_WEAR,
1045
                                 "Fora" => FOR_A,
1046
                                 "Goldcoins" => GOLD_COINS,
1047
                                 "Sellall" => SELL_ALL_ARR));
1048
    }
1049
    $posiada = true;
1050
    $costone = $arr -> fields['cost'] / 100;
1051
    $arrname[$i] = $arr -> fields['name'];
1052
    $arrpower[$i] = $arr -> fields['power'];
1053
    $arrdur[$i] = $arr -> fields['wt'] * $arr -> fields['amount'];
1054
    $arrid[$i] = $arr -> fields['id'];
1055
    $arrcost[$i] = ceil($costone * $arr -> fields['wt']);
1056
    $arrpoisontext[$i] = showpoisoned( $arr -> fields['poison'], $arr -> fields['ptype']);
1057
    $arr -> MoveNext();
1058
    $i++;
1059
}
1060
$arr -> Close();
1061
$smarty -> assign(array("Barrows" => $arrname,
1062
                        "Barrpower" => $arrpower,
1063
                        "Barramount" => $arrdur,
1064
                        "Barrid" => $arrid,
1065
                        "Barrcost" => $arrcost,
1066
                        "Barrpoison" => $arrpoisontext,
1067
                        "Potions1" => '',
1068
                        "Rings1" => ''));
1069
1070
backpack('H',$player -> id,HELMETS,'','Bhelmets');
1071
backpack('A',$player -> id,ARMORS,'','Barmors');
1072
backpack('S',$player -> id,SHIELDS,'','Bshields');
1073
backpack('C',$player -> id,CAPES,'','Bcapes');
1074
backpack('L',$player -> id,LEGS2,'','Blegs');
1075
1076
/**
1077
 * Unused rings
1078
 */
1079
$arrRings = $db -> Execute("SELECT `id`, `name`, `power`, `cost`, `amount` FROM `equipment` WHERE `owner`=".$player -> id." AND `type`='I' AND `status`='U'");
1080
$posiada = false;
1081
$arrName = array();
1082
$arrPower = array();
1083
$arrId = array();
1084
$arrCost = array();
1085
$arrAmount = array();
1086
$i = 0;
1087
while (!$arrRings -> EOF)
1088
{
1089
    if(!$posiada)
1090
    {
1091
        $smarty -> assign (array("Rings1" => "<br /><u>".BACK_RINGS."</u>:<br />\n",
1092
                                 "Awear" => A_WEAR,
1093
                                 "Fora" => FOR_A,
1094
                                 "Goldcoins" => GOLD_COINS,
1095
                                 "Sellallrings" => SELL_ALL_RINGS,
1096
                                 "Amount" => AMOUNT));
1097
    }
1098
    $posiada = true;
1099
    $arrName[$i] = $arrRings -> fields['name'];
1100
    $arrPower[$i] = $arrRings -> fields['power'];
1101
    $arrId[$i] = $arrRings -> fields['id'];
1102
    $arrCost[$i] = $arrRings -> fields['cost'];
1103
    $arrAmount[$i] = $arrRings -> fields['amount'];
1104
    $arrRings -> MoveNext();
1105
    $i++;
1106
}
1107
$arrRings -> Close();
1108
$smarty -> assign(array("Brings" => $arrName,
1109
                        "Bringpower" => $arrPower,
1110
                        "Bringid" => $arrId,
1111
                        "Bringcost" => $arrCost,
1112
                        "Bringamount" => $arrAmount));
1113
1114
$mik = $db -> Execute("SELECT * FROM `potions` WHERE `owner`=".$player -> id." AND `status`='K'");
1115
if ($mik -> fields['id'])
1116
{
1117
    $arrname = array();
1118
    $arramount = array();
1119
    $arreffect = array();
1120
    $arrpower = array();
1121
    $arraction = array();
1122
    $arrsellpotion = array();
1123
    $i = 0;
1124
    while (!$mik -> EOF)
1125
    {
1126
        $arrname[$i] = $mik -> fields['name'];
1127
        $arramount[$i] = $mik -> fields['amount'];
1128
        $arreffect[$i] = $mik -> fields['efect'];
1129
        if (ereg("(K)",  $mik -> fields['name']) || ereg("(S)",  $mik -> fields['name']))
1130
        {
1131
        	$arrname1[$i] = str_replace(" (S)","", str_replace(" (K)","", $arrname[$i]));
1132
        	$mik2 = $db -> Execute("SELECT `illani`, `illanias`, `nutari`, `dynallca` FROM `alchemy_mill` WHERE `name`='".$arrname1[$i]."' AND `owner`=0" );
1133
        }
1134
        else
1135
        {
1136
        	$mik2 = $db -> Execute("SELECT `illani`, `illanias`, `nutari`, `dynallca` FROM `alchemy_mill` WHERE `name`='".$arrname[$i]."' AND `owner`=0" );
1137
        }
1138
        $arrsellpotion[$i] = $mik2 -> fields['illanias']*6 + $mik2 -> fields['illani']*4 +$mik2 -> fields['nutari']*8 + $mik2 -> fields['dynallca']*10;
1139
        $arraction[$i] = "[<a href=\"equip.php?wypij=".$mik -> fields['id']."\">".A_DRINK."</a>  | <a href=\"equip.php?sell_potion=".$mik -> fields['id']."\">".A_SELL."</a> ".N_FOR.$arrsellpotion[$i]." ".GOLD_COINS."]";
1140
        $mik2 -> Close();
1141
        if ($mik -> fields['type'] != 'A')
1142
        {
1143
            $arrpower[$i] = "(".POWER.": ".$mik -> fields['power'].")";
1144
            if ($mik -> fields['type'] == 'P')
1145
            {
1146
                $arraction[$i] = "[<a href=\"equip.php?poison=".$mik -> fields['id']."\">".A_POISON."</a>] | <a href=\"equip.php?sell_potion=".$mik -> fields['id']."\">".A_SELL."</a> ".N_FOR.$arrsellpotion[$i]." ".GOLD_COINS."]";
1147
            }
1148
        }
1149
            else
1150
        {
1151
            $arrpower[$i] = '';
1152
        }
1153
        $mik -> MoveNext();
1154
        $i = $i + 1;
1155
    }
1156
    $sell_allpotion = "(<a href=\"equip.php?sell_allpotion\">".SELL_ALL_POTIONS."</a>)";
1157
    $smarty -> assign ( array("Pname1" => $arrname,
1158
                              "Pamount1" => $arramount,
1159
                              "Peffect1" => $arreffect,
1160
                              "Potionid1" => $arrid,
1161
                              "Paction1" => $arraction,
1162
                              "Ppower1" => $arrpower,
1163
                              "Potions1" => 1,
1164
                              "Potions2" => POTIONS,
1165
                              "Amount" => AMOUNT,
1166
                              "Asellall" => $sell_allpotion));
1167
}
1168
$mik -> Close();
1169
1170
$mik2 = $db -> Execute("SELECT * FROM potions WHERE owner=".$player -> id." AND status='K' AND type!='A' AND type!='P'");
1171
if ($mik2 -> fields['id']) 
1172
{
1173
    $arrname = array();
1174
    $arramount = array();
1175
    $arreffect = array();
1176
    $arrpower = array();
1177
    $arrid = array();
1178
    $i = 0;
1179
    while (!$mik2 -> EOF) 
1180
    {
1181
        $arrname[$i] = $mik2 -> fields['name'];
1182
        $arrid[$i] = $mik2 -> fields['id'];
1183
        $arramount[$i] = $mik2 -> fields['amount'];
1184
        $arreffect[$i] = $mik2 -> fields['efect'];
1185
        $arrpower[$i] = "(".POWER.": ".$mik2 -> fields['power'].")";
1186
        
1187
        $mik2 -> MoveNext();
1188
        $i = $i + 1;
1189
    }
1190
    $smarty -> assign ( array("2Pname1" => $arrname, 
1191
                              "2Pamount1" => $arramount, 
1192
                              "2Peffect1" => $arreffect, 
1193
                              "2Potionid1" => $arrid,  
1194
                              "2Ppower1" => $arrpower, 
1195
                              "2Potions1" => 1,
1196
                              "2Potions2" => POTIONS,
1197
                              "2Amount" => AMOUNT));
1198
}
1199
$mik2 -> Close();
1200
1201
$smarty -> assign(array("Arramount" => ARR_AMOUNT,
1202
                        "Goldcoins" => GOLD_COINS,
1203
                        "Fora" => FOR_A));
1204
1205
1206
1207
/**
1208
* Initialization of variables
1209
*/
1210
if (!isset($_GET['poison']))
1211
{
1212
    $_GET['poison'] = '';
1213
}
1214
if (!isset($_GET['step']))
1215
{
1216
    $_GET['step'] = '';
1217
}
1218
1219
/**
1220
* Assign variables and display page
1221
*/
1222
$smarty -> assign(array("Poison" => $_GET['poison'],
1223
                        "Step" => $_GET['step']));
1224
$smarty -> display ('equip.tpl');
1225
1226
1227
require_once("includes/foot.php");
1228
?>