[ErrorSystem-devel] TR: PHP developpers for ErrorSystem

[BrokenClock <bro...@fr...>]

It seems that I forgot this stupid "reply all " button again, so I transf=
er
you this mail and some others.

-----Message d'origine-----
De : BrokenClock [mailto:bro...@fr...]
Envoy=E9 : lundi 15 d=E9cembre 2003 21:37
=C0 : nw
Objet : RE: PHP developpers for ErrorSystem


ES-Main :
"One record for one system." I never thought that ES should manage only o=
ne
system. I thought using name as primary key. But if you tell that's bette=
r
to have a system id as key, why not?

About langages : I have suggest that ES would create one table for each
langage and system. I never suggested that ES would manage only two langa=
ge
per system. Well, but I made a mistake in the design page : the deflg fie=
ld
describ in the ES-main table should be used also in the yoursystem-ini
table. It would define the default langage used by yoursystem in the
yoursystem-ini table, and the default langage used by ES and all the syst=
ems
(but ones defined in the yoursystem-ini table) in the ES-main. And defaul=
t
langages did not mean that ES woould not be able to display others. You
should add as many langages as you need. That why I thought to use one ta=
ble
per langage. So you whould have yoursystem-en table for english,
yoursystem-fr for french, and so on. Maybe I wasn'd as clear as I wish
(pardon my poor english, I'm not very used to it, and I'm a little tired
those days (just have a removal, big update is running just *now*, some
difficulties with critical process, well, well, well stop complain!))
I mean, I don't know if a langage table is required.
About Errorlevel table : do we really need it? What the others think? A
description in the documentation should enough?
About foreign key : see McTail mail.

Well, it's time to go to bed, I think.

Have fun dreams, guys

Stephane


> -----Message d'origine-----
> De : nw [mailto:bi...@ra...]
> Envoy=E9 : lundi 15 d=E9cembre 2003 10:00
> =C0 : bro...@fr...
> Objet : Re: PHP developpers for ErrorSystem
>
>
> Hello.
> I've visited design page. Following is an example MySql database
> structure as i see it:
>
> ES-Main table
> _____________
> System ID (i think that errorsystem server should can manage not only
> one system. This field can be unique key for every system)
> System Name (that you have described)
> AdminMail (that you have described)
> DefLg (that you have described)
>
> ES-Languages table (good error system should support more than 2
> languages, let the user manage any number of languages. This table
> only define system languages but not errors text)
> __________________
> SystemID (foreign key to associate with specific system from ES-Main)
> LanguageShortName (fr, eng, ru or another - used as primary key)
> LanguageFullName (France, English, Russian or another. This field
> maybe must contain native name of language - Deutsch, =D0=F3=F1=F1=EA=E8=
=E9, English
> or another)
>
> ES-Errors table (contain special info about errors)
> ________________
> ErrorNum (used as index and primary key)
> ErrorLevel (foreign key to asscociate with following ES-ErrorLevels
> table)
> InternalCode
> (In this table i have some doubts about errorName to use by special
> action and SpecialMsg to use by special action)
>
>
> ES-ErrorLevels table
> ____________________
> ErrorLevel (number of level, used as primary key)
> ErrorLevelDescription (like "stop the execution of the software")
>
>
> ES-Messages table (contain messages table for every language, defined
> in ES-Languages table)
> _________________
> LanguageShortName (used to make relation with language from
> ES-Languages table)
> ErrorNum (used foreign key to make relation with ES-Errors table)
> ErrorName (in this language)
> ShortDesc
> LongDesc
> HTMLDesc
> XMLDesc
>
> This way structured database is able to manage any numbers of error
> systems in one database (became error system server), is able to use
> any numbers of user defined languages.
>
> I think so.
> Best Regards.
> nw.
>
> On Thu, 11 Dec 2003 16:35:01 +0100
>   "BrokenClock" <bro...@fr...> wrote:
> >Hi,
> >
> >I've already add you as a developer.
> >I was just working on an update of the design page when i received
> >your
> >mail. What will I say on this page in about one hour? That, as
> >McTails
> >suggested, we better planed to use SQLite (www.sqlite.com) instead of
> >flat
> >files. SQLite will be implemented in PHP5, which should be published
> >very
> >soon. Waiting, we will use MySQL. I think we should not have a lot of
> >work
> >to add the code for SQLite, using SQL requests.
> >Check the page when it is up to date, and we will re-talk about it.
> >
> >Regards,
> >
> >Stephane
> >
> >> -----Message d'origine-----
> >> De : nw [mailto:bi...@ra...]
> >> Envoy=E9 : jeudi 11 d=E9cembre 2003 16:23
> >> =C0 : bro...@fr...
> >> Objet : Re: PHP developpers for ErrorSystem
> >>
> >>
> >> Hello.
> >> I've read project information at project homepage and subscribed
> >> error-devel mailing-list. And about Unix name, maybe you mean my
> >> Sourceforge login? It's biznw.
> >> I think that ErrorSystem is an interesting idea. On my mind, system
> >> will be more flexible and powerfull with MySQL, but you are right
> >> about synchronous development of both (db and files-driven). I
> >>expect
> >> from this project better knowlege of php and expierense of team
> >> working. Now? you can pose a problem(s)!
> >>
> >> On Thu, 11 Dec 2003 15:04:56 +0100
> >>   "BrokenClock" <bro...@fr...> wrote:
> >> >OK, so read the home page : http://errorsystem.sourceforge.net/
> >> >Subscribe the error-devel mailing-list.
> >> >Send me your Unix name (your account name on SourceForge, you must
> >> >have
> >> >one), so I can had you as a developper.
> >> >And tell me what you think about this project, your suggestion and
> >> >all.
> >> >
> >> >Pleased to have you with us.
> >> >
> >> >Stephane
> >> >
> >> >> -----Message d'origine-----
> >> >> De : Andrew [mailto:bi...@us...]
> >> >> Envoy=E9 : mardi 9 d=E9cembre 2003 15:20
> >> >> =C0 : bro...@us...
> >> >> Objet : RE: PHP developpers for ErrorSystem
> >> >>
> >> >>
> >> >> Hello!
> >> >>
> >> >> I have some expierence in php programming and want to learn
> >> >>
> >> >> more. Will be glad to share workload!
> >> >>
> >> >
> >>
> >>
> >
>
>