Assigning a special rank based on custom profile field

Need some custom code changes to the phpBB core simple enough that you feel doesn't require an extension? Then post your request here so that community members can provide some assistance.

NOTE: NO OFFICIAL SUPPORT IS PROVIDED IN THIS SUB-FORUM
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: NO OFFICIAL SUPPORT IS PROVIDED IN THIS SUB-FORUM
Post Reply
1024KBUser
Registered User
Posts: 32
Joined: Mon Dec 23, 2013 1:18 pm

Assigning a special rank based on custom profile field

Post by 1024KBUser » Fri Jan 12, 2018 11:31 pm

I dont know if there is already a way to do this but I currently have a field called "sellerbuyer" that can be either "Seller" or "buyer" (which the user fills in via drop down box) and I want to assign the rank image "seller.jpg" or "buyer.jpg" based on this "sellerbuyer" field automatically.

I also want to put them in to the seller group or buyer group. Im doing this manually at the moment but want to automate.

Is there an extension that can do this ? Or maybe I have to code some custom code to interact with the phpbb Database file directly ?? Which SQL Table has these values ?

My forum is pretty small at the moment but if it grows it will difficult.

1024KBUser
Registered User
Posts: 32
Joined: Mon Dec 23, 2013 1:18 pm

Re: Assigning a special rank based on custom profile field

Post by 1024KBUser » Tue Jan 16, 2018 3:18 am

I figured it out. I did an INNER JOIN on profile_fields_data.user_id & users.user_id which allowed me to set the rank via users table in a couple of lines.

Post Reply

Return to “phpBB Custom Coding”

Who is online

Users browsing this forum: No registered users and 6 guests