require_once BX_DIRECTORY_PATH_INC . 'utils.inc.php';
require_once BX_DIRECTORY_PATH_INC . 'languages.inc.php';
// Check if administrator is logged in. If not display login form.
$logged['admin'] = member_auth(1, true, true);
$GLOBALS['oAdmTemplate']->addJsTranslation(array('_adm_mbuilder_Sorry_could_not_insert_object', '_adm_mbuilder_This_items_are_non_editable'));
bx_import('BxDolMenuService');
$oMenu = new BxDolMenuService();
$sResponce = null;
// ** FOR 'AJAX' REQUESTS ;
if (bx_get('action') !== false) {
switch (bx_get('action')) {
case 'edit_form':
$id = (int) bx_get('id');
header('Content-Type: text/html; charset=utf-8');
$aItem = db_assoc_arr("SELECT * FROM `" . $oMenu->sDbTable . "` WHERE `ID` = {$id}", 0);
$sResponce = $aItem ? showEditForm($aItem) : echoMenuEditMsg('Error', 'red');
break;
case 'create_item':
$sResponce = createNewElement($_POST['type'], (int) $_POST['source']);
break;
case 'deactivate_item':
$res = db_res("UPDATE `" . $oMenu->sDbTable . "` SET `Active`='0' WHERE `ID`=" . (int) bx_get('id'));
$sResponce = db_affected_rows($res);
break;
case 'save_item':
$id = (int) $_POST['id'];
if (!$id) {
$sResponce = echoMenuEditMsg('Error', 'red');
break;
}
$aItemFields = array('Name', 'Caption', 'Icon', 'Link', 'Script', 'Target');
foreach ($aMenuSection as $sValue => $a) {
if ($sValue == $_GET['menu_position']) {
$sMenuSection = $sValue;
break;
}
}
}
$aMenuSection[$sMenuSection]['active'] = 1;
// ** FOR 'AJAX' REQUESTS ;
if (bx_get('action') !== false) {
switch (bx_get('action')) {
case 'edit_form':
$id = (int) bx_get('id');
header('Content-Type: text/html; charset=utf-8');
$aItem = db_assoc_arr("SELECT * FROM `sys_menu_member` WHERE `ID` = {$id}", 0);
$sResponce = $aItem ? showEditForm($aItem, $sMenuSection) : echoMenuEditMsg('Error', 'red');
break;
case 'create_item':
$newID = createNewElement($_POST['type'], (int) $_POST['source'], $sMenuSection);
$sResponce = $newID;
break;
case 'deactivate_item':
$res = db_res("UPDATE `sys_menu_member` SET `Active`='0' WHERE `ID`=" . (int) bx_get('id'));
$sResponce = db_affected_rows();
break;
case 'save_item':
$id = (int) $_POST['id'];
if (!$id) {
$sResponce = echoMenuEditMsg('Error', 'red');
} else {
$aItemFields = array('Name', 'Caption', 'Link', 'Target', 'Icon', 'Script');
if ($_REQUEST['action']) {
switch ($_REQUEST['action']) {
case 'edit_form':
$id = (int) $_REQUEST['id'];
$aItem = db_assoc_arr("SELECT * FROM `{$sTableName}` WHERE `ID` = {$id}", 0);
if ($aItem) {
$aItem['Deletable'] = false;
if ($aItem['Func'] == 'Echo') {
$aItem['Deletable'] = true;
} else {
$iTypeNum = (int) db_value("SELECT COUNT( * ) FROM `{$sTableName}` WHERE `Func` = '{$aItem['Func']}'");
if ($iTypeNum > 1) {
$aItem['Deletable'] = true;
}
}
showEditForm($aItem);
} else {
echoMenuEditMsg('Error', 'red');
}
exit;
case 'create_item':
$newID = createNewElement((int) $_GET['source']);
echo $newID;
exit;
case 'deactivate_item':
echo "OK";
//moved it to Col 0
exit;
case 'save_item':
$id = (int) $_POST['id'];
if (!$id) {
function installMain(&$s)
{
global $lll;
global $hostName, $dbUser, $dbUserPw, $dbName, $dbPort, $dbSocket;
global $scriptName;
global $cookiePath;
global $phpVersionMin, $mySqlVersionMin;
$s = "";
showInstallHeader($s1);
$s .= $s1;
// Ezt azert kommentezem ki, mert gyakran ujrainstallalok ugy hogy elozoleg
// john-kent be voltam jelentkezve. Ilyen esetben mindig john
// id-jevel hozta letre eloszor az admint, majd amikor john
// letrehozasara kerult a sor, akkor hibat adott az install mondvan,
// hogy ilyen id-ju juzer mar letezik:
//if (!isset($_COOKIE["globalUserId"]))
//{
mt_srand((double) microtime() * 1000000);
global $randIdMax, $randIdMin;
if (!isset($randIdMin)) {
$randIdMin = 0;
}
if (!isset($randIdMax)) {
$randIdMax = getrandmax();
}
$randomId = (int) mt_rand($randIdMin, $randIdMax);
setcookie("globalUserId", $randomId, Loginlib_ExpirationDate, $cookiePath);
$_COOKIE["globalUserId"] = $randomId;
//}
if (isset($_POST["edit"])) {
$s .= showEditForm(TRUE);
return;
}
//if( isset($_POST["submit"]) &&
// $_POST["submit"]==$lll["install"] )
//{
//check file creation
$ret = checkFileCreate();
if ($ret == ok) {
iPrint($lll["create_file_ok"], "ok", $sp);
$s .= $sp;
$createconf = TRUE;
} else {
if (!isset($_POST["confirm"])) {
iPrint($lll["create_file_nok_ext"], "warn", $sp);
} else {
iPrint($lll["create_file_nok"], "warn", $sp);
}
$s .= $sp;
$createconf = FALSE;
}
//check mysql connection
$db->hostName = $hostName;
$db->user = $dbUser;
$db->password = $dbUserPw;
$db->port = $dbPort;
$db->socket = $dbSocket;
$connectRet = checkMysql($db, $s1);
$s .= $s1;
if ($connectRet == ok) {
iPrint($lll["mysql_found"], "ok", $sp);
$s .= $sp;
$connectok = TRUE;
$pwok = TRUE;
} elseif ($connectRet == mysql_access_denied) {
iPrint($lll["mysql_found"], "ok", $sp);
$s .= $sp;
if ($dbUserPw == "") {
iPrint(sprintf($lll["need_pw"], $dbUser), "warn", $sp);
$s .= $sp;
$s .= showEditForm(TRUE);
return ok;
} else {
iPrint(sprintf($lll["incorr_pw"], $dbUser), "warn", $sp);
$s .= $sp;
$s .= showEditForm(TRUE);
return ok;
}
} else {
iPrint($lll["mysql_not_found"] . " (" . mysql_error() . ")", "warn", $sp);
$s .= $sp;
$s .= showEditForm(TRUE);
return ok;
}
if (!DbInstall::checkComponentVersions($mySqlVersion, $phpVersion)) {
iPrint(sprintf($lll["versionTooLow"], $mySqlVersionMin, $mySqlVersion, $phpVersionMin, $phpVersion), "err", $sp);
$s .= $sp;
return ok;
}
if (!isset($_POST["confirm"])) {
$s .= showAskConfirm();
return ok;
}
if (isset($_COOKIE["globalUserId"])) {
iPrint($lll["cookieok"], "ok", $sp);
$s .= $sp;
} else {
iPrint($lll["cookienok"], "err", $sp);
$s .= $sp;
return;
}
//check if db exists
$ret = mysql_select_db($dbName);
if ($ret) {
iPrint(sprintf($lll["db_installed"], $dbName), "ok", $sp);
$s .= $sp;
} else {
$ret = createDb();
if ($ret != ok) {
$s1 = sprintf($lll["cantcreatedb"], $dbUser);
iPrint($s1, "warn", $sp);
$s .= $sp;
return ok;
} else {
iPrint(sprintf($lll["db_created"], $dbName), "ok", $sp);
$s .= $sp;
//select db
$ret = mysql_select_db($dbName);
}
}
$ret = DbInstall::installCreateTables();
if ($ret != ok) {
iPrint($lll["inst_create_table_err"], "err", $sp);
$s .= $sp;
return $ret;
} else {
iPrint($lll["tables_installed"], "ok", $sp);
$s .= $sp;
}
createFirstAdmin();
appFillTables();
iPrint($lll["tables_filled"], "ok", $sp);
$s .= $sp;
if ($createconf) {
//config file can be generated
$ret = writeConfigFile($s1);
if ($ret != ok) {
$s .= $s1;
return;
}
} else {
//config can't be created
iPrint($lll["compare_conf"], "warn", $sp);
$s .= $sp;
showConfFileHtml($s1);
$s .= $s1;
iPrint($lll["afterwrconf"], "warn", $s1);
$s .= $s1;
}
iPrint($lll["move_inst_file"], "warn", $s1);
$s .= $s1;
iPrint(sprintf($lll["congrat"], "Noah's Classifieds"), "hurra", $s1);
$s .= $s1;
iPrint($lll["inst_ch_pw"], "warn", $s1);
$s .= $s1;
//send him to the application:
$s .= "<a href='{$scriptName}'>" . sprintf($lll["inst_click"], "Noah's Classifieds") . "</a>";
return ok;
}
switch (true) {
case 'getArea' == $sAction:
genAreaJSON((int) bx_get('id'));
break;
case 'createNewBlock' == $sAction:
createNewBlock();
break;
case 'createNewItem' == $sAction:
createNewItem();
break;
case 'savePositions' == $sAction:
savePositions((int) bx_get('id'));
break;
case 'loadEditForm' == $sAction:
header('Content-Type: text/html; charset=utf-8');
showEditForm((int) bx_get('id'), (int) bx_get('area'));
break;
case 'dummy' == $sAction:
echo 'Dummy!';
break;
case true == bx_get('action-save'):
case 'Save' == $sAction:
saveItem((int) bx_get('area'), $_POST);
break;
case true == bx_get('action-delete'):
case 'Delete' == $sAction:
deleteItem((int) bx_get('id'), (int) bx_get('area'));
break;
}
function createNewBlock()
{
$logged['admin'] = member_auth(1, true, true);
switch ($_REQUEST['action']) {
case 'getArea':
genAreaJSON((int) $_REQUEST['id']);
break;
case 'createNewBlock':
createNewBlock();
break;
case 'createNewItem':
createNewItem();
break;
case 'savePositions':
savePositions((int) $_REQUEST['id']);
break;
case 'loadEditForm':
showEditForm((int) $_REQUEST['id'], (int) $_REQUEST['area']);
break;
case 'dummy':
echo 'Dummy!';
break;
case 'Save':
//save item
saveItem((int) $_POST['area'], $_POST);
break;
case 'Delete':
//delete item
deleteItem((int) $_POST['id'], (int) $_POST['area']);
break;
}
function createNewBlock()
{
<html>
<head>
<title> ElifTech test task </title>
</head>
<body>
<?php
include "PageElements/MenuBar.php";
echo '<hr>';
if (isset($IsDeleteFlag)) {
deleteRecord($id);
} else {
if (isset($IsUpdateFlag)) {
updateRecord();
} else {
showEditForm($id);
}
}
?>
</body>
</html>
<?php
function deleteRecord($id)
{
$TblName = TableName;
$Connection = mysql_connect(ServerName, UserName, Password);
$db_selected = mysql_select_db(DBName, $Connection);
if (!$Connection) {
die("DataBase connection failed: " . mysql_error());
