Aufgeräumt und verschoben

1 files changed, 224 insertions, 0 deletions

diff --git a/scripts/dbContent.php b/scripts/dbContent.php
new file mode 100644
index 0000000..a704ec2
--- /dev/null
+++ b/scripts/dbContent.php
@@ -0,0 +1,224 @@
+<?php
+/*
+ * Copyright (c) 2011 - OpenSLX GmbH, RZ Uni Freiburg
+ * This program is free software distributed under the GPL version 2.
+ * See http://gpl.openslx.org/
+ *
+ * If you have any feedback please consult http://feedback.openslx.org/ and
+ * send your suggestions, praise, or complaints to feedback@openslx.org
+ *
+ * General information about OpenSLX can be found at http://openslx.org/
+ */
+// generate mysql graph
+$name = substr(str_replace("/","",$_SERVER['SCRIPT_NAME']),0,-4);
+$dotname = $name . '.dot';
+$pngname = $name . '.png';
+
+echo "Opening Database Connection...\n";
+$link = mysql_connect('localhost', 'root', '123456');
+if (!$link) {
+    die('keine Verbindung möglich: ' . mysql_error());
+}
+mysql_select_db('pbs');
+error_reporting(1);
+ 
+ 
+$format['groupnode'] 	= '"%s" [shape=trapezium, fontcolor="#ffffffff", style=filled, fillcolor="#004A99FF"];'."\n";
+$format['personnode'] 	= '"%s" [shape=ellipse, fontcolor="#ffffffff", style=filled, fillcolor="#FF0000FF"];'."\n";
+$format['poolnode'] 	= '"%s" [shape=ellipse, fontcolor="#000000ff", style=filled, fillcolor="#00FF00FF"];'."\n";
+$format['membershipnode'] = '"%s" [shape=ellipse, fontcolor="#ffffffff", style=filled, fillcolor="#990000FF"];'."\n";
+$format['clientnode'] 	= '"%s" [shape=ellipse, fontcolor="#000000ff", style=filled, fillcolor="#FFFF00FF"];'."\n";
+$format['rolenode'] 	= '"%s" [fontcolor="#000000ff", style=filled, fillcolor="#FF0099FF"];'."\n";
+$format['bootmenunode'] = '"%s" [shape=ellipse, fontcolor="#000000ff", style=filled, fillcolor="#009999FF"];'."\n";
+$format['bootisonode'] 	= '"%s" [shape=ellipse, fontcolor="#000000ff", style=filled, fillcolor="#FF9900FF"];'."\n";
+$format['bootosnode']	= '"%s" [fontcolor="#000000ff", style=filled, fillcolor="#99FF99FF"];'."\n";
+
+$format['groupgroup'] 		= '"%s" -> "%s";'."\n";               
+$format['personmember'] 	= '"%s" -> "%s";'."\n";   
+$format['rolemember'] 		= '"%s" -> "%s";'."\n";   
+$format['membergroup'] 		= '"%s" -> "%s";'."\n";   
+$format['personrequest'] 	= '"%s" -> "%s" [style=dotted];'."\n";   
+$format['poolgroup'] 		= '"%s" -> "%s";'."\n";   
+$format['clientgroup'] 		= '"%s" -> "%s";'."\n";
+$format['clientpool'] 		= '"%s" -> "%s";'."\n";
+$format['bootisogroup'] 	= '"%s" -> "%s";'."\n";
+$format['bootmenugroup'] 	= '"%s" -> "%s";'."\n";
+$format['bootosbootmenu'] 	= '"%s" -> "%s";'."\n";
+$format['bootosgroup'] 		= '"%s" -> "%s";'."\n";
+
+
+
+
+function getGroups(){
+    global $format;
+    $q = "SELECT groupID,title FROM pbs_group";
+    $groups = "subgraph cluster_0 {";
+    $groups .= "label=Groups;";
+    $result = mysql_query($q);
+    while($data = mysql_fetch_array($result)){
+        $groups .= sprintf($format['groupnode'] ,"Group".$data['groupID']);
+    }
+    $groups .= "}";
+    return $groups;
+}
+function recGroups($groupID,$level=0,$data=''){
+    global $format;
+    $q = "SELECT groupID FROM pbs_groupgroups WHERE parentID = $groupID";
+    $result = mysql_query($q);
+    while($data = mysql_fetch_array($result)){
+        $groups .= sprintf($format['groupgroup'],"Group".$groupID, "Group".$data['groupID']);
+        $groups .= recGroups($data['groupID']);
+    }
+    return $groups;
+}
+function getPersons(){
+    global $format;
+    $q = "SELECT personID,title FROM pbs_person";
+    $result = mysql_query($q);
+    while($data = mysql_fetch_array($result)){
+        $persons .= sprintf($format['personnode'] ,"Person". $data['personID']);
+       
+    }
+    return $persons;
+}
+function getMemberships(){
+    global $format;
+    $q = "SELECT personID,groupID,membershipID,roleID FROM pbs_membership";
+    $result = mysql_query($q);
+    while($data = mysql_fetch_array($result)){
+        $memberships .= sprintf($format['membershipnode'],"Member".$data['membershipID']);        
+        $memberships .= sprintf($format['personmember'],"Person".$data['personID'],"Member".$data['membershipID']);
+        $memberships .= sprintf($format['rolemember'],"Role".$data['roleID'], "Member".$data['membershipID']);
+        $memberships .= sprintf($format['membergroup'],"Member".$data['membershipID'], "Group".$data['groupID']);
+    }
+    return $memberships;
+}
+function getRequests(){
+    global $format;
+    $q = "SELECT personID,groupID FROM pbs_grouprequest";
+    $result = mysql_query($q);
+    while($data = mysql_fetch_array($result)){
+    	$memberships .= sprintf($format['peronrequests'],"Group".$data['groupID'], "Person".$data['personID']);  
+    }
+    return $memberships;
+}
+function getPools(){
+    global $format;
+    $q = "SELECT poolID,groupID FROM pbs_pool";
+    $result = mysql_query($q);
+    while($data = mysql_fetch_array($result)){
+        $pools .= sprintf($format['poolnode'] ,"Pool".$data['poolID']);
+        $pools .= sprintf($format['poolgroup'],"Pool".$data['poolID'], "Group".$data['groupID']);
+        
+    }   
+    return $pools;
+}
+function getClients(){
+    global $format;
+    $q = "SELECT clientID,groupID FROM pbs_client";
+    $result = mysql_query($q);   
+    while($data = mysql_fetch_array($result)){
+        $clients .= sprintf($format['clientnode'] ,"Client".$data['clientID']);       
+        $query2 = "SELECT clientID, poolID FROM pbs_poolentries WHERE clientID = '".$data['clientID']."'";
+        $result2 = mysql_query($query2);
+        if(mysql_num_rows($result2) == 0)
+            $clients .= sprintf($format['clientgroup'],"Client".$data['clientID'], "Group".$data['groupID']);
+    }
+   
+    return $clients;
+}
+function clientPools(){
+    global $format;
+    $q = "SELECT clientID,poolID FROM pbs_poolentries";
+    $result = mysql_query($q);
+    while($data = mysql_fetch_array($result)){
+        $clientpools .= sprintf($format['clientpool'],"Client".$data['clientID'], "Pool".$data['poolID']);
+    }
+    return $clientpools;
+}
+function getRoles(){
+    global $format;
+    $q = "SELECT roleID,groupID FROM pbs_role";
+    $result = mysql_query($q);
+    while($data = mysql_fetch_array($result)){
+        $roles .= sprintf($format['rolenode'] ,"Role".$data['roleID']);
+        # $roles .= "Role".$data['roleID'] ." -> " . "Group".$data['groupID'].";\n";   
+    }
+    return $roles;
+}
+function getBootiso(){
+    global $format;
+    $q = "SELECT bootisoID,groupID FROM pbs_bootiso";
+    $result = mysql_query($q);
+    while($data = mysql_fetch_array($result)){
+        $bootiso .= sprintf($format['bootisonode'] ,"BootIso".$data['bootisoID']);
+		$bootiso .= sprintf($format['bootisogroup'],"BootIso".$data['bootisoID'], "Group".$data['groupID']);
+       
+    }
+    return $bootiso;
+}
+function getBootMenus(){
+    global $format;
+    $q = "SELECT bootmenuID,groupID FROM pbs_bootmenu";
+    $result = mysql_query($q);
+    while($data = mysql_fetch_array($result)){
+        $bootmenu .= sprintf($format['bootmenunode'] ,"BootMenu".$data['bootmenuID']);
+        $bootmenu .= sprintf($format['bootmenugroup'],"BootMenu".$data['bootmenuID'], "Group".$data['groupID']);
+    }
+    return $bootmenu;
+}
+function getBootos(){
+    global $format;
+    $q = "SELECT bootosID,groupID FROM pbs_bootos";
+    $result = mysql_query($q);
+    while($data = mysql_fetch_array($result)){
+        $bootos .= sprintf($format['bootosnode'] ,"BootOs".$data['bootosID']);
+       
+        $q2 = "SELECT * FROM pbs_bootmenuentries WHERE bootosID = ".$data['bootosID']."";
+        $result2 = mysql_query($q2);
+        if(mysql_num_rows($result2)){
+            while($data2 = mysql_fetch_array($result2))
+                $bootos .= sprintf($format['bootosbootmenu'],"BootOs".$data['bootosID'], "BootMenu".$data2['bootmenuID']);
+        }
+        else
+            $bootos .= sprintf($format['bootosgroup'],"BootOs".$data['bootosID'], "Group".$data['groupID']);
+    }
+    return $bootos;
+}
+ 
+## Concatenation
+$defs = '';
+$defs .= getGroups();
+$defs .= recGroups(1);
+$defs .= getPersons();
+$defs .= getMemberships();
+$defs .= getRoles();
+$defs .= getRequests();
+$defs .= getPools();
+$defs .= getClients();
+$defs .= clientPools();
+$defs .= getBootiso();
+$defs .= getBootMenus();
+$defs .= getBootos();
+ 
+ 
+ 
+$str = 'digraph x {
+    node [];
+    ranksep=3;
+    size="20,20";
+    overlap="0:true"'."\n";
+$str .= str_replace("\n","\n\t",$defs);
+$str .= "}";
+ 
+echo "Write to file ...\n";
+// Create the dot file
+$fp = fopen($dotname, "w");
+fputs ($fp, $str);
+fclose ($fp);
+// Generate the image
+echo "Generate the image ...\n";
+exec("dot -Tpng $dotname >$pngname");
+// delete the dot file
+unlink ($dotname);
+echo "Ready!\n";