function commit_sauvegarde($type_sauvegarde, $DEBUG = FALSE)
{
$PHP_SELF = $_SERVER['PHP_SELF'];
$session = session_id();
header("Pragma: no-cache");
header("Content-Type: text/x-delimtext; name=\"php_conges_" . $type_sauvegarde . ".sql\"");
header("Content-disposition: attachment; filename=php_conges_" . $type_sauvegarde . ".sql");
//
// Build the sql script file...
//
$maintenant = date("d-m-Y H:i:s");
echo "#\n";
echo "# PHP_CONGES\n";
echo "#\n# DATE : {$maintenant}\n";
echo "#\n";
//recup de la liste des tables
$sql1 = "SHOW TABLES";
$ReqLog = SQL::query($sql1);
while ($resultat = $ReqLog->fetch_array()) {
$table = $resultat[0];
echo "#\n#\n# TABLE: {$table} \n#\n";
if ($type_sauvegarde == "all" || $type_sauvegarde == "structure") {
echo "# Struture : \n#\n";
echo get_table_structure($table);
}
if ($type_sauvegarde == "all" || $type_sauvegarde == "data") {
echo "# Data : \n#\n";
echo get_table_data($table);
}
}
}
$tpl->assign('sql_error', $db->ErrorMsg());
}
case 'N':
default:
if (empty($_REQUEST['submit'])) {
SmartyValidate::connect($tpl);
SmartyValidate::register_form('conf_user_permissions', true);
SmartyValidate::register_criteria('isValueUnique', 'validate_unique', 'conf_user_permissions');
SmartyValidate::register_criteria('isNotEqual', 'validate_not_equal', 'conf_user_permissions');
SmartyValidate::register_criteria('isNotSubCat', 'validate_not_sub_category', 'conf_user_permissions');
SmartyValidate::register_validator('v_CATEGORY_ID', 'CATEGORY_ID:0', 'isNotEqual', true, false, null, 'conf_user_permissions');
SmartyValidate::register_validator('v_CATEGORY_ID_U', "CATEGORY_ID:user_permission:0:USER_ID", 'isValueUnique', false, false, null, 'conf_user_permissions');
SmartyValidate::register_validator('v_CATEGORY_ID_S', "CATEGORY_ID", 'isNotSubCat', false, false, null, 'conf_user_permissions');
} else {
SmartyValidate::connect($tpl);
$data = get_table_data('user_permission');
$data['USER_ID'] = $u;
if (SmartyValidate::is_valid($data, 'conf_user_permissions')) {
// Check if category is parent to existing categories.
$child_categories = find_child_categories();
if ($child_categories > 0) {
$tpl->assign('CHILD_CATEGORIES', $child_categories);
$tpl->assign('WARN', true);
$category = $db->GetOne("SELECT `TITLE` FROM `{$tables['category']['name']}` WHERE `ID` = " . $db->qstr($data['CATEGORY_ID']));
$tpl->assign('CATEGORY', $category);
} else {
$id = $db->GenID($tables['user_permission']['name'] . '_SEQ');
$data['ID'] = $id;
if (db_replace('user_permission', $data, 'ID') > 0) {
$tpl->assign('posted', 'Permission granted.');
} else {
<div id="content" class="span10">
<!-- content starts -->
<?php
$get_pages = get_table_data('brochure', null);
//echo "<pre>";print_r($get_pages);
?>
<div>
<ul class="breadcrumb">
<li>
<a href="#">Home</a> <span class="divider">/</span>
</li>
<li>
<a href="#">brochure</a>
</li>
<li>
</li>
</ul>
</div>
<?php
if ($_GET['msg'] == 'delete') {
?>
<div class="alert alert-success">brochure has been Deleted</div>
<?php
}
?>
<?php
if ($_GET['msg'] == 'success') {
?>
$tmpl = $db->GetRow("SELECT `SUBJECT`, `BODY` FROM `{$tables['email_tpl']['name']}` WHERE `ID` = " . $db->qstr($_REQUEST['EMAIL_TPL_ID']));
$mail = get_emailer();
$mail->Body = replace_email_vars($tmpl['BODY'], $email_data);
$mail->Subject = replace_email_vars($tmpl['SUBJECT'], $email_data);
$mail->AddAddress($email_data['EMAIL'], $email_data['NAME']);
if (!DEMO) {
$sent = $mail->Send();
} else {
$sent = true;
}
if ($sent) {
$id = $db->GenID($tables['email']['name'] . '_SEQ');
$data['ID'] = $id;
if ($db->Replace($tables['email']['name'], $data, 'ID', true) > 0) {
// Save to Links table
$link_data = get_table_data('link');
$link_data['RECPR_REQUIRED'] = REQUIRE_RECIPROCAL;
$link_data['STATUS'] = 2;
$link_data['OWNER_NAME'] = $data['NAME'];
$link_data['OWNER_EMAIL'] = $data['EMAIL'];
$link_data['DATE_ADDED'] = gmdate('Y-m-d H:i:s');
$link_data['DATE_MODIFIED'] = gmdate('Y-m-d H:i:s');
if (ENABLE_PAGERANK) {
require_once 'include/pagerank.php';
$link_data['PAGERANK'] = get_page_rank($link_data['URL']);
}
$link_data['ID'] = $link_id;
if ($db->Replace($tables['link']['name'], $link_data, 'ID', true) > 0) {
$category = $db->GetOne("SELECT `TITLE` FROM `{$tables['category']['name']}` WHERE `STATUS` = '2' AND `ID` = " . $db->qstr($full_data['CATEGORY_ID']));
$full_data['CATEGORY'] = $category;
$tpl->assign('posted', true);
<div id="content" class="span10">
<!-- content starts -->
<?php
$get_pages = get_table_data('sr_gallery', null);
//echo "<pre>";print_r($get_pages);
?>
<div>
<ul class="breadcrumb">
<li>
<a href="#">Home</a> <span class="divider">/</span>
</li>
<li>
<a href="#">Gallary</a>
</li>
<li>
</li>
</ul>
</div>
<?php
if ($_GET['msg'] == 'delete') {
?>
<div class="alert alert-success">Gallary has been Deleted</div>
<?php
}
?>
<?php
if ($_GET['msg'] == 'success') {
?>
case 'delete_entry':
$myReturn = delete_entry($_POST);
break;
case 'book_entry':
$myReturn = book_entry($_POST);
break;
case 'get_entry':
$myReturn = get_entry($_POST);
if (isset($myReturn['minutes_locked']) && $myReturn['minutes_locked'] > 31) {
$data = array('user_id' => $myReturn['fields']['lock'], 'id' => $myReturn['fields']['id']);
release_lock($data);
$myReturn = get_entry($_POST);
}
break;
case 'get_table_data':
$myReturn = get_table_data($_POST['access_level'] * 1);
break;
case 'get_groups':
$myReturn['groups'] = get_groups($_POST['nuid']);
break;
case 'release_lock':
$myReturn = release_lock($_POST);
break;
case 'delete_revisions':
$myReturn = delete_revisions($_POST);
break;
default:
$myReturn['error'] = 'Not prepared to handle action "' . $_POST['action'] . '"';
break;
}
// end switch
$page = mysqli_fetch_array($page1);
include "addpage.php";
}
/**gallary**/
if ($_GET['data'] == 'gallary') {
include "gallary.php";
}
if ($_GET['data'] == 'addgallary') {
include "addgallary.php";
}
/* Home Page */
if ($_GET['data'] == 'homepage') {
$page = get_table_data(DB_PREFIX . 'homepage', null);
include "homepage.php";
}
if ($_GET['data'] == 'contactpage') {
$page = get_table_data(DB_PREFIX . 'contact', null);
include "contactpage.php";
}
if ($_GET['data'] == 'settings') {
$global1 = mysqli_query($db_connect, "select * from cns_globalsettings");
$global = mysqli_fetch_array($global1);
include "settings.php";
}
?>
</div>
<?php
include "include/footer.php";
?>
</div>
SmartyValidate::register_validator('v_RECPR_ONLINE', 'RECPR_URL', 'isURLOnline', $recpr_required ? false : true, false, null, 'submit_link');
SmartyValidate::register_validator('v_RECPR_LINK', 'RECPR_URL', 'isRecprOnline', $recpr_required ? false : true, false, null, 'submit_link');
SmartyValidate::register_validator('v_RECPR_DOMAIN', 'RECPR_URL', 'isRecprDomain', $recpr_required ? false : true, false, null, 'submit_link');
SmartyValidate::register_validator('v_OWNER_NAME', 'OWNER_NAME', 'notEmpty', false, false, 'trim', 'submit_link');
SmartyValidate::register_validator('v_OWNER_EMAIL', 'OWNER_EMAIL', 'isEmail', false, false, 'trim', 'submit_link');
if (count($price) > 0) {
SmartyValidate::register_validator('v_LINK_TYPE', 'LINK_TYPE', 'notEmpty', false, false, 'trim', 'submit_link');
}
// Deeplink URL Validation
for ($dl = 1; $dl <= 5; $dl++) {
SmartyValidate::register_validator('v_DEEPLINK_URL' . $dl, 'URL' . $dl, 'isURL', true, false, 'trim', 'submit_link');
}
} else {
SmartyValidate::connect($tpl);
SmartyValidate::set_form('submit_link');
$data = get_table_data('link', true);
$data['STATUS'] = 1;
$data['IPADDRESS'] = get_client_ip();
$data['VALID'] = 1;
$data['LINK_TYPE'] = $link_type;
$data['RECPR_REQUIRED'] = $recpr_required;
if ($recpr_required) {
$data['RECPR_VALID'] = 1;
$data['RECPR_LAST_CHECKED'] = gmdate('Y-m-d H:i:s');
}
$data['LAST_CHECKED'] = gmdate('Y-m-d H:i:s');
$data['DATE_ADDED'] = gmdate('Y-m-d H:i:s');
$data['DATE_MODIFIED'] = gmdate('Y-m-d H:i:s');
if (strlen(trim($data['URL'])) > 0 && !preg_match('#^http[s]?:\\/\\/#i', $data['URL'])) {
$data['URL'] = "http://" . $data['URL'];
}
case 'N':
default:
if ($id) {
$where = "WHERE `ID` != " . $db->qstr($id);
}
if (empty($_POST['submit'])) {
SmartyValidate::disconnect();
SmartyValidate::connect($tpl, true);
SmartyValidate::register_criteria('isEmailAndAddLinkValid', 'validate_email_and_add_link');
SmartyValidate::register_validator('v_VALIDATE_EMAIL_TYPE', 'TPL_TYPE', 'isEmailAndAddLinkValid', false, false, 'trim');
SmartyValidate::register_validator('v_TITLE', 'TITLE', 'notEmpty', false, false, 'trim');
SmartyValidate::register_validator('v_SUBJECT', 'SUBJECT', 'notEmpty', false, false, 'trim');
SmartyValidate::register_validator('v_BODY', 'BODY', 'notEmpty', false, false, 'trim');
} else {
SmartyValidate::connect($tpl);
$data = get_table_data('email_tpl');
if (SmartyValidate::is_valid($data)) {
if (empty($id)) {
$id = $db->GenID($tables['email_tpl']['name'] . '_SEQ');
}
$data['ID'] = $id;
if ($db->Replace($tables['email_tpl']['name'], $data, 'ID', true) > 0) {
$tpl->assign('posted', true);
if (isset($_SESSION['return'])) {
@header('Location: ' . $_SESSION['return']);
@exit;
}
} else {
$tpl->assign('sql_error', $db->ErrorMsg());
}
}
function show_spam()
{
print get_table_data('SELECT * FROM ' . db_tablename('spamlog'));
}
if (isset($data['user_id']) && $data['user_id'] !== '') {
$qry = "INSERT INTO `{$user_meta}` (user_id,meta_key,meta_value) VALUES ('" . $data['user_id'] . "','last_accessed', CURRENT_TIMESTAMP) " . "ON DUPLICATE KEY UPDATE meta_value=CURRENT_TIMESTAMP;";
$myResults = $mySQLi->add_row($qry);
$out['results'] = $myResults;
if ($mySQLi->error != '') {
$out['error'] = $mySQLi->error_num . ': ' . $mySQLi->error;
}
return $out;
}
}
//*** Primary control. Calls the function that matches the requested ACTION ***//
if (isset($_POST['action']) && $_POST['action'] != '') {
$myAction = $_POST['action'];
switch ($myAction) {
case 'get_table_data':
$myReturn['table_data'] = get_table_data($_POST['user_access']);
break;
case 'get_groups':
$myReturn['groups'] = get_groups($_POST['nuid']);
break;
case 'update_user':
unset($_POST['action']);
$myReturn = update_user($_POST);
break;
case 'add_user':
unset($_POST['action']);
$myReturn = add_user($_POST);
break;
case 'delete_user':
$myReturn = delete_user($_POST['id']);
break;
SmartyValidate::register_validator('v_TITLE_URL', 'TITLE_URL:!^[\\w_-]+$!', 'isRegExp', false, false, 'trim', 'dir_categs_edit');
SmartyValidate::register_validator('v_TITLE_URL_U', 'TITLE_URL:category:' . $id . ':PARENT_ID', 'isValueUnique', false, false, null, 'dir_categs_edit');
}
} else {
SmartyValidate::register_criteria('isNotEqual', 'validate_not_equal', 'dir_categs_edit');
SmartyValidate::register_criteria('isNotEqualVariable', 'validate_not_equal_var', 'dir_categs_edit');
SmartyValidate::register_criteria('isSymbolicUnique', 'validate_symbolic_unique', 'dir_categs_edit');
SmartyValidate::register_criteria('isParentValid', 'validate_symbolic_parent', 'dir_categs_edit');
SmartyValidate::register_validator('v_SYMBOLIC_ID', 'SYMBOLIC_ID:0', 'isNotEqual', true, false, null, 'dir_categs_edit');
SmartyValidate::register_validator('v_SYMBOLIC_ID_E', 'SYMBOLIC_ID:PARENT_ID', 'isNotEqualVariable', true, false, null, 'dir_categs_edit');
SmartyValidate::register_validator('v_SYMBOLIC_ID_U', 'SYMBOLIC_ID', 'isSymbolicUnique', false, false, null, 'dir_categs_edit');
SmartyValidate::register_validator('v_SYMBOLIC_ID_P', 'SYMBOLIC_ID', 'isParentValid', false, false, null, 'dir_categs_edit');
}
} else {
SmartyValidate::connect($tpl);
$data = get_table_data('category');
$data['SYMBOLIC'] = isset($_REQUEST['s']) && $_REQUEST['s'] == 1 ? 1 : 0;
if (strlen(trim($data['TITLE_URL'])) == 0) {
$data['TITLE_URL'] = preg_replace('`[^\\w_-]`', '_', $data['TITLE']);
}
if (SmartyValidate::is_valid($data, 'dir_categs_edit')) {
if ($action == 'N') {
$data['DATE_ADDED'] = gmdate('Y-m-d H:i:s');
}
if (empty($id)) {
$id = $db->GenID($tables['category']['name'] . '_SEQ');
}
$data['ID'] = $id;
if ($db->Replace($tables['category']['name'], $data, 'ID', true) > 0) {
// Refresh editor permissions
if (!$_SESSION['is_admin']) {
function create_admin($admin_details)
{
global $tpl, $db, $tables;
$db = ADONewConnection(DB_DRIVER);
if (!$db->Connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)) {
return false;
}
$db->SetFetchMode(ADODB_FETCH_ASSOC);
$sql = "SELECT * FROM `{$tables['user']['name']}` WHERE `LOGIN` = " . $db->qstr($admin_details['admin_user']) . " LIMIT 1";
$result = $db->GetRow($sql);
$max_user_id = $db->GetOne("SELECT MAX(`ID`) FROM `{$tables['user']['name']}`");
$max_user_id = empty($max_user_id) ? 1 : $max_user_id + 1;
$data = !empty($result) && is_array($result) ? $result : get_table_data('user');
$data['LOGIN'] = $admin_details['admin_user'];
$data['NAME'] = $admin_details['admin_name'];
$data['PASSWORD'] = encrypt_password($admin_details['admin_password']);
$data['EMAIL'] = $admin_details['admin_email'];
$data['ADMIN'] = 1;
$data['SUBMIT_NOTIF'] = $data['SUBMIT_NOTIF'] == 0 ? 0 : 1;
$data['PAYMENT_NOTIF'] = $data['PAYMENT_NOTIF'] == 0 ? 0 : 1;
if (empty($result) || !is_array($result)) {
$mode = "INSERT";
$where = false;
$data['ID'] = $db->GenID($tables['user']['name'] . '_SEQ', $max_user_id);
} else {
$mode = "UPDATE";
$where = " `ID` = " . $db->qstr($data['ID']);
/* Create a new sequence to cater for upgrading installation */
$db->CreateSequence($tables['user']['name'] . '_SEQ', $max_user_id);
}
if (!$db->AutoExecute($tables['user']['name'], $data, $mode, $where)) {
$tpl->assign('form_error', 'SQL_ERROR_ADMIN');
$tpl->assign('sql_error', $db->ErrorMsg());
return false;
}
return 1;
}
# 0.0.4
//}
//else
//{
// # update the totals anyways, it may be needed when the language changes
// #
// calc_query_limits('table_editor_adm', $parms[2], $TABLE);
// $_SESSION['table_editor_adm'.'_paginate']['thispage'] = 0;
//}
//echo '<p class="todo">$limits='.$limits.'</p>';
//echo '<p class="todo">$filters='.$filters.'</p>';
//echo ' $TABLE_ADM_PARAM<br>';var_dump($TABLE_ADM_PARAM);echo '<hr>';
if ($TABLE_ADM_PARAM) {
$rows = get_table_data('*all', $parms[0], $limits, $filters, $TABLE_ADM_PARAM);
} else {
$rows = get_table_data('*all', $parms[0], $limits, $filters, $filters_relations);
}
if (function_exists('get_table_data_list')) {
echo get_table_data_list($rows, 'table_editor_adm', $parms[4]);
} else {
echo '<p style="color:red;">Missing function <b>get_table_data_list</b></p>';
//var_dump($rows);
echo '<hr>';
}
//echo $splitter_block
// .$js;
exit;
break;
#
#---------------------------
#
<div id="content" class="span10">
<!-- content starts -->
<?php
$get_pages = get_table_data('gallary', null);
//echo "<pre>";print_r($get_pages);
?>
<div>
<ul class="breadcrumb">
<li>
<a href="#">Home</a> <span class="divider">/</span>
</li>
<li>
<a href="#">Gallary</a>
</li>
<li>
</li>
</ul>
</div>
<?php
if ($_GET['msg'] == 'delete') {
?>
<div class="alert alert-success">Gallary has been Deleted</div>
<?php
}
?>
<?php
if ($_GET['msg'] == 'success') {
?>
<div id="content" class="span10">
<!-- content starts -->
<?php
$pages = get_table_data('services', null);
//echo "<pre>";print_r($pages);
?>
<div>
<ul class="breadcrumb">
<li>
<a href="#">Home</a> <span class="divider">/</span>
</li>
<li>
<a href="#">Services</a>
</li>
<li>
</li>
</ul>
</div>
<?php
if ($_GET['msg'] == 'delete') {
?>
<div class="alert alert-success">Services has been Deleted</div>
<?php
}
?>
<?php
if ($_GET['msg'] == 'update') {
?>
<div class="alert alert-success">Services has update successfully</div>
<?php
}
if ($_GET['data'] == 'editproject') {
$pages = mysqli_query($db_connect, "select * from on_projects where id ='{$_GET['page']}'");
$page = mysqli_fetch_array($pages);
include "addproject.php";
}
if ($_GET['data'] == 'addproject') {
include "addproject.php";
}
if ($_GET['data'] == 'pages') {
$pages = get_table_data('pages', null);
include "pages.php";
}
if ($_GET['data'] == 'editpage') {
$pages = get_table_data('pages', array('page_id !' => $_GET['page']));
$page = get_table_data('pages', array('page_id' => $_GET['page']));
include "addpage.php";
}
if ($_GET['data'] == 'addpage') {
include "addpage.php";
}
if ($_GET['data'] == 'addimage') {
include "page_images.php";
}
if ($_GET['data'] == 'gallary') {
include "gallary.php";
}
if ($_GET['data'] == 'addgallary') {
include "addgallary.php";
}
if ($_GET['data'] == 'brochure') {
<?php
require 'admin/coreclass.php';
include 'autoresponder/responder.php';
$db = new database();
$x = new online_tracker();
$x->tracker();
$gerger = new gerger_timer();
$gerger->start();
$gerger->setprecision(4);
$articleID = $_REQUEST['segment'];
$where = " WHERE autoNumber = '{$articleID}'";
$rs = get_table_data('news_segments', $where);
$data = mysql_fetch_assoc($rs);
/*
$sql = " select * from article_versions av ";
$sql .= " where av.articleID =" . intval( $articleID );
if (!($result = $db->query( $sql ))) {
die('Error:'. $db->error());
}
$view_article = array();
while ( $view_article[] = $db->fetcharray() );
$dateline = $view_article[0]->dateline;
// get the dateline of the headline news..
$day = $view_article[0]->published_day;
$month = $view_article[0]->published_month;
$year = $view_article[0]->published_year;
$articleID = $view_article[0]->articleID;
*/
/**
* Get the other news on this category
<div class="control-group">
<label class="control-label" for="textarea2">Gallery</label>
<div class="controls">
<input class="input-file uniform_on" id="fileInput" type="file" required name="banners[]" multiple>
</div>
</div>
<div class="control-group">
<label class="control-label" for="textarea2">Type</label>
<div class="controls">
<select name="type">
<option value=""> select gallery type</option>
<option value="certificates">certificates</option>
<?php
$serv = get_table_data('services', null);
for ($i = 0; $i < count($serv); $i++) {
?>
<option value="<?php
echo $serv[$i]['name'];
?>
"><?php
echo $serv[$i]['name'];
?>
</option>
<?php
}
?>
</select>
</div>
</div>
header("location:../index.php?data=projects&msg=delete");
}
if (isset($_POST['page_id']) && $_POST['page_id'] == '') {
$pr_id = array_shift($_POST);
$pr_img = array_shift($_POST);
$_POST['name'] = htmlspecialchars(str_replace("'", "", $_POST['name']));
$_POST['created_date'] = date("Y-m-d H:i:s");
$_POST['updated_date'] = date("Y-m-d H:i:s");
if ($_FILES['image']['name']) {
$image_file = rand() . $_FILES['image']['name'];
$image_path = '../../images/' . $image_file;
$temp = $_FILES['image']['tmp_name'];
copy($temp, $image_path);
$_POST['image'] = $image_file;
}
$pages = get_table_data('services', array('showon_homepage' => 1));
if (count($pages) < 3) {
$_POST['showon_homepage'] = 1;
}
$_POST['description'] = htmlspecialchars(str_replace("'", "", $_POST['description']));
//print_r($_POST); exit;
db_insert('services', $_POST);
header('location:../index.php?data=projects&msg=success');
} else {
$product_id = array_shift($_POST);
$images = array_shift($_POST);
$_POST['name'] = str_replace("'", "", $_POST['name']);
if ($_FILES['image']['name']) {
$image_file = rand() . $_FILES['image']['name'];
$image_path = '../../images/' . $image_file;
$temp = $_FILES['image']['tmp_name'];
if ($action == 'N') {
$data = array();
}
SmartyValidate::connect($tpl);
SmartyValidate::register_form('conf_users_edit', true);
SmartyValidate::register_criteria('isValueUnique', 'validate_unique', 'conf_users_edit');
SmartyValidate::register_validator('v_LOGIN', 'LOGIN:4:25', 'isLength', false, false, 'trim', 'conf_users_edit');
SmartyValidate::register_validator('v_LOGIN_U', 'LOGIN:user:'******'isValueUnique', false, false, false, 'conf_users_edit');
SmartyValidate::register_validator('v_NAME', 'NAME:4:25', 'isLength', false, false, 'trim', 'conf_users_edit');
SmartyValidate::register_validator('v_PASSWORD', 'PASSWORD:4:25', 'isLength', true, false, 'trim', 'conf_users_edit');
SmartyValidate::register_validator('v_PASSWORDC', 'PASSWORD:PASSWORDC', 'isEqual', true, false, 'trim', 'conf_users_edit');
SmartyValidate::register_validator('v_EMAIL', 'EMAIL', 'isEmail', false, false, 'trim', 'conf_users_edit');
SmartyValidate::register_validator('v_EMAIL_U', 'EMAIL:user:'******'isValueUnique', false, false, 'trim', 'conf_users_edit');
} else {
SmartyValidate::connect($tpl);
$data = get_table_data('user');
if (!isset($data['SUBMIT_NOTIF'])) {
$data['SUBMIT_NOTIF'] = 0;
}
if (!isset($data['PAYMENT_NOTIF'])) {
$data['PAYMENT_NOTIF'] = 0;
}
$data['PASSWORDC'] = $_REQUEST['PASSWORDC'];
if (SmartyValidate::is_valid($data, 'conf_users_edit')) {
unset($data['PASSWORDC']);
if (empty($id)) {
$id = $db->GenID($tables['user']['name'] . '_SEQ');
}
$data['ID'] = $id;
if ($action == 'E') {
if (empty($data['PASSWORD'])) {
include "projects.php";
}
if ($_GET['data'] == 'editproject') {
$pages = get_table_data('services', array('id' => $_GET['page']));
$page = $pages[0];
include "addproject.php";
}
if ($_GET['data'] == 'addproject') {
include "addproject.php";
}
if ($_GET['data'] == 'about') {
$page = get_table_data('about');
include "addpage.php";
}
if ($_GET['data'] == 'contact') {
$page = get_table_data('contact');
include "addcontact.php";
}
if ($_GET['data'] == 'gallary') {
include "gallary.php";
}
if ($_GET['data'] == 'addgallary') {
include "addgallary.php";
}
if ($_GET['data'] == 'addimages') {
include "addimages.php";
}
?>
</div>
<?php
include "include/footer.php";
for ($i = 0; $i < $n; $i++) {
// Count the active banners
foreach ($links as $field => $values) {
if ($field == 'clientID') {
if (checkhttptext($links[$i]->website)) {
$url = splithttptext($links[$i]->website);
$sponsoredlinks .= '<li><a href="' . $links[$i]->website . '">' . $url[1] . '</a></li>';
} else {
$sponsoredlinks .= '<li><a href="http://' . $links[$i]->website . '">' . $links[$i]->website . '</a></li>';
}
}
}
}
###################################################
# get station segments here
$rs = get_table_data('news_segments');
while ($data = mysql_fetch_assoc($rs)) {
$segments .= '<li><a href="segments.php?segmentID=' . $data['autoNumber'] . '">' . $data['segmentTitle'] . '</li>';
}
/*
* Generate random quote
*/
$quote = new quote_of_the_day();
$result = $quote->generate_random_quote();
$quote_author = $result[0]->quote_author;
$quote_message = $result[0]->quote_message;
/**
* Get the poll of the day
*/
//get the current date
$date = date('Y-m-d');
<div id="content" class="span10">
<?php
$page = get_table_data('scanner_video', array('video_id' => 1));
?>
<!-- content starts -->
<div>
<ul class="breadcrumb">
<li>
<a href="#">Home</a> <span class="divider">/</span>
</li>
<li>
<a href="#">Video Page Settings</a>
</li>
</ul>
</div>
<div class="row-fluid sortable">
<div class="box span12">
<div class="box-header well" data-original-title>
<h2><i class="icon-edit"></i> Video Page Settings</h2>
<div class="box-icon">
</div>
</div>
<div class="box-content">
<form class="form-horizontal" method="post" action="dbfiles/videotable.php" enctype="multipart/form-data">
<fieldset>
<input type="hidden" value="<?php
echo $page[0]['video_id'];
?>
" name="video_id">
<?php
include "../include/config.php";
include "../include/functions.php";
if ($_GET['table']) {
deleterow($_GET['table'], array('page_id' => $_GET['page_id']));
header("location:../index.php?data=pages&msg=delete");
}
if (isset($_POST['page_id']) && $_POST['page_id'] == '') {
$pr_id = array_shift($_POST);
$_POST['page_url'] = strtolower(htmlspecialchars(str_replace(" ", "-", str_replace("'", "", $_POST['page_title']))));
$_POST['page_title'] = htmlspecialchars(str_replace("'", "", $_POST['page_title']));
$url_exists = get_table_data('pages', array('page_url' => $_POST['page_url']));
if (count($url_exists) > 0) {
$_POST['page_url'] = rand() . strtolower(htmlspecialchars(str_replace(" ", "-", str_replace("'", "", $_POST['page_title']))));
}
$_POST['created_date'] = date("Y-m-d H:i:s");
$_POST['updated_date'] = date("Y-m-d H:i:s");
$_POST['page_description'] = htmlspecialchars(str_replace("'", "", $_POST['page_description']));
// echo "<pre>";print_r($_POST);
db_insert('pages', $_POST);
header('location:../index.php?data=pages&msg=success');
} else {
$product_id = array_shift($_POST);
$_POST['page_url'] = strtolower(htmlspecialchars(str_replace(" ", "-", str_replace("'", "", $_POST['page_title']))));
$_POST['page_title'] = str_replace("'", "", $_POST['page_title']);
$_POST['page_description'] = htmlspecialchars(str_replace("'", "", $_POST['page_description']));
db_update('pages', $_POST, array('page_id' => $product_id));
header('location:../index.php?data=pages&msg=updated');
}
function calc_query_limits($thisPage, $paginate, $TABLE, $items_per_page = '')
{
# 0.0.4
#~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
#
# recalculate the query limits to paginate
#
# get the total number of records in the table and calculate the total number of pages
#
global $filters, $TABLE_ADM_PARAM, $filters_relations;
# 0.0.6
if ($items_per_page == '') {
$items_per_page = ITEMS_PER_PAGE;
}
# 0.0.4
//echo '<p class="todo">tot_pages='.$_SESSION[EDIT_TABLE_NAME.'_paginate']['tot_pages'].'</p>';
if ($TABLE_ADM_PARAM) {
$rows = get_table_data('*info', '', $TABLE, $filters, $TABLE_ADM_PARAM);
} else {
//$rows = get_table_data('*info', '', $TABLE, $filters); # 0.0.6
$rows = get_table_data('*info', '', $TABLE, $filters, $filters_relations);
# 0.0.6
}
//$tot_pages = (int)($rows / ITEMS_PER_PAGE + 0.999); # 0.0.4
$tot_pages = (int) ($rows / $items_per_page + 0.999);
# 0.0.4
//echo '<p class="todo">$rows='.$rows.'</p>';
//echo '<p class="todo">$items_per_page='.$items_per_page.'</p>';
//echo '<p class="todo">$tot_pages='.$tot_pages.'</p>';
#
# manage pagination
#
$act_page = $_SESSION[EDIT_TABLE_NAME . '_paginate']['thispage'];
//echo '<p class="todo">IN $act_page='.$act_page.'</p>';
//$limits = '0,'.ITEMS_PER_PAGE; # 0.0.4
$limits = '0,' . $items_per_page;
# 0.0.4
if ($paginate == 'next' && $act_page < $tot_pages - 1) {
$act_page++;
//$limits = ($act_page * ITEMS_PER_PAGE).','.ITEMS_PER_PAGE; # 0.0.4
$limits = $act_page * $items_per_page . ',' . $items_per_page;
# 0.0.4
} elseif ($paginate == 'prev' && $act_page > 0) {
$act_page--;
//$limits = ($act_page * ITEMS_PER_PAGE).','.ITEMS_PER_PAGE; # 0.0.4
$limits = $act_page * $items_per_page . ',' . $items_per_page;
# 0.0.4
} elseif (is_numeric($paginate)) {
$act_page = $paginate;
//$limits = ($act_page * ITEMS_PER_PAGE).','.ITEMS_PER_PAGE; # 0.0.4
$limits = $act_page * $items_per_page . ',' . $items_per_page;
# 0.0.4
}
$_SESSION[EDIT_TABLE_NAME . '_paginate']['thispage'] = $act_page;
$_SESSION[EDIT_TABLE_NAME . '_paginate']['tot_pages'] = $tot_pages;
//echo '<p class="todo">OUT $act_page='.$act_page.'</p>';
//echo '<p class="todo">$thisPage='.$thisPage.'</p>';
//echo '<p class="todo">items_per_page='.ITEMS_PER_PAGE.'</p>';
//echo '<p class="todo">thispage='.$_SESSION[EDIT_TABLE_NAME.'_paginate']['thispage'].'</p>';
//echo '<p class="todo">tot_pages='.$_SESSION[EDIT_TABLE_NAME.'_paginate']['tot_pages'].'</p>';
//echo '<p class="todo">$limits='.$limits.'</p>';
return $limits;
}
<div id="content" class="span10">
<!-- content starts -->
<?php
$get_pages = get_table_data('sr_service_images', array('service_id' => $_GET['page']));
$pagess = get_table_data('sr_services', array('id' => $_GET['page']));
//echo "<pre>";print_r($pagess[0]['name']);
?>
<div>
<ul class="breadcrumb">
<li>
<a href="#">Home</a> <span class="divider">/</span>
</li>
<li>
<a href="#"><?php
echo $pagess[0]['name'];
?>
Service images</a>
</li>
<li>
</li>
</ul>
</div>
<?php
if ($_GET['msg'] == 'delete') {
?>
<div class="alert alert-success">Gallary has been Deleted</div>
<?php
}
?>
}
#=========================================
#
# if the user has not enough privileges, redirect to the main site page
#
#=========================================
//check_access($USER_ID,$USER_PW,EDIT_TABLE_MIN_PRIV);
#=========================================
#
# get the required record
#
#=========================================
if ($_REC_MODE == '*add') {
$row_data = array();
} else {
$row_data = get_table_data($RRN, $_SESSION['table_editor']['lang']);
if (!is_array($row_data)) {
?>
<div class="warningBox">
Record ID "<?php
echo $RRN;
?>
" not found in table "<?php
echo $TABLE;
?>
"
</div><?php
return;
}
