Well, if the version table is been used somewhere, I have not seen it over the years.
About the version numbering as comments. I would like to move that topic when we killed all relevant bugs out and place a (c) setting in each file. We have to do it, care2x was pirated and sold in the past many times. When you have the ER diagram ready, please send it. That would be nice to have. What app you are using for? Robert Am Mittwoch, den 22.09.2010, 00:36 +0530 schrieb Ap.Muthu: > $$ - Mostly used as LD_var for translating strings and possibly field names > A data dictionary is what is needed. > I will now try to make some (non)sense out of an entity relationship diagram > for care2x. > The unusual naming conventions for naming fields have got me dizzy. > Since we are all using MySQL5, should we not go in for some views? > $$ is very useful in handling recursively a set of field names and table > names from the information_schema table to act uipon user tables across a > set of similar databases. > Many files have the version number of Care2x hard coded - sould we not use > some config variable for it and do away with the versions table? Is the > versions table used anywhere? > > Regards, > Ap.Muthu > > > > Hi Robert, > > > > you are so right about the $$ a lot of modules uses it, > > prescription, lab requests, depot... > > it's really a dark chapter.. > > > > gj. > > > > On 2010-09-21 8:49.MD, Robert Meggle wrote: > >> Hi Muthu, > >> > >> We are now on the level where all had started of care2x nearly 10 years > >> ago. Since that time that peace of code had not been touched. But you're > >> right, the "_" will be escaped by MySQL and the interesting thing is > >> that somehow it had been worked now since years. > >> > >> Another aspect, especially on that ground.level.zero: The idea to store > >> that kind of global settings in a table like we are discussing it now is > >> really ok, but we can discuss the naming convention of it. But the way > >> how it is used by $$ use of var.... look: > >> http://www.php.net/manual/en/language.variables.variable.php > >> > >> That is a dark chapter of php how to (mis)use variables. Normally you > >> should read it, understand it, and -please- forget it and never use it! > >> > >> Robert > >> > >> > >> Am Dienstag, den 21.09.2010, 23:19 +0530 schrieb Ap.Muthu: > >>> Hi Robert, > >>> > >>> That's a good one. > >>> > >>> I did notice that in many parts of the code the global config variable > >>> was > >>> selectively filtered using "person_%". In MySQL, the "_" should be > >>> escaped > >>> as otherwise it means any characters wildcard. The existing filter will > >>> choose "personell" and "person_" as well! I do not know if the > >>> "person\_%" > >>> will work as an argument in the function but it certainly works in MySQL > >>> directly. At the moment it is not affecting any working by having a few > >>> more > >>> unfiltered variables getting in. > >>> > >>> Regards, > >>> Ap.Muthu > >>> > >>>> Hi, > >>>> > >>>> just one note on 6779, there was one value missing in > >>>> care_config_global. Can be added by: > >>>> > >>>> INSERT INTO care_config_global VALUES ('person_insurance_1_nr_hide', > >>>> '1', NULL, '', '', '', 00000000000000, '', '0000-00-00 00:00:00'); > >>>> > >>>> Robert > >>> > >>> > >>> ------------------------------------------------------------------------------ > >>> Start uncovering the many advantages of virtual appliances > >>> and start using them to simplify application deployment and > >>> accelerate your shift to cloud computing. > >>> http://p.sf.net/sfu/novell-sfdev2dev > >>> _______________________________________________ > >>> Care2002-developers mailing list > >>> Care2002-developers@lists.sourceforge.net > >>> https://lists.sourceforge.net/lists/listinfo/care2002-developers > > > > ------------------------------------------------------------------------------ > > Start uncovering the many advantages of virtual appliances > > and start using them to simplify application deployment and > > accelerate your shift to cloud computing. > > http://p.sf.net/sfu/novell-sfdev2dev > > _______________________________________________ > > Care2002-developers mailing list > > Care2002-developers@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/care2002-developers > > > > > > ------------------------------------------------------------------------------ > Start uncovering the many advantages of virtual appliances > and start using them to simplify application deployment and > accelerate your shift to cloud computing. > http://p.sf.net/sfu/novell-sfdev2dev > _______________________________________________ > Care2002-developers mailing list > Care2002-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/care2002-developers -- -- -------------------------------------------- CARE2X - free Integ Hospital Info System https://sourceforge.net/projects/care2002/ http://www.care2x.org ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers
