function get_user_col($id, $col) { validate_user_id($id); $con = db_connect(); $result = mysql_query("SELECT {$col} FROM users WHERE id={$id})"); if (mysql_num_rows($result) > 0) { $val = mysql_result($result, 0); db_close($con); return $row[$col]; } else { db_close($con); return null; } }
function get_post_id($userid, $title, $content) { validate_user_id($userid); $content = mysql_real_escape_string($content); $title = mysql_real_escape_string($title); $con = db_connect(); $sql = "SELECT id FROM posts WHERE user={$userid} AND content='{$content}' AND title='{$title}' ORDER BY posttime DESC"; $result = mysql_query($sql); if (mysql_num_rows($result) > 0) { $id = mysql_result($result, 0); } else { $id = null; } db_close($con); return $id; }
function get_comment_id($userid, $postid, $parentid, $content) { validate_user_id($userid); $content = mysql_real_escape_string($content); $con = db_connect(); $sql = "SELECT id FROM comments WHERE user={$userid} AND content='{$content}' AND postparent={$postid}"; if ($parentid === null) { $sql = $sql . " AND parent IS NULL"; } else { $sql = $sql . " AND parent={$parentid}"; } $sql = $sql . " ORDER BY posttime DESC"; $result = mysql_query($sql); if (mysql_num_rows($result) > 0) { $id = mysql_result($result, 0); } else { $id = null; } db_close($con); return $id; }