Kleeja/includes/adm/l_rules.php

<?php
/**
*
* @package adm
* @copyright (c) 2007 Kleeja.net
* @license ./docs/license.txt
*
*/


// not for directly open
if (! defined('IN_ADMIN'))
{
    exit();
}

//for style ..
$stylee    = 'admin_rules';
$action    = basename(ADMIN_PATH) . '?cp=' . basename(__file__, '.php');

$affected       = false;
$H_FORM_KEYS    = kleeja_add_form_key('adm_rules');

//
// Check form key
//
if (ip('submit'))
{
    if (! kleeja_check_form_key('adm_rules'))
    {
        kleeja_admin_err($lang['INVALID_FORM_KEY'], true, $lang['ERROR'], true, $action, 1);
    }
}


$query    = [
    'SELECT'       => 'rules',
    'FROM'         => "{$dbprefix}stats"
];

$result = $SQL->build($query);

while ($row=$SQL->fetch_array($result))
{
    $rules = p('rules_text', 'str', $row['rules']);

    //when submit
    if (ip('submit'))
    {
        //update
        $update_query    = [
            'UPDATE'       => "{$dbprefix}stats",
            'SET'          => "rules = '" . $SQL->real_escape(htmlspecialchars_decode($rules)) . "'"
        ];

        $SQL->build($update_query);

        if ($SQL->affected())
        {
            $affected = true;
            delete_cache('data_rules');
        }
    }
}

$SQL->freeresult($result);


//after submit 
if (ip('submit'))
{
    $text    = ($affected ? $lang['RULES_UPDATED'] : $lang['NO_UP_CHANGE_S']);
    $text    .= '<script type="text/javascript"> setTimeout("get_kleeja_link(\'' . basename(ADMIN_PATH) . '?cp=' . basename(__file__, '.php') . '\');", 2000);</script>' . "\n";
    $stylee    = 'admin_info';
}