Commit: de4ed2a2441e546035e4a7f0c0aaf91491dc42c9 Author: Sherif Ramadan <[email protected]> Sat, 15 Dec 2012 09:01:40 -0500 Parents: 63290154e7df51c6e8a3b5969c6ebaf020fc4e0d Branches: master
Link: http://git.php.net/?p=web/master.git;a=commitdiff;h=de4ed2a2441e546035e4a7f0c0aaf91491dc42c9 Log: Used the wrong timestamp in the votes search query. Changed paths: M manage/user-notes.php Diff: diff --git a/manage/user-notes.php b/manage/user-notes.php index 8315ea8..31198cd 100644 --- a/manage/user-notes.php +++ b/manage/user-notes.php @@ -121,7 +121,7 @@ if (!$action) { $search_votes = true; // set this only to change the output between votes table and notes table if (!empty($_GET['votesip'])) { $searchip = (int) ip2long(filter_var(html_entity_decode($_GET['votesip'], ENT_QUOTES, 'UTF-8'), FILTER_VALIDATE_IP)); - $sql = "SELECT votes.id, UNIX_TIMESTAMP(note.ts) AS ts, votes.vote, votes.note_id, note.sect, votes.hostip, votes.ip ". + $sql = "SELECT votes.id, UNIX_TIMESTAMP(votes.ts) AS ts, votes.vote, votes.note_id, note.sect, votes.hostip, votes.ip ". "FROM votes ". "JOIN(note) ON (votes.note_id = note.id) ". "WHERE hostip = $searchip OR ip = $searchip ". -- PHP Webmaster List Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
