Online dating software

You are not logged in.

Active topics Unanswered topics

Move all Regular women, or men to a specific Group, with 1 click

vldPersonals Forum » Tutorials and Guides » Move all Regular women, or men to a specific Group, with 1 click

Pages 1

You must login or register to post a reply

RSS topic feed

Posts [ 11 ]

1 Topic by matrimo 2010-07-10 20:41:55

matrimo
Power member
Offline

From: Belgium
Registered: 2008-05-25
Posts: 957

Topic: Move all Regular women, or men to a specific Group, with 1 click

Let s say your site become paied or you want move all women to a free access membership or to paid group.

You may Alter your database with one command:

UPDATE vld_members AS vld_members LEFT JOIN vld_members_data_members AS vld_members_data_members ON ( vld_members.member_id = vld_members_data_members.data_id ) SET vld_members.group_id =9,
vld_members.expirationdate =0 WHERE vld_members_data_members.data_gender1 =2;

Where 9 is my free access group; 2 is my regular group who can not send messages.

You can use this command to MASS move members from all Group to another.

If you want SPECIFIC groups, see below down on page (edited) !

This formula is Tested by myself.

Last edited by matrimo (2011-04-09 04:56:56)

Matrimoniale Iubire Agence Matrimoniale Matrimoniale Romania Dating Romania

matrimo's Website

2 Reply by bpejic 2010-07-11 01:50:24

bpejic
Regular member
Offline

Registered: 2009-02-03
Posts: 177

Re: Move all Regular women, or men to a specific Group, with 1 click

thx

|^^^^^^^^^^^^^|____
| vldpersonals | '|";,__.
|_..._....._____===|=_|__|....,]|
"(@)'(@)****|(@)*(@)***(@)

3 Reply by sowers 2010-07-13 18:35:50

sowers
Professional member
Offline

From: Mars
Registered: 2008-07-29
Posts: 400

Re: Move all Regular women, or men to a specific Group, with 1 click

Rombest, you're an angel

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

4 Reply by gugu 2010-07-13 19:58:59

gugu
Power member
Online

From: Sweden
Registered: 2009-01-22
Posts: 1,194

Re: Move all Regular women, or men to a specific Group, with 1 click

Give the world the best you have, and the best will come to you.
Tutorials and Mods for VldPersonals Swedish Dating on Love2u.se VldCrowd:s Community

gugu's Website

5 Reply by matrimo 2011-04-09 04:55:02

matrimo
Power member
Offline

From: Belgium
Registered: 2008-05-25
Posts: 957

Re: Move all Regular women, or men to a specific Group, with 1 click

Till now, with the first Sql comand, all registered women was moved to the Free Group. (9)

The problem is that even all women from Canceled Group and the other Groups was moved to the Free Group.

Now I improved the command to move only Regular women (2) to the Free group.(9)

Here is the right SQL command :

 

UPDATE vld_members AS vld_members LEFT JOIN vld_members_data_members AS vld_members_data_members ON ( vld_members.member_id = vld_members_data_members.data_id ) SET vld_members.group_id =9,
vld_members.expirationdate =0 WHERE vld_members_data_members.data_gender1 =2 AND group_id =2;

Hope you enjoy it.

If you use this SQL comand, it is free.

Anyway, a link to my site is welcome and allways appreciated. Thank you.

Last edited by matrimo (2011-04-09 05:00:29)

Matrimoniale Iubire Agence Matrimoniale Matrimoniale Romania Dating Romania

matrimo's Website

6 Reply by sowers 2011-06-27 15:58:36

sowers
Professional member
Offline

From: Mars
Registered: 2008-07-29
Posts: 400

Re: Move all Regular women, or men to a specific Group, with 1 click

matrimo wrote:

Till now, with the first Sql comand, all registered women was moved to the Free Group. (9)
The problem is that even all women from Canceled Group and the other Groups was moved to the Free Group.

Now I improved the command to move only Regular women (2) to the Free group.(9)

Here is the right SQL command :
 

UPDATE vld_members AS vld_members LEFT JOIN vld_members_data_members AS vld_members_data_members ON ( vld_members.member_id = vld_members_data_members.data_id ) SET vld_members.group_id =9,
vld_members.expirationdate =0 WHERE vld_members_data_members.data_gender1 =2 AND group_id =2;
Hope you enjoy it.
If you use this SQL comand, it is free.
Anyway, a link to my site is welcome and allways appreciated. Thank you.

Thank's !!!

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

7 Reply by sowers 2011-08-05 09:19:25

sowers
Professional member
Offline

From: Mars
Registered: 2008-07-29
Posts: 400

Re: Move all Regular women, or men to a specific Group, with 1 click

I made the mistake of changing sql statement without knowing it, and I turned all men into women and all women into men, you could help me fix this problem?

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

8 Reply by matrimo 2011-08-05 13:49:13

matrimo
Power member
Offline

From: Belgium
Registered: 2008-05-25
Posts: 957

Re: Move all Regular women, or men to a specific Group, with 1 click

Is not recommanded to joke with your database and you must be sure what you do.

You could use you backup to set it was before, or you can start a new SQL command :

UPDATE vld_members_data_members SET data_gender1=8 WHERE data_gender1=2;
UPDATE vld_members_data_members SET data_gender1=2 WHERE data_gender1=1;
UPDATE vld_members_data_members SET data_gender1=1 WHERE data_gender1=8;

This will change gender : Man into Woman and Woman into Men. Do not do this in Real World , lol.

This a tricky but logical sollution... it should work because I am not sure about the simple command (... AND...)

Last edited by matrimo (2011-08-05 13:49:29)

Matrimoniale Iubire Agence Matrimoniale Matrimoniale Romania Dating Romania

matrimo's Website