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;
}
