[edit member's settings]: click on the icon
to edit this member's settings.
[view member's stats]: click on the icon
to view this member's statistics.
[credit/debit member]: click on the icon
to credit or debit this member's account.
[delete member]: click on the icon
to delete this member from your program.
Add a new member manually: use this to create a new member account by hand.
Username must be between 3 and 32 characters long.
Search for members:
Search type: select basic search to form your search criteria from
the provided information fields or select advanced search (SQL knowledge
required) to perform a SQL search.
For the basic search form, on text based fields (i.e.: char, varchar, text, etc) the use of "%" is allowed
to match an arbitrary number of characters. For example, Username like %bob%
will match the members bob, super_bob and bob1988.
For the advanced search, you must enter a search criteria that will be performed as
SELECT <member info> FROM GPTE_Members WHERE <your search criteria>
If you want, for instance, search for members who have joined your program within the
last 10 days and order the result by their number of points, your search criteria should be
Signup_Time > NOW() - INTERVAL 10 DAY ORDER BY Points
In order to prevent performance degradation, members search is limited to 100 results.