function getList($type = '') { $value = array(); $i = 0; $db = new DB_Sql(); if ($type == 'all') { $db->query("SELECT *, DATE_FORMAT(date_created, '%d-%m-%Y %H:%i') AS date_dk FROM materialebestilling ORDER BY date_created"); } else { $db->query("SELECT *, DATE_FORMAT(date_created, '%d-%m-%Y %H:%i') AS date_dk FROM materialebestilling WHERE er_sendt = 0 ORDER BY date_created"); } while ($db->nextRecord()) { $value[$i]['id'] = $db->f('id'); $value[$i]['navn'] = $db->f('navn'); $value[$i]['adresse'] = $db->f('adresse'); $value[$i]['postnr'] = $db->f('postnr'); $value[$i]['postby'] = $db->f('postby'); $value[$i]['email'] = $db->f('email'); $value[$i]['telefon'] = $db->f('telefon'); $value[$i]['langekurser'] = $db->f('langekurser'); $value[$i]['kortekurser'] = $db->f('kortekurser'); $value[$i]['kursuscenter'] = $db->f('kursuscenter'); $value[$i]['efterskole'] = $db->f('efterskole'); $value[$i]['besked'] = $db->f('besked'); $value[$i]['date_dk'] = $db->f('date_dk'); $value[$i]['er_sendt'] = $db->f('er_sendt'); $i++; } return $value; }
public function getList($show = "open") { $sql_ekstra = ""; switch ($show) { case 'åbne': // fall through // fall through case 'open': $sql_ekstra = "published = 1 AND DATE_ADD(dato_start, INTERVAL 14 DAY) > NOW()"; break; case 'aktuelle': $sql_ekstra = "dato_slut > NOW()"; break; case 'intranet': $sql_ekstra = "dato_slut > DATE_SUB(NOW(), INTERVAL 400 DAY)"; break; case 'old': $sql_ekstra = "dato_slut > DATE_SUB(NOW(), INTERVAL 3650 DAY)"; break; default: $sql_ekstra = " 1 = 1"; break; } $db = new DB_Sql(); $db->query("SELECT id FROM langtkursus WHERE " . $sql_ekstra . " AND active = 1 ORDER BY dato_start ASC, dato_slut DESC, belong_to ASC, navn ASC"); $kurser = array(); while ($db->nextRecord()) { $kurser[] = new VIH_Model_LangtKursus($db->f('id')); } return $kurser; }
private function init() { $db = new DB_Sql(); $db->query("SELECT id FROM langtkursus_tilmelding WHERE session_id = '" . $this->session_id . "'"); if ($db->nextRecord()) { parent::__construct($db->f('id')); } }
protected function load() { $db = new DB_Sql(); $sql = "SELECT art, indhold FROM kortkursus_tilmelding_oplysninger\r\n WHERE tilmelding_id = '" . $this->tilmelding->get('id') . "'"; $db->query($sql); while ($db->nextRecord()) { $this->value[$db->f('art')] = $db->f('indhold'); } return true; }
function checkurl() { foreach ($_GET as $check1) { $check2 = check($check1); if ($check1 != $check2 || strlen($check1) != strlen($check2)) { @($str = "INSERT INTO `attacklog` ( `uid` , `dt` , `ip` , `key` , `memo` , `httphost` ) \r\n\t\t\t\tVALUES ( '" . $_SESSION['uid'] . "', '" . date("Y-m-d H:i:s") . "', '" . $_SERVER['REMOTE_ADDR'] . "', '" . $_SERVER['SCRIPT_FILENAME'] . "', '', '" . $_SERVER['HTTP_HOST'] . "')"); @($db = new DB_Sql()); @$db->query($str); echo "¹¥»÷Ìáʾ"; exit; } } }
function postForm() { $db = new DB_Sql(); foreach ($this->body() as $key => $value) { foreach ($value as $id => $hold) { if (!$hold) { continue; } $db->query("UPDATE langtkursus_tilmelding_x_fag SET hold = " . $hold . " WHERE id = " . $id); } } return new k_SeeOther($this->url()); }
public function get($art) { if (!empty($this->info[$art])) { return $this->info[$art]; } $art = trim(strip_tags(mysql_escape_string($art))); $sql = "SELECT art, indhold FROM kortkursus_deltager_oplysninger_ny\r\n WHERE deltager_id = '" . $this->deltager->get('id') . "'"; $db = new DB_Sql(); $db->query($sql); while ($db->nextRecord()) { $this->info[$db->f('art')] = $db->f('indhold'); } if (!empty($this->info[$art])) { return $this->info[$art]; } }
function get_db_value($sql = '', $default = '') { $this->connect_to_db(); $this->enable_data = FALSE; $sql = trim($sql); if (mb_strlen($sql) > 0) { $this->set_sql($sql); } $this->db->query($this->sql); $this->after_query(); if ($this->db->next_record()) { $this->enable_data = TRUE; return $this->db->f(0); } else { return $default; } }
function _is_jubilar($auth) { $jubilar = false; $db = new DB_Sql(); $db->query("SELECT aargange FROM elevforeningen_jubilar ORDER BY id DESC"); if ($db->nextRecord()) { $jubilar_aargange = array_values(unserialize($db->f('aargange'))); } $contact = $auth->get(); $keywords = $auth->contact_client->getConnectedKeywords($contact['id']); $jubilar = false; if (is_array($keywords)) { foreach ($keywords as $key => $value) { if (in_array($value, $jubilar_aargange)) { $jubilar = true; } } } return $jubilar; }
public function getKurser() { $db = new DB_Sql(); $db->query("SELECT * FROM langtkursus_x_fag INNER JOIN langtkursus ON langtkursus_x_fag.langtkursus_id = langtkursus.id WHERE fag_id = " . $this->id . ' AND dato_start > NOW() AND langtkursus.active = 1 AND langtkursus.published = 1 GROUP BY langtkursus_id ORDER BY dato_start'); $kurser = array(); while ($db->nextRecord()) { $kurser[] = new VIH_Model_LangtKursus($db->f('langtkursus_id')); } return $kurser; }
<?php include '../../include_videotutoriales/configpc.php'; session_start(); $html = new Smarty(); if (!isset($_POST["formulario"])) { $html->display("login.html"); } else { $usuario = $_POST["usuario"]; $pass = $_POST["pass"]; $pass = md5($pass); $db = new DB_Sql(); //query de usuario si es que si creamos la session usuario y vamos a perifl.php , si da error a error.php $query = "select usuario from usuarios where usuario='{$usuario}' and pass='******'"; $db->query($query); if ($db->num_rows() > 0) { $_SESSION["usuario"] = $usuario; header("location: perfil.php"); } else { $html->display("error.html"); } }
function getValueTable($campo, $tabla, $idTabla, $idEnviado) { // Extrae solo info de SION global $sionSrv, $sionDB; /* * @return Info de un campo especifico * @param string $campo * @param string $tabla * @param string $idTabla * @param string $idEnviado * @desc Esta funcion sirve para traer informacion de x campo de cualquier tabla. */ $dbf = new DB_Sql(); $dbf->connect($sionDB, $sionSrv, "root", ""); $sql = "select {$campo} from {$tabla} where {$idTabla}='{$idEnviado}'"; $dbf->query($sql); while ($dbf->next_record()) { $valor = $dbf->f($campo); return $valor; // No mover el return, podria ser peligroso!. } }
public function getPictures() { $db = new DB_Sql(); $db->query("SELECT * FROM langtkursus_x_file WHERE langtkursus_id = " . $this->id); $id = array(); while ($db->nextRecord()) { $id[]['file_id'] = $db->f('file_id'); } return $id; }
// FIRMA BL A REVISION // 1. Detectar el link los log del Bl, Draf. // 2. Crear firma en SION, Bl-Revision // -------------------------------------------------- $sql2 = "\n SELECT *\n FROM Z_MS_LOG\n where Action_Description like '%draft%' and Action_Description like '%{$bl}%'\n "; $db2->query($sql2); $nrLog = $db2->num_rows(); unset($myrow); if ($nrLog > 0) { while ($db2->next_record()) { $userName = $db2->f('User_Name'); $userName = str_replace("nala\\", "", $userName); if (!empty($userName)) { //echo "UserName : $userName <br>"; $sqlX = "select Id_usuario from USUARIO where Email like '{$userName}%' "; $dbX->query($sqlX); unset($rowZ); while ($dbX->next_record()) { $idUsrSion = $dbX->f('Id_usuario'); } } elseif ($idUsrSion == 0 || empty($idUsrSion)) { $idUsrSion = 647; // Robot SION. } $actionDesc = $db2->f('Action_Description'); $actionDesc = addslashes($actionDesc); $logDateTime = $db2->f('Log_DateTime'); // Comprobar que no exista para evitar Duplicado if ($idBlDCE > 0) { $sqlX = "\n select id_firma_his from FIRMA_HIS\n where id_bl='{$idBlDCE}' and id_firma_cpto='1' "; // and nota='$actionDesc'
/** * * Der m� i denne funktion ikke bruges array_map() til at genneml�be * v�rdierne, da den �del�gger arrayet til andet brug. * Sune: Nu har jeg alligevel benyttet array_map, for jeg kan ikke se hvor man ikke kan det. */ function save($input) { settype($input['arbejdstelefon'], 'string'); settype($input['mobil'], 'string'); settype($input['adresse'], 'string'); settype($input['postnr'], 'string'); settype($input['postby'], 'string'); if (!$this->validate($input)) { return 0; } $var = $input; $navn = vih_split_name($var['navn']); $var['fornavn'] = $navn['fornavn']; $var['efternavn'] = $navn['efternavn']; if ($this->id == 0) { $sql_type = "INSERT INTO "; $sql_end = ", date_created = NOW()"; } else { $sql_type = "UPDATE "; $sql_end = ", date_changed = NOW() WHERE id = " . $this->id; } $sql = $sql_type . "adresse SET\r\n fornavn = '" . $var['fornavn'] . "',\r\n efternavn = '" . $var['efternavn'] . "',\r\n adresse = '" . $var['adresse'] . "',\r\n postnr = '" . $var['postnr'] . "',\r\n postby = '" . $var['postby'] . "',\r\n email = '" . $var['email'] . "',\r\n arbejdstelefon = '" . $var['arbejdstelefon'] . "',\r\n telefon = '" . $var['telefonnummer'] . "',\r\n mobil = '" . $var['mobil'] . "'" . $sql_end; $db = new DB_Sql(); $db->query($sql); if ($this->id == 0) { return $db->insertedId(); } $this->load(); return $this->id; }
* The contents of this file are subject to the License; you may not use this file except in compliance with the License. * * @version $Revision: 2075 $ */ @set_time_limit(1000); require "../libraries/common.inc.php"; require "session_cp.inc.php"; require LIB_PATH . "db_mysql.inc.php"; uses("log"); $log = new Logs(); $db = new DB_Sql(); $conn = $db->connect($dbname, $dbhost, $dbuser, $dbpasswd); $tpl_file = "db"; if (!($backupdir = $pdb->GetOne("SELECT valued FROM {$tb_prefix}settings WHERE variable='backup_dir'"))) { $backupdir = pb_radom(6); $db->query("REPLACE INTO {$tb_prefix}settings (variable, valued) values ('backup_dir', '{$backupdir}')"); } require LIB_PATH . "func.db.php"; require LIB_PATH . "func.sql.php"; if (isset($_POST['do'])) { $do = trim($_POST['do']); if (!file_exists(DATA_PATH . "backup_" . $backupdir)) { pb_create_folder(DATA_PATH . "backup_" . $backupdir); } if ($do == "query" && !empty($_POST['sql_content'])) { if ($admin_runquery) { $result = sql_run($_POST['sql_content']); if ($result) { flash("success"); } else { flash();
function getForfaldenDato($key = '', $sprog = '') { if (!in_array($key, array('depositum', ''))) { throw new Exception("Tilmelding->getForfaldenDato"); } if (!empty($sprog)) { $sprog = '_' . $sprog; } $db = new DB_Sql(); switch ($key) { case 'depositum': $db->query("SELECT\n date_add(date_created, interval 10 day) AS dato_forfalden,\n DATE_FORMAT(date_add(date_created, interval 10 day), '%d-%m-%Y') AS forfald_dk\n FROM kortkursus_tilmelding\n WHERE id=" . $this->get('id')); break; default: $db->query("SELECT date_sub(dato_start, interval 42 day) AS dato_forfalden,\n DATE_FORMAT(date_sub(dato_start, interval 42 day), '%d-%m-%Y') AS forfald_dk\n FROM kortkursus\n WHERE id=" . $this->kursus->get('id')); break; } if (!$db->nextRecord()) { return 0; } return $db->f('forfald' . $sprog); }
function updateCGAGpo($idGrupo, $forzarMov = 0) { $db = new DB_Sql(); $db->connect("MscCobranza", "localhost", "root", ""); $db2 = new DB_Sql(); $db2->connect("MscCobranza", "localhost", "root", ""); $db3 = new DB_Sql(); $db3->connect("MscCobranza", "localhost", "root", ""); //echo "Gpo:$idGrupo || forzaMov:$forzarMov <br>"; // --------------------------------- // PROCESO PARA ACTUALIZAR LAS C.G.A // --------------------------------- $ano = date("Y"); $anoAnt = $ano - 1; $grupo = getValueTable("grupo", "D_GRUPO", "id_grupo", $idGrupo); $cgaAct = getValueTable("cga", "D_GRUPO", "id_grupo", $idGrupo); $cgaOld = getValueTable("cga_old", "D_GRUPO", "id_grupo", $idGrupo); // * DETECTAR REGISTROS DEL CLIENTE $sql2 = "select a.id_calculo as IDCALCULO, a.carta_g as CGACAL, a.id_bl_conte as IDBLCONTE "; $sql2 .= "from D_CALCULO a, D_CLIENTE b "; $sql2 .= "where "; $sql2 .= "a.id_cliente=b.id_cliente and b.id_grupo='{$idGrupo}' and "; if ($forzarMov == '0') { $sql2 .= "a.carta_g='' and "; } $sql2 .= "(libre_f1 BETWEEN '{$anoAnt}-01-01' and '{$ano}-12-31%' )"; $db2->query($sql2); while ($db2->next_record()) { $idCalculo = $db2->f(IDCALCULO); //echo "idCalculo=$idCalculo <br>"; $idBlConte = $db2->f(IDBLCONTE); $cgaCal = $db2->f(CGACAL); $idBl = getValueTable("id_bl", "BL_CONTE", "id_bl_conte", $idBlConte); $bl = getValueTable("Bl", "EXPO", "Id_expo", $idBl); $idBarco = getValueTable("Id_barco", "EXPO", "Id_expo", $idBl); $eta = getValueTable("Eta1", "BARCO", "Id_barco", $idBarco); if (preg_match("/^(\\d{4})/i", $eta, $parts)) { $etaAno = $parts[1]; } // * CGA - ACTUAL if (!empty($cgaAct) && (empty($cgaCal) || $forzarMov == 1)) { if (preg_match("/CGA {$etaAno}/i", $cgaAct)) { $sql3 = "update D_CALCULO set carta_g='{$cgaAct}' where id_calculo='{$idCalculo}'"; $db3->query($sql3); //echo "$bl [CGA - Actualizada]...<br>"; } } // * CGA - ANTERIOR if (!empty($cgaOld) && (empty($cgaCal) || $forzarMov == 1)) { if (preg_match("/CGA {$etaAno}/i", $cgaOld)) { $sql3 = "update D_CALCULO set carta_g='{$cgaOld}' where id_calculo='{$idCalculo}'"; $db3->query($sql3); //echo "$bl [CGA - Actualizada]...<br>"; } } } }
function deletePicture($file_id) { $db = new DB_Sql(); $db->query('UPDATE facilitet SET pic_id = 0, date_updated = NOW() WHERE id = ' . $this->id); return 1; }
if (mysql_get_server_info() > '4.1') { mysql_query("CREATE DATABASE IF NOT EXISTS" . " {$dbname} DEFAULT CHARACTER SET {$dbcharset};"); } else { mysql_query("CREATE DATABASE IF NOT EXISTS {$dbname};"); } mysql_close(); } else { $error_info = mysql_errno() . " : " . mysql_error() . "<br>"; $db_error = true; break; } } else { $sqldump = null; $conn = $db->connect($dbname, $dbhost, $dbuser, $dbpasswd); if ($version > '4.1' && $charset) { $db->query($set_names); } if ($version > '5.0') { $db->query($set_modes); } $tables = $db->table_names(); if (!empty($tables)) { foreach ($tables as $names) { if (!function_exists("stripos")) { function stripos($str, $needle) { return strpos(strtolower($str), strtolower($needle)); } } if (stripos($names['table_name'], $tb_prefix) === 0) { $sqldump .= data2sql($names['table_name']);
function addContenedor($bl) { global $serverName, $db, $usuario, $pass; $dbf = new DB_Sql(); $dbf->connect("MscCobranza", "10.110.13.13", "root", ""); $dsn = "Driver={SQL Server};Server={$serverName};Database={$db};Integrated Security=SSPI;Persist Security Info=False;"; $conn2 = odbc_connect($dsn, $usuario, $pass); $blSION = str_replace("MSCU", "", $bl); // Consultar los contenedores y despues agregarlos al SION. $sql = "\n SELECT DISTINCT\n\tCH.Container_Number as CONTE,\n\tC.EQ_Type AS EQUIPO,\n\tC.Shipper_Owned AS SOC\n FROM\n Interlink_DFeed90.dfeed.FNTB_Bill_Of_Lading (1, NULL) BL\n INNER JOIN Interlink_DFeed90.dfeed.FNTB_Charge (1, NULL) CH ON BL.Bill_of_Lading_id = CH.Bill_Of_Lading_id\n INNER JOIN Interlink_DFeed90.dfeed.FNTB_BOLREP_Container () C ON CH.Container_Number = C.Container_Number\n WHERE\n BL.Include_In_Manifest_And_DTX = '1'\n AND CH.Container_Number <> ''\n AND BL.Bill_Of_Lading_Number='{$bl}'\n "; $rsf = odbc_exec($conn2, $sql); while (odbc_fetch_row($rsf)) { $conte = odbc_result($rsf, "CONTE"); $equipo = odbc_result($rsf, "EQUIPO"); $soc = odbc_result($rsf, "SOC"); // Detectar el Equipo en SION. $sql2 = "select id_equipo from EQUIPO where equipo_link='{$equipo}' "; $dbf->query($sql2); while ($dbf->next_record()) { $idEquipo = $dbf->f('id_equipo'); } // Comprobar si existe en el SION, // Si existe, entonces actualzar equipo y SOC. // No existe, agregar. $sql2 = "select id_contenedor from CONTENEDOR where numero='{$conte}' "; $dbf->query($sql2); while ($dbf->next_record()) { $idConte = $dbf->f('id_contenedor'); } if (!empty($idConte)) { // Actualizar $sql2 = "update CONTENEDOR set id_equipo='{$idEquipo}',soc='{$soc}' where id_contenedor='{$idConte}'"; $dbf->query($sql2); unset($idConte); } else { // Nuevo contenedor $sql2 = "insert into CONTENEDOR ("; $sql2 .= "numero,id_equipo,soc"; $sql2 .= ") values ("; $sql2 .= "'{$conte}','{$idEquipo}','{$soc}'"; $sql2 .= ")"; $dbf->query($sql2); } $sql2 = "select id_contenedor from CONTENEDOR where numero='{$conte}' "; $dbf->query($sql2); while ($dbf->next_record()) { $idConte = $dbf->f('id_contenedor'); } $sql2 = "select Id_expo from EXPO where Bl='{$blSION}' "; $dbf->query($sql2); while ($dbf->next_record()) { $idBlSion = $dbf->f('Id_expo'); } if (!empty($idConte) && !empty($idBlSion)) { // Comprobar que no exista en SION : BL_CONTE, // Si no existe, entonces grabarlo en la relación bl-conte. $sql2 = "select id_bl_conte from BL_CONTE where id_bl='{$idBlSion}' and id_contenedor='{$idConte}' "; $dbf->query($sql2); while ($dbf->next_record()) { $idBlConte = $dbf->f('id_bl_conte'); } if (empty($idBlConte)) { $sql2 = "insert into BL_CONTE ("; $sql2 .= "id_bl,id_contenedor"; $sql2 .= ") values ("; $sql2 .= "'{$idBlSion}','{$idConte}'"; $sql2 .= ")"; $dbf->query($sql2); unset($idConte); unset($idBlSion); echo "[Cargado] {$bl} | {$conte} <br>\n"; } } } //odbc_close($conn2); }
/** * Execute the SQL query. * @param string $qs */ public function query($qs) { if ($this->env->warn_if_duplicate_query_executed) { if (isset($this->_query_texts[$qs])) { $count = $this->_query_texts[$qs]; log_message("The query [{$qs}] has already been executed [{$count}] times.", Msg_type_debug_warning, Msg_channel_database); $this->_query_texts[$qs] += 1; } else { $this->_query_texts[$qs] = 1; } } if (isset($this->env->profiler)) { $this->env->profiler->start('db'); DB_Sql::query($qs); $this->env->profiler->stop('db'); } else { DB_Sql::query($qs); } $this->env->num_queries_executed += 1; }
function save() { $db = new DB_Sql(); $db->query("INSERT INTO betaling_online SET date_created = NOW(), type='" . $this->type . "', transaktionsnummer = '', status='" . $this->eval['qpstat'] . "'"); return 1; }
function sendMail($bl, $pod) { global $hoy, $sionSrv, $sionDB; $db = new DB_Sql(); $db->connect($sionDB, $sionSrv, "root", ""); $mail = new phpmailer(); $mail->Priority = 0; // Se declara la prioridad del mensaje. // ------------------------------------------------ // CONFIGURAR EMAIL. // ------------------------------------------------ //Definimos las propiedades y llamamos a los m�todos //correspondientes del objeto mail //Con PluginDir le indicamos a la clase phpmailer donde se //encuentra la clase smtp que como he comentado al principio de //este ejemplo va a estar en el subdirectorio includes $mail->PluginDir = "../include/"; $mail->Mailer = "smtp"; // ++ EXCHANGE MSC ++ $userName = '******'; $linkPass = '******'; $mail->IsSMTP(); $mail->SMTPSecure = 'tls'; $mail->SMTPAuth = true; $mail->Host = 'mail.mscgva.ch'; // IP 193.138.73.142 $mail->Username = $userName; $mail->Password = $linkPass; $mail->Port = 25; $mail->From = '*****@*****.**'; $mail->FromName = 'Robot.SION'; $mail->Timeout = 10; //El valor por defecto 10 de Timeout es un poco escaso dado que voy a usar //una cuenta gratuita, por tanto lo pongo a 30 //$mail->Timeout=10; $mail->Timeout = 10; $paisSan = getValueTable("country", "DOC_PAIS_SANCIONADO", "code", $pod); // -------------------- // FORMATO HTML // -------------------- $mail->Body = "\n <html>\n <body>\n <center>\n <table border=0 cellpadding=2 cellspacing=1>\n <tr>\n <td width=\"60\" height=\"40\" valign=top align=right><img src=\"http://148.245.13.34/nestor/images/logoMscGoldSmall.gif\" ></td>\n <td valign=top align=center>\n <font size=\"4\"><b>Mediterranean Shipping Company M�xico S.A. de C.V.</b></font><br>\n <font size=\"2\">S�lo como agentes / As agents only</font>\n </td>\n </tr>\n <tr>\n <td colspan=2><hr></td>\n </tr>\n </table>\n <font size=\"4\"><b>NOTIFICACION - SANCTIONS COMPLIANCE<br>({$paisSan})</b><BR>{$bl}</font>\n </center>\n <p>\n\n Estimado Ejecutivo de Ventas\n <p>\n El bl de referencia tiene un destino a uno de los pa�ses sancionados.\n Por favor confirmar si el procedimiento de las pol�ticas de conformidad ha sido realizado y firmado por el Sr. Alonso Sope�a y/o el Sr. Homely Rojas\n de lo contrario la carga no podr� ser embarcada.\n <p>\n En espera de sus urgentes comentarios.\n <br>\n Este mensaje es enviado por razones de SEGURIDAD.\n <p>\n <i>\n Att. Robot SION.<br>\n </i>\n <p>\n <hr>\n <font color=\"red\" size=\"2\">\n <i>Este es un correo de envio autom�tico por nuestro sistema SION, por favor no responda este email.</i>\n </font>\n <br>\n <br>\n <br>\n\n </body>\n </html>\n\n "; // ------------------------------------------------------- // FORMATO TEXTO // Definimos AltBody por si el destinatario del correo // no admite email con formato html // ------------------------------------------------------- $mail->AltBody = "\n MEDITERRANEAN SHIPPING COMPANY M�XICO\n MSC M�xico (As Agents Only-Solo como Agentes)\n =====================================================================\n "; // Nota : // La direccion PARA solo se puede manejar 1. // Las direcciones CC puede manejar N correos. // ------------- // Destinatarios // ------------- $mail->ClearAddresses(); // ------------------------------------------------ /* $arrDirDestino[] ="*****@*****.**"; foreach ( $arrDirDestino as $emailDestino ) { if (! empty ( $emailDestino )) { $mail->AddAddress ( $emailDestino ); $emailDesTxt .= "$emailDestino,"; } } */ $mail->AddCC("*****@*****.**"); // Copia Ciega $mail->AddBCC("*****@*****.**"); $mail->AddBCC("*****@*****.**"); //$mail->AddAddress("*****@*****.**"); //if(!empty($sndCC))$mail->AddCC($sndCC); // ----------------------------------------- // Subject //----------------------------------------- $sql = "select * from DOC_CTRL_EXPO "; $sql .= "where bl='{$bl}' "; $db->query($sql); while ($db->next_record()) { // ----------------------------------------- // Comprobar q no tenga la firma BL-REVISION // ----------------------------------------- $bl = $db->f(bl); $bkg = $db->f(bkg); $bkgp = $db->f(bkg_party); $executive = $db->f(bkg_executive); $exeMail1 = getValueTable("mail1", "DOC_CAT_EJE", "cod", $executive); $exeMail2 = getValueTable("mail2", "DOC_CAT_EJE", "cod", $executive); $exeMail3 = getValueTable("mail3", "DOC_CAT_EJE", "cod", $executive); if (!empty($exeMail1)) { $mail->AddAddress($exeMail1); } if (!empty($exeMail2)) { $mail->AddAddress($exeMail2); } if (!empty($exeMail3)) { $mail->AddAddress($exeMail3); } $pol = $db->f(pol); $pod = $db->f(pod); $who = $db->f(who); $idBarco = getValueTable("id_barco", "DOC_CTRL_EXPO", "id_bl", $idBl); $vessel = getValueTable("Nombre", "BARCO", "Id_barco", $idBarco); $voy = getValueTable("Viaje", "BARCO", "Id_barco", $idBarco); $eta = getValueTable("Eta1", "BARCO", "Id_barco", $idBarco); $vesVoy = "{$vessel} / {$voy} (<font color=maroon>{$idBarco}</font>)"; $puerto = getValueTable("puerto", "CS_CODIGO", "codigo", $pod); $pais = getValueTable("pais", "CS_CODIGO", "codigo", $pod); } // VERACRUZ : MXVER // ALTAMIRA : MXLMR,MXATM // PACIFICO : MXZLO,MXMZT,MXSCX,MXLZC,MXPMS,MXGYM if ($pol == "MXVER") { $mail->AddCC("*****@*****.**"); } elseif ($pol == "MXZLO" || $pol == "MXMZT" || $pol == "MXSCX" || $pol == "MXLZC" || $pol == "MXPMS" || $pol == "MXGYM") { $mail->AddCC("*****@*****.**"); } elseif ($pol == "MXLMR" || $pol == "MXATM") { $mail->AddCC("*****@*****.**"); } else { $mail->AddCC("*****@*****.**"); } $paisSan = getValueTable("country", "DOC_PAIS_SANCIONADO", "code", $pol); $txtSubj = "SANCTIONS COMPLIANCE {$paisSan} / [{$who}] / {$vessel} {$voy} / MSCU{$bl} / {$bkg} / {$bkgp} / {$pol} / {$pol} / [{$who}] %0A%0A"; $txtSubj = str_replace("&", "AND", $txtSubj); $mail->Subject = "{$txtSubj}"; // Incluir Attach. //$mail->AddAttachment("../files/demo.txt","demo.txt"); // Se envia el mensaje, si no ha habido problemas, la variable $exito tendra el valor true $exito = $mail->Send(); /* // PARA INTAR REENVIARLO //Si el mensaje no ha podido ser enviado se realizaran 4 intentos mas como mucho //para intentar enviar el mensaje, cada intento se hara 5 segundos despues //del anterior, para ello se usa la funcion sleep $intentos=1; while ((!$exito) && ($intentos < 5)) { sleep(5); $exito = $mail->Send(); $intentos=$intentos+1; } */ if (!$exito) { echo "[ <font color=red><b>Problema de envio</b></font> ] {$emailDestino} -> {$valor}" . $mail->ErrorInfo . "<br>\n"; } else { echo "[ <font color=green><b>Enviado</b></font> ] <br>"; } }
<? include "../inc/config.php"; //?user_id=1&event_id=1&tekma_id=2 //$event_id = $_REQUEST["event_id"]; //$tekma_id = $_REQUEST["tekma_id"]; $user_id = $_REQUEST["user_id"]; echo "userID=".$user_id; //create db object// $db = new DB_Sql(); if ($user_id) { $sql = "delete from users where id_user='******'"; $db->query($sql); //echo $sql; //redirekt to monitor page// header("location:".$_SERVER['HTTP_REFERER']); exit(); } echo "Ups??";
/** * Cleans up old subscriptions * * NOTICE: Use cancel() and not delete() * * @return 1 on success */ function cleanUp() { $db = new DB_Sql(); $db->query("SELECT id, DATE_ADD(date_updated, INTERVAL 1 HOUR) AS date_created FROM kortkursus_tilmelding\n WHERE DATE_ADD(date_updated, INTERVAL 1 HOUR) < NOW()\n AND (status_key = '" . $this->getStatusKey('undervejs') . "' OR status_key = '" . $this->getStatusKey('ikke tilmeldt') . "') AND active = 1"); while ($db->nextRecord()) { $tilmelding = new VIH_Model_KortKursus_Tilmelding($db->f('id')); $tilmelding->setStatus('annulleret'); } return true; }
define('DB_USER', $dbuser); define('DB_PASS', $dbpass); define('DB_NAME', $dbname); $db = new DB_Sql(); // poprawiono dla wersji php < 4.3.0 if (!function_exists('file_get_contents')) { $sql_query = implode('', file($db_schema)); $sql_query = explode(';', $sql_query); } else { $sql_query = explode(';', file_get_contents($db_schema)); } $sql_query = str_replace('core_', $dbprefix, $sql_query); $sql_query = $lang == 'en' ? str_replace('DEFAULT_CATEGORY', 'default', $sql_query) : str_replace('DEFAULT_CATEGORY', 'ogólna', $sql_query); $sql_size = sizeof($sql_query) - 1; for ($i = 0; $i < $sql_size; $i++) { $db->query($sql_query[$i]); } $file = '<?php' . "\n"; $file .= "\n// Core CMS auto-generated config file\n\n"; $file .= 'define(\'DB_HOST\', \'' . $dbhost . '\');' . "\n"; $file .= 'define(\'DB_USER\', \'' . $dbuser . '\');' . "\n"; $file .= 'define(\'DB_PASS\', \'' . $dbpass . '\');' . "\n"; $file .= 'define(\'DB_NAME\', \'' . $dbname . '\');' . "\n"; $file .= 'define(\'PREFIX\', \'' . $dbprefix . '\');' . "\n\n"; $file .= "define('TABLE_ASSIGN2CAT', PREFIX . 'assign2cat');\n"; $file .= "define('TABLE_MAIN', PREFIX . 'devlog');\n"; $file .= "define('TABLE_USERS', PREFIX . 'users');\n"; $file .= "define('TABLE_COMMENTS', PREFIX . 'comments');\n"; $file .= "define('TABLE_CONFIG', PREFIX . 'config');\n"; $file .= "define('TABLE_CATEGORY', PREFIX . 'category');\n"; $file .= "define('TABLE_PAGES', PREFIX . 'pages');\n";
"; $db3->query($sql3); while( $db3->next_record() ){ $idBarcoX = $db3->f('Id_barco'); if( $idBarco!=$idBarcoX ){ echo "Se eliminara $nombre | $viaje | $eta | $IE | $puerto | $tlBls <br>"; } else{ echo "No se eliminara $nombre | $viaje | $eta | $IE | $puerto | $tlBls <br>""; } } */ } if ($flgDup == 1) { $sql3 = "select * from Z_BUQUE_DUP WHERE nombre='{$nombre}' and viaje='{$viaje}' and Eta1='{$eta}' and Impo_expo='{$IE}' and Puerto='{$puerto}'"; $db3->query($sql3); while ($db3->next_record()) { $idBarcoX = $db3->f('Id_barco'); if ($idBarco != $idBarcoX) { echo "[Eliminado] {$nombre} | {$viaje} | {$eta} | {$IE} | {$puerto} | {$tlBls} <br>"; // Mover los Bls al buque correcto. $sql2 = "update EXPO set Id_barco='{$idBarco}' where Id_barco='{$idBarcoX}'"; $db2->query($sql2); // Eliminar el buque. $sql2 = "delete from BARCO where Id_barco='{$idBarcoX}'"; $db2->query($sql2); $sql2 = "delete from Z_BUQUE_DUP where Id_barco='{$idBarcoX}'"; $db2->query($sql2); } else { //echo "No se eliminara $nombre | $viaje | $eta | $IE | $puerto | $tlBls <br>"; }
$conn = odbc_connect($dsn, $linkUsr, $linkPass); // --------------------------------------------------------------------------------------- if ($_POST['modo'] == "ok") { $salesExe = ""; $sql = "select * from Z_MS_POLPOD"; $db->query($sql); while ($db->next_record()) { $POLUN = ""; $PODUN = ""; //$id = $db->f('id'); $bl = $db->f('Bill_Of_Lading_Number'); $bl = str_replace("MSCU", "", $bl); $POLUN = $db->f('POLUN'); $PODUN = $db->f('PODUN'); $sql2 = "\n update EXPO \n set Loading='{$POLUN}', Discharge='{$PODUN}'\n WHERE Bl='{$bl}'"; $db2->query($sql2); echo "{$bl} [Actualizado] <br>"; } } ?> <!doctype html> <html lang="es"> <head> <meta charset="iso-8859-1"> <title>X-Tractor</title> <link href="../include/sionMenu.css" rel="stylesheet" type="text/css"> <script src="../include/funcionesG.js" language="javascript"></script> <link rel="stylesheet" type="text/css" href="../jquery/css/theme/jquery-ui.custom.css"> <script type="text/javascript" src="../jquery/js/jquery.min.js"></script>
/** * Statistics * * @todo Optimize */ function statistik($filter = '') { // count number of spots on each course $countPladser = 0; $countOptagne = 0; $db1 = new DB_Sql(); $sql = "SELECT id, pladser FROM kortkursus\r\n WHERE published=1\r\n AND tilmeldingsmulighed = 'Ja'\r\n AND DATE_FORMAT(dato_start, '%Y') >= 2005"; if (!empty($filter)) { $sql .= "\tAND gruppe_id = " . (int) $filter; } $sql .= " ORDER BY dato_start ASC"; $db1->query($sql); while ($db1->nextRecord()) { $countPladser += $db1->f('pladser'); $kursus = new VIH_Model_KortKursus($db1->f('id')); $countOptagne += $kursus->getOptagnePladser(); } if ($countPladser == 0) { $countPladser = 1; } $percent = round($countOptagne / $countPladser * 100, 0); return array('pladser' => $countPladser, 'percent' => $percent, 'optagne' => $countOptagne); }