public static function drop_command($nick, $ircdata = array()) { $chan = core::get_chan(&$ircdata, 0); // get the channel. if (self::_drop_check($nick, $chan) === false) { return false; } // do nessicary checks if ($channel = services::chan_exists($chan, array('channel', 'suspended'))) { if ($channel->suspended == 1) { services::communicate(core::$config->chanserv->nick, $nick, &chanserv::$help->CS_SUSPEND_1, array('chan' => $chan)); return false; } } // is the channel suspended? database::delete('chans', array('channel', '=', $chan)); database::delete('chans_levels', array('channel', '=', $chan)); // delete all associated records services::communicate(core::$config->chanserv->nick, $nick, &chanserv::$help->CS_CHAN_DROPPED, array('chan' => $chan)); // let the user know if (isset(core::$chans[$chan])) { ircd::part_chan(core::$config->chanserv->nick, $chan); // now lets leave the channel if we're in it } // is the channel in existance? if so unregister mode // remember we DON'T unset the channel record, because the channel // is still there, just isnt registered, completely different things core::alog(core::$config->chanserv->nick . ': ' . $chan . ' has been dropped by ' . core::get_full_hostname($nick)); // logchan it core::alog('drop_command(): ' . $chan . ' has been dropped by ' . core::get_full_hostname($nick), 'BASIC'); // log what we need to log. }
public static function update_list() { database::delete("permission"); foreach (self::list_of_existing_permissions() as $perm => $descr) { database::insert("permission", array("permission" => $perm, "description" => $descr)); } }
function delete() { $this->onDelete(); if (!$this->validate($errors)) { return false; } $db = new database(); $db->table = $this->__table; $db->drop($this); return $db->delete(); }
public static function drop_command($nick, $ircdata = array()) { $unick = core::get_nick(&$ircdata, 0); $password = $ircdata[1]; // get the nick. if (trim($unick) == '' || trim($password) == '' && (!core::$nicks[$nick]['ircop'] || services::user_exists($nick, true, array('display', 'identified')) === false)) { services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_INVALID_SYNTAX_RE, array('help' => 'DROP')); return false; } // invalid syntax 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 drop a root? if ($user = services::user_exists($unick, false, array('id', 'display', 'pass', 'salt', 'suspended'))) { if ($user->suspended == 1) { services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_SUSPEND_1, array('nick' => $user->display)); return false; } // are they suspended? if ($user->pass == sha1($password . $user->salt) || core::$nicks[$nick]['ircop'] && services::user_exists($nick, true, array('display', 'identified')) !== false) { database::delete('users', array('display', '=', $user->display)); database::delete('users_flags', array('nickname', '=', $user->display)); // delete the users record database::delete('chans_levels', array('target', '=', $user->display)); // also delete this users channel access. core::alog(core::$config->nickserv->nick . ': ' . $user->display . ' has been dropped by ' . core::get_full_hostname($nick)); // logchan it core::alog('drop_command(): ' . $user->display . ' has been dropped by ' . core::get_full_hostname($nick), 'BASIC'); // log what we need to log. if (isset(core::$nicks[$user->display])) { ircd::on_user_logout($nick->display); } // if the nick is being used unregister it, even though it shouldn't be? services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_NICK_DROPPED, array('nick' => $user->display)); // let the nick know the account has been dropped. } else { services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_INVALID_PASSWORD); // password isn't correct } } else { services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_ISNT_REGISTERED, array('nick' => $unick)); return false; // doesn't even exist.. } }
public function delete() { // for admin only // needs: // 1. record id (WHERE condition) in $_GET['id'] // 2. id column name (in $this->id_column, through set_id_column method // 3. table (in $this->table_name, through set_table_name method $security_handler = new security(); $security_handler->check_token(); $_SESSION['log'] .= new timestamp("Deleting record {$_GET['id']} on table {$this->table_name}"); if (isset($_GET['id'])) { if (is_numeric($_GET['id'])) { if (isset($this->id_column)) { $id = $_GET['id']; $sql = "DELETE FROM {$this->table_name} WHERE {$this->id_column}=?"; $data = array($id); $connection = new database(); if ($connection->delete($sql, $data)) { $_SESSION['log'] .= new timestamp("Record deleted"); } else { $_SESSION['log'] .= new timestamp("Error: record could not be deleted!!"); } //header("Location: http://localhost/css/index.php?controller={$_GET['controller']}&action=index"); } else { $_SESSION['log'] .= new timestamp("Error: id_column property not set when deleting record. Cannot delete!"); } } else { $_SESSION['log'] .= new timestamp("Error: id value is not numeric. Aborting operation!"); header("Location: http://" . WEBSITE_URL . "/index.php?controller={$_GET['controller']}&action=index"); } } else { $_SESSION['log'] .= new timestamp("Error: id is not set. Aborting operation!"); header("Location: http://" . WEBSITE_URL . "/index.php?controller={$_GET['controller']}&action=index"); } }
function delete() { //create the database object $database = new database(); //start the transaction //$count = $database->db->exec("BEGIN;"); //delete the fax if (strlen($this->fax_uuid) > 0) { $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'] = '='; $database->delete(); unset($this->fax_uuid); } //delete the fax if (strlen($this->fax_uuid) == 0) { //select the dialplan entries $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']; //delete the child dialplan information $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 dialplan information $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(); } //delete the fax if (strlen($this->fax_uuid) > 0) { $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'] = '='; $database->delete(); unset($this->fax_uuid); } //commit the transaction //$count = $database->db->exec("COMMIT;"); } }
function action($_arg) { //------------------------------------------------------------------------------ // extrace action from coordinate system while ($entry = each($_arg)) { $argArray = explode("_", $entry[key]); if (count($argArray) > 1) { $indexString = $argArray[0]; $valueString = $argArray[1]; $_arg[$indexString] = $valueString; if (isset($argArray[2])) { $_arg['_ID'] = $argArray[2]; } } } //echoalert($_arg); //echoalert($_SESSION); //------------------------------------------------------------------------------ // parse reset value if ($_arg[reset]) { $_arg = array(); session::destroy(searchshow); session::destroy(show); session::destroy(search); session::destroy(searchtype); session::destroy(searchcom); session::destroy(searchorder); session::destroy(searchString); session::destroy(searchexact); session::destroy(searchstart); session::destroy(searchowner); session::destroy(searchentrytype); session::destroy(searchstatus); } //------------------------------------------------------------------------------ // parse action parameter switch ($_arg[action]) { //------------------------------------------------------------------------------ // login / out case login: // login user user::login($_arg[user], $_arg[password]); // restore program status if new session restore_status(); // reset linking session::destroy("linkaction"); session::destroy("link"); break; case logout: // logout user user::logout(); break; case changedo: // change password if ($password = $_GET[password]) { database::query("UPDATE user SET password='******' WHERE ID='" . session::get("user") . "'"); echojavascript("Passwort erfolgreich geändert"); } break; //------------------------------------------------------------------------------ // inherit entrytype to children //------------------------------------------------------------------------------ // inherit entrytype to children case inherit: $childArray = thesaurus::get_child($_arg[id]); foreach ($childArray as $entry) { database::query("UPDATE entry SET entrytype={$_arg['entrytype']} WHERE ID={$entry}"); } break; //------------------------------------------------------------------------------ //------------------------------------------------------------------------------ case update: if ($_arg[orderdefault]) { session::set(orderdefault, $_arg[id]); } elseif (isset($_arg[orderdefault])) { session::destroy(orderdefault); } break; //------------------------------------------------------------------------------ //------------------------------------------------------------------------------ case edit: session::set("edit", TRUE); session::set("show", $_arg[id]); session::destroy("searchshow"); break; case noedit: session::destroy("edit"); break; //------------------------------------------------------------------------------ //------------------------------------------------------------------------------ case open: session::open($_arg[id]); break; case close: session::close($_arg[id]); break; case closeall: session::close_all(); break; //------------------------------------------------------------------------------ //------------------------------------------------------------------------------ case deleteid: end_link(); hide(); database::delete($_arg[id]); break; //------------------------------------------------------------------------------ //------------------------------------------------------------------------------ case suchen: if (!$_arg[searchString] and ($_arg[searchowner] or $_arg[searchtype] or $_arg[searchstatus])) { $_arg[searchString] = "%"; } if ($_arg[searchString]) { session::set("searchshow", true); } // show search result session::set("search", $_arg[searchString]); session::set("searchcom", $_arg[searchcom]); session::set("searchorder", $_arg[searchorder]); session::set("searchentrytype", $_arg[searchentrytype]); session::set("searchstatus", $_arg[searchstatus]); if ($_arg[searchowner]) { session::set("searchowner", $_arg[searchowner]); } else { session::destroy("searchowner"); } switch ($_arg[searchtype]) { case 0: session::destroy("searchexact"); session::destroy("searchstart"); break; case 1: session::destroy("searchexact"); session::set("searchstart", TRUE); break; case 2: session::destroy("searchstart"); session::set("searchexact", TRUE); break; } break; case hidesearch: session::destroy(searchshow); break; //------------------------------------------------------------------------------ //------------------------------------------------------------------------------ case show: session::destroy("searchshow"); $_arg[linkaction] = ""; if ($_arg[id] == NULL) { break; } elseif ($_arg[id] > 0) { session::set("show", $_arg[id]); break; } else { session::delete("show"); break; } break; //------------------------------------------------------------------------------ //------------------------------------------------------------------------------ case swap: if ($_arg[id]) { thesaurus::swap_link($_arg[id], $_arg[_ID]); } break; case change: if ($_arg[id]) { // thesaurus::change_link($_arg); } break; case add: // add new descriptor session::destroy("show"); session::destroy("searchshow"); // session::set("",1); break; // clean database // clean database case correct: thesaurus::validate(true); echoalert("Datenbank bereinigt"); break; //------------------------------------------------------------------------------ // open hyrarchy down to selected entry //------------------------------------------------------------------------------ // open hyrarchy down to selected entry case showhyrarchy: if ($_arg[id]) { $hyrarchyArray = thesaurus::get_hyrarchy($_arg[id]); // don't open selected entry // array_pop($hyrarchyArray); foreach ($hyrarchyArray as $entry) { // echo $entry . " "; echo session::open($entry); } session::set("hyrarchy", TRUE); // hide search window session::destroy("searchshow"); // if nothing selected for display, show ID if (!session::get(show)) { session::set("show", $_arg[id]); } break; } //------------------------------------------------------------------------------ // debug on/off //------------------------------------------------------------------------------ // debug on/off case debugon: system::setval(debug, TRUE); break; case debugoff: system::setval(debug, FALSE); // legend on/off // legend on/off case legendon: session::set("legend", TRUE); break; case legendoff: session::destroy("legend"); break; // display / hide non descriptors // display / hide non descriptors case toggleND: if (session::get("descriptor")) { session::destroy("descriptor"); } else { session::set("descriptor", TRUE); } break; // display / hide orders // display / hide orders case toggleVI: if (session::get("visible")) { session::destroy("visible"); } else { session::set("visible", TRUE); } break; // toggle tooltips on/off // toggle tooltips on/off case off: session::set("tooltips", TRUE); break; case on: session::destroy("tooltips"); break; // toggle hyrarchy // toggle hyrarchy case hyrarchyon: session::set("hyrarchy", TRUE); break; case hyrarchyoff: session::set("hyrarchy", FALSE); break; } //------------------------------------------------------------------------------ // parse linkaction parameter switch ($_arg[linkaction]) { // link case link: session::set("link", $_arg[id]); session::set("linkaction", $_arg[linkaction]); session::set("linktype", $_arg[linktype]); break; // execute linking // execute linking case linkdo: switch (session::get('linkaction')) { case link: database::parent_insert(session::get("link"), $_arg[id], session::get("linktype")); session::set("show", session::get("link")); // set display to linked objects // with BS set linked descriptor to "no descriptor" if (session::get("linktype") == 2) { database::set_desc($_arg[id], 0); } // session::destroy("link"); // end linking break; case change: database::link_change(session::get('linkparent'), session::get('link'), $_arg['id']); // parent,oldlink,newlink break; } break; case linkend: end_link(); break; // unlink // unlink case unlink: if ($_arg[id]) { database::parent_delete(session::get("show"), $_arg[id]); } break; // change OB // change OB case change: if ($_arg[id]) { session::set("link", $_arg[id]); session::set("linkaction", $_arg[linkaction]); session::set("linkparent", $_arg[_ID]); session::set("linktype", $_arg[linktype]); } break; } // TEMP SETTINGS // if not link rights, set descriptor and visible to true if (!right::link()) { session::set(descriptor, FALSE); } //if (!right::link()) session::set(visible,TRUE); // save program status save_status($_SESSION); }
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 }
$db->where("id = {$s_tournois}"); $db->exec(); /*** inscription des teams dans m4 ***/ if ($modescore_tournois == 'M4') { $dbm4 = new database(); $dbm4->debug($m4dbdebug); $dbm4->connect($m4dbhost, $m4dbuser, $m4dbpass, $m4dbname); $db->select("id, tag"); $db->from("{$dbprefix}equipes, {$dbprefix}participe"); $db->where("{$dbprefix}equipes.id = {$dbprefix}participe.equipe"); $db->where("tournois = {$s_tournois}"); $db->order_by("id"); $res = $db->exec(); while ($equipes = $db->fetch($res)) { /*** suppression de l'equipe dans m4 (eviter les conflits d'id) ***/ $dbm4->delete("m4_clan"); $dbm4->where("numero = {$equipes->id}"); $dbm4->exec(); /*** insertion de l'equipe inscrites dans m4 ***/ $dbm4->insert("m4_clan (numero,nom)"); $dbm4->values("{$equipes->id},'{$equipes->tag}'"); $dbm4->exec(); } } /*** redirection ***/ if (type_tournois($s_tournois) == 'E') { js_goto("?page=finales&op=admin"); } else { js_goto("?page=poules&op=admin"); } } elseif ($op == "valider_poules") {
public static function _clear_users($nick) { database::delete('ignored_users'); services::communicate(core::$config->operserv->nick, $nick, &operserv::$help->OS_IGNORE_CLEARED, array('users' => database::num_rows($nicks_q))); // list cleared. }
<?php /* * php code///////////********************************************************** */ $db = new database(); $query = $db->delete("orders", "id='{$_GET['id']}'"); if ($query == TRUE) { $db->delete("order_details", "order_id='{$_GET['id']}'"); header("location:" . $baseUrl . "/back/order"); } else { echo "Error!"; } mysql_close();
public static function identify_command($nick, $ircdata = array()) { $password = $ircdata[0]; if (trim($password) == '') { services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_INVALID_SYNTAX_RE, array('help' => 'IDENTIFY')); return false; } // wrong syntax damit! if ($user = services::user_exists($nick, false, array('display', 'pass', 'identified', 'validated', 'salt', 'vhost'))) { if ($user->validated == 0) { services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_AWAITING_VALIDATION); return false; } elseif ($user->identified == 1) { services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_ALREADY_IDENTIFIED); return false; } else { if ($user->pass == sha1($password . $user->salt)) { timer::remove(array('ns_identify', 'secured_callback', array($nick))); // remove the secured timer. if there is one ircd::on_user_login($nick); // registered mode database::update('users', array('identified' => 1, 'last_hostmask' => core::get_full_hostname($nick), 'last_timestamp' => 0), array('display', '=', $nick)); services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_IDENTIFIED); // right, standard identify crap core::alog(core::$config->nickserv->nick . ': ' . core::get_full_hostname($nick) . ' identified for nick ' . core::$nicks[$nick]['nick']); // logchan if ($user->vhost != '' && isset(modules::$list['os_vhost'])) { if (substr_count($user->vhost, '@') == 1) { $new_host = explode('@', $user->vhost); $ident = $new_host[0]; $host = $new_host[1]; ircd::setident(core::$config->operserv->nick, $user->display, $ident); ircd::sethost(core::$config->operserv->nick, $user->display, $host); } else { ircd::sethost(core::$config->operserv->nick, $user->display, $user->vhost); } } // first thing we do, check if they have a vhost, if they do, apply it. $failed_attempts = database::select('failed_attempts', array('nick', 'mask', 'time'), array('nick', '=', $nick)); if (database::num_rows($failed_attempts) > 0) { services::communicate(core::$config->nickserv->nick, $nick, '' . database::num_rows($failed_attempts) . ' failed login(s) since last login.'); while ($row = database::fetch($failed_attempts)) { services::communicate(core::$config->nickserv->nick, $nick, 'Failed login from: ' . $row->mask . ' on ' . date("F j, Y, g:i a", $row->time) . ''); } // loop through the failed attempts messaging them to the user database::delete('failed_attempts', array('nick', '=', $nick)); // clear them now that they've been seen } // we got any failed attempts? HUMM $hostname = core::get_full_hostname($nick); // generate a hostname. if (core::$config->settings->mode_on_id == 'yes' && isset(modules::$list['cs_levels'])) { foreach (core::$chans as $chan => $cdata) { $access_array = cs_levels::get_access($chan); // get the access array if ($nick == core::$config->chanserv->nick) { continue; } // skip us :D $hostname = core::get_full_hostname($nick); // get the hostname ready. foreach ($access_array as $target => $access) { if ($target == $nick) { $remove_access = false; // don't remove access cs_levels::give_access($chan, $nick, $access, chanserv::check_flags($chan, array('S'))); // give them access continue 2; // continue to next loop cause we've found a match } elseif (strpos($target, '@') !== false && services::match($hostname, $target)) { $remove_access = false; // don't remove access cs_levels::give_access($chan, $nick, $access, chanserv::check_flags($chan, array('S'))); // give them access continue 2; // continue to next loop cause we've found a match } elseif (strpos(core::$chans[$chan]['users'][$nick], 'o') !== false) { $remove_access = true; // set remove access to true continue 1; // continue to next loop to check other access records } else { continue 1; // continue to next loop to check other access records } // we check if the user has access, if they do break; // we also check if they dont have access and have op, if they do remove it. } // loop through the access records } // loop through channels, check if they are in any } // check if mode_on_id is set, also cs_access is enabled, and lets do a remote access gain :D } else { services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_INVALID_PASSWORD); core::alog(core::$config->nickserv->nick . ': Invalid password from ' . core::get_full_hostname($nick)); // some logging stuff database::insert('failed_attempts', array('nick' => $nick, 'mask' => core::get_full_hostname($nick), 'time' => core::$network_time)); core::$nicks[$nick]['failed_attempts']++; // ooh, we have something to log :) if (core::$nicks[$nick]['failed_attempts'] == 5) { ircd::kill(core::$config->nickserv->nick, $nick, 'Maxmium FAILED login attempts reached.'); } // have they reached the failed attempts limit? we gonna f*****g KILL mwhaha } // invalid password? HAX!! } // are they already identifed? } else { services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_UNREGISTERED); return false; // doesn't even exist.. } // right now we need to check if the user exists, and password matches }
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 static function del($variable) { database::delete("variables", "variable_name='%var'", array("%var" => $variable)); }
public static function check_expire() { if (core::$config->nickserv->expire == 0) { return false; } // skip nicknames if config is set to no expire. $expiry_time = core::$config->nickserv->expire * 86400; $check_time = core::$network_time - $expiry_time; // set up our times. $nick_q = database::select('users', array('id', 'display', 'last_timestamp'), array('last_timestamp', '!=', '0', 'AND', 'last_timestamp', '<', $check_time)); if (database::num_rows($nick_q) == 0) { return false; } // no expiring nicknames while ($nick = database::fetch($nick_q)) { // Mikeh gets most of the credit for helping // me code this function database::delete('users', array('display', '=', $nick->display)); database::delete('users_flags', array('nickname', '=', $user->display)); // delete the users record database::delete('chans_levels', array('target', '=', $nick->display)); // also delete this users channel access. core::alog(core::$config->nickserv->nick . ': ' . $nick->display . ' has expired. Last used on ' . date('F j, Y, g:i a', $nick->last_timestamp)); // logchan it if (isset(core::$nicks[$nick->display])) { ircd::on_user_logout($nick->display); } // if the nick is being used unregister it, even though it shouldn't be, just to be safe. } // loop through all expiring nicks. }
private static function remove_theme($theme_name) { database::delete("theme_manager", "theme_name='{$theme_name}'"); }
<?php /* * php code///////////********************************************************** */ $db = new database(); $option_im = array("table" => "products", "fields" => "image", "condition" => "id='{$_GET['id']}'"); $query_im = $db->select($option_im); $rs_im = $db->get($query_im); $query = $db->delete("products", "id='{$_GET['id']}'"); if ($query == TRUE) { if ($rs_im['image'] != "ecimage.jpg") { $path = base_path() . "/upload/product/"; @unlink($path . $rs_im['image']); @unlink($path . "thumb_" . $rs_im['image']); @unlink($path . "md_" . $rs_im['image']); @unlink($path . "sm_" . $rs_im['image']); } header("location:" . $baseUrl . "/back/product"); } else { echo "error"; } mysql_close();
public function dialplan() { //create the database object $database = new database(); if ($this->db) { $database->db = $this->db; } //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['domain_uuid'] = $this->domain_uuid; $database->fields['dialplan_uuid'] = $this->dialplan_uuid; $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->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'] = '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 if ($_SESSION['ivr menu']['application']['text'] == "lua") { $database->fields['dialplan_detail_type'] = 'lua'; $database->fields['dialplan_detail_data'] = 'ivr_menu.lua'; } else { $database->fields['dialplan_detail_type'] = 'ivr'; $database->fields['dialplan_detail_data'] = $this->ivr_menu_uuid; } $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(); } //delete the dialplan context from memcache $fp = event_socket_create($_SESSION['event_socket_ip_address'], $_SESSION['event_socket_port'], $_SESSION['event_socket_password']); if ($fp) { $switch_cmd .= "memcache delete dialplan:" . $_SESSION["context"] . "@" . $_SESSION['domain_name']; $switch_result = event_socket_request($fp, 'api ' . $switch_cmd); } }
<?php 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 ($resultUser) { $strSQL = sprintf("SELECT * FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE record_id = '%s'", mysql_real_escape_string("registerrecord"), mysql_real_escape_string($_GET['id'])); $resultRecord = $db->select($strSQL, false, true); if ($resultRecord) { $strSQL = sprintf("DELETE FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE record_id = '%s'", mysql_real_escape_string("delivery"), mysql_real_escape_string($resultRecord[0]['record_id'])); $resultDelete = $db->delete($strSQL); $strSQL = sprintf("DELETE FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE record_id = '%s'", mysql_real_escape_string("obstetric"), mysql_real_escape_string($resultRecord[0]['record_id'])); $resultDelete = $db->delete($strSQL); $strSQL = sprintf("DELETE FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE record_id = '%s'", mysql_real_escape_string("other_postnatal"), mysql_real_escape_string($resultRecord[0]['record_id'])); $resultDelete = $db->delete($strSQL); $strSQL = sprintf("DELETE FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE record_id = '%s'", mysql_real_escape_string("outcome"), mysql_real_escape_string($resultRecord[0]['record_id'])); $resultDelete = $db->delete($strSQL); $strSQL = sprintf("DELETE FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE record_id = '%s'", mysql_real_escape_string("postnatal"), mysql_real_escape_string($resultRecord[0]['record_id'])); $resultDelete = $db->delete($strSQL); $strSQL = sprintf("DELETE FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE record_id = '%s'", mysql_real_escape_string("registerrecord"), mysql_real_escape_string($resultRecord[0]['record_id'])); $resultDelete = $db->delete($strSQL); $strSQL = sprintf("SELECT * FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE record_id = '%s'", mysql_real_escape_string("registerrecord"), mysql_real_escape_string($_GET['id'])); $resultRecord = $db->select($strSQL, false, true); if ($resultRecord) { // Delete fail $db->disconnect();
<?php /* * php code///////////********************************************************** */ $db = new database(); $query = $db->delete("users", "id='{$_GET['id']}'"); if ($query == TRUE) { header("location:" . $baseUrl . "/back/user"); } else { echo "error"; } mysql_close();
/*** delete du serveur dans m4 ***/ $dbm4->delete("m4_serveur"); $dbm4->where("numero = {$id}"); $dbm4->exec(); /*** insertion du serveur dans m4 ***/ $dbm4->insert("m4_serveur (numero,adresse,port,hostname)"); $dbm4->values("{$id},'{$adresse}','{$port}','{$nom}'"); $dbm4->exec(); $dbm4->close(); } if ($insert_ab) { $dbab = new database(); $dbab->debug($abdbdebug); $dbab->connect($abdbhost, $abdbuser, $abdbpass, $abdbname); /*** delete du serveur dans adminbot ***/ $dbab->delete("gameserver"); $dbab->where("ServerId = {$id}"); $dbab->exec(); /*** insertion du serveur dans adminbot ***/ $dbab->insert("gameserver (ServerId,GameId,GameGroupId,ServerAddress,ServerPort,ServerIsUp,ServerType,ServerRcon,ServerHostName)"); $dbab->values("'{$id}','','','{$adresse}','{$port}','','cs','{$rcon}','{$nom}'"); $dbab->exec(); $dbab->close(); } /*** redirection ***/ js_goto("?page=serveurs&op=modify&id={$id}"); } } elseif ($op == "delete") { /*** verification securite ***/ if ($grade['a'] != 'a' && $grade['b'] != 'b' && $grade['r'] != 'r') { js_goto($PHP_SELF);
public static function delete_all_permissions() { database::delete("permission_role"); }
function delete() { //create the database object $database = new database(); if ($this->db) { $database->db = $this->db; } //start the transaction //$count = $database->db->exec("BEGIN;"); //delete the ivr menu option if (strlen($this->ivr_menu_option_uuid) > 0) { $database->table = "v_ivr_menu_options"; $database->where[0]['name'] = 'domain_uuid'; $database->where[0]['value'] = $this->domain_uuid; $database->where[0]['operator'] = '='; $database->where[1]['name'] = 'ivr_menu_option_uuid'; $database->where[1]['value'] = $this->ivr_menu_option_uuid; $database->where[1]['operator'] = '='; $database->delete(); unset($this->ivr_menu_option_uuid); } //delete the ivr menu if (strlen($this->ivr_menu_option_uuid) == 0) { //select the dialplan entries $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']; //delete the child dialplan information $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 dialplan information $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(); } //delete child data $database->table = "v_ivr_menu_options"; $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->delete(); //delete parent data $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'] = '='; $database->delete(); //delete the dialplan context from memcache $fp = event_socket_create($_SESSION['event_socket_ip_address'], $_SESSION['event_socket_port'], $_SESSION['event_socket_password']); if ($fp) { $switch_cmd = "memcache delete dialplan:" . $_SESSION["context"]; $switch_result = event_socket_request($fp, 'api ' . $switch_cmd); } //commit the transaction //$count = $database->db->exec("COMMIT;"); } }
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. } }
public static function remove_ignore($who) { database::delete('ignored_users', array('who', '=', $who)); // remove it. }
public static function check_expire() { if (core::$config->chanserv->expire == 0) { return false; } // skip channels if config is set to no expire. $expiry_time = core::$config->chanserv->expire * 86400; $check_time = core::$network_time - $expiry_time; // set up our times $channel_q = database::select('chans', array('channel', 'last_timestamp'), array('last_timestamp', '<', $check_time)); if (database::num_rows($channel_q) == 0) { return false; } // no registered channels while ($channel = database::fetch($channel_q)) { database::delete('chans', array('channel', '=', $channel->channel)); database::delete('chans_levels', array('channel', '=', $channel->channel)); core::alog(core::$config->chanserv->nick . ': ' . $channel->channel . ' has expired. Last used on ' . date('F j, Y, g:i a', $channel->last_timestamp)); // logchan it if (isset(core::$chans[$channel->channel])) { ircd::part_chan(core::$config->chanserv->nick, $channel->channel); // now lets leave the channel if we're in it } // unset some modes, leave the channel if its in use.. i know this shouldn't // be even thought about.. but maybe somebody idled in it and never even did // anything for the whole expiry period? :P } // channel is old i'm afraid, expire it }
public static function logout() { session::destroy(); $tokenExist = cookie::exists(TOKEN_NAME); if ($tokenExist) { $token = cookie::get(TOKEN_NAME); try { $db = new database(DBTYPE, DBHOST, DBNAME, DBUSER, DBPASS); $data = $db->select("users_session", "*", "token = '{$token}'", "fetch"); $agent_id = $data['agent_id']; $db->delete("users_session", "token = '{$agent_id}'"); cookie::delete(TOKEN_NAME); } catch (Exception $ex) { cookie::delete(TOKEN_NAME); } } redirect::to("login"); }
public static function delete_block($blockname) { database::delete("blocks", "block='%bn'", array("%bn" => $blockname)); }
<?php include "dbclass.php"; $obj = new database(); /* $hostname = "localhost"; $username = "******"; $password = ""; $database = "student"; */ //$obj->database(); $tablename = "register"; echo $id = $_GET["id"]; $obj->delete($tablename, $id); header("location:select.php?msg=data deleted"); //$row = mysql_fetch_array($result);
/*** delete du serveur dans m4 ***/ $dbm4->delete("m4_serveur"); $dbm4->where("numero = {$id}"); $dbm4->exec(); /*** insertion du serveur dans m4 ***/ $dbm4->insert("m4_serveur (numero,adresse,port,hostname)"); $dbm4->values("{$id},'{$adresse}','{$port}','{$nom}'"); $dbm4->exec(); $dbm4->close(); } if ($insert_ab) { $dbab = new database(); $dbab->debug($abdbdebug); $dbab->connect($abdbhost, $abdbuser, $abdbpass, $abdbname); /*** delete du serveur dans adminbot ***/ $dbab->delete("adb_server_tbl"); $dbab->where("server_id = {$id}"); $dbab->exec(); /*** insertion du serveur dans adminbot ***/ $dbab->insert("adb_server_tbl (server_id,server_hostname,server_ip,server_port,server_rcon,server_game)"); $dbab->values("{$id},'{$nom}','{$adresse}','{$port}','{$rcon}','CS'"); $dbab->exec(); $dbab->close(); } /*** redirection ***/ js_goto("?page=team_serveurs&op=modify&id={$id_s}&id_t={$id_t}"); } } elseif ($op == "delete") { if (!equipe_manager($id_t, $s_joueur)) { js_goto($PHP_SELF); }