0) {
while (list($key, $val) = each($data)) {
$no++;
}
};
$title = FAQ_ADD . ' #' . $no;
echo tep_draw_form('',FILENAME_FAQ_MANAGER, 'faq_action=AddSure');
include('faq_form.php');
break;
case "AddSure":
function add_faq ($data) {
$query = "INSERT INTO " . TABLE_FAQ . " (visible,v_order,question,answer,date,language) VALUES( '". (isset($data['visible']) ? (int)$data['visible'] : 0)."', '$data[v_order]', '$data[question]', '$data[answer]', NOW(),'$data[faq_language]')";
tep_db_query($query);
// update category info
$fID = tep_db_insert_id();
tep_db_query("insert into " . TABLE_FAQ_TO_CATEGORIES . " (faq_id, categories_id) values ('" . (int)$fID . "', '" . (int)$data['faq_category'] . "')");
}
if (isset($v_order) && isset($question) && isset($answer)) {
if ( (int)$v_order) {
add_faq($_POST);
$data = browse_faq($language,$_GET);
$title = FAQ_CREATED . ' ' . FAQ_ADD_QUEUE . ' ' . $v_order;
include('faq_list.php');
} else {
$error = 20;
}
} else {
$error = 80;
}
break;
case "Edit":
if ($faq_id) {
$edit = read_data($faq_id);
$data = browse_faq($language,$_GET);
$button = array("Update");
$title = FAQ_EDIT_ID . ' ' . $faq_id;
echo tep_draw_form('',FILENAME_FAQ_MANAGER, 'faq_action=Update');
echo tep_draw_hidden_field('faq_id', $faq_id);
include('faq_form.php');
} else {
$error = 80;
}
break;
case "Update":
function update_faq ($data) {
tep_db_query("UPDATE " . TABLE_FAQ . " SET question='$data[question]', answer='$data[answer]', visible='".(isset($data['visible']) ? (int)$data['visible'] : 0)."', v_order=$data[v_order], date = now() WHERE faq_id=$data[faq_id]");
$category_check_query = tep_db_query("select categories_id from " . TABLE_FAQ_TO_CATEGORIES . " where faq_id = '" . (int)$data['faq_id'] . "'");
if (tep_db_fetch_array($category_check_query)) { // if category exists
// update category info
tep_db_query("update " . TABLE_FAQ_TO_CATEGORIES . " set categories_id = '" . (int)$data['faq_category'] . "' where faq_id = '" . (int)$data['faq_id'] . "'");
} else {
tep_db_query("insert into " . TABLE_FAQ_TO_CATEGORIES . " (faq_id, categories_id) values ('" . (int)$data['faq_id'] . "', '" . (int)$data['faq_category'] . "')");
}
}
if ($faq_id && $question && $answer && $v_order) {
if ( (int)$v_order ) {
update_faq($_POST);
$data = browse_faq($language,$_GET);
$title = FAQ_UPDATED_ID . ' ' . $faq_id;
include('faq_list.php');
} else {
$error = 20;
}
} else {
$error = 80;
}
break;
case 'Visible':
function tep_set_faq_visible($faq_id, $_GET) {
if ($_GET['visible'] == 1) {
return tep_db_query("update " . TABLE_FAQ . " set visible = '0', date = now() where faq_id = '" . $faq_id . "'");
} else{
return tep_db_query("update " . TABLE_FAQ . " set visible = '1', date = now() where faq_id = '" . $faq_id . "'");
}
}
tep_set_faq_visible($faq_id, $_GET);
$data = browse_faq($language,$_GET);
if ($_GET['visible'] == 1) {
$vivod = FAQ_DEACTIVATED_ID;
} else {
$vivod = FAQ_ACTIVATED_ID;
}
$title = $vivod . ' ' . $faq_id;
include('faq_list.php');
break;
case "Delete":
if ($faq_id) {
$delete = read_data($faq_id);
$data = browse_faq($language,$_GET);
$title = FAQ_DELETE_CONFITMATION_ID . ' ' . $faq_id;
echo '
| ' . $title . ' |
| ' . FAQ_QUESTION . ': |
| ' . $delete[question] . ' |
| ' . FAQ_ANSWER . ': |
| ' . $delete[answer] . ' |
|
';
echo tep_draw_form('',FILENAME_FAQ_MANAGER, 'faq_action=DelSure&faq_id='.$val[faq_id]);
echo tep_draw_hidden_field('faq_id', $faq_id);
echo tep_image_submit('button_delete.gif', IMAGE_DELETE);
echo '' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '';
echo ' | ';
} else {
$error = 80;
}
break;
case "DelSure":
function delete_faq ($faq_id) {
tep_db_query("DELETE FROM " . TABLE_FAQ . " WHERE faq_id=$faq_id");
tep_db_query("delete from " . TABLE_FAQ_TO_CATEGORIES . " where faq_id = '" . (int)$faq_id . "'");
}
if ($faq_id) {
delete_faq($faq_id);
$data = browse_faq($language,$_GET);
$title = FAQ_DELETED_ID . ' ' . $faq_id;
include('faq_list.php');
} else {
$error = 80;
}
break;
default:
$data = browse_faq($language,$_GET);
$title = FAQ_MANAGER;
include('faq_list.php');
break;
}
if (isset($error)) {
$content = error_message($error);
echo $content;
$data = browse_faq($language,$_GET);
$no = 1;
if (sizeof($data) > 0) {
while (list($key, $val) = each($data)) {
$no++;
}
};
$title = FAQ_ADD_QUEUE . ' ' . $no;
echo tep_draw_form('',FILENAME_FAQ_MANAGER, 'faq_action=AddSure');
include('faq_form.php');
}
?>
|