Info['theme']); $color1="#{$theme[1]}"; ?>
"; include "/home/ac/public_html/theme/{$theme[0]}.html"; ?>
ALERTS:
Below is a complete list of your alerts for the past (3) three week in case you missed an update you were looking for.
UPDATE HISTORY
query("SELECT * FROM anime_updates ORDER BY id DESC LIMIT 1" ); $ac_anime2 = $Db->query("SELECT * FROM anime_fansub_updates ORDER BY id DESC LIMIT 1" ); $ac_anime3 = $Db->query("SELECT * FROM anime_other_updates ORDER BY id DESC LIMIT 1" ); // Marko: I've merged the queries, and changed while to use the new result set $ac_anime_big_query = "SELECT * FROM ((SELECT `update`, `timestamp`, `url`, anime_id FROM anime_updates) UNION (SELECT `update`, `timestamp`, `url`, anime_id FROM anime_fansub_updates) UNION (SELECT `update`, `timestamp`, `url`, anime_id FROM anime_other_updates)) ups LEFT JOIN `ac_anime` ON ups.anime_id = `ac_anime`.id ORDER BY timestamp DESC LIMIT 15"; $ac_anime_updates = $Db->query($ac_anime_big_query); //using the above results match the URL colum to find the same URL in the ac_anime table so we can then bring in more options for each individual title. // some usefull functions function anime_image_link($value='') { if ($value != NULL) { return $value; }else{ return ""; } } function anime_bg_color($anime_type='') { switch ($anime_type) { case 1: return "#9ACD2B"; break; case 5: return "#32679d"; break; default: return "#FFAE00"; break; } } // write out both attributes function anime_tile_attrs($data) { $anime_type = $data['type']; $anime_image = $data['image']; $color = 'bgcolor="'.anime_bg_color($anime_type).'"'; $image = 'style="background-image:url('.anime_image_link($anime_image).'); background-repeat:no-repeat; background-position:9px 10px;"'; return $color." ".$image; } //make display show only 1 item per box (table cell below) there should be a total of 15 different values total. ?>
>

on:
>

on:
>

on:
>

on:
>

on:
>

on:
>

on:
>

on:
>

on:
>

on:
>

on:
>

on:
>

on:
>

on:
VIEW MORE UPDATES