List of all SQL mentioned in the code..
| Value | Count | File:Line |
|---|---|---|
| "SELECT count(table_schema) from information_schema.tables WHERE table_schema = '$database'" | 1 |
|
| "UPDATE input SET time = ?, value = ? WHERE id = ?" | 1 |
|
| "SELECT time, data FROM $feedname WHERE feed_id=$feedid and day=$max_day ORDER BY time DESC LIMIT 1" | 1 |
|
| "SELECT time, data FROM $feedname WHERE feed_id=$feedid AND day IN (" . implode($day_range, ',') . ") AND time >= $start AND time <= $end" | 1 |
|
| "DELETE FROM $feedname WHERE feed_id = $feedid AND day = $day AND time = $time" | 1 |
|
| "DELETE FROM $feedname WHERE feed_id=$feedid AND day IN (" . implode($day_range, ',') . ") AND time >= $start AND time <= $end" | 1 |
|
| "select data2, sum(data) as kWh from $feedname WHERE time>='$start' AND time<'$end' group by data2 order by data2 Asc" | 1 |
|
| "INSERT INTO input (userid,name,nodeid,description,processList) VALUES (?,?,?,'','')" | 1 |
|
| "SELECT id FROM input WHERE `id` = '$inputid'" | 1 |
|
| "SELECT id FROM input WHERE userid=? AND nodeid=? AND name=?" | 1 |
|
| "SELECT id FROM input WHERE userid = '$userid' AND id = '$inputid'" | 1 |
|
| "UPDATE $feedname SET data = $value WHERE feed_id = $feedid AND day = $day AND time = $time" | 1 |
|
| "UPDATE input SET name = ? WHERE id = ?" | 1 |
|
| "UPDATE input SET description = ? WHERE id = ?" | 1 |
|
| "SELECT id,nodeid,name,description,processList FROM input WHERE `userid` = '$userid' ORDER BY nodeid,name asc" | 1 |
|
| "SELECT nodeid,name,description,processList,time,value FROM input WHERE `userid` = '$userid' ORDER BY nodeid,name asc" | 1 |
|
| "SELECT id,nodeid,name,description,processList,time,value FROM input WHERE `userid` = '$userid' ORDER BY nodeid,name asc" | 1 |
|
| "SELECT name FROM input WHERE `id` = '$id'" | 1 |
|
| "SELECT nodeid,name,description FROM input WHERE `id` = '$id'" | 1 |
|
| "SELECT value FROM input WHERE `id` = '$id'" | 1 |
|
| "SELECT time, value FROM input WHERE `id` = '$id'" | 1 |
|
| "SELECT max(day) AS max_day FROM $feedname WHERE feed_id=$feedid" | 1 |
|
| "INSERT INTO $feedname(feed_id,day,time,data) VALUES($feedid,$day,$time,$value)" | 1 |
|
| "SELECT id, processList FROM input WHERE `userid`='$userid'" | 1 |
|
| "SELECT AVG(data) AS dp FROM $table WHERE time >= $interval_start AND time < $interval_end" | 1 |
|
| "Delete data point" | 1 |
|
| "Delete existent feed" | 1 |
|
| "Update feed field" | 1 |
|
| "SELECT time FROM " . $meta->table_name . " ORDER BY time ASC LIMIT 1" | 1 |
|
| "SHOW INDEX FROM $table" | 1 |
|
| "SELECT time, data FROM $table ORDER BY time Desc LIMIT 1" | 1 |
|
| "SELECT time, data FROM $table" . " WHERE time = $start LIMIT 1" | 1 |
|
| "SELECT time, data FROM $table WHERE (" . " time = IFNULL( (SELECT max(time) FROM $table where time <= $time), 0) " . "OR time = IFNULL( (SELECT min(time) FROM $table where time > $time), 0) " . ")" | 1 |
|
| "SELECT time, AVG(data) AS data_avg FROM $table WHERE time >= $start AND time < $end GROUP BY FLOOR(time/$interval)" | 1 |
|
| "SHOW TABLE STATUS LIKE '$table'" | 1 |
|
| "SELECT datatype FROM feeds WHERE `id` = '$feedid'" | 1 |
|
| "SELECT * FROM $table WHERE time>$start ORDER BY time Asc Limit $block_size" | 1 |
|
| "DELETE FROM $table WHERE time < ?" | 1 |
|
| "SELECT * FROM $table WHERE time = '$time'" | 1 |
|
| "UPDATE $table SET data = '$value' WHERE time = '$time'" | 1 |
|
| "INSERT INTO $table (`time`,`data`) VALUES ('$time','$value')" | 1 |
|
| "INSERT INTO $table (time,data) VALUES ('$time','$value') ON DUPLICATE KEY UPDATE data=VALUES(data)" | 1 |
|
| "INSERT INTO $table (`time`,`data`) VALUES " . substr($sql_values, 0, -1) . " ON DUPLICATE KEY UPDATE data=VALUES(data)" | 1 |
|
| "DELETE FROM $table where `time` = '$time' LIMIT 1" | 1 |
|
| "DELETE FROM $table where `time` >= '$start' AND `time`<= '$end'" | 1 |
|
| "SELECT * FROM input WHERE `userid` = '$userid'" | 1 |
|
| "UPDATE input SET processList = '$processlist_after' WHERE id='$inputid'" | 1 |
|
| "Insert new data point" | 1 |
|
| 'Select visualisation:' | 1 |
|
| "SELECT id,name,feedlist FROM multigraph WHERE `userid`='$userid'" | 1 |
|
| "Delete Multigraph" | 1 |
|
| "Delete permanently" | 1 |
|
| "Select Display Type:" | 1 |
|
| "Select multigraph:" | 1 |
|
| "Show Legend" | 1 |
|
| "Show tag name" | 1 |
|
| "Show difference between each bar" | 1 |
|
| 'Delete data in window' | 1 |
|
| "UPDATE multigraph SET name=?, feedlist=? WHERE id=? AND userid=?" | 1 |
|
| 'Delete feed data' | 1 |
|
| "Update feed at day" | 1 |
|
| "SELECT time FROM $feedname WHERE `time` = '$time'" | 1 |
|
| "INSERT INTO $feedname (time,data) VALUES ('$time','$value')" | 1 |
|
| "UPDATE $feedname SET data = '$value' WHERE `time` = '$time'" | 1 |
|
| "SELECT * FROM $feedname WHERE time = '$time' AND data2 = '$new_value'" | 1 |
|
| "INSERT INTO $feedname (time,data,data2) VALUES ('$time','0.0','$new_value')" | 1 |
|
| "UPDATE $feedname SET data = '$new_kwh' WHERE time = '$time' AND data2 = '$new_value'" | 1 |
|
| "SELECT data FROM $feedname WHERE `time` = '$time'" | 1 |
|
| "SELECT name, feedlist FROM multigraph WHERE `id`='$id'" | 1 |
|
| "DELETE FROM multigraph WHERE id=? AND userid=?" | 1 |
|
| "SELECT processList FROM input WHERE `id` = '$id'" | 1 |
|
| "Update flag file $backup_flag created. Update will start on next cron call in " . (60 - (time( ) % 60)) . "s..." | 1 |
|
| "UPDATE input SET processList=? WHERE id=?" | 1 |
|
| "SELECT id,userid,nodeid,name,description,processList FROM input WHERE `id` = '$inputid' ORDER BY nodeid,name asc" | 1 |
|
| "SELECT id,userid,nodeid,name,description,processList FROM input WHERE `userid` = '$userid' ORDER BY nodeid,name asc" | 1 |
|
| 'Delete an input' | 1 |
|
| 'Delete Input' | 1 |
|
| 'Show node key' | 1 |
|
| 'Select all %s inputs' | 1 |
|
| "Select all %s inputs" | 1 |
|
| 'Show device key' | 1 |
|
| "SELECT id,username,email,email_verified FROM users $searchstr ORDER BY $orderby $order " . $limit | 1 |
|
| "INSERT INTO multigraph (`userid`,`feedlist`, `name`) VALUES ('$userid','', 'New Multigraph')" | 1 |
|
| "SELECT * FROM feeds WHERE `userid`='$userid'" | 1 |
|
| "SELECT userid FROM feeds WHERE id=$feedid" | 1 |
|
| "select now() as datetime, time_format(timediff(now(),convert_tz(now(),@@session.time_zone,'+00:00')),'%H:%i') AS timezone" | 1 |
|
| "Update database" | 1 |
|
| 'Update Emoncms' | 1 |
|
| 'Update EmonHub' | 1 |
|
| 'Update Firmware' | 1 |
|
| 'Update Database' | 1 |
|
| 'Update Log' | 1 |
|
| "Update data point" | 1 |
|
| "SELECT COUNT(*) FROM " . $meta->table_name | 1 |
|
| 'Delete feed permanently' | 1 |
|
| "SELECT `apikey_read` FROM users WHERE `id`='$userid'" | 1 |
|
| "SELECT id,password,salt,apikey_write,admin,language,startingpage,email_verified,timezone FROM users WHERE username=?" | 1 |
|
| "SELECT id,password,salt,apikey_write,apikey_read FROM users WHERE username=?" | 1 |
|
| "SELECT id FROM users WHERE username=? AND email=?" | 1 |
|
| "UPDATE users SET username = ? WHERE id = ?" | 1 |
|
| "UPDATE users SET email = ? WHERE id = ?" | 1 |
|
| "SELECT username FROM users WHERE id = '$userid';" | 1 |
|
| "SELECT name FROM users WHERE id = '$userid';" | 1 |
|
| "SELECT email FROM users WHERE id = '$userid';" | 1 |
|
| "SELECT `apikey_write` FROM users WHERE `id`='$userid'" | 1 |
|
| "SELECT id,email_verified FROM users WHERE email=? AND verification_key=?" | 1 |
|
| "SELECT language FROM users WHERE id = '$userid';" | 1 |
|
| "SELECT salt FROM users WHERE id = '$userid'" | 1 |
|
| "SELECT id FROM users WHERE username = ?" | 1 |
|
| "UPDATE users SET language = ? WHERE id = ?" | 1 |
|
| "UPDATE users SET timezone = ? WHERE id = ?" | 1 |
|
| "SELECT id,username,email,gravatar,name,location,timezone,language,bio,startingpage,apikey_write,apikey_read,tags FROM users WHERE id=$userid" | 1 |
|
| "UPDATE users SET gravatar = ?, name = ?, location = ?, timezone = ?, language = ?, bio = ?, startingpage = ?, tags = ? WHERE id = ?" | 1 |
|
| 'Delete feed' | 1 |
|
| "UPDATE users SET apikey_write = ? WHERE id = ?" | 1 |
|
| "UPDATE users SET email_verified='1' WHERE id=?" | 1 |
|
| "UPDATE users SET verification_key=? WHERE id=?" | 1 |
|
| "UPDATE users SET preferences = ? WHERE id = ?" | 1 |
|
| "SELECT id,apikey_read,apikey_write FROM users WHERE id=$userid" | 1 |
|
| "SHOW TABLES LIKE '$table'" | 1 |
|
| "SHOW COLUMNS FROM `$table` LIKE '$field'" | 1 |
|
| 'Delete this dashboard' | 1 |
|
| "SELECT token FROM rememberme WHERE userid=? AND persistentToken=? LIMIT 1" | 1 |
|
| "INSERT INTO rememberme (userid, token, persistentToken, expire) VALUES (?,?,?,?)" | 1 |
|
| "DELETE FROM rememberme WHERE userid=? AND persistentToken=?" | 1 |
|
| "DELETE FROM rememberme WHERE userid=?" | 1 |
|
| "SELECT expire FROM rememberme WHERE userid=?" | 1 |
|
| "DELETE FROM rememberme WHERE userid=? AND expire=?" | 1 |
|
| "SELECT id,name FROM feeds WHERE userid=$userid" | 1 |
|
| "SELECT id,email,email_verified FROM users WHERE username=?" | 1 |
|
| "SELECT id,name FROM input WHERE userid=$userid" | 1 |
|
| "DELETE FROM users WHERE `id` = '$userid'" | 1 |
|
| "DELETE FROM $tablename WHERE `userid`='$userid'" | 1 |
|
| "SELECT id,username FROM users WHERE apikey_write=?" | 1 |
|
| "SELECT id,username FROM users WHERE apikey_read=?" | 1 |
|
| "SELECT id FROM users WHERE apikey_read=? OR apikey_write=?" | 1 |
|
| "SELECT * FROM users WHERE id = '$loginresult'" | 1 |
|
| "INSERT INTO users ( username, password, email, salt ,apikey_read, apikey_write, timezone, admin) VALUES (?,?,?,?,?,?,?,0)" | 1 |
|
| "UPDATE users SET admin = 1 WHERE id = '1'" | 1 |
|
| "SELECT id,username FROM users WHERE email = ?" | 1 |
|
| "UPDATE users SET apikey_read = ? WHERE id = ?" | 1 |
|
| "SELECT preferences FROM users WHERE id = ?" | 1 |
|
| "UPDATE feeds SET name = ? WHERE id = ?" | 1 |
|
| "SELECT id FROM feeds WHERE userid=? AND name=?" | 1 |
|
| "SELECT id FROM feeds WHERE userid=? AND BINARY name=? AND BINARY tag=?" | 1 |
|
| "SELECT id,engine FROM feeds WHERE `userid` = '$userid'" | 1 |
|
| "UPDATE feeds SET `size` = '$size' WHERE `id`= '$feedid'" | 1 |
|
| "SELECT id,name,userid,tag,datatype,public,size,engine,time,value,processList,unit FROM feeds WHERE `userid` = '$userid'" | 1 |
|
| "SELECT id FROM feeds WHERE `userid` = '$userid'" | 1 |
|
| "SELECT id,name,userid,tag,datatype,public,size,engine,processList FROM feeds WHERE `id` = '$id'" | 1 |
|
| "SELECT time,value FROM feeds WHERE `id` = '$id'" | 1 |
|
| "UPDATE feeds SET tag = ? WHERE id = ?" | 1 |
|
| "SELECT id FROM feeds WHERE userid=? AND id=?" | 1 |
|
| "UPDATE feeds SET unit = ? WHERE id = ?" | 1 |
|
| "UPDATE feeds SET public = ? WHERE id = ?" | 1 |
|
| "UPDATE feeds SET time = ?, value = ? WHERE id = ?" | 1 |
|
| "SELECT processList FROM feeds WHERE `id` = '$id'" | 1 |
|
| "UPDATE feeds SET processList=? WHERE id=?" | 1 |
|
| "SELECT * FROM feeds WHERE `userid` = '$userid'" | 1 |
|
| "SELECT engine FROM feeds WHERE `id` = '$feedid'" | 1 |
|
| 'Select the time range and interval that you wish to export: ' | 1 |
|
| 'Delete my account' | 1 |
|
| 'Select interval' | 1 |
|
| "SELECT id FROM feeds WHERE id = '$feedid'" | 1 |
|
| "UPDATE schedule SET expression = ? WHERE id = ?" | 1 |
|
| "SELECT id FROM schedule WHERE id = '$id'" | 1 |
|
| "SELECT * FROM schedule WHERE id = '$id'" | 1 |
|
| "SELECT `id`, `userid`, `name`, `expression`, `timezone`, `public`, CASE `userid` WHEN '$userid' THEN '1' ELSE '0' END AS `own` FROM schedule WHERE (userid = '$userid' OR public = '1')" | 1 |
|
| "SELECT `expression`, `timezone` FROM schedule WHERE id = '$id'" | 1 |
|
| "INSERT INTO schedule (`userid`,`name`,`expression`,`timezone`, `public`) VALUES ('$userid','New Schedule','','" . $this->timezone . "',0)" | 1 |
|
| "UPDATE schedule SET name = ? WHERE id = ?" | 1 |
|
| "UPDATE schedule SET public = ? WHERE id = ?" | 1 |
|
| "DELETE FROM schedule WHERE `id` = '$id'" | 1 |
|
| 'Update schedule' | 1 |
|
| "INSERT INTO feeds (userid,tag,name,datatype,public,engine,unit) VALUES (?,?,?,?,?,?,?)" | 1 |
|
| 'Delete schedule' | 2 |
|
| "SELECT id FROM schedule WHERE userid=? AND id=?" | 2 |
|
| "SELECT id FROM input WHERE userid=? AND id=?" | 2 |
|
| "SELECT COUNT(*) FROM users" | 2 |
|
| "DELETE FROM input WHERE userid = '$userid' AND id = '$inputid'" | 2 |
|
| "SELECT time, data FROM $table WHERE time BETWEEN ? AND ? ORDER BY time ASC LIMIT 1" | 2 |
|
| "SELECT time DIV $td AS time, AVG(data) AS data" . " FROM $table WHERE time BETWEEN $start AND $end" . " GROUP BY 1 ORDER BY time ASC" | 2 |
|
| 'Update All' | 2 |
|
| "SELECT time, data FROM $table" . " WHERE time BETWEEN $start AND $end ORDER BY time ASC" | 2 |
|
| "SELECT DISTINCT time, data FROM $table WHERE (" . " time = (SELECT min(time) FROM $table )" . "OR time = (SELECT max(time) FROM $table )" . ")" | 2 |
|
| 'Update Emoncms Only' | 2 |
|
| 'Update EmonHub Only' | 2 |
|
| "SELECT * FROM $tablename WHERE `userid`='$userid'" | 2 |
|
| 'Select your hardware type and firmware version' | 2 |
|
| 'Update Firmware Only' | 2 |
|
| "UPDATE users SET password = ?, salt = ? WHERE id = ?" | 2 |
|
| 'Update Database Only' | 2 |
|
| "DELETE FROM feeds WHERE `id` = '$feedid'" | 2 |
|
| "SELECT * FROM feeds WHERE `id` = '$id'" | 2 |
|
| "SELECT time, sum(data) as kWh FROM `$feedname` WHERE `data2`>='$min' AND `data2`<='$max' group by time" | 2 |
|
| "SELECT userid,datatype FROM feeds WHERE `id` = '$feedid'" | 2 |
|
| "SELECT password, salt FROM users WHERE id = '$userid'" | 2 |
|
| 'Show CSV Output' | 3 |
|
| 'Select all' | 3 |
|
| 'Delete permanently' | 3 |
|
| "SELECT timezone FROM users WHERE id = '$userid';" | 4 |
|