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
|
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class armurie_model extends CI_Model {
public function Pseudo_Search ($pseudo) {
$DB3 = $this->load->database('char', TRUE);
$DB3 -> select('*');
$DB3 -> from('characters');
$DB3 -> where('name = ' . "'" . $pseudo . "'");
$DB3 -> limit(1);
$query = $DB3 -> get();
if($query -> num_rows() == 1)
{
return $query->result();
}
else
{
return false;
}
}
public function View ($pseudo) {
$DB3 = $this->load->database('char', TRUE);
$DB3 -> select('*');
$DB3 -> from('characters');
$DB3 -> where('name = ' . "'" . $pseudo . "'");
$DB3 -> limit(1);
$query = $DB3 -> get();
return $query -> result();
}
public function stuff ($guid) {
for ($i = 0; $i < 19; $i++) {
$DB4 = $this->load->database('world', TRUE);
$DB3 = $this->load->database('char', TRUE);
$row_item[$i] = array();
$DB3 -> select('item');
$DB3 -> from('character_inventory');
$DB3 -> where("guid = ' " . $guid . " ' AND bag = '0' AND slot = ' " . $i . " ' ");
$DB3 -> limit('1');
$querycharinvent = $DB3 -> get();
if ($querycharinvent -> num_rows() > 0) {
$slot = $querycharinvent -> result();
$DB3 -> select('*');
$DB3 -> from('item_instance');
$DB3 -> where("guid = ' " . $guid . " '");
$DB3 -> limit('1');
$resch = $DB3 -> get();
$row_item[$i] = $resch->result();
$DB4 -> select('*');
$DB4 -> from('item_template');
$DB4 -> where("entry = '".$row_item[$i]['itemEntry']."' ");
$res = $DB4 -> get();
$result = $res -> result;
$row_item[$i]['Quality'] = 0;
$row_item[$i]['displayid'] = 0;
$row_item[$i]['Quality'] = $result['Quality'];
$row_item[$i]['displayid'] = $result['displayid'];
}
}
return $row_item;
}
} |
