|
weathermap |
Subversion Repositories: |
Compare with Previous - Blame - Download
<?phpchdir('../../');include_once("./include/auth.php");include_once("./include/config.php");include_once($config["library_path"] . "/database.php");$weathermap_confdir = realpath(dirname(__FILE__).'/configs');// include the weathermap class so that we can get the versioninclude_once(dirname(__FILE__)."/Weathermap.class.php");$i_understand_file_permissions_and_how_to_fix_them = FALSE;$action = "";if (isset($_POST['action'])) {$action = $_POST['action'];} else if (isset($_GET['action'])) {$action = $_GET['action'];}switch ($action) {case 'group_update':$id = -1;$newname = "";if( isset($_REQUEST['id']) && is_numeric($_REQUEST['id'])) { $id = intval($_REQUEST['id']); }if( isset($_REQUEST['gname']) && (strlen($_REQUEST['gname'])>0) ) { $newname = $_REQUEST['gname']; }if($id >= 0 && $newname != "") weathermap_group_update($id,$newname);if($id < 0 && $newname != "") weathermap_group_create($newname);header("Location: weathermap-cacti-plugin-mgmt.php?action=groupadmin");break;case 'groupadmin_delete':$id = -1;if( isset($_REQUEST['id']) && is_numeric($_REQUEST['id'])) { $id = intval($_REQUEST['id']); }if($id>=1){weathermap_group_delete($id);}header("Location: weathermap-cacti-plugin-mgmt.php?action=groupadmin");break;case 'group_form':$id = -1;include_once($config["base_path"]."/include/top_header.php");if( isset($_REQUEST['id']) && is_numeric($_REQUEST['id'])) { $id = intval($_REQUEST['id']); }if($id>=0){weathermap_group_form($id);}weathermap_footer_links();include_once($config["base_path"]."/include/bottom_footer.php");break;case 'groupadmin':include_once($config["base_path"]."/include/top_header.php");weathermap_group_editor();weathermap_footer_links();include_once($config["base_path"]."/include/bottom_footer.php");break;case 'chgroup_update':$mapid = -1;$groupid = -1;if( isset($_REQUEST['map_id']) && is_numeric($_REQUEST['map_id'])) { $mapid = intval($_REQUEST['map_id']); }if( isset($_REQUEST['new_group']) && is_numeric($_REQUEST['new_group'])) { $groupid = intval($_REQUEST['new_group']); }if( ($groupid > 0) && ($mapid >= 0)) { weathermap_set_group($mapid,$groupid); }header("Location: weathermap-cacti-plugin-mgmt.php");break;case 'chgroup':if( isset($_REQUEST['id']) && is_numeric($_REQUEST['id']) ){include_once($config["base_path"]."/include/top_header.php");weathermap_chgroup( intval($_REQUEST['id']) );include_once($config["base_path"]."/include/bottom_footer.php");}else{print "Something got lost back there.";}break;case 'map_settings_delete':$mapid = NULL;$settingid = NULL;if( isset($_REQUEST['mapid']) && is_numeric($_REQUEST['mapid'])) { $mapid = intval($_REQUEST['mapid']); }if( isset($_REQUEST['id']) && is_numeric($_REQUEST['id'])) { $settingid = intval($_REQUEST['id']); }if(! is_null($mapid) && ! is_null($settingid) ){// create settingweathermap_setting_delete($mapid,$settingid);}header("Location: weathermap-cacti-plugin-mgmt.php?action=map_settings&id=".$mapid);break;// this is the save option from the map_settings_formcase 'save':$mapid = NULL;$settingid = NULL;$name=''; $value='';if( isset($_REQUEST['mapid']) && is_numeric($_REQUEST['mapid'])) { $mapid = intval($_REQUEST['mapid']); }if( isset($_REQUEST['id']) && is_numeric($_REQUEST['id'])) { $settingid = intval($_REQUEST['id']); }if( isset($_REQUEST['name']) && $_REQUEST['name']) { $name = $_REQUEST['name']; }if( isset($_REQUEST['value']) && $_REQUEST['value']) { $value = $_REQUEST['value']; }if(! is_null($mapid) && $settingid==0 ){// create settingweathermap_setting_save($mapid,$name,$value);}elseif(! is_null($mapid) && ! is_null($settingid) ){// update settingweathermap_setting_update($mapid,$settingid,$name,$value);}header("Location: weathermap-cacti-plugin-mgmt.php?action=map_settings&id=".$mapid);break;case 'map_settings_form':if( isset($_REQUEST['mapid']) && is_numeric($_REQUEST['mapid'])){include_once($config["base_path"]."/include/top_header.php");if( isset($_REQUEST['id']) && is_numeric($_REQUEST['id'])){weathermap_map_settings_form(intval($_REQUEST['mapid']), intval($_REQUEST['id']) );}else{weathermap_map_settings_form(intval($_REQUEST['mapid']));}weathermap_footer_links();include_once($config["base_path"]."/include/bottom_footer.php");}break;case 'map_settings':if( isset($_REQUEST['id']) && is_numeric($_REQUEST['id'])){include_once($config["base_path"]."/include/top_header.php");weathermap_map_settings(intval($_REQUEST['id']));weathermap_footer_links();include_once($config["base_path"]."/include/bottom_footer.php");}break;case 'perms_add_user':if( isset($_REQUEST['mapid']) && is_numeric($_REQUEST['mapid'])&& isset($_REQUEST['userid']) && is_numeric($_REQUEST['userid'])){perms_add_user(intval($_REQUEST['mapid']),intval($_REQUEST['userid']));header("Location: weathermap-cacti-plugin-mgmt.php?action=perms_edit&id=".intval($_REQUEST['mapid']));}break;case 'perms_delete_user':if( isset($_REQUEST['mapid']) && is_numeric($_REQUEST['mapid'])&& isset($_REQUEST['userid']) && is_numeric($_REQUEST['userid'])){perms_delete_user($_REQUEST['mapid'],$_REQUEST['userid']);header("Location: weathermap-cacti-plugin-mgmt.php?action=perms_edit&id=".$_REQUEST['mapid']);}break;case 'perms_edit':if( isset($_REQUEST['id']) && is_numeric($_REQUEST['id']) ){include_once($config["base_path"]."/include/top_header.php");perms_list($_REQUEST['id']);include_once($config["base_path"]."/include/bottom_footer.php");}else{print "Something got lost back there.";}break;case 'delete_map':if( isset($_REQUEST['id']) && is_numeric($_REQUEST['id']) ) map_delete($_REQUEST['id']);header("Location: weathermap-cacti-plugin-mgmt.php");break;case 'deactivate_map':if( isset($_REQUEST['id']) && is_numeric($_REQUEST['id']) ) map_deactivate($_REQUEST['id']);header("Location: weathermap-cacti-plugin-mgmt.php");break;case 'activate_map':if( isset($_REQUEST['id']) && is_numeric($_REQUEST['id']) ) map_activate($_REQUEST['id']);header("Location: weathermap-cacti-plugin-mgmt.php");break;case 'move_map_up':if( isset($_REQUEST['id']) && is_numeric($_REQUEST['id']) &&isset($_REQUEST['order']) && is_numeric($_REQUEST['order']) )map_move($_REQUEST['id'],$_REQUEST['order'],-1);header("Location: weathermap-cacti-plugin-mgmt.php");break;case 'move_map_down':if( isset($_REQUEST['id']) && is_numeric($_REQUEST['id']) &&isset($_REQUEST['order']) && is_numeric($_REQUEST['order']) )map_move($_REQUEST['id'],$_REQUEST['order'],+1);header("Location: weathermap-cacti-plugin-mgmt.php");break;case 'move_group_up':if( isset($_REQUEST['id']) && is_numeric($_REQUEST['id']) &&isset($_REQUEST['order']) && is_numeric($_REQUEST['order']) )weathermap_group_move(intval($_REQUEST['id']),intval($_REQUEST['order']),-1);header("Location: weathermap-cacti-plugin-mgmt.php?action=groupadmin");break;case 'move_group_down':if( isset($_REQUEST['id']) && is_numeric($_REQUEST['id']) &&isset($_REQUEST['order']) && is_numeric($_REQUEST['order']) )weathermap_group_move(intval($_REQUEST['id']),intval($_REQUEST['order']),1);header("Location: weathermap-cacti-plugin-mgmt.php?action=groupadmin");break;case 'viewconfig':include_once($config["base_path"]."/include/top_graph_header.php");if(isset($_REQUEST['file'])){preview_config($_REQUEST['file']);}else{print "No such file.";}include_once($config["base_path"]."/include/bottom_footer.php");break;case 'addmap_picker':include_once($config["base_path"]."/include/top_header.php");if(isset($_REQUEST['show']) && $_REQUEST['show']=='all'){addmap_picker(true);}else{addmap_picker(false);}include_once($config["base_path"]."/include/bottom_footer.php");break;case 'addmap':if(isset($_REQUEST['file'])){add_config($_REQUEST['file']);header("Location: weathermap-cacti-plugin-mgmt.php");}else{print "No such file.";}break;case 'editor':// chdir(dirname(__FILE__));// include_once('./weathermap-cacti-plugin-editor.php');break;case 'rebuildnow':include_once($config["base_path"]."/include/top_header.php");print "<h3>REALLY Rebuild all maps?</h3><strong>NOTE: Because your Cacti poller process probably doesn't run as the same user as your webserver, it's possible this will fail with file permission problems even though the normal poller process runs fine. In some situations, it MAY have memory_limit problems, if your mod_php/ISAPI module uses a different php.ini to your command-line PHP.</strong><hr>";print "<p>It is recommended that you don't use this feature, unless you understand and accept the problems it may cause.</p>";print "<h4><a href=\"weathermap-cacti-plugin-mgmt.php?action=rebuildnow2\">YES</a></h4>";print "<h1><a href=\"weathermap-cacti-plugin-mgmt.php\">NO</a></h1>";include_once($config["base_path"]."/include/bottom_footer.php");break;case 'rebuildnow2':include_once(dirname(__FILE__).DIRECTORY_SEPARATOR."Weathermap.class.php");include_once(dirname(__FILE__).DIRECTORY_SEPARATOR."lib".DIRECTORY_SEPARATOR."poller-common.php");include_once($config["base_path"]."/include/top_header.php");print "<h3>Rebuilding all maps</h3><strong>NOTE: Because your Cacti poller process probably doesn't run as the same user as your webserver, it's possible this will fail with file permission problems even though the normal poller process runs fine. In some situations, it MAY have memory_limit problems, if your mod_php/ISAPI module uses a different php.ini to your command-line PHP.</strong><hr><pre>";weathermap_run_maps(dirname(__FILE__));print "</pre>";print "<hr /><h3>Done.</h3>";include_once($config["base_path"]."/include/bottom_footer.php");break;// by default, just list the map setupdefault:include_once($config["base_path"]."/include/top_header.php");maplist();weathermap_footer_links();include_once($config["base_path"]."/include/bottom_footer.php");break;}///////////////////////////////////////////////////////////////////////////function weathermap_footer_links(){global $colors;global $WEATHERMAP_VERSION;print '<br />';html_start_box("<center><a target=\"_blank\" class=\"linkOverDark\" href=\"docs/\">Local Documentation</a> -- <a target=\"_blank\" class=\"linkOverDark\" href=\"http://www.network-weathermap.com/\">Weathermap Website</a> -- <a target=\"_target\" class=\"linkOverDark\" href=\"editor.php?plug=1\">Weathermap Editor</a> -- This is version $WEATHERMAP_VERSION</center>", "78%", $colors["header"], "2", "center", "");html_end_box();}// Repair the sort order column (for when something is deleted or inserted, or moved between groups)// our primary concern is to make the sort order consistent, rather than any special 'correctness'function map_resort(){$list = db_fetch_assoc("select * from weathermap_maps order by group_id,sortorder;");$i = 1;$last_group = -1020.5;foreach ($list as $map){if($last_group != $map['group_id']){$last_group = $map['group_id'];$i=1;}$sql[] = "update weathermap_maps set sortorder = $i where id = ".$map['id'];$i++;}if (!empty($sql)) {for ($a = 0; $a < count($sql); $a++) {$result = db_execute($sql[$a]);}}}// Repair the sort order column (for when something is deleted or inserted)function weathermap_group_resort(){$list = db_fetch_assoc("select * from weathermap_groups order by sortorder;");$i = 1;foreach ($list as $group){$sql[] = "update weathermap_groups set sortorder = $i where id = ".$group['id'];$i++;}if (!empty($sql)) {for ($a = 0; $a < count($sql); $a++) {$result = db_execute($sql[$a]);}}}function map_move($mapid,$junk,$direction){$source = db_fetch_assoc("select * from weathermap_maps where id=$mapid");$oldorder = $source[0]['sortorder'];$group = $source[0]['group_id'];$neworder = $oldorder + $direction;$target = db_fetch_assoc("select * from weathermap_maps where group_id=$group and sortorder = $neworder");if(!empty($target[0]['id'])){$otherid = $target[0]['id'];// move $mapid in direction $direction$sql[] = "update weathermap_maps set sortorder = $neworder where id=$mapid";// then find the other one with the same sortorder and move that in the opposite direction$sql[] = "update weathermap_maps set sortorder = $oldorder where id=$otherid";}if (!empty($sql)) {for ($a = 0; $a < count($sql); $a++) {$result = db_execute($sql[$a]);}}}function weathermap_group_move($id,$junk,$direction){$source = db_fetch_assoc("select * from weathermap_groups where id=$id");$oldorder = $source[0]['sortorder'];$neworder = $oldorder + $direction;$target = db_fetch_assoc("select * from weathermap_groups where sortorder = $neworder");if(!empty($target[0]['id'])){$otherid = $target[0]['id'];// move $mapid in direction $direction$sql[] = "update weathermap_groups set sortorder = $neworder where id=$id";// then find the other one with the same sortorder and move that in the opposite direction$sql[] = "update weathermap_groups set sortorder = $oldorder where id=$otherid";}if (!empty($sql)) {for ($a = 0; $a < count($sql); $a++) {$result = db_execute($sql[$a]);}}}function maplist(){global $colors, $menu;global $i_understand_file_permissions_and_how_to_fix_them;#print "<pre>";#print_r($menu);#print "</pre>";$last_started = read_config_option("weathermap_last_started_file",true);$last_finished = read_config_option("weathermap_last_finished_file",true);$last_start_time = intval(read_config_option("weathermap_last_start_time",true));$last_finish_time = intval(read_config_option("weathermap_last_finish_time",true));$poller_interval = intval(read_config_option("poller_interval"));if( ($last_finish_time - $last_start_time) > $poller_interval ) {if( ($last_started != $last_finished) && ($last_started != "") ) {print '<div align="center" class="wm_warning"><p>';print "Last time it ran, Weathermap did NOT complete it's run. It failed during processing for '$last_started'. ";print "This <strong>may</strong> have affected other plugins that run during the poller process. </p><p>";print "You should either disable this map, or fault-find. Possible causes include memory_limit issues. The log may have more information.";print '</p></div>';}}html_start_box("<strong>Weathermaps</strong>", "78%", $colors["header"], "3", "center", "weathermap-cacti-plugin-mgmt.php?action=addmap_picker");html_header(array("Config File", "Title", "Group", "Active", "Settings", "Sort Order", "Accessible By",""));$query = db_fetch_assoc("select id,username from user_auth");$users[0] = 'Anyone';foreach ($query as $user){$users[$user['id']] = $user['username'];}$i = 0;$queryrows = db_fetch_assoc("select weathermap_maps.*, weathermap_groups.name as groupname from weathermap_maps, weathermap_groups where weathermap_maps.group_id=weathermap_groups.id order by weathermap_groups.sortorder,sortorder");// or die (mysql_error("Could not connect to database") )$previous_id = -2;$had_warnings = 0;if( is_array($queryrows) ){form_alternate_row_color($colors["alternate"],$colors["light"],$i);print "<td>ALL MAPS</td><td>(special settings for all maps)</td><td></td><td></td>";print "<td><a href='?action=map_settings&id=0'>";$setting_count = db_fetch_cell("select count(*) from weathermap_settings where mapid=0 and groupid=0");if($setting_count > 0){print $setting_count." special";if($setting_count>1) print "s";}else{print "standard";}print "</a>";print "</td>";print "<td></td>";print "<td></td>";print "<td></td>";print "</tr>";$i++;foreach ($queryrows as $map){form_alternate_row_color($colors["alternate"],$colors["light"],$i);print '<td><a title="Click to start editor with this file" href="editor.php?plug=1&mapname='.htmlspecialchars($map['configfile']).'">'.htmlspecialchars($map['configfile']).'</a>';if($map['warncount']>0){$had_warnings++;print '<a href="../../utilities.php?tail_lines=500&message_type=2&action=view_logfile&filter='.urlencode($map['configfile']).'" title="Check cacti.log for this map"><img border=0 src="images/exclamation.png" title="'.$map['warncount'].' warnings last time this map was run. Check your logs.">'.$map['warncount']."</a>";}print "</td>";# print '<a href="?action=editor&plug=1&mapname='.htmlspecialchars($map['configfile']).'">[edit]</a></td>';print '<td>'.htmlspecialchars($map['titlecache']).'</td>';print '<td><a title="Click to change group" href="?action=chgroup&id='.$map['id'].'">'.htmlspecialchars($map['groupname']).'</a></td>';if($map['active'] == 'on'){print '<td class="wm_enabled"><a title="Click to Deactivate" href="?action=deactivate_map&id='.$map['id'].'"><font color="green">Yes</font></a>';}else{print '<td class="wm_disabled"><a title="Click to Activate" href="?action=activate_map&id='.$map['id'].'"><font color="red">No</font></a>';}print "<td>";print "<a href='?action=map_settings&id=".$map['id']."'>";$setting_count = db_fetch_cell("select count(*) from weathermap_settings where mapid=".$map['id']);if($setting_count > 0){print $setting_count." special";if($setting_count>1) print "s";}else{print "standard";}print "</a>";print "</td>";print '</td>';print '<td>';print '<a href="?action=move_map_up&order='.$map['sortorder'].'&id='.$map['id'].'"><img src="../../images/move_up.gif" width="14" height="10" border="0" alt="Move Map Up" title="Move Map Up"></a>';print '<a href="?action=move_map_down&order='.$map['sortorder'].'&id='.$map['id'].'"><img src="../../images/move_down.gif" width="14" height="10" border="0" alt="Move Map Down" title="Move Map Down"></a>';// print $map['sortorder'];print "</td>";print '<td>';$UserSQL = 'select * from weathermap_auth where mapid='.$map['id'].' order by userid';$userlist = db_fetch_assoc($UserSQL);$mapusers = array();foreach ($userlist as $user){if(array_key_exists($user['userid'],$users)){$mapusers[] = $users[$user['userid']];}}print '<a title="Click to edit permissions" href="?action=perms_edit&id='.$map['id'].'">';if(count($mapusers) == 0){print "(no users)";}else{print join(", ",$mapusers);}print '</a>';print '</td>';// print '<td><a href="?action=editor&mapname='.urlencode($map['configfile']).'">Edit Map</a></td>';print '<td>';print '<a href="?action=delete_map&id='.$map['id'].'"><img src="../../images/delete_icon.gif" width="10" height="10" border="0" alt="Delete Map" title="Delete Map"></a>';print '</td>';print '</tr>';$i++;}}if($i==0){print "<tr><td><em>No Weathermaps Configured</em></td></tr>\n";}html_end_box();$last_stats = read_config_option("weathermap_last_stats", true);if($last_stats != "") {print "<div align='center'><strong>Last Completed Run:</strong> $last_stats</div>";} else {}if($had_warnings>0){print '<div align="center" class="wm_warning">'.$had_warnings.' of your maps had warnings last time '.($had_warnings>1?"they":"it").' ran. You can try to find these in your Cacti log file or by clicking on the warning sign next to that map (you might need to increase the log line count).</div>';}print "<div align='center'>";print "<a href='weathermap-cacti-plugin-mgmt.php?action=groupadmin'><img src='images/button_editgroups.png' border=0 alt='Edit Groups' /></a>";print " <a href='../../settings.php?tab=misc'><img src='images/button_settings.gif' border=0 alt='Settings' /></a>";if($i>0 && $i_understand_file_permissions_and_how_to_fix_them){print '<br /><a href="?action=rebuildnow"><img src="images/btn_recalc.png" border="0" alt="Rebuild All Maps Right Now"><br />(Experimental - You should NOT need to use this normally)</a><br />';}print "</div>";}function addmap_picker($show_all=false){global $weathermap_confdir;global $colors;$loaded=array();$flags=array();// find out what maps are already in the database, so we can skip those$queryrows = db_fetch_assoc("select * from weathermap_maps");if( is_array($queryrows) ){foreach ($queryrows as $map){$loaded[]=$map['configfile'];}}$loaded[]='index.php';html_start_box("<strong>Available Weathermap Configuration Files</strong>", "78%", $colors["header"], "1", "center", "");if( is_dir($weathermap_confdir)){$n=0;$dh = opendir($weathermap_confdir);if($dh){$i = 0; $skipped = 0;html_header(array("","","Config File", "Title",""),2);while($file = readdir($dh)){$realfile = $weathermap_confdir.'/'.$file;$used = in_array($file,$loaded);$flags[$file] = '';if($used) $flags[$file] = 'USED';if( is_file($realfile) ){if( $used && !$show_all){$skipped++;}else{$title = wmap_get_title($realfile);$titles[$file] = $title;$i++;}}}closedir($dh);if($i>0){ksort($titles);$i=0;foreach ($titles as $file=>$title){$title = $titles[$file];form_alternate_row_color($colors["alternate"],$colors["light"],$i);print '<td><a href="?action=addmap&file='.$file.'" title="Add the configuration file">Add</a></td>';print '<td><a href="?action=viewconfig&file='.$file.'" title="View the configuration file in a new window" target="_blank">View</a></td>';print '<td>'.htmlspecialchars($file);if($flags[$file] == 'USED') print ' <b>(USED)</b>';print '</td>';print '<td><em>'.htmlspecialchars($title).'</em></td>';print '</tr>';$i++;}}if( ($i + $skipped) == 0 ){print "<tr><td>No files were found in the configs directory.</td></tr>";}if( ($i == 0) && $skipped>0){print "<tr><td>($skipped files weren't shown because they are already in the database</td></tr>";}}else{print "<tr><td>Can't open $weathermap_confdir to read - you should set it to be readable by the webserver.</td></tr>";}}else{print "<tr><td>There is no directory named $weathermap_confdir - you will need to create it, and set it to be readable by the webserver. If you want to upload configuration files from inside Cacti, then it should be <i>writable</i> by the webserver too.</td></tr>";}html_end_box();if($skipped>0){print "<p align=center>Some files are not shown because they have already been added. You can <a href='?action=addmap_picker&show=all'>show these files too</a>, if you need to.</p>";}if($show_all){print "<p align=center>Some files are shown even though they have already been added. You can <a href='?action=addmap_picker'>hide those files too</a>, if you need to.</p>";}}function preview_config($file){global $weathermap_confdir;global $colors;chdir($weathermap_confdir);$path_parts = pathinfo($file);$file_dir = realpath($path_parts['dirname']);if($file_dir != $weathermap_confdir){// someone is trying to read arbitrary files?// print "$file_dir != $weathermap_confdir";print "<h3>Path mismatch</h3>";}else{html_start_box("<strong>Preview of $file</strong>", "98%", $colors["header"], "3", "center", "");print '<tr><td valign="top" bgcolor="#'.$colors["light"].'" class="textArea">';print '<pre>';$realfile = $weathermap_confdir.'/'.$file;if( is_file($realfile) ){$fd = fopen($realfile,"r");while (!feof($fd)){$buffer = fgets($fd,4096);print $buffer;}fclose($fd);}print '</pre>';print '</td></tr>';html_end_box();}}function add_config($file){global $weathermap_confdir;global $colors;chdir($weathermap_confdir);$path_parts = pathinfo($file);$file_dir = realpath($path_parts['dirname']);if($file_dir != $weathermap_confdir){// someone is trying to read arbitrary files?// print "$file_dir != $weathermap_confdir";print "<h3>Path mismatch</h3>";}else{$realfile = $weathermap_confdir.DIRECTORY_SEPARATOR.$file;$title = wmap_get_title($realfile);$file = mysql_real_escape_string($file);$title = mysql_real_escape_string($title);$SQL = "insert into weathermap_maps (configfile,titlecache,active,imagefile,htmlfile,filehash,config) VALUES ('$file','$title','on','','','','')";db_execute($SQL);// add auth for 'admin'$last_id = mysql_insert_id();// $myuid = (int)$_SESSION["sess_user_id"];$myuid = (isset($_SESSION["sess_user_id"]) ? intval($_SESSION["sess_user_id"]) : 1);$SQL = "insert into weathermap_auth (mapid,userid) VALUES ($last_id,$myuid)";db_execute($SQL);db_execute("update weathermap_maps set filehash=LEFT(MD5(concat(id,configfile,rand())),20) where id=$last_id");map_resort();}}function wmap_get_title($filename){$title = "(no title)";$fd = fopen($filename,"r");while (!feof($fd)){$buffer = fgets($fd,4096);if(preg_match("/^\s*TITLE\s+(.*)/i",$buffer, $matches)){$title = $matches[1];}// this regexp is tweaked from the ReadConfig version, to only match TITLEPOS lines *with* a title appendedif(preg_match("/^\s*TITLEPOS\s+\d+\s+\d+\s+(.+)/i",$buffer, $matches)){$title = $matches[1];}// strip out any DOS line endings that got through$title=str_replace("\r", "", $title);}fclose($fd);return($title);}function map_deactivate($id){$SQL = "update weathermap_maps set active='off' where id=".$id;db_execute($SQL);}function map_activate($id){$SQL = "update weathermap_maps set active='on' where id=".$id;db_execute($SQL);}function map_delete($id){$SQL = "delete from weathermap_maps where id=".$id;db_execute($SQL);$SQL = "delete from weathermap_auth where mapid=".$id;db_execute($SQL);$SQL = "delete from weathermap_settings where mapid=".$id;db_execute($SQL);map_resort();}function weathermap_set_group($mapid,$groupid){# print "UPDATING";$SQL = sprintf("update weathermap_maps set group_id=%d where id=%d", $groupid, $mapid);db_execute($SQL);map_resort();}function perms_add_user($mapid,$userid){$SQL = "insert into weathermap_auth (mapid,userid) values($mapid,$userid)";db_execute($SQL);}function perms_delete_user($mapid,$userid){$SQL = "delete from weathermap_auth where mapid=$mapid and userid=$userid";db_execute($SQL);}function perms_list($id){global $colors;// $title_sql = "select titlecache from weathermap_maps where id=$id";$title = db_fetch_cell("select titlecache from weathermap_maps where id=".intval($id));// $title = $results[0]['titlecache'];$auth_sql = "select * from weathermap_auth where mapid=$id order by userid";$query = db_fetch_assoc("select id,username from user_auth order by username");$users[0] = 'Anyone';foreach ($query as $user){$users[$user['id']] = $user['username'];}$auth_results = db_fetch_assoc($auth_sql);$mapusers = array();$mapuserids = array();foreach ($auth_results as $user){if(isset($users[$user['userid']])){$mapusers[] = $users[$user['userid']];$mapuserids[] = $user['userid'];}}$userselect="";foreach ($users as $uid => $name){if(! in_array($uid,$mapuserids)) $userselect .= "<option value=\"$uid\">$name</option>\n";}html_start_box("<strong>Edit permissions for Weathermap $id: $title</strong>", "70%", $colors["header"], "2", "center", "");html_header(array("Username", ""));$n = 0;foreach($mapuserids as $user){form_alternate_row_color($colors["alternate"],$colors["light"],$n);print "<td>".$users[$user]."</td>";print '<td><a href="?action=perms_delete_user&mapid='.$id.'&userid='.$user.'"><img src="../../images/delete_icon.gif" width="10" height="10" border="0" alt="Remove permissions for this user to see this map"></a></td>';print "</tr>";$n++;}if($n==0){print "<tr><td><em><strong>nobody</strong> can see this map</em></td></tr>";}html_end_box();html_start_box("", "70%", $colors["header"], "3", "center", "");print "<tr>";if($userselect == ''){print "<td><em>There aren't any users left to add!</em></td></tr>";}else{print "<td><form action=\"\">Allow <input type=\"hidden\" name=\"action\" value=\"perms_add_user\"><input type=\"hidden\" name=\"mapid\" value=\"$id\"><select name=\"userid\">";print $userselect;print "</select> to see this map <input type=\"submit\" value=\"Update\"></form></td>";print "</tr>";}html_end_box();}function weathermap_map_settings($id){global $colors, $config;if($id==0){$title = "Additional settings for ALL maps";$nonemsg = "There are no settings for all maps yet. You can add some by clicking Add up in the top-right, or choose a single map from the management screen to add settings for that map.";$type = "global";$settingrows = db_fetch_assoc("select * from weathermap_settings where mapid=0 and groupid=0");}elseif($id<0){$group_id = -intval($id);$groupname = db_fetch_cell("select name from weathermap_groups where id=".$group_id);$title = "Edit per-map settings for Group ". $group_id . ": " . $groupname;$nonemsg = "There are no per-group settings for this group yet. You can add some by clicking Add up in the top-right.";$type="group";$settingrows = db_fetch_assoc("select * from weathermap_settings where groupid=".$group_id);}else{// print "Per-map settings for map $id";$map = db_fetch_row("select * from weathermap_maps where id=".intval($id));$groupname = db_fetch_cell("select name from weathermap_groups where id=".intval($map['group_id']));$title = "Edit per-map settings for Weathermap $id: " . $map['titlecache'];$nonemsg = "There are no per-map settings for this map yet. You can add some by clicking Add up in the top-right.";$type = "map";$settingrows = db_fetch_assoc("select * from weathermap_settings where mapid=".intval($id));}if($type == "group"){print "<p>All maps in this group are also affected by the following GLOBAL settings (group overrides global, map overrides group, but BOTH override SET commands within the map config file):</p>";weathermap_readonly_settings(0, "Global Settings");}if($type == "map"){print "<p>This map is also affected by the following GLOBAL and GROUP settings (group overrides global, map overrides group, but BOTH override SET commands within the map config file):</p>";weathermap_readonly_settings(0, "Global Settings");weathermap_readonly_settings(-$map['group_id'], "Group Settings (".htmlspecialchars($groupname).")");}html_start_box("<strong>$title</strong>", "70%", $colors["header"], "2", "center", "weathermap-cacti-plugin-mgmt.php?action=map_settings_form&mapid=".intval($id));html_header(array("","Name", "Value",""));$n=0;if( is_array($settingrows) ){if(sizeof($settingrows)>0){foreach( $settingrows as $setting){form_alternate_row_color($colors["alternate"],$colors["light"],$n);print '<td><a href="?action=map_settings_form&mapid='.$id.'&id='.intval($setting['id']).'"><img src="../../images/graph_properties.gif" width="16" height="16" border="0" alt="Edit this definition">Edit</a></td>';print "<td>".htmlspecialchars($setting['optname'])."</td>";print "<td>".htmlspecialchars($setting['optvalue'])."</td>";print '<td><a href="?action=map_settings_delete&mapid='.$id.'&id='.intval($setting['id']).'"><img src="../../images/delete_icon_large.gif" width="12" height="12" border="0" alt="Remove this definition from this map"></a></td>';print "</tr>";$n++;}}else{print "<tr>";print "<td colspan=2>$nonemsg</td>";print "</tr>";}}html_end_box();print "<div align=center>";if($type == "group") print "<a href='?action=groupadmin'>Back to Group Admin</a>";if($type == "global") print "<a href='?action='>Back to Map Admin</a>";print "</div>";}function weathermap_readonly_settings($id,$title="Settings"){global $colors, $config;if($id == 0) $query = "select * from weathermap_settings where mapid=0 and groupid=0";if($id < 0) $query = "select * from weathermap_settings where mapid=0 and groupid=".(-intval($id));if($id > 0) $query = "select * from weathermap_settings where mapid=".intval($id);$settings = db_fetch_assoc($query);html_start_box("<strong>$title</strong>", "70%", $colors["header"], "2", "center", "");html_header(array("","Name", "Value",""));$n=0;if(sizeof($settings)>0){foreach($settings as $setting){form_alternate_row_color($colors["alternate"],$colors["light"],$n);print "<td></td>";print "<td>".htmlspecialchars($setting['optname'])."</td><td>".htmlspecialchars($setting['optvalue'])."</td>";print "<td></td>";print "</tr>";$n++;}}else{form_alternate_row_color($colors["alternate"],$colors["light"],$n);print "<td colspan=4><em>No Settings</em></td>";print "</tr>";}html_end_box();}function weathermap_map_settings_form($mapid=0,$settingid=0){global $colors, $config;// print "Per-map settings for map $id";if($mapid > 0) $title = db_fetch_cell("select titlecache from weathermap_maps where id=".intval( $mapid ));if($mapid < 0) $title = db_fetch_cell("select name from weathermap_groups where id=".intval( -$mapid ));// print "Settings edit/add form.";$name = "";$value = "";if($settingid != 0){$result = db_fetch_assoc("select * from weathermap_settings where id=".intval($settingid));if(is_array($result) && sizeof($result)>0){$name = $result[0]['optname'];$value = $result[0]['optvalue'];}}# print "$mapid $settingid |$name| |$value|";$values_ar = array();$field_ar = array("mapid" => array("friendly_name" => "Map ID", "method" => "hidden_zero", "value" => $mapid ) ,"id" => array("friendly_name" => "Setting ID", "method" => "hidden_zero", "value" => $settingid ) ,"name" => array("friendly_name" => "Name", "method" => "textbox", "max_length"=>128,"description"=>"The name of the map-global SET variable", "value"=>$name),"value" => array("friendly_name" => "Value", "method" => "textbox", "max_length"=>128, "description"=>"What to set it to", "value"=>$value));$action = "Edit";if($settingid == 0) $action ="Create";if($mapid == 0){$title = "setting for ALL maps";}elseif($mapid < 0){$grpid = -$mapid;$title = "per-group setting for Group $grpid: $title";}else{$title = "per-map setting for Weathermap $mapid: $title";}html_start_box("<strong>$action $title</strong>", "98%", $colors["header"], "3", "center", "");draw_edit_form( array("config"=>$values_ar, "fields"=>$field_ar) );html_end_box();form_save_button("weathermap-cacti-plugin-mgmt.php?action=map_settings&id=".$mapid);}function weathermap_setting_save($mapid,$name,$value){if($mapid >0){db_execute("insert into weathermap_settings (mapid, optname, optvalue) values ($mapid,'".mysql_real_escape_string($name)."','".mysql_real_escape_string($value)."')");}elseif($mapid <0){db_execute("insert into weathermap_settings (mapid, groupid, optname, optvalue) values (0, -$mapid,'".mysql_real_escape_string($name)."','".mysql_real_escape_string($value)."')");}else{db_execute("insert into weathermap_settings (mapid, groupid, optname, optvalue) values (0, 0,'".mysql_real_escape_string($name)."','".mysql_real_escape_string($value)."')");}}function weathermap_setting_update($mapid,$settingid,$name,$value){db_execute("update weathermap_settings set optname='".mysql_real_escape_string($name)."', optvalue='".mysql_real_escape_string($value)."' where id=".intval($settingid));}function weathermap_setting_delete($mapid,$settingid){db_execute("delete from weathermap_settings where id=".intval($settingid)." and mapid=".intval($mapid));}function weathermap_chgroup($id){global $colors;$title = db_fetch_cell("select titlecache from weathermap_maps where id=".intval($id));$curgroup = db_fetch_cell("select group_id from weathermap_maps where id=".intval($id));$n=0;print "<form>";print "<input type=hidden name='map_id' value='".$id."'>";print "<input type=hidden name='action' value='chgroup_update'>";html_start_box("<strong>Edit map group for Weathermap $id: $title</strong>", "70%", $colors["header"], "2", "center", "");# html_header(array("Group Name", ""));form_alternate_row_color($colors["alternate"],$colors["light"],$n++);print "<td><strong>Choose an existing Group:</strong><select name='new_group'>";$SQL = "select * from weathermap_groups order by sortorder";$results = db_fetch_assoc($SQL);foreach ($results as $grp){print "<option ";if($grp['id'] == $curgroup) print " SELECTED ";print "value=".$grp['id'].">".htmlspecialchars($grp['name'])."</option>";}print "</select>";print '<input type="image" src="../../images/button_save.gif" border="0" alt="Change Group" title="Change Group" />';print "</td>";print "</tr>\n";print "<tr><td></td></tr>";print "<tr><td><p>or create a new group in the <strong><a href='?action=groupadmin'>group management screen</a></strong></p></td></tr>";html_end_box();print "</form>\n";}function weathermap_group_form($id=0){global $colors, $config;$grouptext = "";// if id==0, it's an Add, otherwise it's an editor.if($id == 0){print "Adding a group...";}else{print "Editing group $id\n";$grouptext = db_fetch_cell("select name from weathermap_groups where id=".$id);}print "<form action=weathermap-cacti-plugin-mgmt.php>\n<input type=hidden name=action value=group_update />\n";print "Group Name: <input name=gname value='".htmlspecialchars($grouptext)."'/>\n";if($id>0){print "<input type=hidden name=id value=$id />\n";print "Group Name: <input type=submit value='Update' />\n";}else{# print "<input type=hidden name=id value=$id />\n";print "Group Name: <input type=submit value='Add' />\n";}print "</form>\n";}function weathermap_group_editor(){global $colors, $config;html_start_box("<strong>Edit Map Groups</strong>", "70%", $colors["header"], "2", "center", "weathermap-cacti-plugin-mgmt.php?action=group_form&id=0");html_header(array("", "Group Name", "Settings", "Sort Order", ""));$groups = db_fetch_assoc("select * from weathermap_groups order by sortorder");$n = 0;if( is_array($groups) ){if(sizeof($groups)>0){foreach( $groups as $group){form_alternate_row_color($colors["alternate"],$colors["light"],$n);print '<td><a href="weathermap-cacti-plugin-mgmt.php?action=group_form&id='.intval($group['id']).'"><img src="../../images/graph_properties.gif" width="16" height="16" border="0" alt="Rename This Group" title="Rename This Group">Rename</a></td>';print "<td>".htmlspecialchars($group['name'])."</td>";print "<td>";print "<a href='?action=map_settings&id=-".$group['id']."'>";$setting_count = db_fetch_cell("select count(*) from weathermap_settings where mapid=0 and groupid=".$group['id']);if($setting_count > 0){print $setting_count." special";if($setting_count>1) print "s";}else{print "standard";}print "</a>";print "</td>";print '<td>';print '<a href="weathermap-cacti-plugin-mgmt.php?action=move_group_up&order='.$group['sortorder'].'&id='.$group['id'].'"><img src="../../images/move_up.gif" width="14" height="10" border="0" alt="Move Group Up" title="Move Group Up"></a>';print '<a href="weathermap-cacti-plugin-mgmt.php?action=move_group_down&order='.$group['sortorder'].'&id='.$group['id'].'"><img src="../../images/move_down.gif" width="14" height="10" border="0" alt="Move Group Down" title="Move Group Down"></a>';// print $map['sortorder'];print "</td>";print '<td>';if($group['id']>1){print '<a href="weathermap-cacti-plugin-mgmt.php?action=groupadmin_delete&id='.intval($group['id']).'"><img src="../../images/delete_icon.gif" width="10" height="10" border="0" alt="Remove this definition from this map"></a>';}print '</td>';print "</tr>";$n++;}}else{print "<tr>";print "<td colspan=2>No groups are defined.</td>";print "</tr>";}}html_end_box();}function weathermap_group_create($newname){$sortorder = db_fetch_cell("select max(sortorder)+1 from weathermap_groups");$SQL = sprintf("insert into weathermap_groups (name, sortorder) values ('%s',%d)", mysql_escape_string($newname), $sortorder);# print $SQL;db_execute($SQL);}function weathermap_group_update($id, $newname){$SQL = sprintf("update weathermap_groups set name='%s' where id=%d", mysql_escape_string($newname), $id);# print $SQL;db_execute($SQL);}function weathermap_group_delete($id){$SQL1 = "SELECT MIN(id) from weathermap_groups where id <> ". $id;$newid = db_fetch_cell($SQL1);# move any maps out of this group into a still-existing one$SQL2 = "UPDATE weathermap_maps set group_id=$newid where group_id=".$id;# then delete the group$SQL3 = "DELETE from weathermap_groups where id=".$id;db_execute($SQL2);db_execute($SQL3);}// vim:ts=4:sw=4:?>