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]

UPDATE user SET usergroupid=y WHERE usergroupid=2 AND posts>x

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:


UPDATE user SET usergroupid=y WHERE usergroupid=2 AND posts>=x

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

and change it to:
$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 :D