);
}
- function handler_phpinfo(&$page)
+ function handler_phpinfo($page)
{
phpinfo();
exit;
}
- function handler_get_rights(&$page)
+ function handler_get_rights($page)
{
if (S::suid()) {
$page->kill('Déjà en SUID');
}
}
- function handler_set_skin(&$page)
+ function handler_set_skin($page)
{
S::assert_xsrf_token();
S::set('skin', Post::s('change_skin'));
}
}
- function handler_default(&$page)
+ function handler_default($page)
{
$page->changeTpl('admin/index.tpl');
$page->setTitle('Administration');
}
- function handler_postfix_delayed(&$page)
+ function handler_postfix_delayed($page)
{
$page->changeTpl('admin/postfix_delayed.tpl');
$page->setTitle('Administration - Postfix : Retardés');
// }}}
- function handler_logger(&$page, $action = null, $arg = null) {
+ function handler_logger($page, $action = null, $arg = null) {
if ($action == 'session') {
// we are viewing a session
$page->setTitle('Administration - Logs des sessions');
}
- function handler_user(&$page, $login = false)
+ function handler_user($page, $login = false)
{
global $globals;
$page->changeTpl('admin/user.tpl');
// }}}
- $page->addJsLink('jquery.ui.core.js');
- $page->addJsLink('jquery.ui.widget.js');
- $page->addJsLink('jquery.ui.tabs.js');
- $page->addJsLink('password.js');
+ $page->addJsLink('jquery.ui.xorg.js');
// Displays last login and last host information.
$res = XDB::query("SELECT start, host
return null;
}
- private static function formatNewUser(&$page, $infosLine, $separator, $promo, $size)
+ private static function formatNewUser($page, $infosLine, $separator, $promo, $size)
{
$infos = explode($separator, $infosLine);
if (sizeof($infos) > $size || sizeof($infos) < 2) {
return $infos;
}
- private static function formatSex(&$page, $sex, $line)
+ private static function formatSex($page, $sex, $line)
{
switch ($sex) {
case 'F':
return date("Y-m-d", strtotime(str_replace('/', '-', $birthDate)));
}
- function handler_add_accounts(&$page, $action = null, $promo = null)
+ function handler_add_accounts($page, $action = null, $promo = null)
{
$page->changeTpl('admin/add_accounts.tpl');
directory_name, short_name, sort_name, promo)
VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})',
$pid, $infos[1], $fullName, $fullName, $directoryName, $fullName, $directoryName, $promo);
- XDB::execute('INSERT INTO profile_education (pid, eduid, degreeid, entry_year, grad_year, flags)
- VALUES ({?}, {?}, {?}, {?}, {?}, {?})',
- $pid, $eduSchools[Profile::EDU_X], $degreeid, $entry_year, $grad_year, 'primary');
+ XDB::execute('INSERT INTO profile_education (id, pid, eduid, degreeid, entry_year, grad_year, flags)
+ VALUES (100, {?}, {?}, {?}, {?}, {?}, \'primary\')',
+ $pid, $eduSchools[Profile::EDU_X], $degreeid, $entry_year, $grad_year);
XDB::execute('INSERT INTO accounts (hruid, type, is_admin, state, full_name, directory_name, display_name, sex)
VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})',
$infos['hrid'], $type, 0, 'pending', $fullName, $directoryName, $infos[1], $sex);
}
}
- function handler_homonyms(&$page, $op = 'list', $target = null)
+ function handler_homonyms($page, $op = 'list', $target = null)
{
$page->changeTpl('admin/homonymes.tpl');
$page->setTitle('Administration - Homonymes');
}
}
- function handler_deaths(&$page, $promo = 0, $validate = false)
+ function handler_deaths($page, $promo = 0, $validate = false)
{
$page->changeTpl('admin/deces_promo.tpl');
$page->setTitle('Administration - Deces');
$page->assign('profileList', $res);
}
- function handler_dead_but_active(&$page)
+ function handler_dead_but_active($page)
{
$page->changeTpl('admin/dead_but_active.tpl');
$page->setTitle('Administration - Décédés');
$page->assign('dead', $res);
}
- function handler_validate(&$page, $action = 'list', $id = null)
+ function handler_validate($page, $action = 'list', $id = null)
{
$page->changeTpl('admin/validation.tpl');
$page->setTitle('Administration - Valider une demande');
- $page->addCssLink('nl.css');
+ $page->addCssLink('nl.Polytechnique.org.css');
if ($action == 'edit' && !is_null($id)) {
$page->assign('preview_id', $id);
$page->assign('isAdmin', S::admin());
}
- function handler_validate_answers(&$page, $action = 'list', $id = null)
+ function handler_validate_answers($page, $action = 'list', $id = null)
{
$page->setTitle('Administration - Réponses automatiques de validation');
$page->assign('title', 'Gestion des réponses automatiques');
$table_editor->apply($page, $action, $id);
}
- function handler_skins(&$page, $action = 'list', $id = null)
+ function handler_skins($page, $action = 'list', $id = null)
{
$page->setTitle('Administration - Skins');
$page->assign('title', 'Gestion des skins');
$table_editor->apply($page, $action, $id);
}
- function handler_postfix_blacklist(&$page, $action = 'list', $id = null)
+ function handler_postfix_blacklist($page, $action = 'list', $id = null)
{
$page->setTitle('Administration - Postfix : Blacklist');
$page->assign('title', 'Blacklist de postfix');
$table_editor->apply($page, $action, $id);
}
- function handler_postfix_whitelist(&$page, $action = 'list', $id = null)
+ function handler_postfix_whitelist($page, $action = 'list', $id = null)
{
$page->setTitle('Administration - Postfix : Whitelist');
$page->assign('title', 'Whitelist de postfix');
$table_editor->apply($page, $action, $id);
}
- function handler_mx_broken(&$page, $action = 'list', $id = null)
+ function handler_mx_broken($page, $action = 'list', $id = null)
{
$page->setTitle('Administration - MX Défaillants');
$page->assign('title', 'MX Défaillant');
$table_editor->apply($page, $action, $id);
}
- function handler_logger_actions(&$page, $action = 'list', $id = null)
+ function handler_logger_actions($page, $action = 'list', $id = null)
{
$page->setTitle('Administration - Actions');
$page->assign('title', 'Gestion des actions de logger');
$table_editor->apply($page, $action, $id);
}
- function handler_downtime(&$page, $action = 'list', $id = null)
+ function handler_downtime($page, $action = 'list', $id = null)
{
$page->setTitle('Administration - Coupures');
$page->assign('title', 'Gestion des coupures');
return $warning;
}
+ private static function updateCountry(array $item)
+ {
+ XDB::execute('UPDATE geoloc_countries
+ SET countryPlain = {?}
+ WHERE iso_3166_1_a2 = {?}',
+ mb_strtoupper(replace_accent($item['country'])), $item['iso_3166_1_a2']);
+ }
+
private static function isLanguageIncomplete(array &$item)
{
if ($item['language'] == '') {
return false;
}
- function handler_geocoding(&$page, $action = null)
+ private static function updateLanguage(array $item) {}
+
+ function handler_geocoding(&$page, $category = null, $action = null, $id = null)
{
// Warning, this handler requires the following packages:
// * pkg-isocodes
'id' => 'iso_3166_1_a2',
'main_fields' => array('iso_3166_1_a3', 'iso_3166_1_num', 'countryEn'),
'other_fields' => array('worldRegion', 'country', 'capital', 'nationality', 'nationalityEn',
- 'phonePrefix', 'phoneFormat', 'licensePlate', 'belongsTo', 'countryPlain')
+ 'phonePrefix', 'phoneFormat', 'licensePlate', 'belongsTo')
),
'language' => array(
'name' => 'langages',
)
);
- //For ISO 639, the first three columns are the ISO 639 2B code, the ISO 639 2T code and the ISO 639-1 code. The third column may be
- if (is_null($action) || !array_key_exists($action, $properties)) {
+ if (is_null($category) || !array_key_exists($category, $properties)) {
pl_redirect('admin');
}
- $data = $properties[$action];
+ $data = $properties[$category];
+
+ if ($action == 'edit' || $action == 'add') {
+ $main_fields = array_merge(array($data['id']), $data['main_fields']);
+ $all_fields = array_merge($main_fields, $data['other_fields']);
+
+ if (is_null($id)) {
+ if (Post::has('new_id')) {
+ $id = Post::v('new_id');
+ } else {
+ pl_redirect('admin/geocoding/' . $category);
+ }
+ }
+
+ $list = array();
+ exec('isoquery --iso=' . $data['isocode'] . ' ' . $id, $list);
+ if (count($list) == 1) {
+ $array = explode("\t", $list[0]);
+ foreach ($main_fields as $i => $field) {
+ $iso[$field] = $array[$i];
+ }
+ } else {
+ $iso = array();
+ }
+
+ if ($action == 'add') {
+ if (Post::has('new_id')) {
+ S::assert_xsrf_token();
+ }
+
+ if (count($iso)) {
+ $item = $iso;
+ } else {
+ $item = array($data['id'] => $id);
+ }
+ XDB::execute('INSERT INTO ' . $data['table'] . '(' . implode(', ', array_keys($item)) . ')
+ VALUES ' . XDB::formatArray($item));
+ $page->trigSuccess($id . ' a bien été ajouté à la base.');
+ } elseif ($action == 'edit') {
+ if (Post::has('edit')) {
+ S::assert_xsrf_token();
+
+ $item = array();
+ $set = array();
+ foreach ($all_fields as $field) {
+ $item[$field] = Post::t($field);
+ $set[] = $field . XDB::format(' = {?}', ($item[$field] ? $item[$field] : null));
+ }
+ XDB::execute('UPDATE ' . $data['table'] . '
+ SET ' . implode(', ', $set) . '
+ WHERE ' . $data['id'] . ' = {?}',
+ $id);
+ call_user_func_array(array('self', 'update' . ucfirst($category)), array($item));
+ $page->trigSuccess($id . ' a bien été mis à jour.');
+ } elseif (Post::has('del')) {
+ S::assert_xsrf_token();
+
+ XDB::execute('DELETE FROM ' . $data['table'] . '
+ WHERE ' . $data['id'] . ' = {?}',
+ $id);
+ $page->trigSuccessRedirect($id . ' a bien été supprimé.', 'admin/geocoding/' . $category);
+ } else {
+ $item = XDB::fetchOneAssoc('SELECT *
+ FROM ' . $data['table'] . '
+ WHERE ' . $data['id'] . ' = {?}',
+ $id);
+ }
+ }
+
+ $page->changeTpl('admin/geocoding_edit.tpl');
+ $page->setTitle('Administration - ' . ucfirst($data['name']));
+ $page->assign('category', $category);
+ $page->assign('name', $data['name']);
+ $page->assign('all_fields', $all_fields);
+ $page->assign('id', $id);
+ $page->assign('iso', $iso);
+ $page->assign('item', $item);
+ return;
+ }
$page->changeTpl('admin/geocoding.tpl');
$page->setTitle('Administration - ' . ucfirst($data['name']));
+ $page->assign('category', $category);
$page->assign('name', $data['name']);
$page->assign('id', $data['id']);
$page->assign('main_fields', $data['main_fields']);
}
if ($error == true) {
$erroneous[$id] = $item;
- } elseif (call_user_func_array(array('self', 'is' . ucfirst($action) . 'Incomplete'), array(&$item))) {
+ } elseif (call_user_func_array(array('self', 'is' . ucfirst($category) . 'Incomplete'), array(&$item))) {
$incomplete[$id] = $item;
} else {
$remaining[$id] = $item;
{
$page->changeTpl('admin/accounts.tpl');
$page->setTitle('Administration - Comptes');
- $page->addJsLink('password.js');
if (Post::has('create_account')) {
S::assert_xsrf_token();
}
- function handler_account_types(&$page, $action = 'list', $id = null)
+ function handler_account_types($page, $action = 'list', $id = null)
{
$page->setTitle('Administration - Types de comptes');
$page->assign('title', 'Gestion des types de comptes');
$table_editor->apply($page, $action, $id);
}
- function handler_wiki(&$page, $action = 'list', $wikipage = null, $wikipage2 = null)
+ function handler_wiki($page, $action = 'list', $wikipage = null, $wikipage2 = null)
{
if (S::hasAuthToken()) {
$page->setRssLink('Changement Récents',
$page->assign('perms_opts', $perms);
}
- function handler_ipwatch(&$page, $action = 'list', $ip = null)
+ function handler_ipwatch($page, $action = 'list', $ip = null)
{
$page->changeTpl('admin/ipwatcher.tpl');
}
}
- function handler_icons(&$page)
+ function handler_icons($page)
{
$page->changeTpl('admin/icons.tpl');
$dh = opendir('../htdocs/images/icons');
$page->assign('icons', $icons);
}
- function handler_account_watch(&$page)
+ function handler_account_watch($page)
{
$page->changeTpl('admin/accounts.tpl');
$page->assign('disabled', XDB::iterator('SELECT a.hruid, FIND_IN_SET(\'watch\', a.flags) AS watch,
ORDER BY a.hruid'));
}
- function handler_jobs(&$page, $id = -1)
+ function handler_jobs($page, $id = -1)
{
$page->changeTpl('admin/jobs.tpl');
}
}
- function handler_profile(&$page)
+ function handler_profile($page)
{
$page->changeTpl('admin/profile.tpl');