<?php
/***************************************************************************
- * Copyright (C) 2003-2004 Polytechnique.org *
+ * Copyright (C) 2003-2006 Polytechnique.org *
* http://opensource.polytechnique.org/ *
* *
* This program is free software; you can redistribute it and/or modify *
if(Env::has('langue_op')){
- if(Env::get('langue_op', '')=='retirer'){
- $globals->xdb->execute("DELETE FROM langues_ins WHERE uid = {?} AND lid = {?}", Session::getInt('uid', -1), Env::get('langue_id', ''));
- } elseif(Env::get('langue_op', '') == 'ajouter'){
- if(Env::get('langue_id', '') != '')
- $globals->xdb->execute("INSERT INTO langues_ins (uid,lid,level) VALUES ({?}, {?}, {?})", Session::getInt('uid', -1), Env::get('langue_id', ''), Env::get('langue_level', ''));
+ if(Env::v('langue_op', '')=='retirer'){
+ XDB::execute("DELETE FROM langues_ins WHERE uid = {?} AND lid = {?}", S::v('uid', -1), Env::v('langue_id', ''));
+ } elseif(Env::v('langue_op', '') == 'ajouter'){
+ if(Env::v('langue_id', '') != '')
+ XDB::execute("INSERT INTO langues_ins (uid,lid,level) VALUES ({?}, {?}, {?})", S::v('uid', -1), Env::v('langue_id', ''), Env::v('langue_level', ''));
}
}
if(Env::has('comppros_op')){
- if(Env::get('comppros_op', '')=='retirer'){
- $globals->xdb->execute("DELETE FROM competences_ins WHERE uid = {?} AND cid = {?}", Session::getInt('uid', -1), Env::get('comppros_id', ''));
- } elseif(Env::get('comppros_op', '') == 'ajouter') {
- if(Env::get('comppros_id', '') != '')
- $globals->xdb->execute("INSERT INTO competences_ins (uid,cid,level) VALUES({?}, {?}, {?})", Session::getInt('uid', -1), Env::get('comppros_id', ''), Env::get('comppros_level', ''));
+ if(Env::v('comppros_op', '')=='retirer'){
+ XDB::execute("DELETE FROM competences_ins WHERE uid = {?} AND cid = {?}", S::v('uid', -1), Env::v('comppros_id', ''));
+ } elseif(Env::v('comppros_op', '') == 'ajouter') {
+ if(Env::v('comppros_id', '') != '')
+ XDB::execute("INSERT INTO competences_ins (uid,cid,level) VALUES({?}, {?}, {?})", S::v('uid', -1), Env::v('comppros_id', ''), Env::v('comppros_level', ''));
}
}
// nombre maximum autorisé de compétences professionnelles
$nb_cpro_max = 20;
-$res = $globals->xdb->iterRow("SELECT ld.id, ld.langue_fr, li.level FROM langues_ins AS li, langues_def AS ld "
- ."WHERE (li.lid=ld.id AND li.uid= {?}) LIMIT $nb_lg_max", Session::getInt('uid', -1));
+$res = XDB::iterRow("SELECT ld.id, ld.langue_fr, li.level FROM langues_ins AS li, langues_def AS ld "
+ ."WHERE (li.lid=ld.id AND li.uid= {?}) LIMIT $nb_lg_max", S::v('uid', -1));
$nb_lg = $res->total();
list($langue_id[$i], $langue_name[$i], $langue_level[$i]) = $res->next();
}
-$res = $globals->xdb->iterRow("SELECT cd.id, cd.text_fr, ci.level FROM competences_ins AS ci, competences_def AS cd "
- ."WHERE (ci.cid=cd.id AND ci.uid={?}) LIMIT $nb_cpro_max", Session::getInt('uid', -1));
+$res = XDB::iterRow("SELECT cd.id, cd.text_fr, ci.level FROM competences_ins AS ci, competences_def AS cd "
+ ."WHERE (ci.cid=cd.id AND ci.uid={?}) LIMIT $nb_cpro_max", S::v('uid', -1));
$nb_cpro = $res->total();
6 => "6"
);
-$res = $globals->xdb->iterRow("SELECT id, langue_fr FROM langues_def");
+$res = XDB::iterRow("SELECT id, langue_fr FROM langues_def");
while(list($tmp_lid, $tmp_lg_fr) = $res->next()){
$langues_def[$tmp_lid] = $tmp_lg_fr;
'expert' => 'expert'
);
-$res = $globals->xdb->iterRow("SELECT id, text_fr, FIND_IN_SET('titre',flags) FROM competences_def");
+$res = XDB::iterRow("SELECT id, text_fr, FIND_IN_SET('titre',flags) FROM competences_def");
while(list($tmp_id, $tmp_text_fr, $tmp_title) = $res->next()){
$comppros_def[$tmp_id] = $tmp_text_fr;