\n\n"; $database="ambmembers"; #note: $Surg_ID_String in the following SQL statement is set by 1-Center_Info_Lookup.phtml $query1 = "SELECT DISTINCT Photo_Thumbnail " . "FROM members " . "WHERE OH_Visible=1 AND account_status='active' " . "AND Photo_Thumbnail <> '' AND Photo_Thumbnail_Ok = 'Yes' " . "AND $Surg_ID_String " . "ORDER BY Profile_Update_Date LIMIT 12"; #echo "query1 = $query1\n"; $q1start = getmicrotime(); $result1 = db_query_read($database,$query1); if (mysql_num_rows($result1) > 4) { echo ""; while($row1 = mysql_fetch_row($result1)) echo "\"\"\n"; mysql_free_result($result1); echo "\n"; echo "\n\n\n"; } $q1end = getmicrotime(); ?>

"; echo "\n"; echo ""; #Daniel removed an unused query here 08/05/2004 #-----------------------------------BEGIN Surgeons Associate------- echo "\n\n\n\n"; if ($Surgeon_ID_List != "" && count($Doc_ID_Array) > 0) { echo"
"; // build a query to get info on all docs in Surgeon_ID_list $Where_Clause = str_replace("Surgeon_ID", "Doc_Index_ID", $Surg_ID_String); $query3 = "SELECT Doc_Index_ID, Name_Full, First_Name, Last_Name, Cookie_Key FROM docs WHERE $Where_Clause ORDER BY Sponsor_Level DESC, Priority DESC"; $q3start = getmicrotime(); $result3 = db_query_read("obesitydocs", $query3); echo ""; $names_used = array(); while($row = mysql_fetch_row($result3)) { list($This_ID, $Name_Full, $fn, $ln, $ck) = $row; if(!in_array($Name_Full, $names_used)) { $docLink = "/morbidobesity/bariatric+surgeon+profile+"; if(strlen($fn) > 0 && strlen($ln) > 0) $docLink .= cleanName("$fn $ln"); else $docLink .= cleanName($Name_Full); $docLink .= "+" . encodeNumber($ck) . ".html"; echo " $Name_Full    
\n"; } $names_used[] = $Name_Full; } $q3end = getmicrotime(); mysql_free_result($result3); echo "
"; } echo "\n\n\n\n"; # ------BEGIN Recent message-------- $query5 = "SELECT Mod_Must_Approve FROM users WHERE User_ID = '$cat' LIMIT 1"; $mod = ""; $q5start = getmicrotime(); $rs = db_query_read("ohusers", $query5); $q5end = getmicrotime(); if(mysql_num_rows($rs) > 0) list($mod) = mysql_fetch_row($rs); if ($mod == "Yes") $modstatus = "p.Mod_Status = 'approved' AND"; else $modstatus = "p.Mod_Status <> 'witheld' AND"; #use this if no moderation needed mysql_free_result($rs); if(strlen($cat) > 0 && strlen($Owner) > 0 && strtoupper($cat) != strtoupper($Owner)) $OwnerClause = "p.Owner IN ('" . mysql_escape_string($cat) . "', '" . mysql_escape_string($Owner) . "')"; elseif(strlen($cat) > 0) $OwnerClause = "p.Owner = '" . mysql_escape_string($cat) . "'"; elseif(strlen($Owner) > 0) $OwnerClause = "p.Owner = '" . mysql_escape_string($Owner) . "'"; else $OwnerClause = ""; #should never happen! $whereclause = trim("$modstatus $OwnerClause"); $query6 = "SELECT p.Post_ID, p.Poster_ID, p.Post_Date, p.Category, p.Content, p.Angel_ID, " . "a1.First_Name, a1.Last_Name, a2.First_Name, a2.Last_Name, " . "IF(a1.Photo_Thumbnail_OK = 'Yes', a1.Photo_Thumbnail, NULL) " . "FROM posts p " . "INNER JOIN ambmembers.members a1 ON p.Poster_ID = a1.Member_ID AND a1.account_status='active' " . "LEFT OUTER JOIN ambmembers.members a2 ON p.Angel_ID = a2.Member_ID AND a2.account_status='active' " . "WHERE $whereclause ORDER BY Post_Date DESC LIMIT 2"; $q6start = getmicrotime(); $rs = db_query_read("wlsposts", $query6); $q6end = getmicrotime(); $num = mysql_num_rows($rs); if($num > 0) { echo "

\n"; echo "\n"; echo "
\n"; } while($row = mysql_fetch_row($rs)) { list($Post_ID, $Poster_ID, $Post_Date, $Category, $Content, $Angel_ID, $mFirst_Name, $mLast_Name, $aFirst_Name, $aLast_Name, $Photo_Thumbnail) = $row; $Post_Date_F = date("m/d h:i A", $Post_Date); $Poster_Name = htmlentities(getAMOSDisplayName($mFirst_Name, $mLast_Name)); $Photo_Thumbnail = cleanPhotoPath($Photo_Thumbnail); $Pt_Name = htmlentities(getAMOSDisplayName($aFirst_Name, $aLast_Name)); echo "\n\n\n\n"; if (!is_null($Photo_Thumbnail) && $Poster_Name != $Last_Poster && $Photo_Thumbnail) echo "\"Photo"; echo "$Post_Date_F
\n"; if ($Category == "Angels-Update" || $Category == "Angels") echo "[From the surgery page of $Pt_Name]   "; if ($Category == "Angels-Update") echo ""; echo strip_all_tags($Content, ""); echo "     — $Poster_Name

"; if ($Category == "Angels-Update") echo "
"; echo "
\n"; $Last_Poster = $Poster_Name; } if($num > 0) { echo "
\n


