List of all SQL mentioned in the code..
| Value | Count | File:Line |
|---|---|---|
| "SELECT `referrer`, COUNT(*) AS `count` FROM `$table` WHERE `shorturl` $keyword_range GROUP BY `referrer`;" | 1 |
|
| 'Select a date' | 1 |
|
| "SELECT `keyword`,`url` FROM `$table` WHERE 1=1 ORDER BY `url` ASC LIMIT $from, $chunk ;" | 1 |
|
| "UPDATE `$table` SET `keyword` = '$newkeyword' WHERE `url` = '$url';" | 1 |
|
| 'Show %s rows' | 1 |
|
| 'Show links with' | 1 |
|
| 'Show links with %1$s than %2$s clicks' | 1 |
|
| 'Show links created' | 1 |
|
| 'Select an end date' | 1 |
|
| "SHOW COLUMNS FROM `$table_log`" | 1 |
|
| 'Show links created %1$s %2$s %3$s %4$s' | 1 |
|
| "SELECT option_name, option_value FROM $table WHERE 1=1" | 1 |
|
| "SHOW TABLES LIKE '%s'" | 1 |
|
| "SELECT option_value FROM $table WHERE option_name = :option_name LIMIT 1" | 1 |
|
| "UPDATE $table SET option_value = :value WHERE option_name = :name" | 1 |
|
| "INSERT INTO $table (option_name, option_value) VALUES (:name, :value)" | 1 |
|
| "DELETE FROM $table WHERE option_name = :name" | 1 |
|
| "SELECT `next_id` FROM `$table`" | 1 |
|
| "SELECT `keyword` FROM `$table` WHERE `url` = :url" | 1 |
|
| "SELECT `country_code`, COUNT(*) AS `count` FROM `$table` WHERE `shorturl` $keyword_range GROUP BY `country_code`;" | 1 |
|
| "SHOW TABLES LIKE '$table_name'" | 1 |
|
| "UPDATE `$table` SET `clicks` = :clicks WHERE `keyword` = :keyword" | 1 |
|
| "UPDATE `$table` SET `clicks` = clicks + 1 WHERE `keyword` = :keyword" | 1 |
|
| "SELECT * FROM `$table_url` WHERE 1=1 ORDER BY $sort_by $sort_order LIMIT $start, $limit;" | 1 |
|
| "SELECT COUNT(keyword) as count, SUM(clicks) as sum FROM `$table_url` WHERE 1=1 " . $where['sql'] | 1 |
|
| "INSERT INTO `$table` (click_time, shorturl, referrer, user_agent, ip_address, country_code) VALUES (:now, :keyword, :referrer, :ua, :ip, :location)" | 1 |
|
| "SELECT `timestamp` FROM $table WHERE `ip` = :ip ORDER BY `timestamp` DESC LIMIT 1" | 1 |
|
| "DELETE FROM `$table` WHERE `keyword` = :keyword" | 1 |
|
| "SELECT * FROM `$table_url` WHERE `keyword` = :keyword" | 1 |
|
| "INSERT INTO `$table` (`keyword`, `url`, `title`, `timestamp`, `ip`, `clicks`) VALUES(:keyword, :url, :title, :timestamp, :ip, 0);" | 1 |
|
| "SELECT * FROM `$table` WHERE `url` = :url" | 1 |
|
| "SELECT `url` FROM `$table` WHERE `keyword` = :keyword" | 1 |
|
| "SELECT COUNT(keyword) FROM `$table` WHERE `url` = :url;" | 1 |
|
| "UPDATE `$table` SET `url` = :url, `keyword` = :newkeyword, `title` = :title WHERE `keyword` = :keyword" | 1 |
|
| "UPDATE `$table` SET `title` = :title WHERE `keyword` = :keyword;" | 1 |
|
| "SELECT * FROM `$table` WHERE `keyword` = :keyword" | 1 |
|
| "SELECT * FROM `$table_url` WHERE 1=1 ${where['sql']} ORDER BY `$sort_by` $sort_order LIMIT $offset, $perpage;" | 1 |
|