233663
All VERY valid points. Please keep in mind that this was my first PHP project and my first XOOPS project, so I know I have a lot to learn.
Very poor use of SQL queries (two used when one could have been) to begin with. Then the lack of Criteria Objects make it worse. For the reporting section, I will try to do better (I am working on Query Objects for that). If it will be flexablie, I will have to do better
EDIT - I see that you are referring to XOOPS specific CriteriaCampo, I did not kow that existed. I was thinking of Java related general Criteria and Query Objects. I will do more research.
Also, the language constants are a good idea. Way too much hard coded. I will be sure to correct this.
This is only about 50% done. I guess alpha would have been a better term for the release.
JMass