Thanks for your response,
Marco. Yes, I know that's by design, but I'm looking for a way to override it.
On further research, I think what I need is to create a cron job with an sql query that does the following:
UPDATE user
SET customtitle = 1
WHERE usergroupid = X
I gleaned this info from
here and
here.
Customtitle data values are:
0 = No Custom User Title
1 = Admin Set
2 = User Set
and X would be the usergroup ID of the Secondary Usergroup: Premium Member.
So, essentially, the above sql query would set all customtitle datavalues to Admin Set for the usergroup Premium Member, which is what I need.
Is my understanding of the above correct? Can usergroupid be used in the sql query to specify users whose secondary usergroup matches the usergroupid?
How do I create a cron job with the above sql query? I know how to add a new task using "Schedule Task Manager" in Admin CP, but what code do I need in the .php file to run the above query?
If someone could point me in the right direction, or provide a link to an example .php file with an sql query, I would much appreciate it.
Thanks.
--------------- Added [DATE]1265416347[/DATE] at [TIME]1265416347[/TIME] ---------------
No one here knows how to run this sql query in php? :
UPDATE user
SET customtitle = 1
WHERE usergroupid = X
All I need is a small .php script which runs this single query. Thanks in advance for your time.