Oops!\r\n";
echo " \r\n\r\n\r\n";
echo "\r\n";
if(!empty($members->image))
{
$size=getimagesize("graphics/members/".$members->image);
echo "![](\"graphics/members/".$members-)
image."\" ".$size[3]." STYLE=\"margin-left:3px; margin-right:10px\">";
}
else
{
echo "![](\"graphics/members/no-image.png\")
";
}
echo " ";
echo "\r\n";
echo "";
if(!empty($members->address1))
{
echo $members->address1.", ";
}
if(!empty($members->address2))
{
echo $members->address2."";
}
echo "
".$members->town." ".$members->zip; if(!empty($members->province)) { echo " ".$members->province; } echo "\r\n"; echo "
\r\n"; if(!empty($members->tel)) { echo "Tel: ".$members->tel." ";} if(!empty($members->fax)) { echo "Fax: ".$members->fax." ";} if(!empty($members->cell)) { echo "Mobile: ".$members->cell." ";} if(!empty($members->email)) { echo "
Email: code."&id=".$members->uid."\">Click here";} if(!empty($members->web)) { echo " Website: uid."&link=".$members->web."\">Click here";} echo "\r\n"; echo " \r\n";
echo "\r\n\r\n";
$cnt++;
endwhile;
@mysql_close();
if($cnt==0) {
echo "
Sorry, but there are practitioners available in $country at the moment."; } } if($show==1) { // Just a variable that makes sure that if no // items are in the database, a little message is displayed $items=0; if(!isset($item)) {$item=0;} if($item!=0) { //Abfrage stellen $query="SELECT * FROM $tablename WHERE id='$item' LIMIT 5"; $db_abfrage=@mysql_query($query); $cnt=0; //Aus Tabelle lesen while ($result=@mysql_fetch_array($db_abfrage)) { $id=$result["id"]; $author=$result["author"]; $date=$result["date"]; $title= nl2br($result["title"]); $intro= nl2br($result["intro"]); $text=$result["text"]; $items++; // find the image references, their ALT tags and their alignment // all three elements are semi-colon separated, enclosed by curly brackets // Example: {myimage;This is a sample of an image;r} // Will show
$path ="graphics/library/";
$delimiter =";";
preg_match_all('/\{[\w\s,-;\"\'\.]*\}/', $text, $images);
foreach($images[0] as $k=>$v)
{
#echo "
" . $k . " = " . $v; $v2 = str_replace("{","",$v); $v2 = str_replace("}","",$v2); $img_name = trim(strtok($v2,$delimiter)); $img_alt = trim(strtok($delimiter)); $img_align = trim(strtok($delimiter)); if($img_align=="l"){ $img_align="align=\"left\""; } elseif($img_align=="r"){ $img_align="align=\"right\""; } elseif($img_align=="n"){ $img_align=""; } // Get the size of the image $size = getimagesize($path.$img_name); // Get the string that contains the height and width elements $hw = $size[3]; // Define Style sheet if($img_align=="right") { $style="style=\"border:1px solid maroon; padding:3px; margin:5px 0px 5px 10px\""; } if($img_align=="left") { $style="style=\"border:1px solid maroon; padding:3px; margin:5px 10px 5px 0px\""; } if($img_align=="none") { $style="style=\"border:1px solid maroon; padding:3px; margin:5px 0px 5px 0px\""; } $img = "![\"$img_alt\"](\"$path$img_name\" "\\"$img_alt\\"")
";
$text = str_replace($v , $img , $text);
}
?>
I couldn't connect to the database, and the query failed.
Please contact Helmar right away! Thanks."); $h1_text="
Members in $country
"; } if(isset($category)) { if($_REQUEST['category']!="practitioner") { $query=@mysql_query("SELECT * FROM $tablename WHERE active='1' AND code='$code' AND ".$_REQUEST['category']."='1' ORDER BY country ASC, lastname ASC" ) or die ("Oops!
I couldn't connect to the database, and the query failed.
Please contact Helmar right away! Thanks."); $h1_text="
Members in $country
"; } else { $query=@mysql_query("SELECT * FROM $tablename WHERE active='1' AND code='$code' AND ".$_REQUEST['category']."='1' ORDER BY country ASC, lastname ASC" ) or die ("Oops!
I couldn't connect to the database, and the query failed.
Please contact Helmar right away! Thanks."); $h1_text="
Practitioners in $country
"; # AND expires > CURDATE() } } else { $query=@mysql_query("SELECT * FROM $tablename WHERE active='1' AND code='$code' ORDER BY coordinator DESC , lastname ASC" ) or die ("Oops!
I couldn't connect to the database, and the query failed.
Please contact Helmar right away! Thanks."); $h1_text="
Member(s) in $country
"; } $location=""; $cnt=0; echo $h1_text; //Aus Tabelle lesen while ($members=@mysql_fetch_object($query)): if(substr($members->web,0,4)=="www.") { $members->web="http://".$members->web; } ?>
".$members->name." ".$members->lastname." (". ($members->coordinator==1 ? "Co-ordinator - " : "" ).
($members->teacher==1 ? "Teacher - " : "" ).
($members->practitioner==1 ? "Practitioner" : "").
")
\r\n";
echo "";
}
echo "".$members->town." ".$members->zip; if(!empty($members->province)) { echo " ".$members->province; } echo "\r\n"; echo "
\r\n"; if(!empty($members->tel)) { echo "Tel: ".$members->tel." ";} if(!empty($members->fax)) { echo "Fax: ".$members->fax." ";} if(!empty($members->cell)) { echo "Mobile: ".$members->cell." ";} if(!empty($members->email)) { echo "
Email: code."&id=".$members->uid."\">Click here";} if(!empty($members->web)) { echo " Website: uid."&link=".$members->web."\">Click here";} echo "\r\n"; echo "
\r\n";
echo '
';
echo "
| ';
echo 'Courses completed: '; echo "Vortex: ".($members->vortex_course=="0" ? '-' : ''.$members->vortex_course.''); echo " "; echo "BAT Module: ".($members->bat_course=="0" ? '-' : ''.$members->bat_course.''); echo ' |
';
echo 'Teaching level: '; echo "Vortex: ".($members->vortex_teach=="0" ? '-' : ''.$members->vortex_teach.''); echo " "; echo "BAT Module: ".($members->bat_teach=="0" ? '-' : ''.$members->bat_teach.''); echo ' |
';
echo 'Body Spin: '; echo "Practitioner: ".($members->bs_practitioner=="1" ? 'Yes' : 'No'); echo " "; echo "Teacher: ".($members->bs_teacher=="1" ? 'Yes' : 'No'); echo ' |
Sorry, but there are practitioners available in $country at the moment."; } } if($show==1) { // Just a variable that makes sure that if no // items are in the database, a little message is displayed $items=0; if(!isset($item)) {$item=0;} if($item!=0) { //Abfrage stellen $query="SELECT * FROM $tablename WHERE id='$item' LIMIT 5"; $db_abfrage=@mysql_query($query); $cnt=0; //Aus Tabelle lesen while ($result=@mysql_fetch_array($db_abfrage)) { $id=$result["id"]; $author=$result["author"]; $date=$result["date"]; $title= nl2br($result["title"]); $intro= nl2br($result["intro"]); $text=$result["text"]; $items++; // find the image references, their ALT tags and their alignment // all three elements are semi-colon separated, enclosed by curly brackets // Example: {myimage;This is a sample of an image;r} // Will show
$path ="graphics/library/";
$delimiter =";";
preg_match_all('/\{[\w\s,-;\"\'\.]*\}/', $text, $images);
foreach($images[0] as $k=>$v)
{
#echo "" . $k . " = " . $v; $v2 = str_replace("{","",$v); $v2 = str_replace("}","",$v2); $img_name = trim(strtok($v2,$delimiter)); $img_alt = trim(strtok($delimiter)); $img_align = trim(strtok($delimiter)); if($img_align=="l"){ $img_align="align=\"left\""; } elseif($img_align=="r"){ $img_align="align=\"right\""; } elseif($img_align=="n"){ $img_align=""; } // Get the size of the image $size = getimagesize($path.$img_name); // Get the string that contains the height and width elements $hw = $size[3]; // Define Style sheet if($img_align=="right") { $style="style=\"border:1px solid maroon; padding:3px; margin:5px 0px 5px 10px\""; } if($img_align=="left") { $style="style=\"border:1px solid maroon; padding:3px; margin:5px 10px 5px 0px\""; } if($img_align=="none") { $style="style=\"border:1px solid maroon; padding:3px; margin:5px 0px 5px 0px\""; } $img = "
[ By on ]
".stripslashes(str_replace("\r\n","\r\n\t\t
\r\n\t\t",$text))."";
}
@mysql_close();
}
}
?>