xdb->query(" SELECT nom,mail,sig,if(FIND_IN_SET('threads',flags),'1','0'), IF(FIND_IN_SET('automaj',flags),'1','0') FROM forums.profils WHERE uid = {?}", Session::getInt('uid')); if (!(list($nom,$mail,$sig,$disp,$maj) = $req->fetchOneRow())) { $nom = Session::get('prenom').' '.Session::get('nom'); $mail = Session::get('forlife').'@'.$globals->mail->domain; $sig = $nom.' ('.Session::getInt('promo').')'; $disp = 0; $maj = 0; } $page->assign('nom' , $nom); $page->assign('mail', $mail); $page->assign('sig' , $sig); $page->assign('disp', $disp); $page->assign('maj' , $maj); } else { $globals->xdb->execute( 'REPLACE INTO forums.profils (uid,sig,mail,nom,flags) VALUES ({?},{?},{?},{?},{?})', Session::getInt('uid'), Post::get('bananasig'), Post::get('bananamail'), Post::get('banananame'), (Post::getBool('bananadisplay') ? 'threads,' : '') . (Post::getBool('bananaupdate') ? 'automaj' : '') ); } $page->run(); ?>