eMoneySpace
Welcome, Guest. Please login or register.
Did you miss your activation email?
News: Earn your money online safely here at eMoneySpace. Aug 10, 2022 04:16 AM




[Tutorial] How to check Multi Account in PTC - Manual
Print
Author Topic: [Tutorial] How to check Multi Account in PTC - Manual  (Read 13495 times)
JustClick
Reputation: (+60)
*

Offline

Posts: 5794
Referrals: 1


View Profile WWW
Dec 09, 2014 01:41 PM

May be you have this feature in your script but if you have not then it is manual command based.

SQL Query : SELECT m.userid as id1,m.username as user1,m.password as pass1,m1.username as user2,m1.password as pass2 from user m join user m1 on m.password = m1.password;


m.userid as id1 ( userid is row name of userid i am calling it as id1 so that i can recognize the username id )
m.username as user1 ( username row name which i called it as user1 , suppose if your script is having member or membername instead of username .. so u have to use rowname whatever it is in your script )

Bcoz i am doing SELF JOIN in SQL so i made a condition where password = password .. means if password matched to same password it will show one username = another username

If both end username is same means it is normal account.


This is a single command which u can run from phpMyadmin.

THE MEMBER TABLE



ROWS OF MEMBER TABLE



RESULT



Dont ban these members directly without asking or monitor there activites, it is possible many are using a normal passwords like " ABCDEFG " or " 123456"

BUT WHAT YOU WILL DO IF THINGS LOOK LIKE THIS ?


« Last Edit: Dec 09, 2014 01:44 PM by JustClick » Logged

leoleo
Reputation: (-1)
*

Offline

Gender: Female
Posts: 88
Referrals: 1


View Profile WWW
Reply #1: Dec 09, 2014 08:28 PM

awesome
Logged

wonder of world
JustClick
Reputation: (+60)
*

Offline

Posts: 5794
Referrals: 1


View Profile WWW
Reply #2: Dec 12, 2014 08:25 AM

i got a pm, a guy is facing problem using this command.

If someone else is facing problem then let me know i am happy to guide you.

Thank you.
Logged

JustClick
Reputation: (+60)
*

Offline

Posts: 5794
Referrals: 1


View Profile WWW
Reply #3: Dec 29, 2014 01:22 PM

Bump to make aware.
Logged

JustClick
Reputation: (+60)
*

Offline

Posts: 5794
Referrals: 1


View Profile WWW
Reply #4: Aug 30, 2015 10:33 AM

Bump ! May be helpful to someone.  Smiley
Logged

JustClick
Reputation: (+60)
*

Offline

Posts: 5794
Referrals: 1


View Profile WWW
Reply #5: Mar 20, 2016 01:39 AM

Bump ! May be helpful to someone.  Smiley
Logged

JustClick
Reputation: (+60)
*

Offline

Posts: 5794
Referrals: 1


View Profile WWW
Reply #6: Jun 07, 2016 09:37 AM

Tut Bump !  Tongue
Logged

JustClick
Reputation: (+60)
*

Offline

Posts: 5794
Referrals: 1


View Profile WWW
Reply #7: Jul 02, 2016 09:41 AM

Monthly Bump !  Smiley
Logged

JustClick
Reputation: (+60)
*

Offline

Posts: 5794
Referrals: 1


View Profile WWW
Reply #8: Jul 27, 2016 10:20 PM

Bump !
Logged

fawad1234
Reputation: (+60)
*

Offline

Gender: Male
Posts: 6152
Referrals: 3


LOVE PAKISTAN

View Profile
Reply #9: Jul 29, 2016 04:17 PM

Bump for free Tongue
Logged

PAKISTAN Zindabad      high5 high5 high5 high5 high5 high5 high5 high5 high5 high5 high5      PAKISTAN Zindabad
JustClick
Reputation: (+60)
*

Offline

Posts: 5794
Referrals: 1


View Profile WWW
Reply #10: Dec 17, 2016 05:26 AM

Tut Bomb !  big grin
Logged

nikilavi
Reputation: (+43)
*

Offline

Gender: Male
Posts: 1911
Referrals: 0

View Profile
Reply #11: Jan 04, 2017 12:48 PM

bump big grin
Logged
delftnenasala
Reputation: (+10)
*

Offline

Posts: 154
Referrals: 0


Probux Moderator ITECCENTRE

View Profile WWW
Reply #12: Jan 05, 2017 05:37 AM

hi thanks your guide please next to wrote template design guide
Logged

Probux ZModerator ITECCENTRE
rosestorm
Reputation: (0)
*

Offline

Posts: 191
Referrals: 0

View Profile WWW
Reply #13: Jan 06, 2017 09:46 AM

thank for share How to check Multi Account in PTC
Logged

JustClick
Reputation: (+60)
*

Offline

Posts: 5794
Referrals: 1


View Profile WWW
Reply #14: Mar 04, 2017 10:47 PM

Monthly Bump !
Logged

Print
 
Jump to:  
Copyright © 2008-2022 eMoneySpace. All rights reserved.