@@ -90,7 +90,7 @@ discard block |
||
90 | 90 | /** |
91 | 91 | * @param string $query |
92 | 92 | * @param array $params |
93 | - * @param null $db |
|
93 | + * @param string $db |
|
94 | 94 | * @return null|void |
95 | 95 | * @internal param string $db |
96 | 96 | */ |
@@ -237,7 +237,7 @@ discard block |
||
237 | 237 | |
238 | 238 | //CORP INFO |
239 | 239 | /** |
240 | - * @param $corpID |
|
240 | + * @param integer $corpID |
|
241 | 241 | * @param $corpTicker |
242 | 242 | * @param string $corpName |
243 | 243 | */ |
@@ -246,6 +246,9 @@ discard block |
||
246 | 246 | dbExecute('REPLACE INTO corpCache (`corpID`, `corpTicker`, `corpName`) VALUES (:corpID,:corpTicker,:corpName)', array(':corpID' => $corpID, ':corpTicker' => $corpTicker, ':corpName' => $corpName)); |
247 | 247 | } |
248 | 248 | |
249 | +/** |
|
250 | + * @param integer $corpID |
|
251 | + */ |
|
249 | 252 | function getCorpInfo($corpID) |
250 | 253 | { |
251 | 254 | return dbQueryRow('SELECT * FROM corpCache WHERE `corpID` = :corpID', array(':corpID' => $corpID)); |
@@ -290,6 +293,9 @@ discard block |
||
290 | 293 | return $query['typeName']; |
291 | 294 | } |
292 | 295 | |
296 | +/** |
|
297 | + * @return string |
|
298 | + */ |
|
293 | 299 | function getSystemID($solarSystemName) |
294 | 300 | { |
295 | 301 | $query = dbQueryRow('SELECT * FROM mapSolarSystems WHERE lower(`solarSystemName`) = :solarSystemName', array(':solarSystemName' => $solarSystemName), 'eve'); |
@@ -37,7 +37,7 @@ |
||
37 | 37 | $logger->pushHandler(new StreamHandler(__DIR__ . '/../../log/libraryError.log', Logger::DEBUG)); |
38 | 38 | if ($db === null) { |
39 | 39 | $db = __DIR__ . '/../../database/dramiel.sqlite'; |
40 | - } elseif ($db === 'eve'){ |
|
40 | + } elseif ($db === 'eve') { |
|
41 | 41 | $db = __DIR__ . '/../../database/eveData.db'; |
42 | 42 | } |
43 | 43 |
@@ -4,93 +4,93 @@ discard block |
||
4 | 4 | |
5 | 5 | class sysInfo |
6 | 6 | { |
7 | - public $config; |
|
8 | - public $discord; |
|
9 | - public $logger; |
|
10 | - private $excludeChannel; |
|
11 | - private $message; |
|
12 | - private $triggers; |
|
13 | - |
|
14 | - public function init($config, $discord, $logger) |
|
15 | - { |
|
16 | - $this->config = $config; |
|
17 | - $this->discord = $discord; |
|
18 | - $this->logger = $logger; |
|
19 | - $this->excludeChannel = $this->config['bot']['restrictedChannels']; |
|
20 | - $this->triggers[] = $this->config['bot']['trigger'] . 'sys'; |
|
21 | - $this->triggers[] = $this->config['bot']['trigger'] . 'Sys'; |
|
22 | - $this->triggers[] = $this->config['bot']['trigger'] . 'sysinfo'; |
|
23 | - $this->triggers[] = $this->config['bot']['trigger'] . 'system'; |
|
24 | - $this->triggers[] = $this->config['bot']['trigger'] . 'System'; |
|
25 | - $this->triggers[] = $this->config['bot']['trigger'] . 'Sysinfo'; |
|
26 | - } |
|
27 | - |
|
28 | - public function onMessage($msgData, $message) |
|
29 | - { |
|
30 | - $channelID = (int) $msgData['message']['channelID']; |
|
31 | - |
|
32 | - if(in_array($channelID, $this->excludeChannel, true)) |
|
33 | - { |
|
34 | - return null; |
|
35 | - } |
|
36 | - |
|
37 | - $this->message = $message; |
|
38 | - |
|
39 | - $message = $msgData['message']['message']; |
|
40 | - $user = $msgData['message']['from']; |
|
41 | - |
|
42 | - $data = command($message, $this->information()['trigger'], $this->config['bot']['trigger']); |
|
43 | - if(isset($data['trigger'])) |
|
44 | - { |
|
45 | - $messageString = strstr($data['messageString'], '@') ? str_replace('<@', '', str_replace('>', '', $data['messageString'])) : $data['messageString']; |
|
46 | - if(is_numeric($messageString)) |
|
47 | - { |
|
48 | - $messageString = dbQueryField('SELECT name FROM usersSeen WHERE id = :id', 'name', array(':id' => $messageString)); |
|
49 | - } |
|
50 | - $cleanString = urlencode($messageString); |
|
51 | - $sysID = urlencode(getSystemID($cleanString)); |
|
52 | - |
|
53 | - //Check if we get a system back, otherwise check for partials |
|
54 | - if(empty($sysID)) |
|
55 | - { |
|
56 | - $search = "http://tools.pandemic-legion.pl/api/search/{$cleanString}"; |
|
57 | - $search = json_decode(file_get_contents($search)); |
|
58 | - $tot = 0; |
|
59 | - $res = array(); |
|
60 | - foreach ($search as $s){ |
|
61 | - if ($s->type == "system"){ |
|
62 | - $tot++; |
|
63 | - $res[] = $s->name; |
|
64 | - } |
|
65 | - } |
|
66 | - if ($tot == 0){ |
|
67 | - return $this->message->reply('**Error:** no data available'); |
|
68 | - } |
|
69 | - if ($tot == 1){ |
|
70 | - $sysID = urlencode(getSystemID($res[0])); |
|
71 | - if(empty($sysID)){ |
|
72 | - return $this->message->reply('**Error:** no data available'); |
|
73 | - } |
|
74 | - } |
|
75 | - if ($tot > 1){ |
|
76 | - $res = implode(", ",$res); |
|
77 | - return $this->message->reply("**Error:** Did you mean one of these? {$res}"); |
|
78 | - } |
|
79 | - } |
|
80 | - |
|
81 | - $systemDetails = systemDetails($sysID); |
|
82 | - if (null === $systemDetails) |
|
83 | - { |
|
84 | - return $this->message->reply('**Error:** ESI is down. Try again later.'); |
|
85 | - } |
|
86 | - |
|
87 | - $url = "https://zkillboard.com/api/stats/solarSystemID/{$sysID}/"; |
|
88 | - $json = json_decode(file_get_contents($url)); |
|
89 | - |
|
90 | - $regionID = $json->info->regionID; |
|
91 | - $regionName = getRegionName($regionID); |
|
92 | - |
|
93 | - $thisMonth = (string)date('Ym'); |
|
7 | + public $config; |
|
8 | + public $discord; |
|
9 | + public $logger; |
|
10 | + private $excludeChannel; |
|
11 | + private $message; |
|
12 | + private $triggers; |
|
13 | + |
|
14 | + public function init($config, $discord, $logger) |
|
15 | + { |
|
16 | + $this->config = $config; |
|
17 | + $this->discord = $discord; |
|
18 | + $this->logger = $logger; |
|
19 | + $this->excludeChannel = $this->config['bot']['restrictedChannels']; |
|
20 | + $this->triggers[] = $this->config['bot']['trigger'] . 'sys'; |
|
21 | + $this->triggers[] = $this->config['bot']['trigger'] . 'Sys'; |
|
22 | + $this->triggers[] = $this->config['bot']['trigger'] . 'sysinfo'; |
|
23 | + $this->triggers[] = $this->config['bot']['trigger'] . 'system'; |
|
24 | + $this->triggers[] = $this->config['bot']['trigger'] . 'System'; |
|
25 | + $this->triggers[] = $this->config['bot']['trigger'] . 'Sysinfo'; |
|
26 | + } |
|
27 | + |
|
28 | + public function onMessage($msgData, $message) |
|
29 | + { |
|
30 | + $channelID = (int) $msgData['message']['channelID']; |
|
31 | + |
|
32 | + if(in_array($channelID, $this->excludeChannel, true)) |
|
33 | + { |
|
34 | + return null; |
|
35 | + } |
|
36 | + |
|
37 | + $this->message = $message; |
|
38 | + |
|
39 | + $message = $msgData['message']['message']; |
|
40 | + $user = $msgData['message']['from']; |
|
41 | + |
|
42 | + $data = command($message, $this->information()['trigger'], $this->config['bot']['trigger']); |
|
43 | + if(isset($data['trigger'])) |
|
44 | + { |
|
45 | + $messageString = strstr($data['messageString'], '@') ? str_replace('<@', '', str_replace('>', '', $data['messageString'])) : $data['messageString']; |
|
46 | + if(is_numeric($messageString)) |
|
47 | + { |
|
48 | + $messageString = dbQueryField('SELECT name FROM usersSeen WHERE id = :id', 'name', array(':id' => $messageString)); |
|
49 | + } |
|
50 | + $cleanString = urlencode($messageString); |
|
51 | + $sysID = urlencode(getSystemID($cleanString)); |
|
52 | + |
|
53 | + //Check if we get a system back, otherwise check for partials |
|
54 | + if(empty($sysID)) |
|
55 | + { |
|
56 | + $search = "http://tools.pandemic-legion.pl/api/search/{$cleanString}"; |
|
57 | + $search = json_decode(file_get_contents($search)); |
|
58 | + $tot = 0; |
|
59 | + $res = array(); |
|
60 | + foreach ($search as $s){ |
|
61 | + if ($s->type == "system"){ |
|
62 | + $tot++; |
|
63 | + $res[] = $s->name; |
|
64 | + } |
|
65 | + } |
|
66 | + if ($tot == 0){ |
|
67 | + return $this->message->reply('**Error:** no data available'); |
|
68 | + } |
|
69 | + if ($tot == 1){ |
|
70 | + $sysID = urlencode(getSystemID($res[0])); |
|
71 | + if(empty($sysID)){ |
|
72 | + return $this->message->reply('**Error:** no data available'); |
|
73 | + } |
|
74 | + } |
|
75 | + if ($tot > 1){ |
|
76 | + $res = implode(", ",$res); |
|
77 | + return $this->message->reply("**Error:** Did you mean one of these? {$res}"); |
|
78 | + } |
|
79 | + } |
|
80 | + |
|
81 | + $systemDetails = systemDetails($sysID); |
|
82 | + if (null === $systemDetails) |
|
83 | + { |
|
84 | + return $this->message->reply('**Error:** ESI is down. Try again later.'); |
|
85 | + } |
|
86 | + |
|
87 | + $url = "https://zkillboard.com/api/stats/solarSystemID/{$sysID}/"; |
|
88 | + $json = json_decode(file_get_contents($url)); |
|
89 | + |
|
90 | + $regionID = $json->info->regionID; |
|
91 | + $regionName = getRegionName($regionID); |
|
92 | + |
|
93 | + $thisMonth = (string)date('Ym'); |
|
94 | 94 | $lastMonth = (string)date('Ym', strtotime('first day of previous month')); |
95 | 95 | |
96 | 96 | $thisMonthKill = $json->months->$thisMonth->shipsDestroyed; |
@@ -100,21 +100,21 @@ discard block |
||
100 | 100 | $activeKills = $activePVP->kills->count; |
101 | 101 | $activeChars = $activePVP->characters->count; |
102 | 102 | |
103 | - $sysName = $systemDetails['name']; |
|
104 | - $secStatus = round($systemDetails['security_status'],2); |
|
103 | + $sysName = $systemDetails['name']; |
|
104 | + $secStatus = round($systemDetails['security_status'],2); |
|
105 | 105 | |
106 | - $npc = "https://api.eveonline.com/map/kills.xml.aspx"; |
|
107 | - $npc = new SimpleXMLElement(file_get_contents($npc)); |
|
108 | - foreach($npc->result->rowset->row as $row){ |
|
109 | - if($row->attributes()->solarSystemID == $sysID){ |
|
110 | - $npcKills = $row->attributes()->factionKills; |
|
111 | - $podKills = $row->attributes()->podKills; |
|
112 | - } |
|
113 | - } |
|
106 | + $npc = "https://api.eveonline.com/map/kills.xml.aspx"; |
|
107 | + $npc = new SimpleXMLElement(file_get_contents($npc)); |
|
108 | + foreach($npc->result->rowset->row as $row){ |
|
109 | + if($row->attributes()->solarSystemID == $sysID){ |
|
110 | + $npcKills = $row->attributes()->factionKills; |
|
111 | + $podKills = $row->attributes()->podKills; |
|
112 | + } |
|
113 | + } |
|
114 | 114 | |
115 | - $url = "https://zkillboard.com/system/{$sysID}/"; |
|
115 | + $url = "https://zkillboard.com/system/{$sysID}/"; |
|
116 | 116 | |
117 | - $msg = "```Systeminfo |
|
117 | + $msg = "```Systeminfo |
|
118 | 118 | Name: {$sysName} |
119 | 119 | Region: {$regionName} |
120 | 120 | Security: {$secStatus} |
@@ -131,18 +131,18 @@ discard block |
||
131 | 131 | ``` |
132 | 132 | |
133 | 133 | More information: $url"; |
134 | - $this->logger->addInfo("sysInfo: Sending system information to {$user}"); |
|
135 | - $this->message->reply($msg); |
|
136 | - } |
|
137 | - return null; |
|
138 | - } |
|
139 | - |
|
140 | - public function information() |
|
141 | - { |
|
142 | - return array( |
|
143 | - 'name' => 'sys', |
|
144 | - 'trigger' => $this->triggers, |
|
145 | - 'information' => 'Returns information for the given system' |
|
146 | - ); |
|
147 | - } |
|
134 | + $this->logger->addInfo("sysInfo: Sending system information to {$user}"); |
|
135 | + $this->message->reply($msg); |
|
136 | + } |
|
137 | + return null; |
|
138 | + } |
|
139 | + |
|
140 | + public function information() |
|
141 | + { |
|
142 | + return array( |
|
143 | + 'name' => 'sys', |
|
144 | + 'trigger' => $this->triggers, |
|
145 | + 'information' => 'Returns information for the given system' |
|
146 | + ); |
|
147 | + } |
|
148 | 148 | } |
@@ -29,7 +29,7 @@ discard block |
||
29 | 29 | { |
30 | 30 | $channelID = (int) $msgData['message']['channelID']; |
31 | 31 | |
32 | - if(in_array($channelID, $this->excludeChannel, true)) |
|
32 | + if (in_array($channelID, $this->excludeChannel, true)) |
|
33 | 33 | { |
34 | 34 | return null; |
35 | 35 | } |
@@ -40,10 +40,10 @@ discard block |
||
40 | 40 | $user = $msgData['message']['from']; |
41 | 41 | |
42 | 42 | $data = command($message, $this->information()['trigger'], $this->config['bot']['trigger']); |
43 | - if(isset($data['trigger'])) |
|
43 | + if (isset($data['trigger'])) |
|
44 | 44 | { |
45 | 45 | $messageString = strstr($data['messageString'], '@') ? str_replace('<@', '', str_replace('>', '', $data['messageString'])) : $data['messageString']; |
46 | - if(is_numeric($messageString)) |
|
46 | + if (is_numeric($messageString)) |
|
47 | 47 | { |
48 | 48 | $messageString = dbQueryField('SELECT name FROM usersSeen WHERE id = :id', 'name', array(':id' => $messageString)); |
49 | 49 | } |
@@ -51,29 +51,29 @@ discard block |
||
51 | 51 | $sysID = urlencode(getSystemID($cleanString)); |
52 | 52 | |
53 | 53 | //Check if we get a system back, otherwise check for partials |
54 | - if(empty($sysID)) |
|
54 | + if (empty($sysID)) |
|
55 | 55 | { |
56 | 56 | $search = "http://tools.pandemic-legion.pl/api/search/{$cleanString}"; |
57 | 57 | $search = json_decode(file_get_contents($search)); |
58 | 58 | $tot = 0; |
59 | 59 | $res = array(); |
60 | - foreach ($search as $s){ |
|
61 | - if ($s->type == "system"){ |
|
60 | + foreach ($search as $s) { |
|
61 | + if ($s->type == "system") { |
|
62 | 62 | $tot++; |
63 | 63 | $res[] = $s->name; |
64 | 64 | } |
65 | 65 | } |
66 | - if ($tot == 0){ |
|
66 | + if ($tot == 0) { |
|
67 | 67 | return $this->message->reply('**Error:** no data available'); |
68 | 68 | } |
69 | - if ($tot == 1){ |
|
69 | + if ($tot == 1) { |
|
70 | 70 | $sysID = urlencode(getSystemID($res[0])); |
71 | - if(empty($sysID)){ |
|
71 | + if (empty($sysID)) { |
|
72 | 72 | return $this->message->reply('**Error:** no data available'); |
73 | 73 | } |
74 | 74 | } |
75 | - if ($tot > 1){ |
|
76 | - $res = implode(", ",$res); |
|
75 | + if ($tot > 1) { |
|
76 | + $res = implode(", ", $res); |
|
77 | 77 | return $this->message->reply("**Error:** Did you mean one of these? {$res}"); |
78 | 78 | } |
79 | 79 | } |
@@ -90,8 +90,8 @@ discard block |
||
90 | 90 | $regionID = $json->info->regionID; |
91 | 91 | $regionName = getRegionName($regionID); |
92 | 92 | |
93 | - $thisMonth = (string)date('Ym'); |
|
94 | - $lastMonth = (string)date('Ym', strtotime('first day of previous month')); |
|
93 | + $thisMonth = (string) date('Ym'); |
|
94 | + $lastMonth = (string) date('Ym', strtotime('first day of previous month')); |
|
95 | 95 | |
96 | 96 | $thisMonthKill = $json->months->$thisMonth->shipsDestroyed; |
97 | 97 | $lastMonthKill = $json->months->$lastMonth->shipsDestroyed; |
@@ -101,12 +101,12 @@ discard block |
||
101 | 101 | $activeChars = $activePVP->characters->count; |
102 | 102 | |
103 | 103 | $sysName = $systemDetails['name']; |
104 | - $secStatus = round($systemDetails['security_status'],2); |
|
104 | + $secStatus = round($systemDetails['security_status'], 2); |
|
105 | 105 | |
106 | 106 | $npc = "https://api.eveonline.com/map/kills.xml.aspx"; |
107 | 107 | $npc = new SimpleXMLElement(file_get_contents($npc)); |
108 | - foreach($npc->result->rowset->row as $row){ |
|
109 | - if($row->attributes()->solarSystemID == $sysID){ |
|
108 | + foreach ($npc->result->rowset->row as $row) { |
|
109 | + if ($row->attributes()->solarSystemID == $sysID) { |
|
110 | 110 | $npcKills = $row->attributes()->factionKills; |
111 | 111 | $podKills = $row->attributes()->podKills; |
112 | 112 | } |