Register for your free account! | Forgot your password?

You last visited: Today at 04:48

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



Multi account

Discussion on Multi account within the Shaiya PServer Development forum part of the Shaiya Private Server category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Oct 2012
Posts: 89
Received Thanks: 4
Multi account

Hello!
I try tu wirte some query's for show multi acc
But i have a problem "Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the varchar value '127.0.0.1' to data type int."

Code:
 SELECT * FROM PS_UserData.dbo.users_master
Where UserIp >1
Code:
SELECT * FROM PS_UserData.dbo.Users_Master c
INNER JOIN PS_UserData.dbo.Users_Master um ON um.UserUID=c.UserUID
WHERE um.UserIp >1
QQers19 is offline  
Old 05/15/2014, 15:15   #2
 
nubness's Avatar
 
elite*gold: 10
Join Date: Jan 2012
Posts: 1,698
Received Thanks: 5,455
Code:
USE PS_UserData
SELECT UserUID, UserID, Pw, UserIp FROM Users_Master
WHERE UserIp IN (SELECT UserIp FROM Users_Master
GROUP BY UserIp
HAVING COUNT(UserIp) > 1)
ORDER BY UserIp
nubness is offline  
Thanks
1 User
Old 05/15/2014, 15:32   #3
 
elite*gold: 0
Join Date: Oct 2012
Posts: 89
Received Thanks: 4
Thank you
QQers19 is offline  
Old 05/16/2014, 18:55   #4




 
Autrux's Avatar
 
elite*gold: 246
Join Date: Dec 2010
Posts: 33,474
Received Thanks: 6,059
Arrow Shaiya Private Server -> Shaiya PServer Development

#moved
Autrux is offline  
Reply




All times are GMT +1. The time now is 04:49.


Powered by vBulletin®
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2025 elitepvpers All Rights Reserved.