summary refs log tree commit diff stats
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
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
-rw-r--r--admin/posts.php2
-rwxr-xr-xincludes/functions.php14
-rwxr-xr-xincludes/header.php20
-rw-r--r--theme/admin/header.tpl6
-rw-r--r--theme/header.tpl64
5 files changed, 55 insertions, 51 deletions
diff --git a/admin/posts.php b/admin/posts.php index ac5b612..605db30 100644 --- a/admin/posts.php +++ b/admin/posts.php
@@ -8,7 +8,7 @@
8 4::::4 4::::4 8 4::::4 4::::4
9 4::::4 4::::4 Written and maintained by Starla Insigna 9 4::::4 4::::4 Written and maintained by Starla Insigna
104::::444444::::444 104::::444444::::444
114::::::::::::::::4 admin/pages.php 114::::::::::::::::4 admin/posts.php
124444444444:::::444 124444444444:::::444
13 4::::4 Please do not use, reproduce or steal the 13 4::::4 Please do not use, reproduce or steal the
14 4::::4 contents of this file without explicit 14 4::::4 contents of this file without explicit
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();
diff --git a/theme/admin/header.tpl b/theme/admin/header.tpl index bfc1dd4..62beb89 100644 --- a/theme/admin/header.tpl +++ b/theme/admin/header.tpl
@@ -24,6 +24,7 @@
24 <li><a href="/admin/posts.php"<!--POSTSACTIVECAT-->>POSTS</a></li> 24 <li><a href="/admin/posts.php"<!--POSTSACTIVECAT-->>POSTS</a></li>
25 <li><a href="/admin/polls.php"<!--POLLSACTIVECAT-->>POLLS</a></li> 25 <li><a href="/admin/polls.php"<!--POLLSACTIVECAT-->>POLLS</a></li>
26 <li><a href="/admin/quotes.php"<!--QUOTESACTIVECAT-->>QUOTES</a></li> 26 <li><a href="/admin/quotes.php"<!--QUOTESACTIVECAT-->>QUOTES</a></li>
27 <li><a href="/admin/links.php"<!--LINKSACTIVECAT-->>LINKS</a></li>
27 <li class="logout"><a href="/">FOUR ISLAND</a></li> 28 <li class="logout"><a href="/">FOUR ISLAND</a></li>
28 </ul> 29 </ul>
29 30
@@ -51,6 +52,11 @@
51 <li><a href="/admin/modquotes.php"<!--MODQUOTESACTIVE-->>Moderate Quotes</a></li> 52 <li><a href="/admin/modquotes.php"<!--MODQUOTESACTIVE-->>Moderate Quotes</a></li>
52 <li><a href="/admin/quotes.php?flagged="<!--FLAGGEDACTIVE-->>Manage Flagged Quotes</a></li> 53 <li><a href="/admin/quotes.php?flagged="<!--FLAGGEDACTIVE-->>Manage Flagged Quotes</a></li>
53 <!--END QUOTESISACTIVECAT--> 54 <!--END QUOTESISACTIVECAT-->
55 <!--BEGIN LINKSISACTIVECAT-->
56 <li><a href="/admin/newLink.php"<!--NEWLINKACTIVE-->>Add a new link</a></li>
57 <li><a href="/admin/links.php"<!--AFFILIATESACTIVE-->>Manage Affiliates</a></li>
58 <li><a href="/admin/links.php?type=webprojs"<!--WEBPROJSACTIVE-->>Manage Website Projects</a></li>
59 <!--END LINKSISACTIVECAT-->
54 </ul> 60 </ul>
55 </div> 61 </div>
56 62
diff --git a/theme/header.tpl b/theme/header.tpl index 24c9b6b..896ded5 100644 --- a/theme/header.tpl +++ b/theme/header.tpl
@@ -63,62 +63,26 @@
63 <div class="module rounded sidebar"> 63 <div class="module rounded sidebar">
64 <h3>Affiliates</h3> 64 <h3>Affiliates</h3>
65 65
66 <ul> 66 <ul>
67 <li> 67 <!--BEGIN AFFILIATES-->
68 <img src="/theme/images/icons/tag_blue.png" alt="The S Site" /> 68 <li>
69 <a href="http://ssite.fourisland.com/">The S Site</a> 69 <img src="/theme/images/icons/tag_<!--AFFILIATES.COLOR-->.png" alt="<!--AFFILIATES.TITLE-->" />
70 </li> 70 <a href="<!--AFFILIATES.URL-->"><!--AFFILIATES.TITLE--></a>
71 71 </li>
72 <li> 72 <!--END AFFILIATES-->
73 <img src="/theme/images/icons/tag_green.png" alt="Wikipinia" />
74 <a href="http://nablecak.fourisland.com/">Wikipinia</a>
75 </li>
76
77 <li>
78 <img src="/theme/images/icons/tag_orange.png" alt="Color Pencils" />
79 <a href="http://gryph.fourisland.com/">Color Pencils</a>
80 </li>
81
82 <li>
83 <img src="/theme/images/icons/tag_pink.png" alt="Dream Weaver" />
84 <a href="http://timbo94.fourisland.com/">Dream Weaver</a>
85 </li>
86
87 <li>
88 <img src="/theme/images/icons/tag_purple.png" alt="Randomness" />
89 <a href="http://pyro.fourisland.com/">Randomness</a>
90 </li>
91
92 <li>
93 <img src="/theme/images/icons/tag_red.png" alt="Bubble Blog" />
94 <a href="http://sammi9494.fourisland.com/">Bubble Blog</a>
95 </li>
96 </ul> 73 </ul>
97 </div> 74 </div>
98 75
99 <div class="module rounded sidebar"> 76 <div class="module rounded sidebar">
100 <h3>Website Projects</h3> 77 <h3>Website Projects</h3>
101 78
102 <ul> 79 <ul>
103 <li> 80 <!--BEGIN WEBPROJS-->
104 <img src="/theme/images/icons/tag_blue.png" alt="The Sabrina FanWiki" /> 81 <li>
105 <a href="http://sabrina.fourisland.com/">The Sabrina FanWiki</a> 82 <img src="/theme/images/icons/tag_<!--WEBPROJS.COLOR-->.png" alt="<!--WEBPROJS.TITLE-->" />
106 </li> 83 <a href="<!--WEBPROJS.URL-->"><!--WEBPROJS.TITLE--></a>
107 84 </li>
108 <li> 85 <!--END WEBPROJS-->
109 <img src="/theme/images/icons/tag_green.png" alt="True Falsities" />
110 <a href="http://false.fourisland.com/">True Falsities</a>
111 </li>
112
113 <li>
114 <img src="/theme/images/icons/tag_orange.png" alt="Pillowcase" />
115 <a href="http://pillowcase.fourisland.com/">Pillowcase</a>
116 </li>
117
118 <li>
119 <img src="/theme/images/icons/tag_pink.png" alt="Endlenge" />
120 <a href="http://endlenge.fourisland.com/">Endlenge</a>
121 </li>
122 </ul> 86 </ul>
123 </div> 87 </div>
124 88