# #RED DD7755 BLUE 7777DD GREEN 559955 $js_str = " "; echo $js_str; function jump_box(){ echo "
.
Find a Volunteering Opportunity!
"; } 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 "
. "; while($row = mysql_fetch_array($result)){ ($row["neighbourhood"] == "" || $row["town"] == "") ? ($comma = "") : ($comma = ", "); echo " "; } echo "
Featured Orgs
".$row["name"]."
".$row["neighbourhood"].$comma.$row["town"]."
["; echo "".$row["categories"].""; echo "]

Search Database!...

"; } function login_box(){ echo "
.
Organisation Login
Username:
Password:

Or, Signup for an Account!

Forgotten Password?

"; } function email_box(){ echo "
.
Check Email
Username:
Password:
Or, Signup for an Account!
"; } function newsletter_box(){ echo "
.
Volunteer Login
Your Email:
Or, Signup as a Volunteer!

"; } function friend_box(){ echo "
.
Tell a Friend!
Friend's Email:
"; } function news_box(){ require("db_conn.php3"); $select_str = "SELECT * FROM news ORDER BY date DESC LIMIT 5"; $result = mysql_query($select_str); echo "
. "; while($row = mysql_fetch_array($result)){ $mydate = split("-", $row["date"]); echo " "; } $mydate = date("Y-m-d", time()); echo " "; /*echo " "; */echo "
News Headlines
*Use the Form at the Bottom to Add News Items.*
".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 "

Browse the News Archive!...

Add Your News Item Below:
*Incorrectly Filled Forms Will Be Deleted*
*Please use this for NEWS ONLY, not REQUESTS for volunteers*
News Source (e.g. The Guardian):

Title:

Summary (first 2-3 lines):

URL/Web Address (Optional):

"; } 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 "
. "; while($row = mysql_fetch_array($result)){ $mydate = split("-", $row["date"]); echo " "; } echo "
Bookstore

".$row["title"]." ".$mydate[0]."

[".nl2br($row["description"])."]


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 "
"; ?>