web/public_php/app/app_achievements_admin/index.php

   1 <?php
   2
   3 $microstart = explode(' ',microtime());
   4 $start_time = $microstart[0] + $microstart[1];
   5
   6 error_reporting(E_ALL ^ E_NOTICE);
   7 ini_set("display_errors","1");
   8
   9 define('APP_NAME', 'app_achievements_admin');
  10
  11 require_once('../config.php');
  12 include_once('../lang.php');
  13 include_once('lang.php');
  14 require_once('conf.php');
  15
  16 // Ask to authenticate user (using ingame or session method) and fill $user with all information
  17 ryzom_app_authenticate($user, true);
  18
  19 #echo var_export($user,true);
  20
  21 /*$user = array();
  22 $user['id'] = 1;
  23 $user['lang'] = 'en';
  24 $user['name'] = 'Talvela';
  25 $user['race'] = "r_matis";
  26 $user['civilization'] = "c_neutral";
  27 $user['cult'] = "c_neutral";
  28 $user['admin'] = true;*/
  29
  30 require_once($_CONF['app_achievements_path']."class/RyzomUser_class.php");
  31 require_once("class/RyzomAdmin_class.php");
  32 $_ADMIN = new RyzomAdmin($user);
  33
  34 if($_ADMIN->isIG()) {
  35         die("IG disabled for admin tool!");
  36 }
  37
  38 require_once("class/mySQL_class.php");
  39
  40 require_once($_CONF['app_achievements_path']."include/ach_render_common.php");
  41
  42 require_once($_CONF['app_achievements_path']."class/DLL_class.php");
  43 require_once($_CONF['app_achievements_path']."class/Node_abstract.php");
  44 require_once($_CONF['app_achievements_path']."class/AVLTree_class.php");
  45 require_once($_CONF['app_achievements_path']."class/Parentum_abstract.php");
  46 require_once($_CONF['app_achievements_path']."class/AchList_abstract.php");
  47 require_once($_CONF['app_achievements_path']."class/Tieable_inter.php");
  48 require_once($_CONF['app_achievements_path']."class/NodeIterator_class.php");
  49 #require_once($_CONF['app_achievements_path']."class/InDev_trait.php");
  50
  51 require_once($_CONF['app_achievements_path']."class/AchMenu_class.php");
  52 require_once($_CONF['app_achievements_path']."class/AchMenuNode_class.php");
  53 require_once($_CONF['app_achievements_path']."class/AchCategory_class.php");
  54 require_once($_CONF['app_achievements_path']."class/AchAchievement_class.php");
  55 require_once($_CONF['app_achievements_path']."class/AchTask_class.php");
  56 require_once($_CONF['app_achievements_path']."class/AchObjective_class.php");
  57 require_once($_CONF['app_achievements_path']."class/AchSummary_class.php");
  58
  59 require_once("class/ADM_inter.php");
  60 #require_once("class/AdmDispatcher_trait.php");
  61 require_once("class/AdmMenu_class.php");
  62 require_once("class/AdmMenuNode_class.php");
  63 require_once("class/AdmCategory_class.php");
  64 require_once("class/AdmAchievement_class.php");
  65 require_once("class/AdmTask_class.php");
  66 require_once("class/AdmObjective_class.php");
  67 require_once("class/AdmAtom_class.php");
  68
  69 #require_once("class/CSRDispatcher_trait.php");
  70 require_once("class/CSR_inter.php");
  71 require_once("class/CSRCategory_class.php");
  72 require_once("class/CSRAchievement_class.php");
  73 require_once("class/CSRTask_class.php");
  74 require_once("class/CSRObjective_class.php");
  75 require_once("class/CSRAtom_class.php");
  76
  77 $DBc = ryDB::getInstance("app_achievements");
  78
  79 function mkn($x) { // make NULL function for SQL
  80         global $DBc;
  81         if($x == null || strtolower($x) == "null" || $x == "") {
  82                 return "NULL";
  83         }
  84         else {
  85                 return "'".$DBc->sqlEscape($x)."'";
  86         }
  87 }
  88
  89
  90 $c = "<script type='text/javascript'>
  91
  92                 function hs(id,mod) { // hide / show
  93                         if(document.getElementById(id).style.display == 'none') {
  94                                 document.getElementById(id).style.display=mod;
  95                         }
  96                         else {
  97                                 document.getElementById(id).style.display='none';
  98                         }
  99                 }
 100
 101                 function hs_force(id,mod,show) { // hide / show forced
 102                         if(show == true) {
 103                                 document.getElementById(id).style.display=mod;
 104                         }
 105                         else {
 106                                 document.getElementById(id).style.display='none';
 107                         }
 108                 }
 109 </script>
 110
 111 <style>
 112         h1 {
 113                 margin-top:0px;
 114         }
 115 </style>
 116
 117 <center><table width='100%'>
 118         <tr>
 119                 <td valign='top' width='200px'><div style='font-weight:bold;font-size:14px;'>";
 120
 121                 if($_ADMIN->isAdmin()) {
 122                         $c .= "<b>Admin</b><br>
 123                         <ul>
 124                                 <li><a href='?mode=menu'>menu settings</a></li>
 125                                 <li><a href='?mode=ach'>achievement settings</a></li>
 126                                 <li><a href='?mode=atom'>trigger settings</a></li>
 127                                 <li><a href='?mode=lang'>language editor</a></li>
 128                                 <li><a href='?mode=stats'>statistics</a></li>
 129                         </ul><p />";
 130                 }
 131                 if($_ADMIN->isCSR()) {
 132                         $c .= "<b>CSR</b><br>
 133                         <ul>
 134                                 <li><a href='?mode=player'>player administration</a></li>
 135                         </ul><p />";
 136                 }
 137
 138
 139
 140 $c .= "</div></td>
 141                 <td valign='top'>";
 142
 143                 /*if($_REQUEST['mode'] == "insert_fame" && $_ADMIN->isAdmin()) {
 144                         $ftpl = 'ENTITY fame AS $fame {
 145         if($fame->faction == ".faction" && ceil($fame->fame/6000) >= [0]) {
 146                 GRANT;
 147                 FINAL ENTITY;
 148         }
 149 }';
 150
 151                         $res = $DBc->sqlQuery("SELECT at_id,atl_name FROM ach_achievement,ach_task,ach_task_lang WHERE at_achievement=aa_id AND ((aa_category<'24' AND aa_category>'15') OR aa_category='56') AND atl_task=at_id AND atl_lang='en'");
 152
 153                         for($i=0;$i<sizeof($res);$i++) {
 154                                 $DBc->sqlQuery("INSERT INTO ach_objective (ao_task,ao_condition,ao_value,ao_display,ao_metalink) VALUES ('".$res[$i]['at_id']."','all',NULL,'hidden',NULL)");
 155                                 $nid = $DBc->insertID();
 156                                 $DBc->sqlQuery("INSERT INTO ach_atom (atom_objective,atom_mandatory,atom_ruleset) VALUES ('".$nid."','0','".$DBc->sqlEscape(str_replace('[0]',$res[$i]['atl_name'],$ftpl))."')");
 157
 158                                 $c .= "INSERT INTO ach_objective (ao_task,ao_condition,ao_value,ao_display,ao_metalink) VALUES ('".$res[$i]['at_id']."','all',NULL,'hidden',NULL)<br>";
 159
 160                                 $c .= "INSERT INTO ach_atom (atom_objective,atom_mandatory,atom_ruleset) VALUES ('".$nid."','0','".$DBc->sqlEscape(str_replace('[0]',$res[$i]['atl_name'],$ftpl))."')<p>";
 161                         }
 162                 }
 163
 164                 if($_REQUEST['mode'] == "enable_fame" && $_ADMIN->isAdmin()) {
 165                         $res = $DBc->sqlQuery("SELECT aa_id FROM ach_achievement WHERE (aa_category<'24' AND aa_category>'14') OR aa_category='56'");
 166
 167                         for($i=0;$i<sizeof($res);$i++) {
 168                                 $DBc->sqlQuery("UPDATE ach_achievement SET aa_dev='0' WHERE aa_id='".$res[$i]['aa_id']."'");
 169
 170                                 $DBc->sqlQuery("UPDATE ach_task SET at_dev='0' WHERE at_achievement='".$res[$i]['aa_id']."'");
 171                         }
 172                 }*/
 173
 174                 /*
 175                  * translation
 176                  */
 177                 if($_REQUEST['mode'] == "lang" && $_ADMIN->isAdmin()) {
 178                         $c .= "<h1>Language Editor</h1>";
 179
 180                         $user = array();
 181                         $user['id'] = 0;
 182                         $user['lang'] = 'en';
 183                         $user['name'] = 'Talvela';
 184                         $user['race'] = "matis";
 185                         $user['civ'] = "neutral";
 186                         $user['cult'] = "neutral";
 187
 188                         $_USER = new RyzomUser($user);
 189
 190                         //menu
 191                         require_once("include/adm_render_lang.php");
 192                         $menu = new AdmMenu($_REQUEST['cat']);
 193
 194                         $c .= "<center><table>
 195                         <tr>
 196                                 <td valign='top'><div style='width:230px;font-weight:bold;font-size:14px;'>";
 197
 198
 199                         $c .= adm_render_menu($menu);
 200
 201                         $c .= "</div></td>
 202                                         <td width='645px' valign='top'>";
 203
 204                         $open = $menu->getOpenCat();
 205
 206                         if($open != 0) {
 207                                 $cat = new AdmCategory($open,'%','%','%');
 208
 209                                 if($_REQUEST['act'] == "cat_save") {
 210                                         if(is_array($_REQUEST['c_name'])) {
 211                                                 foreach($_REQUEST['c_name'] as $key=>$elem) {
 212                                                         $cat->setLang($key,$_REQUEST['c_name'][$key]);
 213                                                 }
 214                                         }
 215                                 }
 216
 217                                 if($_REQUEST['act'] == "ach_save") {
 218                                         $ach = $cat->getElementByPath($_REQUEST['id']);
 219
 220                                         if(is_array($_REQUEST['a_name'])) {
 221                                                 foreach($_REQUEST['a_name'] as $key=>$elem) {
 222                                                         $ach->setLang($key,$_REQUEST['a_name'][$key],$_REQUEST['a_tpl'][$key]);
 223                                                 }
 224                                         }
 225                                 }
 226
 227                                 if($_REQUEST['act'] == "task_save") {
 228                                         $task = $cat->getElementByPath($_REQUEST['id']);
 229
 230                                         if(is_array($_REQUEST['t_name'])) {
 231                                                 foreach($_REQUEST['t_name'] as $key=>$elem) {
 232                                                         $task->setLang($key,$_REQUEST['t_name'][$key],$_REQUEST['t_tpl'][$key]);
 233                                                 }
 234                                         }
 235                                 }
 236
 237                                 if($_REQUEST['act'] == "obj_save") {
 238                                         $obj = $cat->getElementByPath($_REQUEST['id']);
 239
 240                                         if(is_array($_REQUEST['o_name'])) {
 241                                                 foreach($_REQUEST['o_name'] as $key=>$elem) {
 242                                                         $obj->setLang($key,$_REQUEST['o_name'][$key]);
 243                                                 }
 244                                         }
 245                                 }
 246
 247
 248
 249                                 $c .= atom_render_category($cat);
 250                         }
 251
 252
 253                         $c .= "</td>
 254                                 </tr>
 255                         </table></center>";
 256
 257                 }
 258
 259                 /*
 260                  * Trigger settings
 261                  */
 262
 263                 if($_REQUEST['mode'] == "atom" && $_ADMIN->isAdmin()) {
 264                         $c .= "<h1>Trigger Settings</h1>";
 265
 266                         $user = array();
 267                         $user['id'] = 0;
 268                         $user['lang'] = 'en';
 269                         $user['name'] = 'Talvela';
 270                         $user['race'] = "matis";
 271                         $user['civ'] = "neutral";
 272                         $user['cult'] = "neutral";
 273
 274                         $_USER = new RyzomUser($user);
 275
 276                         //menu
 277                         require_once("include/adm_render_atom.php");
 278                         $menu = new AdmMenu($_REQUEST['cat']);
 279
 280                         $c .= "<center><table>
 281                         <tr>
 282                                 <td valign='top'><div style='width:230px;font-weight:bold;font-size:14px;'>";
 283
 284
 285                         $c .= adm_render_menu($menu);
 286
 287                         $c .= "</div></td>
 288                                         <td width='645px' valign='top'>";
 289
 290                         $open = $menu->getOpenCat();
 291
 292                         if($open != 0) {
 293                                 $cat = new AdmCategory($open,'%','%','%');
 294
 295                                 if($_REQUEST['act'] == "insert_atom") {
 296                                         $obj = $cat->getElementByPath($_REQUEST['id']);
 297
 298                                         if($obj != null) {
 299                                                 $atom = new AdmAtom(array(),$obj);
 300                                                 $atom->setRuleset($_REQUEST['atom_ruleset']);
 301                                                 $atom->setMandatory($_REQUEST['atom_mandatory']);
 302                                                 $atom->setObjective($obj->getID());
 303
 304                                                 $obj->insertNode($atom);
 305                                         }
 306                                 }
 307
 308                                 if($_REQUEST['act'] == "update_atom") {
 309                                         $atom = $cat->getElementByPath($_REQUEST['id']);
 310
 311                                         if($atom != null) {
 312                                                 $atom->setRuleset($_REQUEST['atom_ruleset']);
 313                                                 $atom->setMandatory($_REQUEST['atom_mandatory']);
 314
 315                                                 $atom->update();
 316                                         }
 317                                 }
 318
 319                                 if($_REQUEST['act'] == "delete") {
 320                                         $elem = $cat->getElementByPath($_REQUEST['id']);
 321                                         $par = $elem->getParent();
 322                                         $par->removeNode($elem->getID());
 323                                 }
 324
 325                                 $c .= atom_render_category($cat);
 326                         }
 327
 328                         $c .= "</td>
 329                                 </tr>
 330                         </table></center>";
 331
 332                 }
 333
 334                 /*
 335                  * Menu settings
 336                  */
 337
 338                 if($_REQUEST['mode'] == "menu" && $_ADMIN->isAdmin()) {
 339                         $c .= "<h1>Menu Settings</h1>";
 340
 341                         $user = array();
 342                         $user['id'] = 1;
 343                         $user['lang'] = 'en';
 344                         $user['name'] = 'Talvela';
 345                         $user['race'] = "matis";
 346                         $user['civ'] = "neutral";
 347                         $user['cult'] = "neutral";
 348
 349                         $_USER = new RyzomUser($user);
 350
 351                         require_once("include/adm_render_menu.php");
 352                         $menu = new AdmMenu(false);
 353
 354                         if($_REQUEST['act'] == "insert") {
 355                                 $n = new AdmMenuNode(array(),null);
 356                                 $n->setID(null);
 357                                 $n->setInDev(true);
 358                                 $n->setName($_REQUEST['acl_name']);
 359                                 $n->setImage($_REQUEST['ac_image']);
 360                                 $n->setParentID($_REQUEST['ac_parent']);
 361
 362                                 $menu->insertNode($n);
 363                         }
 364
 365                         if($_REQUEST['act'] == "delete") {
 366                                 $menu->removeNode($_REQUEST['ac_id']);
 367                         }
 368
 369                         if($_REQUEST['act'] == "update") {
 370                                 $menu->updateNode($_REQUEST['ac_id'],array("acl_name"=>$_REQUEST['acl_name'],"ac_image"=>$_REQUEST['ac_image']));
 371                         }
 372
 373                         if($_REQUEST['act'] == "dev") {
 374                                 $curr = $menu->getNode($_REQUEST['ac_id']);
 375                                 $curr->setInDev(($_REQUEST['state'] != 1));
 376                         }
 377
 378
 379                         $c .= adm_render_menu($menu);
 380                 }
 381
 382                 /*
 383                  * Achievement settings
 384                  */
 385
 386                 if($_REQUEST['mode'] == "ach" && $_ADMIN->isAdmin()) {
 387                         $c .= "<h1>Achievement Settings</h1>";
 388
 389                         $user = array();
 390                         $user['id'] = 0;
 391                         $user['lang'] = 'en';
 392                         $user['name'] = 'Talvela';
 393                         $user['race'] = "matis";
 394                         $user['civ'] = "neutral";
 395                         $user['cult'] = "neutral";
 396
 397                         $_USER = new RyzomUser($user);
 398
 399                         //menu
 400                         require_once("include/adm_render_ach.php");
 401                         $menu = new AdmMenu($_REQUEST['cat']);
 402
 403                         $c .= "<center><table>
 404                         <tr>
 405                                 <td valign='top'><div style='width:230px;font-weight:bold;font-size:14px;'>";
 406
 407
 408                         $c .= adm_render_menu($menu);
 409
 410                         $c .= "</div></td>
 411                                         <td width='645px' valign='top'>";
 412
 413                         $open = $menu->getOpenCat();
 414
 415                         if($open != 0) {
 416                                 if($_REQUEST['cult']) {
 417                                         $cult = $_REQUEST['cult'];
 418                                         $_SESSION['cult'] = $cult;
 419                                 }
 420                                 elseif($_SESSION['cult']) {
 421                                         $cult = $_SESSION['cult'];
 422                                 }
 423                                 else {
 424                                         $cult = $_USER->getCult();
 425                                 }
 426
 427                                 if($_REQUEST['civ']) {
 428                                         $civ = $_REQUEST['civ'];
 429                                         $_SESSION['civ'] = $civ;
 430                                 }
 431                                 elseif($_SESSION['civ']) {
 432                                         $civ = $_SESSION['civ'];
 433                                 }
 434                                 else {
 435                                         $civ = $_USER->getCiv();
 436                                 }
 437
 438                                 echo $civ.$cult;
 439
 440                                 $cat = new AdmCategory($open,$_USER->getRace(),$cult,$civ);
 441
 442                                 $microstop = explode(' ',microtime());
 443                                 $stop_time = $microstop[0] + $microstop[1];
 444
 445                                 echo "<br>loading: ".round($stop_time - $start_time,3);
 446
 447                                 $start_time = $stop_time;
 448
 449                                 if($_REQUEST['act'] == "ach_move") {
 450                                         $ach = $cat->getChildDataByID($_REQUEST['id']);
 451                                         if($ach != null) {
 452                                                 $ach->setCategory($_REQUEST['new_cat']);
 453                                                 $ach->update();
 454                                                 $cat->removeChild($ach->getID());
 455
 456                                                 $iter = $cat->getOpen();
 457                                                 while($iter->hasNext()) {
 458                                                         $item = $iter->getNext();
 459
 460                                                         if($ach->getID() == $item->getParentID()) {
 461                                                                 $item->setCategory($_REQUEST['new_cat']);
 462                                                                 $item->update();
 463                                                                 $cat->removeChild($item->getID());
 464                                                         }
 465                                                 }
 466                                         }
 467                                 }
 468
 469                                 if($_REQUEST['act'] == "ach_insert") {
 470                                         $ach = new AdmAchievement(array(),$cat);
 471                                         $ach->setCategory($cat->getID());
 472                                         $ach->setName($_REQUEST['aal_name']);
 473                                         $ach->setTemplate($_REQUEST['aal_template']);
 474                                         $ach->setImage($_REQUEST['aa_image']);
 475                                         $ach->setParentID($_REQUEST['aa_parent']);
 476                                         $ach->setSticky($_REQUEST['aa_sticky']);
 477
 478                                         $cat->insertNode($ach);
 479
 480                                         $task = new AdmTask(array(),$ach);
 481                                         $task->setAchievement($ach->getID());
 482                                         $task->setName($_REQUEST['atl_name']);
 483                                         $task->setTemplate($_REQUEST['atl_template']);
 484                                         $task->setValue($_REQUEST['at_value']);
 485                                         $task->setCondition($_REQUEST['at_condition']);
 486                                         $task->setConditionValue($_REQUEST['at_condition_value']);
 487                                         $task->setHeritage(0);
 488
 489                                         if(is_array($_REQUEST['at_tie_allegiance'])) {
 490                                                 $task->setTieAlign($_REQUEST['at_tie_allegiance']);
 491                                         }
 492
 493                                         $ach->insertNode($task);
 494                                 }
 495
 496                                 if($_REQUEST['act'] == "ach_update") {
 497                                         $ach = $cat->getChildDataByID($_REQUEST['id']);
 498
 499                                         if($ach != null) {
 500                                                 $ach->setName($_REQUEST['aal_name']);
 501                                                 $ach->setTemplate($_REQUEST['aal_template']);
 502                                                 #$ach->setTieCult($_REQUEST['aa_tie_cult']);
 503                                                 #$ach->setTieCiv($_REQUEST['aa_tie_civ']);
 504                                                 $ach->setImage($_REQUEST['aa_image']);
 505                                                 $ach->setParentID($_REQUEST['aa_parent']);
 506                                                 $ach->setSticky($_REQUEST['aa_sticky']);
 507
 508                                                 $ach->update();
 509                                         }
 510                                 }
 511
 512                                 if($_REQUEST['act'] == "task_insert") {
 513                                         $ach = $cat->getChildDataByID($_REQUEST['id']);
 514                                         if($ach != null) {
 515                                                 $task = new AdmTask(array(),$ach);
 516                                                 $task->setAchievement($ach->getID());
 517                                                 $task->setName($_REQUEST['atl_name']);
 518                                                 $task->setTemplate($_REQUEST['atl_template']);
 519                                                 $task->setValue($_REQUEST['at_value']);
 520                                                 $task->setCondition($_REQUEST['at_condition']);
 521                                                 $task->setConditionValue($_REQUEST['at_condition_value']);
 522                                                 $task->setHeritage($_REQUEST['at_inherit']);
 523
 524                                                 if(is_array($_REQUEST['at_tie_allegiance'])) {
 525                                                         $task->setTieAlign($_REQUEST['at_tie_allegiance']);
 526                                                 }
 527
 528                                                 $ach->insertNode($task);
 529                                                 $task->setParentID($_REQUEST['at_parent']);
 530                                                 $ach->orderTasks();
 531                                                 $task->update();
 532                                         }
 533                                 }
 534
 535                                 if($_REQUEST['act'] == "task_update") {
 536                                         $task = $cat->getElementByPath($_REQUEST['id']);
 537
 538                                         if($task != null) {
 539                                                 $task->setName($_REQUEST['atl_name']);
 540                                                 $task->setTemplate($_REQUEST['atl_template']);
 541                                                 $task->setValue($_REQUEST['at_value']);
 542                                                 $task->setCondition($_REQUEST['at_condition']);
 543                                                 $task->setConditionValue($_REQUEST['at_condition_value']);
 544                                                 $task->setHeritage($_REQUEST['at_inherit']);
 545
 546                                                 if(is_array($_REQUEST['at_tie_allegiance'])) {
 547                                                         $task->setTieAlign($_REQUEST['at_tie_allegiance']);
 548                                                 }
 549
 550                                                 $task->setParentID($_REQUEST['at_parent']);
 551
 552                                                 $ach = $task->getParent();
 553                                                 $ach->orderTasks();
 554
 555                                                 $task->update();
 556                                         }
 557                                 }
 558
 559                                 if($_REQUEST['act'] == "obj_insert") {
 560                                         $task = $cat->getElementByPath($_REQUEST['id']);
 561
 562                                         if($task != null) {
 563                                                 $obj = new AdmObjective(array(),$task);
 564                                                 $obj->setName($_REQUEST['aol_name']);
 565                                                 $obj->setCondition($_REQUEST['ao_condition']);
 566                                                 $obj->setValue($_REQUEST['ao_value']);
 567                                                 $obj->setDisplay($_REQUEST['ao_display']);
 568                                                 $obj->setMetalink($_REQUEST['ao_metalink']);
 569                                                 $obj->setTask($task->getID());
 570
 571                                                 $task->insertNode($obj);
 572                                         }
 573                                 }
 574
 575                                 if($_REQUEST['act'] == "obj_update") {
 576                                         $obj = $cat->getElementByPath($_REQUEST['id']);
 577
 578                                         if($obj != null) {
 579                                                 $obj->setName($_REQUEST['aol_name']);
 580                                                 $obj->setCondition($_REQUEST['ao_condition']);
 581                                                 $obj->setValue($_REQUEST['ao_value']);
 582                                                 $obj->setDisplay($_REQUEST['ao_display']);
 583                                                 $obj->setMetalink($_REQUEST['ao_metalink']);
 584
 585                                                 $obj->update();
 586                                         }
 587                                 }
 588
 589                                 if($_REQUEST['act'] == "delete") {
 590                                         $elem = $cat->getElementByPath($_REQUEST['id']);
 591                                         if($elem != null) {
 592                                                 $par = $elem->getParent();
 593                                                 $par->removeNode($elem->getID());
 594
 595                                                 if(get_class($elem) == "AdmAchievement") {
 596                                                         $iter = $cat->getOpen();
 597                                                         while($iter->hasNext()) {
 598                                                                 $item = $iter->getNext();
 599
 600                                                                 if($elem->getID() == $item->getParentID()) {
 601                                                                         $item->setParentID(null);
 602                                                                         $item->update();
 603                                                                 }
 604                                                         }
 605                                                 }
 606                                         }
 607                                 }
 608
 609                                 if($_REQUEST['act'] == "dev") {
 610                                         $curr = $cat->getElementByPath($_REQUEST['id']);
 611                                         $curr->setInDev(($_REQUEST['state'] != 1));
 612                                 }
 613
 614                                 $microstop = explode(' ',microtime());
 615                                 $stop_time = $microstop[0] + $microstop[1];
 616
 617                                 echo "<br>manipulation: ".round($stop_time - $start_time,3);
 618
 619                                 $start_time = $stop_time;
 620
 621                                 $c .= adm_render_category($cat);
 622
 623                                 $microstop = explode(' ',microtime());
 624                                 $stop_time = $microstop[0] + $microstop[1];
 625
 626                                 echo "<br>rendering: ".round($stop_time - $start_time,3);
 627                         }
 628
 629                         $c .= "</td>
 630                                 </tr>
 631                         </table></center>";
 632
 633                 }
 634
 635                 /*
 636                  * Statistics page
 637                  */
 638
 639                 if($_REQUEST['mode'] == "stats" && $_ADMIN->isCSR()) {
 640                         require_once("include/adm_render_stats.php");
 641
 642                         $c .= "<h1>Statistics</h1>";
 643
 644                         $c .= stats_render();
 645                 }
 646
 647                 /*
 648                  * CSR player manager
 649                  */
 650                 if($_REQUEST['mode'] == "player" && $_ADMIN->isCSR()) {
 651                         $c .= "<h1>Player Administration</h1>";
 652
 653                         #$DBc_char = new mySQL($_CONF['mysql_error']);
 654                         #$DBc_char->connect($_CONF['char_mysql_server'],$_CONF['char_mysql_user'],$_CONF['char_mysql_pass'],$_CONF['char_mysql_database']);
 655
 656                         $DBc_char = ryDB::getInstance("webig");
 657                         //menu
 658                         require_once("include/adm_render_csr.php");
 659
 660                         if(!is_user($_REQUEST['pid'])) { // no user ID
 661                                 $c .= csr_render_find_player();
 662                         }
 663                         else {
 664                                 $user = array();
 665                                 $user['id'] = $_REQUEST['pid'];
 666                                 $user['lang'] = 'en';
 667                                 $dta = user_get_data($_REQUEST['pid']);
 668                                 $user['char_name'] = user_get_name($_REQUEST['pid']);
 669                                 $user['race'] = substr($dta['race'],2);
 670                                 $user['civ'] = substr($dta['civilisation'],2);
 671                                 $user['cult'] = substr($dta['cult'],2);
 672
 673                                 $_USER = new RyzomUser($user);
 674
 675                                 $menu = new AchMenu($_REQUEST['cat']);
 676
 677                                 $open = $menu->getOpenCat();
 678
 679                                 if($open != 0) {
 680                                         if($_REQUEST['cult']) {
 681                                                 $cult = $_REQUEST['cult'];
 682                                                 $_SESSION['cult'] = $cult;
 683                                         }
 684                                         elseif($_SESSION['cult']) {
 685                                                 $cult = $_SESSION['cult'];
 686                                         }
 687                                         else {
 688                                                 $cult = $_USER->getCult();
 689                                         }
 690
 691                                         if($_REQUEST['civ']) {
 692                                                 $civ = $_REQUEST['civ'];
 693                                                 $_SESSION['civ'] = $civ;
 694                                         }
 695                                         elseif($_SESSION['civ']) {
 696                                                 $civ = $_SESSION['civ'];
 697                                         }
 698                                         else {
 699                                                 $civ = $_USER->getCiv();
 700                                         }
 701
 702                                         $cat = new CSRCategory($open,$_USER->getRace(),$cult,$civ);
 703
 704                                         if($_REQUEST['grant'] != "") {
 705                                                 $cat->grantNode($_REQUEST['grant'],$_USER->getID());
 706                                         }
 707
 708                                         if($_REQUEST['deny'] != "") {
 709                                                 $cat->denyNode($_REQUEST['deny'],$_USER->getID());
 710                                         }
 711                                 }
 712
 713
 714                                 $c .= "<center><table>
 715                                 <tr>
 716                                 <td colspan='2' align='left'>".csr_render_yubopoints($user['id'])."</td>
 717                         </tr>
 718                                 <tr>
 719                                         <td valign='top'><div style='width:230px;font-weight:bold;font-size:14px;'>";
 720
 721
 722                                 $c .= csr_render_menu($menu);
 723
 724                                 $c .= "</div></td>
 725                                                 <td width='645px' valign='top'>";
 726
 727
 728                                 if($open != 0) {
 729                                         $c .= csr_render_category($cat);
 730                                 }
 731                                 else {
 732                                         $cat = new AchSummary($menu,3);
 733                                         $c .= ach_render_summary_header();
 734                                 }
 735
 736                                 if($open == 0) {
 737                                         $c .= ach_render_summary_footer($cat);
 738                                 }
 739
 740                                 $c .= "</td>
 741                                         </tr>
 742                                 </table></center>";
 743                         }
 744
 745                 }
 746
 747 $c .= "</td>
 748         </tr>
 749 </table></center>";
 750
 751 #$c = var_export($_USER).$c;
 752
 753 echo ryzom_app_render("achievements admin", $c, $_ADMIN->isIG());
 754
 755 ?>