public static function set($variable, $value)
{
$v = json_encode($value);
if (!self::exists($variable)) {
database::insert("variables", array("variable_name" => $variable, "variable_value" => $v));
} else {
database::update("variables", array("variable_value" => $v), "variable_name='%var'", array("%var" => $variable));
}
}
function update()
{
$this->onUpdate();
if (!$this->validate($errors)) {
return false;
}
$db = new database();
$db->table = $this->__table;
$db->drop($this);
return $db->update();
}
public static function suspend_command($nick, $ircdata = array())
{
$chan = core::get_chan(&$ircdata, 0);
$reason = core::get_data_after(&$ircdata, 1);
$chan_info = array();
// get the channel.
if (!core::$nicks[$nick]['ircop'] || services::user_exists($nick, true, array('display', 'identified')) === false) {
services::communicate(core::$config->chanserv->nick, $nick, &chanserv::$help->CS_ACCESS_DENIED);
return false;
}
// they've gotta be identified and opered..
if ($chan == '' || $chan[0] != '#') {
services::communicate(core::$config->chanserv->nick, $nick, &chanserv::$help->CS_INVALID_SYNTAX_RE, array('help' => 'SUSPEND'));
return false;
// wrong syntax
}
// make sure they've entered a channel
if (trim($reason) == '') {
$reason = 'No reason';
}
// is there a reason? if not we set it to 'No Reason'
if ($channel = services::chan_exists($chan, array('channel', 'suspended'))) {
if ($channel->suspended == 1) {
services::communicate(core::$config->chanserv->nick, $nick, &chanserv::$help->CS_SUSPEND_2, array('chan' => $chan));
return false;
// channel is already suspended lol
} else {
database::update('chans', array('suspended' => 1, 'suspend_reason' => $reason), array('channel', '=', $channel->channel));
// channel isn't suspended, but it IS registered
}
} else {
$chan_info = array('channel' => $chan, 'timestamp' => core::$network_time, 'last_timestamp' => core::$network_time, 'suspended' => 1, 'suspend_reason' => $reason);
database::insert('chans', $chan_info);
database::insert('chans_flags', array('channel' => $chan, 'flags' => 'd', 'desc' => $reason));
// if the channel isn't registered, we register it, with a founder value of 0
// so we can check when it's unsuspended THAT if the founder value is 0, we'll
// just drop it as well, this way nobody actually gets the founder status.
}
services::communicate(core::$config->chanserv->nick, $nick, &chanserv::$help->CS_SUSPEND_3, array('chan' => $chan, 'reason' => $reason));
core::alog(core::$config->chanserv->nick . ': ' . $nick . ' SUSPENDED ' . $chan . ' with the reason: ' . $reason);
ircd::globops(core::$config->chanserv->nick, $nick . ' SUSPENDED ' . $chan);
if (!empty(core::$chans[$chan]['users'])) {
foreach (core::$chans[$chan]['users'] as $user => $boolean) {
if (!core::$nicks[$nick]['ircop']) {
ircd::kick(core::$config->chanserv->nick, $user, $chan, $reason);
}
}
}
// any users in the channel? KICK EM!! RAWR
}
public static function logout_command($nick, $ircdata = array())
{
// no parameter commands ftw.
if ($user = services::user_exists($nick, false, array('display', 'id', 'identified', 'vhost'))) {
if ($user->identified == 1) {
ircd::on_user_logout($nick);
// here we set unregistered mode
database::update('users', array('identified' => 0, 'last_timestamp' => core::$network_time), array('display', '=', $nick));
// unidentify them
services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_LOGGED_OUT);
// let them know
core::alog(core::$config->nickserv->nick . ': ' . core::get_full_hostname($nick) . ' logged out of ' . core::$nicks[$nick]['nick']);
// and log it.
} else {
services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_NOT_IDENTIFIED);
// not even identified
}
} else {
services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_UNREGISTERED);
// unregistered nick name
}
}
<?php
session_start();
include "../lib/server-config.php";
require "../lib/connect.class.php";
$db = new database();
$db->connect2(trim($u), trim($p), trim($dbn));
//Checking parameter
if (isset($_GET['an']) && isset($_GET['part']) && isset($_GET['to'])) {
if ($_GET['part'] == 'account') {
$strSQL = "UPDATE " . substr(strtolower($tbf), 0, -2) . "useraccount SET status = '" . $_GET['to'] . "' WHERE username = '******'an'] . "'";
$resultUpdate = $db->update($strSQL);
$db->disconnect();
?>
<script>
alert('Activate success!');
window.history.back();
</script>
<?php
exit;
} else {
if ($_GET['part'] == 'institute') {
$strSQL = "UPDATE " . substr(strtolower($tbf), 0, -2) . "institute SET institute_status = '" . $_GET['to'] . "' WHERE institute_id = '" . $_GET['an'] . "'";
$resultUpdate = $db->update($strSQL);
$db->disconnect();
?>
<script>
alert('Activate success!');
window.history.back();
</script>
<?php
public static function unsuspend_command($nick, $ircdata = array())
{
$unick = core::get_nick(&$ircdata, 0);
// get the nick etc.
if (!core::$nicks[$nick]['ircop'] || services::user_exists($nick, true, array('display', 'identified')) === false) {
services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_ACCESS_DENIED);
return false;
}
// they've gotta be identified and opered..
if ($user = services::user_exists($unick, false, array('display', 'suspended', 'real_user'))) {
if ($user->suspended == 0) {
services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_SUSPEND_4, array('nick' => $unick));
return false;
}
// nick isn't suspended
database::update('users', array('suspended' => 0, 'suspend_reason' => null), array('display', '=', $unick));
if ($user->real_user == 0) {
database::delete('users', array('display', '=', $unick));
}
// nick wasen't registered by a real person, drop it
} else {
services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_SUSPEND_4, array('nick' => $unick));
return false;
}
// nick isn't even registered.
services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_SUSPEND_5, array('nick' => $unick));
core::alog(core::$config->nickserv->nick . ': ' . $nick . ' UNSUSPENDED ' . $unick);
ircd::globops(core::$config->nickserv->nick, $nick . ' UNSUSPENDED ' . $unick);
// oh well, was fun while it lasted eh?
// unsuspend it :P
}
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$pay_date_explode = explode("/", trim($_POST['pay_date']));
$pay_date = $pay_date_explode[2] . "-" . $pay_date_explode[1] . "-" . $pay_date_explode[0] . " " . trim($_POST['pay_time']);
$db = new database();
$value_pm = array("pay_money" => trim($_POST['pay_money']), "pay_date" => $pay_date, "detail" => trim($_POST['detail']), "order_id" => $_POST['order_id']);
$query_pm = $db->insert("payments", $value_pm);
if ($query_pm == TRUE) {
$db->update("orders", array("order_status" => "payments"), "id='{$_POST['order_id']}'");
header("location:" . $baseUrl . "/back/order");
}
mysql_close();
}
public static function confirm_command($nick, $ircdata = array())
{
$code = $ircdata[0];
if (trim($code) == '') {
services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_INVALID_SYNTAX_RE, array('help' => 'CONFIRM'));
return false;
}
// wrong syntax
if (!($user = services::user_exists($nick, false, array('display', 'id')))) {
services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_UNREGISTERED);
return false;
}
// unregistered
$code_array = database::select('validation_codes', array('nick', 'code'), array('nick', '=', $nick, 'AND', 'code', '=', $code));
if (database::num_rows($code_array) == 0) {
services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_INVALID_PASSCODE);
} else {
services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_VALIDATED);
// let them know.
database::update('users', array('validated' => 1), array('id', '=', $user->id));
// user is now validated.
database::delete('validation_codes', array('nick', '=', $nick, 'AND', 'code', '=', $code));
// delete the code now that we've validated them
core::alog(core::$config->nickserv->nick . ': ' . $nick . ' activated');
// logchan
}
// no passcode found
}
public function update()
{
//udate the fax
//get the dialplan uuid
$database = new database();
$database->table = "v_fax";
$database->where[0]['name'] = 'domain_uuid';
$database->where[0]['value'] = $this->domain_uuid;
$database->where[0]['operator'] = '=';
$database->where[1]['name'] = 'fax_uuid';
$database->where[1]['value'] = $this->fax_uuid;
$database->where[1]['operator'] = '=';
$result = $database->find();
foreach ($result as $row) {
$this->dialplan_uuid = $row['dialplan_uuid'];
}
//if the extension number is empty and the dialplan exists then delete the dialplan
if (strlen($this->fax_extension) == 0) {
if (strlen($this->dialplan_uuid) > 0) {
//delete dialplan entry
$database = new database();
$database->table = "v_dialplan_details";
$database->where[0]['name'] = 'domain_uuid';
$database->where[0]['value'] = $this->domain_uuid;
$database->where[0]['operator'] = '=';
$database->where[1]['name'] = 'dialplan_uuid';
$database->where[1]['value'] = $this->dialplan_uuid;
$database->where[1]['operator'] = '=';
$database->delete();
//delete the child dialplan information
$database = new database();
$database->table = "v_dialplans";
$database->where[0]['name'] = 'domain_uuid';
$database->where[0]['value'] = $this->domain_uuid;
$database->where[0]['operator'] = '=';
$database->where[1]['name'] = 'dialplan_uuid';
$database->where[1]['value'] = $this->dialplan_uuid;
$database->where[1]['operator'] = '=';
$database->delete();
//update the table to remove the dialplan_uuid
$this->dialplan_uuid = '';
}
}
//update the fax
$fax_uuid = uuid();
$database = new database();
$database->table = "v_fax";
$database->fields['fax_uuid'] = $this->fax_uuid;
$database->fields['dialplan_uuid'] = $this->dialplan_uuid;
$database->fields['domain_uuid'] = $this->domain_uuid;
$database->fields['fax_name'] = $this->fax_name;
$database->fields['fax_extension'] = $this->fax_extension;
$database->fields['fax_email'] = $this->fax_email;
$database->fields['fax_pin_number'] = $this->fax_pin_number;
$database->fields['fax_caller_id_name'] = $this->fax_caller_id_name;
$database->fields['fax_caller_id_number'] = $this->fax_caller_id_number;
$database->fields['fax_forward_number'] = $this->fax_forward_number;
$database->fields['fax_user_list'] = $this->fax_user_list;
$database->fields['fax_description'] = $this->fax_description;
$database->where[0]['name'] = 'domain_uuid';
$database->where[0]['value'] = $this->domain_uuid;
$database->where[0]['operator'] = '=';
$database->where[1]['name'] = 'fax_uuid';
$database->where[1]['value'] = $this->fax_uuid;
$database->where[1]['operator'] = '=';
$database->update();
if (strlen($this->fax_extension) > 0) {
//update the dialplan
$database = new database();
$database->table = "v_dialplans";
$database->fields['dialplan_name'] = $this->fax_name;
$database->fields['dialplan_order'] = '333';
$database->fields['dialplan_context'] = $this->context;
$database->fields['dialplan_enabled'] = $this->fax_enabled;
$database->fields['dialplan_description'] = $this->dialplan_description;
$database->fields['app_uuid'] = $this->app_uuid;
if ($this->dialplan_uuid) {
$database->where[0]['name'] = 'domain_uuid';
$database->where[0]['value'] = $this->domain_uuid;
$database->where[0]['operator'] = '=';
$database->where[1]['name'] = 'dialplan_uuid';
$database->where[1]['value'] = $this->dialplan_uuid;
$database->where[1]['operator'] = '=';
$database->update();
} else {
$database->fields['domain_uuid'] = $this->domain_uuid;
$database->fields['dialplan_uuid'] = $this->dialplan_uuid;
$database->add();
}
//delete the old dialplan details to prepare for new details
$database = new database();
$database->table = "v_dialplan_details";
$database->where[0]['name'] = 'domain_uuid';
$database->where[0]['value'] = $this->domain_uuid;
$database->where[0]['operator'] = '=';
$database->where[1]['name'] = 'dialplan_uuid';
$database->where[1]['value'] = $this->dialplan_uuid;
$database->where[1]['operator'] = '=';
$database->delete();
//add the dialplan details
$detail_data = '^' . $this->fax_extension . '$';
$database->table = "v_dialplan_details";
$database->fields['domain_uuid'] = $this->domain_uuid;
$database->fields['dialplan_uuid'] = $this->dialplan_uuid;
$database->fields['dialplan_detail_uuid'] = uuid();
$database->fields['dialplan_detail_tag'] = 'condition';
//condition, action, antiaction
$database->fields['dialplan_detail_type'] = 'destination_number';
$database->fields['dialplan_detail_data'] = $detail_data;
$database->fields['dialplan_detail_order'] = '005';
$database->add();
if (file_exists(PHP_BINDIR . "/php")) {
define(PHP_BIN, 'php');
}
if (file_exists(PHP_BINDIR . "/php.exe")) {
define(PHP_BIN, 'php.exe');
}
$dialplan_detail_data = "api_hangup_hook=system " . PHP_BINDIR . "/" . PHP_BIN . " " . $_SERVER["DOCUMENT_ROOT"] . PROJECT_PATH . "/secure/fax_to_email.php ";
$dialplan_detail_data .= "email=" . $this->fax_email . " ";
$dialplan_detail_data .= "extension=" . $this->fax_extension . " ";
$dialplan_detail_data .= "name=\\\\\\\${last_fax} ";
$dialplan_detail_data .= "messages='result: \\\\\\\${fax_result_text} sender:\\\\\\\${fax_remote_station_id} pages:\\\\\\\${fax_document_total_pages}' ";
$dialplan_detail_data .= "domain=" . $domain_name . " ";
$dialplan_detail_data .= "caller_id_name='\\\\\\\${caller_id_name}' ";
$dialplan_detail_data .= "caller_id_number=\\\\\\\${caller_id_number} ";
$database->table = "v_dialplan_details";
$database->fields['domain_uuid'] = $this->domain_uuid;
$database->fields['dialplan_uuid'] = $this->dialplan_uuid;
$database->fields['dialplan_detail_uuid'] = uuid();
$database->fields['dialplan_detail_tag'] = 'action';
//condition, action, antiaction
$database->fields['dialplan_detail_type'] = 'set';
$database->fields['dialplan_detail_data'] = $dialplan_detail_data;
$database->fields['dialplan_detail_order'] = '010';
$database->add();
$database->table = "v_dialplan_details";
$database->fields['domain_uuid'] = $this->domain_uuid;
$database->fields['dialplan_uuid'] = $this->dialplan_uuid;
$database->fields['dialplan_detail_uuid'] = uuid();
$database->fields['dialplan_detail_tag'] = 'action';
//condition, action, antiaction
$database->fields['dialplan_detail_type'] = 'answer';
$database->fields['dialplan_detail_data'] = '';
$database->fields['dialplan_detail_order'] = '015';
$database->add();
$database->table = "v_dialplan_details";
$database->fields['domain_uuid'] = $this->domain_uuid;
$database->fields['dialplan_uuid'] = $this->dialplan_uuid;
$database->fields['dialplan_detail_uuid'] = uuid();
$database->fields['dialplan_detail_tag'] = 'action';
//condition, action, antiaction
$database->fields['dialplan_detail_type'] = 'set';
$database->fields['dialplan_detail_data'] = 'fax_enable_t38=true';
$database->fields['dialplan_detail_order'] = '020';
$database->add();
$database->table = "v_dialplan_details";
$database->fields['domain_uuid'] = $this->domain_uuid;
$database->fields['dialplan_uuid'] = $this->dialplan_uuid;
$database->fields['dialplan_detail_uuid'] = uuid();
$database->fields['dialplan_detail_tag'] = 'action';
//condition, action, antiaction
$database->fields['dialplan_detail_type'] = 'set';
$database->fields['dialplan_detail_data'] = 'fax_enable_t38_request=true';
$database->fields['dialplan_detail_order'] = '025';
$database->add();
$database->table = "v_dialplan_details";
$database->fields['domain_uuid'] = $this->domain_uuid;
$database->fields['dialplan_uuid'] = $this->dialplan_uuid;
$database->fields['dialplan_detail_uuid'] = uuid();
$database->fields['dialplan_detail_tag'] = 'action';
//condition, action, antiaction
$database->fields['dialplan_detail_type'] = 'playback';
$database->fields['dialplan_detail_data'] = 'silence_stream://2000';
$database->fields['dialplan_detail_order'] = '030';
$database->add();
$database->table = "v_dialplan_details";
$database->fields['domain_uuid'] = $this->domain_uuid;
$database->fields['dialplan_uuid'] = $this->dialplan_uuid;
$database->fields['dialplan_detail_uuid'] = uuid();
$database->fields['dialplan_detail_tag'] = 'action';
//condition, action, antiaction
$database->fields['dialplan_detail_type'] = 'set';
$database->fields['dialplan_detail_data'] = 'last_fax=${caller_id_number}-${strftime(%Y-%m-%d-%H-%M-%S)}';
$database->fields['dialplan_detail_order'] = '035';
$database->add();
$database->table = "v_dialplan_details";
$database->fields['domain_uuid'] = $this->domain_uuid;
$database->fields['dialplan_uuid'] = $this->dialplan_uuid;
$database->fields['dialplan_detail_uuid'] = uuid();
$database->fields['dialplan_detail_tag'] = 'action';
//condition, action, antiaction
$database->fields['dialplan_detail_type'] = 'rxfax';
$dialplan_detail_data = $_SESSION['switch']['storage']['dir'] . '/fax/' . $_SESSION['domains'][$this->domain_uuid]['domain_name'] . '/' . $this->fax_extension . '/inbox/${last_fax}.tif';
$database->fields['dialplan_detail_data'] = $dialplan_detail_data;
$database->fields['dialplan_detail_order'] = '040';
$database->add();
$database->table = "v_dialplan_details";
$database->fields['domain_uuid'] = $this->domain_uuid;
$database->fields['dialplan_uuid'] = $this->dialplan_uuid;
$database->fields['dialplan_detail_uuid'] = uuid();
$database->fields['dialplan_detail_tag'] = 'action';
//condition, action, antiaction
$database->fields['dialplan_detail_type'] = 'hangup';
$database->fields['dialplan_detail_data'] = '';
$database->fields['dialplan_detail_order'] = '045';
$database->add();
}
}
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$db = new database();
$value_py = array("detail" => trim($_POST['detail']), "created" => date('Y-m-d H:i:s'));
$query_py = $db->update("contents", $value_py, "codename='howtopay'");
if ($query_py == TRUE) {
$_SESSION[_ss . 'msg_result'] = TRUE;
header("location:" . $baseUrl . "/back/howtopay");
}
mysql_close();
}
public function update()
{
/* UPDATE multiple tables:
// UPDATE tables SET table1.col1=table2.col2
// WHERE condition;
// needs:
// 1. column names - $this->cols
// 2. table name - $this->table_name
// 3. id - $_GET['id'] from action form
example:
$sql = " UPDATE {$this->table_name} SET
nom=?, prenom=?, nom_khmer=?, prenom_khmer=?, sex_id=?, matricule=?, dob=?, program_id=?
WHERE student_id=?";
/********************************************/
$security_handler = new security();
$security_handler->check_token();
$id = $_GET['id'];
$i = 0;
$cols = '';
$values = array();
foreach ($this->cols as $column) {
array_push($values, $_POST[$column]);
$cols .= $column . '=?,';
$i++;
}
array_push($values, $id);
// add last value to the array, which corresponds to the record id number.
$cols = substr($cols, 0, -1);
$sql = "UPDATE " . $this->table_name . " SET " . $cols . " WHERE " . $this->id_column . "=?";
//echo "<p>sql: ".$sql."<br>";
//echo "<p>values: ";
//var_dump ($values);
$connection = new database();
if ($connection->update($sql, $values)) {
$_SESSION['log'] .= new timestamp("Affected rows: " . $connection->get_row_num());
} else {
$_SESSION['log'] .= new timestamp("Record was not updated in {$_GET['controller']}!");
}
//die();
}
public static function _registered_nick($nick, $user)
{
database::update('users', array('identified' => 0), array('display', '=', $nick));
// set them to identified 0, this might fix that long term bug.
ircd::on_user_logout($nick);
// they shouldn't really have registered mode
if (is_array(nickserv::$help->NS_REGISTERED_NICK)) {
foreach (nickserv::$help->NS_REGISTERED_NICK as $line) {
services::communicate(core::$config->nickserv->nick, $nick, $line);
}
} else {
services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_REGISTERED_NICK);
}
// this is just a crappy function, basically just parses the NS_REGISTERED thing
// we check for arrays and single lines, even though the default is array
// someone might have changed it.
if (nickserv::check_flags($nick, array('S')) && isset(modules::$list['ns_flags'])) {
timer::add(array('ns_identify', 'secured_callback', array($nick)), core::$config->nickserv->secure_time, 1);
services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_SECURED_NICK, array('seconds' => core::$config->nickserv->secure_time));
}
// if the nickname has secure enabled, we let them know that we're watching them :o
}
public function updateData($data, $id)
{
$database = new database();
$data['updated_at'] = date('Y-m-d H:i:s');
$conditions['id'] = $id;
return $database->update('trolls', $data, $conditions);
}
public static function sapass_command($nick, $ircdata = array())
{
$unick = core::get_nick(&$ircdata, 0);
$new_pass = $ircdata[1];
$conf_pass = $ircdata[2];
// new password.
if (!($user = services::user_exists($unick, false, array('display', 'id', 'identified', 'salt')))) {
services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_ISNT_REGISTERED, array('nick' => $unick));
return false;
}
// find out if our user is registered
if (services::is_root($unick) && !services::is_root($nick)) {
services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_ACCESS_DENIED);
return false;
}
// is a non-root trying to change a root's password?
if (!core::$nicks[$nick]['ircop'] || services::user_exists($nick, true, array('display', 'identified')) === false) {
services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_ACCESS_DENIED);
return false;
}
// do we have access to do this?
if (strtolower($new_pass) == strtolower($unick)) {
services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_PASSWORD_NICK_U);
return false;
}
// are they using a reasonable password, eg. != their nick, lol.
if ($new_pass != $conf_pass) {
services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_PASSWORD_DIFF);
return false;
}
// the passwords are different
database::update('users', array('pass' => sha1($new_pass . $user->salt)), array('display', '=', $unick));
// we update the password here, with the users salt.
services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_NEW_PASSWORD_U, array('nick' => $unick, 'pass' => $new_pass));
// let them know
core::alog(core::$config->nickserv->nick . ': ' . core::get_full_hostname($nick) . ' changed the password for ' . $unick);
// logchan
}
public function main(&$ircdata, $startup = false)
{
if (ircd::on_msg(&$ircdata)) {
$nick = core::get_nick(&$ircdata, 0);
$chan = core::get_chan(&$ircdata, 2);
//if ( core::search_nick( $chan ) !== false )
//return false;
// bail if it thinks chan == nick.
if (!($channel = services::chan_exists($chan, array('channel')))) {
return false;
}
// channel isnt registered, halt immediatly..
// either something has cocked up or someone
// has forced us into a channel :S
if (chanserv::check_flags($chan, array('F')) === false) {
return false;
}
// we gotta check if the channel has fantasy commands enabled first
if (commands::on_fantasy_cmd(&$ircdata, 'help', core::$config->chanserv->nick)) {
if (ircd::$halfop) {
$help =& chanserv::$help->CS_HELP_FANTASY_ALL1;
} else {
$help =& chanserv::$help->CS_HELP_FANTASY_ALL2;
}
foreach ($help as $line) {
services::communicate(core::$config->chanserv->nick, $nick, $line, array('p' => core::$config->chanserv->fantasy_prefix));
}
}
// !help command
if (commands::on_fantasy_cmd(&$ircdata, 'owner', core::$config->chanserv->nick) && ircd::$owner) {
if (chanserv::check_levels($nick, $channel->channel, array('q', 'f', 'F')) === false) {
return false;
}
if (strpos($ircdata[4], ':') !== false) {
mode::type_check($chan, $ircdata[4], '+q', core::$config->chanserv->nick);
} elseif (isset($ircdata[4])) {
ircd::mode(core::$config->chanserv->nick, $chan, '+q ' . $ircdata[4]);
} else {
ircd::mode(core::$config->chanserv->nick, $chan, '+q ' . $nick);
}
// check if another param is specified
}
// !owner command
if (commands::on_fantasy_cmd(&$ircdata, 'deowner', core::$config->chanserv->nick) && ircd::$owner) {
if (chanserv::check_levels($nick, $channel->channel, array('q', 'f', 'F')) === false) {
return false;
}
if (strpos($ircdata[4], ':') !== false) {
mode::type_check($chan, $ircdata[4], '-q', core::$config->chanserv->nick);
} elseif (isset($ircdata[4])) {
ircd::mode(core::$config->chanserv->nick, $chan, '-q ' . $ircdata[4]);
} else {
ircd::mode(core::$config->chanserv->nick, $chan, '-q ' . $nick);
}
// check if another param is specified
}
// !deowner command
if (commands::on_fantasy_cmd(&$ircdata, 'protect', core::$config->chanserv->nick) && ircd::$protect) {
if (chanserv::check_levels($nick, $channel->channel, array('a', 'q', 'f', 'F')) === false) {
return false;
}
if (strpos($ircdata[4], ':') !== false) {
mode::type_check($chan, $ircdata[4], '+a', core::$config->chanserv->nick);
} elseif (isset($ircdata[4])) {
ircd::mode(core::$config->chanserv->nick, $chan, '+a ' . $ircdata[4]);
} else {
ircd::mode(core::$config->chanserv->nick, $chan, '+a ' . $nick);
}
// check if another param is specified
}
// !protect command
if (commands::on_fantasy_cmd(&$ircdata, 'deprotect', core::$config->chanserv->nick) && ircd::$protect) {
if (chanserv::check_levels($nick, $channel->channel, array('a', 'q', 'f', 'F')) === false) {
return false;
}
if (strtolower($ircdata[4]) == strtolower(core::$config->chanserv->nick)) {
return false;
}
if (strpos($ircdata[4], ':') !== false) {
mode::type_check($chan, $ircdata[4], '-a', core::$config->chanserv->nick);
} elseif (isset($ircdata[4])) {
ircd::mode(core::$config->chanserv->nick, $chan, '-a ' . $ircdata[4]);
} else {
ircd::mode(core::$config->chanserv->nick, $chan, '-a ' . $nick);
}
// check if another param is specified
}
// !protect command
if (commands::on_fantasy_cmd(&$ircdata, 'op', core::$config->chanserv->nick)) {
if (chanserv::check_levels($nick, $channel->channel, array('o', 'a', 'q', 'f', 'F')) === false) {
return false;
}
if (strpos($ircdata[4], ':') !== false) {
mode::type_check($chan, $ircdata[4], '+o', core::$config->chanserv->nick);
} elseif (isset($ircdata[4])) {
ircd::mode(core::$config->chanserv->nick, $chan, '+o ' . $ircdata[4]);
} else {
ircd::mode(core::$config->chanserv->nick, $chan, '+o ' . $nick);
}
// check if another param is specified
}
// !op command
if (commands::on_fantasy_cmd(&$ircdata, 'deop', core::$config->chanserv->nick)) {
if (chanserv::check_levels($nick, $channel->channel, array('o', 'a', 'q', 'f', 'F')) === false) {
return false;
}
if (strtolower($ircdata[4]) == strtolower(core::$config->chanserv->nick)) {
return false;
}
if (strpos($ircdata[4], ':') !== false) {
mode::type_check($chan, $ircdata[4], '-o', core::$config->chanserv->nick);
} elseif (isset($ircdata[4])) {
ircd::mode(core::$config->chanserv->nick, $chan, '-o ' . $ircdata[4]);
} else {
ircd::mode(core::$config->chanserv->nick, $chan, '-o ' . $nick);
}
// check if another param is specified
}
// !deop command
if (commands::on_fantasy_cmd(&$ircdata, 'halfop', core::$config->chanserv->nick) && ircd::$halfop) {
if (chanserv::check_levels($nick, $channel->channel, array('h', 'o', 'a', 'q', 'f', 'F')) === false) {
return false;
}
if (strpos($ircdata[4], ':') !== false) {
mode::type_check($chan, $ircdata[4], '+h', core::$config->chanserv->nick);
} elseif (isset($ircdata[4])) {
ircd::mode(core::$config->chanserv->nick, $chan, '+h ' . $ircdata[4]);
} else {
ircd::mode(core::$config->chanserv->nick, $chan, '+h ' . $nick);
}
// check if another param is specified
}
// !hop command
if (commands::on_fantasy_cmd(&$ircdata, 'dehalfop', core::$config->chanserv->nick) && ircd::$halfop) {
if (chanserv::check_levels($nick, $channel->channel, array('h', 'o', 'a', 'q', 'f', 'F')) === false) {
return false;
}
if (strtolower($ircdata[4]) == strtolower(core::$config->chanserv->nick)) {
return false;
}
if (strpos($ircdata[4], ':') !== false) {
mode::type_check($chan, $ircdata[4], '-h', core::$config->chanserv->nick);
} elseif (isset($ircdata[4])) {
ircd::mode(core::$config->chanserv->nick, $chan, '-h ' . $ircdata[4]);
} else {
ircd::mode(core::$config->chanserv->nick, $chan, '-h ' . $nick);
}
// check if another param is specified
}
// !dehop command
if (commands::on_fantasy_cmd(&$ircdata, 'voice', core::$config->chanserv->nick)) {
if (chanserv::check_levels($nick, $channel->channel, array('v', 'h', 'o', 'a', 'q', 'f', 'F')) === false) {
return false;
}
if (strpos($ircdata[4], ':') !== false) {
mode::type_check($chan, $ircdata[4], '+v', core::$config->chanserv->nick);
} elseif (isset($ircdata[4])) {
ircd::mode(core::$config->chanserv->nick, $chan, '+v ' . $ircdata[4]);
} else {
ircd::mode(core::$config->chanserv->nick, $chan, '+v ' . $nick);
}
// check if another param is specified
}
// !voice command
if (commands::on_fantasy_cmd(&$ircdata, 'devoice', core::$config->chanserv->nick)) {
if (chanserv::check_levels($nick, $channel->channel, array('v', 'h', 'o', 'a', 'q', 'f', 'F')) === false) {
return false;
}
if (strpos($ircdata[4], ':') !== false) {
mode::type_check($chan, $ircdata[4], '-v', core::$config->chanserv->nick);
} elseif (isset($ircdata[4])) {
ircd::mode(core::$config->chanserv->nick, $chan, '-v ' . $ircdata[4]);
} else {
ircd::mode(core::$config->chanserv->nick, $chan, '-v ' . $nick);
}
// check if another param is specified
}
// !devoice command
if (commands::on_fantasy_cmd(&$ircdata, 'topic', core::$config->chanserv->nick)) {
if (chanserv::check_levels($nick, $channel->channel, array('t', 'F')) === false) {
return false;
}
if (isset($ircdata[4])) {
$topicmask = chanserv::get_flags($chan, 't');
// get the topicmask
if ($topicmask != null) {
$new_topic = core::get_data_after(&$ircdata, 4);
$new_topic = str_replace(' *', ' ' . $new_topic, $topicmask);
$new_topic = str_replace('\\*', '*', $new_topic);
ircd::topic(core::$config->chanserv->nick, $channel->channel, $new_topic);
database::update('chans', array('topic' => $new_topic, 'topic_setter' => core::$config->chanserv->nick), array('channel', '=', $channel->channel));
} else {
$new_topic = trim(core::get_data_after(&$ircdata, 4));
ircd::topic(core::$config->chanserv->nick, $channel->channel, $new_topic);
database::update('chans', array('topic' => $new_topic, 'topic_setter' => core::$config->chanserv->nick), array('channel', '=', $channel->channel));
}
// if there isnt, just set it normally.
}
// make sure there is another mask x]
}
// !topic command
if (commands::on_fantasy_cmd(&$ircdata, 'mode', core::$config->chanserv->nick) || commands::on_fantasy_cmd(&$ircdata, 'm', core::$config->chanserv->nick)) {
if (chanserv::check_levels($nick, $channel->channel, array('h', 'o', 'a', 'q', 'F')) === false) {
return false;
}
if (isset($ircdata[4])) {
$mode_queue = core::get_data_after(&$ircdata, 4);
// get the mode queue
if (!core::$nicks[$nick]['ircop']) {
$mode_queue[0] = str_replace('O', '', $mode_queue[0]);
}
// don't let them MODE +O if they're not an IRCop
ircd::mode(core::$config->chanserv->nick, $chan, $mode_queue);
// check if there are any other parameters in the !mode command
}
// are we even setting a mode?
}
// !mode command
if (commands::on_fantasy_cmd(&$ircdata, 'kick', core::$config->chanserv->nick)) {
if (chanserv::check_levels($nick, $channel->channel, array('r', 'F')) === false) {
return false;
}
// ignore if the nick doesn't have access to perform this
if (isset($ircdata[4])) {
if (chanserv::check_levels($nick, $channel->channel, array('o', 'F')) && chanserv::check_levels($nick, $channel->channel, array('o', 'F')) === false) {
return false;
}
// check if the user kicking, has the access to kick them. that doesn't make sense, but yeah.
if (isset($ircdata[5])) {
$reason = core::get_data_after(&$ircdata, 5);
ircd::kick(core::$config->chanserv->nick, $ircdata[4], $chan, '(' . $nick . ') ' . ($reason != '') ? $reason : 'No reason');
// kick them with the reason
} else {
ircd::kick(core::$config->chanserv->nick, $ircdata[4], $chan, $nick);
// kick them with no reason
}
}
// make sure a parameter is issued
}
// !kick command
if (commands::on_fantasy_cmd(&$ircdata, 'kickban', core::$config->chanserv->nick)) {
if (chanserv::check_levels($nick, $channel->channel, array('r', 'F')) === false) {
return false;
}
// ignore if the nick doesn't have access to perform this
if (isset($ircdata[4])) {
if (chanserv::check_levels($nick, $channel->channel, array('o', 'F')) && chanserv::check_levels($nick, $channel->channel, array('o', 'F')) === false) {
return false;
}
// check if the user kicking, has the access to kick them. that doesn't make sense, but yeah.
if ($user = core::search_nick($ircdata[4])) {
ircd::mode(core::$config->chanserv->nick, $chan, '+b *@' . $user['host']);
if (isset($ircdata[5])) {
$reason = core::get_data_after(&$ircdata, 5);
ircd::kick(core::$config->chanserv->nick, $ircdata[4], $chan, '(' . $nick . ') ' . ($reason != '') ? $reason : 'No reason');
// kick them with the reason
} else {
ircd::kick(core::$config->chanserv->nick, $ircdata[4], $chan, $nick);
// kick them with no reason
}
// check if there is a reason etc.
} else {
return false;
}
}
// make sure a parameter is issued
}
// !ban command
if (commands::on_fantasy_cmd(&$ircdata, 'ban', core::$config->chanserv->nick)) {
if (chanserv::check_levels($nick, $channel->channel, array('r', 'F')) === false) {
return false;
}
// ignore if the nick doesn't have access to perform this
if (isset($ircdata[4])) {
if (chanserv::check_levels($nick, $channel->channel, array('o', 'F')) && chanserv::check_levels($nick, $channel->channel, array('o', 'F')) === false) {
return false;
}
// check if the user kicking, has the access to kick them. that doesn't make sense, but yeah.
if (strpos($ircdata[4], '@') === false && ($user = core::search_nick($ircdata[4]))) {
ircd::mode(core::$config->chanserv->nick, $chan, '+b *@' . $user['host']);
} else {
ircd::mode(core::$config->chanserv->nick, $chan, '+b ' . $ircdata[4]);
}
// is the hostname in our cache? if not just set a ban on it lol.
}
}
// !ban command
if (commands::on_fantasy_cmd(&$ircdata, 'unban', core::$config->chanserv->nick)) {
if (chanserv::check_levels($nick, $channel->channel, array('r', 'F')) === false) {
return false;
}
if (isset($ircdata[4])) {
if (strpos($ircdata[4], '@') === false && ($user = core::search_nick($ircdata[4]))) {
ircd::mode(core::$config->chanserv->nick, $chan, '-b *@' . $user['host']);
} else {
ircd::mode(core::$config->chanserv->nick, $chan, '-b ' . $ircdata[4]);
}
// is the hostname in our cache? if not unban it..
}
}
// !unban command
if (commands::on_fantasy_cmd(&$ircdata, 'flags', core::$config->chanserv->nick) && isset(modules::$list['cs_flags'])) {
$n_ircdata = $ircdata;
unset($n_ircdata[0], $n_ircdata[1], $n_ircdata[2], $n_ircdata[3]);
array_unshift($n_ircdata, $chan);
// construct a new ircdata array
cs_flags::flags_command($nick, $n_ircdata, true);
// execute the flags command with the new data
unset($n_ircdata);
// get rid of this, isn't longer needed
}
// !flags command (experimental)
if (commands::on_fantasy_cmd(&$ircdata, 'levels', core::$config->chanserv->nick) && isset(modules::$list['cs_levels'])) {
$n_ircdata = $ircdata;
unset($n_ircdata[0], $n_ircdata[1], $n_ircdata[2], $n_ircdata[3]);
array_unshift($n_ircdata, $chan);
// construct a new ircdata array
cs_levels::levels_command($nick, $n_ircdata, true);
// execute the flags command with the new data
unset($n_ircdata);
// get rid of this, isn't longer needed
}
// !levels command (experimental)
if (commands::on_fantasy_cmd(&$ircdata, 'sync', core::$config->chanserv->nick) && isset(modules::$list['cs_levels'])) {
cs_levels::on_create(core::$chans[$chan]['users'], $channel);
// execute on_create, cause we just treat it as that
// this is kinda a shortcut, but well worth it.
ircd::notice(core::$config->chanserv->nick, $chan, '' . $nick . ' used SYNC');
}
// !sync command (experimental)
}
// only trigger on channel messages
}
public function update()
{
// update student based on $_post variables and $_get['id']
//UPDATE multiple tables:
// UPDATE tables SET table1.col1=table2.col2
// WHERE condition;
$sql = 'UPDATE students SET
nom=?, prenom=?, nom_khmer=?, prenom_khmer=?, sex_id=?, matricule=?, dob=?, program_id=?, active_id=?
WHERE student_id=?';
$nom = $_POST['nom'];
$prenom = $_POST['prenom'];
$nom_khmer = $_POST['nom_khmer'];
$prenom_khmer = $_POST['prenom_khmer'];
$sex_id = $_POST['sex_id'];
$matricule = $_POST['matricule'];
$dob = $_POST['dob'];
$program_id = $_POST['program_id'];
$active_id = $_POST['active_id'];
$id = $_GET['id'];
$data = array($nom, $prenom, $nom_khmer, $prenom_khmer, $sex_id, $matricule, $dob, $program_id, $active_id, $id);
$connection = new database();
if ($connection->update($sql, $data)) {
$content = "Affected rows: ";
$content .= $connection->get_row_num();
} else {
$content = "Could not update student!";
}
header("Location: http://" . WEBSITE_URL . "/index.php?controller=students&action=index");
$output['content'] = $content;
return $output;
}
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$db = new database();
$value_pc = array("name" => trim($_POST['name']), "codename" => trim($_POST['codename']));
$query_pc = $db->update("product_categories", $value_pc, "id='{$_POST['id']}'");
if ($query_pc == TRUE) {
header("location:" . $baseUrl . "/back/productcategorie");
}
mysql_close();
}
public function main(&$ircdata, $startup = false)
{
if (ircd::on_topic(&$ircdata) || ircd::on_ftopic(&$ircdata)) {
$chan = core::get_chan(&$ircdata, 2);
$topic = core::$chans[$chan]['topic'];
$setter = core::$chans[$chan]['topic_setter'];
// i forgot this was done by the protocol modules
if ($channel = services::chan_exists($chan, array('channel', 'topic'))) {
if (chanserv::check_flags($chan, array('T')) && chanserv::check_flags($chan, array('K')) && $channel->topic != $topic) {
ircd::topic(core::$config->chanserv->nick, $channel->channel, $channel->topic);
database::update('chans', array('topic_setter' => core::$config->chanserv->nick), array('channel', '=', $chan));
return false;
// reset it i reckon.
} elseif ($channel->topiclock == 0) {
database::update('chans', array('topic' => $topic, 'topic_setter' => $setter), array('channel', '=', $chan));
// OTHERWISE, update it.
}
// some housekeepin.
}
// make sure the channel exists.
}
// now we check for topiclocking
// moved this from cs_set to here
// there was 2 versions O.o
}
$deskripsi = $controll->keamanan($_POST['namaacara']);
$pemesan = $controll->keamanan($_POST['penggunaacara']);
$tanggalB = $controll->keamanan($_POST['tanggalpesan']);
$tempat = $controll->keamanan($_POST['pilihan_tempat']);
$indikator = $controll->keamanan($_POST['indikator']);
if ($_FILES['uploadbanner']['name']) {
$name = $_FILES['uploadbanner']['name'];
$size = $_FILES['uploadbanner']['size'];
$tmp = $_FILES['uploadbanner']['tmp_name'];
$controll->uploadfile($name, $size, $tmp, $pemesan, $tempat, $tanggalA);
}
if ($indikator == "aktif") {
$indikator = 1;
} elseif ($indikator == "nonaktif") {
$indikator = 0;
}
if (empty($id = $controll->keamanan($_POST['id_acara']))) {
if ($controll->insertdata($tanggalA, $deskripsi, $pemesan, $tempat, $tanggalB, $indikator) == true) {
echo "<script>alert('Data Berhasil di masukkan !!')</script>";
} else {
echo "<script>alert('Data Gagal di masukkan !!')</script>";
}
} else {
if ($controll->update($id, $tanggalA, $deskripsi, $pemesan, $tempat, $tanggalB, $indikator) == true) {
echo "<script>alert('Data Berhasil di update !!')</script>";
} else {
echo "<script>alert('Data Gagal di update !!')</script>";
}
}
}
header("location:admin.php?controll=home");
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$db = new database();
$option_uw = array("table" => "users", "fields" => "password", "condition" => "id='{$_POST['id']}'");
$query_uw = $db->select($option_uw);
$rs_uw = $db->get($query_uw);
if ($rs_uw['password'] == trim(salt_pass($_POST['oldpassword']))) {
$value_pw = array("password" => trim(salt_pass($_POST['pass'])));
$query_pw = $db->update("users", $value_pw, "id='{$_POST['id']}'");
if ($query_pw == TRUE) {
header("location:" . $baseUrl . "/back/user");
}
} else {
$_SESSION[_ss . 'msg_result'] = TRUE;
header("location:" . $baseUrl . "/back/user/changepassword");
}
mysql_close();
}
$db->debug($dbdebug);
$db->connect($dbhost, $dbuser, $dbpass, $dbname);
//if($mode=='demo') $sql_file="db/phptournois$version.demo.sql";
//else
if ($sql == "16") {
include "db/up_g4_16.php";
$a = explode(';', $req);
if (!$db->query($req)) {
die(mysql_error());
}
$db->exec();
} else {
include "db/up_g4.php";
}
/* update des newseurs */
$db->update("{$dbprefix}joueurs");
$db->set("grade='nz'");
$db->where("newseur = 'O'");
$db->exec();
/* update des admins */
$db->update("{$dbprefix}joueurs");
$db->set("grade='abcdefghijklmnopqrstuvwxyz'");
$db->where("admin = 'O'");
$db->exec();
/* update du fichier de conf */
if (!($fd = @fopen($filename, "a+"))) {
$erreur = 1;
show_erreur("{$strOuvertureInvalideConfigFile} : {$filename}");
} elseif (!fputs($fd, "<?php define('PHPTOURNOIS_INSTALLED',true);?>")) {
$erreur = 1;
show_erreur("{$strEcritureInvalideConfigFile} : {$filename}");
public static function set_flag($nick, $chan, $target, $flag, $param = '')
{
$mode = $flag[0];
$r_flag = $flag[1];
// get the real flag, eg. V, v and mode
if (chanserv::check_levels($target, $chan, array($r_flag), false, false, false, false)) {
$user_flag_q = database::select('chans_levels', array('id', 'channel', 'target', 'flags'), array('channel', '=', $chan, 'AND', 'target', '=', $target));
if ($mode == '-') {
if ($nick == $target && $r_flag == 'F') {
services::communicate(core::$config->chanserv->nick, $nick, &chanserv::$help->CS_LEVELS_BAD_FLAG, array('flag' => $flag));
return false;
}
// someone is trying to de-founder themselves?
if (strpos(self::$set[$target], '-') === false) {
self::$set[$target] .= '-';
}
// ok, no - ?
$user_flag = database::fetch($user_flag_q);
// get the flag record
$new_user_flags = str_replace($r_flag, '', $user_flag->flags);
if ($new_user_flags == '') {
database::delete('chans_levels', array('channel', '=', $chan, 'AND', 'target', '=', $target));
} else {
database::update('chans_levels', array('flags' => $new_user_flags), array('channel', '=', $chan, 'AND', 'target', '=', $target));
}
// check if it's empty, if it is just delete the row
self::$set[$target] .= $r_flag;
// some magic :O
return true;
} else {
self::$already_set[$target] .= $r_flag;
// some magic :O
return false;
}
// the user has the flag, so, if it's - remove it, if it is +
// we send a message back.
} else {
$user_flag_q = database::select('chans_levels', array('id', 'channel', 'target', 'flags'), array('channel', '=', $chan, 'AND', 'target', '=', $target));
if ($mode == '+') {
if (strpos(self::$set[$target], '+') === false) {
self::$set[$target] .= '+';
}
// ok, no + ?
if (database::num_rows($user_flag_q) > 0) {
$user_flag = database::fetch($user_flag_q);
$new_user_flags = $user_flag->flags . $r_flag;
if ($r_flag == 'b' && $mode == '+') {
database::update('chans_levels', array('flags' => $new_user_flags, 'reason' => $param), array('channel', '=', $chan, 'AND', 'target', '=', $target));
} else {
database::update('chans_levels', array('flags' => $new_user_flags), array('channel', '=', $chan, 'AND', 'target', '=', $target));
}
// update.
self::$set[$target] .= $r_flag;
// some magic :O
return true;
} else {
if ($r_flag == 'b' && $mode == '+') {
database::insert('chans_levels', array('channel' => $chan, 'target' => $target, 'flags' => $r_flag, 'reason' => $param));
} else {
database::insert('chans_levels', array('channel' => $chan, 'target' => $target, 'flags' => $r_flag));
}
// insert.
self::$set[$target] .= $r_flag;
// some magic :O
return true;
}
} else {
self::$not_set[$target] .= $r_flag;
// some magic :O
return false;
}
// the user doesn't have the flag, so if it's + add it, if it is -
// we send a message back, basically the opposite of above.
}
}
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$db = new database();
$value_py = array("detail" => trim($_POST['detail']), "created" => date('Y-m-d H:i:s'));
$query_py = $db->update("contents", $value_py, "codename='aboutus'");
if ($query_py == TRUE) {
$_SESSION[_ss . 'msg_result'] = TRUE;
header("location:" . $baseUrl . "/back/aboutus");
}
mysql_close();
}
public static function _join_channel(&$channel)
{
database::update('chans', array('last_timestamp' => core::$network_time), array('channel', '=', $channel->channel));
// lets update the last used timestamp
if (self::check_flags($channel->channel, array('G')) && $channel->suspended == 0 && isset(modules::$list['cs_fantasy']) && !isset(core::$chans[$channel->channel]['users'][core::$config->chanserv->nick])) {
ircd::join_chan(core::$config->chanserv->nick, $channel->channel);
// join the chan.
if (ircd::$protect) {
ircd::mode(core::$config->chanserv->nick, $channel->channel, '+ao ' . core::$config->chanserv->nick . ' ' . core::$config->chanserv->nick);
} else {
ircd::mode(core::$config->chanserv->nick, $channel->channel, '+o ' . core::$config->chanserv->nick);
}
// +o its self.
}
// check if guard is on
$modelock = self::get_flags($channel->channel, 'm');
// store some flag values in variables.
if ($modelock != null && $channel->suspended == 0) {
ircd::mode(core::$config->chanserv->nick, $channel->channel, $modelock);
// Going to have to do some fuffing around here, basically if the channel
// in question is mlocked +i, and somebody has joined it, while its empty
// +i will be set after they have joined the channel, so here we're gonna
// have to kick them out, same applies for +O and +k
$mode_array = mode::sort_modes($modelock);
if (strstr($mode_array['plus'], 'i') || strstr($mode_array['plus'], 'k')) {
foreach (core::$chans[$channel->channel]['users'] as $nick => $modes) {
if (count(core::$chans[$channel->channel]['users']) == 2 && isset(core::$chans[$channel->channel]['users'][core::$config->chanserv->nick])) {
if (self::check_levels($nick, $channel->channel, array('k', 'v', 'h', 'o', 'a', 'q', 'F'), true, false) === false) {
if (strstr($mode_array['plus'], 'i') && $nick != core::$config->chanserv->nick) {
ircd::kick(core::$config->chanserv->nick, $nick, $channel->channel, 'Invite only channel');
timer::add(array('chanserv', 'part_chan_callback', array($channel->channel)), 1, 1);
}
if (strstr($mode_array['plus'], 'k') && $nick != core::$config->chanserv->nick) {
ircd::kick(core::$config->chanserv->nick, $nick, $channel->channel, 'Passworded channel');
timer::add(array('chanserv', 'part_chan_callback', array($channel->channel)), 1, 1);
}
}
}
// if the user isn't on the access list
// we kick them out ^_^
}
}
// is mode i in the modelock?
if (strstr($mode_array['plus'], 'O')) {
foreach (core::$chans[$channel->channel]['users'] as $nick => $modes) {
if (!core::$nicks[$nick]['ircop']) {
ircd::kick(core::$config->chanserv->nick, $nick, $channel->channel, 'IRCop only channel');
timer::add(array('chanserv', 'part_chan_callback', array($channel->channel)), 1, 1);
}
// if the user isn't on the access list
// we kick them out ^_^
}
}
// how about +O?
}
// any modelocks?
if (self::check_flags($channel->channel, array('K')) && !self::check_flags($channel->channel, array('T')) && isset(modules::$list['cs_flags']) && isset(modules::$list['cs_topic'])) {
if (trim($channel->topic) != trim(core::$chans[$channel->channel]['topic']) || $channel->topic != '') {
ircd::topic(core::$config->chanserv->nick, $channel->channel, $channel->topic);
}
// set the previous topic
}
// set the topic to the last known topic
}
public function update()
{
//udate the ivr menu
if (strlen($this->ivr_menu_option_action) == 0) {
//get the dialplan uuid
$database = new database();
if ($this->db) {
$database->db = $this->db;
}
$database->table = "v_ivr_menus";
$database->where[0]['name'] = 'domain_uuid';
$database->where[0]['value'] = $this->domain_uuid;
$database->where[0]['operator'] = '=';
$database->where[1]['name'] = 'ivr_menu_uuid';
$database->where[1]['value'] = $this->ivr_menu_uuid;
$database->where[1]['operator'] = '=';
$result = $database->find();
foreach ($result as $row) {
$this->dialplan_uuid = $row['dialplan_uuid'];
}
//if the extension number is empty and the dialplan exists then delete the dialplan
if (strlen($this->ivr_menu_extension) == 0) {
if (strlen($this->dialplan_uuid) > 0) {
//delete dialplan entry
$database = new database();
$database->table = "v_dialplan_details";
$database->where[0]['name'] = 'domain_uuid';
$database->where[0]['value'] = $this->domain_uuid;
$database->where[0]['operator'] = '=';
$database->where[1]['name'] = 'dialplan_uuid';
$database->where[1]['value'] = $this->dialplan_uuid;
$database->where[1]['operator'] = '=';
$database->delete();
//delete the child dialplan information
$database = new database();
$database->table = "v_dialplans";
$database->where[0]['name'] = 'domain_uuid';
$database->where[0]['value'] = $this->domain_uuid;
$database->where[0]['operator'] = '=';
$database->where[1]['name'] = 'dialplan_uuid';
$database->where[1]['value'] = $this->dialplan_uuid;
$database->where[1]['operator'] = '=';
$database->delete();
//update the table to remove the dialplan_uuid
$this->dialplan_uuid = '';
}
}
//update the ivr menu
if (strlen($this->dialplan_uuid) == 0) {
$this->dialplan_uuid = uuid();
}
$database = new database();
$database->table = "v_ivr_menus";
$database->fields['ivr_menu_uuid'] = $this->ivr_menu_uuid;
$database->fields['dialplan_uuid'] = $this->dialplan_uuid;
$database->fields['ivr_menu_name'] = $this->ivr_menu_name;
$database->fields['ivr_menu_extension'] = $this->ivr_menu_extension;
$database->fields['ivr_menu_greet_long'] = $this->ivr_menu_greet_long;
$database->fields['ivr_menu_greet_short'] = $this->ivr_menu_greet_short;
$database->fields['ivr_menu_invalid_sound'] = $this->ivr_menu_invalid_sound;
$database->fields['ivr_menu_exit_sound'] = $this->ivr_menu_exit_sound;
$database->fields['ivr_menu_confirm_macro'] = $this->ivr_menu_confirm_macro;
$database->fields['ivr_menu_confirm_key'] = $this->ivr_menu_confirm_key;
$database->fields['ivr_menu_tts_engine'] = $this->ivr_menu_tts_engine;
$database->fields['ivr_menu_tts_voice'] = $this->ivr_menu_tts_voice;
$database->fields['ivr_menu_confirm_attempts'] = $this->ivr_menu_confirm_attempts;
$database->fields['ivr_menu_timeout'] = $this->ivr_menu_timeout;
$database->fields['ivr_menu_exit_app'] = $this->ivr_menu_exit_app;
$database->fields['ivr_menu_exit_data'] = $this->ivr_menu_exit_data;
$database->fields['ivr_menu_inter_digit_timeout'] = $this->ivr_menu_inter_digit_timeout;
$database->fields['ivr_menu_max_failures'] = $this->ivr_menu_max_failures;
$database->fields['ivr_menu_max_timeouts'] = $this->ivr_menu_max_timeouts;
$database->fields['ivr_menu_max_timeouts'] = $this->ivr_menu_max_timeouts;
$database->fields['ivr_menu_digit_len'] = $this->ivr_menu_digit_len;
$database->fields['ivr_menu_digit_len'] = $this->ivr_menu_digit_len;
$database->fields['ivr_menu_direct_dial'] = $this->ivr_menu_direct_dial;
$database->fields['ivr_menu_ringback'] = $this->ivr_menu_ringback;
$database->fields['ivr_menu_cid_prefix'] = $this->ivr_menu_cid_prefix;
$database->fields['ivr_menu_enabled'] = $this->ivr_menu_enabled;
$database->fields['ivr_menu_description'] = $this->ivr_menu_description;
$database->where[0]['name'] = 'domain_uuid';
$database->where[0]['value'] = $this->domain_uuid;
$database->where[0]['operator'] = '=';
$database->where[1]['name'] = 'ivr_menu_uuid';
$database->where[1]['value'] = $this->ivr_menu_uuid;
$database->where[1]['operator'] = '=';
$database->update();
//check to see if the dialplan entry exists
$dialplan = new dialplan();
$dialplan->domain_uuid = $_SESSION["domain_uuid"];
$dialplan->dialplan_uuid = $this->dialplan_uuid;
$dialplan_exists = $dialplan->dialplan_exists();
//if the dialplan entry does not exist then add it
if (!$dialplan_exists) {
$database = new database();
$database->table = "v_dialplans";
$database->fields['dialplan_name'] = $this->ivr_menu_name;
$database->fields['dialplan_order'] = '333';
$database->fields['dialplan_context'] = $_SESSION['context'];
$database->fields['dialplan_enabled'] = $this->ivr_menu_enabled;
$database->fields['dialplan_description'] = $this->ivr_menu_description;
$database->fields['app_uuid'] = $this->app_uuid;
$database->fields['domain_uuid'] = $this->domain_uuid;
$database->fields['dialplan_uuid'] = $this->dialplan_uuid;
$database->add();
}
//if the dialplan entry exists then update it
if ($dialplan_exists && strlen($this->ivr_menu_extension) > 0) {
//update the dialplan
$database = new database();
$database->table = "v_dialplans";
$database->fields['dialplan_name'] = $this->ivr_menu_name;
$database->fields['dialplan_order'] = '333';
$database->fields['dialplan_context'] = $_SESSION['context'];
$database->fields['dialplan_enabled'] = $this->ivr_menu_enabled;
$database->fields['dialplan_description'] = $this->ivr_menu_description;
$database->fields['app_uuid'] = $this->app_uuid;
$database->fields['domain_uuid'] = $this->domain_uuid;
$database->fields['dialplan_uuid'] = $this->dialplan_uuid;
$database->where[0]['name'] = 'domain_uuid';
$database->where[0]['value'] = $this->domain_uuid;
$database->where[0]['operator'] = '=';
$database->where[1]['name'] = 'dialplan_uuid';
$database->where[1]['value'] = $this->dialplan_uuid;
$database->where[1]['operator'] = '=';
$database->update();
//delete the old dialplan details to prepare for new details
$database = new database();
$database->table = "v_dialplan_details";
$database->where[0]['name'] = 'domain_uuid';
$database->where[0]['value'] = $this->domain_uuid;
$database->where[0]['operator'] = '=';
$database->where[1]['name'] = 'dialplan_uuid';
$database->where[1]['value'] = $this->dialplan_uuid;
$database->where[1]['operator'] = '=';
$database->delete();
}
//add the dialplan details
$detail_data = '^' . $this->ivr_menu_extension . '$';
$database->table = "v_dialplan_details";
$database->fields['domain_uuid'] = $this->domain_uuid;
$database->fields['dialplan_uuid'] = $this->dialplan_uuid;
$database->fields['dialplan_detail_uuid'] = uuid();
$database->fields['dialplan_detail_tag'] = 'condition';
//condition, action, antiaction
$database->fields['dialplan_detail_type'] = 'destination_number';
$database->fields['dialplan_detail_data'] = $detail_data;
$database->fields['dialplan_detail_order'] = '005';
$database->add();
$database->table = "v_dialplan_details";
$database->fields['domain_uuid'] = $this->domain_uuid;
$database->fields['dialplan_uuid'] = $this->dialplan_uuid;
$database->fields['dialplan_detail_uuid'] = uuid();
$database->fields['dialplan_detail_tag'] = 'action';
//condition, action, antiaction
$database->fields['dialplan_detail_type'] = 'answer';
$database->fields['dialplan_detail_data'] = '';
$database->fields['dialplan_detail_order'] = '010';
$database->add();
$database->table = "v_dialplan_details";
$database->fields['domain_uuid'] = $this->domain_uuid;
$database->fields['dialplan_uuid'] = $this->dialplan_uuid;
$database->fields['dialplan_detail_uuid'] = uuid();
$database->fields['dialplan_detail_tag'] = 'action';
//condition, action, antiaction
$database->fields['dialplan_detail_type'] = 'sleep';
$database->fields['dialplan_detail_data'] = '1000';
$database->fields['dialplan_detail_order'] = '015';
$database->add();
$database->table = "v_dialplan_details";
$database->fields['domain_uuid'] = $this->domain_uuid;
$database->fields['dialplan_uuid'] = $this->dialplan_uuid;
$database->fields['dialplan_detail_uuid'] = uuid();
$database->fields['dialplan_detail_tag'] = 'action';
//condition, action, antiaction
$database->fields['dialplan_detail_type'] = 'set';
$database->fields['dialplan_detail_data'] = 'hangup_after_bridge=true';
$database->fields['dialplan_detail_order'] = '020';
$database->add();
$database->table = "v_dialplan_details";
$database->fields['domain_uuid'] = $this->domain_uuid;
$database->fields['dialplan_uuid'] = $this->dialplan_uuid;
$database->fields['dialplan_detail_uuid'] = uuid();
$database->fields['dialplan_detail_tag'] = 'action';
//condition, action, antiaction
$database->fields['dialplan_detail_type'] = 'set';
if ($this->ivr_menu_ringback == "music" || $this->ivr_menu_ringback == "") {
$database->fields['dialplan_detail_data'] = 'ringback=${hold_music}';
} else {
$database->fields['dialplan_detail_data'] = 'ringback=' . $this->ivr_menu_ringback;
}
$database->fields['dialplan_detail_order'] = '025';
$database->add();
$database->table = "v_dialplan_details";
$database->fields['domain_uuid'] = $this->domain_uuid;
$database->fields['dialplan_uuid'] = $this->dialplan_uuid;
$database->fields['dialplan_detail_uuid'] = uuid();
$database->fields['dialplan_detail_tag'] = 'action';
//condition, action, antiaction
$database->fields['dialplan_detail_type'] = 'set';
if ($this->ivr_menu_ringback == "music" || $this->ivr_menu_ringback == "") {
$database->fields['dialplan_detail_data'] = 'transfer_ringback=${hold_music}';
} else {
$database->fields['dialplan_detail_data'] = 'transfer_ringback=' . $this->ivr_menu_ringback;
}
$database->fields['dialplan_detail_order'] = '030';
$database->add();
/*
$database->table = "v_dialplan_details";
$database->fields['domain_uuid'] = $this->domain_uuid;
$database->fields['dialplan_uuid'] = $this->dialplan_uuid;
$database->fields['dialplan_detail_uuid'] = uuid();
$database->fields['dialplan_detail_tag'] = 'action'; //condition, action, antiaction
$database->fields['dialplan_detail_type'] = 'ivr';
if (count($_SESSION["domains"]) > 1) {
$database->fields['dialplan_detail_data'] = $_SESSION['domain_name'].'-'.$this->ivr_menu_name;
}
else {
$database->fields['dialplan_detail_data'] = $this->ivr_menu_name;
}
$database->fields['dialplan_detail_order'] = '035';
$database->add();
*/
$database->table = "v_dialplan_details";
$database->fields['domain_uuid'] = $this->domain_uuid;
$database->fields['dialplan_uuid'] = $this->dialplan_uuid;
$database->fields['dialplan_detail_uuid'] = uuid();
$database->fields['dialplan_detail_tag'] = 'action';
//condition, action, antiaction
$database->fields['dialplan_detail_type'] = 'set';
$database->fields['dialplan_detail_data'] = 'ivr_menu_uuid=' . $this->ivr_menu_uuid;
$database->fields['dialplan_detail_order'] = '035';
$database->add();
$database->table = "v_dialplan_details";
$database->fields['domain_uuid'] = $this->domain_uuid;
$database->fields['dialplan_uuid'] = $this->dialplan_uuid;
$database->fields['dialplan_detail_uuid'] = uuid();
$database->fields['dialplan_detail_tag'] = 'action';
//condition, action, antiaction
$database->fields['dialplan_detail_type'] = 'lua';
$database->fields['dialplan_detail_data'] = 'ivr_menu.lua';
$database->fields['dialplan_detail_order'] = '040';
$database->add();
if (strlen($this->ivr_menu_exit_app) > 0) {
$database->table = "v_dialplan_details";
$database->fields['domain_uuid'] = $this->domain_uuid;
$database->fields['dialplan_uuid'] = $this->dialplan_uuid;
$database->fields['dialplan_detail_uuid'] = uuid();
$database->fields['dialplan_detail_tag'] = 'action';
//condition, action, antiaction
$database->fields['dialplan_detail_type'] = $this->ivr_menu_exit_app;
$database->fields['dialplan_detail_data'] = $this->ivr_menu_exit_data;
$database->fields['dialplan_detail_order'] = '045';
$database->add();
}
}
//update the ivr menu option
if (strlen($this->ivr_menu_option_action) > 0) {
$database = new database();
$database->table = "v_ivr_menu_options";
$database->fields['ivr_menu_option_digits'] = $this->ivr_menu_option_digits;
$database->fields['ivr_menu_option_action'] = $this->ivr_menu_option_action;
$database->fields['ivr_menu_option_param'] = $this->ivr_menu_option_param;
$database->fields['ivr_menu_option_order'] = $this->ivr_menu_option_order;
$database->fields['ivr_menu_option_description'] = $this->ivr_menu_option_description;
$database->where[0]['name'] = 'domain_uuid';
$database->where[0]['value'] = $this->domain_uuid;
$database->where[0]['operator'] = '=';
$database->where[1]['name'] = 'ivr_menu_uuid';
$database->where[1]['value'] = $this->ivr_menu_uuid;
$database->where[1]['operator'] = '=';
$database->where[2]['name'] = 'ivr_menu_option_uuid';
$database->where[2]['value'] = $this->ivr_menu_option_uuid;
$database->where[2]['operator'] = '=';
$database->update();
}
}
public static function update_block($blockname, $fields)
{
database::update("blocks", $fields, "block='%bn'", array("%bn" => $blockname));
}
public static function max_users(&$ircdata)
{
if (ircd::on_connect(&$ircdata)) {
if (count(self::$nicks) > self::$max_users) {
$update_array = array('max_users' => count(self::$nicks), 'max_userstime' => self::$network_time);
$update = database::update('core', $update_array, array('id', '=', '1'));
self::$max_users = count(self::$nicks);
// update the max users
self::alog(self::$config->operserv->nick . ': New user peak: ' . count(self::$nicks) . ' users');
// logchan
return true;
}
// if the current number of users is more than the previous max
}
// if someone has logged in
}
require base_path() . "/library/uploadimg.php";
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$db = new database();
$option_im = array("table" => "products", "fields" => "image", "condition" => "id='{$_POST['id']}'");
$query_im = $db->select($option_im);
$rs_im = $db->get($query_im);
if (checkimg() == TRUE) {
$filename = date('YmdHis') . rand(0, 9);
$type = end(explode(".", $_FILES["image"]["name"]));
$image = $filename . "." . $type;
$path = base_path() . "/upload/product/";
uploadimg($filename, 600, 600, $path);
uploadimg("thumb_" . $filename, 400, 400, $path);
uploadimg("md_" . $filename, 150, 150, $path);
uploadimg("sm_" . $filename, 70, 70, $path);
if ($rs_im['image'] != "ecimage.jpg") {
@unlink($path . $rs_im['image']);
@unlink($path . "thumb_" . $rs_im['image']);
@unlink($path . "md_" . $rs_im['image']);
@unlink($path . "sm_" . $rs_im['image']);
}
} else {
$image = $rs_im['image'];
}
$value_pd = array("name" => trim($_POST['name']), "price" => trim($_POST['price']), "brandname" => trim($_POST['brandname']), "detail" => trim($_POST['detail']), "image" => $image, "product_categorie_id" => trim($_POST['product_categorie_id']));
$query_pd = $db->update("products", $value_pd, "id='{$_POST['id']}'");
if ($query_pd == TRUE) {
header("location:" . $baseUrl . "/back/product");
}
mysql_close();
}
<?php
require_once "../classes/database.php";
$db = new database();
$db->connect();
$postid = $_REQUEST['postid'];
//echo $postid;
if (isset($_REQUEST['postid'])) {
$query = "SELECT * from post where postid='{$postid}'";
$result = $db->selectData($query);
while ($row = mysqli_fetch_array($result)) {
$upvote = $row['upvote'];
$downvote = $row['downvote'];
//echo $upvote." ".$downvote;
}
if ($_REQUEST['vote'] == "up") {
$GLOBALS['upvote']++;
echo $GLOBALS['upvote'];
$query = "UPDATE post set upvote='" . $GLOBALS['upvote'] . "' where postid='{$postid}'";
$db->update($query);
} else {
if ($_REQUEST['vote'] == "down") {
++$GLOBALS['downvote'];
//echo $GLOBALS['downvote'];
$query = "UPDATE post set downvote='{$downvote}' where postid='{$postid}'";
$db->update($query);
}
}
}
session_start();
include "./../lib/server-config.php";
require "./../lib/connect.class.php";
$db = new database();
$db->connect2(trim($u), trim($p), trim($dbn));
//Check user priviledge
$strSQL = sprintf("SELECT * FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE username = '******' and status = 1 and user_type_id = '%s'", mysql_real_escape_string("useraccount"), mysql_real_escape_string($_SESSION['userSIMANHusername']), mysql_real_escape_string(3));
$resultUser = $db->select($strSQL, false, true);
//If privilegde available
$art = $_POST['initiate_art'];
if ($_POST['on_art_delivery'] == 'Dual' || $_POST['on_art_delivery'] == 'Triple') {
$art = 0;
}
if ($resultUser) {
$strSQL = sprintf("UPDATE " . substr(strtolower($tbf), 0, -2) . "%s SET\n\t\t\t gravidity = '%s',\n\t\t\t parity= '%s',\n\t\t\t anc_attend = '%s',\n\t\t\t ga1st = '%s',\n\t\t\t ga20w = '%s',\n\t\t\t no_anc = '%s',\n\t\t\t rh = '%s',\n\t\t\t anti_d = '%s',\n\t\t\t rpr = '%s',\n\t\t\t rpr_treated = '%s',\n\t\t\t hiv_status = '%s',\n\t\t\t on_art_delivery = '%s',\n\t\t\t hiv_1st = '%s',\n\t\t\t hiv_retest = '%s',\n\t\t\t hiv_labour = '%s',\n\t\t\t cd4 = '%s',\n\t\t\t cd4_count = '%s',\n\t\t\t initiate_art = '%s',\n\t\t\t bba = '%s',\n\t\t\t ga_adm = '%s',\n\t\t\t stage_of_labour = '%s',\n\t\t\t date_lbs = '%s',\n\t\t\t time_lbs = '%s',\n\t\t\t date_rm = '%s',\n\t\t\t time_rm = '%s',\n\t\t\t date_3cm = '%s',\n\t\t\t time_3cm\t = '%s',\n\t\t\t date_fully = '%s',\n\t\t\t time_fully = '%s',\n\t\t\t duration_active_phase = '%s'\n\t\t\t WHERE record_id = '%s'\n\t\t\t\t", mysql_real_escape_string("obstetric"), mysql_real_escape_string($_POST['gravidity']), mysql_real_escape_string($_POST['parity']), mysql_real_escape_string($_POST['anc_attend']), mysql_real_escape_string($_POST['ga1st']), mysql_real_escape_string($_POST['ga20w']), mysql_real_escape_string($_POST['no_anc']), mysql_real_escape_string($_POST['rh']), mysql_real_escape_string($_POST['anti_d']), mysql_real_escape_string($_POST['rpr']), mysql_real_escape_string($_POST['rpr_treated']), mysql_real_escape_string($_POST['hiv_status']), mysql_real_escape_string($_POST['on_art_delivery']), mysql_real_escape_string($_POST['hiv_1st']), mysql_real_escape_string($_POST['hiv_retest']), mysql_real_escape_string($_POST['hiv_labour']), mysql_real_escape_string($_POST['cd4']), mysql_real_escape_string($_POST['cd4_count']), mysql_real_escape_string($art), mysql_real_escape_string($_POST['bba']), mysql_real_escape_string($_POST['ga_adm']), mysql_real_escape_string($_POST['stage_of_labour']), mysql_real_escape_string($_POST['date_lbs']), mysql_real_escape_string($_POST['time_lbs']), mysql_real_escape_string($_POST['date_rm']), mysql_real_escape_string($_POST['time_rm']), mysql_real_escape_string($_POST['date_3cm']), mysql_real_escape_string($_POST['time_3cm']), mysql_real_escape_string($_POST['date_fully']), mysql_real_escape_string($_POST['time_fully']), mysql_real_escape_string($_POST['duration_active_phase']), mysql_real_escape_string($_SESSION['userSIMANHmother_record']));
$resultInsert = $db->update($strSQL);
//print $strSQL;
//exit();
if ($resultInsert) {
$strSQL = sprintf("SELECT record_id FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE record_id = '%s' ", mysql_real_escape_string("obstetric"), mysql_real_escape_string($_SESSION['userSIMANHmother_record']));
$resultCheck = $db->select($strSQL, false, true);
//print $strSQL;
//exit();
if ($resultCheck) {
$db->disconnect();
?>
<script>
alert('Update obstetric information complete!');
window.location = '../enter/main.php?id=1';
</script>
<?php
