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 |
|