summaryrefslogtreecommitdiffstats
path: root/scripts
diff options
context:
space:
mode:
authorSebastian Schmelzer2012-01-11 15:59:04 +0100
committerSebastian Schmelzer2012-01-11 15:59:04 +0100
commitac7df5d8551cbacf60f9adc770783a710737fa90 (patch)
tree6d4823587c44e1e5551a191e6a86547b41a52320 /scripts
parentfix stylecode output (diff)
downloadpbs2-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.php76
-rw-r--r--scripts/mysqlGraph.php10
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");