public function SelectAppliSearch($name, $enseigne, $irt, $trigramme) { $tabParam = array(); if ($name) { $tabParam['libelle'] = $name; } if ($enseigne) { $tabParam['enseigne'] = $enseigne; } if ($irt) { $tabParam['irt'] = $irt; } if ($trigramme) { $tabParam['trigramme'] = $trigramme; } $rq = "SELECT ID,LIBELLE,ENSEIGNE,IRT,TRIGRAMME FROM " . SCHEMA . ".APPLICATION "; $rq .= "WHERE "; $l = 1; foreach ($tabParam as $key => $value) { $or = $l != count($tabParam) ? " AND" : ""; $rq .= "UPPER(REPLACE({$key},' ','')) LIKE '%" . strtoupper(str_replace(' ', '', $value)) . "%' " . $or; $l++; } $rq .= " ORDER BY NAME"; $db = new db(); $db->db_connect(); $db->db_query($rq); $res = $db->db_fetch_array(); return $res; }
public function SupprimerUtilisateur($id) { $rq = "DELETE FROM " . SCHEMA . ".UTILISATEURS_OSI WHERE ID=" . $id; $SCHEMA = new db(); $SCHEMA->db_connect(); $SCHEMA->db_query($rq); }
<?php include_once 'class/class.main.php'; $connect = new db(); $connect->db_connect(); $limit = 20; $page = (int) $_REQUEST['p']; if ($page < 1) { $page = 1; } $offset = ($page - 1) * $limit; //echo "SELECT SQL_CALC_FOUND_ROWS p.rated1, p.rated2, p.rated3, p.rated4, p.rated5, p.rated6, p.rated7, p.aveRate,p.photo_url,p.userName,c.item2Rate,c.selectedItems, pr.businessName, pr.address, pr.city, pr.country, pr.zip FROM photoshare AS p LEFT JOIN businessCustom AS c ON c.customPlaceId = p.placeId LEFT JOIN businessProfile as pr ON pr.profilePlaceId=p.placeId ORDER BY p.id DESC LIMIT $offset,$limit"; $result = mysql_query("SELECT SQL_CALC_FOUND_ROWS p.rated1, p.rated2, p.rated3, p.rated4, p.rated5, p.rated6, p.rated7, p.aveRate,p.photo_url,p.userName,c.item2Rate,c.selectedItems, pr.businessName, pr.address, pr.city, pr.country, pr.zip, pr.nicename,p.comment,p.userId FROM photoshare AS p LEFT JOIN businessCustom AS c ON c.customPlaceId = p.placeId LEFT JOIN businessProfile as pr ON pr.profilePlaceId=p.placeId WHERE p.source = 'fb' ORDER BY p.id DESC LIMIT {$offset},{$limit}"); $numberOfRows = mysql_result(mysql_query("SELECT FOUND_ROWS()"), 0, 0); $totalPages = ceil($numberOfRows / $limit); ?> <!DOCTYPE html> <html> <head> <meta name="robots" content="noindex, nofollow"/> <title>Photos share on facebook</title> <link href="css/bootstrap.css" rel="stylesheet" media="all"> <link href="css/style.css" rel="stylesheet" media="all"> <link rel="stylesheet" href="css/flexslider.css" media="all"> <script type="text/javascript" src="js/jquery.js"></script> <script type="text/javascript" src="js/bootstrap.min.js"></script> <script type="text/javascript" src="js/star-rating.js"></script> <script type="text/javascript" src="js/sharephoto.js"></script> <style stype="css/text"> section#photo{height:100%;width:100%;min-width:600px;max-width:66.8em;margin:0 auto;padding: 20px 0 20px 0;} section#photo .frame{width:100%;height:100%;padding: 10px 0 10px 0}
<?php session_start(); $login = $_POST['Username']; $pass = $_POST['Userpasswd']; if (isset($login) && $login && isset($pass) && $pass) { require_once '../inc/config.inc.php'; require_once '../classes/db.php'; require_once '../inc/fonctions.inc.php'; $rq = "SELECT ID,NOM,PRENOM,MAIL,LOGIN,PASSWD,PROFIL FROM " . SCHEMA . ".UTILISATEURS_OSI WHERE LOGIN='******'"; $SCHEMA = new db(); $SCHEMA->db_connect(); $SCHEMA->db_query($rq); $res = $SCHEMA->db_fetch_array(); $total = $SCHEMA->total_record(); if ($res[0]) { if (password_verify($pass, $res[0][5])) { $_SESSION['auth'] = $res[0]; unset($_SESSION['flash']); $_SESSION['flash']['success'] = "Vous êtes connecté."; $contenu_fichier_json = file_get_contents('../inc/TraceFiche.json'); $tr = json_decode($contenu_fichier_json, true); if (is_array($tr)) { foreach ($tr as $key => $value) { if ($value['user'] == $userConnected) { unset($tr[$key]); } } } $json = json_encode($tr); file_put_contents('../inc/TraceFiche.json', $json);
$commision = $row2->commission + 20; $unpaid = $row2->unpaid + 20; $sql = "UPDATE affsale SET sales=". $sales .",commission=". $commision .",unpaid=". $unpaid ." WHERE affId = ".$affid; mysql_query($sql); }else{ $sales = 1;$commision = 20;$unpaid = 20; $sql = "INSERT INTO affsale SET sales=". $sales .",commission=". $commision .",unpaid=". $unpaid .", affId = ".$affid; mysql_query($sql); } header("Location: app/signup.html?cust_id=$cust_id&subs_id=$subs_id"); //header("Location: http://tabluu.applicationcraft.com/app#/app?cust_id=$cust_id&subs_id=$subs_id"); } $db->db_disconnect(); }else{ */ if (isset($_REQUEST['cust_id']) && isset($_REQUEST['subs_id']) && isset($_REQUEST['ref'])) { $db->db_connect(); $cust_id = $_REQUEST['cust_id']; $url = '/customers/' . $cust_id . '/subscriptions.xml'; $result = $connector->sendRequest($url, $format = 'xml', $method = 'GET', $data = ''); if ($result->code == 200) { $objxml = simplexml_load_string($result->response); $state = $objxml->subscription->state; $expiry = $objxml->subscription->current_period_ends_at; $subs_id = $_REQUEST['subs_id']; $fname = $objxml->subscription->customer->first_name; $lname = $objxml->subscription->customer->last_name; $email = $objxml->subscription->customer->email; $productId = $objxml->subscription->product->id; $cust_id = $_REQUEST['cust_id']; $date = date('Y-m-d h:i:s'); $gId = $_REQUEST['ref'];
function checknicename() { include_once 'class/class.main.php'; $connect = new db(); $connect->db_connect(); $con = new fucn(); $link = strtolower($con->rand_string(7)); $result = mysql_query("SELECT id FROM businessProfile WHERE nicename = '{$link}'"); //check if link is existed if (mysql_num_rows($result)) { checknicename(); } else { return $link; } $connect->db_connect(); }
/** * Selectionnez la liste des stats * * @return $none */ public function SelectStat() { $requette = "SELECT ID,REFCHANGEMENT,DATEPUBIR,DATEPUBPM,TYPECAUSE,TYPECAUSESECONDAIRE,TYPOLIGYGTS,KINDIMPACT,RESPONSIBLETEAM,FOURNISSEURRESPONSIBLE,POWERPROD,LEGACY,COMPOSANT,COMPOSANTCOMPLEMENT,ZONEGEOGRAPHIQUE "; $requette = "FROM " . SCHEMA . ".STATISTIQUE "; $db = new db(); $db->db_connect(); $db->db_query($requette); $res = $db->db_fetch_array(); $db->close(); $tab = array(); for ($i = 0; $i < count($res); $i++) { $valeur = $res[$i]; array_push($tab, $this->SetParam($valeur[0], $valeur[1], $valeur[2], $valeur[3], $valeur[4], $valeur[5], $valeur[6], $valeur[7], $valeur[8], $valeur[9], $valeur[10], $valeur[11], $valeur[12], $valeur[13], $valeur[14])); } return $tab; }
public function Supprimer() { $base = new db(); $base->db_connect(); //Suppression de Stat if ($this->getIdStat()) { $rq = "DELETE FROM " . SCHEMA . ".STATISTIQUE "; $rq .= "WHERE ID=" . $this->getIdStat(); $base->db_query($rq); } //Suppression d'impact $rq = "DELETE FROM " . SCHEMA . ".IMPACT "; $rq .= "WHERE INCIDENT_ID=" . $this->getNumero(); $base->db_query($rq); // SUppression de l'incident $rq = "DELETE FROM " . SCHEMA . ".INCIDENT "; $rq .= "WHERE ID=" . $this->getNumero(); $base->db_query($rq); $base->close(); }
/** * Modification d'un objet * * @return mixed */ public function Supprimer($id) { $rq = "DELETE FROM " . SCHEMA . ".CALENDRIER"; $rq .= " WHERE ID=" . $id; $db = new db(); $db->db_connect(); $db->db_query($rq); $db->close(); }
function tweet_photo($tmhOAuth) { $connect = new db(); $connect->db_connect(); $nice = strtolower($_REQUEST['l']); $splitID = explode('-', $nice); $sql = "SELECT s.pathimg, p.profilePlaceId, p.nicename, l.businessName, l.subscribe,u.state,v.link,cam.brand, cam.tag1, cam.tag2 FROM businessProfile AS p\n LEFT JOIN businessList AS l ON l.id = p.profilePlaceId\n LEFT JOIN businessUserGroup AS u ON u.gId = l.userGroupId\n LEFT JOIN businessvanitylink AS v ON v.placeId = l.id\n LEFT JOIN campaigndetails AS cam ON cam.posterId = l.id\n LEFT JOIN businessCustom AS c ON c.customPlaceId = p.profilePlaceId\n LEFT JOIN sharedlink_{$splitID[1]} AS s ON s.link = '{$nice}'\n WHERE p.profilePlaceId = {$splitID[1]}\n LIMIT 1"; $result1 = mysql_query($sql) or die(mysql_error()); $row = mysql_fetch_object($result1); $dir = __DIR__ . '/' . $row->pathimg; $getpath = explode('/', $row->pathimg); $params = array('media[]' => "@{$dir};type={'jpg'};filename={$getpath[3]}", 'status' => $row->businessName . ' -- ' . strtolower($row->tag1) . ' ' . strtolower($row->tag2) . ' by ' . $row->brand . ' ' . 'http://camrally.com/app/user/' . $nice); $code = $tmhOAuth->user_request(array('method' => 'POST', 'url' => $tmhOAuth->url("1.1/statuses/update_with_media"), 'params' => $params, 'multipart' => true)); if ($code == 200) { $data = json_decode($tmhOAuth->response['response'], true); } else { error("There was an error communicating with Twitter. {$tmhOAuth->response['response']}"); return; } }
public function chargerImpact($id) { $req = "SELECT ID,INCIDENT_ID,APPLICATION_ID,TO_CHAR(DATESTART,'DD/MM/YYYY HH24:MI'),TO_CHAR(DATEEND,'DD/MM/YYYY HH24:MI'),DUREEREELLE,JOURHOMME,IMPACTMETIER,IMPACT,SLA,SEVERITE,DESCRIPTION,CREATED,UPDATED "; $req .= "FROM " . SCHEMA . ".IMPACT WHERE ID=" . $id . " "; $req .= "ORDER BY ID ASC"; $base = new db(); $base->db_connect(); $base->db_query($req); $res = $base->db_fetch_array(); $base->close(); $this->setParam($res[0][0], $res[0][1], $res[0][2], $res[0][3], $res[0][4], $res[0][5], $res[0][6], $res[0][7], $res[0][8], $res[0][9], $res[0][10], $res[0][11], $res[0][12], $res[0][13]); return $this; }
function checkshortULR() { include_once 'class/class.main.php'; $connect = new db(); $connect->db_connect(); $con = new fucn(); $link = strtolower($con->rand_string(6)); $result = mysql_query("SELECT id,source FROM businessshorturl WHERE link = '{$link}'"); //check if link is existed if (mysql_num_rows($result)) { checkshortULR(); } else { return $link; } $connect->db_connect(); }