Databasified Affiliates and Website Projects

The following database changes must be made ASAP:

* Import the links.sql script into the database

Closes #114

2 files changed, 34 insertions, 0 deletions

@@ -357,4 +357,18 @@ function getPollOfTheWeek($id = -1)
         return $result;
 }
 
+function getTagColor($i)
+{
+        switch ($i % 7)
+        {
+                case 0: return 'blue';
+                case 1: return 'green';
+                case 2: return 'orange';
+                case 3: return 'pink';
+                case 4: return 'purple';
+                case 5: return 'red';
+                case 6: return 'yellow';
+        }
+}
+
 ?>
@@ -69,6 +69,26 @@ $headerTemp->add('DATEFINDER', sd_dateFinder());
 if ($usingIE)

 {

         $headerTemp->add('FLASH', 'It appears you are using Internet Explorer. Four Island is not likely to work properly in IE due to a <a href="http://www.webdevout.net/articles/beware-of-xhtml#ie">huge bug</a> in it. <a href="http://getfirefox.com/">There are better browsers out there, why not try one?</a>');

+}
+
+$getaffs = "SELECT * FROM links WHERE type = \"affiliates\" ORDER BY id ASC";
+$getaffs2 = mysql_query($getaffs);
+$i=0;
+while ($getaffs3 = mysql_fetch_array($getaffs2))
+{
+        $headerTemp->adds_block('AFFILIATES', array(    'COLOR' => getTagColor($i++),
+                                                        'TITLE' => $getaffs3['title'],
+                                                        'URL' => $getaffs3['url']));
+}
+
+$getwebps = "SELECT * FROM links WHERE type = \"webprojs\" ORDER BY id ASC";
+$getwebps2 = mysql_query($getwebps);
+$i=0;
+while ($getwebps3 = mysql_fetch_array($getwebps2))
+{
+        $headerTemp->adds_block('WEBPROJS', array(      'COLOR' => getTagColor($i++),
+                                                        'TITLE' => $getwebps3['title'],
+                                                        'URL' => $getwebps3['url']));
 }

 

 $headerTemp->display();