The Great Tree

Durin Mephit · Posted: Thu Mar 20, 2008 1:41 pm Post subject:

Tweek,

Lynnutte likes the idea. Let's roll with it. Rel.to shall be "A service of the Guild of Messengers."

I will check your work in progress when I have time (hopefully tonight)
_________________
Durin Mephit * Member of Guild of Messengers - Unless otherwise stated, opinions are mine only and not Guild endorsed.
rel.to | Marten KI: 59474 | Durin M KI: 11883768

Moiety Jean · Posted: Thu Mar 20, 2008 2:15 pm Post subject:

Let us celebrate this arrangement with the adding of chocolate to milk.
_________________
~Moiety Jean

KI#44727
"There is a certain beautiful danger when a group of geeks get together to entertain themselves." ~Orin Drake

CuzinJohn · Posted: Thu Mar 20, 2008 4:57 pm Post subject:

Moiety Jean · Posted: Thu Mar 20, 2008 5:06 pm Post subject:

::considers for a moment::

Yes.
_________________
~Moiety Jean

KI#44727
"There is a certain beautiful danger when a group of geeks get together to entertain themselves." ~Orin Drake

janaba1 · Posted: Fri Mar 21, 2008 6:06 am Post subject:

Ooooh, a paaartyyyy??? Did I miss anything???

So, yeah, let's celebrate this arrangement and let's celebrate ourselves!!!
I'm contributing some more cookies and selfmade fudge... Very Happy

Durin Mephit · Posted: Sat Apr 05, 2008 6:04 pm Post subject:

Thanks to a lot of hard work from Tweek and Erik... rel.to is now automated off of a database and looks absolutely fantastic.

/CHEER!
_________________
Durin Mephit * Member of Guild of Messengers - Unless otherwise stated, opinions are mine only and not Guild endorsed.
rel.to | Marten KI: 59474 | Durin M KI: 11883768

janaba1 · Posted: Sat Apr 05, 2008 7:35 pm Post subject:

Wow!!! Marten, Erik and Tweek... this is beyond words!!!

What an amazing, comprehensive and handy D'ni/Uru resource ...
Thank you all for the hard work... And it looks just awesome... Very Happy

Moiety Jean · Posted: Sat Apr 05, 2008 7:39 pm Post subject:

Looks great! Very Happy

_________________
~Moiety Jean

KI#44727
"There is a certain beautiful danger when a group of geeks get together to entertain themselves." ~Orin Drake

Eleri · Great Tree Member Joined: 27 May 2004 Posts: 819

teh snazzy
_________________

Durin Mephit · Posted: Tue Apr 15, 2008 12:37 am Post subject:

Now that the heat is off, I can conspire with Erik and Tweek on improvements to Rel.to. Smile

First up: I need to add some additional fields to the database to track the days entries are added and last modified. That will come in handy later.
Cool

_________________
Durin Mephit * Member of Guild of Messengers - Unless otherwise stated, opinions are mine only and not Guild endorsed.
rel.to | Marten KI: 59474 | Durin M KI: 11883768

Erik · Posted: Tue Apr 15, 2008 8:37 am Post subject:

You mean just adding the fields and doing nothing with it for now, or do you want to use them right away?

Dates won't be stored in the typical fashion, but as a timestamp, so that won't be easy to edit manually. So it's better in my opinion to create a module to add/edit entries to the database first. (Doesn't have to be a cool module right from the start, we could also set something up quickly that works, and make a more user-friendly after that, while still having a way to add to the database.)

Durin Mephit · Posted: Tue Apr 15, 2008 11:44 am Post subject:

Just adding the fields, and doing nothing with them, for now. There are a few possible ideas for later though:
* Track the 10 latest entries
* Provide a "sort by date" option

I'm not sure which of the above two is a better idea... or maybe there's better ideas than those two.

I was looking at both DATETIME and TIMESTAMP and trying to figure out which was better. I was also trying to figure out why mySQL won't let two columns be declared TIMESTAMP and both have a default value of CURRENT_TIMESTAMP. There's some sort of limitation there.

I guess I need to read up more on it Smile

All I really care is that these fields get filled in automatically with "now" when I add a new entry, and it would be nice if the "modified" field would fill in automatically to the current time when I edit an exiting entry.
_________________
Durin Mephit * Member of Guild of Messengers - Unless otherwise stated, opinions are mine only and not Guild endorsed.
rel.to | Marten KI: 59474 | Durin M KI: 11883768

Erik · Posted: Tue Apr 15, 2008 12:27 pm Post subject:

Didn't know there was an actual TIMESTAMP field and I never heard about CURRENT_TIMESTAMP before. (Probably because normally I let php take care of all those things)

A timestamp is just an amount of seconds, so that's something that can be handled just as easy by an integer (it's probably better).

Something like current_timestamp could be handy yes, but when it's eventually handled by the script, PHP could easily take care of that. It's not really the job of the database to perform such calculations I think... I'll read a bit about CURRENT_TIMESTAMP as well, perhaps it does work what you want.

EDIT: Looked some more info up regarding TIMESTAMP, and it just seems like overkill to me... I think it's much better to store just an integer and to let PHP take care of creating and interpreting these timestamps. That will make manually editing the database a bit more difficult, but that's only temporary.