Location: PHPKode > projects > ViperWeb Portal System > httpdocs/modules/Admin/modules/encyclopedia.php
<?php

/************************************************************************/
/* ViperWeb: Web Portal System                                          */
/* ===========================                                          */
/*                                                                      */
/* Copyright (c) 2002 by Raptr & Godboko                                */
/* http://development.ea-hq.net                                         */
/*                                                                      */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License.       */
/*                                                                      */
/* Based on PHP-Nuke found at http://www.phpnuke.org                    */
/************************************************************************/



$result = sql_query("select radminency, radminsuper from ".$prefix."_users where aid='$aid'", $dbi);
list($radminency, $radminsuper) = sql_fetch_row($result, $dbi);
if (($radminency==1) OR ($radminsuper==1)) {

/*********************************************************/
/* Sections Manager Functions                            */
/*********************************************************/

function alpha($eid) {
    global $module_name, $prefix, $dbi;
    $alphabet = array ("A","B","C","D","E","F","G","H","I","J","K","L","M",
                       "N","O","P","Q","R","S","T","U","V","W","X","Y","Z");
    $num = count($alphabet) - 1;
    echo "<center>[ ";
    $counter = 0;
    while (list(, $ltr) = each($alphabet)) {
	$result = sql_query("select * from ".$prefix."_encyclopedia_text where eid='$eid' AND UPPER(title) LIKE '$ltr%'", $dbi);
	if (sql_num_rows($result) > 0) {
	    echo "<a href=\"index.php?mod=Admin&op=encyclopedia_terms&eid=$eid&ltr=$ltr\">$ltr</a>";
	} else {
	    echo "$ltr";
	}
        if ( $counter == round($num/2) ) {
            echo " ]\n<br>\n[ ";
        } elseif ( $counter != $num ) {
            echo "&nbsp;|&nbsp;\n";
        }
        $counter++;
    }
    echo " ]</center><br><br>\n\n\n";
}

function encyclopedia() {
    global $prefix, $dbi, $language, $multilingual, $bgcolor2;
    include("includes/admin/header.php");
    GraphicAdmin();
    title(""._ENCYCLOPEDIAMANAGER."");
    OpenTable();
    echo "<table border=\"0\" width=\"100%\"><tr>"
	."<td bgcolor=\"$bgcolor2\"><b>"._TITLE."</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>"._TERMS."</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>"._CURRENTSTATUS."</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>"._FUNCTIONS."</b></td></tr>";
    $result = sql_query("select * from ".$prefix."_encyclopedia order by eid", $dbi);
    while($ency = sql_fetch_array($result, $dbi)) {
	$num = sql_num_rows(sql_query("select * from ".$prefix."_encyclopedia_text WHERE eid='$ency[eid]'", $dbi), $dbi);
	if ($ency[active] == 1) {
	    $status = _ACTIVE;
	    $status_chng = _DEACTIVATE;
	    $active = 1;
	} else {
	    $status = "<i>"._INACTIVE."</i>";
	    $status_chng = _ACTIVATE;
	    $active = 0;
	}
	echo "<tr><td><a href=\"index.php?mod=Encyclopedia&op=list_content&eid=$ency[eid]\">$ency[title]</a></td><td align=\"center\">$num</td><td align=\"center\">$status</td><td align=\"center\">[ <a href=\"index.php?mod=Admin&op=encyclopedia_edit&eid=$ency[eid]\">"._EDIT."</a> | <a href=\"index.php?mod=Admin&op=encyclopedia_change_status&eid=$ency[eid]&active=$active\">$status_chng</a> | <a href=\"index.php?mod=Admin&op=encyclopedia_delete&eid=$ency[eid]\">"._DELETE."</a> ]</td></tr>";
    }
    echo "</table>";
    CloseTable();
    echo "<br>";
    OpenTable();
    echo "<center><b>"._ADDNEWENCYCLOPEDIA."</b></center><br><br>"
	."<form action=\"index.php?mod=Admin\" method=\"post\">"
	."<b>"._TITLE.":</b><br>"
	."<input type=\"text\" name=\"title\" size=\"50\"><br><br>"
	."<b>"._DESCRIPTION.":</b><br>"
	."<textarea name=\"description\" cols=\"60\" rows=\"10\"></textarea><br><br>";
    if ($multilingual == 1) {
	echo "<br><b>"._LANGUAGE.": </b>"
	    ."<select name=\"elanguage\">";
	$handle=opendir('language');
	while ($file = readdir($handle)) {
	    if (preg_match("/^lang\-(.+)\.php/", $file, $matches)) {
	        $langFound = $matches[1];
		$languageslist .= "$langFound ";
	    }
	}
	closedir($handle);
	$languageslist = explode(" ", $languageslist);
	sort($languageslist);
	for ($i=0; $i < sizeof($languageslist); $i++) {
	    if($languageslist[$i]!="") {
	        echo "<option value=\"$languageslist[$i]\" ";
	        if($languageslist[$i]==$language) echo "selected";
		echo ">".ucfirst($languageslist[$i])."</option>\n";
	    }
	}
	echo "</select><br><br>";
    } else {
	echo "<input type=\"hidden\" name=\"elanguage\" value=\"$language\">";
    }
    echo "<b>"._ACTIVATEPAGE."</b><br>"
	."<input type=\"radio\" name=\"active\" value=\"1\" checked>&nbsp;"._YES."&nbsp&nbsp;<input type=\"radio\" name=\"active\" value=\"0\">&nbsp;"._NO."<br><br>"
	."<input type=\"hidden\" name=\"op\" value=\"encyclopedia_save\">"
	."<input type=\"submit\" value=\""._SEND."\">"
	."</form>";
    CloseTable();
    $result = sql_query("select eid, title from ".$prefix."_encyclopedia", $dbi);
    if (sql_num_rows($result, $dbi) > 0) {
	echo "<br>";
	OpenTable();
	echo "<center><b>"._ADDNEWENCYTERM."</b></center><br><br>"
	    ."<form action=\"index.php?mod=Admin\" method=\"post\">"
	    ."<b>"._TITLE.":</b><br>"
	    ."<input type=\"text\" name=\"title\" size=\"50\"><br><br>"
	    ."<b>"._TERMTEXT.":</b><br>"._PAGEBREAK."<br>"
	    ."<textarea name=\"text\" cols=\"60\" rows=\"20\"></textarea><br><br>";
	if ($multilingual == 1) {
	    echo "<br><b>"._LANGUAGE.": </b>"
		."<select name=\"elanguage\">";
	    $handle=opendir('language');
	    while ($file = readdir($handle)) {
		if (preg_match("/^lang\-(.+)\.php/", $file, $matches)) {
	    	    $langFound = $matches[1];
		    $languageslist .= "$langFound ";
		}
	    }
	    closedir($handle);
	    $languageslist = explode(" ", $languageslist);
	    sort($languageslist);
	    for ($i=0; $i < sizeof($languageslist); $i++) {
		if($languageslist[$i]!="") {
	    	    echo "<option value=\"$languageslist[$i]\" ";
	    	    if($languageslist[$i]==$language) echo "selected";
		    echo ">".ucfirst($languageslist[$i])."</option>\n";
		}
	    }
	    echo "</select><br><br>";
	} else {
	    echo "<input type=\"hidden\" name=\"elanguage\" value=\"$language\">";
	}
	echo "<b>"._ENCYCLOPEDIA.":</b><br><select name=\"eid\">";
	while(list($eid, $title) = sql_fetch_row($result, $dbi)) {
	    echo "<option value=\"$eid\" name=\"eid\">$title</option>";
	}
	echo "</select><br><br>"
	    ."<input type=\"hidden\" name=\"op\" value=\"encyclopedia_text_save\">"
	    ."<input type=\"submit\" value=\""._ADD."\">"
	    ."</form>";
	CloseTable();

    }
    $result = sql_query("select eid, title from ".$prefix."_encyclopedia", $dbi);
    $result2 = sql_query("select eid, title from ".$prefix."_encyclopedia", $dbi);
    if (sql_num_rows($result, $dbi) > 1) {
	echo "<br>";
	OpenTable();
	echo "<center><b>"._MOVETERMS."</b><br><br>"
	    ."<form action=\"index.php?mod=Admin\" method=\"post\">"
	    .""._MOVEALLTERMSFROM.": <select name=\"eid\">";
	while(list($eid, $title) = sql_fetch_row($result, $dbi)) {
	    echo "<option name=\"eid\" value=\"$eid\">$title";
	}
	echo "</select> "._TO.": <select name=\"new_eid\">";
	while(list($eid, $title) = sql_fetch_row($result2, $dbi)) {
	    echo "<option name=\"new_eid\" value=\"$eid\">$title";
	}    
	echo "</select>&nbsp;&nbsp;"
	    ."<input type=\"hidden\" name=\"op\" value=\"move_terms\">"
	    ."<input type=\"submit\" value=\""._SAVECHANGES."\">"
	    ."</form></center>";
	CloseTable();
    }
    include("includes/admin/footer.php");
}

function encyclopedia_edit($eid) {
    global $prefix, $dbi, $language, $multilingual, $bgcolor2;
    include("includes/admin/header.php");
    GraphicAdmin();
    title(""._ENCYCLOPEDIAMANAGER."");
    $result = sql_query("select * from ".$prefix."_encyclopedia WHERE eid='$eid'", $dbi);
    $ency = sql_fetch_array($result, $dbi);
	if ($ency[active] == 1) {
	    $sel1 = "checked";
	    $sel2 = "";
	} else {
	    $sel1 = "";
	    $sel2 = "checked";
	}
    OpenTable();
    echo "<center><b>"._EDITENCYCLOPEDIA."</b></center><br><br>"
	."<form action=\"index.php?mod=Admin\" method=\"post\">"
	."<b>"._TITLE.":</b><br>"
	."<input type=\"text\" name=\"title\" size=\"50\" value=\"$ency[title]\"><br><br>"
	."<b>"._DESCRIPTION.":</b><br>"
	."<textarea name=\"description\" cols=\"60\" rows=\"10\">$ency[description]</textarea><br><br>";
    if ($multilingual == 1) {
	echo "<br><b>"._LANGUAGE.": </b>"
	    ."<select name=\"elanguage\">";
	$handle=opendir('language');
	while ($file = readdir($handle)) {
	    if (preg_match("/^lang\-(.+)\.php/", $file, $matches)) {
	        $langFound = $matches[1];
		$languageslist .= "$langFound ";
	    }
	}
	closedir($handle);
	$languageslist = explode(" ", $languageslist);
	sort($languageslist);
	for ($i=0; $i < sizeof($languageslist); $i++) {
	    if($languageslist[$i]!="") {
	        echo "<option value=\"$languageslist[$i]\" ";
	        if($languageslist[$i]==$language) echo "selected";
		echo ">".ucfirst($languageslist[$i])."</option>\n";
	    }
	}
	echo "</select><br><br>";
    } else {
	echo "<input type=\"hidden\" name=\"elanguage\" value=\"$ency[elanguage]\">";
    }
    echo "<b>"._ACTIVATEPAGE."</b><br>"
	."<input type=\"radio\" name=\"active\" value=\"1\" $sel1>&nbsp;"._YES."&nbsp&nbsp;<input type=\"radio\" name=\"active\" value=\"0\" $sel2>&nbsp;"._NO."<br><br>"
	."<input type=\"hidden\" name=\"eid\" value=\"$ency[eid]\">"
	."<input type=\"hidden\" name=\"op\" value=\"encyclopedia_save_edit\">"
	."<input type=\"submit\" value=\""._SAVECHANGES."\">"
	."</form>";
    CloseTable();
    echo "<br>";
    OpenTable();
    echo "<center><b>"._ENCYTERMSEDIT."</b></center><br><br>";
    alpha($eid);
    CloseTable();
    include("includes/admin/footer.php");
}

function encyclopedia_terms($eid, $ltr) {
    global $prefix, $dbi;
    include("includes/admin/header.php");
    GraphicAdmin();
    title(""._ENCYCLOPEDIAMANAGER."");
    $result = sql_query("select title from ".$prefix."_encyclopedia where eid='$eid' AND UPPER(title) LIKE '%$ltr%'", $dbi);
    list($title) = sql_fetch_row($result, $dbi);
    title("$title");
    OpenTable();
	echo "<center>"._SELECTONETERM."</center><br><br>"
	    ."<table border=\"0\" align=\"center\">";
	$result = sql_query("select tid, title from ".$prefix."_encyclopedia_text WHERE UPPER(title) LIKE '$ltr%' AND eid='$eid'", $dbi);
	if (sql_num_rows($result, $dbi) == 0) {
	    echo "<center><i>"._NOCONTENTFORLETTER." $ltr.</i></center>";
	}
	while(list($tid, $title) = sql_fetch_row($result, $dbi)) {
	    echo "<tr><td><a href=\"index.php?mod=Admin&op=encyclopedia_text_edit&tid=$tid\">$title</a></td></tr>";
	}
	echo "</table><br><br>";
	alpha($eid);
	echo "<center>"._GOBACK."</center>";
    CloseTable();
    include("includes/admin/footer.php");
}

function encyclopedia_text_edit($tid) {
    global $prefix, $dbi, $language, $multilingual, $bgcolor2;
    include("includes/admin/header.php");
    GraphicAdmin();
    title(""._ENCYCLOPEDIAMANAGER."");
    $result = sql_query("select * from ".$prefix."_encyclopedia_text WHERE tid='$tid'", $dbi);
    $ency = sql_fetch_array($result, $dbi);
    OpenTable();
    echo "<center><b>"._ENCYTERMSEDIT."</b></center><br><br>"
	."<form action=\"index.php?mod=Admin\" method=\"post\">"
	."<b>"._TITLE.":</b><br>"
	."<input type=\"text\" name=\"title\" size=\"50\" value=\"$ency[title]\"><br><br>"
	."<b>"._TERMTEXT.":</b><br>"._PAGEBREAK."<br>"
	."<textarea name=\"text\" cols=\"60\" rows=\"20\">$ency[text]</textarea><br><br>"
	."<b>"._CHANGETOENCY.":</b><br>"
	."<select name=\"eid\">";
    $result = sql_query("select eid, title from ".$prefix."_encyclopedia", $dbi);
    while(list($eid, $title) = sql_fetch_row($result, $dbi)) {
	if ($eid == $ency[eid]) {
	    $sel = "selected";
	} else {
	    $sel = "";
	}
	echo "<option value=\"$eid\" name=\"eid\" $sel>$title</option>";
    }
    echo "</select><br><br>"
	."<input type=\"hidden\" name=\"op\" value=\"encyclopedia_text_save_edit\">"
	."<input type=\"hidden\" name=\"tid\" value=\"$tid\">"
	."<input type=\"submit\" value=\""._SAVECHANGES."\"> &nbsp;&nbsp; [ <a href=\"index.php?mod=Admin&op=encyclopedia_text_delete&tid=$tid&ok=0\">"._DELETE."</a> ]"
	."</form>";
    CloseTable();
    include("includes/admin/footer.php");
}

function encyclopedia_save($title, $description, $elanguage, $active) {
    global $prefix, $dbi;
    sql_query("insert into ".$prefix."_encyclopedia values(NULL, '$title', '$description', '$elanguage', '$active')", $dbi);
    Header("Location: index.php?mod=Admin&op=encyclopedia");
}

function encyclopedia_text_save($eid, $title, $text) {
    global $prefix, $dbi;
    sql_query("insert into ".$prefix."_encyclopedia_text values(NULL, '$eid', '$title', '$text', '0')", $dbi);
    Header("Location: index.php?mod=Admin&op=encyclopedia");
}

function encyclopedia_save_edit($eid, $title, $description, $elanguage, $active) {
    global $prefix, $dbi;
    sql_query("update ".$prefix."_encyclopedia set title='$title', description='$description', elanguage='$elanguage', active='$active' where eid='$eid'", $dbi);
    Header("Location: index.php?mod=Admin&op=encyclopedia");
}

function encyclopedia_text_save_edit($tid, $eid, $title, $text) {
    global $prefix, $dbi;
    sql_query("update ".$prefix."_encyclopedia_text set eid='$eid', title='$title', text='$text' WHERE tid='$tid'", $dbi);
    Header("Location: index.php?mod=Admin&op=encyclopedia");
}
function encyclopedia_change_status($eid, $active) {
    global $prefix, $dbi;
    if ($active == 1) {
	$new_active = 0;
    } elseif ($active == 0) {
	$new_active = 1;
    }
    sql_query("update ".$prefix."_encyclopedia set active='$new_active' WHERE eid='$eid'", $dbi);
    Header("Location: index.php?mod=Admin&op=encyclopedia");
}

function encyclopedia_delete($eid, $ok=0) {
    global $prefix, $dbi;
    if ($ok==1) {
        sql_query("delete from ".$prefix."_encyclopedia where eid='$eid'", $dbi);
	sql_query("delete from ".$prefix."_encyclopedia_text where eid='$eid'", $dbi);
        Header("Location: index.php?mod=Admin&op=encyclopedia");
    } else {
        include("includes/admin/header.php");
        GraphicAdmin();
	title(""._ENCYCLOPEDIAMANAGER."");
	$result = sql_query("select title from ".$prefix."_encyclopedia where eid='$eid'", $dbi);
	list($title) = sql_fetch_row($result, $dbi);
	OpenTable();
	echo "<center><b>"._DELENCYCLOPEDIA.": $title</b><br><br>"
	    .""._DELENCYCONTWARNING."<br><br>"
	    ."[ <a href=\"index.php?mod=Admin&op=encyclopedia\">"._NO."</a> | <a href=\"index.php?mod=Admin&op=encyclopedia_delete&amp;eid=$eid&amp;ok=1\">"._YES."</a> ]</center>";
	CloseTable();
        include("includes/admin/footer.php");
    }
}

function encyclopedia_text_delete($tid, $ok=0) {
    global $prefix, $dbi;
    if ($ok==1) {
        sql_query("delete from ".$prefix."_encyclopedia_text where tid='$tid'", $dbi);
        Header("Location: index.php?mod=Admin&op=encyclopedia");
    } else {
        include("includes/admin/header.php");
        GraphicAdmin();
	title(""._ENCYCLOPEDIAMANAGER."");
	$result = sql_query("select title from ".$prefix."_encyclopedia_text where tid='$tid'", $dbi);
	list($title) = sql_fetch_row($result, $dbi);
	OpenTable();
	echo "<center><b>"._DELENCYCLOPEDIATEXT.": $title</b><br><br>"
	    .""._DELENCYTEXTWARNING."<br><br>"
	    ."[ <a href=\"index.php?mod=Admin&op=encyclopedia\">"._NO."</a> | <a href=\"index.php?mod=Admin&op=encyclopedia_text_delete&amp;tid=$tid&amp;ok=1\">"._YES."</a> ]</center>";
	CloseTable();
        include("includes/admin/footer.php");
    }
}

function move_terms($eid, $new_eid) {
    global $prefix, $dbi;
    $result = sql_query("select tid from ".$prefix."_encyclopedia_text WHERE eid='$eid'", $dbi);
    while(list($tid) = sql_fetch_row($result, $dbi)) {
	sql_query("update ".$prefix."_encyclopedia_text set eid='$new_eid' WHERE tid='$tid'", $dbi);
    }
    Header("Location: index.php?mod=Admin&op=encyclopedia");
}

switch ($op) {

    case "encyclopedia":
    encyclopedia();
    break;

    case "move_terms":
    move_terms($eid, $new_eid);
    break;

    case "encyclopedia_terms":
    encyclopedia_terms($eid, $ltr);
    break;

    case "encyclopedia_edit":
    encyclopedia_edit($eid);
    break;

    case "encyclopedia_text_edit":
    encyclopedia_text_edit($tid);
    break;

    case "encyclopedia_delete":
    encyclopedia_delete($eid, $ok);
    break;

    case "encyclopedia_text_delete":
    encyclopedia_text_delete($tid, $ok);
    break;

    case "encyclopedia_save":
    encyclopedia_save($title, $description, $elanguage, $active);
    break;

    case "encyclopedia_text_save":
    encyclopedia_text_save($eid, $title, $text);
    break;

    case "encyclopedia_save_edit":
    encyclopedia_save_edit($eid, $title, $description, $elanguage, $active);
    break;

    case "encyclopedia_text_save_edit":
    encyclopedia_text_save_edit($tid, $eid, $title, $text);
    break;

    case "encyclopedia_change_status":
    encyclopedia_change_status($eid, $active);
    break;

}

} else {
    echo "Access Denied";
}

?>
Return current item: ViperWeb Portal System