added soundcards - part 2

7 files changed, 37 insertions, 1 deletions

diff --git a/h-source/Application/Controllers/DownloadController.php b/h-source/Application/Controllers/DownloadController.php
index 2015ce7..c3a9661 100644
--- a/h-source/Application/Controllers/DownloadController.php
+++ b/h-source/Application/Controllers/DownloadController.php
@@ -107,6 +107,11 @@ class DownloadController extends BaseController
 				$xml .= "\t\t<it_works>".$row['hardware']['wifi_works']."</it_works>\n";
 			}
 			
+			if ($type === 'soundcard')
+			{
+				$xml .= "\t\t<it_works>".$row['hardware']['sound_card_works']."</it_works>\n";
+			}
+			
 			if ($type === 'notebook' or $type === 'videocard')
 			{
 				$xml .= "\t\t<videocard_works>".$row['hardware']['video_card_works']."</videocard_works>\n";
@@ -117,7 +122,7 @@ class DownloadController extends BaseController
 				$xml .= "\t\t<webcam_works>".$row['hardware']['webcam_works']."</webcam_works>\n";
 			}
 			
-			if ($type === 'printer' or $type === 'scanner')
+			if ($type === 'printer' or $type === 'scanner' or $type === 'soundcard')
 			{
 				$xml .= "\t\t<driver>".$row['hardware']['driver']."</driver>\n";
 			}
@@ -224,4 +229,17 @@ class DownloadController extends BaseController
 		$this->clean();
 		$this->load('xml');
 	}
+	
+	public function soundcards($lang = 'en')
+	{
+		header ("Content-Type:text/xml");
+
+		$res = $this->m['HardwareModel']->clear()->select()->where(array('type'=>'soundcard','-deleted'=>'no'))->orderBy("type,hardware.id_hard")->send();
+
+		$data['xml'] = $this->getXml($res);
+		
+		$this->append($data);
+		$this->clean();
+		$this->load('xml');
+	}
 }
\ No newline at end of file
diff --git a/h-source/Application/Include/hardware.php b/h-source/Application/Include/hardware.php
index e0919a9..9879d14 100644
--- a/h-source/Application/Include/hardware.php
+++ b/h-source/Application/Include/hardware.php
@@ -314,6 +314,7 @@ class Soundcards extends Hardware
 		"National Semiconductor Corporation"	=>	"National-Semiconductor-Corporation",
 		"Neomagic Corp"	=>	"Neomagic-Corp",
 		"nVidia Corporation"	=>	"nVidia-Corporation",
+		"Realtek"	=>	"Realtek",
 		"RME"	=>	"RME",
 		"S3 Inc"	=>	"S3-Inc",
 		"Silicon Integrated Systems (SiS)"	=>	"Silicon-Integrated-Systems",
diff --git a/h-source/Application/Views/Download/index.php b/h-source/Application/Views/Download/index.php
index dc937d6..c13e0b3 100644
--- a/h-source/Application/Views/Download/index.php
+++ b/h-source/Application/Views/Download/index.php
@@ -65,6 +65,10 @@
 							<td>Download the xml file of all the <b>3G cards</b> in the database</td>
 							<td><a href="<?php echo $this->baseUrl."/download/threegcards/$lang";?>"><img src="<?php echo $this->baseUrl?>/Public/Img/H2O/download.png"></a></td>
 						</tr>
+						<tr>
+							<td>Download the xml file of all the <b>soundcards</b> in the database</td>
+							<td><a href="<?php echo $this->baseUrl."/download/soundcards/$lang";?>"><img src="<?php echo $this->baseUrl?>/Public/Img/H2O/download.png"></a></td>
+						</tr>
 					</table>
 				</div>
 			</div>
diff --git a/h-source/Application/Views/Download/index_es.php b/h-source/Application/Views/Download/index_es.php
index 4aa3439..10051a4 100644
--- a/h-source/Application/Views/Download/index_es.php
+++ b/h-source/Application/Views/Download/index_es.php
@@ -65,6 +65,10 @@
 							<td>Download the xml file of all the <b>3G cards</b> in the database</td>
 							<td><a href="<?php echo $this->baseUrl."/download/threegcards/$lang";?>"><img src="<?php echo $this->baseUrl?>/Public/Img/H2O/download.png"></a></td>
 						</tr>
+						<tr>
+							<td>Download the xml file of all the <b>soundcards</b> in the database</td>
+							<td><a href="<?php echo $this->baseUrl."/download/soundcards/$lang";?>"><img src="<?php echo $this->baseUrl?>/Public/Img/H2O/download.png"></a></td>
+						</tr>
 					</table>
 				</div>
 			</div>
diff --git a/h-source/Application/Views/Download/index_fr.php b/h-source/Application/Views/Download/index_fr.php
index 1e4fa2f..d178a6a 100644
--- a/h-source/Application/Views/Download/index_fr.php
+++ b/h-source/Application/Views/Download/index_fr.php
@@ -65,6 +65,10 @@
 							<td>Download the xml file of all the <b>3G cards</b> in the database</td>
 							<td><a href="<?php echo $this->baseUrl."/download/threegcards/$lang";?>"><img src="<?php echo $this->baseUrl?>/Public/Img/H2O/download.png"></a></td>
 						</tr>
+						<tr>
+							<td>Download the xml file of all the <b>soundcards</b> in the database</td>
+							<td><a href="<?php echo $this->baseUrl."/download/soundcards/$lang";?>"><img src="<?php echo $this->baseUrl?>/Public/Img/H2O/download.png"></a></td>
+						</tr>
 					</table>
 				</div>
 			</div>
diff --git a/h-source/Application/Views/Download/index_it.php b/h-source/Application/Views/Download/index_it.php
index 137d067..1428202 100644
--- a/h-source/Application/Views/Download/index_it.php
+++ b/h-source/Application/Views/Download/index_it.php
@@ -65,6 +65,10 @@
 							<td>Scarica il file xml di tutte le schede <b>3G cards</b> del database</td>
 							<td><a href="<?php echo $this->baseUrl."/download/threegcards/$lang";?>"><img src="<?php echo $this->baseUrl?>/Public/Img/H2O/download.png"></a></td>
 						</tr>
+						<tr>
+							<td>Scarica il file xml di tutte le schede <b>audio</b> del database</td>
+							<td><a href="<?php echo $this->baseUrl."/download/soundcards/$lang";?>"><img src="<?php echo $this->baseUrl?>/Public/Img/H2O/download.png"></a></td>
+						</tr>
 					</table>
 				</div>
 			</div>
diff --git a/h-source/Config/Route.php b/h-source/Config/Route.php
index bf3dd1b..1a3161a 100644
--- a/h-source/Config/Route.php
+++ b/h-source/Config/Route.php
@@ -95,6 +95,7 @@ class Route
 		'download,printers',
 		'download,scanners',
 		'download,threegcards',
+		'download,soundcards',
 		'history,hide',
 		'history,show',
 		'history,block',