#
#RED DD7755 BLUE 7777DD GREEN 559955
$js_str = " ";
echo $js_str;
function jump_box(){
echo " ";
}
function featured_box(){
require("db_conn.php3");
$select_str = " SELECT *
FROM feat_orgs AS f, orgs AS o, cats AS c
WHERE f.org_id=o.org_id AND o.primary_cat=c.cat_id ORDER BY o.name";
$result = mysql_query($select_str);
echo " | . |
| Featured Orgs | ";
while($row = mysql_fetch_array($result)){
($row["neighbourhood"] == "" || $row["town"] == "") ? ($comma = "") : ($comma = ", ");
echo "
".$row["name"]."
".$row["neighbourhood"].$comma.$row["town"]." |
[";
echo "".$row["categories"]."";
echo "]
|
";
}
echo " Search Database!...
|
|
";
}
function login_box(){
echo " ";
}
function email_box(){
echo " ";
}
function newsletter_box(){
echo " ";
}
function friend_box(){
echo " ";
}
function news_box(){
require("db_conn.php3");
$select_str = "SELECT * FROM news ORDER BY date DESC LIMIT 5";
$result = mysql_query($select_str);
echo " | . |
| News Headlines |
*Use the Form at the Bottom to Add News Items.*
|
";
while($row = mysql_fetch_array($result)){
$mydate = split("-", $row["date"]);
echo "
| ".nl2br($row["title"])." |
| ".$row["source"]."
".$mydate[2]."/".$mydate[1]."/".$mydate[0]." |
";
if ($row["url"] && ($row["url"] != 'http://')){
echo "".nl2br($row["summary"])."";
} else {
echo nl2br($row["summary"]);
}
echo "
|
";
}
$mydate = date("Y-m-d", time());
echo " Browse the News Archive!...
|
";
/*echo "
Add Your News Item Below:
*Incorrectly Filled Forms Will Be Deleted*
*Please use this for NEWS ONLY, not REQUESTS for volunteers*
|
";
*/echo "
|
";
}
function books_boxS(){
require("db_conn.php3");
srand((double)microtime()*1000000);
$limit_start = rand(0,18); #upper limit for rand should be tot number of books less display size
$select_str = "SELECT * FROM books ORDER BY title LIMIT ".$limit_start.",4";
$result = mysql_query($select_str);
echo " | . |
| Bookstore |
 | ";
while($row = mysql_fetch_array($result)){
$mydate = split("-", $row["date"]);
echo "
![](book_images/".$row["image"].")
|
".$row["title"]." ".$mydate[0]."
[".nl2br($row["description"])."]
|
";
}
echo "
More Books!...
|
|
";
}
function insert_news(){
require("db_conn.php3");
$insert_str = "INSERT news(source, date, title, summary, url) VALUES(
'".$GLOBALS["source"]."',
'".$GLOBALS["date"]."',
'".$GLOBALS["title"]."',
'".$GLOBALS["summary"]."',
'".$GLOBALS["url"]."'
)";
$result = mysql_query($insert_str);
$to = "support@evolunteer.co.uk";
$subject = "News Item";
$message = "Details:
Source: ".$GLOBALS["source"]."
Date: ".$GLOBALS["date"]."
Title: ".$GLOBALS["title"]."
Summary: ".$GLOBALS["summary"]."
URL: ".$GLOBALS["url"]."
";
$from = "From:support@evolunteer.co.uk";
mail($to,$subject,$message,$from);
}
menu_bar("index");
echo "
eVolunteer.co.uk is the FREE online resource for recruiting volunteers internationally! Signup!... Read more...
";
?>
";
#echo "";
#echo "
";
login_box();
#echo "
";
#email_box();
#echo "
";
newsletter_box();
echo " |
";
news_box();
echo "
|
";
jump_box();
echo "
";
featured_box();
echo "
";
friend_box();
echo "
|
";
?>