function get_comic($comic, $date) { global $sql; $res=$sql->query("select gfx, strftime('%s', 'now')-strftime('%s', timestamp) as last from comics_date where comic='$comic' and date='$date'"); if($elem=$sql->fetch_assoc($res)) { if($elem['gfx']) return $elem["gfx"]; elseif(!date_is_after($date, date_add(date_get_today(), -60))) { return null; } elseif((!date_is_after($date, date_add(date_get_today(), -2)))&&($elem['last']>24*60*60)) return null; elseif($elem['last']>60) return null; } $fun="{$comic}_check"; $gfx=$fun($date); if($gfx) $gfx_sql="\"$gfx\""; else $gfx_sql="null"; $sql->query("insert or replace into comics_date values ('$comic', '$date', $gfx_sql, null, datetime('now'))"); return $gfx; }
function prev_next_links($id=0) { global $date; $ret=""; $i=-1; if($id) { $found=false; while(($i>-10)&&(!$found)) { if(get_comic($id, date_add($date, $i))) { $found=true; } else $i--; } if(!$found) $i=-1; } $ret.="<a href='?date=".date_add($date, $i).($id?"#$id":"")."'>previous</a>\n"; $ret.="$date\n"; $i=1; if($id) { $found=false; while(($i<10)&&(date_add($date, $i)<=date_get_today())&&(!$found)) { if(get_comic($id, date_add($date, $i))) { $found=true; } else $i++; } if(!$found) $i=1; } $ret.="<a href='?date=".date_add($date, $i).($id?"#$id":"")."'>next</a>\n"; return $ret; }