1 | <?php |
---|
2 | |
---|
3 | if (!defined("PHPWG_ROOT_PATH")){ |
---|
4 | die("Hacking attempt!"); |
---|
5 | } |
---|
6 | |
---|
7 | include_once(PHPWG_ROOT_PATH.'admin/include/functions.php'); |
---|
8 | |
---|
9 | // Check access and exit when user status is not ok |
---|
10 | check_status(ACCESS_ADMINISTRATOR); |
---|
11 | |
---|
12 | // Default is to create, if changed to 1, show edit page |
---|
13 | $edit = 0; |
---|
14 | |
---|
15 | // The values for the form fields |
---|
16 | $CRid = 0; |
---|
17 | $CRname = ''; |
---|
18 | $CRurl = ''; |
---|
19 | $CRvisible = 0; |
---|
20 | |
---|
21 | // Do managing of copyrights |
---|
22 | if (isset($_GET['tab'])) { |
---|
23 | if ($_GET['tab'] == 'create') { |
---|
24 | $name = $_REQUEST['name']; |
---|
25 | $url = $_REQUEST['url']; |
---|
26 | $visible = (isset($_REQUEST['visible']) ? 1 : 0); |
---|
27 | $query = ' |
---|
28 | INSERT INTO '.COPYRIGHTS_ADMIN.' |
---|
29 | (`name`,`url`,`visible`) VALUES |
---|
30 | ("'.$name.'","'.$url.'",'.$visible.') |
---|
31 | ;'; |
---|
32 | pwg_query($query); |
---|
33 | } |
---|
34 | |
---|
35 | if ($_GET['tab'] == 'edit') { |
---|
36 | $edit = 1; |
---|
37 | $CRid = $_REQUEST['id']; |
---|
38 | $query = ' |
---|
39 | SELECT * |
---|
40 | FROM '.COPYRIGHTS_ADMIN.' |
---|
41 | WHERE `cr_id`='.$CRid.' |
---|
42 | ;'; |
---|
43 | $result = pwg_query($query); |
---|
44 | $row = pwg_db_fetch_assoc($result); |
---|
45 | $CRname = $row['name']; |
---|
46 | $CRurl = $row['url']; |
---|
47 | $CRvisible = $row['visible']; |
---|
48 | } |
---|
49 | |
---|
50 | if ($_GET['tab'] == 'update') { |
---|
51 | $id = $_REQUEST['id']; |
---|
52 | $name = $_REQUEST['name']; |
---|
53 | $url = $_REQUEST['url']; |
---|
54 | $visible = (isset($_REQUEST['visible']) ? 1 : 0); |
---|
55 | $query = ' |
---|
56 | UPDATE '.$prefixeTable.'copyrights_admin |
---|
57 | SET `name`="'.$name.'", `url`="'.$url.'", `visible`='.$visible.' |
---|
58 | WHERE `cr_id`='.$id.' |
---|
59 | ;'; |
---|
60 | pwg_query($query); |
---|
61 | } |
---|
62 | |
---|
63 | if ($_GET['tab'] == 'delete') { |
---|
64 | $id = $_REQUEST['id']; |
---|
65 | $query = ' |
---|
66 | DELETE FROM '.$prefixeTable.'copyrights_admin |
---|
67 | WHERE `cr_id`='.$id.' |
---|
68 | ;'; |
---|
69 | pwg_query($query); |
---|
70 | } |
---|
71 | } |
---|
72 | |
---|
73 | // Create page template |
---|
74 | global $template; |
---|
75 | |
---|
76 | $template->set_filenames( |
---|
77 | array( |
---|
78 | 'plugin_admin_content' => dirname(__FILE__).'/admin.tpl' |
---|
79 | ) |
---|
80 | ); |
---|
81 | |
---|
82 | $query = ' |
---|
83 | SELECT * |
---|
84 | FROM '.COPYRIGHTS_ADMIN.' |
---|
85 | ;'; |
---|
86 | $result = pwg_query($query); |
---|
87 | |
---|
88 | while ($row = pwg_db_fetch_assoc($result)) { |
---|
89 | $template->append( |
---|
90 | 'CRs', |
---|
91 | array( |
---|
92 | 'cr_id' => $row['cr_id'], |
---|
93 | 'name' => $row['name'], |
---|
94 | 'url' => $row['url'], |
---|
95 | 'visible' => $row['visible'] |
---|
96 | ) |
---|
97 | ); |
---|
98 | } |
---|
99 | |
---|
100 | $template->assign( |
---|
101 | 'COPYRIGHTS_PATH', |
---|
102 | COPYRIGHTS_WEB_PATH |
---|
103 | ); |
---|
104 | |
---|
105 | $template->assign('edit', $edit); |
---|
106 | $template->assign('CRid', $CRid); |
---|
107 | $template->assign('CRname', $CRname); |
---|
108 | $template->assign('CRurl', $CRurl); |
---|
109 | $template->assign('CRvisible', $CRvisible); |
---|
110 | |
---|
111 | $template->assign_var_from_handle('ADMIN_CONTENT', 'plugin_admin_content'); |
---|
112 | |
---|
113 | ?> |
---|