".$data[0][name]."![](files/flag_images/big/".$data[0][big_image].")
"; } function event_data($niid){ // $items[] = l(''.$niid , 'node/'. $niid,''); // print theme('node_list', $items, ''); // unset($items); $qr="select * from event where nid=".$niid; $rs =mysql_query($qr); $trow=mysql_num_rows($rs); $data =mysql_fetch_array($rs); return $data; } function node_data($niid){ // unset($items); $qr="select * from node where nid=".$niid; $rs =mysql_query($qr); $trow=mysql_num_rows($rs); $data =mysql_fetch_array($rs); return $data; //return "body".$niid; } function node_bod($niid){ // unset($items); $qr="select * from node_revisions where nid=".$niid; $rs =mysql_query($qr); $trow=mysql_num_rows($rs); $data =mysql_fetch_array($rs); return $data; //return "body".$niid; } function node_extra($niid){ // unset($items); $qr="select * from content_type_event where nid=".$niid; $rs =mysql_query($qr); $trow=mysql_num_rows($rs); $data =mysql_fetch_array($rs); return $data; //return "body".$niid; } //print event using nid function print_events($eventarr){ foreach($eventarr as $niid){ $eve_data=event_data($niid); $node_data=node_data($niid); $node_bod=node_bod($niid); $node_extra=node_extra($niid); $eventdata.="
"; if($eve_data[event_end]) $eventdata.="End: ".date('l, j/m/Y h:i:s A',$eve_data[event_end])."
"; $eventdata.="
"; $eventdata.="Fees: ".$node_extra[field_fees_value]."
"; $eventdata.="Location: ".$node_extra[field_location_value]."
"; $eventdata.="Phone: ".$node_extra[field_phone_value]."
"; $eventdata.="Email Address: ".$node_extra[field_address_0_format]."
"; } return $eventdata; } //get event of user function get_events_by_uid($usrdata){ $nidarr=array(); foreach($usrdata as $uid){ $qr="select nid from node where type='event' and uid=".$uid; $rs =mysql_query($qr); $trow=mysql_num_rows($rs); if($trow>0){ while($dg=mysql_fetch_array($rs)) $nidarr[]=$dg[nid]; } } return $nidarr; } // get id by GET methode $stateid=$_GET[stateid]; if(chk_state($stateid)){ /////main if //print flag nad state name print getFlag($stateid); //15 is the adjustment factor careful $fiid=15+$stateid; $qry="SELECT uid FROM `profile_values` where fid=".$fiid." and value=1 order by uid"; $rs=mysql_query($qry); $num=mysql_num_rows($rs); if($num>0){ //start if 00 while($dt=mysql_fetch_array($rs)) $usrdata[]=$dt['uid']; //call the event listing of created by each user $event_nid_arry= get_events_by_uid($usrdata); // print "This is final array of events belongs to state id: ".$stateid.'
'; // print "
"; } function event_data($niid){ // $items[] = l(''.$niid , 'node/'. $niid,''); // print theme('node_list', $items, ''); // unset($items); $qr="select * from event where nid=".$niid; $rs =mysql_query($qr); $trow=mysql_num_rows($rs); $data =mysql_fetch_array($rs); return $data; } function node_data($niid){ // unset($items); $qr="select * from node where nid=".$niid; $rs =mysql_query($qr); $trow=mysql_num_rows($rs); $data =mysql_fetch_array($rs); return $data; //return "body".$niid; } function node_bod($niid){ // unset($items); $qr="select * from node_revisions where nid=".$niid; $rs =mysql_query($qr); $trow=mysql_num_rows($rs); $data =mysql_fetch_array($rs); return $data; //return "body".$niid; } function node_extra($niid){ // unset($items); $qr="select * from content_type_event where nid=".$niid; $rs =mysql_query($qr); $trow=mysql_num_rows($rs); $data =mysql_fetch_array($rs); return $data; //return "body".$niid; } //print event using nid function print_events($eventarr){ foreach($eventarr as $niid){ $eve_data=event_data($niid); $node_data=node_data($niid); $node_bod=node_bod($niid); $node_extra=node_extra($niid); $eventdata.="
"; $eventdata.="".$node_data['title'].""; $eventdata.="
"; if($eve_data[event_start]) $eventdata.="Start: ".date('l, j/m/Y h:i:s A',$eve_data[event_start]).""; if($eve_data[event_end]) $eventdata.="End: ".date('l, j/m/Y h:i:s A',$eve_data[event_end])."
"; $eventdata.="
".$node_bod[body]."
"; $eventdata.="Contact Name: ".$node_extra[field_conatct_name_value].""; $eventdata.="Fees: ".$node_extra[field_fees_value]."
"; $eventdata.="Location: ".$node_extra[field_location_value]."
"; $eventdata.="Phone: ".$node_extra[field_phone_value]."
"; $eventdata.="Email Address: ".$node_extra[field_address_0_format]."
"; } return $eventdata; } //get event of user function get_events_by_uid($usrdata){ $nidarr=array(); foreach($usrdata as $uid){ $qr="select nid from node where type='event' and uid=".$uid; $rs =mysql_query($qr); $trow=mysql_num_rows($rs); if($trow>0){ while($dg=mysql_fetch_array($rs)) $nidarr[]=$dg[nid]; } } return $nidarr; } // get id by GET methode $stateid=$_GET[stateid]; if(chk_state($stateid)){ /////main if //print flag nad state name print getFlag($stateid); //15 is the adjustment factor careful $fiid=15+$stateid; $qry="SELECT uid FROM `profile_values` where fid=".$fiid." and value=1 order by uid"; $rs=mysql_query($qry); $num=mysql_num_rows($rs); if($num>0){ //start if 00 while($dt=mysql_fetch_array($rs)) $usrdata[]=$dt['uid']; //call the event listing of created by each user $event_nid_arry= get_events_by_uid($usrdata); // print "This is final array of events belongs to state id: ".$stateid.'
'; // print "
";
print print_events($event_nid_arry);
// print "";
}
else{
print "No records found...";
}
///end if 00
}
else{ ///// else of mail if
print "Invalid State Id...";
}
?>