Lil Request...

[Dean C]

I want to be able to run a query to update all users who have more than "x" posts into a new usergroup... then i want to add a script to a page somewhere so that if a user reaches "X" amount of posts then they're automatically upgraded to the usergroup...

Thanks in Advance

- miSt

[Xenon]

[sql]UPDATE user SET usergroupid=y WHERE usergroupid=2 AND posts>x[/sql]

scriptquestion: well normally you should add this to newreply.php and newthread.php
look for the code line where the user postcounter is increased and add usergroupid=y to it if $bbuserinfo[usergroupid]==2.

[Dean C]

two more questions...

is greater than and equal to allowed in sql queries? Would it look like this:

[sql]
UPDATE user SET usergroupid=y WHERE usergroupid=2 AND posts>=x[/sql]

Second thing... could you give me some more advanced steps as to what to change in newreply.php and newthread.php

Kindest Regards

- miSt

[Xenon]

first:
yes is allowed

second:
in newreply for example find this:

PHP Code:

$DB_site->query("UPDATE user SET
          ".iif ($foruminfo[countposts],"posts=posts+1,","")."
          $dotitle"."lastpost='".time()."' WHERE userid='$bbuserinfo[userid]'"); 


and change it to:

PHP Code:

$DB_site->query("UPDATE user SET
          ".iif ($foruminfo[countposts],"posts=posts+1,".iif($bbuserinfo[usergroupid]==2 and $bbuserinfo[posts]+1>=x,"usergroupid=y,",""),"")."
          $dotitle"."lastpost='".time()."' WHERE userid='$bbuserinfo[userid]'"); 


the changes in newthread would be similar

[Dean C]

thanks xenon ^... ill give it a try..

- miSt

[wolfe]

that should work i requested that too