Reply to thread

Message

<blockquote data-quote="Meap" data-source="post: 350666" data-attributes="member: 1553">Ive almost fixed my chatlogs to work with the azure structure but I'm stuck on this last bit for searching for the username, because in the azure chatlogs structure, it enters the user id and I cant think how to make it pull the username in this line of code, [CODE]&lt;?php&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $searchResults = null;if (isset($_GET['timeSearch'])){&nbsp; &nbsp; &nbsp; &nbsp; $_POST['searchQuery'] = $_GET['timeSearch'];&nbsp; &nbsp; &nbsp; &nbsp; $_POST['searchType'] = '4';}if (isset($_POST['searchQuery'])){&nbsp; &nbsp; &nbsp; &nbsp; $query = filter($_POST['searchQuery']);&nbsp; &nbsp; &nbsp; &nbsp; $type = $_POST['searchType'];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $q = &quot;SELECT * FROM users_chatlogs WHERE &quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; switch ($type)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; default:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; case '1':&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $q .= &quot;user_id = '&quot; . $query . &quot;'&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; break;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; case '2':&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $q .= &quot;message LIKE '%&quot; . $query . &quot;%'&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; break;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; case '3':&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $q .= &quot;room_id = '&quot; . $query . &quot;'&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; break;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; case '4':&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $cutMin = intval($query) - 300;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $cutMax = intval($query) + 300;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $q .= &quot;timestamp &gt;= &quot; . $cutMin . &quot; AND timestamp &lt;= &quot; . $cutMax;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $searchResults = mysql_query($q);}?&gt;[/CODE]any ideas? If more is needed I can post the whole chatlogs file I have for the HK?</blockquote>

[QUOTE="Meap, post: 350666, member: 1553"] Ive almost fixed my chatlogs to work with the azure structure but I'm stuck on this last bit for searching for the username, because in the azure chatlogs structure, it enters the user id and I cant think how to make it pull the username in this line of code, [CODE]<?php $searchResults = null; if (isset($_GET['timeSearch'])) { $_POST['searchQuery'] = $_GET['timeSearch']; $_POST['searchType'] = '4'; } if (isset($_POST['searchQuery'])) { $query = filter($_POST['searchQuery']); $type = $_POST['searchType']; $q = "SELECT * FROM users_chatlogs WHERE "; switch ($type) { default: case '1': $q .= "user_id = '" . $query . "'"; break; case '2': $q .= "message LIKE '%" . $query . "%'"; break; case '3': $q .= "room_id = '" . $query . "'"; break; case '4': $cutMin = intval($query) - 300; $cutMax = intval($query) + 300; $q .= "timestamp >= " . $cutMin . " AND timestamp <= " . $cutMax; } $searchResults = mysql_query($q); } ?>[/CODE] any ideas? If more is needed I can post the whole chatlogs file I have for the HK? [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members