Changeset 55 for trunk/Modules/Dance/Dance.php
- Timestamp:
- Apr 7, 2020, 12:55:39 AM (5 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/Modules/Dance/Dance.php
r40 r55 39 39 $this->Title = 'Tanec - Tance - '.$this->Title; 40 40 $Output = ''; 41 if (count($this->System->PathItems) > 1)41 if (count($this->System->PathItems) > 1) 42 42 { 43 43 $id = $this->System->PathItems[1] * 1; … … 60 60 $Output .= '<tr><th>Český název</th><th>Anglický název</th><th>Detail</th></tr>'; 61 61 $DbResult = $this->Database->select('DanceFigure', '*', '(`Dance`='.$id.')'); 62 while ($DanceFigure = $DbResult->fetch_assoc())62 while ($DanceFigure = $DbResult->fetch_assoc()) 63 63 { 64 64 $Output .= '<tr>'. … … 74 74 $Output .= '<tr><th>Název</th><th>Skupina</th><th>Odkaz</th></tr>'; 75 75 $DbResult = $this->Database->select('Resource', '*, (SELECT Name FROM ResourceGroup WHERE ResourceGroup.Id=Resource.Group) AS GroupName', '(`Dance`='.$id.')'); 76 while ($DbRow = $DbResult->fetch_assoc())76 while ($DbRow = $DbResult->fetch_assoc()) 77 77 { 78 78 $Output .= '<tr>'. … … 86 86 /* 87 87 $DbResult2 = $this->Database->select('ResourceGroup', '*'); 88 while ($ResourceGroup = $DbResult2->fetch_assoc())88 while ($ResourceGroup = $DbResult2->fetch_assoc()) 89 89 { 90 90 $Output .= '<th>'.$ResourceGroup['Name'].'</th>'; … … 92 92 93 93 $DbResult2 = $this->Database->select('ResourceGroup', '*'); 94 while ($ResourceGroup = $DbResult2->fetch_assoc())94 while ($ResourceGroup = $DbResult2->fetch_assoc()) 95 95 { 96 96 $Output .= '<td>'; 97 while ($Resource = $DbResult3->fetch_assoc())97 while ($Resource = $DbResult3->fetch_assoc()) 98 98 { 99 99 $Output .= '<a href="'.$Resource['URL'].'">'.$Resource['Name'].'</a> '; … … 122 122 $Output .= '<tr><th>Název</th><th>Skupina</th><th>Detail</th></tr>'; 123 123 $DbResult = $this->Database->select('Dance', '*, (SELECT Name FROM DanceGroup WHERE DanceGroup.Id=Dance.Group) AS GroupName', '1 ORDER BY `Name`'); 124 while ($Dance = $DbResult->fetch_assoc())124 while ($Dance = $DbResult->fetch_assoc()) 125 125 { 126 126 $Output .= '<tr>'. … … 132 132 $Output .= '</table>'; 133 133 134 return ($Output);134 return $Output; 135 135 } 136 136 } … … 149 149 $this->Title = 'Taneční figura - Tance - '.$this->Title; 150 150 $Output = ''; 151 if (count($this->System->PathItems) > 1)151 if (count($this->System->PathItems) > 1) 152 152 { 153 153 $id = $this->System->PathItems[1] * 1; … … 169 169 $Output .= '<tr><th>Skupina videí</th><th></th><th>Detail</th></tr>'; 170 170 $DbResult = $this->Database->select('DanceFigure', '*', '(`Dance`='.$id.')'); 171 while ($DanceFigure = $DbResult->fetch_assoc())171 while ($DanceFigure = $DbResult->fetch_assoc()) 172 172 { 173 173 $Output .= '<tr>'. … … 181 181 /* 182 182 $DbResult2 = $this->Database->select('ResourceGroup', '*'); 183 while ($ResourceGroup = $DbResult2->fetch_assoc())183 while ($ResourceGroup = $DbResult2->fetch_assoc()) 184 184 { 185 185 $Output .= '<th>'.$ResourceGroup['Name'].'</th>'; … … 187 187 188 188 $DbResult2 = $this->Database->select('ResourceGroup', '*'); 189 while ($ResourceGroup = $DbResult2->fetch_assoc())189 while ($ResourceGroup = $DbResult2->fetch_assoc()) 190 190 { 191 191 $Output .= '<td>'; 192 while ($Resource = $DbResult3->fetch_assoc())192 while ($Resource = $DbResult3->fetch_assoc()) 193 193 { 194 194 $Output .= '<a href="'.$Resource['URL'].'">'.$Resource['Name'].'</a> '; … … 217 217 $Output .= '<tr><th>Název</th><th>Skupina</th><th>Tanec</th><th>Detail</th></tr>'; 218 218 $DbResult = $this->Database->select('DanceFigure', '*, (SELECT Dance.Name FROM Dance WHERE Dance.Id=DanceFigure.Dance) AS DanceName', '1 ORDER BY `NameCz`'); 219 while ($DbRow = $DbResult->fetch_assoc())219 while ($DbRow = $DbResult->fetch_assoc()) 220 220 { 221 221 $Output .= '<tr>'. … … 228 228 $Output .= '</table>'; 229 229 230 return ($Output);231 } 232 } 230 return $Output; 231 } 232 }
Note:
See TracChangeset
for help on using the changeset viewer.