com web/master: Used the wrong timestamp in the votes search query.: manage/user-notes.php
| From: | Sherif Ramadan | Date: | Sat, 15 Dec 2012 14:01:40 +0000 |
| Subject: | com web/master: Used the wrong timestamp in the votes search query.: manage/user-notes.php | ||
| Groups: | php.webmaster | ||
| Request: | Send a blank email to php-webmaster+get-15097@lists.php.net to get a copy of this message | ||
Commit: de4ed2a2441e546035e4a7f0c0aaf91491dc42c9
Author: Sherif Ramadan <googleguy@php.net> 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 ".