My present to you all

Improvements:

• [Optional] users and passwords ect, prevents impersonation, allows custom settings, and messages will link back to an about you page. (I've tried to design this so there's no *need* to login or register, and I have thought about browsers that don't support cookies).
• Dates and times can be changed to your time zone
• Email addresses are hidden unless you're logged in - this should prevent spam bots and such
• Unanswered questions now automatically appear (in bold) on the new answers page
• Consistent design on every page
• Direct links to New Questions and New Answers on the boards page
• Web mail lets you email other posters from your browser
• Permalinks to individual messages
• Optional time stamps on messages
• Hierarchial category system

is tripod php slow? i don't even recall tripod doing PHP leave alone whichevr variety of SQL! -- certainly not when I joined. i'll just go and have a play on my server now...

It looks really good ( well a lot like this one)

I like the way you can write a message and still see the entire thread.

I will give more comments once I have used it a bit more

Thanks Graham.

(i'm confused abt whether these are two options we will have to choose between, or two HEROES OF ILX working on the same project but difft continents...)

OH No! I broke it :-/

Two things, though: you say that emails are hidden if you are not logged in, but that wasn't the case, at least for me. More importantly, I think, there are a number of dead ends in standard navigation paths where we get to otherwise blank pages with "Poster Added", "Poster Info Changed", "Logged In" or "Message Added" (the ones I found in a quick play). A short message and a redirect (usually to the Boards level, but refreshing the thread to which you have just posted is a very good idea in that case) might be better, or a popped-up alert for you to acknowledge while the same happens, or something like that - there are lots of design options here, but these "what do I do next? How do I get anywhere?" dead ends are bad.

I haven't tried from more than one machine (I'll try to have a look from work tomorrow) but I want to be able to log in easily from wherever I am. I don't mind at all entering a password once per session, to help cut a lot of abuses.

Alan: PHP and MySQL, and it does seem to be a bit slow.

Mark S: What I've written will probable be put up on Andrew's server when it's finished, and I'll add ILE<->ILM links.

RickyT: That top bit does need redesigning.

Add New Board should be users only, but I hadn't got that far when I programmed it.

I'll do something about the message added/login pages, they're very unfinished right now.

Automatic line breaks are definitely doable.

I don't get the problem with cookies, you should be able to login (and save cookies) on as many computers and browsers as you like. Maybe you're using the Register link again instead of the Login link?

Video Hits: Classic or Dud(Chupa-Cabras)

(I'll ring you tomorrow, BTW)

The rubbish confirmation pages are linked to me not having done much work on checking what people enter i.e. the scripts that insert message ect are v.v. simple.

New improvements:

- Rearranged page titles
- New Answers page now has subheadings for dates
- Added links between ILE and ILM
- Changed "short username" references to "Login name"
- Basic automatic line breaks - one break becomes <BR>, two become - Add new board now available only to registered users (I like the idea of people being able to start their own adjunct/clique/ect, but I suppose if P**dle Support Group or someone turns up, we tell them to off)
- Email addresses are now checked for an @ symbol, mainly for people confused by me swapping over the fields to a more logical (?) order
- Success/failure pages are still rub - no autodirects, links ect, yet.

parse error, expecting `','' or `';'' in boards.php on line 41

However you are awesome for doing this whether I get to see it or not

(two line breaks become <P>, if you don't get the, erm literal demonstration)

I've implemented yahoo style address hiding for people who aren't logged in (dtcd@b...). Do people like it?

DOES ANYBODY IN THIS BITCH KNOW WHEN WE'RE MOVING?

(lez/wanker feature is gone now)

(wanker)

"VARCHAR and the BLOB and TEXT types are variable-length types, for which the storage requirements depend on the actual length of column values (represented by L in the preceding table), rather than on the type's maximum possible size."

The manual makes a lot references to which version things changed in, and it doesn't mention anything here, so they must have fixed this a very long time ago.

• All of the "message posted","logged in","incorrect password" pages are pretty now. Some of them need to be a bit more wordy, but they are at least proper pages.
• Comedy timing warning! It will show you new messages posted while you were composing, and let you edit your message before it's posted (this might annoy people, in which case I can turn it off or make it a user setting or something). No more agreeing with Ronan.
• User setting to only show last n messages of a thread (then click a link to show all of them).
• User setting for message details to show
• User setting for time zone works
• Names and email address are kept unique - someone can't post as you without entering your password (and no you won't have to enter it every time with a non-cookie browser)
• Password reset function if you forget it
• Double post check
• Loads of other little things

Can i please request a log-out function for this? some sites don't have this and it makes it a pain for people like me that access ILE from home and also public/school/work/other peoples' computers quite a lot.

Petra: You'll ba pleased to hear there's already a log out link on every page.

To be clear, if you're logged in you won't be asked for your password. I supposse that's pretty obvious really.

We need to choose a domain name.

Is there an easy way to do a table join (I'm not sure if that's what it's even called) without losing the records in the first table that don't have a corresponding entry in the second? eg I want the left hand side of the result to be the contents of the first table, and the right hand side to be either the corresponding entry from the second table, or blank. Is this doable?

SELECT c.catid, c.name, count(*) as count FROM categories c, threads t WHERE c.catid=t.catid GROUP BY t.catid

SELECT c.catid, c.name,t.catid,if(isnull(t.catid),0,count(*)) as count FROM categories c LEFT JOIN threads t ON c.catid=t.catid group by t.catid,c.catid

Thankyou!

Well?

What, is he going to start demanding our money?

they are still on the other page

can they come back?

(reb - A: Because you're trying to be helpful?)

Unfortunately, this means I get a lot of "this page has expired" messages of late also - e.g. on thread 'n', post message --> success screen, click on "view 'n'" link --> back to thread 'n', hit back button <-- page expired message. I guess I should only go forwards when on ILX from now on!>

(Steve: probably a ilxor.com/ilx.wh3rd.net problem, I think Tom probably links to both)

Thanks for this, Graham!