next »

[JustClick]

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 ?

[leoleo]

awesome

[JustClick]

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.

[JustClick]

Bump to make aware.

[JustClick]

Bump ! May be helpful to someone. 

[JustClick]

Bump ! May be helpful to someone.  Smiley

[JustClick]

Tut Bump ! 

[JustClick]

Monthly Bump ! 

[JustClick]

Bump !

[fawad1234]

Bump for free

[JustClick]

Tut Bomb ! 

[nikilavi]

bump

[delftnenasala]

hi thanks your guide please next to wrote template design guide

[rosestorm]

thank for share How to check Multi Account in PTC

[JustClick]

Monthly Bump !