Sql- Approve al users

15 years 6 months ago #3268 by Johny
Sql- Approve al users was created by Johny
I have been sniflin around the database, tried some things. And dumb me, now all users have the status in the backend:Confirmed X. the X=is the red X. Also a clock is displayed on the column: approved.

Is their someone who nows a Sql code or other trick to approve every users en aso confirmed?
Thank you very much!
Byeee!

Please Log in to join the conversation.

15 years 6 months ago #3278 by trail
Replied by trail on topic Re:Sql- Approve al users
Before you mess with the database you might wanna create backups..

But thats not what you like to hear now is it..

I have no clue what you might have done to get this effect..

You would need a php script to change all your fields.. im thinking maybe you have just edited the default state of the field ?

Or you have tinkered with the ID numbers and somehow your userbase is out of synch.. now cb thinks users are unapproved..

In any case.. what i would do.. since you don't know.. is make a backup of this bad state (better than nothing).. and try the synching tool that comes with CB in the backend..

Then i would like to know how the database looks. you should have just as many fields in comprofiler as in users table..

anyway.. WEiRD situation.. and i have no clue what you might have done so the fix is unknown.. BACKUP before you do ANYTHING, even NOW!!!

~T.

DJ Trail.
CB Co-Founder & Test-Lead.
Plugins: My Age , Starsign Matchmaking Horoscope , My Visitor , My Highscores , My ProfileID ,
My Components: Import & Invite Karma Casino (Use Test / Test)
My Modules: Many :)

Please Log in to join the conversation.

15 years 6 months ago #3340 by Johny
Replied by Johny on topic Re:Sql- Approve al users
Yes, the problem is solved!
Thank you Trail

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.432 seconds

Facebook Twitter LinkedIn