function pagination($messageParPage, $sscategorie, $search, $searchColumn)
{
/*
paginatio_array 0->Nbre d'enregistrements
paginatio_array 1->Nbre de pages
paginatio_array 2->Pages actuelle
paginatio_array 3->Première entrée
*/
$pagination_array = array();
if (!empty($search)) {
$sqlQuery = "SELECT COUNT(*) AS total FROM " . TABLE_PREFIX . CATEGORIE_NOM . " WHERE sscat_radio = '" . $sscategorie . "' AND ";
for ($i = 0; $i < sizeof($searchColumn); $i++) {
if ($i != 0 && $i != sizeof($searchColumn)) {
$sqlQuery .= "OR ";
}
$sqlQuery .= $searchColumn[$i] . " like '%" . Db::escape($search) . "%' ";
}
} else {
$sqlQuery = "SELECT COUNT(*) AS total FROM " . TABLE_PREFIX . CATEGORIE_NOM . " WHERE sscat_radio = '" . $sscategorie . "'";
}
$getTotal = Db::query($sqlQuery);
$donnees_total = Db::fetch_assoc($getTotal);
$pagination_array[0] = $donnees_total['total'];
$pagination_array[1] = ceil($pagination_array[0] / $messageParPage);
if (isset($_POST['page'])) {
$pagination_array[2] = intval($_POST['page']);
if ($pagination_array[2] > $pagination_array[1] && $pagination_array[1] > 0) {
$pagination_array[2] = $pagination_array[1];
}
} else {
$pagination_array[2] = 1;
}
$pagination_array[3] = ($pagination_array[2] - 1) * $messageParPage;
return $pagination_array;
}
function pagination($messageParPage, $table, $sscategorie)
{
/*
paginatio_array 0->Nbre d'enregistrements
paginatio_array 1->Nbre de pages
paginatio_array 2->Pages actuelle
paginatio_array 3->Première entrée
*/
$sscategorie = Utils::anti_injection($sscategorie);
$pagination_array = array();
$sqlQuery = "SELECT COUNT(*) AS total FROM " . TABLE_PREFIX . $table . " WHERE sscat_radio=" . $sscategorie;
$getTotal = Db::query($sqlQuery);
$donnees_total = Db::fetch_assoc($getTotal);
$pagination_array[0] = $donnees_total['total'];
$pagination_array[1] = ceil($pagination_array[0] / $messageParPage);
if (isset($_GET['page'])) {
$pagination_array[2] = intval($_GET['page']);
if ($pagination_array[2] > $pagination_array[1] && $pagination_array[1] > 0) {
$pagination_array[2] = $pagination_array[1];
}
} else {
$pagination_array[2] = 1;
}
$pagination_array[3] = ($pagination_array[2] - 1) * $messageParPage;
return $pagination_array;
}
function login()
{
$retour = false;
$login = Db::escape($_POST['login']);
$getAuth = Db::query("SELECT * FROM `" . TABLE_PREFIX . "admin` WHERE `login_txt` = '" . $login . "'\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND `mdp_txt` = '" . Db::escape(md5($_POST['mdp'])) . "'");
if (Db::num_rows($getAuth) > 0) {
$_SESSION['key'] = true;
// Mise en session de la connexion
$entry = Db::fetch_assoc($getAuth);
$retour = true;
} else {
$getLogin = Db::query("SELECT * FROM `" . TABLE_PREFIX . "admin` WHERE `login_txt` = '" . $login . "'");
if (Db::num_rows($getLogin) > 0) {
$this->login = $login;
$getPwd = Db::query("SELECT * FROM `" . TABLE_PREFIX . "admin` WHERE `login_txt` = '" . $login . "'\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND `mdp_txt` = '" . Db::escape(md5($_POST['mdp'])) . "'");
if (Db::num_rows($getPwd) <= 0) {
$this->errors = "pwd";
}
} else {
$this->errors = "login";
}
$retour = false;
}
return $retour;
}
function pagination2($messageParPage, $table, $id)
{
/*
paginatio_array 0->Nbre d'enregistrements
paginatio_array 1->Nbre de pages
paginatio_array 2->Pages actuelle
paginatio_array 3->Premiere entree
*/
$id = Utils::anti_injection($id);
$pagination_array = array();
$sqlQuery = "SELECT COUNT(*) AS total FROM " . TABLE_PREFIX . $table . " where titre_txt_fr like '%" . $id . "%' or description_txtbox_fr like '%" . $id . "%'";
$getTotal = Db::query($sqlQuery);
$donnees_total = Db::fetch_assoc($getTotal);
$pagination_array[0] = $donnees_total['total'];
$pagination_array[1] = ceil($pagination_array[0] / $messageParPage);
if (isset($_GET['page'])) {
$pagination_array[2] = intval($_GET['page']);
if ($pagination_array[2] > $pagination_array[1] && $pagination_array[1] > 0) {
$pagination_array[2] = $pagination_array[1];
}
} else {
$pagination_array[2] = 1;
}
$pagination_array[3] = ($pagination_array[2] - 1) * $messageParPage;
return $pagination_array;
}
function login()
{
$retour = false;
$this->login = Db::escape($_POST[LOGIN]);
$_SESSION['user'] = $this->login;
$mdp = Db::escape($_POST['mdp']);
$getAuth = Query::connexion($this->login, $mdp);
if (Db::num_rows($getAuth) > 0) {
$entry = Db::fetch_assoc($getAuth);
// Mise en session de la connexion et des accès
$_SESSION['key'] = true;
$_SESSION[LOGIN] = $this->login;
foreach ($entry as $column => $value) {
if ($column == ACCESS) {
$_SESSION[ACCESS] = $value;
}
}
// Sauve la transaction pour l'historique
Db::add_transaction_execute(LOGIN, "4294967290", $_SESSION[LOGIN]);
$retour = true;
} else {
$getLogin = Query::connexionLogin($this->login);
if (Db::num_rows($getLogin) > 0) {
$this->errors = "pwd";
} else {
$this->errors = LOGIN;
}
$retour = false;
}
return $retour;
}
/**
* Find feeds from db
*
* @return array feeds
*/
protected function getFeeds()
{
$feeds = array();
$result = $this->dbh->query("SELECT id, title\n FROM ttrss_feeds\n WHERE owner_uid = " . $_SESSION["uid"] . " ORDER BY order_id, title");
while ($line = $this->dbh->fetch_assoc($result)) {
$feeds[] = (object) $line;
}
return $feeds;
}
function sendNewsletter($titre, $contenu, $view)
{
$passage_ligne = "\r\n";
//=====Déclaration des messages au format HTML
$patterns = array();
$replacements = array();
$patterns[0] = '/<h1/';
$replacements[0] = '<h1 style="width:770px;line-height:25px;font-size:18px;padding-left:5px;background-color:#f49f25;"';
$string = preg_replace($patterns, $replacements, stripslashes($contenu));
$string = str_replace('../albums', 'http://www.pcf-cdh.be/albums', $string);
$string = str_replace("<a href=", "<a style=\"color:#f49f25;\" href=", $string);
$message_html = "\n\t\t\t<div style=\"width:800px;min-height:600px;font-size:11px;font-family:Verdana;\">\n\t\t\t\t<div>\n\t\t\t\t\t<img src=\"http://www.pcf-cdh.be/images/header.jpg\" height=\"175px;\" />\n\t\t\t\t</div>\n\t\t\t\t<div style=\"margin-left:14px;width:770px;min-height:300px;\">\n\t\t\t\t" . $string . "\n\t\t\t\t</div>\n\t\t\t\t<div>\n\t\t\t\t\t<a style=\"text-decoration:none;\" href=\"http://www.pcf-cdh.be/deputy.php\"><img src=\"http://www.pcf-cdh.be/images/footer.jpg\" style=\"height:66px;border:none;\" /></a>\n\t\t\t\t\t<a style=\"text-decoration:none;\" href=\"http://www.pcf-cdh.be\"><img src=\"http://www.pcf-cdh.be/images/footer2.jpg\" style=\"height:50px;border:none;\" /></a>\n\t\t\t\t</div>\n\t\t\t\t<div style=\"width:800px;text-align:center;\">\n\t\t\t\t\t<a style=\"text-decoration:none;font-size:8px;\" href=\"http://www.pcf-cdh.be/desincription.php\">Se désabonner de la newsletters</a>\n\t\t\t\t</div>\n\t\t\t</div>";
//=====Création de la boundary
$boundary = "-----=" . md5(rand());
$boundary_alt = "-----=" . md5(rand());
//=====Définition du sujet
$sujet = "Newsletter du groupe cdH : " . $titre;
//=========
//=====Création du header de l'e-mail
$header = "From: " . MAIL . "" . $passage_ligne;
$header .= "Reply-to: " . MAIL . "" . $passage_ligne;
$header .= "MIME-Version: 1.0" . $passage_ligne;
$header .= "Content-Type: multipart/mixed;" . $passage_ligne . " boundary=\"{$boundary}\"" . $passage_ligne;
//==========
//=====Création du message
$message = $passage_ligne . "--" . $boundary . $passage_ligne;
$message .= "Content-Type: multipart/alternative;" . $passage_ligne . " boundary=\"{$boundary_alt}\"" . $passage_ligne;
$message .= $passage_ligne . "--" . $boundary_alt . $passage_ligne;
//=====Ajout du message au format HTML
$message .= "Content-Type: text/html; charset=\"ISO-8859-1\"" . $passage_ligne;
$message .= "Content-Transfer-Encoding: 8bit" . $passage_ligne;
$message .= $passage_ligne . $message_html . $passage_ligne;
//=====On ferme la boundary alternative
$message .= $passage_ligne . "--" . $boundary_alt . "--" . $passage_ligne;
$message .= $passage_ligne . "--" . $boundary . $passage_ligne;
//=====Envoi de l'e-mail
if ($view == true) {
$sqlQuery = "SELECT email_txt FROM cdh_newsletter";
$getEntries = Db::query($sqlQuery);
if (Db::num_rows($getEntries) > 0) {
$entry = Db::fetch_assoc($getEntries);
while ($entry) {
foreach ($entry as $column => $value) {
$value = stripslashes(htmlentities($value, ENT_QUOTES, "iso-8859-1"));
mail($value, $sujet, $message, $header);
}
$entry = Db::fetch_assoc($getEntries);
}
}
header("Location: http://www.pcf-cdh.be/admin/index.php?module=newsletter&categorie=5&sscategorie=14&send=true");
} else {
mail('', $sujet, $message, $header);
mail('', $sujet, $message, $header);
mail('', $sujet, $message, $header);
header("Location: http://www.pcf-cdh.be/admin/index.php?module=newsletter&categorie=5&sscategorie=14&send=true");
}
}
function sendNewsletter($titre, $contenu, $view)
{
$passage_ligne = "\r\n";
//=====Declaration des messages au format HTML
$patterns = array();
$patterns[0] = '/<img src="../albums/';
$replacements = array();
$replacements[0] = '<img src="http://www.microniser.com/albums/';
$string = preg_replace($patterns, $replacements, stripslashes($contenu));
$string = str_replace("<a href=", "<a style=\"color:#f49f25;\" href=", $string);
$message_html = "\r\n\t\t\t<div style=\"width:800px;min-height:600px;font-size:10px;font-family:Verdana;\">\r\n\t\t\t\t<div>\r\n\t\t\t\t\tIMAGE ENTETE\r\n\t\t\t\t</div>\r\n\t\t\t\t<div style=\"margin-left:14px;width:770px;min-height:300px;\">\r\n\t\t\t\t" . $string . "\r\n\t\t\t\t</div>\r\n\t\t\t\t<div>\r\n\t\t\t\t\tIMAGE PIED DE PAGE\r\n\t\t\t\t</div>\r\n\t\t\t\t<div style=\"width:800px;text-align:center;\">\r\n\t\t\t\t\t<a style=\"text-decoration:none;font-size:8px;\" href=\"http://www.microniser.com/desincription.php\">Se désabonner de la newsletters</a>\r\n\t\t\t\t</div>\r\n\t\t\t</div>";
//=====Creation de la boundary
$boundary = "-----=" . md5(rand());
$boundary_alt = "-----=" . md5(rand());
//=====Definition du sujet
$sujet = "Newsletter Microniser : " . $titre;
//=========
//=====Creation du header de l'e-mail
$header = "From: " . MAIL . "" . $passage_ligne;
$header .= "Reply-to: " . MAIL . "" . $passage_ligne;
$header .= "MIME-Version: 1.0" . $passage_ligne;
$header .= "Content-Type: multipart/mixed;" . $passage_ligne . " boundary=\"{$boundary}\"" . $passage_ligne;
//==========
//=====Creation du message
$message = $passage_ligne . "--" . $boundary . $passage_ligne;
$message .= "Content-Type: multipart/alternative;" . $passage_ligne . " boundary=\"{$boundary_alt}\"" . $passage_ligne;
$message .= $passage_ligne . "--" . $boundary_alt . $passage_ligne;
//=====Ajout du message au format HTML
$message .= "Content-Type: text/html; charset=\"ISO-8859-1\"" . $passage_ligne;
$message .= "Content-Transfer-Encoding: 8bit" . $passage_ligne;
$message .= $passage_ligne . $message_html . $passage_ligne;
//=====On ferme la boundary alternative
$message .= $passage_ligne . "--" . $boundary_alt . "--" . $passage_ligne;
$message .= $passage_ligne . "--" . $boundary . $passage_ligne;
//=====Envoi de l'e-mail
if ($view == true) {
$sqlQuery = "SELECT email_txt FROM micro_newsletters";
$getEntries = Db::query($sqlQuery);
if (Db::num_rows($getEntries) > 0) {
$entry = Db::fetch_assoc($getEntries);
while ($entry) {
foreach ($entry as $column => $value) {
$value = stripslashes(htmlentities($value, ENT_QUOTES, "iso-8859-1"));
//mail($value, $sujet, $message, $header);
}
$entry = Db::fetch_assoc($getEntries);
}
}
header("Location: http://www.microniser.com/admin/index.php?module=newsletters&categorie=7&sscategorie=41&send=true");
} else {
mail('', $sujet, $message, $header);
header("Location: http://www.microniser.com/admin/index.php?module=newsletters&categorie=7&sscategorie=41");
}
}
function sendNewsletter($groupe, $sujet, $contenu)
{
//=====Declaration des messages au format HTML
$message_html = "\n\t\t\t<div style=\"width:800px;min-height:600px;font-size:10px;font-family:Verdana;\">\n\t\t\t\t<div>\n\t\t\t\t\tIMAGE ENTETE\n\t\t\t\t</div>\n\t\t\t\t<div style=\"margin-left:14px;width:770px;min-height:300px;\">\n\t\t\t\t" . $contenu . "\n\t\t\t\t</div>\n\t\t\t\t<div>\n\t\t\t\t\tIMAGE PIED DE PAGE\n\t\t\t\t</div>\n\t\t\t\t<div style=\"width:800px;text-align:center;\">\n\t\t\t\t\t<a style=\"text-decoration:none;font-size:8px;\" href=\"http://www.microniser.com/desincription.php\">Se désabonner de la newsletters</a>\n\t\t\t\t</div>\n\t\t\t</div>";
//=====Envoi de l'e-mail
$getEntries = Query::selectEmailNewslettersWithGroup($groupe);
if (Db::num_rows($getEntries) > 0) {
$entry = Db::fetch_assoc($getEntries);
while ($entry) {
foreach ($entry as $column => $email) {
//Mail::ConstructBoundary($email, $sujet, $message_html)
echo $email;
}
$entry = Db::fetch_assoc($getEntries);
}
}
header("Location: " . SITE_URL . "/admin/webpassions.php?module=historiquenewsletters&categorie=130&sscategorie=130&send=send" . $groupe);
}
function getEnumValue($column, $val)
{
$sqlQuery = "SELECT " . $column . " FROM " . TABLE_PREFIX . CATEGORIE_NOM . "_" . $column;
$getEntries = Db::query($sqlQuery);
$tmp = '<select name="' . $column . '" class="jNiceSelectWrapper"><option></option>';
if (Db::num_rows($getEntries) > 0) {
$entry = Db::fetch_assoc($getEntries);
while ($entry) {
foreach ($entry as $column => $option) {
$selected = $val == $option ? 'selected="selected"' : '';
// are we selected?
$tmp .= '<option value="' . $option . '" ' . $selected . '>' . $option . '</option>';
}
$entry = Db::fetch_assoc($getEntries);
}
}
$tmp .= '</select>';
return $tmp;
}
function login()
{
$retour = false;
$login = Db::escape($_POST['login']);
$mdp = Db::escape($_POST['mdp']);
$getAuth = Query::connexion($login, $mdp);
if (Db::num_rows($getAuth) > 0) {
// Mise en session de la connexion
$_SESSION['key'] = true;
$entry = Db::fetch_assoc($getAuth);
$retour = true;
} else {
$getLogin = Query::connexionLogin($login);
if (Db::num_rows($getLogin) > 0) {
$this->login = $login;
$this->errors = "pwd";
} else {
$this->errors = "login";
}
$retour = false;
}
return $retour;
}
function pagination($messageParPage, $sscategorie, $search, $searchColumn)
{
$pagination_array = array();
/*
paginatio_array 0->Nbre d'enregistrements
paginatio_array 1->Nbre de pages
paginatio_array 2->Pages actuelle
paginatio_array 3->Première entrée
*/
$getTotal = Query::pagination($sscategorie, $search, $searchColumn);
$donnees_total = Db::fetch_assoc($getTotal);
$pagination_array[0] = $donnees_total['total'];
$pagination_array[1] = ceil($pagination_array[0] / $messageParPage);
if (isset($_POST['page'])) {
$pagination_array[2] = intval($_POST['page']);
if ($pagination_array[2] > $pagination_array[1] && $pagination_array[1] > 0) {
$pagination_array[2] = $pagination_array[1];
}
} else {
$pagination_array[2] = 1;
}
$pagination_array[3] = ($pagination_array[2] - 1) * $messageParPage;
return $pagination_array;
}
function login()
{
$retour = false;
$login = Utils::anti_injection($_POST['login']);
$getAuth = Db::query("SELECT * FROM `" . TABLE_PREFIX . "admin` WHERE `login_txt` = '" . $login . "'");
if (Db::num_rows($getAuth) > 0) {
$mdp = Utils::anti_injection($_POST['mdp']);
$getMdp = Db::query("SELECT * FROM `" . TABLE_PREFIX . "admin` WHERE `login_txt` = '" . $login . "'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND `mdp_txt` = '" . md5($mdp) . "'");
if (Db::num_rows($getMdp) > 0) {
$_SESSION['key'] = true;
// Mise en session de la connexion
$retour = true;
} else {
$this->login = $login;
$this->errors = "pwd";
$retour = false;
}
$entry = Db::fetch_assoc($getMdp);
} else {
$this->errors = "login";
$retour = false;
}
return $retour;
}
function displaySSMenu($lang)
{
$layout = "";
$getssCategories = Query::sousCategories();
$ssCategorie = Db::fetch_assoc($getssCategories);
while ($ssCategorie) {
$url = 'module=' . CATEGORIE_NOM . '&categorie=' . CATEGORIE_ID . '&sscategorie=' . $ssCategorie['id'];
$layout .= '<li>';
$layout .= '<a href="webpassions.php" onclick="formURL(\'' . $url . '\');return false;">' . $lang[WRAPPER][$ssCategorie['sscategorie']] . '</a>';
$layout .= '</li>';
$ssCategorie = Db::fetch_assoc($getssCategories);
}
if (empty($layout)) {
$layout .= '<li>';
$layout .= '<a href="webpassions.php" onclick="formURL(\'module=dashboard\');return false;">' . $lang[WRAPPER]['tableau'] . '</a>';
$layout .= '</li>';
if ($_SESSION[ACCESS] == FULL) {
$layout .= '<li>';
$layout .= '<a href="webpassions.php" onclick="formURL(\'module=statistique&categorie=110\');return false;">' . $lang[WRAPPER]['statistique'] . '</a>';
$layout .= '</li>';
}
$layout .= '<li>';
$layout .= '<a href="webpassions.php" onclick="formURL(\'module=document&categorie=100&folder=123456789cms\');return false;">' . $lang[WRAPPER]['help'] . '</a>';
$layout .= '</li>';
$layout .= '<li>';
$layout .= '<a href="webpassions.php" onclick="formURL(\'module=contact\');return false;">' . $lang[WRAPPER]['contact'] . '</a>';
$layout .= '</li>';
$layout .= '<li>';
$layout .= '<a href="webpassions.php" onclick="formURL(\'authenticate=out\');return false;">' . $lang[WRAPPER][LOGOUT] . '</a>';
$layout .= '</li>';
}
return $layout;
}
public static function table_list_grid($request, $table, $field, $condition, $order = '', $bilrow = 10, $dbg = 'N')
{
$error = '';
$x = 0;
$cari = chk($request['cari']);
$all = chk($request['fw_all']);
$sql = "SELECT {$field} FROM {$table} WHERE {$condition}";
list($data, $sts) = Db::query($sql);
if ($sts != '1') {
echo $sts;
} else {
if ($order == '') {
$order = Db::field_name($data, 0);
}
if ($cari != '') {
$cari = str_replace("'", "''", $cari);
$bil_field = Db::num_fields($data);
$carian = '';
$array_field = explode(",", $field);
//echo '<pre>'; print_r($array_field); echo '</pre>';
$bil_field = count($array_field);
for ($a = 0; $a < $bil_field; $a++) {
$nama_field = Db::field_name($data, $a);
// $nama_field_all = $array_field[$a];
//
// $pos = strpos($nama_field_all, '*');
//
// if ($pos === false) {
// $nama_field = $nama_field_all;
// switch (Db::$db)
// {
// case 'Pg':
// $carian = "$carian CAST($nama_field AS TEXT) ILIKE '%$cari%' OR";
// break;
// case 'Mysql':
// $carian = "$carian $nama_field LIKE '%$cari%' OR";
// break;
// case 'Oci':
// $carian = "$carian lower($nama_field) LIKE lower('%$cari%') OR";
// break;
// }
// }
$type_field = Db::field_type($data, $a);
$array_type = array("timestamp", "float8", "int4");
foreach ($array_field as $fieldselect) {
if (strpos($fieldselect, $nama_field) !== false) {
$nama_field = $fieldselect;
}
$position = strpos($nama_field, ' as ');
if ($position != '') {
$nama_field = substr($nama_field, '0', $position);
}
$position = strpos($nama_field, ' AS ');
if ($position != '') {
$nama_field = substr($nama_field, '0', $position);
}
$nama_field = str_replace('DISTINCT ', '', $nama_field);
}
if (!in_array($type_field, $array_type)) {
switch (Db::$db) {
case 'Pg':
$carian = "{$carian} CAST({$nama_field} AS TEXT) ILIKE '%{$cari}%' OR";
break;
case 'Mysql':
$carian = "{$carian} {$nama_field} LIKE '%{$cari}%' OR";
break;
case 'Oci':
$carian = "{$carian} lower({$nama_field}) LIKE lower('%{$cari}%') OR";
break;
}
}
}
$carian = "(" . substr($carian, 1, -3) . ")";
$condition = "{$condition} AND {$carian}";
}
$totalreturned = Db::num_rows($table, $field, $condition);
$request = datagrid($request, $totalreturned, $bilrow);
$request['fw_all'] = $all;
$page_end = $request['page_end'];
$bilrow = $request['bilrow'];
$limit = $request['limit'];
if ($totalreturned == $page_end) {
$page_end = $page_end - $bilrow;
}
if ($page_end < '0') {
$page_end = '0';
}
if (Db::$db == 'Oci') {
$maxrow = $page_end + $bilrow;
$sql = "SELECT * FROM (\n SELECT a.*, ROWNUM fw_bil FROM (\n SELECT {$field}\n FROM {$table}\n WHERE {$condition}\n ORDER BY {$order}\n ) a WHERE rownum <= {$maxrow}\n ) where fw_bil > {$page_end}";
// ORDER BY $order";
} else {
$condition = "{$condition} ORDER BY {$order} LIMIT {$bilrow} OFFSET {$page_end} ";
$sql = "SELECT {$field} FROM {$table} WHERE {$condition}";
}
list($data, $sts) = Db::query($sql);
if ($sts != '1') {
echo $sts;
} else {
$datarow = Db::fetch_assoc($data);
if (is_array($datarow)) {
foreach ($datarow as $row => $value) {
$datarow[$row]['fw_bil'] = $row + $page_end;
}
}
}
}
if ($dbg == 'Y') {
echo "<br>DEBUG : " . $sql . "<br>";
} elseif ($dbg == 'D') {
echo "<br>DEBUG : " . $sql . "<br>";
echo "<pre>";
print_r($datarow);
echo "</pre>";
}
return array('totalreturned' => $totalreturned, 'page_end' => $page_end, 'request' => $request, 'fw_senarai' => chk($datarow));
}
function delete($id, $categ)
{
$title = "";
$getEntries = Query::selectById($id);
if (Db::num_rows($getEntries)) {
$entry = Db::fetch_assoc($getEntries);
foreach ($entry as $column => $value) {
if (CATEGORIE_NOM == "news") {
if ($column == "titre_txt") {
$title = $value;
}
} elseif (CATEGORIE_NOM == "membre") {
if ($column == "nom_txt" || $column == "nom_txt") {
$title .= $value;
}
} elseif (CATEGORIE_NOM == "newsletters") {
if ($column == "email_txt") {
$title = $value;
}
} elseif (CATEGORIE_NOM == "users") {
$title = $value;
}
}
$entry = Db::fetch_assoc($getEntries);
}
Db::add_transaction_execute(DELETE, $categ, $title);
return Db::executeQuery("UPDATE `" . TABLE_PREFIX . CATEGORIE_NOM . "` SET `delete_logical` = '1' WHERE `id` = '" . Db::escape($id) . "'");
}