Change User Group By post Count

[wolfe]

right i also what it ot change usertitile when it gets 10 posts i have tried adding this

if($bbuserinfo[posts] == 10 AND $bbuserinfo[usergroupid]== 2 AND $bbuserinfo[usertitle] == Trial Member<br><img src="http://www.s2k2.com/forums/images/0stars.gif">) {
  $DB_site->query("UPDATE user SET usergroupid='10' WHERE userid='$bbuserinfo[userid]'");
  $DB_site->query("UPDATE user SET usertitle='1' WHERE usertitle='$bbuserinfo[usertitle]'");
}

what else do i add

[wolfe]

would this work

[wolfe]

i am having problems with this code

i added it and it works it moved people to another group on so many posts but there user title is not updating so i tried the second bit of code bu noe look please hey me

echo "Your User Group Is ".$bbuserinfo[usergroupid]."<br>";
echo "My Post Count is ".$bbuserinfo[posts]."<br>";

if($bbuserinfo[posts] == 9 AND $bbuserinfo[usergroupid]== 2) {
  $DB_site->query("UPDATE user SET usergroupid='10' WHERE userid='$bbuserinfo[userid]'");
}

this one is after they have moved groups

if($bbuserinfo[posts] == 10 AND $bbuserinfo[usergroupid]== 10) {
  $DB_site->query("UPDATE user SET usertitle='New Member<br><img src="http://www.s2k2.com/forums/images/1stars.gif">' WHERE usertitle='$bbuserinfo[usertitle]'");
}

but i get an error when i add it why

[clubdub]

i know this is old, but what Logician posted didn't work for me.

This one did.

PHP Code:

if($bbuserinfo[posts] >= 10 AND $bbuserinfo[usergroupid]==2) {
$DB_site->query("UPDATE user SET usergroupid='{theusergroupidhere}' WHERE usergroupid='2'"); 


[Logician]

Originally posted by clubdub
i know this is old, but what Logician posted didn't work for me.

This one did.

PHP Code:

if($bbuserinfo[posts] >= 10 AND $bbuserinfo[usergroupid]==2) {
$DB_site->query("UPDATE user SET usergroupid='{theusergroupidhere}' WHERE usergroupid='2'"); 


Well, I dont suggest using this code..

Your code is not only changing the usergroup of the poster, but updating the usergroup for ALL USERS in your database. (ones who are from usergroup 2 and post >=10). This might not be a problem to you but I want to remind you the unnecessary MYSQL server load you are creating for every post your members sent..This can especially be a problem if your post number or user number gets bigger..

The reason my code didnt work for you is probably because you didnt test it when you have exactly 10 posts. As I said in my message it will work ONLY when you are on the exact post number, not less, not much..

If you change $bbuserinfo[posts] == 10 to $bbuserinfo[posts] >= 10 in my code as I mentioned, your problem should be cured..

[Learner29]

thank you logician ......

[Learner29]

I highly appreciate your help

[xs1]

its so confusing!!!! can anyone tell me wat exactly to be added and where ?

[insanctus]

Is there any way to add an age check into this.

Say if they hit 50 posts and are 18 or over then it changes them?

The reason I ask is I have a section I want only 18 and older in and only after so many posts.

This will make my life alot easier.

[allan grossman]

I'm gonna need something like this this weekend but would prefer to run it as a job in cron.daily

What I need to do is scan the database for users who are in usergroup 2 that have more than 249 posts and change their usergroup to usergroup xx.

Could someone hook me up, please?