summary refs log tree commit diff stats
path: root/includes
diff options
context:
space:
mode:
authorStarla Insigna <hatkirby@fourisland.com>2009-08-17 15:25:11 -0400
committerStarla Insigna <hatkirby@fourisland.com>2009-08-17 15:25:11 -0400
commit49ff543541097a514cf8c836b74cd9514df2bf98 (patch)
treee745069597fa790a6399f48de653fbb6a55ff6f3 /includes
parent9491162a4ea231f1cdcd1531dc8d21e95878d0bc (diff)
downloadfourisland-49ff543541097a514cf8c836b74cd9514df2bf98.tar.gz
fourisland-49ff543541097a514cf8c836b74cd9514df2bf98.tar.bz2
fourisland-49ff543541097a514cf8c836b74cd9514df2bf98.zip
Databasified Affiliates and Website Projects
The following database changes must be made ASAP:

* Import the links.sql script into the database

Closes #114
Diffstat (limited to 'includes')
-rwxr-xr-xincludes/functions.php14
-rwxr-xr-xincludes/header.php20
2 files changed, 34 insertions, 0 deletions
diff --git a/includes/functions.php b/includes/functions.php index b0b28d5..ce7a03e 100755 --- a/includes/functions.php +++ b/includes/functions.php
@@ -357,4 +357,18 @@ function getPollOfTheWeek($id = -1)
357 return $result; 357 return $result;
358} 358}
359 359
360function getTagColor($i)
361{
362 switch ($i % 7)
363 {
364 case 0: return 'blue';
365 case 1: return 'green';
366 case 2: return 'orange';
367 case 3: return 'pink';
368 case 4: return 'purple';
369 case 5: return 'red';
370 case 6: return 'yellow';
371 }
372}
373
360?> 374?>
diff --git a/includes/header.php b/includes/header.php index ae39bad..3a8edff 100755 --- a/includes/header.php +++ b/includes/header.php
@@ -69,6 +69,26 @@ $headerTemp->add('DATEFINDER', sd_dateFinder());
69if ($usingIE) 69if ($usingIE)
70{ 70{
71 $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>'); 71 $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>');
72}
73
74$getaffs = "SELECT * FROM links WHERE type = \"affiliates\" ORDER BY id ASC";
75$getaffs2 = mysql_query($getaffs);
76$i=0;
77while ($getaffs3 = mysql_fetch_array($getaffs2))
78{
79 $headerTemp->adds_block('AFFILIATES', array( 'COLOR' => getTagColor($i++),
80 'TITLE' => $getaffs3['title'],
81 'URL' => $getaffs3['url']));
82}
83
84$getwebps = "SELECT * FROM links WHERE type = \"webprojs\" ORDER BY id ASC";
85$getwebps2 = mysql_query($getwebps);
86$i=0;
87while ($getwebps3 = mysql_fetch_array($getwebps2))
88{
89 $headerTemp->adds_block('WEBPROJS', array( 'COLOR' => getTagColor($i++),
90 'TITLE' => $getwebps3['title'],
91 'URL' => $getwebps3['url']));
72} 92}
73 93
74$headerTemp->display(); 94$headerTemp->display();