List of all SQL mentioned in the code..
| Value | Count | File:Line |
|---|---|---|
| "SELECT name FROM hdris " . $search_text | 1 |
|
| "SELECT * FROM hdris " . $search_text . " " . $sort_text | 1 |
|
| "SELECT * FROM hdris WHERE slug='" . $item . "'" | 1 |
|
| "INSERT INTO download_counting (`ip`, `hdri_id`, `res`) " | 1 |
|
| "UPDATE hdris SET download_count=download_count+1 WHERE id='" . $id . "'" | 1 |
|
| "INSERT INTO searches (`category`, `search_term`) " | 1 |
|
| "SELECT * FROM sponsors WHERE hdri='" . $slug . "' ORDER BY datetime ASC" | 1 |
|
| "SELECT * FROM gallery ORDER BY POWER(clicks+10*click_weight, 0.6)/POWER(ABS(DATEDIFF(date_added, NOW()))+1, 1.2) DESC, clicks DESC, date_added DESC" | 1 |
|
| "INSERT INTO hdris (" . $sql_field_str . ") VALUES (" . $sql_value_str . ")" | 1 |
|
| "SELECT * from hdris WHERE slug='" . $slug . "'" | 1 |
|
| "UPDATE gallery SET approval_pending=0, hdri_used=\"" . $hdri_used . "\" WHERE hash=\"" . $hash . "\"" | 1 |
|
| "DELETE FROM gallery WHERE hash=\"" . $hash . "\"" | 1 |
|
| "INSERT INTO gallery (" . implode(", ", array_keys($sql_pairs)) . ") VALUES (" . implode(", ", array_values($sql_pairs)) . ")" | 1 |
|
| "UPDATE gallery SET clicks=clicks+1 WHERE id='" . $_POST["id"] . "'" | 1 |
|