\n";
if ( $count % 2 == 0 and $breakem) $old_row .= "
\n";
$last_id = $row[id];
}
$out .= $old_row;
break;
case 1:
if (mysql_num_rows($result) == 0){
$out[] = array("firstn" => "Open", "lastn"=>"");
} else {
while ($row = mysql_fetch_assoc($result)) {
$years_string = "";
$sql = "SELECT * FROM years WHERE member_id = " . $row[id];
$db_link_years = mysql_connect(DATABASE_HOST, DATABASE_USERNAME, DATABASE_PASSWORD) or die(mysql_error() . ", line" . __LINE__);
$result_years= mysql_db_query($database, $sql, $db_link) or die(mysql_error() . ", line" . __LINE__);
while ($year_row = mysql_fetch_assoc($result_years)) {
$years_string .= ($year_row['year'] > 1900)?"'" . substr($year_row['year'], 2) . " ":"";
}
$row['years'] = $years_string;
$out[] = $row;
}
}
break;
}
return $out;
}
function adm_listing($committee) {
// Pass in $committee first, and $member (optional) second
// committees are as listed in "listing()", above
//
// If $committee == 'by_name', then the listing is selected based on the
// first name and last name passed in with $committee
//
// IMPORTANT:
// $member can be one of
// ('all', 'chair', 'vice_chair', 'secretary', 'treasurer', OR 'regional_liason')
//
global $PHP_SELF, $page, $committee_id;
$host = 'data.wse.jhu.edu';
$db_user = 'alumni';
$db_password = 'seadevusr';
$database = 'alumni';
// $member = preg_replace("/_/", " ", $member);
if ($committee == 'by_name') {
if (func_num_args() != 3) die("You MUST supply BOTH firstn and lastn args if the first arg is 'by_name'!");
$firstn = func_get_arg(1);
$lastn = func_get_arg(2);
$sql = "select *";
$sql .= "from personal p, years y ";
$sql .= "where y.member_id = p.id ";
if ( $firstn != '') $sql .= " and firstn like '%$firstn%' ";
if ( $lastn != '') $sql .= " and lastn like '%$lastn%' ";
} else {
if (func_num_args() == 2) $member = func_get_arg(1);
switch ( $member ) {
case "chair":
$listing = " and cs.description = 'Chair' ";
break;
case "vice_chair":
$listing = " and cs.description = 'Vice Chair' ";
break;
case "secretary":
$listing = " and cs.description = 'Secretary' ";
break;
case "treasurer":
$listing = " and cs.description = 'Treasurer' ";
break;
case "regional_liason":
$listing = " and cs.description = 'Regional Liason' ";
break;
case "all":
default;
$listing = " and (cm.standing = '' or cm.standing is null ) ";
// $listing = " ";
}
/*
$sql = "select *";
$sql .= "from personal p, committee_memberships cm, committees c, years y ";
$sql .= "where cm.member_id = p.id and y.member_id = p.id and ";
$sql .= " cm.committee_id = c.committee_id and c.committee_id in ('$committee') ";
$sql .= $listing;
$sql .= " order by lastn";
*/
$sql = "select * from personal p
LEFT OUTER JOIN committee_memberships cm ON p.id = cm.member_id
LEFT OUTER JOIN committee_standings cs ON cm.standing_id = cs.standing_id
LEFT OUTER JOIN committees c ON c.committee_id = cm.committee_id
LEFT OUTER JOIN years y ON p.id = y.member_id
WHERE (c.committee_id in ('$committee') OR c.committee_id IS NULL)
$listing";
}
$sql .= " order by p.lastn";
$fonto = "";
$fontc = "";
$db_link = mysql_connect(DATABASE_HOST, DATABASE_USERNAME, DATABASE_PASSWORD) or die(mysql_error() . ", line" . __LINE__);
$result = mysql_db_query($database, $sql, $db_link) or die(mysql_error() . ", line" . __LINE__);
$last_id = 'START';
while ($row = mysql_fetch_assoc($result)) {
$bgcolor=($count++ % 2 == 1)?"bgcolor='#cccccc'":""; // alternate gray rows
foreach ($row as $key=>$val){
$row[$key] = ($val)?$val:"n/a";
}
$old_row .= "
\n";
}
} else {
$out .= format_site_map($leaves, $level);
}
}
return $out;
}
function setup_site_map_array(){
// Use this function to create the array of all pages with their parent pages
// PASS THIS IN AS AN ARG TO setup_site_map_tree()
$database = CONTENT_DATABASE;
$sql = "SELECT
page_info_id AS id
, parent_page_iD AS parent_id
, page_info.*
FROM page_info
WHERE page_is_approved = 1
AND show_on_site_map = 1
ORDER BY page_info_id, page_title
";
$db_link = mysql_connect(DATABASE_HOST, DATABASE_USERNAME, DATABASE_PASSWORD) or die(mysql_error() . " in setup_site_map_array() , line " . __LINE__);
$result = mysql_db_query($database, $sql, $db_link) or die(mysql_error() . " in setup_site_map_array() , line " . __LINE__);
$i = 0;
while ($row = mysql_fetch_assoc($result) ){
$row['process_id'] = $i;
$out[$i] = $row;
$out[$i][0] = $row;
$i++;
$last_page_info_id = $row['page_info_id'];
}
// Hand-edited external links come from the array $SITE_MAP_EXTERNAL in include/config/vars.inc
// They get added here
$items = $last_page_info_id + 1;
foreach ($GLOBALS['SITE_MAP_EXTERNAL'] as $new_item){
$new_item[0] = $new_item;
$new_item['id'] = $items++;
$new_item['parent_page_id'] = $new_item['parent_id'] ;
array_push($out, $new_item);
}
// print_r($out);
// print_r($GLOBALS['SITE_MAP_EXTERNAL']);
//////////////
return $out;
}
?>
no data source, set all values by hand. Useful for one-off pages.
* 1 (default) => Use database "$datbase_name" as database. (This defaults to "alumni").
* 2
* $database_name is the name of the databses. Defaults to "alumni".
* It is important that you *do* set tag values if you use ($source = 0) or you will get errors!
* Use the method setContentTag(), below!
*
* getContentTag( $tagName )
* setContentTag( $tagName )
* tagName for the last two methods is the name of the tag. You can use
* getTagList(1) to get the list of available tag names as an array
* getTagList( $format )
* returns list of current available tags
* foramt is determined as follows:
* 0 (default) => return sorted, space-delimited list
* 1 => return list as sorted array
* 2 => return list as sorted *associative* array
* setContentFromSource( $pageName, $source )
* Private function
* Sets all the content for the given page. pageName can be the name of the
* page (the directory where the page lives) or the row_id of the page in
* the database.
*
* VARIABLES
* =========
*
* USAGE
* =====
* To instantiate the class, call
* $pc = new PageContent("name_of_page"); // name_of_page is meant to be a unique identifier. The directory in which the page resides is good.
*
* Then set the data inside the instance:
* $pc->setContent("page_name");
* "page_name" should be the unique name of the page; we are using the name
* of the directory for the page. This will be a unique field in the
* database.
*
* To print or use the content, do:
* echo $pc->getContentTag("tagname");
* or, for example, for use with a bTemplate instance called "$bt", do:
* $bt->set("tagname", $pc->getContentTag("tagname"));
*
* If you are not sure what the tags are, you can use the following:
* $pc->getTagList(1);
* like so:
* foreach ($pc->getTagList(1) as $tagname){
* $bt->set($tagname, $pc->getContentTag($tagname);
* }
*/
class SiteContent {
var $tags; // array which holds the tagnames and their values
var $database;
var $db_host;
var $db_username;
var $db_password;
var $db_link;
// var $safe_mode;
/* Function: SiteContent()
* Constructor function for this class sets the default database to "alumni"
* and initializes the class with the source data.
*/
function SiteContent($pageIdentifier, $source = 1, $safe_mode=1, $database = CONTENT_DATABASE, $db_host = DATABASE_HOST, $db_username = DATABASE_USERNAME, $db_password = DATABASE_PASSWORD, $admin_mode = 0 ){
$this->tags = array();
$this->database = $database;
$this->db_host = $db_host;
$this->db_username = $db_username;
$this->db_password = $db_password;
$this->db_link = mysql_connect($this->db_host, $this->db_username, $this->db_password) or die("Could not connect : " . mysql_error());
$this->safe_mode = $safe_mode;
$this->admin_mode = $admin_mode;
$this->setPageList();
$this->setTemplateList();
$this->setPageInfoIdList();
$this->setContentFromSource($pageIdentifier, $source);
mysql_close($this->db_link);
}
function pageIsEditable(){
return $this->tags['page_is_editable'];
}
function pageIsApproved(){
return $this->tags[page_is_approved];
}
function pageIsChanged(){
return $this->tags[page_is_changed];
}
function getTag( $tagName ){
return $this->getContentTag($tagName);
}
function getContentTag( $tagName ){
return $this->tags[$tagName];
}
function getPageInfoIdList() {
return $this->page_info_id_list;
}
function getTemplateName(){
// DEBUG
// echo "Template in function: " . $this->tags["template_name"] . " ";
return ($this->tags["template"]) ? $this->tags["template"] : FALSE;
}
function setContentTag( $tagName, $value, $tf = NULL ){
$this->tags[$tagName] = $value;
// if (isset($tf)) $this->tags['tf'] = $tf;
}
function setVar( $varName, $value ){
$this->$varName = $value;
return;
}
function getVar( $varName ){
return $this->$varName;
}
function getTagList( $format = 1 ){
$list = array_keys($this->tags);
sort($list);
switch ($format){
case 0:
$out = join($list, " ");
break;
default:
case 1:
$out = $list;
break;
case 2:
foreach ($this->tags as $key => $val){
$out[$key] = $val;
}
break;
}
return $out;
}
function getPageList( $format = 0 ){
unset($out);
$home = array(
'page_info_id' => '0'
, 'page_name' => 'home'
, 'template_id' => '1'
, 'template' => 'index1.tpl'
, 'page_title' => 'Home Page'
, 'page_body' => ''
, 'nav_rollover_text' => ''
, 'meta_keywords' => ''
, 'meta_description' => ''
, 'parent_page_id' => ''
, 'blurb' => ''
, 'date_changed' => ''
, 'date_created' => ''
, 'page_is_editable' => ''
, 'page_is_approved' => ''
, 'page_is_changed' => ''
, 'sort_order' => ''
);
switch ($format) {
default:
case 0:
$out[] = $home;
foreach ($this->page_list as $rownum => $row) {
$out[] = $row;
}
break;
case 1:
$out[] = $home;
foreach ($this->page_list as $rownum => $row) {
$out[] = join(", ", $row);
}
break;
}
return $out;
}
function getTemplateList( $format = 0 ){
unset($out);
switch ($format) {
default:
case 0:
foreach ($this->template_list as $rownum => $row) {
$out[] = $row;
}
break;
case 1:
foreach ($this->template_list as $rownum => $row) {
$out[] = join(", ", $row);
}
break;
}
return $out;
}
/* "Private" Methods. (Of course, "private" is not enforced in PHP) */
/* function: setContentFromSource
* This function is the one that will have to change when the data is
* migrated to a database (from a data file). Possible sources: 0 == from file,
* 1 == from db
*/
function setContentFromSource( $pageIdentifier, $source){
if (isset($pageIdentifier) and ($pageIdentifier != '' and $pageIdentifier != '0')){
switch ($source){
case 0:
$this->tags = array("nulltag"=>"");
break;
case 1:
/* Connecting, selecting database */
$link = $this->db_link;
mysql_select_db($this->database) or die("Could not select database. MySQL Error: " . mysql_error() . " in private method setContentFromSource().");
/* Performing SQL query */
$sitecontentsql = "
SELECT
page_url as name
, page_filename as filename
, page_body as body
, page_title as title
, pi.*
, IF(page_is_approved = 1, 'YES', 'NO') as page_is_approved
, DATE_FORMAT( pi.date_changed , '%d-%b-%Y' ) as date_changed
, t.template_name as template
, t.description as template_description
FROM page_info pi
LEFT OUTER JOIN templates t ON pi.template_id = t.template_id
";
//if ($_SERVER["REMOTE_ADDR"] == '128.220.42.136') { echo $sitecontentsql; exit; }
if (is_numeric($pageIdentifier)){
$sitecontentsql .= " WHERE page_info_id = $pageIdentifier ";
} else {
$sitecontentsql .= " WHERE page_url = '$pageIdentifier' AND page_is_approved = 1";
}
// DEBUG
// echo "
$sitecontentsql
";
$sitecontentresult = mysql_query($sitecontentsql) or die("Query failed : " . mysql_error());
/* Printing results in HTML */
while ($sitecontentrow = mysql_fetch_assoc($sitecontentresult)) {
// echo $this->safe_mode;
if (is_file(CONTENT_DIR . "/" . $sitecontentrow['name'] . ".inc") ){
// $sitecontentrow['body'] = file_get_contents(CONTENT_DIR . "/" . $sitecontentrow['filename']);
if ( $this->safe_mode ) {
$sitecontentrow['body'] = ob_get_contents();
} else {
/* I am removing the 'body' setup from the constructor
* For speed reasons. Set up body manually after the $site object
* has been created, that way the 'body' is only processed once
ob_start();
include(CONTENT_DIR . "/" . $sitecontentrow['filename']);
$sitecontentrow['body'] = ob_get_contents();
ob_end_clean();
*/
}
}
if( is_file(CONTENT_DIR . "/" . $sitecontentrow['page_filename']) ){
$sitecontentrow["page_last_updated"] = date("M j, Y", filemtime(CONTENT_DIR . "/" . $sitecontentrow['page_filename']));
}
$page_name = $sitecontentrow['name'];
$tags[$page_name] = $sitecontentrow;
}
/* Free resultset */
// mysql_free_result($sitecontentresult);
/* Closing connection */
// mysql_close($link);
break;
case 2:
default:
include(INCLUDE_DIR . "/content_array.inc");
break;
}
} else { // Set default (blank) page content
$page_name="nopage";
$link = $this->db_link;
$fields = mysql_list_fields($this->database, "page_info", $link);
$columns = mysql_num_fields($fields);
for ($i = 0; $i < $columns; $i++) {
$sitecontentrow[mysql_field_name($fields, $i)] = "";
}
$tags[$page_name]=$sitecontentrow;
$tags[$page_name]['page_is_editable']=true;
}
$content = $tags[$page_name];
$this->tags = $content;
}
function setTemplateList(){
/* Connecting, selecting database */
$link = $this->db_link;
mysql_select_db($this->database) or die("Could not select database. MySQL Error: " . mysql_error() . " in private method setContentFromSource().");
/* Performing SQL query */
$sitecontentsql = "
SELECT
*
FROM templates
WHERE template_type_id = 2
";
$sitecontentresult = mysql_query($sitecontentsql) or die("Query failed : " . mysql_error());
while ($row = mysql_fetch_assoc($sitecontentresult)) {
$out[] = $row;
}
// mysql_free_result($sitecontentresult);
// mysql_close($link);
$this->template_list = $out;
return;
}
function setPageList( $format = 0 ){
/* Connecting, selecting database */
$link = $this->db_link;
mysql_select_db($this->database) or die("Could not select database. MySQL Error: " . mysql_error() . " in private method setContentFromSource().");
/* Performing SQL query */
$sitecontentsql = "
SELECT
*
, IF(page_is_approved = 1, 'YES', 'NO') as page_is_approved
FROM page_info p
";
$sitecontentresult = mysql_query($sitecontentsql) or die("Query failed : " . mysql_error());
unset($out);
$out[0] = array();
while ($row = mysql_fetch_assoc($sitecontentresult)) {
// Bugfix: 21-MAR-2006. Now using the page_info_id as the index for page_list. Hopefully this
// will just be a bug FIX and not break anything else!
// JDS, 21-MAR-2006
$out[$row['page_info_id']] = $row;
}
/* Free resultset */
// mysql_free_result($sitecontentresult);
/* Closing connection */
// mysql_close($link);
$this->page_list = $out;
return;
}
function setPageInfoIdList() {
// Returns a list of all available page_info_id's, for use in further queries, if need be.
$sitecontentsql = "select page_info_id from page_info";
/* Connecting, selecting database */
$link = $this->db_link;
mysql_select_db($this->database) or die("Could not select database. MySQL Error: " . mysql_error() . " in private method setContentFromSource().");
$sitecontentresult = mysql_query($sitecontentsql) or die("Query failed : " . mysql_error());
while ($row = mysql_fetch_assoc($sitecontentresult) ) {
$out[] = $row['page_info_id'];
}
$this->page_info_id_list = $out;
return;
}
function setPageHiearchy(){
// Creates an array that lists the pages "above" the current page and includes the current page.
}
}
?>