I'm relatively new to XOOPS and PHP/SQL programming, and I don't know what the global XOOPS variables are defined as. I want to do something like this:

xoops user logs in

xoops user is in predefined group which is hopefully a variable?

clicks on .php custom link in MyModule


(inside the php file)

SQL connect to database
SELECT table WHERE (column.table = $XoopsGroupName (what is this variable?? )
ORDER BY whatevercolumn.table;

So, my question is, what are the names for variables for XOOPS groups or is there a link to some sort of easily readable documentation? Thanks!!

this would be ideal:

the league manages game statistics, schedule, and rosters through one official (registered user) per team. website admin adds all the teams and gives the team officials username and temporary passwords (registration is turned off). after login, in one block, you would see something like:
welcome, uic flames.
edit schedule
edit roster
edit player statistics
score games (W-L-T)
a feature i haven't thought of

through edit schedule you would be able to add games which would then be able to be viewed by the general public and added to a comprehensive league game schedule.

through edit roster you would be able to obviously add players and their positions height weight etc.

through edit player statistics, the roster would have to be input, and you could add things like goals assists etc etc, and make it editable for all sports sites.

for scoring games, at least for hockey, you would see your schedule and check a box that says win, loss, tie. then on a point system, all the teams in the league would be displayed on the main page by first, second, third place etc based on the amount of points (2 for win, 0 loss, 1 tie).

I've seen a couple league modules but none that have everythign i want. I'm learning php so I'll add to the module if somebody will help me with it.

Here is what I would like to do:

I use the news module quite frequently on my site. Say an anonymous user views a story in their browser. At the bottom of the story there are two drop boxes -"nested, oldest first" etc. When a registered user logs in and views the same story, notification options and a slew of other options appear at the bottom. Well duh right? I have no need for these items whatsoever and I want a cleaner look. I just can't seem to find the code so I can comment the lines out. I want all users to not even see comments and notification options when they view stories. Thanks for your help!