function get_drudb_uid($sid, $dbconn)
{
if (!$dbconn) {
$dbconn = get_drudb_connection();
}
$query = "select uid from drusessions where sid = '{$sid}'";
$result = mysql_query($query);
if (!$result) {
return False;
}
$toret = "";
while ($res = mysql_fetch_assoc($result)) {
$toret = $res["uid"];
}
return $toret;
}
<?php
/* Gives the user id for the logged in user and puts that information on the variable $userid. */
//TODO: Call the described functions in the documentation for retreiving the user id.
// $userid = '247';
$userid = '';
require_once 'cb_backend/db_lib.php';
//check for the cookie from untoldthegame.com site
if (isset($_COOKIE["SESSf11d1277d21527f42a2c13ff12d4cffc"])) {
$sess_id = $_COOKIE["SESSf11d1277d21527f42a2c13ff12d4cffc"];
//query the database based on the session id to get the associated userid
if (strlen($sess_id) > 0) {
$the_real_userid = get_drudb_uid($sess_id, get_drudb_connection());
}
if (strlen($the_real_userid) > 0) {
$userid = $the_real_userid;
}
}
