PHP Decode

<?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'";}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 MAX($u774) AS maxamount FROM ct_ticket WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' AND status !=  '3' $w546 $z547 $i542 $y543 $e551 $k545";}else{$h382="SELECT MAX($u774) AS maxamount 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();foreach($c386 as $o388){$c777=$o388['maxamount'];}return $c777;}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function y256($u774,$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 sum($u774) AS total 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 sum($u774) AS total 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){$c777=$o388['total'];}return $c777;}elseif($o388=='count'){$f448=$b383->y449();$b383->u450();return $f448;}}function m257($u774,$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 AND status != '3' 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 AND status != '3' ORDER BY numbers $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 e258($u774,$g377,$o537,$f538,$k539,$x540,$i541,$o388,$a455,$s457,$j497="",$g522="",$c471="",$p778=""){$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='';}$p778=trim($p778);if($p778!=''){$s779="AND status = '$p778'";}else{$s779="AND status !=  '3'";}$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 DISTINCT($u774) FROM ct_ticket WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' $w546 $z547 $i542 $y543 $e551 $k545 $h544 $s779 AND status != '3' ORDER BY numbers $i541";}else{$h382="SELECT DISTINCT($u774) FROM ct_ticket WHERE time_signin >= '$f538' AND time_signin <= '$k539' $w546 $z547 $i542 $y543 $e551 $k545 $h544 $s779 AND status != '3' ORDER BY numbers $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 s259($u774,$g377,$o537,$f538,$k539,$x540,$i541,$o388,$a455,$s457,$j497="",$g522="",$c471="",$p778=""){$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='';}$p778=trim($p778);if($p778!=''){$s779="AND status = '$p778'";}else{$s779="AND status !=  '3'";}$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 DISTINCT($u774) FROM ct_ticket WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' $w546 $z547 $i542 $y543 $e551 $k545 $h544 $s779 ORDER BY numbers $i541";}else{$h382="SELECT DISTINCT($u774) FROM ct_ticket WHERE time_signin >= '$f538' AND time_signin <= '$k539' $w546 $z547 $i542 $y543 $e551 $k545 $h544 $s779 ORDER BY numbers $i541";}$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function w260($j497){if($j497=='reload'){$y625='recharg le compte de';}elseif($j497=='withdraw'){$y625='fait un retrait sur le compte de';}return $y625;}function f261($q498,$n499,$f538,$k539,$w780,$g781){$t501=m1();$w500=m1();$x440=m1();$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);if(isset($_SESSION['said'])){$e551="OR level = '0'";}else{$e551="";}if($n499!=''){$b782="AND (recipient_user = '$n499' OR sender_user = '$n499')";}else{$b782="";}$b783="";if($w780=='1'&&isset($_SESSION['said'])){$b783="AND master_user = '$x440'";}if($w780=='1'&&isset($_SESSION['aid'])){$b783="AND (recipient_user = '$x440' OR sender_user = '$x440')";}elseif($w780=='2'&&isset($_SESSION['aid'])){$b783="AND master_user = '$x440'";}elseif($w780=='3'&&isset($_SESSION['aid'])){$b783="AND bigmaster_user = '$x440'";}if($w780=='2'&&isset($_SESSION['mid'])){$b783="AND (recipient_user = '$x440' OR sender_user = '$x440')";}elseif($w780=='3'&&isset($_SESSION['mid'])){$b783="AND master_user = '$x440'";}$g381=t0();if($f538==$k539){$h382="SELECT * FROM ct_transactions_prepay WHERE (master_user = '$w500' OR bigmaster_user = '$t501' OR recipient_user = '$x440' $e551) $b782 AND FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' AND (options = 'withdraw' OR options = 'reload') $b783 $g781";}else{$h382="SELECT * FROM ct_transactions_prepay WHERE (master_user = '$w500' OR bigmaster_user = '$t501' OR recipient_user = '$x440' $e551) $b782 AND FROM_UNIXTIME(time_signin, '%m-%d-%Y') >= '$q556' AND FROM_UNIXTIME(time_signin, '%m-%d-%Y') <= '$k557' AND (options = 'withdraw' OR options = 'reload') $b783 $g781";}$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function s262($f538,$k539,$w780,$y784,$g781){$t501=m1();$w500=m1();$x440=m1();$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);if($y784!=''){$r785="AND (crediteur = '$y784' OR debiteur = '$y784')";}else{$r785="";}$b783="";if($w780=='1'&&isset($_SESSION['said'])){$b783="AND master_user = '$x440'";}if($w780=='1'&&isset($_SESSION['aid'])){$b783="AND (crediteur = '$x440' OR debiteur = '$x440')";}elseif($w780=='2'&&isset($_SESSION['aid'])){$b783="AND master_user = '$x440'";}elseif($w780=='3'&&isset($_SESSION['aid'])){$b783="AND bigmaster_user = '$x440'";}if($w780=='2'&&isset($_SESSION['mid'])){$b783="AND (crediteur = '$x440' OR debiteur = '$x440')";}elseif($w780=='3'&&isset($_SESSION['mid'])){$b783="AND master_user = '$x440'";}$g381=t0();if(isset($_SESSION['said'])){if($f538==$k539){$h382="SELECT * FROM ct_transactions_payment WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' $r785 $b783 $g781";}else{$h382="SELECT * FROM ct_transactions_payment WHERE time_signin >= '$f538' AND time_signin <= '$k539' $r785 $b783 $g781";}}else{if($f538==$k539){$h382="SELECT * FROM ct_transactions_payment WHERE (master_user = '$w500' OR bigmaster_user = '$t501' OR crediteur = '$x440' OR debiteur = '$x440') $r785 AND FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' $b783 $g781";}else{$h382="SELECT * FROM ct_transactions_payment WHERE (master_user = '$w500' OR bigmaster_user = '$t501' OR crediteur = '$x440' OR debiteur = '$x440') $r785 AND FROM_UNIXTIME(time_signin, '%m-%d-%Y') >= '$q556' AND FROM_UNIXTIME(time_signin, '%m-%d-%Y') <= '$k557' $b783 $g781";}}$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function y263($g377,$q461,$f538,$k539,$g781){$q461=trim($q461);if($q461!=''){$w762="AND reference_user = '$q461'";}else{$w762='';}$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_transactions WHERE reference_user = '$g377' AND FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' $w762 $g781";}else{$h382="SELECT * FROM ct_transactions WHERE reference_user = '$g377' AND FROM_UNIXTIME(time_signin, '%m-%d-%Y') >= '$q556' AND FROM_UNIXTIME(time_signin, '%m-%d-%Y') <= '$k557' $w762 $g781";}$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function d264($l466,$t786){$g381=t0();$h382="SELECT * FROM ct_ticket  WHERE serial_number = '$l466' AND date_time = '$t786'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function t265($q458){$g381=t0();$h382="SELECT * FROM ct_results  WHERE date_result = '$q458'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function l266($q459,$d456,$q467,$q461,$r469,$o388){$g381=t0();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="";}if(trim($r469)==""){$x787="";}else{$x787="AND expire = '$r469'";}$h382="SELECT * FROM ct_ticket  WHERE reference_id = '$q459' AND lot = '$d456' AND status != '3' $x787 $t465";$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 u267($x472,$q459,$s457,$d456,$q467,$q461,$r469,$o388){$g381=t0();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="";}if(trim($r469)==""){$x787="";}else{$x787="AND expire = '$r469'";}$h382="SELECT * FROM ct_ticket  WHERE numbers = '$x472' AND reference_id = '$q459' AND type = '$s457' AND lot = '$d456' AND status != '3' $x787 $t465";$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 w268($y475,$j476,$t477,$z478,$g479,$j480,$q459,$s457,$d456,$q467,$q461,$r469,$o388){$g381=t0();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="";}if(trim($r469)==""){$x787="";}else{$x787="AND expire = '$r469'";}$h382="SELECT * FROM ct_ticket  WHERE (numbers = '$y475' OR numbers = '$j476' OR numbers = '$t477' OR numbers = '$z478' OR numbers = '$g479' OR numbers = '$j480') AND reference_id = '$q459' AND type = '$s457' AND lot = '$d456' AND status != '3' $x787 $t465";$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 e269($h433,$q467,$q461){$g381=t0();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="";}$h382="SELECT serial_number FROM ct_ticket_status WHERE date_time = '$h433' AND statut_ticket != '3' $t465";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function x270($n788,$r789,$d790,$u431){if($u431=='1'){$t670=$n788.'X'.$r789;}elseif($u431=='1a'){$t670=$r789.'X'.$n788;}elseif($u431=='2'){$t670=$n788.'X'.$d790;}elseif($u431=='2a'){$t670=$d790.'X'.$n788;}elseif($u431=='3'){$t670=$r789.'X'.$d790;}elseif($u431=='3a'){$t670=$d790.'X'.$r789;}return $t670;}function l271($z400,$x437){$c386='';if($x437=='action'){if($z400=='3'){$c386='revert';}else{$c386='cancel';}}if($x437=='text'){if($z400=='3'){$c386='Ractiver ticket';}else{$c386='Annuler ticket';}}elseif($x437=='statut'){if($z400=='3'){$c386='1';}else{$c386='0';}}return $c386;}function c272($g377){$g381=t0();$h382="SELECT DISTINCT serial_number FROM ct_ticket WHERE id_agent = '$g377' AND status != '3' order by id DESC LIMIT 50";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function q273($i541='200'){$g381=t0();$h382="SELECT DISTINCT serial_number FROM ct_ticket order by id DESC LIMIT $i541";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function z274($g377,$i541='200'){$g381=t0();$h382="SELECT DISTINCT serial_number FROM ct_ticket WHERE master_user = '$g377' AND status != '3' order by id DESC LIMIT $i541";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function j275($f460,$u431,$f538,$k539,$o388,$q560='0'){$t403=z154('ct_users','id',$f460,'level');if($q560=='0'){if(isset($_SESSION['said'])){if($t403=='0'){$c791="bigmaster_user = '$f460'";}elseif($t403=='1'){$c791="bigmaster_user = '$f460'";}elseif($t403=='2'){$c791="master_user = '$f460'";}elseif($t403=='3'){$c791="id_agent = '$f460'";}}elseif(isset($_SESSION['aid'])){if($t403=='0'){$c791="bigmaster_user = '$f460'";}elseif($t403=='1'){$c791="bigmaster_user = '$f460'";}elseif($t403=='2'){$c791="master_user = '$f460'";}elseif($t403=='3'){$c791="id_agent = '$f460'";}}elseif(isset($_SESSION['mid'])){if($t403=='0'){$c791="bigmaster_user = '$f460'";}elseif($t403=='1'){$c791="bigmaster_user = '$f460'";}elseif($t403=='2'){$c791="master_user = '$f460'";}elseif($t403=='3'){$c791="id_agent = '$f460'";}}}else{if(isset($_SESSION['said'])){$c791="status !=  '3'";}elseif(isset($_SESSION['aid'])){$c791="bigmaster_user = '$f460'";}elseif(isset($_SESSION['mid'])){$c791="master_user = '$f460'";}}$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($f460==$_SESSION['said']){if($f538==$k539){$h382="SELECT COALESCE(SUM($o388),0) AS total FROM ct_ticket WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' AND lot = '$u431' AND status !=  '3' AND master_user != '$f460'";}else{$h382="SELECT COALESCE(SUM($o388),0) AS total FROM ct_ticket WHERE time_signin >= '$f538' AND time_signin <= '$k539' AND lot = '$u431' AND status !=  '3' AND master_user != '$f460'";}}else{if($f538==$k539){$h382="SELECT COALESCE(SUM($o388),0) AS total FROM ct_ticket WHERE $c791 AND FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' AND lot = '$u431' AND status !=  '3'";}else{$h382="SELECT COALESCE(SUM($o388),0) AS total FROM ct_ticket WHERE $c791 AND FROM_UNIXTIME(time_signin, '%m-%d-%Y') >= '$q556' AND FROM_UNIXTIME(time_signin, '%m-%d-%Y') <= '$k557' AND lot = '$u431' AND status !=  '3'";}}$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$f448=$o388['total'];}if(isset($f448)){return $f448;}}function g276($f460,$f538,$k539,$o388,$q560='0'){$t403=z154('ct_users','id',$f460,'level');if($q560=='0'){if(isset($_SESSION['said'])){if($t403=='0'){$c791="bigmaster_user = '$f460'";}elseif($t403=='1'){$c791="bigmaster_user = '$f460'";}elseif($t403=='2'){$c791="master_user = '$f460'";}elseif($t403=='3'){$c791="id_agent = '$f460'";}}elseif(isset($_SESSION['aid'])){if($t403=='0'){$c791="bigmaster_user = '$f460'";}elseif($t403=='1'){$c791="bigmaster_user = '$f460'";}elseif($t403=='2'){$c791="master_user = '$f460'";}elseif($t403=='3'){$c791="id_agent = '$f460'";}}elseif(isset($_SESSION['mid'])){if($t403=='0'){$c791="bigmaster_user = '$f460'";}elseif($t403=='1'){$c791="bigmaster_user = '$f460'";}elseif($t403=='2'){$c791="master_user = '$f460'";}elseif($t403=='3'){$c791="id_agent = '$f460'";}}}else{if(isset($_SESSION['said'])){$c791="statut_ticket !=  '3'";}elseif(isset($_SESSION['aid'])){$c791="bigmaster_user = '$f460'";}elseif(isset($_SESSION['mid'])){$c791="master_user = '$f460'";}}$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($o388) AS total FROM ct_ticket_status WHERE $c791 AND FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' AND statut_ticket !=  '3'";}else{$h382="SELECT sum($o388) AS total FROM ct_ticket_status WHERE $c791 AND FROM_UNIXTIME(time_signin, '%m-%d-%Y') >= '$q556' AND FROM_UNIXTIME(time_signin, '%m-%d-%Y') <= '$k557' AND statut_ticket !=  '3'";}$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$f448=$o388['total'];}if(isset($f448)){return $f448;}}function c277($b434){$b434=str_replace('/','-',$b434);$f792=date('Y-m-d',strtotime($b434));$f792=strtotime($f792);return $f792;}function r278($p793,$l794,$q795,$h796,$i797){$j798=$p793-$l794-$q795-$h796-$i797;return $j798;}function a279($f460,$f538,$k539,$q560='0',$x540,$y770){$t403=z154('ct_users','id',$f460,'level');$x540=htmlspecialchars_decode($x540,ENT_QUOTES);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($q560=='0'){if(isset($_SESSION['said'])){if($t403=='0'){$c791="bigmaster_user = '$f460'";}elseif($t403=='1'){$c791="bigmaster_user = '$f460'";}elseif($t403=='2'){$c791="master_user = '$f460'";}elseif($t403=='3'){$c791="id_agent = '$f460'";}}elseif(isset($_SESSION['aid'])){if($t403=='2'){$c791="master_user = '$f460'";}elseif($t403=='3'){$c791="id_agent = '$f460'";}}elseif(isset($_SESSION['mid'])){if($t403=='3'){$c791="id_agent = '$f460'";}}}else{if(isset($_SESSION['said'])){$c791="statut_ticket !=  '3'";}elseif(isset($_SESSION['aid'])){$c791="bigmaster_user = '$f460'";}elseif(isset($_SESSION['mid'])){$c791="master_user = '$f460'";}}$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 $c791 AND FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556'  AND status !=  '3' $i542";}else{$h382="SELECT * FROM ct_ticket WHERE $c791 AND FROM_UNIXTIME(time_signin, '%m-%d-%Y') >= '$q556' AND FROM_UNIXTIME(time_signin, '%m-%d-%Y') <= '$k557'  AND status !=  '3' $i542";}$b383=$g381->k384($h382);$b383->u385();$c386=$b383->y449();return $c386;}function d280($f460,$f538,$k539,$o388,$q560='0',$x540,$y770){$t403=z154('ct_users','id',$f460,'level');$x540=htmlspecialchars_decode($x540,ENT_QUOTES);if(trim($x540)!=''){$i542="AND lot in ($x540)";}else{$i542='';}if($q560=='0'){if(isset($_SESSION['said'])){if($t403=='0'){$c791="bigmaster_user = '$f460'";}elseif($t403=='1'){$c791="bigmaster_user = '$f460'";}elseif($t403=='2'){$c791="master_user = '$f460'";}elseif($t403=='3'){$c791="id_agent = '$f460'";}}elseif(isset($_SESSION['aid'])){if($t403=='2'){$c791="master_user = '$f460'";}elseif($t403=='3'){$c791="id_agent = '$f460'";}}elseif(isset($_SESSION['mid'])){if($t403=='3'){$c791="id_agent = '$f460'";}}}else{if(isset($_SESSION['said'])){$c791="statut_ticket !=  '3'";}elseif(isset($_SESSION['aid'])){$c791="bigmaster_user = '$f460'";}elseif(isset($_SESSION['mid'])){$c791="master_user = '$f460'";}}$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($o388) AS total FROM ct_ticket WHERE $c791 AND FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556'  AND status !=  '3' $i542";}else{$h382="SELECT sum($o388) AS total FROM ct_ticket WHERE $c791 AND time_signin >= '$f538' AND time_signin <= '$k539' AND status !=  '3' $i542";}$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$f448=$o388['total'];}if(isset($f448)){return $f448;}}function i281($f460,$f538,$k539,$o388,$q560='0',$x540,$y770,$m799){$t403=z154('ct_users','id',$f460,'level');$x540=htmlspecialchars_decode($x540,ENT_QUOTES);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($q560=='0'){if(isset($_SESSION['said'])){if($t403=='0'){$c791="bigmaster_user = '$f460'";}elseif($t403=='1'){$c791="bigmaster_user = '$f460'";}elseif($t403=='2'){$c791="master_user = '$f460'";}elseif($t403=='3'){$c791="id_agent = '$f460'";}}elseif(isset($_SESSION['aid'])){if($t403=='2'){$c791="master_user = '$f460'";}elseif($t403=='3'){$c791="id_agent = '$f460'";}}elseif(isset($_SESSION['mid'])){if($t403=='3'){$c791="id_agent = '$f460'";}}}else{if(isset($_SESSION['said'])){$c791="statut_ticket !=  '3'";}elseif(isset($_SESSION['aid'])){$c791="bigmaster_user = '$f460'";}elseif(isset($_SESSION['mid'])){$c791="master_user = '$f460'";}}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($o388) AS total FROM ct_ticket WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' AND status !=  '3' $i542";}else{$h382="SELECT sum($o388) AS total FROM ct_ticket WHERE time_signin >= '$f538' AND time_signin <= '$k539'  AND status !=  '3' $i542";}$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$f448=$o388['total'];}if(isset($f448)){return $f448;}}function h282($f460,$f538,$k539,$q560='0'){$t403=z154('ct_users','id',$f460,'level');if($q560=='0'){if(isset($_SESSION['said'])){if($t403=='0'){$c791="bigmaster_user = '$f460'";}elseif($t403=='1'){$c791="bigmaster_user = '$f460'";}elseif($t403=='2'){$c791="master_user = '$f460'";}elseif($t403=='3'){$c791="id_agent = '$f460'";}}elseif(isset($_SESSION['aid'])){if($t403=='2'){$c791="master_user = '$f460'";}elseif($t403=='3'){$c791="id_agent = '$f460'";}}elseif(isset($_SESSION['mid'])){if($t403=='3'){$c791="id_agent = '$f460'";}}}else{if(isset($_SESSION['said'])){$c791="statut_ticket !=  '3'";}elseif(isset($_SESSION['aid'])){$c791="bigmaster_user = '$f460'";}elseif(isset($_SESSION['mid'])){$c791="master_user = '$f460'";}}$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_status WHERE $c791 AND FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' AND statut_ticket !=  '3'";}else{$h382="SELECT * FROM ct_ticket_status WHERE $c791 AND FROM_UNIXTIME(time_signin, '%m-%d-%Y') >= '$q556' AND FROM_UNIXTIME(time_signin, '%m-%d-%Y') <= '$k557' AND statut_ticket !=  '3'";}$b383=$g381->k384($h382);$b383->u385();$c386=$b383->y449();return $c386;}function p283($f538,$k539,$s800,$x801,$u431,$i541="DESC LIMIT 10"){$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);$u431=trim($u431);if($u431!=''){$b802="AND lot = '$u431'";}else{$b802='';}$g381=t0();if($f538==$k539){$h382="SELECT * FROM ct_ticket WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' $b802 $s800 $x801 order by id $i541";}else{$h382="SELECT * FROM ct_ticket WHERE time_signin >= '$f538' AND time_signin <= '$k539' $b802 $s800 $x801 order by id $i541";}$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function m284($f538,$k539,$s800,$x801,$i541="DESC LIMIT 10"){$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_status WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' $s800 $x801 order by id $i541";}else{$h382="SELECT * FROM ct_ticket_status WHERE time_signin >= '$f538' AND time_signin <= '$k539' $s800 $x801 order by id $i541";}$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function p285($h433,$z803,$q461,$j497){if($q461>0){$t403=z154('ct_users','id',$q461,'level');$y784=z154('ct_users','id',$q461,'id');if($t403=='0'){$p804="AND (master_user = '$y784' OR bigmaster_user = '$y784') ";}elseif($t403=='1'){$p804="AND bigmaster_user = '$y784' ";}elseif($t403=='2'){$p804="AND master_user = '$y784' ";}elseif($t403=='3'){$p804="AND id_agent = '$y784' ";}else{$p804=" ";}}else{$p804=" ";}if(isset($_SESSION['aid'])){$x440=m1();$u805=" AND bigmaster_user ='$x440'";}elseif(isset($_SESSION['mid'])){$x440=m1();$u805=" AND master_user ='$x440'";}else{$u805="";}$h552=$h433;$b553=$h433;$p554=str_replace('/','-',$h433);$n555=str_replace('/','-',$h433);$f538=strtotime($p554);$k539=strtotime($n555);$k539=$k539+86399;$q556=gmdate("m-d-Y",$f538);$k557=gmdate("m-d-Y",$k539);$g381=t0();if($j497=='paris'){$h382="SELECT * FROM ct_ticket WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' AND lot = '$z803' $p804 $u805 order by id DESC";}else{$h382="SELECT DISTINCT serial_number FROM ct_ticket WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' AND lot = '$z803' $p804 $u805 order by id DESC";}$b383=$g381->k384($h382);$b383->u385();$c386=$b383->y449();return $c386;}function r286($f538,$k539,$s800,$x801){$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_status WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' $s800 $x801 order by id DESC";}else{$h382="SELECT * FROM ct_ticket_status WHERE time_signin >= '$f538' AND time_signin <= '$k539' $s800 $x801 order by id DESC";}$b383=$g381->k384($h382);$b383->u385();$c386=$b383->y449();return $c386;}function q287($f538,$k539,$s800,$x801,$o388){$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($o388) AS total FROM ct_ticket_status WHERE FROM_UNIXTIME(time_signin, '%m-%d-%Y') = '$q556' $s800 $x801 order by id DESC";}else{$h382="SELECT sum($o388) AS total FROM ct_ticket_status WHERE time_signin >= '$f538' AND time_signin <= '$k539' $s800 $x801 order by id DESC";}$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$f448=$o388['total'];}if(isset($f448)){return $f448;}}function u288(){$g381=t0();$h382="SELECT * FROM ct_job WHERE payment = '1' order by id DESC LIMIT 10";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function q289(){$g381=t0();$h382="SELECT * FROM ct_job WHERE payment = '1'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->y449();return $c386;}function p290($g377){$g381=t0();$h382="SELECT * FROM ct_users WHERE master_user = '$g377'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->y449();return $c386;}function v291(){$g381=t0();$h382="SELECT * FROM ct_users ";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function v292(){$g381=t0();$h382="SELECT * FROM ct_users WHERE level != '0'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function e293($f460){$g381=t0();$h382="SELECT * FROM ct_users WHERE master_user = '$f460'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function g294($f460){$g381=t0();$h382="SELECT * FROM ct_users WHERE bigmaster_user = '$f460'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function b295(){$g381=t0();$h382="SELECT * FROM ct_users WHERE level = '1'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function a296($g377,$o537,$f538,$k539,$x540,$i541,$o388,$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='';}$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 $i542 $y543 $e551 $k545";}else{$h382="SELECT $q776 FROM ct_ticket WHERE time_signin >= '$f538' AND time_signin <= '$k539' AND status !=  '3' $w546 $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 l297($g377){$g381=t0();$h382="SELECT * FROM ct_job WHERE id_user = '$g377' AND payment = '1' order by id DESC LIMIT 10";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function s298(){$g381=t0();$h382="SELECT * FROM ct_job_candidates order by id DESC LIMIT 15";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function s299($x429,$u581){$g381=t0();$h382="SELECT * FROM ct_job_candidates WHERE id_job = '$x429' AND compatibility = $u581";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->y449();return $c386;}function j300($x429){$g381=t0();$h382="SELECT * FROM ct_job_candidates WHERE id_job = '$x429' order by id DESC LIMIT 15";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function m301(){$g381=t0();$h382="SELECT * FROM ct_transaction order by id DESC LIMIT 10";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function t302($t403){$g381=t0();$h382="SELECT * FROM ct_users WHERE level = '$t403' order by id DESC LIMIT 20";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function f303(){$g381=t0();$h382="SELECT * FROM ct_payment order by id DESC LIMIT 10";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function w304($g377){$g381=t0();$h382="SELECT * FROM ct_job WHERE id_user = '$g377'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->y449();return $c386;}function k305($g377){$g381=t0();$h382="SELECT * FROM ct_users WHERE level = '3' AND master_user = '$g377'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->y449();return $c386;}function l306($g377){$g381=t0();$h382="SELECT * FROM ct_ticket WHERE master_user = '$g377'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->y449();return $c386;}function t307($g377){$g381=t0();$h382="SELECT DISTINCT serial_number FROM ct_ticket WHERE master_user ='$g377' AND status != '3'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->y449();return $c386;}function v308($w558){$g381=t0();$h382="SELECT DISTINCT serial_number FROM ct_ticket WHERE id_agent = '$w558' AND status != '3'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->y449();return $c386;}function o309($g377){$g381=t0();$h382="SELECT sum(amount) AS total FROM ct_ticket WHERE master_user = '$g377' AND status != '3'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['total'];}if($g389==''){$g389='0';}return $g389;}function f310($l466){$g381=t0();$h382="SELECT sum(amount) AS total FROM ct_ticket WHERE serial_number = '$l466'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['total'];}return $g389;}function l311($g377){$g381=t0();$h382="SELECT * FROM ct_resultat WHERE id_radiologue = '$g377' order by id DESC LIMIT 10";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function b312($g377,$j497){if($j497=='demandes'){$g381=t0();$h382="SELECT * FROM ct_file WHERE id_user = '$g377' && analyse = '0' order by grade DESC LIMIT 10";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();}elseif($j497=='resultats'){$g381=t0();$h382="SELECT * FROM ct_file WHERE id_user = '$g377' &&  analyse = '2' order by grade DESC LIMIT 10";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();}elseif($j497=='historiques'){$g381=t0();$h382="SELECT * FROM ct_file WHERE id_user = '$g377' && analyse = '2' order by grade DESC LIMIT 10";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();}return $c386;}function g313($j497){if($j497=='demandes'){$g381=t0();$h382="SELECT * FROM ct_file WHERE analyse = '0' order by grade DESC LIMIT 10";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();}elseif($j497=='resultats'){$g381=t0();$h382="SELECT * FROM ct_file WHERE analyse = '2' order by grade DESC LIMIT 10";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();}elseif($j497=='historiques'){$g381=t0();$h382="SELECT * FROM ct_file WHERE analyse = '2' order by grade DESC LIMIT 10";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();}return $c386;}function k314($g377){$g381=t0();$h382="SELECT * FROM ct_community WHERE id = '$g377'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function o315($y625,$m652=1,$r660=false,$b661='...'){$y625=html_entity_decode($y625,ENT_QUOTES,'UTF-8');$x806=strlen($y625);if($x806<=$m652){$l807=$y625;}else{$l807=substr($y625,0,$m652).$b661;}return $l807;}function p316($y625,$i808=14,$k809='',$r660=false){$i808-=strlen($k809);$c810=strlen($y625);if($c810<=$i808){return $y625;}if($r660&&($y811=strrpos($l617,' ',$i808-$c810))){$i808=$y811;}$y625=substr_replace($y625,$k809,$i808);$y625=$y625.'...';return $y625;}function j317($l812){if($l812=='0'){$g381=t0();$h382="SELECT * FROM ct_users where level != '5' AND verified = '0' AND blocked = '0' order by id DESC LIMIT 10";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();}elseif($l812=='1'){$g381=t0();$h382="SELECT * FROM ct_users where level != '5' AND verified = '1' AND blocked = '0' order by id DESC LIMIT 10";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();}return $c386;}function h318($l812){$g381=t0();$h382="SELECT * FROM ct_users where level != '5' AND blocked = '$l812' order by id DESC LIMIT 10";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function j319($g377){$g381=t0();$h382="SELECT * FROM ct_users WHERE id = ".$g377."";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function u320($y625){$y625=trim($y625);return '<p>'.preg_replace('/[\r\n]+/','</p><p>',$y625).'</p>';}function o321($s653){$z813[]="'";$z813[]='"';$z813[]="39";$s653=str_replace($z813,"",$s653);$v814=array('','','','','','','','','','','','','','','','');$e815=array('s','t','s','t','s','t','s','t','i','a','a','i','a','a','e','E');$s653=str_ireplace($v814,$e815,strtolower(trim($s653)));$s653=preg_replace('/[^\w\d-\ ]/','',$s653);$s653=str_replace(' ','-',$s653);return preg_replace('/-{2,}/','-',$s653);}function a322($x592,$f460,$l807,$p816,$m817,$d818,$k819,$f820,$n821,$j686){$l372=t0();$b383=$l372->k384("UPDATE posts SET pid = ?, id_user = ?, texts = ?, hashtag = ?, image_url = ?, date_post = ?, likes = ?, share = ?, adult_content_score = ?, privacy = ? WHERE pid =".$x592."");$b383->b408(1,$x592);$b383->b408(2,$f460);$b383->b408(3,$l807);$b383->b408(4,$p816);$b383->b408(5,$m817);$b383->b408(6,$d818);$b383->b408(7,$k819);$b383->b408(8,$f820);$b383->b408(9,$n821);$b383->b408(10,$j686);if($b383->u385()===true){return 1;}else{return 0;}}function e323($i401,$m402,$f404,$l405,$w406,$g377){$l372=t0();$b383=$l372->k384("UPDATE ct_users SET fullname = ?, email = ?, about = ?, role = ?, avatar = ? WHERE id = ? ");$b383->b408(1,$i401);$b383->b408(2,$m402);$b383->b408(3,$f404);$b383->b408(4,$l405);$b383->b408(5,$w406);$b383->b408(6,$g377);if($b383->u385()===true){return 1;}else{return 0;}}function u324($i541,$s822='ASC'){$g381=t0();$h382="SELECT * FROM users order by id ".$s822." LIMIT ".$i541."";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function o325($g377,$i541){$g381=t0();$h382="SELECT * FROM users WHERE id = ".$g377." order by id ASC LIMIT ".$i541."";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function d326($i541,$s822='ASC'){$g381=t0();$h382="SELECT * FROM posts order by pid ".$s822." LIMIT ".$i541."";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function f327($x592,$i541){$g381=t0();$h382="SELECT * FROM posts WHERE pid = ".$x592." order by pid ASC LIMIT ".$i541."";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function r328($n419){$g381=t0();$h382="SELECT COUNT(id) as count FROM ct_users WHERE verified = ".$n419."";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['count'];}if(isset($g389)){return $g389;}return $f448;}function l329($t403){$g381=t0();$h382="SELECT COUNT(id) as count FROM ct_users WHERE level = ".$t403."";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['count'];}if(isset($g389)){return $g389;}return $f448;}function t330(){$g381=t0();$h382='SELECT COUNT(id) as count FROM ct_users';$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['count'];}if(isset($g389)){return $g389;}return $f448;}function v331(){$g381=t0();$h382='SELECT COUNT(pid) as count FROM posts';$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['count'];}if(isset($g389)){return $g389;}$b383->u450();}function r332($g642,$e380,$v643,$i823,$i824,$k825,$x826,$o494,$w644,$o388="show"){$g381=t0();$h382="SELECT * FROM $g642 WHERE $e380 ='$v643' AND $i823 ='$i824' AND $k825 ='$x826' AND (level = '0' OR id_user = '$o494') ORDER BY id ASC";$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 e333($l827,$m615){$z637="http://api.openweathermap.org/data/2.5/weather?q=".urlencode($l827)."&units=metric&appid=".$m615;$c386=file_get_contents($z637);$d828=json_decode($c386,true);return $d828;}function p334($e380){$g381=t0();$m829='ct_'.$e380;$h382="SELECT count(*) as $e380 FROM $m829";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388[$e380];}if(isset($g389)){return $g389;}$b383->u450();}function f335($p830,$g642,$e380,$v643){$g381=t0();$h382="SELECT COUNT($p830) as count FROM $g642 WHERE $e380 = '$v643'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['count'];}if(isset($g389)){return $g389;}$b383->u450();}function r336($g377,$l641){$g381=t0();$h382="SELECT * FROM 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 q337($g642,$e380,$v643,$i823,$i824,$k825,$x826,$w644,$o388="show"){$g381=t0();$h382="SELECT * FROM $g642 WHERE $e380 ='$v643' AND $i823 ='$i824' AND $k825 ='$x826' ORDER BY id ASC";$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 j338($g642,$e380,$v643,$i823,$i824,$k825,$x826,$f831,$t832,$w644){$g381=t0();$h382="SELECT * FROM $g642 WHERE $e380 ='$v643' AND $i823 ='$i824' AND $k825 ='$x826' AND $f831 ='$t832'";$b383=$g381->k384($h382);$b383->u385();$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;}}function a339($g642,$e380,$v643,$i823,$i824,$w644){$g381=t0();$h382="SELECT * FROM $g642 WHERE $e380 ='$v643' OR $i823 ='$i824'";$b383=$g381->k384($h382);$b383->u385();$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;}}function r340($g642,$e380,$v643,$i823,$i824,$w644){$g381=t0();$h382="SELECT * FROM $g642 WHERE $e380 ='$v643' AND $i823 ='$i824'";$b383=$g381->k384($h382);$b383->u385();$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;}}function d341($u431,$h433){$g381=t0();$h382="SELECT * FROM ct_mail_rapport WHERE lot ='$u431' AND date_time ='$h433'";$b383=$g381->k384($h382);$b383->u385();$f448=$b383->y449();$b383->u450();return $f448;}function y342($x833){$g381=t0();$h382="SELECT COUNT(pid) as count FROM posts INNER JOIN users ON users.id = posts.id_user WHERE sex = '$x833'";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388['count'];}if(isset($g389)){return $g389;}$b383->u450();}function b343($g642,$j739){$g381=t0();$h382="SELECT sum($j739) AS $j739 FROM $g642";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();foreach($c386 as $o388){$g389=$o388[$j739];}if(isset($g389)){return $g389;}}function y344($g377,$b834){$l372=t0();$h382='UPDATE ct_users SET blocked = :num WHERE account_number = :id';$b383=$l372->k384($h382);$b383->u385(array(':num'=>$b834,':id'=>$g377));}function e345($g377){$l372=t0();$h382='UPDATE ct_users SET verified = :num WHERE account_number = :id';$b383=$l372->k384($h382);$b383->u385(array(':num'=>1,':id'=>$g377));}function z346($g377,$b834){$l372=t0();$h382='UPDATE ct_file SET analyse = :num WHERE id = :id';$b383=$l372->k384($h382);$b383->u385(array(':num'=>$b834,':id'=>$g377));}function u347($g377){$l372=t0();$h382='UPDATE ct_users SET active = :num WHERE id = :id';$b383=$l372->k384($h382);$b383->u385(array(':num'=>0,':id'=>$g377));}function h348($g377){$l372=t0();$h382='DELETE FROM ct_users WHERE account_number = :id';$b383=$l372->k384($h382);$b383->u385(array(':id'=>$g377));}function a349($s708,$h835){try{$x836='DELETE FROM ct_attempts WHERE `when` < ?';$e837=strtotime(date('Y-m-d H:i:s').' - '.$s708.' seconds');$e837=date('Y-m-d H:i:s',$e837);$o838=array($e837);$z813=$h835->k384($x836);$z813->u385($o838);$t839='INSERT INTO ct_attempts (`ip`, `when`) VALUES ( ?, ? )';$c386=array($_SERVER['REMOTE_ADDR'],date('Y-m-d H:i:s'));$b840=$h835->k384($t839);$b840->u385($c386);$f448='SELECT count(*) as number FROM ct_attempts where `ip` = ?';$b834=$h835->k384($f448);$b834->u385(array($_SERVER['REMOTE_ADDR']));foreach($b834 as $z841){$z842=$z841['number'];}return $z842;}catch(PDOEXCEPTION $c374){echo 'Error: '.$c374;}}function w350(){$v843=@fsockopen("www.example.com",80);if($v843){$d844=true;fclose($v843);}else{$d844=false;}return $d844;}function h351(){$g381=t0();$h382="SELECT * FROM ct_community WHERE role = 'Clients' order by id ASC";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function r352(){$g381=t0();$h382="SELECT * FROM ct_community WHERE role = 'Partenaires' order by id ASC";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function n353(){$g381=t0();$h382="SELECT * FROM ct_community WHERE role = 'Sponsors' order by id ASC";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function w354(){$g381=t0();$h382="SELECT * FROM ct_testimonial order by id ASC";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->e387();return $c386;}function x355($s845,$n846,$r847,$l848,$z849,$p850){switch($p850){case "jpg":case "jpeg":$n742=imagecreatefromjpeg($s845);break;case "png":$n742=imagecreatefrompng($s845);break;case "gif":$n742=imagecreatefromgif($s845);break;}$d851=imagesx($n742);$i852=imagesy($n742);if($d851>$i852){$l848=floor($i852*($r847/$d851));}if($i852>$d851){$r847=floor($d851*($l848/$i852));}if($d851>$r847||$i852>$l848){$r853=imagecreatetruecolor($r847,$l848);imagecopyresampled($r853,$n742,0,0,0,0,$r847,$l848,$d851,$i852);switch($p850){case "jpg":case "jpeg":return imagejpeg($r853,$n846.$z849);break;case "png":return imagepng($r853,$n846.$z849);break;case "gif":return imagegif($r853,$n846.$z849);break;}}else{copy($s845,$n846.$z849);}}function c356($s653){$b655=strrpos($s653,".");if(!$b655){return "";}$f854=strlen($s653)-$b655;$c855=substr($s653,$b655+1,$f854);return $c855;}function y357($j497){$y625='';if($j497=='reveive_money'){$y625="L'utilisateur m'a fait un paiement";}elseif($j497=='give_money'){$y625="J'ai fait un paiement  l'utilisateur";}return $y625;}function m358($j497,$t403){$y625='';if($j497=='reveive_money'){$y625="J'ai fait un paiement au ".$t403;}elseif($j497=='give_money'){$y625="Le ".$t403." m'a fait un paiement";}return $y625;}function y359($b484,$w558){$l372=t0();$h382='UPDATE ct_users SET balance = :balance WHERE id = :id';$b383=$l372->k384($h382);$b383->u385(array(':balance'=>$b484,':id'=>$w558));}function h360($b484,$f460){$l372=t0();$b383=$l372->k384("UPDATE ct_users SET balance = balance+? WHERE (id = ?)");$b383->b408(1,$b484);$b383->b408(2,$f460);if($b383->u385()===true){return 1;}else{return 0;}}function i361($x437){$x437=trim($x437);if($x437==''){$f792='0';}else{$f792=$x437;}return $f792;}function h362($f460,$h433){$g381=t0();$h382="SELECT * FROM ct_transactions_payment WHERE debiteur = '$f460' OR crediteur = '$f460' AND date_rapport = '$h433' order by id DESC LIMIT 1";$b383=$g381->k384($h382);$b383->u385();$c386=$b383->y449();return $c386;}function a363($q856,$w857,$q858,$g859,$v860,$h861,$j862,$m863,$v864,$c865,$n866,$j867,$x868,$t869,$t403,$w500,$t501,$h433,$m454,$n870){try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_transactions_payment (`amount`, `options`, `debiteur`, `crediteur`, `desc_depenses_1`, `amount_depenses_1`, `desc_depenses_2`, `amount_depenses_2`, `desc_depenses_3`, `amount_depenses_3`, `desc_depenses_4`, `amount_depenses_4`, `desc_depenses_5`, `amount_depenses_5`, `level`, `master_user`, `bigmaster_user`, `date_time`, `time_signin`, `date_rapport`) VALUES (?, ?, ?, ?, ? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,?)');$b383->b408(1,$q856);$b383->b408(2,$w857);$b383->b408(3,$t869);$b383->b408(4,$x868);$b383->b408(5,$q858);$b383->b408(6,$g859);$b383->b408(7,$v860);$b383->b408(8,$h861);$b383->b408(9,$j862);$b383->b408(10,$m863);$b383->b408(11,$v864);$b383->b408(12,$c865);$b383->b408(13,$n866);$b383->b408(14,$j867);$b383->b408(15,$t403);$b383->b408(16,$w500);$b383->b408(17,$t501);$b383->b408(18,$h433);$b383->b408(19,$m454);$b383->b408(20,$n870);if($b383->u385()===true){return $l372->v409('id');}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function b364($i564,$u431,$y871,$z400){$h433=time();$w500=m1();try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_sortition (name,lot,hour,status, date_time) VALUES (?, ?, ?, ?, ?)');$b383->b408(1,$i564);$b383->b408(2,$u431);$b383->b408(3,$y871);$b383->b408(4,$z400);$b383->b408(5,$h433);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function r365($i564,$u431,$y871,$z400,$f460,$q461,$t403){$h433=time();try{$l372=t0();$b383=$l372->k384('INSERT INTO ct_sortition_user (name, lot, hour, status, id_user, reference_user, level, date_time) VALUES (?, ?, ?, ?, ?, ?, ?, ?)');$b383->b408(1,$i564);$b383->b408(2,$u431);$b383->b408(3,$y871);$b383->b408(4,$z400);$b383->b408(5,$f460);$b383->b408(6,$q461);$b383->b408(7,$t403);$b383->b408(8,$h433);if($b383->u385()===true){return 1;}else{return 0;}}catch(PDOException $c374){die('Erreur : '.$c374->s375());}}function i366($z400,$u431,$f460,$q461){$l372=t0();$l372=t0();$b383=$l372->k384('UPDATE ct_sortition_user SET status = ? WHERE lot = ? AND id_user = ? AND reference_user = ?');$b383->b408(1,$z400);$b383->b408(2,$u431);$b383->b408(3,$f460);$b383->b408(4,$q461);if($b383->u385()===true){return 1;}else{return 0;}}function l367($m872,$e873,$n846,$d746='45'){$z874=$e873.$m872;$l875=$n846.$m872;if($z874){$j876=getimagesize($z874);if($j876['mime']=='image/jpeg'){$e873=imagecreatefromjpeg($z874);imagejpeg($e873,$l875,$d746);}elseif($j876['mime']=='image/gif'){$e873=imagecreatefromgif($z874);imagegif($e873,$l875,$d746);}elseif($j876['mime']=='image/png'){$e873=imagecreatefrompng($z874);imagepng($e873,$l875,'8');}}imagedestroy($e873);}if(isset($_SESSION['aid'])){$t403=z154('ct_users','id',$_SESSION['aid'],'level');}?>