SQL Query for Custom Profil Field

[Pinn]

I Need a SQL Query for my Profil Field

ID: fakecheck
Option: benutzer_ungeprueft

All User to the Option: benutzer_ungeprueft

Does anyone know of the SQL query for this?

 

[Amaury]

You will need to ask in the dedicated support sections if you want support.

 

[Pinn]

Yes, I need help, need an option show a SQL query to all allow in the profile field.

 

[Pinn]

@Jake Bunce can you help?

 

[Jake Bunce]

https://xenforo.com/community/threads/user-promotion-not-working.42391/#post-457365

 

[Pinn]

Thanks, so ok:??

INSERT INTO xf_user_field_value (user_id, field_id, field_value)
SELECT user_id, 'fakecheck', 'benutzer_ungeprueft'
FROM xf_user
ON DUPLICATE KEY UPDATE
field_value = VALUES(field_value);

 

[Jake Bunce]

Thanks, so ok:??

INSERT INTO xf_user_field_value (user_id, field_id, field_value)
SELECT user_id, 'fakecheck', 'benutzer_ungeprueft'
FROM xf_user
ON DUPLICATE KEY UPDATE
field_value = VALUES(field_value);

Correct.

 

[Pinn]

202 Datensätze eingefügt. ( Die Abfrage dauerte 0.0018 Sekunden )

It is however entered nothing for anyone.

 

[Jake Bunce]

...

Then rebuild the user cache:

Admin CP -> Tools -> Rebuild Caches -> Rebuild User Caches

 

[Pinn]

Yes, i have.

 

[Pinn]

Option is in Checkbox is that a Problem?

Manual is okey.

 

[Jake Bunce]

Checkboxes are multi-select. Those values are stored as arrays. You will end up with a query like this:

INSERT INTO xf_user_field_value (user_id, field_id, field_value)
	SELECT user_id, 'field_id', 'a:1:{s:5:"value";s:5:"value";}'
	FROM xf_user
ON DUPLICATE KEY UPDATE
	field_value = VALUES(field_value);

This is serialized data. Be careful that the string lengths match the value.

 

[Pinn]

Yes it works:

INSERT INTO xf_user_field_value (user_id, field_id, field_value)
    SELECT user_id, 'fakecheck', 'a:1:{s:13:"benutzer_echt";s:19:"benutzer_ungeprueft";}'
    FROM xf_user
ON DUPLICATE KEY UPDATE
    field_value = VALUES(field_value);