1 Topic by sowers

  • sowers
  • Professional member
  • Offline
  • From: Mars
  • Registered: 2008-07-29
  • Posts: 465

Topic: Move all Members Without Profile Avatar to a new no photo Member Group

I need to move the members without profile photo to a specific group

Move all Members Without Profile Avatar to a new No photo Member Group

Comet Chat - The best Facebook chat clone integrated to Vldpersonals
Asian Dating and Asian Girls
Dating woman Romania

2 Reply by matrimo

  • matrimo
  • Power member
  • Offline
  • From: Belgium
  • Registered: 2008-05-25
  • Posts: 981

Re: Move all Members Without Profile Avatar to a new no photo Member Group

Create a new Group In Control Pannel or choice one. Look to the ID

In the next case the goup ID is 10.


Backup your DB.

Start this SQL command :

UPDATE vld_members SET group_id='10' WHERE picture=''

All members without picture will be moved to the Group  that you like.

It works, it is Created & Tested BY MATRIMO

Have a nice day.

Last edited by matrimo (2011-06-28 01:26:27)

Matrimoniale ~ Iubire ~ Agence Matrimoniale ~ Dating Romania

matrimo's Website

3 Reply by sowers

  • sowers
  • Professional member
  • Offline
  • From: Mars
  • Registered: 2008-07-29
  • Posts: 465

Re: Move all Members Without Profile Avatar to a new no photo Member Group

Thank's Matrimo big_smile

Comet Chat - The best Facebook chat clone integrated to Vldpersonals
Asian Dating and Asian Girls
Dating woman Romania