Difference between revisions of "Active Directory/Software Packages"
| Line 25: | Line 25: | ||
or die("Unable to connect to database server"); | or die("Unable to connect to database server"); | ||
// Select Table | // Select Table | ||
| + | /* | ||
@mysql_select_db($database) | @mysql_select_db($database) | ||
or die("Unable to select database"); | or die("Unable to select database"); | ||
| Line 47: | Line 48: | ||
// Free resultset | // Free resultset | ||
mysql_free_result($result); | mysql_free_result($result); | ||
| + | */ | ||
| + | $i = 0; | ||
| + | echo '<table width="100%"><thead><th>Name</th><th>Version</th><th>Date</th><th>Replication</th></tr></thead><tbody>'; | ||
| + | $getSW = mysql_query("SELECT owner, sw_type, vendor, name, version, other, replication FROM wolftech_myit.log_sw_groups WHERE owner=replication ORDER BY vendor, name, version, other"); | ||
| + | while ($a = mysql_fetch_row($getSW)){ | ||
| + | if ($lastVendor != $a[2]) | ||
| + | echo '<tr style="background-color: #000000; color: #FFFFFF"><td colspan="4">', $a[2], '</td></tr>'; | ||
| + | |||
| + | echo '<tr style="background-color: ', ($i ^= 1) ? '#E7E7E7' : '#F8F8F8' ,'"><td>', $a[3], '</td><td>', $a[4], '</td><td>', $a[5], '</td><td>', $a[1], '/', $a[6], '</td></tr>'; | ||
| + | |||
| + | $lastVendor = $a[2]; | ||
| + | } | ||
| + | echo '</tbody></table>'; | ||
| + | mysql_free_result($getSW); | ||
</php> | </php> | ||
Revision as of 14:22, 7 July 2010
The WOLTECH domain was designed to ease, automate, and monitor the distribution of software to computers. We have an extensive list of software that has been packaged and configured for distribution via the domain, and new packages are being added every day.
Available Packages
The following software products are packaged and available for automatic distribution over the network. To request that software be installed on your computer, please email ecehelp@ncsu.edu.
Once we have configured the software to install on your computer, you can simply reboot and the software will be installed during Windows bootup.
Notes:
- Many software packages have additional license restrictions not listed in the table.
- Software packages that are only available for manual installation are not listed here.
<php> // define ('INCLUDES',"../_include/"); require_once(INCLUDES . "myit/functions.inc.php"); $server = $DB["server"]; $username = $DB["read-un"]; $password = $DB["read-pw"]; $database = $DB["database"]; $table = "packaged_software"; // Connect $link = mysql_connect($server, $username, $password) or die("Unable to connect to database server"); // Select Table /* @mysql_select_db($database) or die("Unable to select database");
echo "<HTML>\n<HEAD>\n\t<title>$title</title>\n</HEAD>\n<BODY>\n"; $query = "SELECT vendor,title,version,licensor,notes FROM $table " . "ORDER BY vendor, title, version"; $result = mysql_query($query) or die("Query failed! $result");
echo "
\n"; echo "\t\n";while ( $line = mysql_fetch_array($result, MYSQL_ASSOC) ) {
if($count++ % 2 == 0) echo "\t\n"; else echo "\t\n"; foreach ($line as $col_value) { echo "\t\t\n";}echo "\t\n"; } echo "
| Vendor | Title | Version | Licensor | Notes |
|---|---|---|---|---|
| $col_value |
\n";
echo "</BODY>\n</HTML>"; // Free resultset mysql_free_result($result);
- /
$i = 0;
echo '
<thead></thead><tbody>';$getSW = mysql_query("SELECT owner, sw_type, vendor, name, version, other, replication FROM wolftech_myit.log_sw_groups WHERE owner=replication ORDER BY vendor, name, version, other"); while ($a = mysql_fetch_row($getSW)){ if ($lastVendor != $a[2])
echo ''; echo '';$lastVendor = $a[2]; }
echo '</tbody>| Name | Version | Date | Replication |
|---|---|---|---|
| ', $a[2], ' | |||
| ', $a[3], ' | ', $a[4], ' | ', $a[5], ' | ', $a[1], '/', $a[6], ' |
';
mysql_free_result($getSW); </php>