Turns out that the method used by AB2.5 yields wrong results (one year off) if the user is old enough.

'Old enough' is typically 100 years or more so it doesn't really matter, though.


I came up with a different method for calculating the member's age. It works fine for all ages, and as a bonus, it doesn't have the requirement of the code that is implemented currently.

if($user['birth']) { $months = array(1 => 'January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'); $bd = explode('-',$user['birth']); $birthday = $months[(int)$bd[0]].' '.(int)$bd[1]; $unit = ($bd[1]>=10 && $bd[1]<=13) ? 4 : $bd[1]%10; switch ($unit) { case 1: $birthday .= 'st'; break; case 2: $birthday .= 'nd'; break; case 3: $birthday .= 'rd'; break; default: $birthday .= 'th'; break; } if ($bd[2]) { $birthday .= ', '.$bd[2]; $datenow = explode('-',date("m-d-Y")); $daynow = $datenow[0]*31 + $datenow[1]; $daybd = (int)$bd[0]*31 + (int)$bd[1]; $age = $datenow[2] - (int)$bd[2]; if ($daybd > $daynow) $age--; if ($age < 0) $age = '(born in '.(-$age).' year'.($age==-1?'':'s').')'; else $age = '('.$age.' year'.($age==1?'':'s').' old)'; } else $age = ''; } else { $birthday='&nbsp;'; $age=''; }

This assumes that the user birthday is stored as 'MM-DD-YYYY' or 'MM-DD' when the year is omitted.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

In my Acmlmboard branch, 'no birthday entered' is represented by an empty string, rather than 0 or -1.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

sigh



oh, it says I have permission to close this. Should I? At this point it's kinda like talking to a brick.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

I would say that quitting your job when you have debts isn't the wisest idea, personally. I hope she finds a better job before falling into a debt spiral.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

Actually, her parents are biphobic, or so she said.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

If you need to know, PM a staff member.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

Pagination in Acmlmboard is done with the typical 'LIMIT X,Y' statement. There's an issue with that and long threads, though.

Let's say the user requests page 200 of a thread. His posts per page setting is 20. Your query will look like this:

SELECT (tons of shit) FROM posts p LEFT JOIN (several other tables) WHERE t.id=1337 LIMIT 4000,20

Which basically means that MySQL will fetch 4020 rows and discard most of them.


I coded a simple solution to reduce that overhead.

function postids($table, $where) { global $sql, $loguser, $page; $ids = $sql->query("SELECT id FROM $table WHERE $where LIMIT ".(($page-1)*$loguser['ppp']).",".$loguser['ppp']); $ret = ''; while ($id = $sql->fetch($ids)) $ret .= ($ret?',':'').$id['id']; return $ret ?: 'NULL'; }

This retrieves the IDs of the posts that are going to be visible. It still has the aforementioned problem, but MySQL will read from the posts table's primary index (as opposed to reading from multiple tables), so it's much less severe.

Once you got the result of that, you feed it to the query that fetches all the remaining data.

SELECT (tons of shit) FROM posts p LEFT JOIN (several other tables) WHERE p.id IN ($result)



Another solution would consist into giving posts per-thread incrementing numbers, and base pagination on that. But this has its number of problems, especially if you find yourself wanting to merge/split threads or delete a spammer's posts. And it only works for displaying a regular thread.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

:3



Had that dream a while ago about me going in vacation somewhere with my parents for Summer. There was a conflict because my sister wasn't there, and we thought she wasn't coming with us (that's what actually happened last Summer). But at the time of leaving home, she came back home and she was willing to come with us.

Then there was that pier platform thing I was on, that was covered in sand, like some weird artificial beach. There was a radio station talking about how hot climate was and supposedly it was caused by global warming, but actually it was cold. So much even that it snowed a little. Didn't seem that off to me despite happening in July. Wee dream logic.

Then we were in our backyard, and for some reason it was flooded. We were bathing as if it was the sea.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

I logged out, and I got a sprite on the redirect page following it. Trying to capture it yielded a 'Not logged in.' message.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

Instant redirects wouldn't have this issue at all


Other than that, I suspect that sprites are added to the page somewhere in pageheader(), before the current page has the time to signal that it's a redirect page.

You'd need to add a flag to pageheader() or somewhere else before that.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

If those places use instant redirects no matter what, you might as well scrap the option entirely, for the sake of consistency.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?