"; } mysql_free_result($rs); # ----------------------------End Recent message----------------- // Note: $State2, $City2, $City1 defined in header.txt if(strlen($State2) > 0 && strlen($City2) > 0) echo "
Local Information for $City1

\n"; echo "\n\n\n\n\n"; echo "
\n"; # --------------------BEGIN SURGERY TODAY----------------------- echo "\n\n\n\n"; $database8 = "ambmembers"; $query8 = "SELECT su.display_name, Member_ID " . "FROM members m " . "INNER JOIN " . SYS_DATABASE . ".sys_user su ON su.legacy_id = m.Member_ID " . "WHERE Postclin_Surg_Date_Y = '" . date("Y") . "' " . "AND Postclin_Surg_Date_D = '" . date("m") . "' " . "AND Postclin_Surg_Date_M = '" . date("d") . "' " . "AND OH_Visible=1 AND m.account_status='active' AND $Surg_ID_String"; $q8start = getmicrotime(); $result8 = db_query_read($database8, $query8); $num8 = mysql_num_rows($result8); if ($num8 >0) { echo "
\n"; echo "\n"; echo ""; while($row8 = mysql_fetch_row($result8)) { list($name, $Member_ID) = $row8; $Member_Name = htmlentities($name); echo "\n\n"; echo "\n\n"; } echo "\n"; echo "
 $Member_Name   " . date("F j") . "
 
\n"; echo "
\n"; echo " 
\n"; } $q8end = getmicrotime(); mysql_free_result($result8); # -------------------end surgery------------------------- # ----------------------Begin Newest Members---------------------- echo "\n\n\n\n"; $database9="ambmembers"; $query9 = "SELECT su.display_name, City, State, show_location, Member_ID " . "FROM members m " . "INNER JOIN " . SYS_DATABASE . ".sys_user su ON su.legacy_id = m.member_id " . "WHERE $Surg_ID_String AND OH_Visible=1 AND m.account_status='active' " . "ORDER BY Signup_Date DESC LIMIT 6"; $q9start = getmicrotime(); $result9 = db_query_read($database9,$query9); $num9 = mysql_num_rows($result9); #echo ""; $i=0; if($num9 >0) { echo "
\n"; echo "\n"; echo ""; while($row9 = mysql_fetch_row($result9)) { list($name, $City, $State, $show_location, $Member_ID) = $row9; $Member_Name = htmlentities($name); $City = properCase($City); if(strlen(trim($State)) == 2) $State = strtoupper($State); echo "\n\n"; echo "\n\n"; } echo "\n"; echo "
 $Member_Name  ".(intval($show_location) == 1 ? "$City, $State" : "")."
 
\n"; echo "
\n"; //echo" 
"; } $q9end = getmicrotime(); mysql_free_result($result9); # ----------------------End Newest Members---------------------- # --------------------BEGIN SURGERY----------------------- echo "\n\n\n\n"; echo " 
"; #echo "Surgery dates this month:
"; $database10 = "ambmembers"; $query10 = "SELECT su.display_name, Member_ID, Postclin_Surg_Date_M " . "FROM members m " . "INNER JOIN " . SYS_DATABASE . ".sys_user su ON su.legacy_id = m.member_id " . "WHERE Postclin_Surg_Date_Y = '" . date("Y") . "' " . "AND Postclin_Surg_Date_D = '" . date("m") . "' " . "AND OH_Visible=1 AND $Surg_ID_String AND m.account_status='active' " . "ORDER BY Postclin_Surg_Date_M"; $q10start = getmicrotime(); $result10 = db_query_read($database10, $query10); $num10 = mysql_num_rows($result10); if ($num10 >0) { echo "
\n"; echo "\n"; echo ""; while($row10 = mysql_fetch_row($result10)) { list($name, $Member_ID, $Surg_Day) = $row10; $Member_Name = htmlentities($name); if(substr($Surg_Day,0,1) == "0") $Surg_Day = substr($Surg_Day, 1); echo "\n\n"; echo "\n\n"; } echo "\n"; echo "
 $Member_Name  " . date("M") . " $Surg_Day
 
\n"; echo "
\n"; echo " 
\n"; } $q10end = getmicrotime(); mysql_free_result($result10); # -------------------end surgery------------------------- # --------------------BEGIN Anniversaries this month------------------------ echo "\n\n\n\n"; #echo "
Anniversaries this month:
"; $database11 = "ambmembers"; $query11 = "SELECT su.display_name, Member_ID, Postclin_Surg_Date_M, Postclin_Surg_Date_Y " . "FROM members m " . "INNER JOIN " . SYS_DATABASE . ".sys_user su ON su.legacy_id = m.member_id " . "WHERE Postclin_Surg_Date_Y <> '" . date("Y") . "' " . "AND Postclin_Surg_Date_D = '" . date("m") . "' " . "AND OH_Visible=1 AND $Surg_ID_String AND m.account_status='active' " . "ORDER BY Postclin_Surg_Date_M"; $q11start = getmicrotime(); $result11 = db_query_read($database11, $query11); $num11 = mysql_num_rows($result11); if ($num11 >0) { echo "
\n"; echo "\n"; echo ""; while($row11 = mysql_fetch_row($result11)) { list($name, $Member_ID, $Surg_Day, $Surg_Year) = $row11; $Member_Name = htmlentities($name); if(substr($Surg_Day,0,1) == "0") $Surg_Day = substr($Surg_Day, 1); echo "\n"; echo "\n"; echo "\n"; echo "\n"; } echo "\n"; echo "
 $Member_Name(" . date("m") . "/$Surg_Day/$Surg_Year)
 
\n"; echo "
\n"; echo " 
\n"; } $q11end = getmicrotime(); mysql_free_result($result11); # -------------------------------------------- ?>