All pastes #525398 Raw Edit

psilo

public text v1 · immutable
#525398 ·published 2007-05-31 10:47 UTC
rendered paste body
$sql_queryb="select * from messages_system where ((folder='binbox')||(folder='bsaved')) and type='message' and frm_id!='$m_id' order by date desc limit 5";
$p458=sql_execute($sqlqueryb,'num');
$p45=sql_execute($sql_queryb,'get');
if($p458!=0) {
while($catye=mysql_fetch_object($p45)){
$p46=$catye->frm_id;
} }
$sql_queryc="select frd_id from network where mem_id='$m_id' and frd_id='$p46'";
$p358=sql_execute($sqlqueryc,'num');
$p35=sql_execute($sql_queryc,'get');
if($p358!=0) {
while($caty=mysql_fetch_object($p35)){
$p36=$caty->frm_id; 
} }

$sql_query="select * from messages_system where ((folder='binbox')||(folder='bsaved')) and type='message' and frm_id='$p36' order by date desc limit 5";
$res=sql_execute($sql_query,'res');
$num=sql_execute($sql_query,'num');
		
		if($num!=0) { ?>

                <tr>
                <form action='index.php' method='post'>
                <input type='hidden' name='mode' value='messages'>
                <input type='hidden' name='act' value='mes_list'>
                <input type='hidden' name='refer' value='sent'>
                <input type='hidden' name='pro' value=''>
<?
                          while($mes=mysql_fetch_object($res)){
                              $sent=date("m/d/y h:i A",$mes->date);
						 echo "<!--";
									 $n=count_network($m_id,"1","ar");
									 echo "-->";
										$f=1;
										$i=0;
									do {
										$pos=strpos($n,"icon_arrow_blue.gif");
										if ($pos){
										$n = substr ($n,$pos+1);
										$i++;
										}else {$f=0;}
									}while($f==1);
								if (($i>0) or ($m_id==$mes->frm_id)){
                              echo "<tr>";
                              //echo"<td><input type='checkbox' name='mes_id[]' value='$mes->mes_id'></td>";
                              // echo "<td>&nbsp</td>";
                              echo "<td bgcolor=\"#ffffff\"><a href='index.php?mode=people_card&p_id=$mes->frm_id'>";
							  echo "<table class='body2' vasilek><tr><td class=lined>";show_photo($mes->frm_id);echo "</br>";
                              echo "<td valign=top bgcolor=\"#ffffff\"><strong><a href='index.php?mode=messages&act=view_mes&mes_id=$mes->mes_id'>$mes->subject</a></strong></br>";
							  echo "Posted on $sent</td></table>";
					}
                         }//while

?>
</form>
           <? }
           else {
           echo "<tr><td align=center>".$GLOBALS['word'][54]."/Under Construction</td></tr>";
           } ?>