Example #1
0
function getStreamByObject($object)
{
    $query = "SELECT * FROM MSTREAMT WHERE oid={$object} ORDER BY(sid) DESC";
    $result = mysql_query($query);
    $ret = "<table class='table' style='width:300px;'>";
    while ($row = mysql_fetch_array($result)) {
        $o = getObject($row["oid"]);
        $id = $row["oid"];
        $im = getImgUri($o["oimgid"]);
        $ret .= "<tr><td>" . $row["message"] . "</td><td>" . dateify($row["postedon"]) . "</td></tr>";
    }
    $ret .= "</table>";
    return $ret;
}
Example #2
0
function showProf($oid)
{
	
	$imgid=mysql_query("select * from MOBJECTT where oid='$oid'");
	while($img=mysql_fetch_array($imgid))
	{
		$obname =$img['obname'];
		$opwd=$img['opwd'];
		$image=$img['oimgid'];
		$otyid=$img['otyid'];
		$obhandle=$img['obhandle'];
	}
	
	
	$obj=mysql_query("select * from OTYPET where tyid='$otyid'");
	while($object=mysql_fetch_array($obj))
	{	
		$table=$object['tytab'];
		$matcher=$object['matcher'];
	}
	$ob=mysql_query("select * from ".$table." where ".$matcher."=".$obhandle);
	while($mat=mysql_fetch_array($ob))
	{
		$bio=$mat[3];
	}
	
	$imgurl=mysql_query("select imguri from MIMGT where imgid='$image'");
	while($imgur=mysql_fetch_array($imgurl))
	{
		$imguri="../".$imgur[0];
	}
	if($otyid == "2")
	{
		//echo "select (select imguri from MIMGT i where i.imgid=s.imgid) as imguri from MSUBJECTT s where subcode='".$obhandle."'";
		$array1 = queryMe("select (select imguri from MIMGT i where i.imgid=s.imgid) as imguri from MSUBJECTT s where subid='".$obhandle."'");
		$imguri = "../".$array1["imguri"];
		//echo $obhandle;
		$wr = queryMe("select subname from MSUBJECTT where subid like '".$obhandle."'");
		$subname = $wr["subname"];
		if(getImgUri($image)=="images/others/book.jpg")
		{
			echo "<a href='../core/immapind.php?subid=".$obhandle."' target='_blank' class='nyroModal' title='Select A Book For ".$subname."'>Find Book Cover</a>";
		//echo "<a href='../core/immapind.php?subid=".$obhandle."'&KeepThis=true&TB_iframe=true&#TB_inline class='thickbox'> Find Book Cover</a><br/>";
		}
		
	}
	list($width, $height, $type, $attr) = getimagesize($imguri);
	if($width>$height)
	{
		$width=200;
		$height=150;
	}
	else if($width<$height)
	{
		$width=150;
		$height=200;
	}	
	else
	{	
		$width=200;
		$height=200;
		
	}
	
echo "<img src='$imguri' width='$width' height='$height' border='1'/>";
echo "<h3>$obname</h3>";

}