function getGameComments($key) { $key = mysql_escape_string($key); $rv = array(); $count = 0; $sql = "select l.*, u.username from log_comment l, users u where u.user_id = l.lc_pid and l.lc_key = '{$key}' order by l.lc_timestamp asc"; $result = mysql_query($sql); $total = mysql_num_rows($result); while ($count < $total) { $v = new mapCollectionCommentClass(); $v->setup(mysql_result($result, $count, "lc_timestamp"), mysql_result($result, $count, "lc_comment"), mysql_result($result, $count, "lc_pid"), mysql_result($result, $count, "lc_rating")); $v->setName(mysql_result($result, $count, "username")); $rv[$count] = $v; $count++; } return $rv; }
function mcGetComments($id) { $comments = array(); $id = mysql_escape_string($id); $sql = "select mc_pid, mc_rating, unix_timestamp(mc_timestamp) as mc_timestamp, mc_comment from map_comment where mc_mapid = '{$id}' order by mc_timestamp"; $result = mysql_query($sql); if ($result) { $total = mysql_num_rows($result); $count = 0; while ($count < $total) { $add = new mapCollectionCommentClass(); $add->setup(mysql_result($result, $count, "mc_timestamp"), mysql_result($result, $count, "mc_comment"), mysql_result($result, $count, "mc_pid"), mysql_result($result, $count, "mc_rating")); $add->setName(getPlayerName($add->getPid())); $comments[$count] = $add; $count++; } } return $comments; }