diff options
author | Sebastian Schmelzer | 2012-01-11 15:59:04 +0100 |
---|---|---|
committer | Sebastian Schmelzer | 2012-01-11 15:59:04 +0100 |
commit | ac7df5d8551cbacf60f9adc770783a710737fa90 (patch) | |
tree | 6d4823587c44e1e5551a191e6a86547b41a52320 /scripts | |
parent | fix stylecode output (diff) | |
download | pbs2-ac7df5d8551cbacf60f9adc770783a710737fa90.tar.gz pbs2-ac7df5d8551cbacf60f9adc770783a710737fa90.tar.xz pbs2-ac7df5d8551cbacf60f9adc770783a710737fa90.zip |
fix stupid checkstyle bugs .. once again..
Diffstat (limited to 'scripts')
-rw-r--r-- | scripts/dbContent.php | 76 | ||||
-rw-r--r-- | scripts/mysqlGraph.php | 10 |
2 files changed, 43 insertions, 43 deletions
diff --git a/scripts/dbContent.php b/scripts/dbContent.php index 28f28ec..09b2fa7 100644 --- a/scripts/dbContent.php +++ b/scripts/dbContent.php @@ -53,12 +53,12 @@ function getGroups() { global $format; $q = "SELECT groupID,title FROM pbs_group"; $groups = "subgraph cluster_0 {"; - $groups . = "label=Groups;"; + $groups .= "label=Groups;"; $result = mysql_query($q); while($data = mysql_fetch_array($result)) { - $groups . = sprintf($format['groupnode'] , "Group".$data['groupID']); + $groups .= sprintf($format['groupnode'] , "Group".$data['groupID']); } - $groups . = "}"; + $groups .= "}"; return $groups; } function recGroups($groupID, $level = 0, $data = '') { @@ -66,8 +66,8 @@ function recGroups($groupID, $level = 0, $data = '') { $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']); + $groups .= sprintf($format['groupgroup'], "Group".$groupID, "Group".$data['groupID']); + $groups .= recGroups($data['groupID']); } return $groups; } @@ -76,7 +76,7 @@ function getPersons() { $q = "SELECT personID,title FROM pbs_person"; $result = mysql_query($q); while($data = mysql_fetch_array($result)) { - $persons . = sprintf($format['personnode'] , "Person". $data['personID']); + $persons .= sprintf($format['personnode'] , "Person". $data['personID']); } return $persons; @@ -86,10 +86,10 @@ function getMemberships() { $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']); + $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; } @@ -98,7 +98,7 @@ function getRequests() { $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']); + $memberships .= sprintf($format['peronrequests'], "Group".$data['groupID'], "Person".$data['personID']); } return $memberships; } @@ -107,8 +107,8 @@ function getPools() { $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']); + $pools .= sprintf($format['poolnode'] , "Pool".$data['poolID']); + $pools .= sprintf($format['poolgroup'], "Pool".$data['poolID'], "Group".$data['groupID']); } return $pools; @@ -118,11 +118,11 @@ function getClients() { $q = "SELECT clientID,groupID FROM pbs_client"; $result = mysql_query($q); while($data = mysql_fetch_array($result)) { - $clients . = sprintf($format['clientnode'] , "Client".$data['clientID']); + $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']); } + { $clients .= sprintf($format['clientgroup'], "Client".$data['clientID'], "Group".$data['groupID']); } } return $clients; @@ -132,7 +132,7 @@ function clientPools() { $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']); + $clientpools .= sprintf($format['clientpool'], "Client".$data['clientID'], "Pool".$data['poolID']); } return $clientpools; } @@ -141,7 +141,7 @@ function getRoles() { $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 .= sprintf($format['rolenode'] , "Role".$data['roleID']); # $roles .= "Role".$data['roleID'] ." -> " . "Group".$data['groupID'].";\n"; } return $roles; @@ -151,8 +151,8 @@ function getBootiso() { $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']); + $bootiso .= sprintf($format['bootisonode'] , "BootIso".$data['bootisoID']); + $bootiso .= sprintf($format['bootisogroup'], "BootIso".$data['bootisoID'], "Group".$data['groupID']); } return $bootiso; @@ -162,8 +162,8 @@ function getBootMenus() { $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']); + $bootmenu .= sprintf($format['bootmenunode'] , "BootMenu".$data['bootmenuID']); + $bootmenu .= sprintf($format['bootmenugroup'], "BootMenu".$data['bootmenuID'], "Group".$data['groupID']); } return $bootmenu; } @@ -172,33 +172,33 @@ function getBootos() { $q = "SELECT bootosID,groupID FROM pbs_bootos"; $result = mysql_query($q); while($data = mysql_fetch_array($result)) { - $bootos . = sprintf($format['bootosnode'] , "BootOs".$data['bootosID']); + $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']); } + { $bootos .= sprintf($format['bootosbootmenu'], "BootOs".$data['bootosID'], "BootMenu".$data2['bootmenuID']); } } else - { $bootos . = sprintf($format['bootosgroup'], "BootOs".$data['bootosID'], "Group".$data['groupID']); } + { $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(); +$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(); @@ -207,8 +207,8 @@ $str = 'digraph x { ranksep=3; size="20,20"; overlap="0:true"'."\n"; -$str . = str_replace("\n", "\n\t", $defs); -$str . = "}"; +$str .= str_replace("\n", "\n\t", $defs); +$str .= "}"; echo "Write to file ...\n"; // Create the dot file diff --git a/scripts/mysqlGraph.php b/scripts/mysqlGraph.php index 18eb9f6..1074325 100644 --- a/scripts/mysqlGraph.php +++ b/scripts/mysqlGraph.php @@ -44,14 +44,14 @@ $str = 'digraph x { // get all table-fields foreach($tables as $tablename => $data) { - $str . = $tablename .' [label= "{'; + $str .= $tablename .' [label= "{'; $array = array(); $array[] = strtoupper($tablename); foreach($data as $d) { $array[] = "<".$d['Field'].">".$d['Field']; } - $str . = implode("|", $array); - $str . = '}",width=3];'.$b; + $str .= implode("|", $array); + $str .= '}",width=3];'.$b; } echo "Generate the Links ...\n"; @@ -64,7 +64,7 @@ foreach($tables as $tablename1 => $table1) { $f2 = $field2['Field']; if( $tablename1 != $tablename2 && $f1 == $f2 && strstr($f1, 'ID') && "pbs_".str_replace("ID", '', $f1) == $tablename1) { // Draw lines to tables - $str . = $tablename1 ." -> ".$tablename2.";".$b; + $str .= $tablename1 ." -> ".$tablename2.";".$b; // draw lines to table-items #$str .= $tablename1.":".$f1 ." -> ".$tablename2.":".$f2 .";".$b; } @@ -72,7 +72,7 @@ foreach($tables as $tablename1 => $table1) { } } } -$str . = "}"; +$str .= "}"; echo "Write to file ...\n"; // Create the dot file $fp = fopen("mysqlGraph.dot", "w"); |