We could not synchronize checks via GitHub's checks API since Scrutinizer's GitHub App is not installed for this repository.
1 | <?php declare(strict_types=1); |
||
2 | |||
3 | use Smr\Database; |
||
4 | use Smr\Epoch; |
||
5 | use Smr\Request; |
||
6 | |||
7 | try { |
||
8 | require_once('../../bootstrap.php'); |
||
9 | require_once(LIB . 'Album/album_functions.php'); |
||
10 | |||
11 | // database object |
||
12 | $db = Database::getInstance(); |
||
13 | ?> |
||
14 | <!DOCTYPE html> |
||
15 | <html> |
||
16 | <head> |
||
17 | <link rel="stylesheet" type="text/css" href="/<?php echo DEFAULT_CSS; ?>"> |
||
18 | <link rel="stylesheet" type="text/css" href="/<?php echo DEFAULT_CSS_COLOUR; ?>"> |
||
19 | <title>Space Merchant Realms - Photo Album</title> |
||
20 | <meta http-equiv="pragma" content="no-cache"> |
||
21 | </head> |
||
22 | <body> |
||
23 | |||
24 | <table class="center" width="850" border="0" cellpadding="0" cellspacing="0" > |
||
25 | <tr> |
||
26 | <td colspan="2"></td> |
||
27 | </tr> |
||
28 | <tr> |
||
29 | <td> |
||
30 | <table width="750" border="0" cellspacing="0" cellpadding="0"> |
||
31 | <tr> |
||
32 | <td> |
||
33 | |||
34 | <table cellspacing="0" cellpadding="0" border="0" width="700"> |
||
35 | <tr><td class="center" colspan="3"><h1>Space Merchant Realms - Photo Album</h1></td></tr> |
||
36 | <tr> |
||
37 | <td colspan="3" height="1" bgcolor="#0B8D35"></td> |
||
38 | </tr> |
||
39 | <tr> |
||
40 | <td width="1" bgcolor="#0B8D35"></td> |
||
41 | <td class="left" valign="top" bgcolor="#06240E"> |
||
42 | <table width="100%" height="100%" border="0" cellspacing="5" cellpadding="5"> |
||
43 | <tr> |
||
44 | <td valign="top"> |
||
45 | <?php |
||
46 | if (Request::has('nick')) { |
||
47 | $query = urldecode(Request::get('nick')); |
||
48 | |||
49 | $dbResult = $db->read('SELECT account_id as album_id |
||
50 | FROM album JOIN account USING(account_id) |
||
51 | WHERE hof_name LIKE ' . $db->escapeString($query . '%') . ' AND |
||
52 | approved = \'YES\' |
||
53 | ORDER BY hof_name'); |
||
54 | |||
55 | if ($dbResult->getNumRecords() > 1) { |
||
56 | $dbResult2 = $db->read('SELECT account_id as album_id |
||
57 | FROM album JOIN account USING(account_id) |
||
58 | WHERE hof_name = ' . $db->escapeString($query) . ' AND |
||
59 | approved = \'YES\' |
||
60 | ORDER BY hof_name'); |
||
61 | |||
62 | if ($dbResult2->hasRecord()) { |
||
63 | album_entry($dbResult2->record()->getInt('album_id')); |
||
64 | } else { |
||
65 | // get all id's and build array |
||
66 | $album_ids = []; |
||
67 | |||
68 | foreach ($dbResult->records() as $dbRecord) { |
||
69 | $album_ids[] = $dbRecord->getInt('album_id'); |
||
70 | } |
||
71 | |||
72 | // double check if we have id's |
||
73 | if (count($album_ids) > 0) { |
||
74 | search_result($album_ids); |
||
75 | } else { |
||
76 | main_page(); |
||
77 | } |
||
78 | } |
||
79 | |||
80 | } elseif ($dbResult->getNumRecords() == 1) { |
||
81 | album_entry($dbResult->record()->getInt('album_id')); |
||
82 | } else { |
||
83 | main_page(); |
||
84 | } |
||
85 | } else { |
||
86 | main_page(); |
||
87 | } |
||
88 | } catch (Throwable $e) { |
||
89 | handleException($e); |
||
0 ignored issues
–
show
Bug
introduced
by
Loading history...
|
|||
90 | } |
||
91 | ?> |
||
92 | </td> |
||
93 | </tr> |
||
94 | </table> |
||
95 | </td> |
||
96 | <td width="1" bgcolor="#0B8D35"></td> |
||
97 | </tr> |
||
98 | <tr> |
||
99 | <td colspan="3" height="1" bgcolor="#0b8d35"></td> |
||
100 | </tr> |
||
101 | </table> |
||
102 | |||
103 | </td> |
||
104 | <td width="20"> </td> |
||
105 | <td height="100%"> |
||
106 | |||
107 | <table cellspacing="0" cellpadding="0" border="0" width="150" height="100%"> |
||
108 | <tr> |
||
109 | <td colspan="3" height="1" bgcolor="#0B8D35"></td> |
||
110 | </tr> |
||
111 | <tr> |
||
112 | <td width="1" bgcolor="#0B8D35"></td> |
||
113 | <td valign="top" bgcolor="#06240E"> |
||
114 | <table width="100%" height="100%" border="0" cellspacing="5" cellpadding="5"> |
||
115 | <tr> |
||
116 | <td valign="top" class="center"> |
||
117 | <form> |
||
118 | Quick Search:<br /> |
||
119 | <input type="text" name="nick" size="10"><br /> |
||
120 | <input type="submit" value="Search"> |
||
121 | </form> |
||
122 | |||
123 | </td> |
||
124 | </tr> |
||
125 | </table> |
||
126 | </td> |
||
127 | <td width="1" bgcolor="#0B8D35"></td> |
||
128 | </tr> |
||
129 | <tr> |
||
130 | <td colspan="3" height="1" bgcolor="#0b8d35"></td> |
||
131 | </tr> |
||
132 | </table> |
||
133 | |||
134 | </td> |
||
135 | </tr> |
||
136 | </table> |
||
137 | </td> |
||
138 | </tr> |
||
139 | |||
140 | <tr> |
||
141 | <td class="left" style='font-size:65%;'> |
||
142 | © 2002-<?php echo date('Y', Epoch::time()); ?> by <a href="<?php echo URL; ?>"><?php echo URL; ?></a><br /> |
||
143 | Hosted by <a href='http://www.fem.tu-ilmenau.de/' target='fem'>FeM</a> |
||
144 | </td> |
||
145 | </tr> |
||
146 | </table> |
||
147 | |||
148 | </body> |
||
149 | </html> |
||
150 |