| Line 128... |
Line 128... |
| 128 |
$str .= "<thead class=\"thead-dark table-header-sticky\">";
|
128 |
$str .= "<thead class=\"thead-dark table-header-sticky\">";
|
| 129 |
$str .= "<tr><th></th>";
|
129 |
$str .= "<tr><th></th>";
|
| 130 |
$str .= "<th id=\"sortColumn1\" class=\"text-left cursor-pointer\"><span class=\"nowrap\">Artist <i class=\"material-icons material-text material-nrm\">arrow_drop_up</i><i class=\"material-icons material-text material-nlm\">arrow_drop_down</i></span></th>";
|
130 |
$str .= "<th id=\"sortColumn1\" class=\"text-left cursor-pointer\"><span class=\"nowrap\">Artist <i class=\"material-icons material-text material-nrm\">arrow_drop_up</i><i class=\"material-icons material-text material-nlm\">arrow_drop_down</i></span></th>";
|
| 131 |
$str .= "<th id=\"sortColumn2\" class=\"text-left cursor-pointer\"><span class=\"text-nowrap\">Title <i class=\"material-icons material-text material-nrm\">arrow_drop_up</i><i class=\"material-icons material-text material-nlm\">arrow_drop_down</i></span></th>";
|
131 |
$str .= "<th id=\"sortColumn2\" class=\"text-left cursor-pointer\"><span class=\"text-nowrap\">Title <i class=\"material-icons material-text material-nrm\">arrow_drop_up</i><i class=\"material-icons material-text material-nlm\">arrow_drop_down</i></span></th>";
|
| 132 |
$str .= "<th id=\"sortColumn3\" class=\"d-none\"></th>";
|
132 |
$str .= "<th id=\"sortColumn3\" class=\"d-none\"></th>";
|
| 133 |
$str .= "<th id=\"sortColumn4\" class=\"cursor-pointer\"><span class=\"text-nowrap\">Barcode <i class=\"material-icons material-text material-nrm\">arrow_drop_up</i><i class=\"material-icons material-text material-nlm\">arrow_drop_down</i></span></th>";
|
133 |
$str .= "<th id=\"sortColumn4\" class=\"cursor-pointer hide-medium hide-small\"><span class=\"text-nowrap\">Barcode <i class=\"material-icons material-text material-nrm\">arrow_drop_up</i><i class=\"material-icons material-text material-nlm\">arrow_drop_down</i></span></th>";
|
| 134 |
$str .= "<th id=\"sortColumn5\" class=\"cursor-pointer\"><span class=\"text-nowrap\">Condition <i class=\"material-icons material-text material-nrm\">arrow_drop_up</i><i class=\"material-icons material-text material-nlm\">arrow_drop_down</i></span></th>";
|
134 |
$str .= "<th id=\"sortColumn5\" class=\"cursor-pointer hide-small\"><span class=\"text-nowrap\">Condition <i class=\"material-icons material-text material-nrm\">arrow_drop_up</i><i class=\"material-icons material-text material-nlm\">arrow_drop_down</i></span></th>";
|
| 135 |
$str .= "<th id=\"sortColumn6\" class=\"cursor-pointer\"><span class=\"text-nowrap\">Format <i class=\"material-icons material-text material-nrm\">arrow_drop_up</i><i class=\"material-icons material-text material-nlm\">arrow_drop_down</i></span></th>";
|
135 |
$str .= "<th id=\"sortColumn6\" class=\"cursor-pointer hide-small\"><span class=\"text-nowrap\">Format <i class=\"material-icons material-text material-nrm\">arrow_drop_up</i><i class=\"material-icons material-text material-nlm\">arrow_drop_down</i></span></th>";
|
| 136 |
$str .= "<th class=\"d-none\">Ceiling Price Number</th>";
|
136 |
$str .= "<th class=\"d-none\">Ceiling Price Number</th>";
|
| 137 |
$str .= "<th id=\"sortColumn7\" class=\"cursor-pointer\"><span class=\"text-nowrap\">Price <i class=\"material-icons material-text material-nrm\">arrow_drop_up</i><i class=\"material-icons material-text material-nlm\">arrow_drop_down</i></span></th>";
|
137 |
$str .= "<th id=\"sortColumn7\" class=\"cursor-pointer\"><span class=\"text-nowrap\">Price <i class=\"material-icons material-text material-nrm\">arrow_drop_up</i><i class=\"material-icons material-text material-nlm\">arrow_drop_down</i></span></th>";
|
| 138 |
$str .= "<th></th><th class=\"d-none\"></th></tr></thead>";
|
138 |
$str .= "<th></th><th class=\"d-none\"></th></tr></thead>";
|
| 139 |
$str .= '<script nonce="' . base64_encode($_SESSION["nonce"]) .'">';
|
139 |
$str .= '<script nonce="' . base64_encode($_SESSION["nonce"]) .'">';
|
| 140 |
$str .= 'document.addEventListener("DOMContentLoaded", function() {';
|
140 |
$str .= 'document.addEventListener("DOMContentLoaded", function() {';
|
| Line 173... |
Line 173... |
| 173 |
$str .= "<tr>";
|
173 |
$str .= "<tr>";
|
| 174 |
$str .= "<td><img class=\"img-fluid wl-img lazyload\" src=\"data:image/png;base64,R0lGODlhAQABAAD/ACwAAAAAAQABAAACADs=\" data-src=\"" . $row["thumbnail"] . "\" alt=\"" . $altText . "\" /></td>";
|
174 |
$str .= "<td><img class=\"img-fluid wl-img lazyload\" src=\"data:image/png;base64,R0lGODlhAQABAAD/ACwAAAAAAQABAAACADs=\" data-src=\"" . $row["thumbnail"] . "\" alt=\"" . $altText . "\" /></td>";
|
| 175 |
$str .= "<td>$artist</td>";
|
175 |
$str .= "<td>$artist</td>";
|
| 176 |
$str .= "<td>" . $row['title'] . "</td>";
|
176 |
$str .= "<td>" . $row['title'] . "</td>";
|
| 177 |
$str .= "<td class=\"d-none\">" . $row['barcode'] . "</td>";
|
177 |
$str .= "<td class=\"d-none\">" . $row['barcode'] . "</td>";
|
| 178 |
$str .= "<td>" . displayBarcode($row['barcode']) . "</td>";
|
178 |
$str .= "<td class=\"hide-medium hide-small\">" . displayBarcode($row['barcode']) . "</td>";
|
| 179 |
$str .= "<td>" . $row['cond'] . "</td>";
|
179 |
$str .= "<td class=\"hide-small\">" . $row['cond'] . "</td>";
|
| 180 |
$str .= "<td>" . $row['format'] . "</td>";
|
180 |
$str .= "<td class=\"hide-small\">" . $row['format'] . "</td>";
|
| 181 |
$str .= "<td class=\"d-none\">" . $row['price'] . "</td>";
|
181 |
$str .= "<td class=\"d-none\">" . $row['price'] . "</td>";
|
| 182 |
$str .= "<td>" . $price . "</td>";
|
182 |
$str .= "<td>" . $price . "</td>";
|
| 183 |
$str .= "<td><span class=\"text-nowrap\"><button id=\"wlEditBtn" . $row['id'] . "\" class=\"btn rounded px-1\" type=\"button\" data-toggle=\"tooltip\" title=\"Edit\" aria-label=\"Edit Entry\"><i class=\"material-icons\">edit</i></button>";
|
183 |
$str .= "<td><span class=\"text-nowrap\"><button id=\"wlEditBtn" . $row['id'] . "\" class=\"btn rounded px-1\" type=\"button\" data-toggle=\"tooltip\" title=\"Edit\" aria-label=\"Edit Entry\"><i class=\"material-icons\">edit</i></button>";
|
| 184 |
$str .= "<button id=\"wlDeleteBtn" . $row['id'] . "\" class=\"btn rounded px-1\" type=\"button\" data-toggle=\"tooltip\" title=\"Delete\" aria-label=\"Delete Entry\"><i class=\"material-icons\">cancel_presentation</i></button>";
|
184 |
$str .= "<button id=\"wlDeleteBtn" . $row['id'] . "\" class=\"btn rounded px-1\" type=\"button\" data-toggle=\"tooltip\" title=\"Delete\" aria-label=\"Delete Entry\"><i class=\"material-icons\">cancel_presentation</i></button>";
|
| 185 |
$str .= "<a class=\"btn rounded px-1\" role=\"button\" data-toggle=\"tooltip\" title=\"Information\" aria-label=\"Information for Entry\" href=\"" . htmlentities($row['url']) . "\" target=\"_blank\" rel=\"noreferrer noopener\"><i class=\"material-icons\">info_outline</i></a>";
|
185 |
$str .= "<a class=\"btn rounded px-1\" role=\"button\" data-toggle=\"tooltip\" title=\"Information\" aria-label=\"Information for Entry\" href=\"" . htmlentities($row['url']) . "\" target=\"_blank\" rel=\"noreferrer noopener\"><i class=\"material-icons\">info_outline</i></a>";
|
| Line 422... |
Line 422... |
| 422 |
if (!($result = mysqli_query($conn, $sql))) {
|
422 |
if (!($result = mysqli_query($conn, $sql))) {
|
| 423 |
error_log("MySQL Update Price Monitor SQL: " . $sql);
|
423 |
error_log("MySQL Update Price Monitor SQL: " . $sql);
|
| 424 |
error_log("MySQL Update Price Monitor Error: " . mysqli_error($conn) . " (" . $error . ")");
|
424 |
error_log("MySQL Update Price Monitor Error: " . mysqli_error($conn) . " (" . $error . ")");
|
| 425 |
}
|
425 |
}
|
| 426 |
|
426 |
|
| 427 |
return(gzdecode(base64_decode($row['data'])));
|
427 |
$html = gzdecode(base64_decode($row['data']));
|
| - |
|
428 |
$html = str_replace(base64_encode("xxxNONCExxx"), base64_encode($_SESSION["nonce"]), $html);
|
| - |
|
429 |
return ($html);
|
| 428 |
}
|
430 |
}
|
| 429 |
}
|
431 |
}
|
| 430 |
}
|
432 |
}
|
| 431 |
else if (mysqli_errno($conn)) {
|
433 |
else if (mysqli_errno($conn)) {
|
| 432 |
error_log("MySQL Read Price Monitor SQL: " . $sql);
|
434 |
error_log("MySQL Read Price Monitor SQL: " . $sql);
|