Online!"; } else { $statiol = "Offline"; } //code for fav friend checking $sqlm = "SELECT * FROM `fav_friends` WHERE `me` = '$urid' AND `fav_frd` = '$user_id'"; $resultm = mysql_query($sqlm) or die('Error, query failed ' . mysql_error()); $countb = mysql_num_rows($resultm); if($countb == 0) { $bookm = 'no'; }else{ $bookm = 'yes'; } $last_login = $row['timestamp']; $pv = $row['pv']; $ag = $row['age']; $joined = $row['joined']; list($jyear, $jmonth, $jday) = explode("-", $joined); $jday = $jday; $jmonth = $jmonth; $jyear = $jyear; $jmonth_name = date( 'F', mktime(0, 0, 0, $jmonth) ); $birth_day = $row['birth_day']; list($year, $month, $day) = explode("-", $birth_day); $day = $day; $month = $month; $year = $year; $month_name = date( 'F', mktime(0, 0, 0, $month) ); $city = $row['city']; //Generating Personal information data for user $queryp = "SELECT * FROM personal_info WHERE user_id = '$user_id'"; $resultp = mysql_query($queryp) or die('Error, query failed : ' . mysql_error()); $rowp = mysql_fetch_array($resultp); $here_for = $rowp['here_for']; $zodiac = $rowp['zodiac']; $language = $rowp['languages']; $children = $rowp['child']; $education = $rowp['education']; $occupation = $rowp['occupation']; $about_me = $rowp['about_me']; $mstatus = $rowp['status']; $str1 = str_replace("\'", "'", $about_me); $about_me = str_replace('\"', '"', $str1); //Generating life style information for user $queryl = "SELECT * FROM lifestyle_info WHERE user_id = '$user_id'"; $resultl = mysql_query($queryl) or die('Error, query failed : ' . mysql_error()); $rowl = mysql_fetch_array($resultl); $home = $rowl['about_home']; $str1 = str_replace("\'", "'", $home); $home = str_replace('\"', '"', $str1); $work = $rowl['about_work_place']; $str1 = str_replace("\'", "'", $work); $work = str_replace('\"', '"', $str1); $ideal = $rowl['ideal_home']; $str1 = str_replace("\'", "'", $ideal); $ideal = str_replace('\"', '"', $str1); $pets = $rowl['pets']; $str1 = str_replace("\'", "'", $pets); $pets = str_replace('\"', '"', $str1); $philo = $rowl['philosophy']; $str1 = str_replace("\'", "'", $philo); $philo = str_replace('\"', '"', $str1); $hope = $rowl['hope']; $str1 = str_replace("\'", "'", $hope); $hope = str_replace('\"', '"', $str1); $bugs = $rowl['bugs']; $str1 = str_replace("\'", "'", $bugs); $bugs = str_replace('\"', '"', $str1); $ins = $rowl['inspirations']; $str1 = str_replace("\'", "'", $ins); $ins = str_replace('\"', '"', $str1); $scares = $rowl['scares']; $str1 = str_replace("\'", "'", $scares); $scares = str_replace('\"', '"', $str1); $traveled = $rowl['traveled']; $str1 = str_replace("\'", "'", $traveled); $traveled = str_replace('\"', '"', $str1); //Generating Professional information for user $querypr = "SELECT * FROM professional_info WHERE user_id = '$user_id'"; $resultpr = mysql_query($querypr) or die('Error, query failed : ' . mysql_error()); $rowpr = mysql_fetch_array($resultpr); $work_place = $rowpr['work_place']; $str1 = str_replace("\'", "'", $work_place); $work_place = str_replace('\"', '"', $str1); $profession = $rowpr['profession']; $str1 = str_replace("\'", "'", $profession); $profession = str_replace('\"', '"', $str1); $job_title = $rowpr['job_title']; $str1 = str_replace("\'", "'", $job_title); $job_title = str_replace('\"', '"', $str1); $qualification = $rowpr['qualification']; $str1 = str_replace("\'", "'", $qualification); $qualification = str_replace('\"', '"', $str1); $exp = $rowpr['exp']; $str1 = str_replace("\'", "'", $exp); $exp = str_replace('\"', '"', $str1); // Generating Favorites info for the user $queryp = "SELECT * FROM favorites_info WHERE user_id = '$user_id'"; $resultp = mysql_query($queryp) or die('Error, query failed : ' . mysql_error()); $rowp = mysql_fetch_array($resultp); $role = $rowp['role']; $str1 = str_replace("\'", "'", $role); $role = str_replace('\"', '"', $str1); $quot = $rowp['quot']; $str1 = str_replace("\'", "'", $quot); $quot = str_replace('\"', '"', $str1); $book = $rowp['book']; $str1 = str_replace("\'", "'", $book); $book = str_replace('\"', '"', $str1); $music = $rowp['music']; $str1 = str_replace("\'", "'", $music); $music = str_replace('\"', '"', $str1); $movie = $rowp['movie']; $str1 = str_replace("\'", "'", $movie); $movie = str_replace('\"', '"', $str1); $tv = $rowp['tv']; $str1 = str_replace("\'", "'", $tv); $tv = str_replace('\"', '"', $str1); $food = $rowp['food']; $str1 = str_replace("\'", "'", $food); $food = str_replace('\"', '"', $str1); $place = $rowp['place']; $str1 = str_replace("\'", "'", $place); $place = str_replace('\"', '"', $str1); $live = $rowp['live']; $str1 = str_replace("\'", "'", $live); $live = str_replace('\"', '"', $str1); //PMs information $sqltoii = "SELECT * FROM pms WHERE id_t = '$user_id' ORDER BY id DESC"; $resulttoii = mysql_query($sqltoii) or die('Error, query failed to : ' . mysql_error()); $cntii = mysql_num_rows($resulttoii); $sqltoi = "SELECT * FROM pms WHERE id_t = '$user_id' AND status = '0' ORDER BY id DESC"; $resulttoi = mysql_query($sqltoi) or die('Error, query failed to : ' . mysql_error()); $cnti = mysql_num_rows($resulttoi); // friends request $queryc = "SELECT * FROM friends WHERE frd2 = '$user_id' AND status = '0'"; $resultc = mysql_query($queryc) or die('Error, query failed : ' . mysql_error()); $cnt = mysql_num_rows($resultc); //This code is responsible for user photo $queryph = "SELECT * FROM pre_avatar WHERE user_id = '$user_id'"; $resultph = mysql_query($queryph) or die('Error, query failed : ' . mysql_error()); $picount = mysql_num_rows($resultph); function CalculateAge($BirthDate) { // Put the year, month and day in separate variables list($Year, $Month, $Day) = explode("/", $BirthDate); $YearDiff = date("Y") - $Year; // If the birthday hasn't arrived yet this year, the person is one year younger if(date("m") < $Month || (date("m") == $Month && date("d") < $DayDiff)) { $YearDiff--; } return $YearDiff; } ?> <?=ucwords($user_name);?> games, free online games - GamesBunch.com
HomeCommunity
ALL GAMES