Decoded Output
Download<?php error_reporting(E_ALL);date_default_timezone_set('America/Port-au-Prince');function t0(){$w368='localhost';$x369='quintgames_db';$z370='Quintgames2023@';$q371='quintgames_db';try{$l372=new x373("mysql:host=$w368;dbname=$q371",$x369,$z370,array(PDO::ATTR_PERSISTENT=>true));}catch(Exception $c374){die('Erreur : '.$c374->s375());}return $l372;}session_start();$i376='';function m1(){$g377='';if(isset($_SESSION['id'])){$g377=$_SESSION['id'];}if(isset($_SESSION['mid'])){$g377=$_SESSION['mid'];}if(isset($_SESSION['aid'])){$g377=$_SESSION['aid'];}if(isset($_SESSION['said'])){$g377=$_SESSION['said'];}return $g377;}$f378=m1();$g379=$_SERVER['REMOTE_ADDR'];function g2($e380){$g381=t0();$h382="SELECT $e380 FROM ct_options";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388[$e380];}if(isset($g389)){return $g389;}}$i390=utf8_encode(g2('site_name'));$o391=g2('site_logo');$n392=g2('site_favicon');$h393=g2('site_desc');$s394=g2('site_url');$z395=g2('site_url');$b396=g2('meta');function l3($p397){if($p397=='0'){$p397='Yes';}else{$p397='No';}return $p397;}function i4($a398){if($a398=='1'){$d399='Pay';}else{$d399='Non Pay';}return $d399;}function r5($z400){if($z400=='1'){$z400='Active';}else{$z400='Inactive';}return $z400;}function b6($i401,$m402,$t403,$f404,$l405,$w406,$v407){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_users (fullname, email, password, level, about, role, avatar) VALUES (? ,? ,? ,? ,? ,? ,?)');$b383->b408(1,$i401);$b383->b408(2,$m402);$b383->b408(3,$v407);$b383->b408(4,$t403);$b383->b408(5,$f404);$b383->b408(6,$l405);$b383->b408(7,$w406);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function p7($v410,$j411,$o412,$j413,$f414,$m402,$l415,$q416,$v407,$t403,$f404,$l405,$w406,$c417,$m418,$n419,$b420,$k421,$z422,$y423){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_users (`account_number`, `firstname`, `lastname`, `email`, `password`, `level`, `about`, `role`, `avatar`, `enterprise_name`, `position`, `phone`, `birthday`, `sex`, `date_signin`, `verified`, `code`, `active`, `profession`, `enterprise_type`) VALUES (? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,?)');$b383->b408(1,$v410);$b383->b408(2,$j411);$b383->b408(3,$o412);$b383->b408(4,$m402);$b383->b408(5,$v407);$b383->b408(6,$t403);$b383->b408(7,$f404);$b383->b408(8,$l405);$b383->b408(9,$w406);$b383->b408(10,$j413);$b383->b408(11,$f414);$b383->b408(12,$l415);$b383->b408(13,$q416);$b383->b408(14,$c417);$b383->b408(15,$m418);$b383->b408(16,$n419);$b383->b408(17,$b420);$b383->b408(18,$k421);$b383->b408(19,$z422);$b383->b408(20,$y423);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function f8($x424){if($x424=='0'||$x424==''||$x424=='Invalid file format..'||$x424=='Please select image..!'){$x424='img/placeholders/avatars/avatar12.jpg';}else{$x424='../'.$x424;}return $x424;}function m9($x424){if($x424=='0'||$x424==''||$x424=='Invalid file format..'||$x424=='Please select image..!'){$x424='img/default-avatar.png';}else{$x424=''.$x424;}return $x424;}function l10($l405){if($l405!=''){$l405=', '.$l405;}return $l405;}function p11($x424){if($x424=='0'||$x424==''){$x424='assets/images/avatar2.jpg';}else{$x424=$x424;}return $x424;}function f12($d425,$n426){if(isset($_GET['page'])&&$d425=='1'&&$n426=='0'){$u427="open";}elseif(isset($_GET['page'])&&$d425=='0'&&$n426=='1'){$u427='style="display: block;"';}else{$u427="";}return $u427;}function o13($d425,$n426){if(isset($_GET['section'])&&$d425=='1'&&$n426=='0'){$d428="open";}elseif(isset($_GET['section'])&&$d425=='0'&&$n426=='1'){$d428='style="display: block;"';}else{$d428="";}return $d428;}function z14($x429,$b430){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_job_lang (id_job,name) VALUES (? ,? )');$b383->b408(1,$x429);$b383->b408(2,$b430);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function g15($u431,$n432,$h433){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_mail_rapport (lot, reference, date_time) VALUES (? ,? ,?)');$b383->b408(1,$u431);$b383->b408(2,$n432);$b383->b408(3,$h433);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function p16($b434){$b434=str_replace("-","",$b434);return $b434;}function e17($r435,$t436){$x437=$r435*100;if($t436>0){$x437=$x437/$t436;}$x437=number_format($x437,2).'%';return $x437;}function b18($z438){if($z438>0){$e439='Profit';}elseif($z438==0){$e439='';}elseif($z438<0){$e439='Perte';}return $e439;}function i19($x440,$f441,$i442,$o388='show',$d443="order by name ASC"){$i444=g2('big_master_limit_trans');$y445=g2('master_limit_trans');if(r340('ct_limitations_transactions','level','0','reference_user',$x440,'level')=='0'){$d443="WHERE level = '0' AND reference_user = '$x440'";$h446=$d443.' superadmin identify';}elseif(r340('ct_limitations_transactions','level','0','reference_user',$i442,'level')=='0'){$d443="WHERE level = '0' AND reference_user = '$i442'";$h446=$d443.' id_master_agent';}elseif(r340('ct_limitations_transactions','level','0','reference_user',$f441,'level')=='0'){$d443="WHERE level = '0' AND reference_user = '$f441'";$h446=$d443.' id_bigmaster_agent';}elseif(r340('ct_limitations_transactions','id_user',$f441,'reference_user',$x440,'level')=='1'&&$i444=='1'){$d443="WHERE id_user = '$f441' AND reference_user = '$x440'";$h446=$d443.' id_bigmaster_agent';}elseif(r340('ct_limitations_transactions','id_user',$f441,'reference_user',$i442,'level')=='1'&&$i444=='1'){$d443="WHERE id_user = '$f441' AND reference_user = '$i442'";$h446=$d443.' id_bigmaster_agent';}elseif(r340('ct_limitations_transactions','id_user',$i442,'reference_user',$x440,'level')=='2'&&$y445=='1'){$d443="WHERE id_user = '$i442' AND reference_user = '$x440'";$h446=$d443.' id_master_agent';}elseif($y445=='1'){$d443="WHERE id_user = '$i442' AND reference_user = '0'";$h446=$d443.' id_master_agent';}elseif($i444=='1'){$d443="WHERE id_user = '$f441' AND reference_user = '0'";$h446=$d443.' id_bigmaster_agent';}else{$d443="WHERE level = '0' AND reference_user = '0'";$h446=$d443.' superadmin default';}$g381=t0();$h382="SELECT * FROM ct_limitations_transactions $d443";$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();foreach($c386 as $o388){$b447=$o388['play'];}if(isset($b447)){return $b447;}}elseif($o388=='user'){$c386=$b383->e387();foreach($c386 as $o388){$b447=$o388['level'];}if(isset($b447)){return $b447;}}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function g20($e451){$o452=60*$e451;$g453=time()-$o452;$z400='disconnect';$l372=t0();$b383=$l372->k384("UPDATE ct_online_users SET status = ? WHERE time_signin < '$g453'");$b383->b408(1,$z400);if($b383->u385()===true){$o452=60*720;$m454=time()-$o452;$z400='absent';$l372=t0();$h382="DELETE FROM ct_online_users WHERE time_signin < :time_signin";$b383=$l372->k384($h382);$b383->u385(array(':time_signin'=>$m454));return 1;}else{return 0;}}function i21($a455,$d456,$s457,$q458,$q459,$f460,$q461,$t403){$m454=time();$i462='0';try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_results (numbers,game,type,description,time_signin,date_result,reference_id, id_user, reference_user, level) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)');$b383->b408(1,$a455);$b383->b408(2,$d456);$b383->b408(3,$s457);$b383->b408(4,$i462);$b383->b408(5,$m454);$b383->b408(6,$q458);$b383->b408(7,$q459);$b383->b408(8,$f460);$b383->b408(9,$q461);$b383->b408(10,$t403);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function g22($q459,$f460,$q461,$h433,$t403){$y463='0';$l372=t0();$f464=z154('ct_users','id',m1(),'level');if($t403=='1'){$t465="AND (bigmaster_user = '$q461')";}elseif($t403=='2'){$t465="AND (master_user = '$q461')";}elseif($t403=='3'){$t465="AND (id_agent = '$q461')";}else{$t465="";}$b383=$l372->k384("UPDATE ct_ticket_status SET statut_ticket = ?, prize = ?, expire = ? WHERE date_time = '$h433' AND statut_ticket != '3' $t465");$b383->b408(1,$y463);$b383->b408(2,$y463);$b383->b408(3,$y463);if($b383->u385()===true){$b383=$l372->k384("UPDATE ct_ticket SET status = ?, prize = ?, expire = ?, pay = ? WHERE date_time = '$h433' AND status != '3' $t465");$b383->b408(1,$y463);$b383->b408(2,$y463);$b383->b408(3,$y463);$b383->b408(4,$y463);if($b383->u385()===true){$q458=str_replace('/','-',$h433);$b383=$l372->k384("DELETE FROM ct_results WHERE date_result = '$q458' AND id_user = '$f460' AND reference_user = '$q461' AND level = '$f464'");$b383->u385();}}}function y23($l466,$h433){$g381=t0();$h382="SELECT sum(prize) as total FROM ct_ticket WHERE serial_number = '$l466' AND date_time = '$h433'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['total'];}if(isset($g389)){return $g389;}else{return 0;}}function x24($q459,$q467,$q461){$m454=time();$p468='1';$r469='1';if($q467=='1'){$t465="AND (ct_ticket_status.bigmaster_user = '$q461')";}elseif($q467=='2'){$t465="AND (ct_ticket_status.master_user = '$q461')";}elseif($q467=='3'){$t465="AND (ct_ticket_status.id_agent = '$q461')";}else{$t465="";}try{$l372=t0();$b383=$l372->k384("UPDATE ct_ticket, ct_ticket_status SET ct_ticket_status.prize = ct_ticket.priz_total, ct_ticket_status.statut_ticket = '1' WHERE ct_ticket_status.serial_number = ct_ticket.serial_number AND ct_ticket.priz_total > '0' AND ct_ticket.reference_id = '$q459' AND ct_ticket_status.statut_ticket != '3' $t465");if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function n25($q459,$q467,$q461){$m454=time();$p468='1';$r469='1';if($q467=='1'){$t465="AND (ct_ticket_status.bigmaster_user = '$q461')";}elseif($q467=='2'){$t465="AND (ct_ticket_status.master_user = '$q461')";}elseif($q467=='3'){$t465="AND (ct_ticket_status.id_agent = '$q461')";}else{$t465="";}try{$l372=t0();$b383=$l372->k384("UPDATE ct_ticket, ct_ticket_status SET ct_ticket_status.statut_ticket = '2' WHERE ct_ticket_status.serial_number = ct_ticket.serial_number AND ct_ticket_status.prize = '0' AND ct_ticket.reference_id = '$q459' AND ct_ticket_status.statut_ticket != '3' $t465");if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function k26($z470,$c471,$x472,$s457,$q459,$d456,$q467,$q461,$a473=""){$m454=time();$p468='1';$r469='1';if($q467=='1'){$t465="AND (bigmaster_user = '$q461')";}elseif($q467=='2'){$t465="AND (master_user = '$q461')";}elseif($q467=='3'){$t465="AND (id_agent = '$q461')";}else{$t465="";}$a473=trim($a473);if($a473!=""){$l474="AND option_lot = '$a473'";}else{$l474="";}try{$l372=t0();$b383=$l372->k384("UPDATE ct_ticket SET status = ?, prize = prize+(amount*?), expire = ?, winning = ? WHERE numbers = ? AND type = ? AND reference_id = ? AND lot = ? $l474 AND status != '3' $t465");$b383->b408(1,$p468);$b383->b408(2,$z470);$b383->b408(3,$r469);$b383->b408(4,$c471);$b383->b408(5,$x472);$b383->b408(6,$s457);$b383->b408(7,$q459);$b383->b408(8,$d456);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function j27($z470,$c471,$x472,$s457,$q459,$d456,$q467,$q461,$a473=""){$m454=time();$p468='1';$r469='1';if($q467=='1'){$t465="AND (bigmaster_user = '$q461')";}elseif($q467=='2'){$t465="AND (master_user = '$q461')";}elseif($q467=='3'){$t465="AND (id_agent = '$q461')";}else{$t465="";}$a473=trim($a473);if($a473!=""){$l474="AND option_lot = '$a473'";}else{$l474="";}try{$l372=t0();$b383=$l372->k384("UPDATE ct_ticket SET status = ?, prize = amount*?, expire = ?, winning = ? WHERE numbers = ? AND type = ? AND reference_id = ? AND lot = ? $l474 AND status != '3' $t465");$b383->b408(1,$p468);$b383->b408(2,$z470);$b383->b408(3,$r469);$b383->b408(4,$c471);$b383->b408(5,$x472);$b383->b408(6,$s457);$b383->b408(7,$q459);$b383->b408(8,$d456);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function l28($z470,$c471,$x472,$s457,$q459,$d456,$q467,$q461){$m454=time();$p468='1';$r469='1';if($q467=='1'){$t465="AND (bigmaster_user = '$q461')";}elseif($q467=='2'){$t465="AND (master_user = '$q461')";}elseif($q467=='3'){$t465="AND (id_agent = '$q461')";}else{$t465="";}try{$l372=t0();$b383=$l372->k384("UPDATE ct_ticket SET status = ?, prize = ?, expire = ?, winning = ? WHERE numbers = ? AND type = ? AND reference_id = ? AND lot = ? AND status != '3' AND expire = '0' $t465");$b383->b408(1,$p468);$b383->b408(2,$z470);$b383->b408(3,$r469);$b383->b408(4,$c471);$b383->b408(5,$x472);$b383->b408(6,$s457);$b383->b408(7,$q459);$b383->b408(8,$d456);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function u29($z470,$c471,$y475,$j476,$t477,$z478,$g479,$j480,$s457,$q459,$d456,$q467,$q461){$m454=time();$p468='1';$r469='1';if($q467=='1'){$t465="AND (bigmaster_user = '$q461')";}elseif($q467=='2'){$t465="AND (master_user = '$q461')";}elseif($q467=='3'){$t465="AND (id_agent = '$q461')";}else{$t465="";}try{$l372=t0();$b383=$l372->k384("UPDATE ct_ticket SET status = ?, prize = amount*?, expire = ?, winning = ? WHERE (numbers = ? OR numbers = ? OR numbers = ? OR numbers = ? OR numbers = ? OR numbers = ?) AND type = ? AND reference_id = ? AND lot = ? AND status != '3' AND expire = '0' $t465");$b383->b408(1,$p468);$b383->b408(2,$z470);$b383->b408(3,$r469);$b383->b408(4,$c471);$b383->b408(5,$y475);$b383->b408(6,$j476);$b383->b408(7,$t477);$b383->b408(8,$z478);$b383->b408(9,$g479);$b383->b408(10,$j480);$b383->b408(11,$s457);$b383->b408(12,$q459);$b383->b408(13,$d456);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function z30($q459,$d456,$q467,$q461){$m454=time();$f481='2';$r469='1';if($q467=='1'){$t465="AND (bigmaster_user = '$q461')";}elseif($q467=='2'){$t465="AND (master_user = '$q461')";}elseif($q467=='3'){$t465="AND (id_agent = '$q461')";}else{$t465="";}try{$l372=t0();$b383=$l372->k384("UPDATE ct_ticket SET status = ?, expire = ? WHERE reference_id = ? AND lot = ? AND status != '3' AND expire = '0' $t465");$b383->b408(1,$f481);$b383->b408(2,$r469);$b383->b408(3,$q459);$b383->b408(4,$d456);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function q31($q459,$q467,$q461){$m454=time();$f481='2';$r469='1';if($q467=='1'){$t465="AND (bigmaster_user = '$q461')";}elseif($q467=='2'){$t465="AND (master_user = '$q461')";}elseif($q467=='3'){$t465="AND (id_agent = '$q461')";}else{$t465="";}try{$l372=t0();$b383=$l372->k384("UPDATE ct_ticket p, (SELECT serial_number, sum(prize) as total FROM ct_ticket WHERE reference_id = '$q459' GROUP BY serial_number) as s SET p.priz_total = s.total WHERE p.serial_number = s.serial_number AND p.reference_id = '$q459'");if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function g32($l466,$z482,$h433){$m454=time();$i462='0';$x483=y23($l466,$h433);$b484=r340('ct_ticket_status','serial_number',$l466,'date_time',$h433,'amount');$v485=r340('ct_ticket_status','serial_number',$l466,'date_time',$h433,'commission_agent');$s486=r340('ct_ticket_status','serial_number',$l466,'date_time',$h433,'commission_masteragent');$h487=r340('ct_ticket_status','serial_number',$l466,'date_time',$h433,'commission_bigmasteragent');$v488=$b484-$v485-$s486-$h487-$x483;$r469="1";if($x483>0){$j489='1';$l372=t0();$b383=$l372->k384('UPDATE ct_ticket_status SET statut_ticket = ?, prize = ?, net = ?, expire = ? WHERE serial_number = ? AND date_time = ?');$b383->b408(1,$j489);$b383->b408(2,$x483);$b383->b408(3,$v488);$b383->b408(4,$r469);$b383->b408(5,$l466);$b383->b408(6,$h433);if($b383->u385()===true){return 1;}else{return 0;}}else{$i490='2';$l372=t0();$b383=$l372->k384('UPDATE ct_ticket_status SET statut_ticket = ?, net = ? WHERE serial_number = ? AND date_time = ?');$b383->b408(1,$i490);$b383->b408(2,$v488);$b383->b408(3,$l466);$b383->b408(4,$h433);if($b383->u385()===true){return 1;}else{return 0;}}}function w33(){$g381=t0();$h382="SELECT * FROM ct_users WHERE prepaye = '1' AND level = '3'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function k34($z482){if($z482>0){$d491='class="alert alert-success" style="color: #000;"';}else{$d491='';}return $d491;}function e35($z400){if($z400=='En attente'){$d491='alert alert-primary';}if($z400=='Gagnant'){$d491='alert alert-success';}if($z400=='Perdant'){$d491='alert alert-danger';}if($z400=='Annul'){$d491='alert alert-secondary';}if(isset($d491)){return $d491;}}function z36($l466){$g381=t0();$h382="SELECT * FROM ct_ticket_status WHERE serial_number = '$l466'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$b492=$o388['statut_ticket'];if($b492=='0'){$v493="Pending";$v493="En attente";}if($b492=='1'){$v493="Winner";$v493="Gagnant";}if($b492=='2'){$v493="Loser";$v493="Perdant";}if($b492=='3'){$v493="Cancelled";$v493="Annul";}}if(isset($v493)){return $v493;}}function t37($o494){$g381=t0();$h382="SELECT * FROM ct_sortition_user WHERE user = '$o494' order by name ASC";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function o38(){$g381=t0();$h382="SELECT * FROM ct_users";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function a39($b484,$f460){$l372=t0();$b383=$l372->k384("UPDATE ct_users SET wallet_prepay = ? WHERE (id = ?)");$b383->b408(1,$b484);$b383->b408(2,$f460);if($b383->u385()===true){return 1;}else{return 0;}}function v40($x495,$f460){$l372=t0();$b383=$l372->k384("UPDATE ct_users SET wallet_prepay = wallet_prepay-? WHERE (id = ?)");$b383->b408(1,$x495);$b383->b408(2,$f460);if($b383->u385()===true){return 1;}else{return 0;}}function g41($b484,$f460){$l372=t0();$b383=$l372->k384("UPDATE ct_users SET wallet_prepay = wallet_prepay+? WHERE (id = ?)");$b383->b408(1,$b484);$b383->b408(2,$f460);if($b383->u385()===true){return 1;}else{return 0;}}function w42($z496,$j497,$q498,$n499,$t403,$w500,$t501,$h433,$m454){$m454=time();try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_transactions_prepay (amount,options,sender_user, recipient_user, level, master_user, bigmaster_user, date_time, time_signin) VALUES (?, ?, ?, ?, ? ,? ,? ,? ,?)');$b383->b408(1,$z496);$b383->b408(2,$j497);$b383->b408(3,$q498);$b383->b408(4,$n499);$b383->b408(5,$t403);$b383->b408(6,$w500);$b383->b408(7,$t501);$b383->b408(8,$h433);$b383->b408(9,$m454);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function l43($a455,$u502,$s457,$d456,$j497,$q461,$t403){$h433=time();$f460=m1();try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_limitations_transactions (numbers,play,type,options, game, date_time,id_user,reference_user,level) VALUES (?, ?, ?, ?, ?, ?, ? ,? ,?)');$b383->b408(1,$a455);$b383->b408(2,$u502);$b383->b408(3,$s457);$b383->b408(4,$j497);$b383->b408(5,$d456);$b383->b408(6,$h433);$b383->b408(7,$f460);$b383->b408(8,$q461);$b383->b408(9,$t403);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function p44($a455,$u502,$s457,$d456,$j497,$q461,$t403){$h433=time();$w500=m1();try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_limitations (numbers,play,type,options, game, date_time,master_user,reference_user,level) VALUES (?, ?, ?, ?, ?, ?, ? ,? ,?)');$b383->b408(1,$a455);$b383->b408(2,$u502);$b383->b408(3,$s457);$b383->b408(4,$j497);$b383->b408(5,$d456);$b383->b408(6,$h433);$b383->b408(7,$w500);$b383->b408(8,$q461);$b383->b408(9,$t403);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function g45($f460,$q461,$t403,$t503,$n504,$u505,$b506,$g507,$l415){$h433=time();try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_ticket_customization (id_user, reference_user, level, title_text_original, title_text_cancel, footer_text_1, footer_text_2, footer_text_3, phone, date_time) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)');$b383->b408(1,$f460);$b383->b408(2,$q461);$b383->b408(3,$t403);$b383->b408(4,$t503);$b383->b408(5,$n504);$b383->b408(6,$u505);$b383->b408(7,$b506);$b383->b408(8,$g507);$b383->b408(9,$l415);$b383->b408(10,$h433);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function j46($f460,$q461,$t403){$g381=t0();$h382="SELECT * FROM ct_ticket_customization WHERE id_user = '$f460' AND reference_user = '$q461' AND level = '$t403'";$b383=$g381->k384($h382);$b383->u385();$f448=$b383->y449();$b383->u450();return $f448;}function j47($f460,$q461,$t403,$t503,$n504,$u505,$b506,$g507,$l415){try{$l372=t0();$b383=$l372->k384('UPDATE ct_ticket_customization SET title_text_original = ?, title_text_cancel = ?, footer_text_1 = ?, footer_text_2 = ?, footer_text_3 = ?, phone = ? WHERE id_user = ? AND reference_user = ? AND level = ?');$b383->b408(1,$t503);$b383->b408(2,$n504);$b383->b408(3,$u505);$b383->b408(4,$b506);$b383->b408(5,$g507);$b383->b408(6,$l415);$b383->b408(7,$f460);$b383->b408(8,$q461);$b383->b408(9,$t403);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function p48($z400,$g377,$z482,$c471){$m454=time();$i462='0';$r469="1";try{$l372=t0();$b383=$l372->k384('UPDATE ct_ticket SET status = ?, prize = ?, expire = ?, winning = ? WHERE id = ?');$b383->b408(1,$z400);$b383->b408(2,$z482);$b383->b408(3,$r469);$b383->b408(4,$c471);$b383->b408(5,$g377);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function o49($f460,$q461,$t403,$h508,$h509,$d456){$h433=time();try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_product_price (id_user, reference_user, level, product, price, game, date_time) VALUES (?, ?, ?, ?, ?, ?, ?)');$b383->b408(1,$f460);$b383->b408(2,$q461);$b383->b408(3,$t403);$b383->b408(4,$h508);$b383->b408(5,$h509);$b383->b408(6,$d456);$b383->b408(7,$h433);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function y50($f460,$q461,$t403,$h508,$d456){$g381=t0();$h382="SELECT * FROM ct_product_price WHERE id_user = '$f460' AND reference_user = '$q461' AND level = '$t403' AND product = '$h508' AND game = '$d456'";$b383=$g381->k384($h382);$b383->u385();$f448=$b383->y449();$b383->u450();return $f448;}function x51($f460,$q461,$t403,$h508,$h509,$d456){try{$l372=t0();$b383=$l372->k384('UPDATE ct_product_price SET price = ? WHERE product = ? AND id_user = ? AND reference_user = ? AND level = ? AND game = ?');$b383->b408(1,$h509);$b383->b408(2,$h508);$b383->b408(3,$f460);$b383->b408(4,$q461);$b383->b408(5,$t403);$b383->b408(6,$d456);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function p52($f460){$l372=t0();$b383=$l372->k384('DELETE FROM ct_cookie WHERE id_user = ?');$b383->b408(1,$f460);if($b383->u385()===true){return 1;}else{return 0;}}function f53($f460,$q461,$t403){$l372=t0();$b383=$l372->k384('DELETE FROM ct_ticket_customization WHERE id_user = ? AND reference_user = ? AND level = ?');$b383->b408(1,$f460);$b383->b408(2,$q461);$b383->b408(3,$t403);if($b383->u385()===true){return 1;}else{return 0;}}function s54($o510,$z511){try{$l372=t0();$b383=$l372->k384('UPDATE ct_options SET big_master_ticket_footer = ?, master_ticket_footer = ?');$b383->b408(1,$o510);$b383->b408(2,$z511);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function a55($d512,$o513){try{$l372=t0();$b383=$l372->k384('UPDATE ct_options SET big_master_add_result = ?, master_add_result = ?');$b383->b408(1,$d512);$b383->b408(2,$o513);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function k56($l514,$o515){try{$l372=t0();$b383=$l372->k384('UPDATE ct_options SET big_master_product_price = ?, master_product_price = ?');$b383->b408(1,$l514);$b383->b408(2,$o515);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function u57($m516,$f517,$e380,$t518){try{$l372=t0();$b383=$l372->k384("UPDATE ct_options SET $e380 = ?, $t518 = ?");$b383->b408(1,$m516);$b383->b408(2,$f517);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function r58($j411,$o412,$m402,$l415,$m519,$f520,$v407,$q459='0',$z400,$q521,$w500,$t403,$g522,$p523='0',$b524='0',$x525='0',$t501,$h526,$b527,$j528){$m454=time();try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_users (firstname, lastname, email, phone, state, address, password, references_id, level, time_signin, status, percentage, master_user, username, password_default, enterprise, logo, currency, bigmaster_user, prepaye, mariage_gratis, details) VALUES (? ,? ,?, ? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,?)');$b383->b408(1,$j411);$b383->b408(2,$o412);$b383->b408(3,$m402);$b383->b408(4,$l415);$b383->b408(5,$m519);$b383->b408(6,$f520);$b383->b408(7,$v407);$b383->b408(8,$q459);$b383->b408(9,$t403);$b383->b408(10,$m454);$b383->b408(11,$z400);$b383->b408(12,$q521);$b383->b408(13,$w500);$b383->b408(14,$g522);$b383->b408(15,$v407);$b383->b408(16,$p523);$b383->b408(17,$b524);$b383->b408(18,$x525);$b383->b408(19,$t501);$b383->b408(20,$h526);$b383->b408(21,$b527);$b383->b408(22,$j528);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function c59(){$g381=t0();$h382="SELECT * FROM ct_ticket WHERE master_user = 'Clients' order by id ASC";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function i60($r529){$g381=t0();$h382="SELECT * FROM ct_options";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388[$r529];}if(isset($g389)){if($g389=='0'){$z400='';}elseif($g389=='1'){$z400='checked';}return $z400;}}function m61($t530,$z531){$z400="0";if(strlen($t530)==3){$i532=$t530[0];$a533=$t530[1];$y534=$t530[2];if(strpos($z531,$i532)!==false&&strpos($z531,$a533)!==false&&strpos($z531,$y534)!==false){$z400="1";}else{$z400="0";}return $z400;}}function l62($t530){if(strlen($t530)==3){$i532=$t530[0];$a533=$t530[1];$y534=$t530[2];return $i532.$a533.$y534;}}function z63($t530){if(strlen($t530)==3){$i532=$t530[0];$a533=$t530[2];$y534=$t530[1];return $i532.$a533.$y534;}}function t64($t530){if(strlen($t530)==3){$i532=$t530[1];$a533=$t530[0];$y534=$t530[2];return $i532.$a533.$y534;}}function c65($t530){if(strlen($t530)==3){$i532=$t530[1];$a533=$t530[2];$y534=$t530[0];return $i532.$a533.$y534;}}function t66($t530){if(strlen($t530)==3){$i532=$t530[2];$a533=$t530[0];$y534=$t530[1];return $i532.$a533.$y534;}}function c67($t530){if(strlen($t530)==3){$i532=$t530[2];$a533=$t530[1];$y534=$t530[0];return $i532.$a533.$y534;}}function l68($h508,$d456,$f460,$w500,$t501){$g381=t0();$h382="SELECT price FROM ct_product_price WHERE product = '$h508' AND game = '$d456'
AND ((level = '0' AND reference_user = '0') OR (level = '0' AND reference_user = '$f460') OR (level = '0' AND reference_user = '$w500') OR (level = '0' AND reference_user = '$t501')
OR (id_user = '$t501' AND reference_user = '0') OR (id_user = '$t501' AND reference_user = '$f460') OR (id_user = '$t501' AND reference_user = '$w500') OR (id_user = '$f460' AND reference_user = '0')
OR (id_user = '$w500' AND reference_user = '0') OR (id_user = '$w500' AND reference_user = '$f460')) ORDER BY id DESC LIMIT 1";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['price'];}if(isset($g389)){return $g389;}}function e69($h508,$d456,$f460,$w500,$t501){$l514=g2('big_master_product_price');$o515=g2('master_product_price');if(j338('ct_product_price','level','0','reference_user',$f460,'product',$h508,'game',$d456,'level')=='0'){$e535=j338('ct_product_price','level','0','reference_user',$f460,'product',$h508,'game',$d456,'price');}elseif(j338('ct_product_price','level','0','reference_user',$w500,'product',$h508,'game',$d456,'level')=='0'){$e535=j338('ct_product_price','level','0','reference_user',$w500,'product',$h508,'game',$d456,'price');}elseif(j338('ct_product_price','level','0','reference_user',$t501,'product',$h508,'game',$d456,'level')=='0'){$e535=j338('ct_product_price','level','0','reference_user',$t501,'product',$h508,'game',$d456,'price');}elseif(j338('ct_product_price','id_user',$t501,'reference_user',$f460,'product',$h508,'game',$d456,'level')=='1'&&$l514=='1'){$e535=j338('ct_product_price','id_user',$t501,'reference_user',$f460,'product',$h508,'game',$d456,'price');}elseif(j338('ct_product_price','id_user',$t501,'reference_user',$w500,'product',$h508,'game',$d456,'level')=='1'&&$l514=='1'){$e535=j338('ct_product_price','id_user',$t501,'reference_user',$w500,'product',$h508,'game',$d456,'price');}elseif(j338('ct_product_price','id_user',$w500,'reference_user',$f460,'product',$h508,'game',$d456,'level')=='2'&&$o515=='1'){$e535=j338('ct_product_price','id_user',$w500,'reference_user',$f460,'product',$h508,'game',$d456,'price');}elseif(j338('ct_product_price','id_user',$w500,'reference_user','0','product',$h508,'game',$d456,'level')=='2'&&$o515=='1'){$e535=j338('ct_product_price','id_user',$w500,'reference_user','0','product',$h508,'game',$d456,'price');}elseif(j338('ct_product_price','id_user',$t501,'reference_user','0','product',$h508,'game',$d456,'level')=='1'&&$l514=='1'){$e535=j338('ct_product_price','id_user',$t501,'reference_user','0','product',$h508,'game',$d456,'price');}else{$e535=j338('ct_product_price','level','0','reference_user','0','product',$h508,'game',$d456,'price');}return $e535;}function i70($c536="name ASC",$o388="show"){$g381=t0();$h382="SELECT * FROM ct_sortition WHERE status = '1' order by $c536";$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();return $c386;}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function q71($f460,$q461,$o388="show"){$g381=t0();$h382="SELECT * FROM ct_sortition_user WHERE id_user = '$f460' AND reference_user = '$q461' order by name ASC";$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();return $c386;}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function d72($q459,$o388){$g381=t0();$h382="SELECT DISTINCT(id_user) FROM ct_results WHERE reference_id = '$q459' AND level ='1'";$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();return $c386;}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function h73($d456,$q458,$s457){$g381=t0();$h382="SELECT numbers FROM ct_results WHERE game = '$d456' AND date_result = '$q458' AND type = '$s457'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['numbers'];}if(isset($g389)){return $g389;}}function r74($g377,$o537,$f538,$k539,$x540,$i541,$o388,$a455,$s457,$j497="",$g522="",$c471=""){$x540=htmlspecialchars_decode($x540,ENT_QUOTES);if(trim($x540)!=''){$i542="AND lot in ($x540)";}else{$i542='';}$y543='';$c471=trim($c471);if($c471!=''){$h544="AND winning = '$c471'";}else{$h544='';}$j497=trim($j497);if($j497!=''){$k545="AND option_lot = '$j497'";}else{$k545='';}$s457=trim($s457);if($s457!=''){$w546="AND type = '$s457'";}else{$w546='';}$a455=trim($a455);if($a455!=''){$z547="AND numbers = '$a455'";}else{$z547='';}$u548=z154('ct_users','username',$g522,'id');$m549=z154('ct_users','username',$g522,'level');if($m549=='0'){$j550="AND bigmaster_user = '$u548'";}elseif($m549=='1'){$j550="AND bigmaster_user = '$u548'";}elseif($m549=='2'){$j550="AND master_user = '$u548'";}elseif($m549=='3'){$j550="AND id_agent = '$u548'";}if(isset($_SESSION['said'])){if($o537=='1'){if($g522!=""){$y543=$j550;}$e551="";}elseif($o537=='2'){if($g522!=""){$y543=$j550;}$e551="";}elseif($o537=='3'){if($g522!=""){$y543=$j550;}$e551="";}else{$y543="";$e551="";}}elseif(isset($_SESSION['aid'])){if($o537=='2'){if($g522!=""){$y543=$j550;}$e551="AND (bigmaster_user = '$g377')";}elseif($o537=='3'){if($g522!=""){$y543=$j550;}$e551="AND (master_user = '$g377' OR bigmaster_user = '$g377')";}else{$e551="AND (master_user = '$g377' OR bigmaster_user = '$g377')";}}elseif(isset($_SESSION['mid'])){if($o537=='3'){if($g522!=""){$y543=$j550;}$e551="AND (master_user = '$g377')";}else{$e551="AND (master_user = '$g377')";}}if($o388=='count'){$i541='';}$h552=$f538;$b553=$k539;$p554=str_replace('/','-',$f538);$n555=str_replace('/','-',$k539);$f538=strtotime($p554);$k539=strtotime($n555);$k539=$k539+86399;$q556=gmdate("m-d-Y",$f538);$k557=gmdate("m-d-Y",$k539);$g381=t0();if($f538==$k539){$h382="SELECT * FROM ct_ticket WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' AND status != '3' $w546 $z547 $i542 $y543 $e551 $k545 $h544 ORDER BY numbers $i541";}else{$h382="SELECT * FROM ct_ticket WHERE time_signin >= '$f538' AND time_signin <= '$k539' AND status != '3' $w546 $z547 $i542 $y543 $e551 $k545 $h544 ORDER BY numbers $i541";}$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['numbers'];}if(isset($g389)){return $g389;}}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function n75($f460,$q458){$g381=t0();$h382="SELECT DISTINCT reference_user FROM ct_results WHERE id_user = '$f460' AND date_result = '$q458'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function y76($u431){$u431=strtoupper(str_replace(' ','',$u431));$g381=t0();$h382="SELECT * FROM ct_sortition WHERE lot = '$u431'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['name'];}if(isset($g389)){return $g389;}}function s77($w558,$h433){$g381=t0();$h382="SELECT max(time_signin) as last FROM ct_ticket_status WHERE id_agent = '$w558' AND date_time = '$h433'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['last'];}if(isset($g389)){return $g389;}else{return 0;}}function d78($w558,$f538,$k539){if(trim($w558)!=''){$u559="AND reference_user = '$w558'";}else{$u559="";}$h552=$f538;$b553=$k539;$p554=str_replace('/','-',$f538);$n555=str_replace('/','-',$k539);$f538=strtotime($p554);$k539=strtotime($n555);$k539=$k539+86399;$q556=gmdate("m-d-Y",$f538);$k557=gmdate("m-d-Y",$k539);$g381=t0();if($f538==$k539){$h382="SELECT sum(amount_pay) as total FROM ct_transactions WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' $u559";}else{$h382="SELECT sum(amount_pay) as total FROM ct_transactions WHERE time_signin >= '$f538' AND time_signin <= '$k539' $u559";}$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['total'];}if(isset($g389)){return $g389;}else{return 0;}}function l79($f460,$f538,$k539){$h552=$f538;$b553=$k539;$p554=str_replace('/','-',$f538);$n555=str_replace('/','-',$k539);$f538=strtotime($p554);$k539=strtotime($n555);$k539=$k539+86399;$q556=gmdate("m-d-Y",$f538);$k557=gmdate("m-d-Y",$k539);$g381=t0();if($f538==$k539){$h382="SELECT sum(amount_pay) as total FROM ct_transactions WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' AND id_user = '$f460' ";}else{$h382="SELECT sum(amount_pay) as total FROM ct_transactions WHERE time_signin >= '$f538' AND time_signin <= '$k539' AND id_user = '$f460' ";}$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['total'];}if(isset($g389)){return $g389;}else{return 0;}}function d80($f460){$g381=t0();$h382="SELECT sum(amount_pay) as total FROM ct_transactions WHERE id_user = '$f460'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['total'];}if(isset($g389)){return $g389;}else{return 0;}}function d81($w558){$g381=t0();$h382="SELECT sum(amount) as total FROM ct_ticket WHERE id_agent = '$w558' AND status != '3'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['total'];}if(isset($g389)){return $g389;}else{return 0;}}function z82($o388,$w558){$g381=t0();$h382="SELECT sum($o388) as total FROM ct_ticket WHERE id_agent = '$w558' AND status != '3'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['total'];}if(isset($g389)){return $g389;}else{return 0;}}function i83($w558){$g381=t0();$h382="SELECT sum(prize) as total FROM ct_ticket WHERE id_agent = '$w558' AND status != '3'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['total'];}if(isset($g389)){return $g389;}else{return 0;}}function f84($f460){$g381=t0();$h382="SELECT sum(amount) as total FROM ct_ticket WHERE master_user = '$f460' AND status != '3'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['total'];}if(isset($g389)){return $g389;}else{return 0;}}function p85($f460){$g381=t0();$h382="SELECT sum(commission_agent) as total FROM ct_ticket WHERE master_user = '$f460' AND status != '3'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['total'];}if(isset($g389)){return $g389;}else{return 0;}}function t86($f460){$g381=t0();$h382="SELECT sum(prize) as total FROM ct_ticket WHERE master_user = '$f460' AND status != '3'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['total'];}if(isset($g389)){return $g389;}else{return 0;}}function f87($g377){$g381=t0();$h382="SELECT * FROM ct_product_price WHERE id_user = '$g377' order by id DESC";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function z88($g377,$q560){$g381=t0();if($q560=='1'){$u561="(level = '0' AND reference_user = '$g377')";}elseif($q560=='2'){$u561="id_user = '$g377'";}elseif($q560=='3'){$u561="(level = '0' AND reference_user = '0')";}$h382="SELECT * FROM ct_product_price WHERE $u561 order by id DESC";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function p89($g377,$w500,$q560){$g381=t0();if($q560=='1'){$u561="(level = '0' AND reference_user = '$g377')";}elseif($q560=='2'){$u561="(level = '0' AND reference_user = '$w500')";}if($q560=='3'){$u561="(level = '1' AND reference_user = '$g377')";}elseif($q560=='4'){$u561="id_user = '$g377'";}if($q560=='5'){$u561="(level = '1' AND id_user = '$w500')";}elseif($q560=='6'){$u561="(level = '0' AND reference_user = '0')";}$h382="SELECT * FROM ct_product_price WHERE id_user = '$g377' OR (level = '0' AND reference_user = '0') OR reference_user = '$g377' OR reference_user = '$w500' order by id DESC";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function n90($g377){$g381=t0();$h382="SELECT * FROM ct_limitations WHERE master_user = '$g377' order by type DESC";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function q91($g377){$g381=t0();$h382="SELECT * FROM ct_limitations_transactions WHERE id_user = '$g377' order by type DESC";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function m92($g377){$g381=t0();$h382="SELECT * FROM ct_limitations_transactions WHERE id_user = '$g377' AND reference_user ='0'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['play'];}if(isset($g389)){return $g389;}else{return 0;}}function b93($g377,$s457){$g381=t0();$h382="SELECT * FROM ct_limitations WHERE type = 'default_play' AND options = '$s457' AND master_user = '$g377' AND reference_user = '0'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['play'];}if(isset($g389)){return $g389;}else{return 0;}}function c94($s457,$d456,$q461,$r529,$j562,$a455){$g381=t0();$h382="SELECT * FROM ct_limitations WHERE type = '$j562' AND options = '$s457' AND game = '$d456' AND reference_user = '$q461' AND numbers = '$a455'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388[$r529];}if(isset($g389)){return $g389;}}function c95($s457,$d456,$w500,$q461,$r529,$j562,$a455){$g381=t0();$h382="SELECT * FROM ct_limitations WHERE type = '$j562' AND options = '$s457' AND game = '$d456' AND master_user = '$w500' AND reference_user = '$q461' AND numbers = '$a455'";$b383=$g381->k384($h382);$b383->u385();if($r529!=''){$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388[$r529];}if(isset($g389)){return $g389;}}else{$f448=$b383->y449();$b383->u450();return $f448;}}function l96($s457){if($s457=='ALL'){$e563='Tous';}else{$e563=$s457;}if(isset($e563)){return $e563;}}function u97($o494){if($o494=='0'){$e563='Tous les utilisateurs';}else{$i564=z154('ct_users','id',$o494,'username').' (<b>'.z154('ct_users','id',$o494,'enterprise').'</b>)';$e563=$i564;}if(isset($e563)){return $e563;}}function y98($s457){if($s457=='DIRECTO'){$e563='Borlette';}elseif($s457=='PALE'){$e563='Mariage';}elseif($s457=='PALE_GR'){$e563='Mariage Gratis';}elseif($s457=='CASH 3'){$e563='Loto 3';}elseif($s457=='PICK 3 BOX'){$e563='PICK 3 BOX';}elseif($s457=='PLAY 4'){$e563='Loto 4';}elseif($s457=='PICK 5'){$e563='Loto 5';}elseif($s457=='PICK 2'){$e563='PICK 2';}if(isset($e563)){return $e563;}}function s99($s457){if($s457=='_directo'){$e563='Borlette';}elseif($s457=='_pale'){$e563='Mariage';}elseif($s457=='_cash3'){$e563='Loto 3';}elseif($s457=='_pick3box'){$e563='PICK 3 BOX';}elseif($s457=='_play4'){$e563='Loto 4';}elseif($s457=='_pick5'){$e563='Loto 5';}elseif($s457=='_pick2'){$e563='PICK 2';}elseif($s457=='0'){$e563='Personnalise';}if(isset($e563)){return $e563;}}function w100($h508){if($h508=='firstlot'){$e563='Borlette 1er Lot';}elseif($h508=='secondlot'){$e563='Borlette 2me Lot';}elseif($h508=='thirdlot'){$e563='Borlette 3me Lot';}elseif($h508=='mariage'){$e563='Mariage';}elseif($h508=='cash3'){$e563='Loto 3';}elseif($h508=='pick2'){$e563='Pick 2 Florida';}elseif($h508=='pick3'){$e563='Pick 3 Box';}elseif($h508=='loto4_1'){$e563='Loto 4 - Option 1';}elseif($h508=='loto4_2'){$e563='Loto 4 - Option 2';}elseif($h508=='loto4_3'){$e563='Loto 4 - Option 3';}elseif($h508=='loto5_1'){$e563='Loto 5 - Option 1';}elseif($h508=='loto5_2'){$e563='Loto 5 - Option 2';}elseif($h508=='loto5_3'){$e563='Loto 5 - Option 3';}elseif($h508=='mariage_gratis'){$e563='Prix Mariage gratis';}elseif($h508=='mariage_gratis_amount'){$e563='Montant Cond. Mariage Gratis';}elseif($h508=='mariage_gratis_quantite'){$e563='Quantit Mariage Gratis';}if(isset($e563)){return $e563;}}function b101($s457,$d456,$t465,$r529,$j562,$a455){$g381=t0();$h382="SELECT * FROM ct_limitations WHERE type = '$j562' AND options = '$s457' AND game = '$d456' $t465 AND numbers = '$a455' AND reference_user = '0'";$b383=$g381->k384($h382);$b383->u385();if($r529!=''){$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388[$r529];}if(isset($g389)){return $g389;}}else{$f448=$b383->y449();$b383->u450();return $f448;}}function z102($g377,$s457,$d456,$q461,$j562,$a455){$g381=t0();$h382="SELECT * FROM ct_limitations WHERE type = '$j562' AND options = '$s457' AND game = '$d456' AND master_user = '$g377' AND reference_user = '$q461' AND numbers = '$a455'";$b383=$g381->k384($h382);$b383->u385();$f448=$b383->y449();$b383->u450();return $f448;}function l103(){$s565=rand(100000,999999);return $s565;}function a104($f460,$o412,$j411,$u566,$j567,$u568,$u569,$f404,$o570,$l415,$m571,$h433){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_cv_infos (id_user,lastname,firstname,location,country,city,sex,about,date_time,views,phone,category) VALUES (? ,? ,?, ? ,? ,? ,? ,? ,? ,? ,? ,?)');$b383->b408(1,$f460);$b383->b408(2,$o412);$b383->b408(3,$j411);$b383->b408(4,$u566);$b383->b408(5,$j567);$b383->b408(6,$u568);$b383->b408(7,$u569);$b383->b408(8,$f404);$b383->b408(9,$h433);$b383->b408(10,$o570);$b383->b408(11,$l415);$b383->b408(12,$m571);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function x105($f460,$z572,$f573,$m574,$t575,$a576,$i462,$h433){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_cv_education (id_user,degree,qualification,education_start_date,education_end_date,institute,description,date_time) VALUES (? ,? ,?, ? ,? ,? ,? ,?)');$b383->b408(1,$f460);$b383->b408(2,$z572);$b383->b408(3,$f573);$b383->b408(4,$m574);$b383->b408(5,$t575);$b383->b408(6,$a576);$b383->b408(7,$i462);$b383->b408(8,$h433);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function v106($f460,$u577,$d578,$w579,$a576,$i462,$f580){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_cv_workexperience (id_user,job_post,job_start_date,job_end_date,institute,description,date_time) VALUES (? ,? ,?, ? ,? ,? ,?)');$b383->b408(1,$f460);$b383->b408(2,$u577);$b383->b408(3,$d578);$b383->b408(4,$w579);$b383->b408(5,$a576);$b383->b408(6,$i462);$b383->b408(7,$f580);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function y107($x429,$f460,$u581,$h433){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_job_candidates (id_job,id_user,compatibility,date_time) VALUES (? ,? ,?, ?)');$b383->b408(1,$x429);$b383->b408(2,$f460);$b383->b408(3,$u581);$b383->b408(4,$h433);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function z108($f460,$v582,$z438,$i462,$f580){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_cv_skills (id_user,skills,value,description,date_time) VALUES (? ,? ,?, ? ,?)');$b383->b408(1,$f460);$b383->b408(2,$v582);$b383->b408(3,$z438);$b383->b408(4,$i462);$b383->b408(5,$f580);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function b109($y583,$r584,$h509,$a585,$f586){$g377=z154('ct_immersion','id','1','id');if($g377!=''){$l372=t0();$b383=$l372->k384('UPDATE ct_immersion SET adventure = ?, duration = ?, price = ?, time_limit = ?, reservation_button_link = ? WHERE id = ?');$b383->b408(1,$y583);$b383->b408(2,$r584);$b383->b408(3,$h509);$b383->b408(4,$a585);$b383->b408(5,$f586);$b383->b408(6,$g377);if($b383->u385()){return 1;}else{return 0;}}else{try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_immersion (adventure,duration,price,time_limit,reservation_button_link) VALUES (? ,?, ? ,? ,?)');$b383->b408(1,$y583);$b383->b408(2,$r584);$b383->b408(3,$h509);$b383->b408(4,$a585);$b383->b408(5,$f586);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}}function f110($n587,$w588,$i589,$j590,$f580,$f591,$x592){try{$l372=t0();$b383=$l372->k384('UPDATE ct_blog SET title = ?, descs = ?, texts = ?, date_modif = ?, photos = ?, author_id = ? WHERE pid = ?');$b383->b408(1,$n587);$b383->b408(2,$i589);$b383->b408(3,$j590);$b383->b408(4,$f580);$b383->b408(5,$w588);$b383->b408(6,$f591);$b383->b408(7,$x592);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function r111($j411,$o412,$m402,$l415,$m519,$f520,$q521,$g522,$g377,$b524,$p523,$h526,$b527,$j528){try{$l372=t0();$b383=$l372->k384('UPDATE ct_users SET firstname = ?, lastname = ?, email = ?, phone = ?, state = ?, address = ? , percentage = ? , username = ? , enterprise = ? , logo = ? , prepaye = ? , mariage_gratis = ?, details = ? WHERE id = ?');$b383->b408(1,$j411);$b383->b408(2,$o412);$b383->b408(3,$m402);$b383->b408(4,$l415);$b383->b408(5,$m519);$b383->b408(6,$f520);$b383->b408(7,$q521);$b383->b408(8,$g522);$b383->b408(9,$p523);$b383->b408(10,$b524);$b383->b408(11,$h526);$b383->b408(12,$b527);$b383->b408(13,$j528);$b383->b408(14,$g377);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function o112($b593,$g594,$h595,$z596,$n597,$r598,$f599,$f591,$o570,$d600,$e601,$b602){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_event (title,descs,date_event,start_hour,end_hour,location,photos,author_id,views,url_id,attendance,reservation_link) VALUES (?, ? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,?)');$b383->b408(1,$b593);$b383->b408(2,$f599);$b383->b408(3,$g594);$b383->b408(4,$h595);$b383->b408(5,$z596);$b383->b408(6,$n597);$b383->b408(7,$r598);$b383->b408(8,$f591);$b383->b408(9,$o570);$b383->b408(10,$d600);$b383->b408(11,$e601);$b383->b408(12,$b602);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function n113($b593,$f599,$g594,$h595,$z596,$n597,$r598,$e601,$b602,$g377){try{$l372=t0();$b383=$l372->k384('UPDATE ct_event SET title = ?, descs = ?, date_event = ?, start_hour = ?, end_hour = ?, location = ?, photos = ?, attendance = ?, reservation_link = ? WHERE id = ?');$b383->b408(1,$b593);$b383->b408(2,$f599);$b383->b408(3,$g594);$b383->b408(4,$h595);$b383->b408(5,$z596);$b383->b408(6,$n597);$b383->b408(7,$r598);$b383->b408(8,$e601);$b383->b408(9,$b602);$b383->b408(10,$g377);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function t114($f460,$m603,$e604,$s605,$u566,$g606,$x525,$u569,$j567,$u568,$p607,$p608,$n609,$k610,$i462,$q611,$y612,$h433,$z400,$k613){try{$l372=t0();$b383=$l372->k384('INSERT INTO `ct_job`(`id_user`, `title`, `type`, `category`, `location`, `salary`, `currency`, `gender`, `country`, `city`, `niveau`, `view`, `qualification_exigence`, `experience`, `description`, `date_limit`, `link`, `date_time`, `status`, `applied`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)');$b383->b408(1,$f460);$b383->b408(2,$m603);$b383->b408(3,$e604);$b383->b408(4,$s605);$b383->b408(5,$u566);$b383->b408(6,$g606);$b383->b408(7,$x525);$b383->b408(8,$u569);$b383->b408(9,$j567);$b383->b408(10,$u568);$b383->b408(11,$p607);$b383->b408(12,$p608);$b383->b408(13,$n609);$b383->b408(14,$k610);$b383->b408(15,$i462);$b383->b408(16,$q611);$b383->b408(17,$y612);$b383->b408(18,$h433);$b383->b408(19,$z400);$b383->b408(20,$k613);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function m115($n587,$w588,$i589,$j590,$f580,$f591,$o570,$d600){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_blog (title,descs,texts,date_time,photos,author_id,views,url_id) VALUES (? ,?, ? ,? ,? ,?,? ,?)');$b383->b408(1,$n587);$b383->b408(2,$i589);$b383->b408(3,$j590);$b383->b408(4,$f580);$b383->b408(5,$w588);$b383->b408(6,$f591);$b383->b408(7,$o570);$b383->b408(8,$d600);if($b383->u385()===true){return $l372->v409('pid');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function j116($h614,$s457,$h433){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_payment (id_transaction,type,date_time) VALUES (? ,?, ?)');$b383->b408(1,$h614);$b383->b408(2,$s457);$b383->b408(3,$h433);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function b117($m615,$i541='6'){$g377=$_SESSION['id'];$g381=t0();$h382="SELECT * FROM ct_users WHERE level ='2' OR level ='3' AND (firstname LIKE '$m615%' or lastname LIKE '$m615%' or email LIKE '$m615%') LIMIT ".$i541."";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function n118($m615,$s616=false,$l617='search result',$t618='search results'){$g381=t0();$g377=$_SESSION['id'];$h382="SELECT COUNT(*) AS count FROM ct_users WHERE firstname LIKE '$m615%' or lastname LIKE '$m615%' or email LIKE '$m615%'";$b383=$g381->k384($h382);$b383->u385();$f448=$b383->n619();$f448=$f448['count'];if($s616){if($f448==0){$f448=$f448.' '.$l617;}elseif($f448==1){$f448=$f448.' '.$l617;}else{$f448=$f448.' '.$t618;}}return $f448;}function g119($i564,$l405,$f404,$s457,$g620){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_team (name,role,about,type,photos) VALUES (? ,?, ? ,? ,?)');$b383->b408(1,$i564);$b383->b408(2,$l405);$b383->b408(3,$f404);$b383->b408(4,$s457);$b383->b408(5,$g620);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function k120($e621,$o622,$g377){try{$l372=t0();$b383=$l372->k384('UPDATE ct_options SET site_name = ?, site_logo = ?, site_favicon = ? WHERE id = ?');$b383->b408(1,$e621);$b383->b408(2,$o622);$b383->b408(3,$o622);$b383->b408(4,$g377);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function k121($w623,$q459,$l466,$z496,$x525,$s457,$h433){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_transaction (payment_id,reference_id,serial_number,amount,currency,type,date_time) VALUES (? ,?, ? ,? ,? ,? ,?)');$b383->b408(1,$w623);$b383->b408(2,$q459);$b383->b408(3,$l466);$b383->b408(4,$z496);$b383->b408(5,$x525);$b383->b408(6,$s457);$b383->b408(7,$h433);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function n122($h614,$s457,$z496,$h433,$z400,$b624,$f460,$x429){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_payment (id_transaction,type,amount,date_time,status,note, id_user, id_job) VALUES (? ,?, ? ,? ,? ,? ,?,?)');$b383->b408(1,$h614);$b383->b408(2,$s457);$b383->b408(3,$z496);$b383->b408(4,$h433);$b383->b408(5,$z400);$b383->b408(6,$b624);$b383->b408(7,$f460);$b383->b408(8,$x429);if($b383->u385()===true){return $l372->v409('id_transaction');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function o123($i401,$l405,$y625,$x424){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_testimonial (fullname,role,texts,image) VALUES (? ,?, ? ,?)');$b383->b408(1,$i401);$b383->b408(2,$l405);$b383->b408(3,$y625);$b383->b408(4,$x424);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function x124($i564,$l405,$m626){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_community (enterprise,role,logo) VALUES (? ,?, ?)');$b383->b408(1,$i564);$b383->b408(2,$l405);$b383->b408(3,$m626);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function d125($i627,$i564,$l405,$f404,$s457,$g620){try{$l372=t0();$b383=$l372->k384('UPDATE ct_team SET name = ?, role = ?, about = ?, type = ?, photos = ? WHERE id = ?');$b383->b408(1,$i564);$b383->b408(2,$l405);$b383->b408(3,$f404);$b383->b408(4,$s457);$b383->b408(5,$g620);$b383->b408(6,$i627);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function r126($i627,$i401,$l405,$y625,$x424){try{$l372=t0();$b383=$l372->k384('UPDATE ct_testimonial SET fullname = ?, role = ?, texts = ?, image = ? WHERE id = ?');$b383->b408(1,$i401);$b383->b408(2,$l405);$b383->b408(3,$y625);$b383->b408(4,$x424);$b383->b408(5,$i627);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function a127($i627,$s628,$f629,$m626){try{$l372=t0();$b383=$l372->k384('UPDATE ct_community SET enterprise = ?, role = ?, logo = ? WHERE id = ?');$b383->b408(1,$s628);$b383->b408(2,$f629);$b383->b408(3,$m626);$b383->b408(4,$i627);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function y128($g377){$l372=t0();$h382='DELETE FROM ct_limitations WHERE id= :id';$b383=$l372->k384($h382);if($b383->u385(array(':id'=>$g377))===true){return 1;}else{return 0;}}function f129($g377){$l372=t0();$h382='DELETE FROM ct_limitations_transactions WHERE id= :id';$b383=$l372->k384($h382);if($b383->u385(array(':id'=>$g377))===true){return 1;}else{return 0;}}function t130($g377){$l372=t0();$h382='DELETE FROM ct_product_price WHERE id= :id';$b383=$l372->k384($h382);if($b383->u385(array(':id'=>$g377))===true){return 1;}else{return 0;}}function x131($u431){$l372=t0();$h382='DELETE FROM ct_sortition WHERE lot= :lot';$b383=$l372->k384($h382);if($b383->u385(array(':lot'=>$u431))===true){return 1;}else{return 0;}}function t132($i627){$l372=t0();$h382='DELETE FROM ct_testimonial WHERE id= :id';$b383=$l372->k384($h382);$b383->u385(array(':id'=>$i627));}function w133($i627){$l372=t0();$h382='DELETE FROM ct_team WHERE id= :id';$b383=$l372->k384($h382);$b383->u385(array(':id'=>$i627));}function y134($x592){$l372=t0();$h382='DELETE FROM ct_blog WHERE pid= :pid';$b383=$l372->k384($h382);$b383->u385(array(':pid'=>$x592));}function j135($x592){$l372=t0();$h382='DELETE FROM ct_event WHERE id= :pid';$b383=$l372->k384($h382);$b383->u385(array(':pid'=>$x592));}function s136($i627){$l372=t0();$h382='DELETE FROM ct_community WHERE id= :id';$b383=$l372->k384($h382);$b383->u385(array(':id'=>$i627));}function c137($i564,$z438,$s630){$b631=z154('ct_page_element','name',$i564,'name');if($i564==$b631){$l372=t0();$b383=$l372->k384("UPDATE `ct_page_element` SET `value`= '$z438' WHERE name= '$i564'");if($b383->u385()){return 1;}else{return 0;}}else{try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_page_element (name, value, page) VALUES (? ,? ,?)');$b383->b408(1,$i564);$b383->b408(2,$z438);$b383->b408(3,$s630);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}}function d138($l617){$s632=" ";$p633=strstr(strtolower($l617),$s632,true);$s634=substr(strstr(strtolower($l617),$s632,false),0,3);$d635=rand(0,100);$g522=trim($p633).trim($s634).trim($d635);return $g522;}function a139($i564,$y612){$b631=z154('ct_medias','name',$i564,'name');if($i564==$b631){$l372=t0();$b383=$l372->k384("UPDATE `ct_medias` SET `link`= '$y612' WHERE name= '$i564'");if($b383->u385()){return 1;}else{return 0;}}else{try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_medias (name, link) VALUES (? ,?)');$b383->b408(1,$i564);$b383->b408(2,$y612);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}}function p140($i564,$z438){$b631=z154('ct_informations','name',$i564,'name');if($i564==$b631){$l372=t0();$b383=$l372->k384("UPDATE `ct_informations` SET `value`= '$z438' WHERE name= '$i564'");if($b383->u385()){return 1;}else{return 0;}}else{try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_informations (name, value) VALUES (? ,?)');$b383->b408(1,$i564);$b383->b408(2,$z438);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}}function c141($x437){$g381=t0();$h382="SELECT * FROM ct_page_element WHERE page ='$x437'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function h142($g377){$l372=t0();$h382='UPDATE users SET active = :num WHERE id = :id';$b383=$l372->k384($h382);$b383->u385(array(':num'=>1,':id'=>$g377));}function v143(){if(isset($_SERVER['HTTPS'])){$k636=($_SERVER['HTTPS']&&$_SERVER['HTTPS']!='off')?'https':'http';}else{$k636='http';}return $k636.'://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'];}function s144($z637,$k638=false){if($k638){header('HTTP/1.1 301 Moved Permanently');}header('Location: '.$z637);exit();}function d145($z438){$x437=''.number_format($z438,2);return $x437;}function x146($z438){$x437=''.number_format($z438,0);return $x437;}function r147($z438){$x437=number_format($z438,2,'.','');return $x437;}function s148($z438){$x437=number_format($z438,2,'.',' ');return $x437;}function z149($z438){return number_format($z438,2);}function k150(){if($_SERVER['SERVER_NAME']=='localhost'){$z637=v143();$t639=explode('/',$z637);$z637=$t639[0].'/'.$t639[1].'/'.$t639[2].'/'.$t639[3].'';}else{$z637=v143();$t639=explode('/',$z637);$z637=$t639[0].'/'.$t639[1].'/'.$t639[2].'';}return $z637;}function f151($l640){$g381=t0();$h382="SELECT * FROM ct_job_lang WHERE id_job ='$l640'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function u152($f460){$g381=t0();$h382="SELECT * FROM ct_cv_lang WHERE id_user ='$f460'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function l153($l641){$g377=$_SESSION['id'];$g381=t0();$h382="SELECT * FROM ct_users WHERE id ='$g377'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();if($l641=='fullname'){foreach($c386 as $o388){$g389=$o388['firstname'].' '.$o388['lastname'];}}else{foreach($c386 as $o388){$g389=$o388[$l641];}}if(isset($g389)){return $g389;}}function z154($g642,$e380,$v643,$w644,$o388='show'){$g381=t0();$h382="SELECT * FROM $g642 WHERE $e380 ='$v643'";$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();if($w644=='fullname'){foreach($c386 as $o388){$g389=$o388['firstname'].' '.$o388['lastname'];}}else{foreach($c386 as $o388){$g389=$o388[$w644];}}if(isset($g389)){return $g389;}}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function o155(){$g381=t0();$h382='SELECT * FROM ct_options';$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function j156($s630,$k421){$y645='';$h646='';$z647='';$n648='';$o649='';$j650='';if($s630=='accueil'){$y645='active';}elseif($s630=='demandes'){$h646='active';}elseif($s630=='resultats'){$z647='active';}elseif($s630=='compte'){$n648='active';}elseif($s630=='utilisateurs'){$o649='active';}elseif($s630=='paiements'){$j650='active';}if($k421=='active0'){return $y645;}elseif($k421=='active1'){return $h646;}elseif($k421=='active2'){return $z647;}elseif($k421=='active3'){return $n648;}elseif($k421=='active4'){return $o649;}elseif($k421=='active5'){return $j650;}}function u157($l651){$l651+=3;$m652="0123456789";$s653="";$z654=strlen($m652);for($b655=0;$b655<$l651;$b655++){if($b655==5||$b655==11||$b655==17)$s653.='';else $s653 .= $m652[rand(0,$z654-1)];}return $s653;}function s158($i564=''){$v656=uniqid(rand(),true);$_SESSION[$i564.'_token']=$v656;return $v656;}function p159($v657,$i564=''){if(isset($_SESSION[$i564.'_token'])&&isset($_POST['token'])){if($_SESSION[$i564.'_token']==$_POST['token']){if(isset($_SERVER['HTTP_REFERER'])){if($_SERVER['HTTP_REFERER']==$v657){return true;}}}}return false;}function b160($i564=''){$z395=g2('site_url');$w658=mb_strlen($z395);if(isset($_SESSION[$i564.'_token'])&&isset($_POST['token'])){if($_SESSION[$i564.'_token']==$_POST['token']){if(isset($_SERVER['HTTP_REFERER'])){$p659=o315($_SERVER['HTTP_REFERER'],$m652=$w658,$r660=false,$b661='');if($p659==$z395){return true;}}}}return false;}function p161($v662,$b663,$i564=''){if(isset($_SESSION[$i564.'_token'])&&isset($_POST['token'])){if($_SESSION[$i564.'_token']==$_POST['token']){if(isset($_SERVER['HTTP_REFERER'])){if($_SERVER['HTTP_REFERER']==$v662||$_SERVER['HTTP_REFERER']==$b663){return true;}}}}return false;}function b162($v662,$b663,$o664,$i564=''){if(isset($_SESSION[$i564.'_token'])&&isset($_POST['token'])){if($_SESSION[$i564.'_token']==$_POST['token']){if(isset($_SERVER['HTTP_REFERER'])){if($_SERVER['HTTP_REFERER']==$v662||$_SERVER['HTTP_REFERER']==$b663||$_SERVER['HTTP_REFERER']==$o664){return true;}}}}return false;}function j163($i564=''){if(isset($_SESSION[$i564.'_token'])&&isset($_GET['c'])){if($_SESSION[$i564.'_token']==$_GET['c']){return true;}}return false;}function z164($r435){return preg_match("/^\d+(?:\.\d{2})?$/",$r435);}function l165($j665){$i666='H:i:s';$b434=new
667();$b434->a668($j665);return $b434->p669($i666);}function o166($t670,$f671,$m402){$i390=g2('site_name');$x440=m1();$h433=date("d-m-Y");$p523=trim(z154('ct_users','id',m1(),'enterprise'));$t670=$t670;$v656="-";$r672=new v673();$r672->$m674='[email protected]';$r672->$j675=$i390;$r672->$l676=$i390.' - Listes des Ventes '.$f671.' '.$h433;ob_start();include "../PHPMail/sales-list.php";$d677=ob_get_clean();$r672->u678($d677);$r672->$l679=$p523.', Rapport liste des ventes '.$h433;$r672->n680($m402,$p523);$r672->$u681='UTF-8';$r672->a682();}function i167($j411,$f683,$t670,$m402){$i390='';$y612='';$v656=sha1($j411.$m402);$r672=new v673();$r672->$m674='[email protected]';$r672->$j675=$i390;$r672->$l676=$i390.' - Code OTP changement d\'heure '.$t670;$s684='Code OPT pour changement d\'heure '.$t670.': '.$f683;$r672->u678($s684);$r672->$l679=$j411.' - Code OTP changement d\'heure '.$t670;$r672->n680($m402,$j411);$r672->$u681='UTF-8';$r672->a682();}function h168($i390,$z395,$h393,$j685,$j686,$a687,$o688){$g377=$_SESSION['aid'];$l372=t0();$b383=$l372->k384('UPDATE general_settings SET site_name = ?, site_url = ?, site_desc = ?, site_desc2 = ?, privacy = ?, email_noreply = ?, email_contact = ?');$b383->b408(1,$i390);$b383->b408(2,$z395);$b383->b408(3,$h393);$b383->b408(4,$j685);$b383->b408(5,$j686);$b383->b408(6,$a687);$b383->b408(7,$o688);if($b383->u385()===true){return 1;}else{return 0;}}function s169($u689,$n690,$g691,$s692,$q693,$j694,$l695,$i696,$k697,$c698,$f699,$t700,$h701,$b702,$f703,$i704){$g377=$_SESSION['aid'];$l372=t0();$b383=$l372->k384('UPDATE general_settings SET ads_1 = ?, ads_2 = ?, ads_3 = ?, ads_4 = ?, ads_link_1 = ?, ads_link_2 = ?, ads_link_3 = ?, ads_link_4 = ?, ads_text_1 = ?, ads_text_2 = ?, ads_text_3 = ?, ads_text_4 = ?, ads_img_1 = ?, ads_img_2 = ?, ads_img_3 = ?, ads_img_4 = ?');$b383->b408(1,$u689);$b383->b408(2,$n690);$b383->b408(3,$g691);$b383->b408(4,$s692);$b383->b408(5,$q693);$b383->b408(6,$j694);$b383->b408(7,$l695);$b383->b408(8,$i696);$b383->b408(9,$k697);$b383->b408(10,$c698);$b383->b408(11,$f699);$b383->b408(12,$t700);$b383->b408(13,$h701);$b383->b408(14,$b702);$b383->b408(15,$f703);$b383->b408(16,$i704);if($b383->u385()===true){return 1;}else{return 0;}}function z170($g377){$l372=t0();$b383=$l372->k384("UPDATE ct_event SET views = views+1 WHERE (id = ?)");$b383->b408(1,$g377);if($b383->u385()===true){return 1;}else{return 0;}}function i171($g377){$l372=t0();$b383=$l372->k384("UPDATE ct_job SET views = views+1 WHERE (id = ?)");$b383->b408(1,$g377);if($b383->u385()===true){return 1;}else{return 0;}}function i172($f460){$l372=t0();$b383=$l372->k384("UPDATE ct_cv_infos SET views = views+1 WHERE (id_user = ?)");$b383->b408(1,$f460);if($b383->u385()===true){return 1;}else{return 0;}}function o173($z637){$z637=str_replace('==','',$z637);return $z637;}function e174($x429){$l372=t0();$b383=$l372->k384("UPDATE ct_job SET applied = applied+1 WHERE (id = ?)");$b383->b408(1,$x429);if($b383->u385()===true){return 1;}else{return 0;}}function c175($x592){$l372=t0();$b383=$l372->k384("UPDATE ct_blog SET views = views+1 WHERE (date_time = ?)");$b383->b408(1,$x592);if($b383->u385()===true){return 1;}else{return 0;}}function d176($j665){$t705=$j665;$p706=time();$x707=$p706-$t705;$s708=$x707;$c709=round($s708/60);$g710=round($s708/3600);$o711=round($s708/86400);$m712=round($s708/604800);$v713=round($s708/2629440);$n714=round($s708/31553280);return utf8_encode(u179($j665)).', '.$g710.'hrs '.$c709.'min '.$s708.'sec';}function o177($j665){if(setlocale(LC_TIME,'fr_FR')==''){setlocale(LC_TIME,'FR');$h715='%#d';}else{$h715='%e';}$g716=strftime("%B",$j665);return $g716;}function v178($j665){if(setlocale(LC_TIME,'fr_FR')==''){setlocale(LC_TIME,'FR');$h715='%#d';}else{$h715='%e';}$g716=strftime("$h715",$j665);return $g716;}function u179($j665){if(setlocale(LC_TIME,'fr_FR')==''){setlocale(LC_TIME,'FR');$h715='%#d';}else{$h715='%e';}$g716=ucfirst(strftime("%A $h715 %B %Y",$j665));$k717=strftime("%a $h715 %b %Y %H heures %M minutes.",$j665);return $g716;}function c180($j665){if(setlocale(LC_TIME,'fr_FR')==''){setlocale(LC_TIME,'FR');$h715='%#d';}else{$h715='%e';}$g716=ucfirst(strftime("%A $h715 %B %Y",$j665));$k717=ucfirst(strftime("%a $h715 %b %Y %H heures %M minutes.",$j665));$p718=ucfirst(strftime("%a $h715 %b %Y - %H:%M:%S",$j665));return utf8_encode($p718);}function j181($g620){$g620=trim($g620);if($g620!=""&&$g620!="0"){$g620='<img src="../'.$g620.'" class="img-thumbnail" />';}else{$g620="";}return $g620;}function o182($g620,$z395){$g620=trim($g620);if($g620!=""&&$g620!="0"){$g620='<img src="'.$z395.$g620.'" class="img-thumbnail" />';}else{$g620="";}return $g620;}function s183($g620){if($g620!=''&&$g620!=0){$g620="../".$g620;$g620='<img src="'.$g620.'" class="img-thumbnail"/>';}else{$g620='';}return $g620;}function h184($t403){$v493='';if($t403=='0'){$v493="Non vrifi";}elseif($t403=='1'){$v493="Vrifi";}return $v493;}function k185($r435){$v493='';if($r435=='1'){$v493="Active";}elseif($r435=='0'){$v493="Inactive";}return $v493;}function d186($t403){if($t403=='1'){$v493="<b>Editeur</b> (Peut seulement publier des articles et des vnements.)";}elseif($t403=='2'){$v493="<b>Administrateur<b/> (Accs total a l'administration du site.)";}elseif($t403=='3'){$v493="<b>Administrateur Gnral</b> (Accs total a l'administration du site. Peut modifier des pages, ajouter, supprimer d'autres site)";}return $v493;}function e187($g642,$o388,$r529,$v719,$a720){$l372=t0();$b383=$l372->k384("UPDATE $g642 SET $o388 = ? WHERE ($v719 = ?)");$b383->b408(1,$r529);$b383->b408(2,$a720);if($b383->u385()===true){return 1;}else{return 0;}}function x188($g642,$o388,$r529,$v719,$f721,$a720,$p722){$l372=t0();$b383=$l372->k384("UPDATE $g642 SET $o388 = ? WHERE $v719 = ? AND $f721 = ?");$b383->b408(1,$r529);$b383->b408(2,$a720);$b383->b408(3,$p722);if($b383->u385()===true){return 1;}else{return 0;}}function w189($g642,$o388,$r529,$v719,$f721,$e723,$a720,$p722,$e724){$l372=t0();$b383=$l372->k384("UPDATE $g642 SET $o388 = ? WHERE $v719 = ? AND $f721 = ? AND $e723 = ?");$b383->b408(1,$r529);$b383->b408(2,$a720);$b383->b408(3,$p722);$b383->b408(4,$e724);if($b383->u385()===true){return 1;}else{return 0;}}function m190($g642,$o388,$r529,$v719,$f721,$e723,$d725,$a720,$p722,$e724,$e726){$l372=t0();$b383=$l372->k384("UPDATE $g642 SET $o388 = ? WHERE $v719 = ? AND $f721 = ? AND $e723 = ? AND $d725 = ?");$b383->b408(1,$r529);$b383->b408(2,$a720);$b383->b408(3,$p722);$b383->b408(4,$e724);$b383->b408(5,$e726);if($b383->u385()===true){return 1;}else{return 0;}}function g191($g642,$o388,$r529,$v719,$f721,$e723,$d725,$k727,$t728,$a720,$p722,$e724,$e726,$l729,$p730){$l372=t0();$b383=$l372->k384("UPDATE $g642 SET $o388 = ? WHERE $v719 = ? AND $f721 = ? AND $e723 = ? AND $d725 = ? AND $k727 = ? AND $t728 = ?");$b383->b408(1,$r529);$b383->b408(2,$a720);$b383->b408(3,$p722);$b383->b408(4,$e724);$b383->b408(5,$e726);$b383->b408(6,$l729);$b383->b408(7,$p730);if($b383->u385()===true){return 1;}else{return 0;}}function c192($g642,$o388,$r529){$l372=t0();$b383=$l372->k384("UPDATE $g642 SET $o388 = ?");$b383->b408(1,$r529);if($b383->u385()===true){return 1;}else{return 0;}}function s193($b434){$j665=strtotime($b434);$f731=array('second','minute','hour','day','month','year');$l651=array('60','60','24','30','12','10');$e732=time();if($e732>=$j665){$h733=time()-$j665;for($b655=0;$h733>=$l651[$b655]&&$b655<count($l651)-1;++$b655){$h733=$h733/$l651[$b655];}$h733=round($h733);return $h733.' '.$f731[$b655].'(s) ago ';}}function w194($o734){$z735=time()-$o734;if($z735<1){return 'less than 1 second ago';}$f736=array(12*30*24*60*60=>'year',30*24*60*60=>'month',24*60*60=>'day',60*60=>'hour',60=>'minute',1=>'second',);foreach($f736 as $a737=>$s653){$c738=$z735/$a737;if($c738>=1){$k717=round($c738);return 'about '.$k717.' '.$s653.($k717>1?'s':'').' ago';}}}function m195($j665){$i666='d-m-Y';$b434=new
667();$b434->a668($j665);return $b434->p669($i666);}function o196($j665){$i666='d-m-Y';$b434=new
667();$b434->a668($j665);return $b434->p669($i666);}function p197($j665){$i666='d-m-Y H:i:s';$b434=new
667();$b434->a668($j665);return $b434->p669($i666);}function x198($j665){if($j665>0){$i666='H:i:s';$b434=new
667();$b434->a668($j665);return $b434->p669($i666);}else{return '-';}}function r199($j739,$z438,$g642){if(trim($z438!='')){$g381=t0();$h382="SELECT * FROM $g642 WHERE $j739='$z438'";$b383=$g381->k384($h382);$b383->u385();$f448=$b383->y449();$b383->u450();return $f448;}else{return 0;}}function j200($j739,$z438,$g642){$g381=t0();$h382="SELECT * FROM $g642 WHERE $j739='$z438'";$b383=$g381->k384($h382);$b383->u385();$f448=$b383->y449();$b383->u450();return $f448;}function l201($j739,$z438,$g642,$l740){$g381=t0();$h382="SELECT * FROM $g642 WHERE $j739='$z438' AND id != $l740";$b383=$g381->k384($h382);$b383->u385();$f448=$b383->y449();$b383->u450();if($z438!=''){return $f448;}else{return 0;}}function k202($g377){$g381=t0();$h382="SELECT * FROM ct_team WHERE id = '$g377'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function h203(){$g381=t0();$h382="SELECT * FROM ct_immersion";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function j204($x437){$g381=t0();$h382="SELECT * FROM ct_photos WHERE album = '$x437' ORDER by date_time DESC";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function y205(){$g381=t0();$h382="SELECT * FROM ct_team";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function p206($i541){$g381=t0();$h382="SELECT * FROM ct_event order by id DESC LIMIT $i541";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function r207($g620){if($g620!='0'){$x424=$g620;}else{$x424='assets/images/blog-default.png';}return $x424;}function n208(){$g381=t0();$h382="SELECT * FROM ct_blog order by pid DESC LIMIT 4";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function z209(){$g381=t0();$h382="SELECT * FROM ct_blog WHERE type != 'page' order by pid DESC LIMIT 6";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function s210($x592){$g381=t0();$h382="SELECT * FROM ct_blog WHERE pid != '$x592' order by pid DESC LIMIT 6";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function s211($g377){$g381=t0();$h382="SELECT * FROM ct_event WHERE id != '$g377' order by id DESC LIMIT 6";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function k212($g377){$g381=t0();$h382="SELECT * FROM ct_file WHERE infos = '$g377'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function l213($x592){$g381=t0();$h382="SELECT * FROM ct_blog WHERE date_time = '$x592'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function k214($g377){$g381=t0();$h382="SELECT * FROM ct_event WHERE id = '$g377'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function z215($g377){$g381=t0();$h382="SELECT * FROM ct_job WHERE id = '$g377'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function c216(){$f460=m1();$g381=t0();$h382="SELECT * FROM ct_cv_infos WHERE id_user = '$f460'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function y217(){$f460=m1();$g381=t0();$h382="SELECT * FROM ct_cv_education WHERE id_user = '$f460'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function b218(){$f460=m1();$g381=t0();$h382="SELECT * FROM ct_cv_workexperience WHERE id_user = '$f460'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function u219(){$f460=m1();$g381=t0();$h382="SELECT * FROM ct_cv_skills WHERE id_user = '$f460'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function h220($f460){$g381=t0();$h382="SELECT * FROM ct_cv_infos WHERE id_user = '$f460'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function u221($f460){$g381=t0();$h382="SELECT * FROM ct_cv_education WHERE id_user = '$f460'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function n222($f460){$g381=t0();$h382="SELECT * FROM ct_cv_workexperience WHERE id_user = '$f460'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function i223($f460){$g381=t0();$h382="SELECT * FROM ct_cv_skills WHERE id_user = '$f460'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function k224($b434){$b434=DateTime::v741("Y-m-d",$b434);$b434=$b434->p669("Y");return $b434;}function n225($x592){$g381=t0();$h382="SELECT * FROM ct_blog WHERE pid < '$x592' order by pid DESC LIMIT 6";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function q226($x592){$g381=t0();$h382="SELECT * FROM ct_blog WHERE pid > '$x592' order by pid ASC LIMIT 6";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function d227($g377){$g381=t0();$h382="SELECT * FROM ct_event WHERE id < '$g377' order by id DESC LIMIT 6";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function f228($n742,$s743,$g744,$w745,$d746=80){list($w747,$h748,$s457)=getimagesize($n742);if($s457==1){header('Content-Type: image/gif');$x424=imagecreatefromgif($n742);}elseif($s457==2){header('Content-Type: image/jpeg');$x424=imagecreatefromjpeg($n742);}elseif($s457==3){header('Content-Type: image/png');$x424=imagecreatefrompng($n742);}else{header('Content-Type: image/x-ms-bmp');$x424=imagecreatefromwbmp($n742);}if($g744==0){$g744=$w747;}if($w745==0){$w745=$h748;}$h749=$g744/$w747;$j750=$w745/$h748;$v751=min($h749,$j750);$o752=(int)$w747*$v751;$h753=(int)$h748*$v751;$z754=imagecreatetruecolor($o752,$h753);$p755=imagecolorallocatealpha($z754,0,0,0,127);$n756=imagefill($z754,0,0,$p755);$z757=imagesavealpha($z754,true);$p758=imagecopyresampled($z754,$x424,0,0,0,0,$o752,$h753,$w747,$h748);$l759=imagepng($z754,$s743);$w760=imagedestroy($x424);$w760=imagedestroy($z754);return $s743;}function s229($g377){$g381=t0();$h382="SELECT * FROM ct_event WHERE id > '$g377' order by id ASC LIMIT 6";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function d230(){$g381=t0();$h382="SELECT * FROM ct_testimonial";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function d231($w558,$o388){$r469="1";$l372=t0();$b383=$l372->k384("UPDATE ct_ticket_status SET expire = ? WHERE ($o388 = ?)");$b383->b408(1,$r469);$b383->b408(2,$w558);if($b383->u385()===true){$b383=$l372->k384("UPDATE ct_ticket SET expire = ? WHERE ($o388 = ?)");$b383->b408(1,$r469);$b383->b408(2,$w558);if($b383->u385()===true){return 1;}else{return 0;}}else{return 0;}}function y232($q467,$q461){if($q467=='1'){$t465="WHERE (bigmaster_user = '$q461')";}elseif($q467=='2'){$t465="WHERE (master_user = '$q461')";}elseif($q467=='3'){$t465="WHERE (id_agent = '$q461')";}else{$t465="";}$r469="1";$l372=t0();$b383=$l372->k384("UPDATE ct_ticket_status SET expire = ? $t465");$b383->b408(1,$r469);if($b383->u385()===true){$b383=$l372->k384("UPDATE ct_ticket SET expire = ? $t465");$b383->b408(1,$r469);if($b383->u385()===true){return 1;}else{return 0;}}else{return 0;}}function o233($f460,$q461,$d456,$q459){if(trim($f460)==''){$a761="";$w762="WHERE reference_user = '$q461'";}else{$a761="WHERE id_user = '$f460'";$w762="AND reference_user = '$q461'";}$g381=t0();$h382="SELECT * FROM ct_results $a761 $w762 AND game = '$d456' AND reference_id = '$q459'";$b383=$g381->k384($h382);$b383->u385();$f448=$b383->y449();$b383->u450();return $f448;}function i234($w500){$r469="1";$l372=t0();$b383=$l372->k384("UPDATE ct_ticket_status SET expire = ? WHERE (master_user = ?)");$b383->b408(1,$r469);$b383->b408(2,$w558);if($b383->u385()===true){$b383=$l372->k384("UPDATE ct_ticket SET expire = ? WHERE (master_user = ?)");$b383->b408(1,$r469);$b383->b408(2,$w558);if($b383->u385()===true){return 1;}else{return 0;}}else{return 0;}}function t235($g377){$g381=t0();$h382="SELECT * FROM ct_testimonial WHERE id = '$g377'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function u236(){$g381=t0();$h382="SELECT * FROM ct_community";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function t237($g377){$g381=t0();$h382="SELECT * FROM ct_file WHERE id_user = '$g377' order by id DESC LIMIT 10";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function f238($g377){$g381=t0();$h382="SELECT * FROM ct_resultat WHERE id_file = '$g377'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function w239($t403){if($t403=='0'){$q763='Super administrateur';}if($t403=='1'){$q763='Big Master Agent';}if($t403=='2'){$q763='Master Agent';}if($t403=='3'){$q763='Agent';}return $q763;}function z240($t403,$g522,$e764='',$o388='show',$x765="order by level DESC limit 700"){$g522=trim($g522);if($g522!=''){if($t403=='all'){$z766="WHERE username LIKE '%$g522%' OR enterprise LIKE '%$g522%' OR firstname LIKE '%$g522%'";}else{$z766="AND (username LIKE '%$g522%' OR enterprise LIKE '%$g522%' OR firstname LIKE '%$g522%')";}}else{$z766='';}$t403=trim($t403);if($t403=='all'){$c767='';}elseif($e764>0&&$t403=='3'){$c767="WHERE level ='3' AND master_user ='$e764'";}elseif($e764>0&&$t403=='2'){$c767="WHERE level ='$t403' AND master_user ='$e764'";}elseif($e764>0&&$t403=='4'){$c767="WHERE level ='3' AND bigmaster_user ='$e764'";}else{$c767="WHERE level ='$t403' OR level ='0'";}if($o388=='show'){$i541=$x765;}elseif($o388=='count'){$i541="";}$g381=t0();$h382="SELECT * FROM ct_users $c767 $z766 $i541";$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();return $c386;}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function r241($t403,$g522,$w500,$e764='',$o388='show',$x765="order by level DESC limit 700"){$g522=trim($g522);if($g522!=''){if($t403=='all'){$z766="AND (username LIKE '%$g522%' OR enterprise LIKE '%$g522%' OR firstname LIKE '%$g522%')";}elseif(trim($e764)==''&&$t403=='1'){$z766="AND id = '$w500'";}elseif(trim($e764)==''&&$t403=='2'){$z766="AND (username LIKE '%$g522%' OR enterprise LIKE '%$g522%' OR firstname LIKE '%$g522%') AND master_user = '$w500'";}elseif(trim($e764)==''&&$t403=='3'){$z766="AND (username LIKE '%$g522%' OR enterprise LIKE '%$g522%' OR firstname LIKE '%$g522%') AND bigmaster_user = '$w500'";}elseif(trim($e764)>0&&$t403=='2'){$z766="AND (username LIKE '%$g522%' OR enterprise LIKE '%$g522%' OR firstname LIKE '%$g522%')";}elseif(trim($e764)>0&&$t403=='3'){$z766="AND (username LIKE '%$g522%' OR enterprise LIKE '%$g522%' OR firstname LIKE '%$g522%')";}elseif(trim($e764)>0&&$t403=='4'){$z766="AND (username LIKE '%$g522%' OR enterprise LIKE '%$g522%' OR firstname LIKE '%$g522%')";}}else{if($t403=='all'){$z766="";}elseif(trim($e764)==''&&$t403=='1'){$z766="AND id = '$w500'";}elseif(trim($e764)==''&&$t403=='2'){$z766="AND master_user = '$w500'";}elseif(trim($e764)==''&&$t403=='3'){$z766="AND (master_user ='$w500' OR bigmaster_user ='$w500')";}elseif(trim($e764)>0&&$t403=='2'){$z766="AND master_user = '$e764'";}elseif(trim($e764)>0&&$t403=='3'){$z766="AND master_user = '$e764'";}elseif(trim($e764)>0&&$t403=='4'){$z766="AND bigmaster_user = '$e764'";}}$t403=trim($t403);if($t403=='all'){$c767="WHERE (master_user ='$w500' OR bigmaster_user ='$w500')";}elseif(trim($e764)==''&&$t403=='1'){$c767="WHERE level ='$t403'";}elseif(trim($e764)==''&&$t403=='2'){$c767="WHERE level ='$t403'";}elseif(trim($e764)==''&&$t403=='3'){$c767="WHERE level ='$t403'";}elseif($e764>0&&$t403=='3'){$c767="WHERE level ='3' AND master_user ='$e764'";}elseif($e764>0&&$t403=='2'){$c767="WHERE level ='$t403' AND master_user ='$e764'";}elseif($e764>0&&$t403=='4'){$c767="WHERE level ='3' AND bigmaster_user ='$e764'";}if($o388=='show'){$i541=$x765;}elseif($o388=='count'){$i541="";}$g381=t0();$h382="SELECT * FROM ct_users $c767 $z766 $i541";$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();return $c386;}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function x242($g377){$g381=t0();$h382="SELECT * FROM ct_users WHERE level = '2' AND master_user = '$g377' order by id DESC LIMIT 50";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function i243(){$g381=t0();$h382="SELECT * FROM ct_users WHERE level = '2' order by id DESC LIMIT 50";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function q244(){$g381=t0();$h382="SELECT * FROM ct_users WHERE level = '1' order by id DESC LIMIT 50";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function c245($g377,$o537,$i541,$o388,$g522=""){if(isset($_SESSION['said'])){if($o537=='1'){$y543="WHERE level = '$o537' OR level ='0'";if($g522!=""){$y543="WHERE username = '$g522'";}$e551="AND (master_user = '$g377')";}elseif($o537=='2'){$y543="WHERE level = '$o537'";if($g522!=""){$y543="WHERE username = '$g522'";}$e551="";}elseif($o537=='3'){$y543="WHERE level = '$o537'";if($g522!=""){$y543="WHERE username = '$g522'";}$e551="";}else{$y543="";$e551="";}}elseif(isset($_SESSION['aid'])){if($o537=='2'){$y543="WHERE level = '$o537'";if($g522!=""){$y543="WHERE username = '$g522'";}$e551="AND (master_user = '$g377')";}elseif($o537=='3'){$y543="WHERE level = '$o537'";if($g522!=""){$y543="WHERE username = '$g522'";}$e551="AND (master_user = '$g377' OR bigmaster_user = '$g377')";}else{$y543="";$e551="WHERE (master_user = '$g377' OR bigmaster_user = '$g377')";}}elseif(isset($_SESSION['mid'])){if($o537=='3'){$y543="WHERE level = '$o537'";if($g522!=""){$y543="WHERE username = '$g522'";}$e551="AND (master_user = '$g377')";}else{$y543="";$e551="WHERE (master_user = '$g377')";}}if($o388=='count'){$i541='';}$g381=t0();$h382="SELECT * FROM ct_users $y543 $e551 ORDER BY id $i541";$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();return $c386;}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function y246($g377,$o537,$i541,$o388,$g522="",$a768,$o769){if(isset($_SESSION['said'])){if($o537=='1'){$y543="WHERE level = '$o537' OR level ='0'";if($g522!=""){$y543="WHERE username = '$g522'";}$e551="AND (master_user = '$g377')";if($a768=='bank'||$a768=='3'){$u548=z154('ct_users','username',$g522,'id');$y543="WHERE master_user = '$u548' OR bigmaster_user = '$u548'";$e551="AND level = '3'";}}elseif($o537=='2'){$y543="WHERE level = '$o537'";if($g522!=""){$y543="WHERE username = '$g522'";}$e551="";}elseif($o537=='3'){$y543="WHERE level = '$o537'";if($g522!=""){$y543="WHERE username = '$g522'";}$e551="";}else{$y543="";$e551="";}if($o769=='1'||$o769=='2'){if($a768=='bank'||$a768=='3'){$u548=z154('ct_users','username',$g522,'id');if($u548!=''){$y543="WHERE (master_user = '$u548' OR bigmaster_user = '$u548')";$e551="AND level = '3'";}else{$y543="WHERE level = '3'";$e551="";}}}}elseif(isset($_SESSION['aid'])){if($o537=='2'){$y543="WHERE level = '$o537'";if($g522!=""){$y543="WHERE username = '$g522'";}$e551="AND (master_user = '$g377')";}elseif($o537=='3'){$y543="WHERE level = '$o537'";if($g522!=""){$y543="WHERE username = '$g522'";}$e551="AND (master_user = '$g377' OR bigmaster_user = '$g377')";}else{$y543="";$e551="WHERE (master_user = '$g377' OR bigmaster_user = '$g377')";}if($o769=='2'){if($a768=='bank'||$a768=='3'){$u548=z154('ct_users','username',$g522,'id');if($u548!=''){$y543="WHERE (master_user = '$u548' OR bigmaster_user = '$u548')";$e551="AND level = '3'";}else{$y543="WHERE level = '3'";$e551="";}}}}elseif(isset($_SESSION['mid'])){if($o537=='3'){$y543="WHERE level = '$o537'";if($g522!=""){$y543="WHERE username = '$g522'";}$e551="AND (master_user = '$g377')";}else{$y543="";$e551="WHERE (master_user = '$g377')";}}if($o388=='count'){$i541='';}$g381=t0();$h382="SELECT * FROM ct_users $y543 $e551 ORDER BY id $i541";$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();return $c386;}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function l247($o537){$g381=t0();$h382="SELECT * FROM ct_users WHERE level = '$o537' ORDER BY id";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function m248($g377,$f538,$k539,$x540,$y770,$i541,$o388,$i771,$g522=""){$x540=htmlspecialchars_decode($x540,ENT_QUOTES);$u548=z154('ct_users','username',$g522,'id');$m549=z154('ct_users','username',$g522,'level');if($m549=='0'){$j550="AND bigmaster_user = '$u548'";}elseif($m549=='1'){$j550="AND bigmaster_user = '$u548'";}elseif($m549=='2'){$j550="AND master_user = '$u548'";}elseif($m549=='3'){$j550="AND id_agent = '$u548'";}if(trim($x540)!=''){$i542="AND lot in ($x540)";}else{$i542='';}if(isset($_SESSION['said'])){$e551="";if($g522!=""){$e551=$j550;}}elseif(isset($_SESSION['aid'])){$e551="AND (master_user = '$g377' OR bigmaster_user = '$g377')";if($g522!=""){$e551=$j550;}}elseif(isset($_SESSION['mid'])){$e551="AND master_user = '$g377'";if($g522!=""){$e551=$j550;}}if($o388=='count'){$i541='';}$h552=$f538;$b553=$k539;$p554=str_replace('/','-',$f538);$n555=str_replace('/','-',$k539);$f538=strtotime($p554);$k539=strtotime($n555);$k539=$k539+86399;$q556=gmdate("m-d-Y",$f538);$k557=gmdate("m-d-Y",$k539);$g381=t0();if($f538==$k539){$h382="SELECT DISTINCT($i771) FROM ct_ticket WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' $e551 $i542 AND status != '3' order by id $i541";}else{$h382="SELECT DISTINCT($i771) FROM ct_ticket WHERE time_signin >= '$f538' AND time_signin <= '$k539' $e551 $i542 AND status != '3' order by id $i541";}$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();return $c386;}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function n249($j772){$x437='';if($j772=='1'){$x437='Pay';}elseif($j772=='0'){$x437='Non pay';}return $x437;}function y250($g377,$f538,$k539,$x540,$y770,$i541,$o388,$i771,$g522="",$j772=""){$x540=htmlspecialchars_decode($x540,ENT_QUOTES);$u548=z154('ct_users','username',$g522,'id');$m549=z154('ct_users','username',$g522,'level');if($m549=='0'){$j550="AND bigmaster_user = '$u548'";}elseif($m549=='1'){$j550="AND bigmaster_user = '$u548'";}elseif($m549=='2'){$j550="AND master_user = '$u548'";}elseif($m549=='3'){$j550="AND id_agent = '$u548'";}$j772=trim($j772);if($j772!=''){$k773="AND pay = '$j772'";}else{$k773="";}if(trim($x540)!=''){$i542="AND lot in ($x540)";}else{$i542='';}if($y770=='all'){$i542=$i542;}elseif($y770=='perte'){$i542=$i542." AND net < '0' ";}elseif($y770=='profit'){$i542=$i542." AND net > '0' ";}if(isset($_SESSION['said'])){$e551="";if($g522!=""){$e551=$j550;}}elseif(isset($_SESSION['aid'])){$e551="AND (master_user = '$g377' OR bigmaster_user = '$g377')";if($g522!=""){$e551=$j550;}}elseif(isset($_SESSION['mid'])){$e551="AND master_user = '$g377'";if($g522!=""){$e551=$j550;}}if($o388=='count'){$i541='';}$h552=$f538;$b553=$k539;$p554=str_replace('/','-',$f538);$n555=str_replace('/','-',$k539);$f538=strtotime($p554);$k539=strtotime($n555);$k539=$k539+86399;$q556=gmdate("m-d-Y",$f538);$k557=gmdate("m-d-Y",$k539);$g381=t0();if($f538==$k539){$h382="SELECT DISTINCT($i771) FROM ct_ticket WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' $e551 $i542 $k773 order by id $i541";}else{$h382="SELECT DISTINCT($i771) FROM ct_ticket WHERE time_signin >= '$f538' AND time_signin <= '$k539' $e551 $i542 $k773 order by id $i541";}$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();return $c386;}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function a251($g377,$f538,$k539,$y770,$i541,$u774,$o388,$u431,$i771,$g522){$o537=z154('ct_users','id',$g377,'level');$u548=z154('ct_users','username',$g522,'id');$m549=z154('ct_users','username',$g522,'level');if($m549=='0'){$j550="AND bigmaster_user = '$u548'";}elseif($m549=='1'){$j550="AND bigmaster_user = '$u548'";}elseif($m549=='2'){$j550="AND master_user = '$u548'";}elseif($m549=='3'){$j550="AND id_agent = '$u548'";}$i542="AND $i771 = '$u431'";if($y770=='all'){$i542=$i542;}elseif($y770=='perte'){$i542=$i542." AND net < '0' ";}elseif($y770=='profit'){$i542=$i542." AND net > '0' ";}if(isset($_SESSION['said'])){if($o537=='0'){$e551="";if($g522!=""){$e551=$j550;}}elseif($o537=='1'){$e551="AND master_user = '$g377'";if($g522!=""){$e551=$j550;}}elseif($o537=='2'){$e551="";if($g522!=""){$e551=$j550;}}elseif($o537=='3'){$e551="";if($g522!=""){$e551=$j550;}}else{$e551="";}}elseif(isset($_SESSION['aid'])){if($o537=='1'){$e551="AND (master_user = '$g377' OR bigmaster_user = '$g377')";if($g522!=""){$e551=$j550;}}elseif($o537=='2'){$e551="AND master_user = '$g377'";if($g522!=""){$e551=$j550;}}elseif($o537=='3'){$e551="AND (master_user = '$g377' OR bigmaster_user = '$g377')";if($g522!=""){$e551=$j550;}}}elseif(isset($_SESSION['mid'])){if($o537=='2'){$e551="AND master_user = '$g377'";if($g522!=""){$e551=$j550;}}elseif($o537=='3'){$e551="AND master_user = '$g377'";if($g522!=""){$e551=$j550;}}}if($o388=='count'){$i541='';}$h552=$f538;$b553=$k539;$p554=str_replace('/','-',$f538);$n555=str_replace('/','-',$k539);$f538=strtotime($p554);$k539=strtotime($n555);$k539=$k539+86399;$q556=gmdate("m-d-Y",$f538);$k557=gmdate("m-d-Y",$k539);$g381=t0();if($f538==$k539){$h382="SELECT sum($u774) AS total FROM ct_ticket WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' $e551 $i542 AND status != '3' order by id $i541";}else{$h382="SELECT sum($u774) AS total FROM ct_ticket WHERE time_signin >= '$f538' AND time_signin <= '$k539' $e551 $i542 AND status != '3' order by id $i541";}$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();foreach($c386 as $o388){$f448=$o388['total'];}if(isset($f448)){return $f448;}}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function j252($g377,$o537,$f538,$k539,$x540,$i541,$o388,$s457,$j497="",$g522=""){$x540=htmlspecialchars_decode($x540,ENT_QUOTES);if(trim($x540)!=''){$i542="AND lot in ($x540)";}else{$i542='';}$y543='';$j497=trim($j497);if($j497!=''){$k545="AND option_lot = '$j497'";}else{$k545='';}$s457=trim($s457);if($s457!=''){$x775="AND type = '$s457'";}else{$x775='';}$u548=z154('ct_users','username',$g522,'id');$m549=z154('ct_users','username',$g522,'level');if($m549=='0'){$j550="AND bigmaster_user = '$u548'";}elseif($m549=='1'){$j550="AND bigmaster_user = '$u548'";}elseif($m549=='2'){$j550="AND master_user = '$u548'";}elseif($m549=='3'){$j550="AND id_agent = '$u548'";}if(isset($_SESSION['said'])){if($o537=='1'){if($g522!=""){$y543=$j550;}$e551="";}elseif($o537=='2'){if($g522!=""){$y543=$j550;}$e551="";}elseif($o537=='3'){if($g522!=""){$y543=$j550;;}$e551="";}else{$y543="";$e551="";}}elseif(isset($_SESSION['aid'])){if($o537=='2'){if($g522!=""){$y543=$j550;}$e551="AND (bigmaster_user = '$g377')";}elseif($o537=='3'){if($g522!=""){$y543=$j550;}$e551="AND (master_user = '$g377' OR bigmaster_user = '$g377')";}else{$e551="AND (master_user = '$g377' OR bigmaster_user = '$g377')";}}elseif(isset($_SESSION['mid'])){if($o537=='3'){if($g522!=""){$y543=$j550;}$e551="AND (master_user = '$g377')";}else{$e551="AND (master_user = '$g377')";}}if($o388=='count'){$i541='';}$h552=$f538;$b553=$k539;$p554=str_replace('/','-',$f538);$n555=str_replace('/','-',$k539);$f538=strtotime($p554);$k539=strtotime($n555);$k539=$k539+86399;$q556=gmdate("m-d-Y",$f538);$k557=gmdate("m-d-Y",$k539);$g381=t0();if($f538==$k539){$h382="SELECT DISTINCT numbers FROM ct_ticket WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' AND status != '3' $x775 $i542 $y543 $e551 $k545 ORDER BY numbers ASC";}else{$h382="SELECT DISTINCT numbers FROM ct_ticket WHERE time_signin >= '$f538' AND time_signin <= '$k539' AND status != '3' $x775 $i542 $y543 $e551 $k545 ORDER BY numbers ASC";}$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();return $c386;}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function j253($g377,$o537,$f538,$k539,$x540,$i541,$o388,$s457,$j497="",$g522=""){$x540=htmlspecialchars_decode($x540,ENT_QUOTES);if(trim($x540)!=''){$i542="AND lot in ($x540)";}else{$i542='';}$y543='';$j497=trim($j497);if($j497!=''){$k545="AND option_lot = '$j497'";}else{$k545='';}$s457=trim($s457);if($s457!=''){$x775="AND type = '$s457'";}else{$x775='';}$u548=z154('ct_users','username',$g522,'id');$m549=z154('ct_users','username',$g522,'level');if($m549=='0'){$j550="AND bigmaster_user = '$u548'";}elseif($m549=='1'){$j550="AND bigmaster_user = '$u548'";}elseif($m549=='2'){$j550="AND master_user = '$u548'";}elseif($m549=='3'){$j550="AND id_agent = '$u548'";}if(isset($_SESSION['said'])){if($o537=='1'){if($g522!=""){$y543=$j550;}$e551="";}elseif($o537=='2'){if($g522!=""){$y543=$j550;}$e551="";}elseif($o537=='3'){if($g522!=""){$y543=$j550;;}$e551="";}else{$y543="";$e551="";}}elseif(isset($_SESSION['aid'])){if($o537=='2'){if($g522!=""){$y543=$j550;}$e551="AND (bigmaster_user = '$g377')";}elseif($o537=='3'){if($g522!=""){$y543=$j550;}$e551="AND (master_user = '$g377' OR bigmaster_user = '$g377')";}else{$e551="AND (master_user = '$g377' OR bigmaster_user = '$g377')";}}elseif(isset($_SESSION['mid'])){if($o537=='3'){if($g522!=""){$y543=$j550;}$e551="AND (master_user = '$g377')";}else{$e551="AND (master_user = '$g377')";}}if($o388=='count'){$i541='';}$h552=$f538;$b553=$k539;$p554=str_replace('/','-',$f538);$n555=str_replace('/','-',$k539);$f538=strtotime($p554);$k539=strtotime($n555);$k539=$k539+86399;$q556=gmdate("m-d-Y",$f538);$k557=gmdate("m-d-Y",$k539);$g381=t0();if($f538==$k539){$h382="SELECT DISTINCT numbers FROM ct_ticket WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' AND status != '3' $x775 $i542 $y543 $e551 $k545 ORDER BY type ASC";}else{$h382="SELECT DISTINCT numbers FROM ct_ticket WHERE time_signin >= '$f538' AND time_signin <= '$k539' AND status != '3' $x775 $i542 $y543 $e551 $k545 ORDER BY type ASC";}$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();return $c386;}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function c254($g377,$o537,$f538,$k539,$x540,$i541,$o388,$a455,$s457,$j497="",$g522="",$u774="amount"){$x540=htmlspecialchars_decode($x540,ENT_QUOTES);if(trim($x540)!=''){$i542="AND lot in ($x540)";}else{$i542='';}$y543='';$u774=trim($u774);if($u774!=''){$q776="sum($u774) AS total";}else{$q776='*';}$j497=trim($j497);if($j497!=''){$k545="AND option_lot = '$j497'";}else{$k545='';}$s457=trim($s457);if($s457!=''){$w546="AND type = '$s457'";}else{$w546='';}$a455=trim($a455);if($a455!=''){$z547="AND numbers = '$a455'";}else{$z547='';}$u548=z154('ct_users','username',$g522,'id');$m549=z154('ct_users','username',$g522,'level');if($m549=='0'){$j550="AND bigmaster_user = '$u548'";}elseif($m549=='1'){$j550="AND bigmaster_user = '$u548'";}elseif($m549=='2'){$j550="AND master_user = '$u548'";}elseif($m549=='3'){$j550="AND id_agent = '$u548'";}if(isset($_SESSION['said'])){if($o537=='1'){if($g522!=""){$y543=$j550;}$e551="";}elseif($o537=='2'){if($g522!=""){$y543=$j550;}$e551="";}elseif($o537=='3'){if($g522!=""){$y543=$j550;;}$e551="";}else{$y543="";$e551="";}}elseif(isset($_SESSION['aid'])){if($o537=='2'){if($g522!=""){$y543=$j550;}$e551="AND (bigmaster_user = '$g377')";}elseif($o537=='3'){if($g522!=""){$y543=$j550;}$e551="AND (master_user = '$g377' OR bigmaster_user = '$g377')";}else{$e551="AND (master_user = '$g377' OR bigmaster_user = '$g377')";}}elseif(isset($_SESSION['mid'])){if($o537=='3'){if($g522!=""){$y543=$j550;}$e551="AND (master_user = '$g377')";}else{$e551="AND (master_user = '$g377')";}}if($o388=='count'){$i541='';}$h552=$f538;$b553=$k539;$p554=str_replace('/','-',$f538);$n555=str_replace('/','-',$k539);$f538=strtotime($p554);$k539=strtotime($n555);$k539=$k539+86399;$q556=gmdate("m-d-Y",$f538);$k557=gmdate("m-d-Y",$k539);$g381=t0();if($f538==$k539){$h382="SELECT $q776 FROM ct_ticket WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' AND status != '3' $w546 $z547 $i542 $y543 $e551 $k545";}else{$h382="SELECT $q776 FROM ct_ticket WHERE time_signin >= '$f538' AND time_signin <= '$k539' AND status != '3' $w546 $z547 $i542 $y543 $e551 $k545";}$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();if($u774!=''){foreach($c386 as $o388){$c777=$o388['total'];}return $c777;}else{return $c386;}}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function p255($g377,$o537,$f538,$k539,$x540,$i541,$o388,$a455,$s457,$j497="",$g522="",$u774="amount"){$x540=htmlspecialchars_decode($x540,ENT_QUOTES);if(trim($x540)!=''){$i542="AND lot in ($x540)";}else{$i542='';}$y543='';$u774=trim($u774);if($u774!=''){$q776="sum($u774) AS total";}else{$q776='*';}$j497=trim($j497);if($j497!=''){$k545="AND option_lot = '$j497'";}else{$k545='';}$s457=trim($s457);if($s457!=''){$w546="AND type = '$s457'";}else{$w546='';}$a455=trim($a455);if($a455!=''){$z547="AND numbers = '$a455'";}e
Showing the first 100,000 of 156,973 characters. Download the full output.
Did this file decode correctly?
How would you describe this file?
Thank you for your feedback! This will help us detect malicious PHP files more accurately in the future.
Function Calls
| error_reporting | 1 |
|---|---|
| date_default_timezone_set | 1 |
Variables
None
Stats
| MD5 | 8336e250e075f1e9 |
|---|---|
| Eval Count | 0 |
| Decode Time | 1112 ms |
Original Code
<?php error_reporting(E_ALL);date_default_timezone_set('America/Port-au-Prince');function t0(){$w368='localhost';$x369='quintgames_db';$z370='Quintgames2023@';$q371='quintgames_db';try{$l372=new x373("mysql:host=$w368;dbname=$q371",$x369,$z370,array(PDO::ATTR_PERSISTENT=>true));}catch(Exception $c374){die('Erreur : '.$c374->s375());}return $l372;}session_start();$i376='';function m1(){$g377='';if(isset($_SESSION['id'])){$g377=$_SESSION['id'];}if(isset($_SESSION['mid'])){$g377=$_SESSION['mid'];}if(isset($_SESSION['aid'])){$g377=$_SESSION['aid'];}if(isset($_SESSION['said'])){$g377=$_SESSION['said'];}return $g377;}$f378=m1();$g379=$_SERVER['REMOTE_ADDR'];function g2($e380){$g381=t0();$h382="SELECT $e380 FROM ct_options";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388[$e380];}if(isset($g389)){return $g389;}}$i390=utf8_encode(g2('site_name'));$o391=g2('site_logo');$n392=g2('site_favicon');$h393=g2('site_desc');$s394=g2('site_url');$z395=g2('site_url');$b396=g2('meta');function l3($p397){if($p397=='0'){$p397='Yes';}else{$p397='No';}return $p397;}function i4($a398){if($a398=='1'){$d399='Pay';}else{$d399='Non Pay';}return $d399;}function r5($z400){if($z400=='1'){$z400='Active';}else{$z400='Inactive';}return $z400;}function b6($i401,$m402,$t403,$f404,$l405,$w406,$v407){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_users (fullname, email, password, level, about, role, avatar) VALUES (? ,? ,? ,? ,? ,? ,?)');$b383->b408(1,$i401);$b383->b408(2,$m402);$b383->b408(3,$v407);$b383->b408(4,$t403);$b383->b408(5,$f404);$b383->b408(6,$l405);$b383->b408(7,$w406);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function p7($v410,$j411,$o412,$j413,$f414,$m402,$l415,$q416,$v407,$t403,$f404,$l405,$w406,$c417,$m418,$n419,$b420,$k421,$z422,$y423){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_users (`account_number`, `firstname`, `lastname`, `email`, `password`, `level`, `about`, `role`, `avatar`, `enterprise_name`, `position`, `phone`, `birthday`, `sex`, `date_signin`, `verified`, `code`, `active`, `profession`, `enterprise_type`) VALUES (? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,?)');$b383->b408(1,$v410);$b383->b408(2,$j411);$b383->b408(3,$o412);$b383->b408(4,$m402);$b383->b408(5,$v407);$b383->b408(6,$t403);$b383->b408(7,$f404);$b383->b408(8,$l405);$b383->b408(9,$w406);$b383->b408(10,$j413);$b383->b408(11,$f414);$b383->b408(12,$l415);$b383->b408(13,$q416);$b383->b408(14,$c417);$b383->b408(15,$m418);$b383->b408(16,$n419);$b383->b408(17,$b420);$b383->b408(18,$k421);$b383->b408(19,$z422);$b383->b408(20,$y423);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function f8($x424){if($x424=='0'||$x424==''||$x424=='Invalid file format..'||$x424=='Please select image..!'){$x424='img/placeholders/avatars/avatar12.jpg';}else{$x424='../'.$x424;}return $x424;}function m9($x424){if($x424=='0'||$x424==''||$x424=='Invalid file format..'||$x424=='Please select image..!'){$x424='img/default-avatar.png';}else{$x424=''.$x424;}return $x424;}function l10($l405){if($l405!=''){$l405=', '.$l405;}return $l405;}function p11($x424){if($x424=='0'||$x424==''){$x424='assets/images/avatar2.jpg';}else{$x424=$x424;}return $x424;}function f12($d425,$n426){if(isset($_GET['page'])&&$d425=='1'&&$n426=='0'){$u427="open";}elseif(isset($_GET['page'])&&$d425=='0'&&$n426=='1'){$u427='style="display: block;"';}else{$u427="";}return $u427;}function o13($d425,$n426){if(isset($_GET['section'])&&$d425=='1'&&$n426=='0'){$d428="open";}elseif(isset($_GET['section'])&&$d425=='0'&&$n426=='1'){$d428='style="display: block;"';}else{$d428="";}return $d428;}function z14($x429,$b430){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_job_lang (id_job,name) VALUES (? ,? )');$b383->b408(1,$x429);$b383->b408(2,$b430);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function g15($u431,$n432,$h433){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_mail_rapport (lot, reference, date_time) VALUES (? ,? ,?)');$b383->b408(1,$u431);$b383->b408(2,$n432);$b383->b408(3,$h433);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function p16($b434){$b434=str_replace("-","",$b434);return $b434;}function e17($r435,$t436){$x437=$r435*100;if($t436>0){$x437=$x437/$t436;}$x437=number_format($x437,2).'%';return $x437;}function b18($z438){if($z438>0){$e439='Profit';}elseif($z438==0){$e439='';}elseif($z438<0){$e439='Perte';}return $e439;}function i19($x440,$f441,$i442,$o388='show',$d443="order by name ASC"){$i444=g2('big_master_limit_trans');$y445=g2('master_limit_trans');if(r340('ct_limitations_transactions','level','0','reference_user',$x440,'level')=='0'){$d443="WHERE level = '0' AND reference_user = '$x440'";$h446=$d443.' superadmin identify';}elseif(r340('ct_limitations_transactions','level','0','reference_user',$i442,'level')=='0'){$d443="WHERE level = '0' AND reference_user = '$i442'";$h446=$d443.' id_master_agent';}elseif(r340('ct_limitations_transactions','level','0','reference_user',$f441,'level')=='0'){$d443="WHERE level = '0' AND reference_user = '$f441'";$h446=$d443.' id_bigmaster_agent';}elseif(r340('ct_limitations_transactions','id_user',$f441,'reference_user',$x440,'level')=='1'&&$i444=='1'){$d443="WHERE id_user = '$f441' AND reference_user = '$x440'";$h446=$d443.' id_bigmaster_agent';}elseif(r340('ct_limitations_transactions','id_user',$f441,'reference_user',$i442,'level')=='1'&&$i444=='1'){$d443="WHERE id_user = '$f441' AND reference_user = '$i442'";$h446=$d443.' id_bigmaster_agent';}elseif(r340('ct_limitations_transactions','id_user',$i442,'reference_user',$x440,'level')=='2'&&$y445=='1'){$d443="WHERE id_user = '$i442' AND reference_user = '$x440'";$h446=$d443.' id_master_agent';}elseif($y445=='1'){$d443="WHERE id_user = '$i442' AND reference_user = '0'";$h446=$d443.' id_master_agent';}elseif($i444=='1'){$d443="WHERE id_user = '$f441' AND reference_user = '0'";$h446=$d443.' id_bigmaster_agent';}else{$d443="WHERE level = '0' AND reference_user = '0'";$h446=$d443.' superadmin default';}$g381=t0();$h382="SELECT * FROM ct_limitations_transactions $d443";$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();foreach($c386 as $o388){$b447=$o388['play'];}if(isset($b447)){return $b447;}}elseif($o388=='user'){$c386=$b383->e387();foreach($c386 as $o388){$b447=$o388['level'];}if(isset($b447)){return $b447;}}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function g20($e451){$o452=60*$e451;$g453=time()-$o452;$z400='disconnect';$l372=t0();$b383=$l372->k384("UPDATE ct_online_users SET status = ? WHERE time_signin < '$g453'");$b383->b408(1,$z400);if($b383->u385()===true){$o452=60*720;$m454=time()-$o452;$z400='absent';$l372=t0();$h382="DELETE FROM ct_online_users WHERE time_signin < :time_signin";$b383=$l372->k384($h382);$b383->u385(array(':time_signin'=>$m454));return 1;}else{return 0;}}function i21($a455,$d456,$s457,$q458,$q459,$f460,$q461,$t403){$m454=time();$i462='0';try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_results (numbers,game,type,description,time_signin,date_result,reference_id, id_user, reference_user, level) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)');$b383->b408(1,$a455);$b383->b408(2,$d456);$b383->b408(3,$s457);$b383->b408(4,$i462);$b383->b408(5,$m454);$b383->b408(6,$q458);$b383->b408(7,$q459);$b383->b408(8,$f460);$b383->b408(9,$q461);$b383->b408(10,$t403);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function g22($q459,$f460,$q461,$h433,$t403){$y463='0';$l372=t0();$f464=z154('ct_users','id',m1(),'level');if($t403=='1'){$t465="AND (bigmaster_user = '$q461')";}elseif($t403=='2'){$t465="AND (master_user = '$q461')";}elseif($t403=='3'){$t465="AND (id_agent = '$q461')";}else{$t465="";}$b383=$l372->k384("UPDATE ct_ticket_status SET statut_ticket = ?, prize = ?, expire = ? WHERE date_time = '$h433' AND statut_ticket != '3' $t465");$b383->b408(1,$y463);$b383->b408(2,$y463);$b383->b408(3,$y463);if($b383->u385()===true){$b383=$l372->k384("UPDATE ct_ticket SET status = ?, prize = ?, expire = ?, pay = ? WHERE date_time = '$h433' AND status != '3' $t465");$b383->b408(1,$y463);$b383->b408(2,$y463);$b383->b408(3,$y463);$b383->b408(4,$y463);if($b383->u385()===true){$q458=str_replace('/','-',$h433);$b383=$l372->k384("DELETE FROM ct_results WHERE date_result = '$q458' AND id_user = '$f460' AND reference_user = '$q461' AND level = '$f464'");$b383->u385();}}}function y23($l466,$h433){$g381=t0();$h382="SELECT sum(prize) as total FROM ct_ticket WHERE serial_number = '$l466' AND date_time = '$h433'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['total'];}if(isset($g389)){return $g389;}else{return 0;}}function x24($q459,$q467,$q461){$m454=time();$p468='1';$r469='1';if($q467=='1'){$t465="AND (ct_ticket_status.bigmaster_user = '$q461')";}elseif($q467=='2'){$t465="AND (ct_ticket_status.master_user = '$q461')";}elseif($q467=='3'){$t465="AND (ct_ticket_status.id_agent = '$q461')";}else{$t465="";}try{$l372=t0();$b383=$l372->k384("UPDATE ct_ticket, ct_ticket_status SET ct_ticket_status.prize = ct_ticket.priz_total, ct_ticket_status.statut_ticket = '1' WHERE ct_ticket_status.serial_number = ct_ticket.serial_number AND ct_ticket.priz_total > '0' AND ct_ticket.reference_id = '$q459' AND ct_ticket_status.statut_ticket != '3' $t465");if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function n25($q459,$q467,$q461){$m454=time();$p468='1';$r469='1';if($q467=='1'){$t465="AND (ct_ticket_status.bigmaster_user = '$q461')";}elseif($q467=='2'){$t465="AND (ct_ticket_status.master_user = '$q461')";}elseif($q467=='3'){$t465="AND (ct_ticket_status.id_agent = '$q461')";}else{$t465="";}try{$l372=t0();$b383=$l372->k384("UPDATE ct_ticket, ct_ticket_status SET ct_ticket_status.statut_ticket = '2' WHERE ct_ticket_status.serial_number = ct_ticket.serial_number AND ct_ticket_status.prize = '0' AND ct_ticket.reference_id = '$q459' AND ct_ticket_status.statut_ticket != '3' $t465");if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function k26($z470,$c471,$x472,$s457,$q459,$d456,$q467,$q461,$a473=""){$m454=time();$p468='1';$r469='1';if($q467=='1'){$t465="AND (bigmaster_user = '$q461')";}elseif($q467=='2'){$t465="AND (master_user = '$q461')";}elseif($q467=='3'){$t465="AND (id_agent = '$q461')";}else{$t465="";}$a473=trim($a473);if($a473!=""){$l474="AND option_lot = '$a473'";}else{$l474="";}try{$l372=t0();$b383=$l372->k384("UPDATE ct_ticket SET status = ?, prize = prize+(amount*?), expire = ?, winning = ? WHERE numbers = ? AND type = ? AND reference_id = ? AND lot = ? $l474 AND status != '3' $t465");$b383->b408(1,$p468);$b383->b408(2,$z470);$b383->b408(3,$r469);$b383->b408(4,$c471);$b383->b408(5,$x472);$b383->b408(6,$s457);$b383->b408(7,$q459);$b383->b408(8,$d456);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function j27($z470,$c471,$x472,$s457,$q459,$d456,$q467,$q461,$a473=""){$m454=time();$p468='1';$r469='1';if($q467=='1'){$t465="AND (bigmaster_user = '$q461')";}elseif($q467=='2'){$t465="AND (master_user = '$q461')";}elseif($q467=='3'){$t465="AND (id_agent = '$q461')";}else{$t465="";}$a473=trim($a473);if($a473!=""){$l474="AND option_lot = '$a473'";}else{$l474="";}try{$l372=t0();$b383=$l372->k384("UPDATE ct_ticket SET status = ?, prize = amount*?, expire = ?, winning = ? WHERE numbers = ? AND type = ? AND reference_id = ? AND lot = ? $l474 AND status != '3' $t465");$b383->b408(1,$p468);$b383->b408(2,$z470);$b383->b408(3,$r469);$b383->b408(4,$c471);$b383->b408(5,$x472);$b383->b408(6,$s457);$b383->b408(7,$q459);$b383->b408(8,$d456);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function l28($z470,$c471,$x472,$s457,$q459,$d456,$q467,$q461){$m454=time();$p468='1';$r469='1';if($q467=='1'){$t465="AND (bigmaster_user = '$q461')";}elseif($q467=='2'){$t465="AND (master_user = '$q461')";}elseif($q467=='3'){$t465="AND (id_agent = '$q461')";}else{$t465="";}try{$l372=t0();$b383=$l372->k384("UPDATE ct_ticket SET status = ?, prize = ?, expire = ?, winning = ? WHERE numbers = ? AND type = ? AND reference_id = ? AND lot = ? AND status != '3' AND expire = '0' $t465");$b383->b408(1,$p468);$b383->b408(2,$z470);$b383->b408(3,$r469);$b383->b408(4,$c471);$b383->b408(5,$x472);$b383->b408(6,$s457);$b383->b408(7,$q459);$b383->b408(8,$d456);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function u29($z470,$c471,$y475,$j476,$t477,$z478,$g479,$j480,$s457,$q459,$d456,$q467,$q461){$m454=time();$p468='1';$r469='1';if($q467=='1'){$t465="AND (bigmaster_user = '$q461')";}elseif($q467=='2'){$t465="AND (master_user = '$q461')";}elseif($q467=='3'){$t465="AND (id_agent = '$q461')";}else{$t465="";}try{$l372=t0();$b383=$l372->k384("UPDATE ct_ticket SET status = ?, prize = amount*?, expire = ?, winning = ? WHERE (numbers = ? OR numbers = ? OR numbers = ? OR numbers = ? OR numbers = ? OR numbers = ?) AND type = ? AND reference_id = ? AND lot = ? AND status != '3' AND expire = '0' $t465");$b383->b408(1,$p468);$b383->b408(2,$z470);$b383->b408(3,$r469);$b383->b408(4,$c471);$b383->b408(5,$y475);$b383->b408(6,$j476);$b383->b408(7,$t477);$b383->b408(8,$z478);$b383->b408(9,$g479);$b383->b408(10,$j480);$b383->b408(11,$s457);$b383->b408(12,$q459);$b383->b408(13,$d456);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function z30($q459,$d456,$q467,$q461){$m454=time();$f481='2';$r469='1';if($q467=='1'){$t465="AND (bigmaster_user = '$q461')";}elseif($q467=='2'){$t465="AND (master_user = '$q461')";}elseif($q467=='3'){$t465="AND (id_agent = '$q461')";}else{$t465="";}try{$l372=t0();$b383=$l372->k384("UPDATE ct_ticket SET status = ?, expire = ? WHERE reference_id = ? AND lot = ? AND status != '3' AND expire = '0' $t465");$b383->b408(1,$f481);$b383->b408(2,$r469);$b383->b408(3,$q459);$b383->b408(4,$d456);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function q31($q459,$q467,$q461){$m454=time();$f481='2';$r469='1';if($q467=='1'){$t465="AND (bigmaster_user = '$q461')";}elseif($q467=='2'){$t465="AND (master_user = '$q461')";}elseif($q467=='3'){$t465="AND (id_agent = '$q461')";}else{$t465="";}try{$l372=t0();$b383=$l372->k384("UPDATE ct_ticket p, (SELECT serial_number, sum(prize) as total FROM ct_ticket WHERE reference_id = '$q459' GROUP BY serial_number) as s SET p.priz_total = s.total WHERE p.serial_number = s.serial_number AND p.reference_id = '$q459'");if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function g32($l466,$z482,$h433){$m454=time();$i462='0';$x483=y23($l466,$h433);$b484=r340('ct_ticket_status','serial_number',$l466,'date_time',$h433,'amount');$v485=r340('ct_ticket_status','serial_number',$l466,'date_time',$h433,'commission_agent');$s486=r340('ct_ticket_status','serial_number',$l466,'date_time',$h433,'commission_masteragent');$h487=r340('ct_ticket_status','serial_number',$l466,'date_time',$h433,'commission_bigmasteragent');$v488=$b484-$v485-$s486-$h487-$x483;$r469="1";if($x483>0){$j489='1';$l372=t0();$b383=$l372->k384('UPDATE ct_ticket_status SET statut_ticket = ?, prize = ?, net = ?, expire = ? WHERE serial_number = ? AND date_time = ?');$b383->b408(1,$j489);$b383->b408(2,$x483);$b383->b408(3,$v488);$b383->b408(4,$r469);$b383->b408(5,$l466);$b383->b408(6,$h433);if($b383->u385()===true){return 1;}else{return 0;}}else{$i490='2';$l372=t0();$b383=$l372->k384('UPDATE ct_ticket_status SET statut_ticket = ?, net = ? WHERE serial_number = ? AND date_time = ?');$b383->b408(1,$i490);$b383->b408(2,$v488);$b383->b408(3,$l466);$b383->b408(4,$h433);if($b383->u385()===true){return 1;}else{return 0;}}}function w33(){$g381=t0();$h382="SELECT * FROM ct_users WHERE prepaye = '1' AND level = '3'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function k34($z482){if($z482>0){$d491='class="alert alert-success" style="color: #000;"';}else{$d491='';}return $d491;}function e35($z400){if($z400=='En attente'){$d491='alert alert-primary';}if($z400=='Gagnant'){$d491='alert alert-success';}if($z400=='Perdant'){$d491='alert alert-danger';}if($z400=='Annul'){$d491='alert alert-secondary';}if(isset($d491)){return $d491;}}function z36($l466){$g381=t0();$h382="SELECT * FROM ct_ticket_status WHERE serial_number = '$l466'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$b492=$o388['statut_ticket'];if($b492=='0'){$v493="Pending";$v493="En attente";}if($b492=='1'){$v493="Winner";$v493="Gagnant";}if($b492=='2'){$v493="Loser";$v493="Perdant";}if($b492=='3'){$v493="Cancelled";$v493="Annul";}}if(isset($v493)){return $v493;}}function t37($o494){$g381=t0();$h382="SELECT * FROM ct_sortition_user WHERE user = '$o494' order by name ASC";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function o38(){$g381=t0();$h382="SELECT * FROM ct_users";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function a39($b484,$f460){$l372=t0();$b383=$l372->k384("UPDATE ct_users SET wallet_prepay = ? WHERE (id = ?)");$b383->b408(1,$b484);$b383->b408(2,$f460);if($b383->u385()===true){return 1;}else{return 0;}}function v40($x495,$f460){$l372=t0();$b383=$l372->k384("UPDATE ct_users SET wallet_prepay = wallet_prepay-? WHERE (id = ?)");$b383->b408(1,$x495);$b383->b408(2,$f460);if($b383->u385()===true){return 1;}else{return 0;}}function g41($b484,$f460){$l372=t0();$b383=$l372->k384("UPDATE ct_users SET wallet_prepay = wallet_prepay+? WHERE (id = ?)");$b383->b408(1,$b484);$b383->b408(2,$f460);if($b383->u385()===true){return 1;}else{return 0;}}function w42($z496,$j497,$q498,$n499,$t403,$w500,$t501,$h433,$m454){$m454=time();try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_transactions_prepay (amount,options,sender_user, recipient_user, level, master_user, bigmaster_user, date_time, time_signin) VALUES (?, ?, ?, ?, ? ,? ,? ,? ,?)');$b383->b408(1,$z496);$b383->b408(2,$j497);$b383->b408(3,$q498);$b383->b408(4,$n499);$b383->b408(5,$t403);$b383->b408(6,$w500);$b383->b408(7,$t501);$b383->b408(8,$h433);$b383->b408(9,$m454);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function l43($a455,$u502,$s457,$d456,$j497,$q461,$t403){$h433=time();$f460=m1();try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_limitations_transactions (numbers,play,type,options, game, date_time,id_user,reference_user,level) VALUES (?, ?, ?, ?, ?, ?, ? ,? ,?)');$b383->b408(1,$a455);$b383->b408(2,$u502);$b383->b408(3,$s457);$b383->b408(4,$j497);$b383->b408(5,$d456);$b383->b408(6,$h433);$b383->b408(7,$f460);$b383->b408(8,$q461);$b383->b408(9,$t403);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function p44($a455,$u502,$s457,$d456,$j497,$q461,$t403){$h433=time();$w500=m1();try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_limitations (numbers,play,type,options, game, date_time,master_user,reference_user,level) VALUES (?, ?, ?, ?, ?, ?, ? ,? ,?)');$b383->b408(1,$a455);$b383->b408(2,$u502);$b383->b408(3,$s457);$b383->b408(4,$j497);$b383->b408(5,$d456);$b383->b408(6,$h433);$b383->b408(7,$w500);$b383->b408(8,$q461);$b383->b408(9,$t403);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function g45($f460,$q461,$t403,$t503,$n504,$u505,$b506,$g507,$l415){$h433=time();try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_ticket_customization (id_user, reference_user, level, title_text_original, title_text_cancel, footer_text_1, footer_text_2, footer_text_3, phone, date_time) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)');$b383->b408(1,$f460);$b383->b408(2,$q461);$b383->b408(3,$t403);$b383->b408(4,$t503);$b383->b408(5,$n504);$b383->b408(6,$u505);$b383->b408(7,$b506);$b383->b408(8,$g507);$b383->b408(9,$l415);$b383->b408(10,$h433);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function j46($f460,$q461,$t403){$g381=t0();$h382="SELECT * FROM ct_ticket_customization WHERE id_user = '$f460' AND reference_user = '$q461' AND level = '$t403'";$b383=$g381->k384($h382);$b383->u385();$f448=$b383->y449();$b383->u450();return $f448;}function j47($f460,$q461,$t403,$t503,$n504,$u505,$b506,$g507,$l415){try{$l372=t0();$b383=$l372->k384('UPDATE ct_ticket_customization SET title_text_original = ?, title_text_cancel = ?, footer_text_1 = ?, footer_text_2 = ?, footer_text_3 = ?, phone = ? WHERE id_user = ? AND reference_user = ? AND level = ?');$b383->b408(1,$t503);$b383->b408(2,$n504);$b383->b408(3,$u505);$b383->b408(4,$b506);$b383->b408(5,$g507);$b383->b408(6,$l415);$b383->b408(7,$f460);$b383->b408(8,$q461);$b383->b408(9,$t403);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function p48($z400,$g377,$z482,$c471){$m454=time();$i462='0';$r469="1";try{$l372=t0();$b383=$l372->k384('UPDATE ct_ticket SET status = ?, prize = ?, expire = ?, winning = ? WHERE id = ?');$b383->b408(1,$z400);$b383->b408(2,$z482);$b383->b408(3,$r469);$b383->b408(4,$c471);$b383->b408(5,$g377);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function o49($f460,$q461,$t403,$h508,$h509,$d456){$h433=time();try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_product_price (id_user, reference_user, level, product, price, game, date_time) VALUES (?, ?, ?, ?, ?, ?, ?)');$b383->b408(1,$f460);$b383->b408(2,$q461);$b383->b408(3,$t403);$b383->b408(4,$h508);$b383->b408(5,$h509);$b383->b408(6,$d456);$b383->b408(7,$h433);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function y50($f460,$q461,$t403,$h508,$d456){$g381=t0();$h382="SELECT * FROM ct_product_price WHERE id_user = '$f460' AND reference_user = '$q461' AND level = '$t403' AND product = '$h508' AND game = '$d456'";$b383=$g381->k384($h382);$b383->u385();$f448=$b383->y449();$b383->u450();return $f448;}function x51($f460,$q461,$t403,$h508,$h509,$d456){try{$l372=t0();$b383=$l372->k384('UPDATE ct_product_price SET price = ? WHERE product = ? AND id_user = ? AND reference_user = ? AND level = ? AND game = ?');$b383->b408(1,$h509);$b383->b408(2,$h508);$b383->b408(3,$f460);$b383->b408(4,$q461);$b383->b408(5,$t403);$b383->b408(6,$d456);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function p52($f460){$l372=t0();$b383=$l372->k384('DELETE FROM ct_cookie WHERE id_user = ?');$b383->b408(1,$f460);if($b383->u385()===true){return 1;}else{return 0;}}function f53($f460,$q461,$t403){$l372=t0();$b383=$l372->k384('DELETE FROM ct_ticket_customization WHERE id_user = ? AND reference_user = ? AND level = ?');$b383->b408(1,$f460);$b383->b408(2,$q461);$b383->b408(3,$t403);if($b383->u385()===true){return 1;}else{return 0;}}function s54($o510,$z511){try{$l372=t0();$b383=$l372->k384('UPDATE ct_options SET big_master_ticket_footer = ?, master_ticket_footer = ?');$b383->b408(1,$o510);$b383->b408(2,$z511);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function a55($d512,$o513){try{$l372=t0();$b383=$l372->k384('UPDATE ct_options SET big_master_add_result = ?, master_add_result = ?');$b383->b408(1,$d512);$b383->b408(2,$o513);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function k56($l514,$o515){try{$l372=t0();$b383=$l372->k384('UPDATE ct_options SET big_master_product_price = ?, master_product_price = ?');$b383->b408(1,$l514);$b383->b408(2,$o515);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function u57($m516,$f517,$e380,$t518){try{$l372=t0();$b383=$l372->k384("UPDATE ct_options SET $e380 = ?, $t518 = ?");$b383->b408(1,$m516);$b383->b408(2,$f517);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function r58($j411,$o412,$m402,$l415,$m519,$f520,$v407,$q459='0',$z400,$q521,$w500,$t403,$g522,$p523='0',$b524='0',$x525='0',$t501,$h526,$b527,$j528){$m454=time();try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_users (firstname, lastname, email, phone, state, address, password, references_id, level, time_signin, status, percentage, master_user, username, password_default, enterprise, logo, currency, bigmaster_user, prepaye, mariage_gratis, details) VALUES (? ,? ,?, ? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,?)');$b383->b408(1,$j411);$b383->b408(2,$o412);$b383->b408(3,$m402);$b383->b408(4,$l415);$b383->b408(5,$m519);$b383->b408(6,$f520);$b383->b408(7,$v407);$b383->b408(8,$q459);$b383->b408(9,$t403);$b383->b408(10,$m454);$b383->b408(11,$z400);$b383->b408(12,$q521);$b383->b408(13,$w500);$b383->b408(14,$g522);$b383->b408(15,$v407);$b383->b408(16,$p523);$b383->b408(17,$b524);$b383->b408(18,$x525);$b383->b408(19,$t501);$b383->b408(20,$h526);$b383->b408(21,$b527);$b383->b408(22,$j528);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function c59(){$g381=t0();$h382="SELECT * FROM ct_ticket WHERE master_user = 'Clients' order by id ASC";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function i60($r529){$g381=t0();$h382="SELECT * FROM ct_options";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388[$r529];}if(isset($g389)){if($g389=='0'){$z400='';}elseif($g389=='1'){$z400='checked';}return $z400;}}function m61($t530,$z531){$z400="0";if(strlen($t530)==3){$i532=$t530[0];$a533=$t530[1];$y534=$t530[2];if(strpos($z531,$i532)!==false&&strpos($z531,$a533)!==false&&strpos($z531,$y534)!==false){$z400="1";}else{$z400="0";}return $z400;}}function l62($t530){if(strlen($t530)==3){$i532=$t530[0];$a533=$t530[1];$y534=$t530[2];return $i532.$a533.$y534;}}function z63($t530){if(strlen($t530)==3){$i532=$t530[0];$a533=$t530[2];$y534=$t530[1];return $i532.$a533.$y534;}}function t64($t530){if(strlen($t530)==3){$i532=$t530[1];$a533=$t530[0];$y534=$t530[2];return $i532.$a533.$y534;}}function c65($t530){if(strlen($t530)==3){$i532=$t530[1];$a533=$t530[2];$y534=$t530[0];return $i532.$a533.$y534;}}function t66($t530){if(strlen($t530)==3){$i532=$t530[2];$a533=$t530[0];$y534=$t530[1];return $i532.$a533.$y534;}}function c67($t530){if(strlen($t530)==3){$i532=$t530[2];$a533=$t530[1];$y534=$t530[0];return $i532.$a533.$y534;}}function l68($h508,$d456,$f460,$w500,$t501){$g381=t0();$h382="SELECT price FROM ct_product_price WHERE product = '$h508' AND game = '$d456'
AND ((level = '0' AND reference_user = '0') OR (level = '0' AND reference_user = '$f460') OR (level = '0' AND reference_user = '$w500') OR (level = '0' AND reference_user = '$t501')
OR (id_user = '$t501' AND reference_user = '0') OR (id_user = '$t501' AND reference_user = '$f460') OR (id_user = '$t501' AND reference_user = '$w500') OR (id_user = '$f460' AND reference_user = '0')
OR (id_user = '$w500' AND reference_user = '0') OR (id_user = '$w500' AND reference_user = '$f460')) ORDER BY id DESC LIMIT 1";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['price'];}if(isset($g389)){return $g389;}}function e69($h508,$d456,$f460,$w500,$t501){$l514=g2('big_master_product_price');$o515=g2('master_product_price');if(j338('ct_product_price','level','0','reference_user',$f460,'product',$h508,'game',$d456,'level')=='0'){$e535=j338('ct_product_price','level','0','reference_user',$f460,'product',$h508,'game',$d456,'price');}elseif(j338('ct_product_price','level','0','reference_user',$w500,'product',$h508,'game',$d456,'level')=='0'){$e535=j338('ct_product_price','level','0','reference_user',$w500,'product',$h508,'game',$d456,'price');}elseif(j338('ct_product_price','level','0','reference_user',$t501,'product',$h508,'game',$d456,'level')=='0'){$e535=j338('ct_product_price','level','0','reference_user',$t501,'product',$h508,'game',$d456,'price');}elseif(j338('ct_product_price','id_user',$t501,'reference_user',$f460,'product',$h508,'game',$d456,'level')=='1'&&$l514=='1'){$e535=j338('ct_product_price','id_user',$t501,'reference_user',$f460,'product',$h508,'game',$d456,'price');}elseif(j338('ct_product_price','id_user',$t501,'reference_user',$w500,'product',$h508,'game',$d456,'level')=='1'&&$l514=='1'){$e535=j338('ct_product_price','id_user',$t501,'reference_user',$w500,'product',$h508,'game',$d456,'price');}elseif(j338('ct_product_price','id_user',$w500,'reference_user',$f460,'product',$h508,'game',$d456,'level')=='2'&&$o515=='1'){$e535=j338('ct_product_price','id_user',$w500,'reference_user',$f460,'product',$h508,'game',$d456,'price');}elseif(j338('ct_product_price','id_user',$w500,'reference_user','0','product',$h508,'game',$d456,'level')=='2'&&$o515=='1'){$e535=j338('ct_product_price','id_user',$w500,'reference_user','0','product',$h508,'game',$d456,'price');}elseif(j338('ct_product_price','id_user',$t501,'reference_user','0','product',$h508,'game',$d456,'level')=='1'&&$l514=='1'){$e535=j338('ct_product_price','id_user',$t501,'reference_user','0','product',$h508,'game',$d456,'price');}else{$e535=j338('ct_product_price','level','0','reference_user','0','product',$h508,'game',$d456,'price');}return $e535;}function i70($c536="name ASC",$o388="show"){$g381=t0();$h382="SELECT * FROM ct_sortition WHERE status = '1' order by $c536";$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();return $c386;}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function q71($f460,$q461,$o388="show"){$g381=t0();$h382="SELECT * FROM ct_sortition_user WHERE id_user = '$f460' AND reference_user = '$q461' order by name ASC";$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();return $c386;}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function d72($q459,$o388){$g381=t0();$h382="SELECT DISTINCT(id_user) FROM ct_results WHERE reference_id = '$q459' AND level ='1'";$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();return $c386;}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function h73($d456,$q458,$s457){$g381=t0();$h382="SELECT numbers FROM ct_results WHERE game = '$d456' AND date_result = '$q458' AND type = '$s457'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['numbers'];}if(isset($g389)){return $g389;}}function r74($g377,$o537,$f538,$k539,$x540,$i541,$o388,$a455,$s457,$j497="",$g522="",$c471=""){$x540=htmlspecialchars_decode($x540,ENT_QUOTES);if(trim($x540)!=''){$i542="AND lot in ($x540)";}else{$i542='';}$y543='';$c471=trim($c471);if($c471!=''){$h544="AND winning = '$c471'";}else{$h544='';}$j497=trim($j497);if($j497!=''){$k545="AND option_lot = '$j497'";}else{$k545='';}$s457=trim($s457);if($s457!=''){$w546="AND type = '$s457'";}else{$w546='';}$a455=trim($a455);if($a455!=''){$z547="AND numbers = '$a455'";}else{$z547='';}$u548=z154('ct_users','username',$g522,'id');$m549=z154('ct_users','username',$g522,'level');if($m549=='0'){$j550="AND bigmaster_user = '$u548'";}elseif($m549=='1'){$j550="AND bigmaster_user = '$u548'";}elseif($m549=='2'){$j550="AND master_user = '$u548'";}elseif($m549=='3'){$j550="AND id_agent = '$u548'";}if(isset($_SESSION['said'])){if($o537=='1'){if($g522!=""){$y543=$j550;}$e551="";}elseif($o537=='2'){if($g522!=""){$y543=$j550;}$e551="";}elseif($o537=='3'){if($g522!=""){$y543=$j550;}$e551="";}else{$y543="";$e551="";}}elseif(isset($_SESSION['aid'])){if($o537=='2'){if($g522!=""){$y543=$j550;}$e551="AND (bigmaster_user = '$g377')";}elseif($o537=='3'){if($g522!=""){$y543=$j550;}$e551="AND (master_user = '$g377' OR bigmaster_user = '$g377')";}else{$e551="AND (master_user = '$g377' OR bigmaster_user = '$g377')";}}elseif(isset($_SESSION['mid'])){if($o537=='3'){if($g522!=""){$y543=$j550;}$e551="AND (master_user = '$g377')";}else{$e551="AND (master_user = '$g377')";}}if($o388=='count'){$i541='';}$h552=$f538;$b553=$k539;$p554=str_replace('/','-',$f538);$n555=str_replace('/','-',$k539);$f538=strtotime($p554);$k539=strtotime($n555);$k539=$k539+86399;$q556=gmdate("m-d-Y",$f538);$k557=gmdate("m-d-Y",$k539);$g381=t0();if($f538==$k539){$h382="SELECT * FROM ct_ticket WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' AND status != '3' $w546 $z547 $i542 $y543 $e551 $k545 $h544 ORDER BY numbers $i541";}else{$h382="SELECT * FROM ct_ticket WHERE time_signin >= '$f538' AND time_signin <= '$k539' AND status != '3' $w546 $z547 $i542 $y543 $e551 $k545 $h544 ORDER BY numbers $i541";}$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['numbers'];}if(isset($g389)){return $g389;}}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function n75($f460,$q458){$g381=t0();$h382="SELECT DISTINCT reference_user FROM ct_results WHERE id_user = '$f460' AND date_result = '$q458'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function y76($u431){$u431=strtoupper(str_replace(' ','',$u431));$g381=t0();$h382="SELECT * FROM ct_sortition WHERE lot = '$u431'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['name'];}if(isset($g389)){return $g389;}}function s77($w558,$h433){$g381=t0();$h382="SELECT max(time_signin) as last FROM ct_ticket_status WHERE id_agent = '$w558' AND date_time = '$h433'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['last'];}if(isset($g389)){return $g389;}else{return 0;}}function d78($w558,$f538,$k539){if(trim($w558)!=''){$u559="AND reference_user = '$w558'";}else{$u559="";}$h552=$f538;$b553=$k539;$p554=str_replace('/','-',$f538);$n555=str_replace('/','-',$k539);$f538=strtotime($p554);$k539=strtotime($n555);$k539=$k539+86399;$q556=gmdate("m-d-Y",$f538);$k557=gmdate("m-d-Y",$k539);$g381=t0();if($f538==$k539){$h382="SELECT sum(amount_pay) as total FROM ct_transactions WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' $u559";}else{$h382="SELECT sum(amount_pay) as total FROM ct_transactions WHERE time_signin >= '$f538' AND time_signin <= '$k539' $u559";}$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['total'];}if(isset($g389)){return $g389;}else{return 0;}}function l79($f460,$f538,$k539){$h552=$f538;$b553=$k539;$p554=str_replace('/','-',$f538);$n555=str_replace('/','-',$k539);$f538=strtotime($p554);$k539=strtotime($n555);$k539=$k539+86399;$q556=gmdate("m-d-Y",$f538);$k557=gmdate("m-d-Y",$k539);$g381=t0();if($f538==$k539){$h382="SELECT sum(amount_pay) as total FROM ct_transactions WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' AND id_user = '$f460' ";}else{$h382="SELECT sum(amount_pay) as total FROM ct_transactions WHERE time_signin >= '$f538' AND time_signin <= '$k539' AND id_user = '$f460' ";}$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['total'];}if(isset($g389)){return $g389;}else{return 0;}}function d80($f460){$g381=t0();$h382="SELECT sum(amount_pay) as total FROM ct_transactions WHERE id_user = '$f460'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['total'];}if(isset($g389)){return $g389;}else{return 0;}}function d81($w558){$g381=t0();$h382="SELECT sum(amount) as total FROM ct_ticket WHERE id_agent = '$w558' AND status != '3'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['total'];}if(isset($g389)){return $g389;}else{return 0;}}function z82($o388,$w558){$g381=t0();$h382="SELECT sum($o388) as total FROM ct_ticket WHERE id_agent = '$w558' AND status != '3'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['total'];}if(isset($g389)){return $g389;}else{return 0;}}function i83($w558){$g381=t0();$h382="SELECT sum(prize) as total FROM ct_ticket WHERE id_agent = '$w558' AND status != '3'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['total'];}if(isset($g389)){return $g389;}else{return 0;}}function f84($f460){$g381=t0();$h382="SELECT sum(amount) as total FROM ct_ticket WHERE master_user = '$f460' AND status != '3'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['total'];}if(isset($g389)){return $g389;}else{return 0;}}function p85($f460){$g381=t0();$h382="SELECT sum(commission_agent) as total FROM ct_ticket WHERE master_user = '$f460' AND status != '3'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['total'];}if(isset($g389)){return $g389;}else{return 0;}}function t86($f460){$g381=t0();$h382="SELECT sum(prize) as total FROM ct_ticket WHERE master_user = '$f460' AND status != '3'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['total'];}if(isset($g389)){return $g389;}else{return 0;}}function f87($g377){$g381=t0();$h382="SELECT * FROM ct_product_price WHERE id_user = '$g377' order by id DESC";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function z88($g377,$q560){$g381=t0();if($q560=='1'){$u561="(level = '0' AND reference_user = '$g377')";}elseif($q560=='2'){$u561="id_user = '$g377'";}elseif($q560=='3'){$u561="(level = '0' AND reference_user = '0')";}$h382="SELECT * FROM ct_product_price WHERE $u561 order by id DESC";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function p89($g377,$w500,$q560){$g381=t0();if($q560=='1'){$u561="(level = '0' AND reference_user = '$g377')";}elseif($q560=='2'){$u561="(level = '0' AND reference_user = '$w500')";}if($q560=='3'){$u561="(level = '1' AND reference_user = '$g377')";}elseif($q560=='4'){$u561="id_user = '$g377'";}if($q560=='5'){$u561="(level = '1' AND id_user = '$w500')";}elseif($q560=='6'){$u561="(level = '0' AND reference_user = '0')";}$h382="SELECT * FROM ct_product_price WHERE id_user = '$g377' OR (level = '0' AND reference_user = '0') OR reference_user = '$g377' OR reference_user = '$w500' order by id DESC";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function n90($g377){$g381=t0();$h382="SELECT * FROM ct_limitations WHERE master_user = '$g377' order by type DESC";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function q91($g377){$g381=t0();$h382="SELECT * FROM ct_limitations_transactions WHERE id_user = '$g377' order by type DESC";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function m92($g377){$g381=t0();$h382="SELECT * FROM ct_limitations_transactions WHERE id_user = '$g377' AND reference_user ='0'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['play'];}if(isset($g389)){return $g389;}else{return 0;}}function b93($g377,$s457){$g381=t0();$h382="SELECT * FROM ct_limitations WHERE type = 'default_play' AND options = '$s457' AND master_user = '$g377' AND reference_user = '0'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['play'];}if(isset($g389)){return $g389;}else{return 0;}}function c94($s457,$d456,$q461,$r529,$j562,$a455){$g381=t0();$h382="SELECT * FROM ct_limitations WHERE type = '$j562' AND options = '$s457' AND game = '$d456' AND reference_user = '$q461' AND numbers = '$a455'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388[$r529];}if(isset($g389)){return $g389;}}function c95($s457,$d456,$w500,$q461,$r529,$j562,$a455){$g381=t0();$h382="SELECT * FROM ct_limitations WHERE type = '$j562' AND options = '$s457' AND game = '$d456' AND master_user = '$w500' AND reference_user = '$q461' AND numbers = '$a455'";$b383=$g381->k384($h382);$b383->u385();if($r529!=''){$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388[$r529];}if(isset($g389)){return $g389;}}else{$f448=$b383->y449();$b383->u450();return $f448;}}function l96($s457){if($s457=='ALL'){$e563='Tous';}else{$e563=$s457;}if(isset($e563)){return $e563;}}function u97($o494){if($o494=='0'){$e563='Tous les utilisateurs';}else{$i564=z154('ct_users','id',$o494,'username').' (<b>'.z154('ct_users','id',$o494,'enterprise').'</b>)';$e563=$i564;}if(isset($e563)){return $e563;}}function y98($s457){if($s457=='DIRECTO'){$e563='Borlette';}elseif($s457=='PALE'){$e563='Mariage';}elseif($s457=='PALE_GR'){$e563='Mariage Gratis';}elseif($s457=='CASH 3'){$e563='Loto 3';}elseif($s457=='PICK 3 BOX'){$e563='PICK 3 BOX';}elseif($s457=='PLAY 4'){$e563='Loto 4';}elseif($s457=='PICK 5'){$e563='Loto 5';}elseif($s457=='PICK 2'){$e563='PICK 2';}if(isset($e563)){return $e563;}}function s99($s457){if($s457=='_directo'){$e563='Borlette';}elseif($s457=='_pale'){$e563='Mariage';}elseif($s457=='_cash3'){$e563='Loto 3';}elseif($s457=='_pick3box'){$e563='PICK 3 BOX';}elseif($s457=='_play4'){$e563='Loto 4';}elseif($s457=='_pick5'){$e563='Loto 5';}elseif($s457=='_pick2'){$e563='PICK 2';}elseif($s457=='0'){$e563='Personnalise';}if(isset($e563)){return $e563;}}function w100($h508){if($h508=='firstlot'){$e563='Borlette 1er Lot';}elseif($h508=='secondlot'){$e563='Borlette 2me Lot';}elseif($h508=='thirdlot'){$e563='Borlette 3me Lot';}elseif($h508=='mariage'){$e563='Mariage';}elseif($h508=='cash3'){$e563='Loto 3';}elseif($h508=='pick2'){$e563='Pick 2 Florida';}elseif($h508=='pick3'){$e563='Pick 3 Box';}elseif($h508=='loto4_1'){$e563='Loto 4 - Option 1';}elseif($h508=='loto4_2'){$e563='Loto 4 - Option 2';}elseif($h508=='loto4_3'){$e563='Loto 4 - Option 3';}elseif($h508=='loto5_1'){$e563='Loto 5 - Option 1';}elseif($h508=='loto5_2'){$e563='Loto 5 - Option 2';}elseif($h508=='loto5_3'){$e563='Loto 5 - Option 3';}elseif($h508=='mariage_gratis'){$e563='Prix Mariage gratis';}elseif($h508=='mariage_gratis_amount'){$e563='Montant Cond. Mariage Gratis';}elseif($h508=='mariage_gratis_quantite'){$e563='Quantit Mariage Gratis';}if(isset($e563)){return $e563;}}function b101($s457,$d456,$t465,$r529,$j562,$a455){$g381=t0();$h382="SELECT * FROM ct_limitations WHERE type = '$j562' AND options = '$s457' AND game = '$d456' $t465 AND numbers = '$a455' AND reference_user = '0'";$b383=$g381->k384($h382);$b383->u385();if($r529!=''){$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388[$r529];}if(isset($g389)){return $g389;}}else{$f448=$b383->y449();$b383->u450();return $f448;}}function z102($g377,$s457,$d456,$q461,$j562,$a455){$g381=t0();$h382="SELECT * FROM ct_limitations WHERE type = '$j562' AND options = '$s457' AND game = '$d456' AND master_user = '$g377' AND reference_user = '$q461' AND numbers = '$a455'";$b383=$g381->k384($h382);$b383->u385();$f448=$b383->y449();$b383->u450();return $f448;}function l103(){$s565=rand(100000,999999);return $s565;}function a104($f460,$o412,$j411,$u566,$j567,$u568,$u569,$f404,$o570,$l415,$m571,$h433){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_cv_infos (id_user,lastname,firstname,location,country,city,sex,about,date_time,views,phone,category) VALUES (? ,? ,?, ? ,? ,? ,? ,? ,? ,? ,? ,?)');$b383->b408(1,$f460);$b383->b408(2,$o412);$b383->b408(3,$j411);$b383->b408(4,$u566);$b383->b408(5,$j567);$b383->b408(6,$u568);$b383->b408(7,$u569);$b383->b408(8,$f404);$b383->b408(9,$h433);$b383->b408(10,$o570);$b383->b408(11,$l415);$b383->b408(12,$m571);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function x105($f460,$z572,$f573,$m574,$t575,$a576,$i462,$h433){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_cv_education (id_user,degree,qualification,education_start_date,education_end_date,institute,description,date_time) VALUES (? ,? ,?, ? ,? ,? ,? ,?)');$b383->b408(1,$f460);$b383->b408(2,$z572);$b383->b408(3,$f573);$b383->b408(4,$m574);$b383->b408(5,$t575);$b383->b408(6,$a576);$b383->b408(7,$i462);$b383->b408(8,$h433);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function v106($f460,$u577,$d578,$w579,$a576,$i462,$f580){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_cv_workexperience (id_user,job_post,job_start_date,job_end_date,institute,description,date_time) VALUES (? ,? ,?, ? ,? ,? ,?)');$b383->b408(1,$f460);$b383->b408(2,$u577);$b383->b408(3,$d578);$b383->b408(4,$w579);$b383->b408(5,$a576);$b383->b408(6,$i462);$b383->b408(7,$f580);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function y107($x429,$f460,$u581,$h433){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_job_candidates (id_job,id_user,compatibility,date_time) VALUES (? ,? ,?, ?)');$b383->b408(1,$x429);$b383->b408(2,$f460);$b383->b408(3,$u581);$b383->b408(4,$h433);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function z108($f460,$v582,$z438,$i462,$f580){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_cv_skills (id_user,skills,value,description,date_time) VALUES (? ,? ,?, ? ,?)');$b383->b408(1,$f460);$b383->b408(2,$v582);$b383->b408(3,$z438);$b383->b408(4,$i462);$b383->b408(5,$f580);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function b109($y583,$r584,$h509,$a585,$f586){$g377=z154('ct_immersion','id','1','id');if($g377!=''){$l372=t0();$b383=$l372->k384('UPDATE ct_immersion SET adventure = ?, duration = ?, price = ?, time_limit = ?, reservation_button_link = ? WHERE id = ?');$b383->b408(1,$y583);$b383->b408(2,$r584);$b383->b408(3,$h509);$b383->b408(4,$a585);$b383->b408(5,$f586);$b383->b408(6,$g377);if($b383->u385()){return 1;}else{return 0;}}else{try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_immersion (adventure,duration,price,time_limit,reservation_button_link) VALUES (? ,?, ? ,? ,?)');$b383->b408(1,$y583);$b383->b408(2,$r584);$b383->b408(3,$h509);$b383->b408(4,$a585);$b383->b408(5,$f586);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}}function f110($n587,$w588,$i589,$j590,$f580,$f591,$x592){try{$l372=t0();$b383=$l372->k384('UPDATE ct_blog SET title = ?, descs = ?, texts = ?, date_modif = ?, photos = ?, author_id = ? WHERE pid = ?');$b383->b408(1,$n587);$b383->b408(2,$i589);$b383->b408(3,$j590);$b383->b408(4,$f580);$b383->b408(5,$w588);$b383->b408(6,$f591);$b383->b408(7,$x592);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function r111($j411,$o412,$m402,$l415,$m519,$f520,$q521,$g522,$g377,$b524,$p523,$h526,$b527,$j528){try{$l372=t0();$b383=$l372->k384('UPDATE ct_users SET firstname = ?, lastname = ?, email = ?, phone = ?, state = ?, address = ? , percentage = ? , username = ? , enterprise = ? , logo = ? , prepaye = ? , mariage_gratis = ?, details = ? WHERE id = ?');$b383->b408(1,$j411);$b383->b408(2,$o412);$b383->b408(3,$m402);$b383->b408(4,$l415);$b383->b408(5,$m519);$b383->b408(6,$f520);$b383->b408(7,$q521);$b383->b408(8,$g522);$b383->b408(9,$p523);$b383->b408(10,$b524);$b383->b408(11,$h526);$b383->b408(12,$b527);$b383->b408(13,$j528);$b383->b408(14,$g377);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function o112($b593,$g594,$h595,$z596,$n597,$r598,$f599,$f591,$o570,$d600,$e601,$b602){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_event (title,descs,date_event,start_hour,end_hour,location,photos,author_id,views,url_id,attendance,reservation_link) VALUES (?, ? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,?)');$b383->b408(1,$b593);$b383->b408(2,$f599);$b383->b408(3,$g594);$b383->b408(4,$h595);$b383->b408(5,$z596);$b383->b408(6,$n597);$b383->b408(7,$r598);$b383->b408(8,$f591);$b383->b408(9,$o570);$b383->b408(10,$d600);$b383->b408(11,$e601);$b383->b408(12,$b602);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function n113($b593,$f599,$g594,$h595,$z596,$n597,$r598,$e601,$b602,$g377){try{$l372=t0();$b383=$l372->k384('UPDATE ct_event SET title = ?, descs = ?, date_event = ?, start_hour = ?, end_hour = ?, location = ?, photos = ?, attendance = ?, reservation_link = ? WHERE id = ?');$b383->b408(1,$b593);$b383->b408(2,$f599);$b383->b408(3,$g594);$b383->b408(4,$h595);$b383->b408(5,$z596);$b383->b408(6,$n597);$b383->b408(7,$r598);$b383->b408(8,$e601);$b383->b408(9,$b602);$b383->b408(10,$g377);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function t114($f460,$m603,$e604,$s605,$u566,$g606,$x525,$u569,$j567,$u568,$p607,$p608,$n609,$k610,$i462,$q611,$y612,$h433,$z400,$k613){try{$l372=t0();$b383=$l372->k384('INSERT INTO `ct_job`(`id_user`, `title`, `type`, `category`, `location`, `salary`, `currency`, `gender`, `country`, `city`, `niveau`, `view`, `qualification_exigence`, `experience`, `description`, `date_limit`, `link`, `date_time`, `status`, `applied`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)');$b383->b408(1,$f460);$b383->b408(2,$m603);$b383->b408(3,$e604);$b383->b408(4,$s605);$b383->b408(5,$u566);$b383->b408(6,$g606);$b383->b408(7,$x525);$b383->b408(8,$u569);$b383->b408(9,$j567);$b383->b408(10,$u568);$b383->b408(11,$p607);$b383->b408(12,$p608);$b383->b408(13,$n609);$b383->b408(14,$k610);$b383->b408(15,$i462);$b383->b408(16,$q611);$b383->b408(17,$y612);$b383->b408(18,$h433);$b383->b408(19,$z400);$b383->b408(20,$k613);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function m115($n587,$w588,$i589,$j590,$f580,$f591,$o570,$d600){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_blog (title,descs,texts,date_time,photos,author_id,views,url_id) VALUES (? ,?, ? ,? ,? ,?,? ,?)');$b383->b408(1,$n587);$b383->b408(2,$i589);$b383->b408(3,$j590);$b383->b408(4,$f580);$b383->b408(5,$w588);$b383->b408(6,$f591);$b383->b408(7,$o570);$b383->b408(8,$d600);if($b383->u385()===true){return $l372->v409('pid');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function j116($h614,$s457,$h433){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_payment (id_transaction,type,date_time) VALUES (? ,?, ?)');$b383->b408(1,$h614);$b383->b408(2,$s457);$b383->b408(3,$h433);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function b117($m615,$i541='6'){$g377=$_SESSION['id'];$g381=t0();$h382="SELECT * FROM ct_users WHERE level ='2' OR level ='3' AND (firstname LIKE '$m615%' or lastname LIKE '$m615%' or email LIKE '$m615%') LIMIT ".$i541."";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function n118($m615,$s616=false,$l617='search result',$t618='search results'){$g381=t0();$g377=$_SESSION['id'];$h382="SELECT COUNT(*) AS count FROM ct_users WHERE firstname LIKE '$m615%' or lastname LIKE '$m615%' or email LIKE '$m615%'";$b383=$g381->k384($h382);$b383->u385();$f448=$b383->n619();$f448=$f448['count'];if($s616){if($f448==0){$f448=$f448.' '.$l617;}elseif($f448==1){$f448=$f448.' '.$l617;}else{$f448=$f448.' '.$t618;}}return $f448;}function g119($i564,$l405,$f404,$s457,$g620){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_team (name,role,about,type,photos) VALUES (? ,?, ? ,? ,?)');$b383->b408(1,$i564);$b383->b408(2,$l405);$b383->b408(3,$f404);$b383->b408(4,$s457);$b383->b408(5,$g620);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function k120($e621,$o622,$g377){try{$l372=t0();$b383=$l372->k384('UPDATE ct_options SET site_name = ?, site_logo = ?, site_favicon = ? WHERE id = ?');$b383->b408(1,$e621);$b383->b408(2,$o622);$b383->b408(3,$o622);$b383->b408(4,$g377);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function k121($w623,$q459,$l466,$z496,$x525,$s457,$h433){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_transaction (payment_id,reference_id,serial_number,amount,currency,type,date_time) VALUES (? ,?, ? ,? ,? ,? ,?)');$b383->b408(1,$w623);$b383->b408(2,$q459);$b383->b408(3,$l466);$b383->b408(4,$z496);$b383->b408(5,$x525);$b383->b408(6,$s457);$b383->b408(7,$h433);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function n122($h614,$s457,$z496,$h433,$z400,$b624,$f460,$x429){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_payment (id_transaction,type,amount,date_time,status,note, id_user, id_job) VALUES (? ,?, ? ,? ,? ,? ,?,?)');$b383->b408(1,$h614);$b383->b408(2,$s457);$b383->b408(3,$z496);$b383->b408(4,$h433);$b383->b408(5,$z400);$b383->b408(6,$b624);$b383->b408(7,$f460);$b383->b408(8,$x429);if($b383->u385()===true){return $l372->v409('id_transaction');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function o123($i401,$l405,$y625,$x424){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_testimonial (fullname,role,texts,image) VALUES (? ,?, ? ,?)');$b383->b408(1,$i401);$b383->b408(2,$l405);$b383->b408(3,$y625);$b383->b408(4,$x424);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function x124($i564,$l405,$m626){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_community (enterprise,role,logo) VALUES (? ,?, ?)');$b383->b408(1,$i564);$b383->b408(2,$l405);$b383->b408(3,$m626);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function d125($i627,$i564,$l405,$f404,$s457,$g620){try{$l372=t0();$b383=$l372->k384('UPDATE ct_team SET name = ?, role = ?, about = ?, type = ?, photos = ? WHERE id = ?');$b383->b408(1,$i564);$b383->b408(2,$l405);$b383->b408(3,$f404);$b383->b408(4,$s457);$b383->b408(5,$g620);$b383->b408(6,$i627);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function r126($i627,$i401,$l405,$y625,$x424){try{$l372=t0();$b383=$l372->k384('UPDATE ct_testimonial SET fullname = ?, role = ?, texts = ?, image = ? WHERE id = ?');$b383->b408(1,$i401);$b383->b408(2,$l405);$b383->b408(3,$y625);$b383->b408(4,$x424);$b383->b408(5,$i627);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function a127($i627,$s628,$f629,$m626){try{$l372=t0();$b383=$l372->k384('UPDATE ct_community SET enterprise = ?, role = ?, logo = ? WHERE id = ?');$b383->b408(1,$s628);$b383->b408(2,$f629);$b383->b408(3,$m626);$b383->b408(4,$i627);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function y128($g377){$l372=t0();$h382='DELETE FROM ct_limitations WHERE id= :id';$b383=$l372->k384($h382);if($b383->u385(array(':id'=>$g377))===true){return 1;}else{return 0;}}function f129($g377){$l372=t0();$h382='DELETE FROM ct_limitations_transactions WHERE id= :id';$b383=$l372->k384($h382);if($b383->u385(array(':id'=>$g377))===true){return 1;}else{return 0;}}function t130($g377){$l372=t0();$h382='DELETE FROM ct_product_price WHERE id= :id';$b383=$l372->k384($h382);if($b383->u385(array(':id'=>$g377))===true){return 1;}else{return 0;}}function x131($u431){$l372=t0();$h382='DELETE FROM ct_sortition WHERE lot= :lot';$b383=$l372->k384($h382);if($b383->u385(array(':lot'=>$u431))===true){return 1;}else{return 0;}}function t132($i627){$l372=t0();$h382='DELETE FROM ct_testimonial WHERE id= :id';$b383=$l372->k384($h382);$b383->u385(array(':id'=>$i627));}function w133($i627){$l372=t0();$h382='DELETE FROM ct_team WHERE id= :id';$b383=$l372->k384($h382);$b383->u385(array(':id'=>$i627));}function y134($x592){$l372=t0();$h382='DELETE FROM ct_blog WHERE pid= :pid';$b383=$l372->k384($h382);$b383->u385(array(':pid'=>$x592));}function j135($x592){$l372=t0();$h382='DELETE FROM ct_event WHERE id= :pid';$b383=$l372->k384($h382);$b383->u385(array(':pid'=>$x592));}function s136($i627){$l372=t0();$h382='DELETE FROM ct_community WHERE id= :id';$b383=$l372->k384($h382);$b383->u385(array(':id'=>$i627));}function c137($i564,$z438,$s630){$b631=z154('ct_page_element','name',$i564,'name');if($i564==$b631){$l372=t0();$b383=$l372->k384("UPDATE `ct_page_element` SET `value`= '$z438' WHERE name= '$i564'");if($b383->u385()){return 1;}else{return 0;}}else{try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_page_element (name, value, page) VALUES (? ,? ,?)');$b383->b408(1,$i564);$b383->b408(2,$z438);$b383->b408(3,$s630);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}}function d138($l617){$s632=" ";$p633=strstr(strtolower($l617),$s632,true);$s634=substr(strstr(strtolower($l617),$s632,false),0,3);$d635=rand(0,100);$g522=trim($p633).trim($s634).trim($d635);return $g522;}function a139($i564,$y612){$b631=z154('ct_medias','name',$i564,'name');if($i564==$b631){$l372=t0();$b383=$l372->k384("UPDATE `ct_medias` SET `link`= '$y612' WHERE name= '$i564'");if($b383->u385()){return 1;}else{return 0;}}else{try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_medias (name, link) VALUES (? ,?)');$b383->b408(1,$i564);$b383->b408(2,$y612);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}}function p140($i564,$z438){$b631=z154('ct_informations','name',$i564,'name');if($i564==$b631){$l372=t0();$b383=$l372->k384("UPDATE `ct_informations` SET `value`= '$z438' WHERE name= '$i564'");if($b383->u385()){return 1;}else{return 0;}}else{try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_informations (name, value) VALUES (? ,?)');$b383->b408(1,$i564);$b383->b408(2,$z438);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}}function c141($x437){$g381=t0();$h382="SELECT * FROM ct_page_element WHERE page ='$x437'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function h142($g377){$l372=t0();$h382='UPDATE users SET active = :num WHERE id = :id';$b383=$l372->k384($h382);$b383->u385(array(':num'=>1,':id'=>$g377));}function v143(){if(isset($_SERVER['HTTPS'])){$k636=($_SERVER['HTTPS']&&$_SERVER['HTTPS']!='off')?'https':'http';}else{$k636='http';}return $k636.'://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'];}function s144($z637,$k638=false){if($k638){header('HTTP/1.1 301 Moved Permanently');}header('Location: '.$z637);exit();}function d145($z438){$x437=''.number_format($z438,2);return $x437;}function x146($z438){$x437=''.number_format($z438,0);return $x437;}function r147($z438){$x437=number_format($z438,2,'.','');return $x437;}function s148($z438){$x437=number_format($z438,2,'.',' ');return $x437;}function z149($z438){return number_format($z438,2);}function k150(){if($_SERVER['SERVER_NAME']=='localhost'){$z637=v143();$t639=explode('/',$z637);$z637=$t639[0].'/'.$t639[1].'/'.$t639[2].'/'.$t639[3].'';}else{$z637=v143();$t639=explode('/',$z637);$z637=$t639[0].'/'.$t639[1].'/'.$t639[2].'';}return $z637;}function f151($l640){$g381=t0();$h382="SELECT * FROM ct_job_lang WHERE id_job ='$l640'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function u152($f460){$g381=t0();$h382="SELECT * FROM ct_cv_lang WHERE id_user ='$f460'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function l153($l641){$g377=$_SESSION['id'];$g381=t0();$h382="SELECT * FROM ct_users WHERE id ='$g377'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();if($l641=='fullname'){foreach($c386 as $o388){$g389=$o388['firstname'].' '.$o388['lastname'];}}else{foreach($c386 as $o388){$g389=$o388[$l641];}}if(isset($g389)){return $g389;}}function z154($g642,$e380,$v643,$w644,$o388='show'){$g381=t0();$h382="SELECT * FROM $g642 WHERE $e380 ='$v643'";$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();if($w644=='fullname'){foreach($c386 as $o388){$g389=$o388['firstname'].' '.$o388['lastname'];}}else{foreach($c386 as $o388){$g389=$o388[$w644];}}if(isset($g389)){return $g389;}}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function o155(){$g381=t0();$h382='SELECT * FROM ct_options';$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function j156($s630,$k421){$y645='';$h646='';$z647='';$n648='';$o649='';$j650='';if($s630=='accueil'){$y645='active';}elseif($s630=='demandes'){$h646='active';}elseif($s630=='resultats'){$z647='active';}elseif($s630=='compte'){$n648='active';}elseif($s630=='utilisateurs'){$o649='active';}elseif($s630=='paiements'){$j650='active';}if($k421=='active0'){return $y645;}elseif($k421=='active1'){return $h646;}elseif($k421=='active2'){return $z647;}elseif($k421=='active3'){return $n648;}elseif($k421=='active4'){return $o649;}elseif($k421=='active5'){return $j650;}}function u157($l651){$l651+=3;$m652="0123456789";$s653="";$z654=strlen($m652);for($b655=0;$b655<$l651;$b655++){if($b655==5||$b655==11||$b655==17)$s653.='';else $s653 .= $m652[rand(0,$z654-1)];}return $s653;}function s158($i564=''){$v656=uniqid(rand(),true);$_SESSION[$i564.'_token']=$v656;return $v656;}function p159($v657,$i564=''){if(isset($_SESSION[$i564.'_token'])&&isset($_POST['token'])){if($_SESSION[$i564.'_token']==$_POST['token']){if(isset($_SERVER['HTTP_REFERER'])){if($_SERVER['HTTP_REFERER']==$v657){return true;}}}}return false;}function b160($i564=''){$z395=g2('site_url');$w658=mb_strlen($z395);if(isset($_SESSION[$i564.'_token'])&&isset($_POST['token'])){if($_SESSION[$i564.'_token']==$_POST['token']){if(isset($_SERVER['HTTP_REFERER'])){$p659=o315($_SERVER['HTTP_REFERER'],$m652=$w658,$r660=false,$b661='');if($p659==$z395){return true;}}}}return false;}function p161($v662,$b663,$i564=''){if(isset($_SESSION[$i564.'_token'])&&isset($_POST['token'])){if($_SESSION[$i564.'_token']==$_POST['token']){if(isset($_SERVER['HTTP_REFERER'])){if($_SERVER['HTTP_REFERER']==$v662||$_SERVER['HTTP_REFERER']==$b663){return true;}}}}return false;}function b162($v662,$b663,$o664,$i564=''){if(isset($_SESSION[$i564.'_token'])&&isset($_POST['token'])){if($_SESSION[$i564.'_token']==$_POST['token']){if(isset($_SERVER['HTTP_REFERER'])){if($_SERVER['HTTP_REFERER']==$v662||$_SERVER['HTTP_REFERER']==$b663||$_SERVER['HTTP_REFERER']==$o664){return true;}}}}return false;}function j163($i564=''){if(isset($_SESSION[$i564.'_token'])&&isset($_GET['c'])){if($_SESSION[$i564.'_token']==$_GET['c']){return true;}}return false;}function z164($r435){return preg_match("/^\d+(?:\.\d{2})?$/",$r435);}function l165($j665){$i666='H:i:s';$b434=new \n667();$b434->a668($j665);return $b434->p669($i666);}function o166($t670,$f671,$m402){$i390=g2('site_name');$x440=m1();$h433=date("d-m-Y");$p523=trim(z154('ct_users','id',m1(),'enterprise'));$t670=$t670;$v656="-";$r672=new v673();$r672->$m674='[email protected]';$r672->$j675=$i390;$r672->$l676=$i390.' - Listes des Ventes '.$f671.' '.$h433;ob_start();include "../PHPMail/sales-list.php";$d677=ob_get_clean();$r672->u678($d677);$r672->$l679=$p523.', Rapport liste des ventes '.$h433;$r672->n680($m402,$p523);$r672->$u681='UTF-8';$r672->a682();}function i167($j411,$f683,$t670,$m402){$i390='';$y612='';$v656=sha1($j411.$m402);$r672=new v673();$r672->$m674='[email protected]';$r672->$j675=$i390;$r672->$l676=$i390.' - Code OTP changement d\'heure '.$t670;$s684='Code OPT pour changement d\'heure '.$t670.': '.$f683;$r672->u678($s684);$r672->$l679=$j411.' - Code OTP changement d\'heure '.$t670;$r672->n680($m402,$j411);$r672->$u681='UTF-8';$r672->a682();}function h168($i390,$z395,$h393,$j685,$j686,$a687,$o688){$g377=$_SESSION['aid'];$l372=t0();$b383=$l372->k384('UPDATE general_settings SET site_name = ?, site_url = ?, site_desc = ?, site_desc2 = ?, privacy = ?, email_noreply = ?, email_contact = ?');$b383->b408(1,$i390);$b383->b408(2,$z395);$b383->b408(3,$h393);$b383->b408(4,$j685);$b383->b408(5,$j686);$b383->b408(6,$a687);$b383->b408(7,$o688);if($b383->u385()===true){return 1;}else{return 0;}}function s169($u689,$n690,$g691,$s692,$q693,$j694,$l695,$i696,$k697,$c698,$f699,$t700,$h701,$b702,$f703,$i704){$g377=$_SESSION['aid'];$l372=t0();$b383=$l372->k384('UPDATE general_settings SET ads_1 = ?, ads_2 = ?, ads_3 = ?, ads_4 = ?, ads_link_1 = ?, ads_link_2 = ?, ads_link_3 = ?, ads_link_4 = ?, ads_text_1 = ?, ads_text_2 = ?, ads_text_3 = ?, ads_text_4 = ?, ads_img_1 = ?, ads_img_2 = ?, ads_img_3 = ?, ads_img_4 = ?');$b383->b408(1,$u689);$b383->b408(2,$n690);$b383->b408(3,$g691);$b383->b408(4,$s692);$b383->b408(5,$q693);$b383->b408(6,$j694);$b383->b408(7,$l695);$b383->b408(8,$i696);$b383->b408(9,$k697);$b383->b408(10,$c698);$b383->b408(11,$f699);$b383->b408(12,$t700);$b383->b408(13,$h701);$b383->b408(14,$b702);$b383->b408(15,$f703);$b383->b408(16,$i704);if($b383->u385()===true){return 1;}else{return 0;}}function z170($g377){$l372=t0();$b383=$l372->k384("UPDATE ct_event SET views = views+1 WHERE (id = ?)");$b383->b408(1,$g377);if($b383->u385()===true){return 1;}else{return 0;}}function i171($g377){$l372=t0();$b383=$l372->k384("UPDATE ct_job SET views = views+1 WHERE (id = ?)");$b383->b408(1,$g377);if($b383->u385()===true){return 1;}else{return 0;}}function i172($f460){$l372=t0();$b383=$l372->k384("UPDATE ct_cv_infos SET views = views+1 WHERE (id_user = ?)");$b383->b408(1,$f460);if($b383->u385()===true){return 1;}else{return 0;}}function o173($z637){$z637=str_replace('==','',$z637);return $z637;}function e174($x429){$l372=t0();$b383=$l372->k384("UPDATE ct_job SET applied = applied+1 WHERE (id = ?)");$b383->b408(1,$x429);if($b383->u385()===true){return 1;}else{return 0;}}function c175($x592){$l372=t0();$b383=$l372->k384("UPDATE ct_blog SET views = views+1 WHERE (date_time = ?)");$b383->b408(1,$x592);if($b383->u385()===true){return 1;}else{return 0;}}function d176($j665){$t705=$j665;$p706=time();$x707=$p706-$t705;$s708=$x707;$c709=round($s708/60);$g710=round($s708/3600);$o711=round($s708/86400);$m712=round($s708/604800);$v713=round($s708/2629440);$n714=round($s708/31553280);return utf8_encode(u179($j665)).', '.$g710.'hrs '.$c709.'min '.$s708.'sec';}function o177($j665){if(setlocale(LC_TIME,'fr_FR')==''){setlocale(LC_TIME,'FR');$h715='%#d';}else{$h715='%e';}$g716=strftime("%B",$j665);return $g716;}function v178($j665){if(setlocale(LC_TIME,'fr_FR')==''){setlocale(LC_TIME,'FR');$h715='%#d';}else{$h715='%e';}$g716=strftime("$h715",$j665);return $g716;}function u179($j665){if(setlocale(LC_TIME,'fr_FR')==''){setlocale(LC_TIME,'FR');$h715='%#d';}else{$h715='%e';}$g716=ucfirst(strftime("%A $h715 %B %Y",$j665));$k717=strftime("%a $h715 %b %Y %H heures %M minutes.",$j665);return $g716;}function c180($j665){if(setlocale(LC_TIME,'fr_FR')==''){setlocale(LC_TIME,'FR');$h715='%#d';}else{$h715='%e';}$g716=ucfirst(strftime("%A $h715 %B %Y",$j665));$k717=ucfirst(strftime("%a $h715 %b %Y %H heures %M minutes.",$j665));$p718=ucfirst(strftime("%a $h715 %b %Y - %H:%M:%S",$j665));return utf8_encode($p718);}function j181($g620){$g620=trim($g620);if($g620!=""&&$g620!="0"){$g620='<img src="../'.$g620.'" class="img-thumbnail" />';}else{$g620="";}return $g620;}function o182($g620,$z395){$g620=trim($g620);if($g620!=""&&$g620!="0"){$g620='<img src="'.$z395.$g620.'" class="img-thumbnail" />';}else{$g620="";}return $g620;}function s183($g620){if($g620!=''&&$g620!=0){$g620="../".$g620;$g620='<img src="'.$g620.'" class="img-thumbnail"/>';}else{$g620='';}return $g620;}function h184($t403){$v493='';if($t403=='0'){$v493="Non vrifi";}elseif($t403=='1'){$v493="Vrifi";}return $v493;}function k185($r435){$v493='';if($r435=='1'){$v493="Active";}elseif($r435=='0'){$v493="Inactive";}return $v493;}function d186($t403){if($t403=='1'){$v493="<b>Editeur</b> (Peut seulement publier des articles et des vnements.)";}elseif($t403=='2'){$v493="<b>Administrateur<b/> (Accs total a l'administration du site.)";}elseif($t403=='3'){$v493="<b>Administrateur Gnral</b> (Accs total a l'administration du site. Peut modifier des pages, ajouter, supprimer d'autres site)";}return $v493;}function e187($g642,$o388,$r529,$v719,$a720){$l372=t0();$b383=$l372->k384("UPDATE $g642 SET $o388 = ? WHERE ($v719 = ?)");$b383->b408(1,$r529);$b383->b408(2,$a720);if($b383->u385()===true){return 1;}else{return 0;}}function x188($g642,$o388,$r529,$v719,$f721,$a720,$p722){$l372=t0();$b383=$l372->k384("UPDATE $g642 SET $o388 = ? WHERE $v719 = ? AND $f721 = ?");$b383->b408(1,$r529);$b383->b408(2,$a720);$b383->b408(3,$p722);if($b383->u385()===true){return 1;}else{return 0;}}function w189($g642,$o388,$r529,$v719,$f721,$e723,$a720,$p722,$e724){$l372=t0();$b383=$l372->k384("UPDATE $g642 SET $o388 = ? WHERE $v719 = ? AND $f721 = ? AND $e723 = ?");$b383->b408(1,$r529);$b383->b408(2,$a720);$b383->b408(3,$p722);$b383->b408(4,$e724);if($b383->u385()===true){return 1;}else{return 0;}}function m190($g642,$o388,$r529,$v719,$f721,$e723,$d725,$a720,$p722,$e724,$e726){$l372=t0();$b383=$l372->k384("UPDATE $g642 SET $o388 = ? WHERE $v719 = ? AND $f721 = ? AND $e723 = ? AND $d725 = ?");$b383->b408(1,$r529);$b383->b408(2,$a720);$b383->b408(3,$p722);$b383->b408(4,$e724);$b383->b408(5,$e726);if($b383->u385()===true){return 1;}else{return 0;}}function g191($g642,$o388,$r529,$v719,$f721,$e723,$d725,$k727,$t728,$a720,$p722,$e724,$e726,$l729,$p730){$l372=t0();$b383=$l372->k384("UPDATE $g642 SET $o388 = ? WHERE $v719 = ? AND $f721 = ? AND $e723 = ? AND $d725 = ? AND $k727 = ? AND $t728 = ?");$b383->b408(1,$r529);$b383->b408(2,$a720);$b383->b408(3,$p722);$b383->b408(4,$e724);$b383->b408(5,$e726);$b383->b408(6,$l729);$b383->b408(7,$p730);if($b383->u385()===true){return 1;}else{return 0;}}function c192($g642,$o388,$r529){$l372=t0();$b383=$l372->k384("UPDATE $g642 SET $o388 = ?");$b383->b408(1,$r529);if($b383->u385()===true){return 1;}else{return 0;}}function s193($b434){$j665=strtotime($b434);$f731=array('second','minute','hour','day','month','year');$l651=array('60','60','24','30','12','10');$e732=time();if($e732>=$j665){$h733=time()-$j665;for($b655=0;$h733>=$l651[$b655]&&$b655<count($l651)-1;++$b655){$h733=$h733/$l651[$b655];}$h733=round($h733);return $h733.' '.$f731[$b655].'(s) ago ';}}function w194($o734){$z735=time()-$o734;if($z735<1){return 'less than 1 second ago';}$f736=array(12*30*24*60*60=>'year',30*24*60*60=>'month',24*60*60=>'day',60*60=>'hour',60=>'minute',1=>'second',);foreach($f736 as $a737=>$s653){$c738=$z735/$a737;if($c738>=1){$k717=round($c738);return 'about '.$k717.' '.$s653.($k717>1?'s':'').' ago';}}}function m195($j665){$i666='d-m-Y';$b434=new \n667();$b434->a668($j665);return $b434->p669($i666);}function o196($j665){$i666='d-m-Y';$b434=new \n667();$b434->a668($j665);return $b434->p669($i666);}function p197($j665){$i666='d-m-Y H:i:s';$b434=new \n667();$b434->a668($j665);return $b434->p669($i666);}function x198($j665){if($j665>0){$i666='H:i:s';$b434=new \n667();$b434->a668($j665);return $b434->p669($i666);}else{return '-';}}function r199($j739,$z438,$g642){if(trim($z438!='')){$g381=t0();$h382="SELECT * FROM $g642 WHERE $j739='$z438'";$b383=$g381->k384($h382);$b383->u385();$f448=$b383->y449();$b383->u450();return $f448;}else{return 0;}}function j200($j739,$z438,$g642){$g381=t0();$h382="SELECT * FROM $g642 WHERE $j739='$z438'";$b383=$g381->k384($h382);$b383->u385();$f448=$b383->y449();$b383->u450();return $f448;}function l201($j739,$z438,$g642,$l740){$g381=t0();$h382="SELECT * FROM $g642 WHERE $j739='$z438' AND id != $l740";$b383=$g381->k384($h382);$b383->u385();$f448=$b383->y449();$b383->u450();if($z438!=''){return $f448;}else{return 0;}}function k202($g377){$g381=t0();$h382="SELECT * FROM ct_team WHERE id = '$g377'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function h203(){$g381=t0();$h382="SELECT * FROM ct_immersion";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function j204($x437){$g381=t0();$h382="SELECT * FROM ct_photos WHERE album = '$x437' ORDER by date_time DESC";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function y205(){$g381=t0();$h382="SELECT * FROM ct_team";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function p206($i541){$g381=t0();$h382="SELECT * FROM ct_event order by id DESC LIMIT $i541";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function r207($g620){if($g620!='0'){$x424=$g620;}else{$x424='assets/images/blog-default.png';}return $x424;}function n208(){$g381=t0();$h382="SELECT * FROM ct_blog order by pid DESC LIMIT 4";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function z209(){$g381=t0();$h382="SELECT * FROM ct_blog WHERE type != 'page' order by pid DESC LIMIT 6";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function s210($x592){$g381=t0();$h382="SELECT * FROM ct_blog WHERE pid != '$x592' order by pid DESC LIMIT 6";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function s211($g377){$g381=t0();$h382="SELECT * FROM ct_event WHERE id != '$g377' order by id DESC LIMIT 6";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function k212($g377){$g381=t0();$h382="SELECT * FROM ct_file WHERE infos = '$g377'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function l213($x592){$g381=t0();$h382="SELECT * FROM ct_blog WHERE date_time = '$x592'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function k214($g377){$g381=t0();$h382="SELECT * FROM ct_event WHERE id = '$g377'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function z215($g377){$g381=t0();$h382="SELECT * FROM ct_job WHERE id = '$g377'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function c216(){$f460=m1();$g381=t0();$h382="SELECT * FROM ct_cv_infos WHERE id_user = '$f460'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function y217(){$f460=m1();$g381=t0();$h382="SELECT * FROM ct_cv_education WHERE id_user = '$f460'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function b218(){$f460=m1();$g381=t0();$h382="SELECT * FROM ct_cv_workexperience WHERE id_user = '$f460'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function u219(){$f460=m1();$g381=t0();$h382="SELECT * FROM ct_cv_skills WHERE id_user = '$f460'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function h220($f460){$g381=t0();$h382="SELECT * FROM ct_cv_infos WHERE id_user = '$f460'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function u221($f460){$g381=t0();$h382="SELECT * FROM ct_cv_education WHERE id_user = '$f460'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function n222($f460){$g381=t0();$h382="SELECT * FROM ct_cv_workexperience WHERE id_user = '$f460'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function i223($f460){$g381=t0();$h382="SELECT * FROM ct_cv_skills WHERE id_user = '$f460'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function k224($b434){$b434=DateTime::v741("Y-m-d",$b434);$b434=$b434->p669("Y");return $b434;}function n225($x592){$g381=t0();$h382="SELECT * FROM ct_blog WHERE pid < '$x592' order by pid DESC LIMIT 6";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function q226($x592){$g381=t0();$h382="SELECT * FROM ct_blog WHERE pid > '$x592' order by pid ASC LIMIT 6";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function d227($g377){$g381=t0();$h382="SELECT * FROM ct_event WHERE id < '$g377' order by id DESC LIMIT 6";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function f228($n742,$s743,$g744,$w745,$d746=80){list($w747,$h748,$s457)=getimagesize($n742);if($s457==1){header('Content-Type: image/gif');$x424=imagecreatefromgif($n742);}elseif($s457==2){header('Content-Type: image/jpeg');$x424=imagecreatefromjpeg($n742);}elseif($s457==3){header('Content-Type: image/png');$x424=imagecreatefrompng($n742);}else{header('Content-Type: image/x-ms-bmp');$x424=imagecreatefromwbmp($n742);}if($g744==0){$g744=$w747;}if($w745==0){$w745=$h748;}$h749=$g744/$w747;$j750=$w745/$h748;$v751=min($h749,$j750);$o752=(int)$w747*$v751;$h753=(int)$h748*$v751;$z754=imagecreatetruecolor($o752,$h753);$p755=imagecolorallocatealpha($z754,0,0,0,127);$n756=imagefill($z754,0,0,$p755);$z757=imagesavealpha($z754,true);$p758=imagecopyresampled($z754,$x424,0,0,0,0,$o752,$h753,$w747,$h748);$l759=imagepng($z754,$s743);$w760=imagedestroy($x424);$w760=imagedestroy($z754);return $s743;}function s229($g377){$g381=t0();$h382="SELECT * FROM ct_event WHERE id > '$g377' order by id ASC LIMIT 6";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function d230(){$g381=t0();$h382="SELECT * FROM ct_testimonial";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function d231($w558,$o388){$r469="1";$l372=t0();$b383=$l372->k384("UPDATE ct_ticket_status SET expire = ? WHERE ($o388 = ?)");$b383->b408(1,$r469);$b383->b408(2,$w558);if($b383->u385()===true){$b383=$l372->k384("UPDATE ct_ticket SET expire = ? WHERE ($o388 = ?)");$b383->b408(1,$r469);$b383->b408(2,$w558);if($b383->u385()===true){return 1;}else{return 0;}}else{return 0;}}function y232($q467,$q461){if($q467=='1'){$t465="WHERE (bigmaster_user = '$q461')";}elseif($q467=='2'){$t465="WHERE (master_user = '$q461')";}elseif($q467=='3'){$t465="WHERE (id_agent = '$q461')";}else{$t465="";}$r469="1";$l372=t0();$b383=$l372->k384("UPDATE ct_ticket_status SET expire = ? $t465");$b383->b408(1,$r469);if($b383->u385()===true){$b383=$l372->k384("UPDATE ct_ticket SET expire = ? $t465");$b383->b408(1,$r469);if($b383->u385()===true){return 1;}else{return 0;}}else{return 0;}}function o233($f460,$q461,$d456,$q459){if(trim($f460)==''){$a761="";$w762="WHERE reference_user = '$q461'";}else{$a761="WHERE id_user = '$f460'";$w762="AND reference_user = '$q461'";}$g381=t0();$h382="SELECT * FROM ct_results $a761 $w762 AND game = '$d456' AND reference_id = '$q459'";$b383=$g381->k384($h382);$b383->u385();$f448=$b383->y449();$b383->u450();return $f448;}function i234($w500){$r469="1";$l372=t0();$b383=$l372->k384("UPDATE ct_ticket_status SET expire = ? WHERE (master_user = ?)");$b383->b408(1,$r469);$b383->b408(2,$w558);if($b383->u385()===true){$b383=$l372->k384("UPDATE ct_ticket SET expire = ? WHERE (master_user = ?)");$b383->b408(1,$r469);$b383->b408(2,$w558);if($b383->u385()===true){return 1;}else{return 0;}}else{return 0;}}function t235($g377){$g381=t0();$h382="SELECT * FROM ct_testimonial WHERE id = '$g377'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function u236(){$g381=t0();$h382="SELECT * FROM ct_community";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function t237($g377){$g381=t0();$h382="SELECT * FROM ct_file WHERE id_user = '$g377' order by id DESC LIMIT 10";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function f238($g377){$g381=t0();$h382="SELECT * FROM ct_resultat WHERE id_file = '$g377'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function w239($t403){if($t403=='0'){$q763='Super administrateur';}if($t403=='1'){$q763='Big Master Agent';}if($t403=='2'){$q763='Master Agent';}if($t403=='3'){$q763='Agent';}return $q763;}function z240($t403,$g522,$e764='',$o388='show',$x765="order by level DESC limit 700"){$g522=trim($g522);if($g522!=''){if($t403=='all'){$z766="WHERE username LIKE '%$g522%' OR enterprise LIKE '%$g522%' OR firstname LIKE '%$g522%'";}else{$z766="AND (username LIKE '%$g522%' OR enterprise LIKE '%$g522%' OR firstname LIKE '%$g522%')";}}else{$z766='';}$t403=trim($t403);if($t403=='all'){$c767='';}elseif($e764>0&&$t403=='3'){$c767="WHERE level ='3' AND master_user ='$e764'";}elseif($e764>0&&$t403=='2'){$c767="WHERE level ='$t403' AND master_user ='$e764'";}elseif($e764>0&&$t403=='4'){$c767="WHERE level ='3' AND bigmaster_user ='$e764'";}else{$c767="WHERE level ='$t403' OR level ='0'";}if($o388=='show'){$i541=$x765;}elseif($o388=='count'){$i541="";}$g381=t0();$h382="SELECT * FROM ct_users $c767 $z766 $i541";$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();return $c386;}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function r241($t403,$g522,$w500,$e764='',$o388='show',$x765="order by level DESC limit 700"){$g522=trim($g522);if($g522!=''){if($t403=='all'){$z766="AND (username LIKE '%$g522%' OR enterprise LIKE '%$g522%' OR firstname LIKE '%$g522%')";}elseif(trim($e764)==''&&$t403=='1'){$z766="AND id = '$w500'";}elseif(trim($e764)==''&&$t403=='2'){$z766="AND (username LIKE '%$g522%' OR enterprise LIKE '%$g522%' OR firstname LIKE '%$g522%') AND master_user = '$w500'";}elseif(trim($e764)==''&&$t403=='3'){$z766="AND (username LIKE '%$g522%' OR enterprise LIKE '%$g522%' OR firstname LIKE '%$g522%') AND bigmaster_user = '$w500'";}elseif(trim($e764)>0&&$t403=='2'){$z766="AND (username LIKE '%$g522%' OR enterprise LIKE '%$g522%' OR firstname LIKE '%$g522%')";}elseif(trim($e764)>0&&$t403=='3'){$z766="AND (username LIKE '%$g522%' OR enterprise LIKE '%$g522%' OR firstname LIKE '%$g522%')";}elseif(trim($e764)>0&&$t403=='4'){$z766="AND (username LIKE '%$g522%' OR enterprise LIKE '%$g522%' OR firstname LIKE '%$g522%')";}}else{if($t403=='all'){$z766="";}elseif(trim($e764)==''&&$t403=='1'){$z766="AND id = '$w500'";}elseif(trim($e764)==''&&$t403=='2'){$z766="AND master_user = '$w500'";}elseif(trim($e764)==''&&$t403=='3'){$z766="AND (master_user ='$w500' OR bigmaster_user ='$w500')";}elseif(trim($e764)>0&&$t403=='2'){$z766="AND master_user = '$e764'";}elseif(trim($e764)>0&&$t403=='3'){$z766="AND master_user = '$e764'";}elseif(trim($e764)>0&&$t403=='4'){$z766="AND bigmaster_user = '$e764'";}}$t403=trim($t403);if($t403=='all'){$c767="WHERE (master_user ='$w500' OR bigmaster_user ='$w500')";}elseif(trim($e764)==''&&$t403=='1'){$c767="WHERE level ='$t403'";}elseif(trim($e764)==''&&$t403=='2'){$c767="WHERE level ='$t403'";}elseif(trim($e764)==''&&$t403=='3'){$c767="WHERE level ='$t403'";}elseif($e764>0&&$t403=='3'){$c767="WHERE level ='3' AND master_user ='$e764'";}elseif($e764>0&&$t403=='2'){$c767="WHERE level ='$t403' AND master_user ='$e764'";}elseif($e764>0&&$t403=='4'){$c767="WHERE level ='3' AND bigmaster_user ='$e764'";}if($o388=='show'){$i541=$x765;}elseif($o388=='count'){$i541="";}$g381=t0();$h382="SELECT * FROM ct_users $c767 $z766 $i541";$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();return $c386;}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function x242($g377){$g381=t0();$h382="SELECT * FROM ct_users WHERE level = '2' AND master_user = '$g377' order by id DESC LIMIT 50";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function i243(){$g381=t0();$h382="SELECT * FROM ct_users WHERE level = '2' order by id DESC LIMIT 50";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function q244(){$g381=t0();$h382="SELECT * FROM ct_users WHERE level = '1' order by id DESC LIMIT 50";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function c245($g377,$o537,$i541,$o388,$g522=""){if(isset($_SESSION['said'])){if($o537=='1'){$y543="WHERE level = '$o537' OR level ='0'";if($g522!=""){$y543="WHERE username = '$g522'";}$e551="AND (master_user = '$g377')";}elseif($o537=='2'){$y543="WHERE level = '$o537'";if($g522!=""){$y543="WHERE username = '$g522'";}$e551="";}elseif($o537=='3'){$y543="WHERE level = '$o537'";if($g522!=""){$y543="WHERE username = '$g522'";}$e551="";}else{$y543="";$e551="";}}elseif(isset($_SESSION['aid'])){if($o537=='2'){$y543="WHERE level = '$o537'";if($g522!=""){$y543="WHERE username = '$g522'";}$e551="AND (master_user = '$g377')";}elseif($o537=='3'){$y543="WHERE level = '$o537'";if($g522!=""){$y543="WHERE username = '$g522'";}$e551="AND (master_user = '$g377' OR bigmaster_user = '$g377')";}else{$y543="";$e551="WHERE (master_user = '$g377' OR bigmaster_user = '$g377')";}}elseif(isset($_SESSION['mid'])){if($o537=='3'){$y543="WHERE level = '$o537'";if($g522!=""){$y543="WHERE username = '$g522'";}$e551="AND (master_user = '$g377')";}else{$y543="";$e551="WHERE (master_user = '$g377')";}}if($o388=='count'){$i541='';}$g381=t0();$h382="SELECT * FROM ct_users $y543 $e551 ORDER BY id $i541";$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();return $c386;}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function y246($g377,$o537,$i541,$o388,$g522="",$a768,$o769){if(isset($_SESSION['said'])){if($o537=='1'){$y543="WHERE level = '$o537' OR level ='0'";if($g522!=""){$y543="WHERE username = '$g522'";}$e551="AND (master_user = '$g377')";if($a768=='bank'||$a768=='3'){$u548=z154('ct_users','username',$g522,'id');$y543="WHERE master_user = '$u548' OR bigmaster_user = '$u548'";$e551="AND level = '3'";}}elseif($o537=='2'){$y543="WHERE level = '$o537'";if($g522!=""){$y543="WHERE username = '$g522'";}$e551="";}elseif($o537=='3'){$y543="WHERE level = '$o537'";if($g522!=""){$y543="WHERE username = '$g522'";}$e551="";}else{$y543="";$e551="";}if($o769=='1'||$o769=='2'){if($a768=='bank'||$a768=='3'){$u548=z154('ct_users','username',$g522,'id');if($u548!=''){$y543="WHERE (master_user = '$u548' OR bigmaster_user = '$u548')";$e551="AND level = '3'";}else{$y543="WHERE level = '3'";$e551="";}}}}elseif(isset($_SESSION['aid'])){if($o537=='2'){$y543="WHERE level = '$o537'";if($g522!=""){$y543="WHERE username = '$g522'";}$e551="AND (master_user = '$g377')";}elseif($o537=='3'){$y543="WHERE level = '$o537'";if($g522!=""){$y543="WHERE username = '$g522'";}$e551="AND (master_user = '$g377' OR bigmaster_user = '$g377')";}else{$y543="";$e551="WHERE (master_user = '$g377' OR bigmaster_user = '$g377')";}if($o769=='2'){if($a768=='bank'||$a768=='3'){$u548=z154('ct_users','username',$g522,'id');if($u548!=''){$y543="WHERE (master_user = '$u548' OR bigmaster_user = '$u548')";$e551="AND level = '3'";}else{$y543="WHERE level = '3'";$e551="";}}}}elseif(isset($_SESSION['mid'])){if($o537=='3'){$y543="WHERE level = '$o537'";if($g522!=""){$y543="WHERE username = '$g522'";}$e551="AND (master_user = '$g377')";}else{$y543="";$e551="WHERE (master_user = '$g377')";}}if($o388=='count'){$i541='';}$g381=t0();$h382="SELECT * FROM ct_users $y543 $e551 ORDER BY id $i541";$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();return $c386;}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function l247($o537){$g381=t0();$h382="SELECT * FROM ct_users WHERE level = '$o537' ORDER BY id";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function m248($g377,$f538,$k539,$x540,$y770,$i541,$o388,$i771,$g522=""){$x540=htmlspecialchars_decode($x540,ENT_QUOTES);$u548=z154('ct_users','username',$g522,'id');$m549=z154('ct_users','username',$g522,'level');if($m549=='0'){$j550="AND bigmaster_user = '$u548'";}elseif($m549=='1'){$j550="AND bigmaster_user = '$u548'";}elseif($m549=='2'){$j550="AND master_user = '$u548'";}elseif($m549=='3'){$j550="AND id_agent = '$u548'";}if(trim($x540)!=''){$i542="AND lot in ($x540)";}else{$i542='';}if(isset($_SESSION['said'])){$e551="";if($g522!=""){$e551=$j550;}}elseif(isset($_SESSION['aid'])){$e551="AND (master_user = '$g377' OR bigmaster_user = '$g377')";if($g522!=""){$e551=$j550;}}elseif(isset($_SESSION['mid'])){$e551="AND master_user = '$g377'";if($g522!=""){$e551=$j550;}}if($o388=='count'){$i541='';}$h552=$f538;$b553=$k539;$p554=str_replace('/','-',$f538);$n555=str_replace('/','-',$k539);$f538=strtotime($p554);$k539=strtotime($n555);$k539=$k539+86399;$q556=gmdate("m-d-Y",$f538);$k557=gmdate("m-d-Y",$k539);$g381=t0();if($f538==$k539){$h382="SELECT DISTINCT($i771) FROM ct_ticket WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' $e551 $i542 AND status != '3' order by id $i541";}else{$h382="SELECT DISTINCT($i771) FROM ct_ticket WHERE time_signin >= '$f538' AND time_signin <= '$k539' $e551 $i542 AND status != '3' order by id $i541";}$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();return $c386;}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function n249($j772){$x437='';if($j772=='1'){$x437='Pay';}elseif($j772=='0'){$x437='Non pay';}return $x437;}function y250($g377,$f538,$k539,$x540,$y770,$i541,$o388,$i771,$g522="",$j772=""){$x540=htmlspecialchars_decode($x540,ENT_QUOTES);$u548=z154('ct_users','username',$g522,'id');$m549=z154('ct_users','username',$g522,'level');if($m549=='0'){$j550="AND bigmaster_user = '$u548'";}elseif($m549=='1'){$j550="AND bigmaster_user = '$u548'";}elseif($m549=='2'){$j550="AND master_user = '$u548'";}elseif($m549=='3'){$j550="AND id_agent = '$u548'";}$j772=trim($j772);if($j772!=''){$k773="AND pay = '$j772'";}else{$k773="";}if(trim($x540)!=''){$i542="AND lot in ($x540)";}else{$i542='';}if($y770=='all'){$i542=$i542;}elseif($y770=='perte'){$i542=$i542." AND net < '0' ";}elseif($y770=='profit'){$i542=$i542." AND net > '0' ";}if(isset($_SESSION['said'])){$e551="";if($g522!=""){$e551=$j550;}}elseif(isset($_SESSION['aid'])){$e551="AND (master_user = '$g377' OR bigmaster_user = '$g377')";if($g522!=""){$e551=$j550;}}elseif(isset($_SESSION['mid'])){$e551="AND master_user = '$g377'";if($g522!=""){$e551=$j550;}}if($o388=='count'){$i541='';}$h552=$f538;$b553=$k539;$p554=str_replace('/','-',$f538);$n555=str_replace('/','-',$k539);$f538=strtotime($p554);$k539=strtotime($n555);$k539=$k539+86399;$q556=gmdate("m-d-Y",$f538);$k557=gmdate("m-d-Y",$k539);$g381=t0();if($f538==$k539){$h382="SELECT DISTINCT($i771) FROM ct_ticket WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' $e551 $i542 $k773 order by id $i541";}else{$h382="SELECT DISTINCT($i771) FROM ct_ticket WHERE time_signin >= '$f538' AND time_signin <= '$k539' $e551 $i542 $k773 order by id $i541";}$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();return $c386;}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function a251($g377,$f538,$k539,$y770,$i541,$u774,$o388,$u431,$i771,$g522){$o537=z154('ct_users','id',$g377,'level');$u548=z154('ct_users','username',$g522,'id');$m549=z154('ct_users','username',$g522,'level');if($m549=='0'){$j550="AND bigmaster_user = '$u548'";}elseif($m549=='1'){$j550="AND bigmaster_user = '$u548'";}elseif($m549=='2'){$j550="AND master_user = '$u548'";}elseif($m549=='3'){$j550="AND id_agent = '$u548'";}$i542="AND $i771 = '$u431'";if($y770=='all'){$i542=$i542;}elseif($y770=='perte'){$i542=$i542." AND net < '0' ";}elseif($y770=='profit'){$i542=$i542." AND net > '0' ";}if(isset($_SESSION['said'])){if($o537=='0'){$e551="";if($g522!=""){$e551=$j550;}}elseif($o537=='1'){$e551="AND master_user = '$g377'";if($g522!=""){$e551=$j550;}}elseif($o537=='2'){$e551="";if($g522!=""){$e551=$j550;}}elseif($o537=='3'){$e551="";if($g522!=""){$e551=$j550;}}else{$e551="";}}elseif(isset($_SESSION['aid'])){if($o537=='1'){$e551="AND (master_user = '$g377' OR bigmaster_user = '$g377')";if($g522!=""){$e551=$j550;}}elseif($o537=='2'){$e551="AND master_user = '$g377'";if($g522!=""){$e551=$j550;}}elseif($o537=='3'){$e551="AND (master_user = '$g377' OR bigmaster_user = '$g377')";if($g522!=""){$e551=$j550;}}}elseif(isset($_SESSION['mid'])){if($o537=='2'){$e551="AND master_user = '$g377'";if($g522!=""){$e551=$j550;}}elseif($o537=='3'){$e551="AND master_user = '$g377'";if($g522!=""){$e551=$j550;}}}if($o388=='count'){$i541='';}$h552=$f538;$b553=$k539;$p554=str_replace('/','-',$f538);$n555=str_replace('/','-',$k539);$f538=strtotime($p554);$k539=strtotime($n555);$k539=$k539+86399;$q556=gmdate("m-d-Y",$f538);$k557=gmdate("m-d-Y",$k539);$g381=t0();if($f538==$k539){$h382="SELECT sum($u774) AS total FROM ct_ticket WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' $e551 $i542 AND status != '3' order by id $i541";}else{$h382="SELECT sum($u774) AS total FROM ct_ticket WHERE time_signin >= '$f538' AND time_signin <= '$k539' $e551 $i542 AND status != '3' order by id $i541";}$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();foreach($c386 as $o388){$f448=$o388['total'];}if(isset($f448)){return $f448;}}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function j252($g377,$o537,$f538,$k539,$x540,$i541,$o388,$s457,$j497="",$g522=""){$x540=htmlspecialchars_decode($x540,ENT_QUOTES);if(trim($x540)!=''){$i542="AND lot in ($x540)";}else{$i542='';}$y543='';$j497=trim($j497);if($j497!=''){$k545="AND option_lot = '$j497'";}else{$k545='';}$s457=trim($s457);if($s457!=''){$x775="AND type = '$s457'";}else{$x775='';}$u548=z154('ct_users','username',$g522,'id');$m549=z154('ct_users','username',$g522,'level');if($m549=='0'){$j550="AND bigmaster_user = '$u548'";}elseif($m549=='1'){$j550="AND bigmaster_user = '$u548'";}elseif($m549=='2'){$j550="AND master_user = '$u548'";}elseif($m549=='3'){$j550="AND id_agent = '$u548'";}if(isset($_SESSION['said'])){if($o537=='1'){if($g522!=""){$y543=$j550;}$e551="";}elseif($o537=='2'){if($g522!=""){$y543=$j550;}$e551="";}elseif($o537=='3'){if($g522!=""){$y543=$j550;;}$e551="";}else{$y543="";$e551="";}}elseif(isset($_SESSION['aid'])){if($o537=='2'){if($g522!=""){$y543=$j550;}$e551="AND (bigmaster_user = '$g377')";}elseif($o537=='3'){if($g522!=""){$y543=$j550;}$e551="AND (master_user = '$g377' OR bigmaster_user = '$g377')";}else{$e551="AND (master_user = '$g377' OR bigmaster_user = '$g377')";}}elseif(isset($_SESSION['mid'])){if($o537=='3'){if($g522!=""){$y543=$j550;}$e551="AND (master_user = '$g377')";}else{$e551="AND (master_user = '$g377')";}}if($o388=='count'){$i541='';}$h552=$f538;$b553=$k539;$p554=str_replace('/','-',$f538);$n555=str_replace('/','-',$k539);$f538=strtotime($p554);$k539=strtotime($n555);$k539=$k539+86399;$q556=gmdate("m-d-Y",$f538);$k557=gmdate("m-d-Y",$k539);$g381=t0();if($f538==$k539){$h382="SELECT DISTINCT numbers FROM ct_ticket WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' AND status != '3' $x775 $i542 $y543 $e551 $k545 ORDER BY numbers ASC";}else{$h382="SELECT DISTINCT numbers FROM ct_ticket WHERE time_signin >= '$f538' AND time_signin <= '$k539' AND status != '3' $x775 $i542 $y543 $e551 $k545 ORDER BY numbers ASC";}$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();return $c386;}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function j253($g377,$o537,$f538,$k539,$x540,$i541,$o388,$s457,$j497="",$g522=""){$x540=htmlspecialchars_decode($x540,ENT_QUOTES);if(trim($x540)!=''){$i542="AND lot in ($x540)";}else{$i542='';}$y543='';$j497=trim($j497);if($j497!=''){$k545="AND option_lot = '$j497'";}else{$k545='';}$s457=trim($s457);if($s457!=''){$x775="AND type = '$s457'";}else{$x775='';}$u548=z154('ct_users','username',$g522,'id');$m549=z154('ct_users','username',$g522,'level');if($m549=='0'){$j550="AND bigmaster_user = '$u548'";}elseif($m549=='1'){$j550="AND bigmaster_user = '$u548'";}elseif($m549=='2'){$j550="AND master_user = '$u548'";}elseif($m549=='3'){$j550="AND id_agent = '$u548'";}if(isset($_SESSION['said'])){if($o537=='1'){if($g522!=""){$y543=$j550;}$e551="";}elseif($o537=='2'){if($g522!=""){$y543=$j550;}$e551="";}elseif($o537=='3'){if($g522!=""){$y543=$j550;;}$e551="";}else{$y543="";$e551="";}}elseif(isset($_SESSION['aid'])){if($o537=='2'){if($g522!=""){$y543=$j550;}$e551="AND (bigmaster_user = '$g377')";}elseif($o537=='3'){if($g522!=""){$y543=$j550;}$e551="AND (master_user = '$g377' OR bigmaster_user = '$g377')";}else{$e551="AND (master_user = '$g377' OR bigmaster_user = '$g377')";}}elseif(isset($_SESSION['mid'])){if($o537=='3'){if($g522!=""){$y543=$j550;}$e551="AND (master_user = '$g377')";}else{$e551="AND (master_user = '$g377')";}}if($o388=='count'){$i541='';}$h552=$f538;$b553=$k539;$p554=str_replace('/','-',$f538);$n555=str_replace('/','-',$k539);$f538=strtotime($p554);$k539=strtotime($n555);$k539=$k539+86399;$q556=gmdate("m-d-Y",$f538);$k557=gmdate("m-d-Y",$k539);$g381=t0();if($f538==$k539){$h382="SELECT DISTINCT numbers FROM ct_ticket WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' AND status != '3' $x775 $i542 $y543 $e551 $k545 ORDER BY type ASC";}else{$h382="SELECT DISTINCT numbers FROM ct_ticket WHERE time_signin >= '$f538' AND time_signin <= '$k539' AND status != '3' $x775 $i542 $y543 $e551 $k545 ORDER BY type ASC";}$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();return $c386;}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function c254($g377,$o537,$f538,$k539,$x540,$i541,$o388,$a455,$s457,$j497="",$g522="",$u774="amount"){$x540=htmlspecialchars_decode($x540,ENT_QUOTES);if(trim($x540)!=''){$i542="AND lot in ($x540)";}else{$i542='';}$y543='';$u774=trim($u774);if($u774!=''){$q776="sum($u774) AS total";}else{$q776='*';}$j497=trim($j497);if($j497!=''){$k545="AND option_lot = '$j497'";}else{$k545='';}$s457=trim($s457);if($s457!=''){$w546="AND type = '$s457'";}else{$w546='';}$a455=trim($a455);if($a455!=''){$z547="AND numbers = '$a455'";}else{$z547='';}$u548=z154('ct_users','username',$g522,'id');$m549=z154('ct_users','username',$g522,'level');if($m549=='0'){$j550="AND bigmaster_user = '$u548'";}elseif($m549=='1'){$j550="AND bigmaster_user = '$u548'";}elseif($m549=='2'){$j550="AND master_user = '$u548'";}elseif($m549=='3'){$j550="AND id_agent = '$u548'";}if(isset($_SESSION['said'])){if($o537=='1'){if($g522!=""){$y543=$j550;}$e551="";}elseif($o537=='2'){if($g522!=""){$y543=$j550;}$e551="";}elseif($o537=='3'){if($g522!=""){$y543=$j550;;}$e551="";}else{$y543="";$e551="";}}elseif(isset($_SESSION['aid'])){if($o537=='2'){if($g522!=""){$y543=$j550;}$e551="AND (bigmaster_user = '$g377')";}elseif($o537=='3'){if($g522!=""){$y543=$j550;}$e551="AND (master_user = '$g377' OR bigmaster_user = '$g377')";}else{$e551="AND (master_user = '$g377' OR bigmaster_user = '$g377')";}}elseif(isset($_SESSION['mid'])){if($o537=='3'){if($g522!=""){$y543=$j550;}$e551="AND (master_user = '$g377')";}else{$e551="AND (master_user = '$g377')";}}if($o388=='count'){$i541='';}$h552=$f538;$b553=$k539;$p554=str_replace('/','-',$f538);$n555=str_replace('/','-',$k539);$f538=strtotime($p554);$k539=strtotime($n555);$k539=$k539+86399;$q556=gmdate("m-d-Y",$f538);$k557=gmdate("m-d-Y",$k539);$g381=t0();if($f538==$k539){$h382="SELECT $q776 FROM ct_ticket WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' AND status != '3' $w546 $z547 $i542 $y543 $e551 $k545";}else{$h382="SELECT $q776 FROM ct_ticket WHERE time_signin >= '$f538' AND time_signin <= '$k539' AND status != '3' $w546 $z547 $i542 $y543 $e551 $k545";}$b383=$g381->k384($h382);$b383->u385();if($o388=='show'){$c386=$b383->e387();if($u774!=''){foreach($c386 as $o388){$c777=$o388['total'];}return $c777;}else{return $c386;}}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function p255($g377,$o537,$f538,$k539,$x540,$i541,$o388,$a455,$s457,$j497="",$g522="",$u774="amount"){$x540=htmlspecialchars_decode($x540,ENT_QUOTES);if(trim($x540)!=''){$i542="AND lot in ($x540)";}else{$i542='';}$y543='';$u774=trim($u774);if($u774!=''){$q776="sum($u774) AS total";}else{$q776='*';}$j497=trim($j497);if($j497!=''){$k545="AND option_lot = '$j497'";}else{$k545='';}$s457=trim($s457);if($s457!=''){$w546="AND type = '$s457'";}else{$w546='';}$a455=trim($a455);if($a455!=''){$z547="AND numbers = '$a455
Showing the first 100,000 of 156,980 characters. Download the original.