Need help in running SQL on custom field

Looking for an Extension? Have an Extension request? Post your request here for help. (Note: This forum is community supported; while there is an Extensions Development Team, said team does not dedicate itself to handling requests in this forum)
Get Involved
Post Reply
1024KBUser
Registered User
Posts: 32
Joined: Mon Dec 23, 2013 1:18 pm

Need help in running SQL on custom field

Post by 1024KBUser » Fri Jan 26, 2018 4:12 pm

Can anyone help I want to execute 2 SQL lines right after they successfully register a new account.

I tried reading about the doing this in the phpbb documentation but the database section is too complex :( and abstract for my newbie PHP skill level :oops: :oops: .

These are the SQL lines:

Code: Select all

UPDATE phpbb_frmusers INNER JOIN phpbb_frmprofile_fields_data ON phpbb_frmusers.user_id = phpbb_frmprofile_fields_data.user_id  SET phpbb_frmusers.user_rank = 3 WHERE phpbb_frmusers.user_rank = 0 AND phpbb_frmprofile_fields_data.pf_sellerreviewer = 1; 

UPDATE phpbb_frmusers INNER JOIN phpbb_frmprofile_fields_data ON phpbb_frmusers.user_id = phpbb_frmprofile_fields_data.user_id  SET phpbb_frmusers.user_rank = 6 WHERE phpbb_frmusers.user_rank = 0 AND phpbb_frmprofile_fields_data.pf_sellerreviewer = 2; 
Id grateful to anyone that code a working example.

Thanks in advance.

Post Reply

Return to “Extension Requests”

Who is online

Users browsing this forum: HiFiKabin and 10 guests