The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
PHPMyAdmin challenge
I hope someone will come up with an answer to this...I am sure it is very easy for someone with the knowledge.
I have a custom profile field which did not used to be required on registration, but is now. I have searched through phpmyadmin and have 1000 people who have this field blank. I have the user IDs but would like to associate these with usernames...Anyone know how I can do this? Many thanks in advance |
#2
|
||||
|
||||
What is it you are trying to do? What is it you want to accomplish?
|
#3
|
||||
|
||||
Something like this?
[sql]SELECT userfield.fieldX, user.username FROM tablePrefix_userfield as userfield LEFT JOIN tablePrefix_user as user using (userid) WHERE userfield.fieldX = ''[/sql] |
#4
|
||||
|
||||
And there is also a hack, I believe, that will require users to enter the info next time they log in. Depends on what it is you are trying to accomplish.
|
#5
|
|||
|
|||
@jumpD, that is exactly what I want to acomplish, complience. Any idea who did the hack or what it is called?
@SirAdrian thanks for that, do i change "x" for 6 "field6" as this is the name...or do i need to fill in the WHERE userfield.fieldX = '', this would be a problem as as I am looking for peeps with nothing in that field... Thanks all Thx guys, the hack worked for me |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|