?  search:
summary | log | graphiclog1 | graphiclog2 | commit | commitdiff | tree | refs | edit | fork
blame | history | raw | HEAD
Linux multi-monitor fullscreen support
[ryzomcore.git] / web / public_php / admin / functions_tool_administration.php
blobe65e48a9f43a511bd475226446cea993c1ef1385
1 <?php
2
3 $tool_admin_menu = array(array('title' => 'Main',
4 'key' => 'help',
5 'uri' => 'tool_administration.php?toolmode=help',
6 'tpl' => 'tool_administration.tpl',
7 'access' => '', // ALWAYS LEAVE EMPTY !
8 ),
9 array('title' => 'Users',
10 'key' => 'users',
11 'uri' => 'tool_administration.php?toolmode=users',
12 'tpl' => 'tool_administration_users.tpl',
13 'access' => 'tool_admin_user',
14 ),
15 array('title' => 'Groups',
16 'key' => 'groups',
17 'uri' => 'tool_administration.php?toolmode=groups',
18 'tpl' => 'tool_administration_groups.tpl',
19 'access' => 'tool_admin_group',
20 ),
21 array('title' => 'Restarts',
22 'key' => 'restarts',
23 'uri' => 'tool_administration.php?toolmode=restarts',
24 'tpl' => 'tool_administration_restarts.tpl',
25 'access' => 'tool_admin_restart',
26 ),
27 array('title' => 'Applications',
28 'key' => 'applications',
29 'uri' => 'tool_administration.php?toolmode=applications',
30 'tpl' => 'tool_administration_applications.tpl',
31 'access' => 'tool_admin_application',
32 ),
33 array('title' => 'Domains',
34 'key' => 'domains',
35 'uri' => 'tool_administration.php?toolmode=domains',
36 'tpl' => 'tool_administration_domains.tpl',
37 'access' => 'tool_admin_domain',
38 ),
39 array('title' => 'Shards',
40 'key' => 'shards',
41 'uri' => 'tool_administration.php?toolmode=shards',
42 'tpl' => 'tool_administration_shards.tpl',
43 'access' => 'tool_admin_shard',
44 ),
45 array('title' => 'Logs',
46 'key' => 'logs',
47 'uri' => 'tool_administration.php?toolmode=logs',
48 'tpl' => 'tool_administration_logs.tpl',
49 'access' => 'tool_admin_logs',
50 ),
51 );
52
53 $tool_language_list = array(array('lang_id' => 'en',
54 'lang_name' => 'English',
55 ),
56 array('lang_id' => 'fr',
57 'lang_name' => 'French',
58 ),
59 array('lang_id' => 'de',
60 'lang_name' => 'German',
61 ),
62 );
63
64 function tool_admin_menu_get_item_from_key($key)
65 {
66 global $tool_admin_menu;
67
68 reset($tool_admin_menu);
69 foreach($tool_admin_menu as $tool_menu)
70 {
71 if ($tool_menu['key'] == $key) return $tool_menu;
72 }
73
74 return null;
75 }
76
77 function tool_admin_users_get_list($group_list)
78 {
79 global $db;
80
81 $data = null;
82
83 $sql = "SELECT * FROM ". NELDB_USER_TABLE ." ORDER BY user_name ASC";
84 if ($result = $db->sql_query($sql))
85 {
86 if ($db->sql_numrows($result))
87 {
88 $data = array();
89 while ($row = $db->sql_fetchrow($result))
90 {
91 $row['user_group_name'] = tool_admin_groups_get_name_from_id($group_list, $row['user_group_id']);
92 $data[] = $row;
93 }
94 }
95 }
96
97 return $data;
98 }
99
100 function tool_admin_groups_get_user_list($group_id)
101 {
102 global $db;
103
104 $data = array();
105
106 $sql = "SELECT * FROM ". NELDB_USER_TABLE ." WHERE user_group_id=". $group_id ." ORDER BY user_name ASC";
107 if ($result = $db->sql_query($sql))
108 {
109 if ($db->sql_numrows($result))
110 {
111 $data = $db->sql_fetchrowset($result);
112 }
113 }
114
115 return $data;
116 }
117
118 function tool_admin_groups_get_list()
119 {
120 global $db;
121
122 $data = null;
123
124 $sql = "SELECT * FROM ". NELDB_GROUP_TABLE ." ORDER BY group_name ASC";
125 if ($result = $db->sql_query($sql))
126 {
127 if ($db->sql_numrows($result))
128 {
129 while ($row = $db->sql_fetchrow($result))
130 {
131 $row['group_level_name'] = tool_admin_groups_get_level_name_from_id($row['group_level']);
132 $data[] = $row;
133 }
134 }
135 }
136
137 return $data;
138 }
139
140 function tool_admin_groups_get_level_name_from_id($group_level)
141 {
142 global $nel_user_group_levels;
143
144 reset($nel_user_group_levels);
145 foreach($nel_user_group_levels as $level_data)
146 {
147 if ($group_level == $level_data['level_id'])
148 {
149 return $level_data['level_name'];
150 }
151 }
152
153 return tool_admin_groups_get_level_name_from_id(0);
154 }
155
156 function tool_admin_groups_get_name_from_id($group_list, $group_id)
157 {
158 $data = 'unknown';
159
160 reset($group_list);
161 foreach($group_list as $group_data)
162 {
163 if ($group_data['group_id'] == $group_id)
164 {
165 $data = $group_data['group_name'];
166 }
167 }
168
169 return $data;
170 }
171
172 function tool_admin_users_get_id($user_id)
173 {
174 global $db;
175
176 $data = null;
177
178 $sql = "SELECT * FROM ". NELDB_USER_TABLE ." WHERE user_id=". $user_id;
179 if ($result = $db->sql_query($sql))
180 {
181 if ($db->sql_numrows($result))
182 {
183 $data = $db->sql_fetchrow($result);
184 }
185 }
186 return $data;
187 }
188
189 function tool_admin_users_add($user_name, $user_password, $user_group, $user_active)
190 {
191 global $db;
192
193 $user_name = trim($user_name);
194 $user_password = trim($user_password);
195
196 if ($user_name == '') return "/!\ Error: user name is empty!";
197 if ($user_password == '') return "/!\ Error: password is empty!";
198
199 $user_exists = tool_admin_users_name_exist($user_name);
200 if (!$user_exists)
201 {
202 $sql = "INSERT INTO ". NELDB_USER_TABLE;
203 $sql .= " (`user_name`,`user_password`,`user_group_id`,`user_created`,`user_active`)";
204 $sql .= " VALUES ";
205 $sql .= " ('". $user_name ."','". md5($user_password) ."','". $user_group ."','". time() ."','". $user_active ."')";
206 $db->sql_query($sql);
207 return "";
208 }
209
210 return "/!\ Error: user name already exists in the database!";
211 }
212
213 function tool_admin_users_name_exist($user_name)
214 {
215 global $db;
216
217 $exists = false;
218
219 $sql = "SELECT user_id, user_name FROM ". NELDB_USER_TABLE ." WHERE user_name='". $user_name ."'";
220 if ($result = $db->sql_query($sql))
221 {
222 if ($db->sql_numrows($result))
223 {
224 $exists = true;
225 }
226 }
227
228 return $exists;
229 }
230
231 function tool_admin_users_del($user_id)
232 {
233 global $db;
234
235 $sql = "DELETE FROM ". NELDB_USER_TABLE ." WHERE user_id=". $user_id;
236 $db->sql_query($sql);
237 }
238
239 function tool_admin_users_update($user_id, $user_name, $user_password, $user_group, $user_active)
240 {
241 global $db;
242
243 $user_name = trim($user_name);
244 $user_password = trim($user_password);
245
246 if ($user_name == "") return "/!\ Error: user name is empty!";
247 if (!ereg("^([[:alnum:]]+)$",$user_name)) return "/!\ Error: invalid user name, only alpha numerical characters allowed!";
248
249 $sql = "SELECT * FROM ". NELDB_USER_TABLE ." WHERE user_name='". $user_name ."' AND user_id<>". $user_id;
250 if ($result = $db->sql_query($sql))
251 {
252 if ($db->sql_numrows($result))
253 {
254 return "/!\ Error: user name already exists in database!";
255 }
256 }
257
258 $sql_ext = "";
259 if ($user_password != '') $sql_ext = ",user_password='". md5($user_password) ."'";
260
261 $sql = "UPDATE ". NELDB_USER_TABLE ." SET user_name='". $user_name ."',user_group_id='". $user_group ."',user_active='". $user_active ."'". $sql_ext ." WHERE user_id=". $user_id;
262 $db->sql_query($sql);
263
264 return "";
265 }
266
267 function tool_admin_groups_get_id($group_id)
268 {
269 global $db;
270
271 $data = null;
272
273 $sql = "SELECT * FROM ". NELDB_GROUP_TABLE ." WHERE group_id=". $group_id;
274 if ($result = $db->sql_query($sql))
275 {
276 if ($db->sql_numrows($result))
277 {
278 $data = $db->sql_fetchrow($result);
279 }
280 }
281
282 return $data;
283 }
284
285 function tool_admin_groups_add($group_name, $group_level, $group_default, $group_active)
286 {
287 global $db;
288
289 $group_name = trim($group_name);
290 if ($group_name == '') return "/!\ Error: group name is empty!";
291
292 $group_exists = tool_admin_groups_name_exist($group_name);
293 if (!$group_exists)
294 {
295 if ($group_default == 1)
296 {
297 $sql = "UPDATE ". NELDB_GROUP_TABLE ." SET group_default=0";
298 $db->sql_query($sql);
299 }
300
301 $sql = "INSERT INTO ". NELDB_GROUP_TABLE;
302 $sql .= " (`group_name`,`group_level`,`group_default`,`group_active`) ";
303 $sql .= " VALUES ";
304 $sql .= " ('". $group_name ."',". $group_level .",". $group_default .",". $group_active .")";
305 $db->sql_query($sql);
306
307 return "";
308 }
309
310 return "/!\ Error: group name already exists in the database!";
311 }
312
313 function tool_admin_groups_name_exist($group_name)
314 {
315 global $db;
316
317 $exists = false;
318
319 $sql = "SELECT group_id, group_name FROM ". NELDB_GROUP_TABLE ." WHERE group_name='". $group_name ."'";
320 if ($result = $db->sql_query($sql))
321 {
322 if ($db->sql_numrows($result))
323 {
324 $exists = true;
325 }
326 }
327
328 return $exists;
329 }
330
331
332 function tool_admin_groups_del($group_id)
333 {
334 global $db;
335
336 $sql = "DELETE FROM ". NELDB_GROUP_TABLE ." WHERE group_id=". $group_id;
337 $db->sql_query($sql);
338 }
339
340 function tool_admin_groups_update($group_id, $group_name, $group_level, $group_default, $group_active)
341 {
342 global $db;
343
344 $group_name = trim($group_name);
345
346 if ($group_name == "") return "/!\ Error: group name is empty!";
347 if (!ereg("^([[:alnum:]]+)$",$group_name)) return "/!\ Error: invalid group name, only alpha numerical characters allowed!";
348
349 $sql = "SELECT * FROM ". NELDB_GROUP_TABLE ." WHERE group_name='". $group_name ."' AND group_id<>". $group_id;
350 if ($result = $db->sql_query($sql))
351 {
352 if ($db->sql_numrows($result))
353 {
354 return "/!\ Error: group name already exists in database!";
355 }
356 }
357
358 if ($group_default == 1)
359 {
360 $sql = "UPDATE ". NELDB_GROUP_TABLE ." SET group_default=0";
361 $db->sql_query($sql);
362 }
363
364 $sql = "UPDATE ". NELDB_GROUP_TABLE ." SET group_name='". $group_name ."',group_level='". $group_level ."',group_default='". $group_default ."',group_active='". $group_active ."' WHERE group_id=". $group_id;
365 $db->sql_query($sql);
366
367 return "";
368 }
369
370 function tool_admin_groups_update_default_domain($group_id, $domain_id)
371 {
372 global $db;
373
374 $sql = "SELECT * FROM ". NELDB_GROUP_TABLE ." WHERE group_id=". $group_id;
375 if ($result = $db->sql_query($sql))
376 {
377 if ($db->sql_numrows($result))
378 {
379 $row = $db->sql_fetchrow($result);
380
381 if ($row['group_default_domain_id'] != $domain_id)
382 {
383 $sql = "UPDATE ". NELDB_GROUP_TABLE ." SET group_default_domain_id=". $domain_id .",group_default_shard_id=0 WHERE group_id=". $group_id;
384 $db->sql_query($sql);
385 }
386 }
387 else
388 {
389 return "/!\ Error: invalid group id!";
390 }
391 }
392
393 return "";
394 }
395
396 function tool_admin_groups_update_default_shard($group_id, $shard_id)
397 {
398 global $db;
399
400 $sql = "SELECT * FROM ". NELDB_GROUP_TABLE ." WHERE group_id=". $group_id;
401 if ($result = $db->sql_query($sql))
402 {
403 if ($db->sql_numrows($result))
404 {
405 $sql = "UPDATE ". NELDB_GROUP_TABLE ." SET group_default_shard_id=". $shard_id ." WHERE group_id=". $group_id;
406 $db->sql_query($sql);
407 }
408 else
409 {
410 return "/!\ Error: invalid group id!";
411 }
412 }
413
414 return "";
415 }
416
417 function tool_admin_groups_update_default_application($group_id, $application_id)
418 {
419 global $db;
420
421 $sql = "SELECT * FROM ". NELDB_GROUP_TABLE ." WHERE group_id=". $group_id;
422 if ($result = $db->sql_query($sql))
423 {
424 if ($db->sql_numrows($result))
425 {
426 $sql = "UPDATE ". NELDB_GROUP_TABLE ." SET group_default_application_id=". $application_id ." WHERE group_id=". $group_id;
427 $db->sql_query($sql);
428 }
429 else
430 {
431 return "/!\ Error: invalid group id!";
432 }
433 }
434
435 return "";
436 }
437
438
439 function tool_admin_applications_get_list()
440 {
441 global $db;
442
443 $data = null;
444
445 $sql = "SELECT * FROM ". NELDB_APPLICATION_TABLE ." ORDER BY application_order ASC, application_name ASC";
446 if ($result = $db->sql_query($sql))
447 {
448 if ($db->sql_numrows($result))
449 {
450 $data = $db->sql_fetchrowset($result);
451 }
452 }
453
454 return $data;
455 }
456
457 function tool_admin_applications_get_id($application_id)
458 {
459 global $db;
460
461 $data = null;
462
463 $sql = "SELECT * FROM ". NELDB_APPLICATION_TABLE ." WHERE application_id=". $application_id;
464 if ($result = $db->sql_query($sql))
465 {
466 if ($db->sql_numrows($result))
467 {
468 $data = $db->sql_fetchrow($result);
469 }
470 }
471
472 return $data;
473 }
474
475 function tool_admin_applications_add($application_name, $application_uri, $application_restriction, $application_icon, $application_order, $application_visible)
476 {
477 global $db;
478
479 $application_name = trim($application_name);
480 if ($application_name == '') return "/!\ Error: application name is empty!";
481
482 $application_exists = tool_admin_applications_name_exist($application_name);
483 if (!$application_exists)
484 {
485 $sql = "INSERT INTO ". NELDB_APPLICATION_TABLE;
486 $sql .= " (`application_name`,`application_uri`,`application_restriction`,`application_order`,`application_visible`,`application_icon`) ";
487 $sql .= " VALUES ";
488 $sql .= " ('". $application_name ."','". $application_uri ."','". $application_restriction ."','". $application_order ."','". $application_visible ."','". $application_icon ."')";
489 $db->sql_query($sql);
490
491 return "";
492 }
493
494 return "/!\ Error: application name already exists in the database!";
495 }
496
497 function tool_admin_applications_name_exist($application_name)
498 {
499 global $db;
500
501 $exists = false;
502
503 $sql = "SELECT application_id, application_name FROM ". NELDB_APPLICATION_TABLE ." WHERE application_name='". $application_name ."'";
504 if ($result = $db->sql_query($sql))
505 {
506 if ($db->sql_numrows($result))
507 {
508 $exists = true;
509 }
510 }
511
512 return $exists;
513 }
514
515 function tool_admin_applications_del($application_id)
516 {
517 global $db;
518
519 $sql = "DELETE FROM ". NELDB_USER_APPLICATION_TABLE ." WHERE user_application_application_id=". $application_id;
520 $db->sql_query($sql);
521
522 $sql = "DELETE FROM ". NELDB_GROUP_APPLICATION_TABLE ." WHERE group_application_application_id=". $application_id;
523 $db->sql_query($sql);
524
525 $sql = "DELETE FROM ". NELDB_APPLICATION_TABLE ." WHERE application_id=". $application_id;
526 $db->sql_query($sql);
527 }
528
529 function tool_admin_applications_update($application_id, $application_name, $application_uri, $application_restriction, $application_icon, $application_order, $application_visible)
530 {
531 global $db;
532
533 $application_name = trim($application_name);
534 if ($application_name == "") return "/!\ Error: application name is empty!";
535
536 $sql = "SELECT * FROM ". NELDB_APPLICATION_TABLE ." WHERE application_name='". $application_name ."' AND application_id<>". $application_id;
537 if ($result = $db->sql_query($sql))
538 {
539 if ($db->sql_numrows($result))
540 {
541 return "/!\ Error: application name already exists in database!";
542 }
543 }
544
545 $sql = "UPDATE ". NELDB_APPLICATION_TABLE ." SET application_name='". $application_name ."',application_uri='". $application_uri ."',application_restriction='". $application_restriction ."',application_icon='". $application_icon ."',application_order='". $application_order ."',application_visible='". $application_visible ."' WHERE application_id=". $application_id;
546 $db->sql_query($sql);
547
548 return "";
549 }
550
551 function tool_admin_domains_get_list()
552 {
553 global $db;
554
555 $data = null;
556
557 $sql = "SELECT * FROM ". NELDB_DOMAIN_TABLE ." ORDER BY domain_name ASC";
558 if ($result = $db->sql_query($sql))
559 {
560 if ($db->sql_numrows($result))
561 {
562 $data = $db->sql_fetchrowset($result);
563 }
564 }
565
566 return $data;
567 }
568
569 function tool_admin_domains_add($domain_name, $domain_application, $domain_as_host, $domain_as_port, $domain_rrd_path, $domain_las_admin_path, $domain_las_local_path, $domain_sql_string, $domain_cs_sql_string, $domain_hd_check, $domain_mfs_web)
570 {
571 global $db;
572
573 $domain_name = trim($domain_name);
574 if ($domain_name == '') return "/!\ Error: domain name is empty!";
575
576 $domain_exists = tool_admin_domains_name_exist($domain_name);
577 if (!$domain_exists)
578 {
579 $sql = "INSERT INTO ". NELDB_DOMAIN_TABLE;
580 $sql .= " (`domain_name`,`domain_application`,`domain_as_host`,`domain_as_port`,`domain_rrd_path`,`domain_las_admin_path`,`domain_las_local_path`,`domain_sql_string`,`domain_hd_check`,`domain_mfs_web`,`domain_cs_sql_string`) ";
581 $sql .= " VALUES ";
582 $sql .= " ('". $domain_name ."','". $domain_application ."','". $domain_as_host ."','". $domain_as_port ."','". $domain_rrd_path ."','". $domain_las_admin_path ."','". $domain_las_local_path ."','". $domain_sql_string ."',". $domain_hd_check .",'". $domain_mfs_web ."','". $domain_cs_sql_string ."') ";
583 $db->sql_query($sql);
584
585 return "";
586 }
587
588 return "/!\ Error: domain name already exists in the database!";
589 }
590
591 function tool_admin_domains_name_exist($domain_name)
592 {
593 global $db;
594
595 $exists = false;
596
597 $sql = "SELECT domain_id, domain_name FROM ". NELDB_DOMAIN_TABLE ." WHERE domain_name='". $domain_name ."'";
598 if ($result = $db->sql_query($sql))
599 {
600 if ($db->sql_numrows($result))
601 {
602 $exists = true;
603 }
604 }
605
606 return $exists;
607 }
608
609 function tool_admin_domains_get_id($domain_id)
610 {
611 global $db;
612
613 $data = null;
614
615 $sql = "SELECT * FROM ". NELDB_DOMAIN_TABLE ." WHERE domain_id=". $domain_id;
616 if ($result = $db->sql_query($sql))
617 {
618 if ($db->sql_numrows($result))
619 {
620 $data = $db->sql_fetchrow($result);
621 }
622 }
623
624 return $data;
625 }
626
627 function tool_admin_domains_del($domain_id)
628 {
629 global $db;
630
631 $sql = "DELETE FROM ". NELDB_USER_SHARD_TABLE ." WHERE user_shard_domain_id=". $domain_id;
632 $db->sql_query($sql);
633
634 $sql = "DELETE FROM ". NELDB_USER_DOMAIN_TABLE ." WHERE user_domain_domain_id=". $domain_id;
635 $db->sql_query($sql);
636
637 $sql = "DELETE FROM ". NELDB_GROUP_SHARD_TABLE ." WHERE group_shard_domain_id=". $domain_id;
638 $db->sql_query($sql);
639
640 $sql = "DELETE FROM ". NELDB_GROUP_DOMAIN_TABLE ." WHERE group_domain_domain_id=". $domain_id;
641 $db->sql_query($sql);
642
643 $sql = "DELETE FROM ". NELDB_SHARD_TABLE ." WHERE shard_domain_id=". $domain_id;
644 $db->sql_query($sql);
645
646 $sql = "DELETE FROM ". NELDB_DOMAIN_TABLE ." WHERE domain_id=". $domain_id;
647 $db->sql_query($sql);
648
649 }
650
651 function tool_admin_domains_update($domain_id, $domain_name, $domain_application, $domain_as_host, $domain_as_port, $domain_rrd_path, $domain_las_admin_path, $domain_las_local_path, $domain_sql_string, $domain_cs_sql_string, $domain_hd_check, $domain_mfs_web)
652 {
653 global $db;
654
655 $domain_name = trim($domain_name);
656
657 if ($domain_name == "") return "/!\ Error: domain name is empty!";
658
659 $sql = "SELECT * FROM ". NELDB_DOMAIN_TABLE ." WHERE domain_name='". $domain_name ."' AND domain_id<>". $domain_id;
660 if ($result = $db->sql_query($sql))
661 {
662 if ($db->sql_numrows($result))
663 {
664 return "/!\ Error: domain name already exists in database!";
665 }
666 }
667
668 $sql = "UPDATE ". NELDB_DOMAIN_TABLE ." SET domain_name='". $domain_name."',domain_application='". $domain_application ."',domain_as_host='". $domain_as_host ."',domain_as_port='". $domain_as_port ."',domain_rrd_path='". $domain_rrd_path ."',domain_las_admin_path='". $domain_las_admin_path ."',domain_las_local_path='". $domain_las_local_path ."',domain_sql_string='". $domain_sql_string ."',domain_hd_check=". $domain_hd_check .",domain_mfs_web='". $domain_mfs_web ."',domain_cs_sql_string='". $domain_cs_sql_string ."' WHERE domain_id=". $domain_id;
669 $db->sql_query($sql);
670
671 return "";
672 }
673
674 function tool_admin_shards_get_list()
675 {
676 global $db;
677
678 $data = null;
679
680 $sql = "SELECT * FROM ". NELDB_SHARD_TABLE ." LEFT JOIN ". NELDB_DOMAIN_TABLE ." ON (shard_domain_id=domain_id) ORDER BY domain_name ASC, shard_name ASC";
681 if ($result = $db->sql_query($sql))
682 {
683 if ($db->sql_numrows($result))
684 {
685 $data = $db->sql_fetchrowset($result);
686 }
687 }
688
689 return $data;
690 }
691
692 function tool_admin_shards_add($shard_name, $shard_as_id, $shard_domain_id, $shard_language)
693 {
694 global $db;
695
696 $shard_name = trim($shard_name);
697 if ($shard_name == '') return "/!\ Error: shard name is empty!";
698
699 $shard_as_id = trim($shard_as_id);
700 //if (!is_numeric($shard_as_id)) return "/!\ Error: shard AS Id is invalid!";
701
702 //$shard_exists = tool_admin_shards_name_exist($shard_as_id);
703 //if (!$shard_exists)
704 //{
705 $sql = "INSERT INTO ". NELDB_SHARD_TABLE;
706 $sql .= " (`shard_name`,`shard_as_id`,`shard_domain_id`,`shard_lang`) ";
707 $sql .= " VALUES ";
708 $sql .= " ('". $shard_name ."','". $shard_as_id ."','". $shard_domain_id ."','". $shard_language ."') ";
709 $db->sql_query($sql);
710 return "";
711 //}
712 //
713 //return "/!\ Error: shard AS Id already exists in the database!";
714 }
715
716 function tool_admin_shards_name_exist($shard_as_id, $except_id=false)
717 {
718 global $db;
719
720 if ($shard_as_id == '*' || $shard_as_id == '?') return false;
721
722 $exists = false;
723
724 $sql = "SELECT * FROM ". NELDB_SHARD_TABLE ." WHERE shard_as_id='". $shard_as_id ."'";
725 if ($except_id !== false) $sql .= " AND shard_id<>". $except_id;
726
727 if ($result = $db->sql_query($sql))
728 {
729 if ($db->sql_numrows($result))
730 {
731 $exists = true;
732 }
733 }
734
735 return $exists;
736 }
737
738 function tool_admin_shards_get_id($shard_id)
739 {
740 global $db;
741
742 $data = null;
743
744 $sql = "SELECT * FROM ". NELDB_SHARD_TABLE ." WHERE shard_id=". $shard_id;
745 if ($result = $db->sql_query($sql))
746 {
747 if ($db->sql_numrows($result))
748 {
749 $data = $db->sql_fetchrow($result);
750 }
751 }
752
753 return $data;
754 }
755
756 function tool_admin_shards_del($shard_id)
757 {
758 global $db;
759
760 $sql = "DELETE FROM ". NELDB_USER_SHARD_TABLE ." WHERE user_shard_shard_id=". $shard_id;
761 $db->sql_query($sql);
762
763 $sql = "DELETE FROM ". NELDB_GROUP_SHARD_TABLE ." WHERE group_shard_shard_id=". $shard_id;
764 $db->sql_query($sql);
765
766 $sql = "DELETE FROM ". NELDB_SHARD_TABLE ." WHERE shard_id=". $shard_id;
767 $db->sql_query($sql);
768 }
769
770 function tool_admin_shards_update($shard_id, $shard_name, $shard_as_id, $shard_domain_id, $shard_language)
771 {
772 global $db;
773
774 $shard_name = trim($shard_name);
775 if ($shard_name == '') return "/!\ Error: shard name is empty!";
776
777 $shard_as_id = trim($shard_as_id);
778 //if (!is_numeric($shard_as_id)) return "/!\ Error: shard AS Id is invalid!";
779
780 //$shard_exists = tool_admin_shards_name_exist($shard_as_id, $shard_id);
781 //if (!$shard_exists)
782 //{
783 $sql = "UPDATE ". NELDB_SHARD_TABLE ." SET shard_name='". $shard_name ."',shard_as_id='". $shard_as_id ."',shard_domain_id='". $shard_domain_id ."',shard_lang='". $shard_language ."' WHERE shard_id=". $shard_id;
784 $db->sql_query($sql);
785
786 return "";
787 //}
788 //
789 //return "/!\ Error: shard AS Id already exists in the database!";
790
791 }
792
793
794 function tool_admin_users_domains_update($user_id, $group_id, $domain_ids)
795 {
796 global $db;
797
798 $user_domains = tool_admin_users_domains_get_list($user_id, true);
799 $group_domains = tool_admin_groups_domains_get_list($group_id, true);
800
801 $sql = "DELETE FROM ". NELDB_USER_DOMAIN_TABLE ." WHERE user_domain_user_id=". $user_id;
802 $db->sql_query($sql);
803
804 if (is_array($domain_ids) and sizeof($domain_ids))
805 {
806 reset($domain_ids);
807 foreach($domain_ids as $domain_id)
808 {
809 if (is_numeric($domain_id) && $domain_id > 0)
810 {
811 $sql = "INSERT INTO ". NELDB_USER_DOMAIN_TABLE ." (`user_domain_user_id`,`user_domain_domain_id`) VALUES ('". $user_id ."','". $domain_id ."')";
812 $db->sql_query($sql);
813 }
814 }
815 }
816
817 // now we remove all shards except those that belong to the user AND group
818
819 $sql = "DELETE FROM ". NELDB_USER_SHARD_TABLE ." WHERE user_shard_user_id=". $user_id;
820 if (is_array($domain_ids) && sizeof($domain_ids)) $sql .= " AND user_shard_domain_id NOT IN (". implode(',',array_values($domain_ids)) .")";
821 if (is_array($group_domains) && sizeof($group_domains)) $sql .= " AND user_shard_domain_id NOT IN (". implode(',',array_values($group_domains)) .")";
822 $db->sql_query($sql);
823 }
824
825 function tool_admin_users_domains_get_list($user_id, $compact = false)
826 {
827 global $db;
828
829 $data = array();
830 $data1 = array();
831
832 $sql = "SELECT * FROM ". NELDB_USER_DOMAIN_TABLE ." LEFT JOIN ". NELDB_DOMAIN_TABLE ." ON (user_domain_domain_id=domain_id) WHERE user_domain_user_id=". $user_id ." ORDER BY domain_name ASC";
833 if ($result = $db->sql_query($sql))
834 {
835 if ($db->sql_numrows($result))
836 {
837 $data1 = $db->sql_fetchrowset($result);
838 }
839 }
840
841 if ($compact)
842 {
843 reset($data1);
844 foreach($data1 as $data_tmp)
845 {
846 $data[] = $data_tmp['user_domain_domain_id'];
847 }
848 }
849 else
850 {
851 $data = $data1;
852 }
853
854
855
856 return $data;
857 }
858
859 function tool_admin_groups_domains_get_list($group_id, $compact = false)
860 {
861 global $db;
862
863 $data = array();
864 $data1 = array();
865
866 $sql = "SELECT * FROM ". NELDB_GROUP_DOMAIN_TABLE ." LEFT JOIN ". NELDB_DOMAIN_TABLE ." ON (group_domain_domain_id=domain_id) WHERE group_domain_group_id=". $group_id ." ORDER BY domain_name ASC";
867 if ($result = $db->sql_query($sql))
868 {
869 if ($db->sql_numrows($result))
870 {
871 $data1 = $db->sql_fetchrowset($result);
872 }
873 }
874
875 if ($compact)
876 {
877 reset($data1);
878 foreach($data1 as $data_tmp)
879 {
880 $data[] = $data_tmp['group_domain_domain_id'];
881 }
882 }
883 else
884 {
885 $data = $data1;
886 }
887
888 //nt_common_add_debug($data);
889
890 return $data;
891 }
892
893 function tool_admin_users_domains_merge($domain_list, $user_list, $group_list)
894 {
895 $data = array();
896
897 if (is_array($domain_list) && sizeof($domain_list))
898 {
899 reset($domain_list);
900 foreach($domain_list as $domain)
901 {
902 if (in_array($domain['domain_id'], $group_list))
903 {
904 $domain['domain_disabled'] = true;
905 $domain['domain_visible'] = true;
906 }
907 elseif (in_array($domain['domain_id'], $user_list))
908 {
909 $domain['domain_selected'] = true;
910 $domain['domain_visible'] = true;
911 }
912
913 $data[] = $domain;
914 }
915 }
916
917 return $data;
918 }
919
920 function tool_admin_users_shards_get_list($user_id, $compact = false)
921 {
922 global $db;
923
924 $data = array();
925 $data1 = array();
926
927 $sql = "SELECT * FROM ". NELDB_USER_SHARD_TABLE ." LEFT JOIN ". NELDB_SHARD_TABLE ." ON (user_shard_shard_id=shard_id) WHERE user_shard_user_id=". $user_id ." ORDER BY shard_name ASC";
928 if ($result = $db->sql_query($sql))
929 {
930 if ($db->sql_numrows($result))
931 {
932 $data1 = $db->sql_fetchrowset($result);
933 }
934 }
935
936 if ($compact)
937 {
938 reset($data1);
939 foreach($data1 as $data_tmp)
940 {
941 $data[] = $data_tmp['user_shard_shard_id'];
942 }
943 }
944 else
945 {
946 $data = $data1;
947 }
948
949
950
951 return $data;
952 }
953
954 function tool_admin_groups_shards_get_list($group_id, $compact = false)
955 {
956 global $db;
957
958 $data = array();
959 $data1 = array();
960
961 $sql = "SELECT * FROM ". NELDB_GROUP_SHARD_TABLE ." LEFT JOIN ". NELDB_SHARD_TABLE ." ON (group_shard_shard_id=shard_id) WHERE group_shard_group_id=". $group_id ." ORDER BY shard_name ASC";
962 if ($result = $db->sql_query($sql))
963 {
964 if ($db->sql_numrows($result))
965 {
966 $data1 = $db->sql_fetchrowset($result);
967 }
968 }
969
970 if ($compact)
971 {
972 reset($data1);
973 foreach($data1 as $data_tmp)
974 {
975 $data[] = $data_tmp['group_shard_shard_id'];
976 }
977 }
978 else
979 {
980 $data = $data1;
981 }
982
983 return $data;
984 }
985
986 function tool_admin_users_shards_merge($domain_list, $shard_list, $user_list, $group_list)
987 {
988 $data1 = array();
989
990 if (is_array($shard_list) && sizeof($shard_list))
991 {
992 reset($shard_list);
993 foreach($shard_list as $shard)
994 {
995 if (in_array($shard['shard_id'], $group_list))
996 {
997 $shard['shard_disabled'] = true;
998 }
999 elseif (in_array($shard['shard_id'], $user_list))
1000 {
1001 $shard['shard_selected'] = true;
1002 }
1003
1004 $data1[] = $shard;
1005 }
1006
1007 $shard_list = $data1;
1008 }
1009
1010 $data2 = array();
1011
1012 // now we sort the shards by their domain
1013 if (is_array($domain_list) && sizeof($domain_list))
1014 {
1015 reset($domain_list);
1016 foreach($domain_list as $domain)
1017 {
1018 // looks for the shards that belong to this domain
1019 reset($shard_list);
1020 foreach($shard_list as $shard)
1021 {
1022 if ($domain['domain_id'] == $shard['shard_domain_id'])
1023 {
1024 $domain['shard_list'][] = $shard;
1025 }
1026 }
1027
1028 $data2[] = $domain;
1029 }
1030
1031 $domain_list = $data2;
1032 }
1033
1034 return $domain_list;
1035 }
1036
1037 function tool_admin_users_shards_update($user_id, $group_id, $shard_ids)
1038 {
1039 global $db;
1040
1041 $sql = "DELETE FROM ". NELDB_USER_SHARD_TABLE ." WHERE user_shard_user_id=". $user_id;
1042 $db->sql_query($sql);
1043
1044 if (is_array($shard_ids) && sizeof($shard_ids))
1045 {
1046 reset($shard_ids);
1047 foreach($shard_ids as $shard_tmp)
1048 {
1049 $tmp = explode('_', $shard_tmp);
1050 $domain_id = $tmp[0];
1051 $shard_id = $tmp[1];
1052
1053 if (is_numeric($domain_id) && is_numeric($shard_id) && $domain_id > 0 && $shard_id > 0)
1054 {
1055 $sql = "INSERT INTO ". NELDB_USER_SHARD_TABLE ." (`user_shard_user_id`,`user_shard_shard_id`,`user_shard_domain_id`) VALUES ('". $user_id ."','". $shard_id ."','". $domain_id ."')";
1056 $db->sql_query($sql);
1057 }
1058 }
1059 }
1060 }
1061
1062 function tool_admin_groups_domains_update($group_id, $domain_ids)
1063 {
1064 global $db;
1065
1066 $sql = "DELETE FROM ". NELDB_GROUP_DOMAIN_TABLE ." WHERE group_domain_group_id=". $group_id;
1067 $db->sql_query($sql);
1068
1069 if (is_array($domain_ids) and sizeof($domain_ids))
1070 {
1071 reset($domain_ids);
1072 foreach($domain_ids as $domain_id)
1073 {
1074 if (is_numeric($domain_id) && $domain_id > 0)
1075 {
1076 $sql = "INSERT INTO ". NELDB_GROUP_DOMAIN_TABLE ." (`group_domain_group_id`,`group_domain_domain_id`) VALUES ('". $group_id ."','". $domain_id ."')";
1077 $db->sql_query($sql);
1078 }
1079 }
1080 }
1081
1082 $sql = "DELETE FROM ". NELDB_GROUP_SHARD_TABLE ." WHERE group_shard_group_id=". $group_id;
1083 if (is_array($domain_ids) && sizeof($domain_ids)) $sql .= " AND group_shard_domain_id NOT IN (". implode(',',array_values($domain_ids)) .")";
1084 $db->sql_query($sql);
1085
1086 // we need to check some stuff for each user in this group
1087
1088 // first we get the list of users that belong to his group
1089 $sql = "SELECT * FROM ". NELDB_USER_TABLE ." WHERE user_group_id=". $group_id;
1090 if ($result = $db->sql_query($sql))
1091 {
1092 if ($db->sql_numrows($result))
1093 {
1094 while ($row = $db->sql_fetchrow($result))
1095 {
1096 // get a user
1097 $user_id = $row['user_id'];
1098
1099 // get the domains specific to the user
1100 $user_domain_list = tool_admin_users_domains_get_list($user_id, true);
1101
1102 // then we delete the shard that don't belong to the group nor user
1103 $sql = "DELETE FROM ". NELDB_USER_SHARD_TABLE ." WHERE user_shard_user_id=". $user_id;
1104 if (is_array($domain_ids) && sizeof($domain_ids)) $sql .= " AND user_shard_domain_id NOT IN (". implode(',', array_values($domain_ids)) .")";
1105 if (is_array($user_domain_list) && sizeof($user_domain_list)) $sql .= " AND user_shard_domain_id NOT IN (". implode(',', array_values($user_domain_list)) .")";
1106 $db->sql_query($sql);
1107
1108 // make sure users don't have a domain that already belongs to a group
1109 $sql = "DELETE FROM ". NELDB_USER_DOMAIN_TABLE ." WHERE user_domain_user_id=". $user_id;
1110 if (is_array($domain_ids) && sizeof($domain_ids)) $sql .= " AND user_domain_domain_id IN (". implode(',', array_values($domain_ids)) .")";
1111 $db->sql_query($sql);
1112 }
1113 }
1114 }
1115
1116 }
1117
1118 function tool_admin_groups_domains_merge($domain_list, $group_list)
1119 {
1120 $data = array();
1121
1122 if (is_array($domain_list) && sizeof($domain_list))
1123 {
1124 reset($domain_list);
1125 foreach($domain_list as $domain)
1126 {
1127 if (in_array($domain['domain_id'], $group_list))
1128 {
1129 $domain['domain_visible'] = true;
1130 $domain['domain_selected'] = true;
1131 }
1132
1133 $data[] = $domain;
1134 }
1135 }
1136
1137 return $data;
1138 }
1139
1140 function tool_admin_groups_shards_merge($domain_list, $shard_list, $group_list)
1141 {
1142 $data1 = array();
1143
1144 if (is_array($shard_list) && sizeof($shard_list))
1145 {
1146 reset($shard_list);
1147 foreach($shard_list as $shard)
1148 {
1149 if (in_array($shard['shard_id'], $group_list))
1150 {
1151 $shard['shard_selected'] = true;
1152 }
1153
1154 $data1[] = $shard;
1155 }
1156
1157 $shard_list = $data1;
1158 }
1159
1160 $data2 = array();
1161
1162 // now we sort the shards by their domain
1163 if (is_array($domain_list) && sizeof($domain_list) && is_array($shard_list) && sizeof($shard_list))
1164 {
1165 reset($domain_list);
1166 foreach($domain_list as $domain)
1167 {
1168 // looks for the shards that belong to this domain
1169 reset($shard_list);
1170 foreach($shard_list as $shard)
1171 {
1172 if ($domain['domain_id'] == $shard['shard_domain_id'])
1173 {
1174 $domain['shard_list'][] = $shard;
1175 }
1176 }
1177
1178 $data2[] = $domain;
1179 }
1180
1181 $domain_list = $data2;
1182 }
1183
1184 return $domain_list;
1185 }
1186
1187 function tool_admin_groups_shards_update($group_id, $shard_ids)
1188 {
1189 global $db;
1190
1191 $sql = "DELETE FROM ". NELDB_GROUP_SHARD_TABLE ." WHERE group_shard_group_id=". $group_id;
1192 $db->sql_query($sql);
1193
1194 if (is_array($shard_ids) && sizeof($shard_ids))
1195 {
1196 $user_shard_ids = array();
1197
1198 reset($shard_ids);
1199 foreach($shard_ids as $shard_tmp)
1200 {
1201 $tmp = explode('_', $shard_tmp);
1202 $domain_id = $tmp[0];
1203 $shard_id = $tmp[1];
1204
1205 $group_shard_ids[] = $shard_id;
1206
1207 if (is_numeric($domain_id) && is_numeric($shard_id) && $domain_id > 0 && $shard_id > 0)
1208 {
1209 $sql = "INSERT INTO ". NELDB_GROUP_SHARD_TABLE ." (`group_shard_group_id`,`group_shard_shard_id`,`group_shard_domain_id`) VALUES ('". $group_id ."','". $shard_id ."','". $domain_id ."')";
1210 $db->sql_query($sql);
1211 }
1212 }
1213
1214 // we need to check some stuff for each user in this group
1215
1216 // first we get the list of users that belong to his group
1217 $sql = "SELECT * FROM ". NELDB_USER_TABLE ." WHERE user_group_id=". $group_id;
1218 if ($result = $db->sql_query($sql))
1219 {
1220 if ($db->sql_numrows($result))
1221 {
1222 while ($row = $db->sql_fetchrow($result))
1223 {
1224 // get a user
1225 $user_ids[] = $row['user_id'];
1226 }
1227
1228 $sql = "DELETE FROM ". NELDB_USER_SHARD_TABLE ." WHERE user_shard_user_id IN (". implode(',',array_values($user_ids)) .") AND user_shard_shard_id IN (". implode(',', array_values($group_shard_ids)) .")";
1229 $db->sql_query($sql);
1230 }
1231 }
1232
1233 }
1234 }
1235
1236 function tool_admin_groups_applications_update($group_id, $application_ids)
1237 {
1238 global $db;
1239
1240 $sql = "DELETE FROM ". NELDB_GROUP_APPLICATION_TABLE ." WHERE group_application_group_id=". $group_id;
1241 $db->sql_query($sql);
1242
1243 if (is_array($application_ids) && sizeof($application_ids))
1244 {
1245 reset($application_ids);
1246 foreach($application_ids as $application_id)
1247 {
1248 $sql = "INSERT INTO ". NELDB_GROUP_APPLICATION_TABLE ." (`group_application_group_id`,`group_application_application_id`) VALUES ('". $group_id ."','". $application_id ."')";
1249 $db->sql_query($sql);
1250 }
1251
1252 // we need to make sure no user in this group has this application
1253 $sql = "SELECT * FROM ". NELDB_USER_TABLE ." WHERE user_group_id=". $group_id;
1254 if ($result = $db->sql_query($sql))
1255 {
1256 if ($db->sql_numrows($result))
1257 {
1258 while ($row = $db->sql_fetchrow($result))
1259 {
1260 // get a user
1261 $user_ids[] = $row['user_id'];
1262 }
1263
1264 $sql = "DELETE FROM ". NELDB_USER_APPLICATION_TABLE ." WHERE user_application_user_id IN (". implode(',',array_values($user_ids)) .") AND user_application_application_id IN (". implode(',', array_values($application_ids)) .")";
1265 $db->sql_query($sql);
1266 }
1267 }
1268
1269 }
1270 }
1271
1272
1273 function tool_admin_groups_applications_get_list($group_id, $compact = false)
1274 {
1275 global $db;
1276
1277 $data = array();
1278 $data1 = array();
1279
1280 $sql = "SELECT * FROM ". NELDB_GROUP_APPLICATION_TABLE ." LEFT JOIN ". NELDB_APPLICATION_TABLE ." ON (group_application_application_id=application_id) WHERE group_application_group_id=". $group_id;
1281 if ($result = $db->sql_query($sql))
1282 {
1283 if ($db->sql_numrows($result))
1284 {
1285 $data1 = $db->sql_fetchrowset($result);
1286 }
1287 }
1288
1289 if ($compact)
1290 {
1291 reset($data1);
1292 foreach($data1 as $data_tmp)
1293 {
1294 $data[] = $data_tmp['group_application_application_id'];
1295 }
1296 }
1297 else
1298 {
1299 $data = $data1;
1300 }
1301
1302 return $data;
1303 }
1304
1305 function tool_admin_groups_applications_merge($appl_list, $group_list)
1306 {
1307 $data1 = array();
1308
1309 if (is_array($appl_list) && sizeof($appl_list))
1310 {
1311 reset($appl_list);
1312 foreach($appl_list as $appl)
1313 {
1314 if (in_array($appl['application_id'], $group_list))
1315 {
1316 $appl['application_selected'] = true;
1317 }
1318
1319 $data1[] = $appl;
1320 }
1321
1322 $appl_list = $data1;
1323 }
1324
1325 return $appl_list;
1326 }
1327
1328 function tool_admin_users_applications_get_list($user_id, $compact = false)
1329 {
1330 global $db;
1331
1332 $data = array();
1333 $data1 = array();
1334
1335 $sql = "SELECT * FROM ". NELDB_USER_APPLICATION_TABLE ." LEFT JOIN ". NELDB_APPLICATION_TABLE ." ON (user_application_application_id=application_id) WHERE user_application_user_id=". $user_id;
1336 if ($result = $db->sql_query($sql))
1337 {
1338 if ($db->sql_numrows($result))
1339 {
1340 $data1 = $db->sql_fetchrowset($result);
1341 }
1342 }
1343
1344 if ($compact)
1345 {
1346 reset($data1);
1347 foreach($data1 as $data_tmp)
1348 {
1349 $data[] = $data_tmp['user_application_application_id'];
1350 }
1351 }
1352 else
1353 {
1354 $data = $data1;
1355 }
1356
1357 return $data;
1358 }
1359
1360 function tool_admin_users_applications_merge($appl_list, $user_list, $group_list)
1361 {
1362 $data1 = array();
1363
1364 if (is_array($appl_list) && sizeof($appl_list))
1365 {
1366 reset($appl_list);
1367 foreach($appl_list as $appl)
1368 {
1369 if (in_array($appl['application_id'], $group_list))
1370 {
1371 $appl['application_disabled'] = true;
1372 }
1373 elseif (in_array($appl['application_id'], $user_list))
1374 {
1375 $appl['application_selected'] = true;
1376 }
1377
1378 $data1[] = $appl;
1379 }
1380
1381 $appl_list = $data1;
1382 }
1383
1384 return $appl_list;
1385 }
1386
1387 function tool_admin_users_applications_update($user_id, $application_ids)
1388 {
1389 global $db;
1390
1391 $sql = "DELETE FROM ". NELDB_USER_APPLICATION_TABLE ." WHERE user_application_user_id=". $user_id;
1392 $db->sql_query($sql);
1393
1394 if (is_array($application_ids) && sizeof($application_ids))
1395 {
1396 reset($application_ids);
1397 foreach($application_ids as $application_id)
1398 {
1399 if (is_numeric($application_id) && $application_id > 0)
1400 {
1401 $sql = "INSERT INTO ". NELDB_USER_APPLICATION_TABLE ." (`user_application_user_id`,`user_application_application_id`) VALUES ('". $user_id ."','". $application_id ."')";
1402 $db->sql_query($sql);
1403 }
1404 }
1405 }
1406 }
1407
1408 function tool_admin_applications_build_menu_list($user_access)
1409 {
1410 $menu = array();
1411
1412 // return $user_access['applications'];
1413
1414 if (is_array($user_access['applications']) && sizeof($user_access['applications']))
1415 {
1416 reset($user_access['applications']);
1417 foreach($user_access['applications'] as $appl_data)
1418 {
1419 if ($appl_data['application_visible'] == 1)
1420 {
1421 $user_check = tool_admin_applications_build_menu_check($appl_data['application_id'], $user_access['user_applications'], 'user_application_application_id');
1422 $group_check = tool_admin_applications_build_menu_check($appl_data['application_id'], $user_access['group_applications'], 'group_application_application_id');
1423
1424 if ($appl_data['application_restriction'] == '')
1425 {
1426 $menu[] = $appl_data;
1427 }
1428 elseif ($user_check || $group_check)
1429 {
1430 $menu[] = $appl_data;
1431 }
1432 }
1433 }
1434 }
1435
1436 return $menu;
1437 }
1438
1439 function tool_admin_applications_get_default($data, $application_id)
1440 {
1441 if (is_array($data) && sizeof($data))
1442 {
1443 reset($data);
1444 foreach($data as $dt)
1445 {
1446 if ($dt['application_id'] == $application_id)
1447 {
1448 return $dt;
1449 }
1450 }
1451 }
1452 return false;
1453 }
1454
1455 function tool_admin_applications_build_menu_check($appl_id, $data, $data_name)
1456 {
1457 if (is_array($data) && sizeof($data))
1458 {
1459 reset($data);
1460 foreach($data as $dt)
1461 {
1462 if ($dt[$data_name] == $appl_id)
1463 {
1464 return true;
1465 }
1466 }
1467 }
1468
1469 return false;
1470 }
1471
1472 function tool_admin_applications_check($appl)
1473 {
1474 global $nel_user;
1475
1476 $ua = $nel_user['access']['user_applications'];
1477 $ga = $nel_user['access']['group_applications'];
1478
1479 if (is_array($ua) && sizeof($ua))
1480 {
1481 reset($ua);
1482 foreach($ua as $a)
1483 {
1484 if ($a['application_restriction'] == $appl)
1485 {
1486 return true;
1487 }
1488 }
1489 }
1490
1491 if (is_array($ga) && sizeof($ga))
1492 {
1493 reset($ga);
1494 foreach($ga as $a)
1495 {
1496 if ($a['application_restriction'] == $appl)
1497 {
1498 return true;
1499 }
1500 }
1501 }
1502
1503 return false;
1504 }
1505
1506 function tool_admin_menu_get_list($ie)
1507 {
1508 global $tool_admin_menu;
1509 global $nel_user;
1510
1511 $new_menu = array();
1512
1513 reset($tool_admin_menu);
1514 foreach($tool_admin_menu as $menu_item)
1515 {
1516 if (($menu_item['access'] == '') || tool_admin_applications_check($menu_item['access']))
1517 {
1518 if ($ie === false)
1519 {
1520 $new_menu[] = $menu_item;
1521 }
1522 }
1523 }
1524
1525 return $new_menu;
1526 }
1527
1528 function tool_admin_users_groups_domains_merge()
1529 {
1530 global $nel_user;
1531
1532 $user_domains = array();
1533
1534 $ud = $nel_user['access']['user_domains'];
1535 $gd = $nel_user['access']['group_domains'];
1536
1537 $dd = tool_admin_domains_get_list();
1538
1539 if (is_array($dd) && sizeof($dd))
1540 {
1541 reset($dd);
1542 foreach($dd as $domain_item)
1543 {
1544 if (is_array($ud))
1545 {
1546 reset($ud);
1547 foreach($ud as $udomain)
1548 {
1549 if ($domain_item['domain_id'] == $udomain['domain_id'])
1550 {
1551 $user_domains[] = $domain_item;
1552 }
1553 }
1554 }
1555
1556 if (is_array($gd))
1557 {
1558 reset($gd);
1559 foreach($gd as $gdomain)
1560 {
1561 if ($domain_item['domain_id'] == $gdomain['domain_id'])
1562 {
1563 $user_domains[] = $domain_item;
1564 }
1565 }
1566 }
1567 }
1568 }
1569
1570 return $user_domains;
1571 }
1572
1573 function tool_admin_users_groups_shards_merge()
1574 {
1575 global $nel_user;
1576
1577 $user_shards = array();
1578
1579 $us = $nel_user['access']['user_shards'];
1580 $gs = $nel_user['access']['group_shards'];
1581
1582 $ss = tool_admin_shards_get_list();
1583
1584 if (is_array($ss) && sizeof($ss))
1585 {
1586 reset($ss);
1587 foreach($ss as $shard_item)
1588 {
1589 if (is_array($us))
1590 {
1591 reset($us);
1592 foreach($us as $ushard)
1593 {
1594 if ($shard_item['shard_id'] == $ushard['shard_id'])
1595 {
1596 $user_shards[] = $shard_item;
1597 }
1598 }
1599 }
1600
1601 if (is_array($gs))
1602 {
1603 reset($gs);
1604 foreach($gs as $gshard)
1605 {
1606 if ($shard_item['shard_id'] == $gshard['shard_id'])
1607 {
1608 $user_shards[] = $shard_item;
1609 }
1610 }
1611 }
1612 }
1613 }
1614
1615 return $user_shards;
1616 }
1617
1618 function tool_admin_logs_get_count()
1619 {
1620 global $db;
1621
1622 $total = 0;
1623
1624 $sql = "SELECT * FROM ". NELDB_LOG_TABLE;
1625 if ($result = $db->sql_query($sql))
1626 {
1627 $total = $db->sql_numrows($result);
1628 }
1629
1630 return $total;
1631 }
1632
1633 function tool_admin_logs_get_list($start=0,$limit=25)
1634 {
1635 global $db;
1636
1637 $data = array();
1638
1639 $sql = "SELECT * FROM ". NELDB_LOG_TABLE ." ORDER BY logs_id DESC LIMIT ". $start .",". $limit;
1640 if ($result = $db->sql_query($sql))
1641 {
1642 if ($db->sql_numrows($result))
1643 {
1644 $data = $db->sql_fetchrowset($result);
1645 }
1646 }
1647
1648 return $data;
1649 }
1650
1651 function tool_admin_domains_get_nel($application)
1652 {
1653 global $db;
1654
1655 $domain_data = null;
1656
1657 if ($db->sql_select_db('nel'))
1658 {
1659 $sql = "SELECT * FROM domain WHERE domain_name='". $application ."'";
1660 if ($result = $db->sql_query($sql))
1661 {
1662 if ($db->sql_numrows($result))
1663 {
1664 $domain_data = $db->sql_fetchrow($result);
1665 }
1666 }
1667
1668 $db->sql_reselect_db();
1669 }
1670
1671 return $domain_data;
1672 }
1673
1674 //function tool_admin_domains_update_nel($domain_id, $domain_name, $domain_version, $domain_status)
1675 function tool_admin_domains_update_nel($domain_id, $domain_name, $domain_status)
1676 {
1677 global $db;
1678
1679 if ($db->sql_select_db('nel'))
1680 {
1681 //$sql = "UPDATE domain SET status='". $domain_status ."',patch_version=". $domain_version ." WHERE domain_id=". $domain_id ." AND domain_name='". $domain_name ."'";
1682 $sql = "UPDATE domain SET status='". $domain_status ."' WHERE domain_id=". $domain_id ." AND domain_name='". $domain_name ."'";
1683 $db->sql_query($sql);
1684
1685 $db->sql_reselect_db();
1686 }
1687 }
1688
1689 function tool_admin_restarts_get_list($order='ASC')
1690 {
1691 global $db;
1692
1693 $data = null;
1694
1695 $sql = "SELECT * FROM ". NELDB_RESTART_GROUP_TABLE ." ORDER BY restart_group_order ". $order .", restart_group_name ". $order;
1696 if ($result = $db->sql_query($sql))
1697 {
1698 if ($db->sql_numrows($result))
1699 {
1700 $data = $db->sql_fetchrowset($result);
1701 }
1702 }
1703
1704 return $data;
1705 }
1706
1707 function tool_admin_restarts_add($restart_name, $restart_list, $restart_order)
1708 {
1709 global $db;
1710
1711 $restart_name = trim($restart_name);
1712 if ($restart_name == '') return "/!\ Error: restart group name is empty!";
1713
1714 $restart_list = trim($restart_list);
1715 if ($restart_list == '') return "/!\ Error: restart group list is empty!";
1716
1717 $restart_order = trim($restart_order);
1718 if (!is_numeric($restart_order)) return "/!\ Error: restart group order is not numeric!";
1719
1720 $sql = "INSERT INTO ". NELDB_RESTART_GROUP_TABLE;
1721 $sql .= " (`restart_group_id`,`restart_group_name`,`restart_group_list`,`restart_group_order`) ";
1722 $sql .= " VALUES ";
1723 $sql .= " (0,'". $restart_name ."','". $restart_list ."','". $restart_order ."') ";
1724 $db->sql_query($sql);
1725
1726 return "";
1727 }
1728
1729 function tool_admin_restarts_get_id($restart_id)
1730 {
1731 global $db;
1732
1733 $data = null;
1734
1735 $sql = "SELECT * FROM ". NELDB_RESTART_GROUP_TABLE ." WHERE restart_group_id=". $restart_id;
1736 if ($result = $db->sql_query($sql))
1737 {
1738 if ($db->sql_numrows($result))
1739 {
1740 $data = $db->sql_fetchrow($result);
1741 }
1742 }
1743
1744 return $data;
1745 }
1746
1747 function tool_admin_restarts_del($restart_id)
1748 {
1749 global $db;
1750
1751 $sql = "DELETE FROM ". NELDB_RESTART_GROUP_TABLE ." WHERE restart_group_id=". $restart_id;
1752 $db->sql_query($sql);
1753 }
1754
1755 function tool_admin_restarts_update($restart_id, $restart_name, $restart_list, $restart_order)
1756 {
1757 global $db;
1758
1759 $restart_name = trim($restart_name);
1760 if ($restart_name == '') return "/!\ Error: restart group name is empty!";
1761
1762 $restart_list = trim($restart_list);
1763 if ($restart_list == '') return "/!\ Error: restart group list is empty!";
1764
1765 $restart_order = trim($restart_order);
1766 if (!is_numeric($restart_order)) return "/!\ Error: restart group order is not numeric!";
1767
1768 $sql = "UPDATE ". NELDB_RESTART_GROUP_TABLE ." SET restart_group_name='". $restart_name ."',restart_group_list='". $restart_list ."',restart_group_order='". $restart_order ."' WHERE restart_group_id=". $restart_id;
1769 $db->sql_query($sql);
1770
1771 return "";
1772 }
1773
1774 function tool_admin_restart_messages_add($message_name, $message_value, $message_lang)
1775 {
1776 global $db;
1777
1778 $message_name = trim($message_name);
1779 if ($message_name == '') return "/!\ Error: restart message name is empty!";
1780
1781 $message_value = trim($message_value);
1782 if ($message_value == '') return "/!\ Error: restart message value is empty!";
1783
1784 $sql = "INSERT INTO ". NELDB_RESTART_MESSAGE_TABLE;
1785 $sql .= " (`restart_message_id`,`restart_message_name`,`restart_message_value`,`restart_message_lang`) ";
1786 $sql .= " VALUES ";
1787 $sql .= " (0,'". $message_name ."','". $message_value ."','". $message_lang ."') ";
1788 $db->sql_query($sql);
1789
1790 return "";
1791 }
1792
1793 function tool_admin_restart_messages_get_list()
1794 {
1795 global $db;
1796
1797 $data = null;
1798
1799 $sql = "SELECT * FROM ". NELDB_RESTART_MESSAGE_TABLE ." ORDER BY restart_message_name ASC, restart_message_lang ASC";
1800 if ($result = $db->sql_query($sql))
1801 {
1802 if ($db->sql_numrows($result))
1803 {
1804 $data = $db->sql_fetchrowset($result);
1805 }
1806 }
1807
1808 return $data;
1809 }
1810
1811 function tool_admin_restart_messages_get_id($message_id)
1812 {
1813 global $db;
1814
1815 $data = null;
1816
1817 $sql = "SELECT * FROM ". NELDB_RESTART_MESSAGE_TABLE ." WHERE restart_message_id=". $message_id;
1818 if ($result = $db->sql_query($sql))
1819 {
1820 if ($db->sql_numrows($result))
1821 {
1822 $data = $db->sql_fetchrow($result);
1823 }
1824 }
1825
1826 return $data;
1827 }
1828
1829 function tool_admin_restart_messages_get_list_from_name($message_name,$lang=null)
1830 {
1831 global $db;
1832
1833 $data = null;
1834
1835 $sql_ext = '';
1836 if ($lang !== null)
1837 {
1838 $sql_ext = " AND restart_message_lang='". $lang ."'";
1839 }
1840
1841 $sql = "SELECT * FROM ". NELDB_RESTART_MESSAGE_TABLE ." WHERE restart_message_name='". $message_name ."' ". $sql_ext ." ORDER BY restart_message_lang ASC";
1842 if ($result = $db->sql_query($sql))
1843 {
1844 if ($db->sql_numrows($result))
1845 {
1846 $data = $db->sql_fetchrowset($result);
1847 }
1848 }
1849
1850 return $data;
1851 }
1852
1853 function tool_admin_restart_messages_del($message_id)
1854 {
1855 global $db;
1856
1857 $sql = "DELETE FROM ". NELDB_RESTART_MESSAGE_TABLE ." WHERE restart_message_id=". $message_id;
1858 $db->sql_query($sql);
1859 }
1860
1861 function tool_admin_restart_messages_update($message_id, $message_name, $message_value, $message_lang)
1862 {
1863 global $db;
1864
1865 $message_name = trim($message_name);
1866 if ($message_name == '') return "/!\ Error: restart message name is empty!";
1867
1868 $message_value = trim($message_value);
1869 if ($message_value == '') return "/!\ Error: restart message value is empty!";
1870
1871 $sql = "UPDATE ". NELDB_RESTART_MESSAGE_TABLE ." SET restart_message_name='". $message_name ."',restart_message_value='". $message_value ."',restart_message_lang='". $message_lang ."' WHERE restart_message_id=". $message_id;
1872 $db->sql_query($sql);
1873
1874 return "";
1875 }
1876
1877
1878 ?>