Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
View | Details | Raw Unified | Return to bug 113337
Collapse All | Expand All

(-)cacti-0.8.6g_p20051023/graph_view.php (-1 / +1 lines)
Lines 207-213 Link Here
207 
               }
 207 
               }
208 
       }
 208 
       }
209 
       $sql_base = "from graph_templates_graph,graph_local
 209 
       $sql_base = "from (graph_templates_graph,graph_local)
210 
               $sql_join
 210 
               $sql_join
211 
               $sql_where
 211 
               $sql_where
212 
               " . (empty($sql_where) ? "where" : "and") . " graph_templates_graph.local_graph_id > 0
 212 
               " . (empty($sql_where) ? "where" : "and") . " graph_templates_graph.local_graph_id > 0
(-)cacti-0.8.6g_p20051023/graphs.php (-2 / +2 lines)
Lines 1037-1043 Link Here
1037 
       $total_rows = db_fetch_cell("select
 1037 
       $total_rows = db_fetch_cell("select
1038 
               COUNT(graph_templates_graph.id)
 1038 
               COUNT(graph_templates_graph.id)
1039 
               from graph_local,graph_templates_graph
 1039 
               from (graph_local,graph_templates_graph)
1040 
               where graph_local.id=graph_templates_graph.local_graph_id
 1040 
               where graph_local.id=graph_templates_graph.local_graph_id
1041 
               $sql_where");
 1041 
               $sql_where");
Lines 1049-1055 Link Here
1049 
               graph_templates_graph.title_cache,
 1049 
               graph_templates_graph.title_cache,
1050 
               graph_templates.name,
 1050 
               graph_templates.name,
1051 
               graph_local.host_id
 1051 
               graph_local.host_id
1052 
               from graph_local,graph_templates_graph
 1052 
               from (graph_local,graph_templates_graph)
1053 
               left join graph_templates on graph_local.graph_template_id=graph_templates.id
 1053 
               left join graph_templates on graph_local.graph_template_id=graph_templates.id
1054 
               where graph_local.id=graph_templates_graph.local_graph_id
 1054 
               where graph_local.id=graph_templates_graph.local_graph_id
1055 
               $sql_where
 1055 
               $sql_where
(-)cacti-0.8.6g_p20051023/lib/auth.php (-1 / +1 lines)
Lines 130-136 Link Here
130 
       $graphs = db_fetch_assoc("select
 130 
       $graphs = db_fetch_assoc("select
131 
               graph_templates_graph.local_graph_id
 131 
               graph_templates_graph.local_graph_id
132 
               from graph_templates_graph,graph_local
 132 
               from (graph_templates_graph,graph_local)
133 
               left join host on host.id=graph_local.host_id
 133 
               left join host on host.id=graph_local.host_id
134 
               left join graph_templates on graph_templates.id=graph_local.graph_template_id
 134 
               left join graph_templates on graph_templates.id=graph_local.graph_template_id
135 
               left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=" . $_SESSION["sess_user_id"] . ") OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=" . $_SESSION["sess_user_id"] . ") OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=" . $_SESSION["sess_user_id"] . "))
 135 
               left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=" . $_SESSION["sess_user_id"] . ") OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=" . $_SESSION["sess_user_id"] . ") OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=" . $_SESSION["sess_user_id"] . "))
(-)cacti-0.8.6g_p20051023/lib/functions.php (-1 / +1 lines)
Lines 850-856 Link Here
850 
               graph_local.snmp_query_id,
 850 
               graph_local.snmp_query_id,
851 
               graph_local.snmp_index,
 851 
               graph_local.snmp_index,
852 
               graph_templates_graph.title
 852 
               graph_templates_graph.title
853 
               from graph_templates_graph,graph_local
 853 
               from (graph_templates_graph,graph_local)
854 
               where graph_templates_graph.local_graph_id=graph_local.id
 854 
               where graph_templates_graph.local_graph_id=graph_local.id
855 
               and graph_local.id=$local_graph_id");
 855 
               and graph_local.id=$local_graph_id");
(-)cacti-0.8.6g_p20051023/lib/html_tree.php (-2 / +2 lines)
Lines 569-575 Link Here
569 
                               $graphs = db_fetch_assoc("select
 569 
                               $graphs = db_fetch_assoc("select
570 
                                       graph_templates_graph.title_cache,
 570 
                                       graph_templates_graph.title_cache,
571 
                                       graph_templates_graph.local_graph_id
 571 
                                       graph_templates_graph.local_graph_id
572 
                                       from graph_local,graph_templates_graph
 572 
                                       from (graph_local,graph_templates_graph)
573 
                                       $sql_join
 573 
                                       $sql_join
574 
                                       where graph_local.id=graph_templates_graph.local_graph_id
 574 
                                       where graph_local.id=graph_templates_graph.local_graph_id
575 
                                       and graph_local.graph_template_id=" . $graph_template["id"] . "
 575 
                                       and graph_local.graph_template_id=" . $graph_template["id"] . "
Lines 614-620 Link Here
614 
                                       graph_templates_graph.title_cache,
 614 
                                       graph_templates_graph.title_cache,
615 
                                       graph_templates_graph.local_graph_id,
 615 
                                       graph_templates_graph.local_graph_id,
616 
                                       graph_local.snmp_index
 616 
                                       graph_local.snmp_index
617 
                                       from graph_local,graph_templates_graph
 617 
                                       from (graph_local,graph_templates_graph)
618 
                                       $sql_join
 618 
                                       $sql_join
619 
                                       where graph_local.id=graph_templates_graph.local_graph_id
 619 
                                       where graph_local.id=graph_templates_graph.local_graph_id
620 
                                       and graph_local.snmp_query_id=" . $data_query["id"] . "
 620 
                                       and graph_local.snmp_query_id=" . $data_query["id"] . "
(-)cacti-0.8.6g_p20051023/lib/rrd.php (-1 / +1 lines)
Lines 526-532 Link Here
526 
               graph_templates_graph.unit_value,
 526 
               graph_templates_graph.unit_value,
527 
               graph_templates_graph.unit_exponent_value,
 527 
               graph_templates_graph.unit_exponent_value,
528 
               graph_templates_graph.export
 528 
               graph_templates_graph.export
529 
               from graph_templates_graph,graph_local
 529 
               from (graph_templates_graph,graph_local)
530 
               where graph_local.id=graph_templates_graph.local_graph_id
 530 
               where graph_local.id=graph_templates_graph.local_graph_id
531 
               and graph_templates_graph.local_graph_id=$local_graph_id");
 531 
               and graph_templates_graph.local_graph_id=$local_graph_id");

Return to bug 113337