Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server > Shaiya PServer Guides & Releases
You last visited: Today at 03:52

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

 

[Release] Accounts Recover (If dbo.Users_Master were deleted)

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Feb 2015
Posts: 464
Received Thanks: 900
[Release] Accounts Recover (If dbo.Users_Master were deleted)

Hello!
I deleted my accounts of my servers with a wrong query.. so I found a way to restore them back
This query will recreate all accounts using Chars and UsersMaxGrow table.

The only problem is that the password of your players will be their UserID, some php script to change the password are already released, use search if you want.

PHP Code:
DECLARE @UserUID int
DECLARE @UserID Varchar(32)
DECLARE @
Count int
DECLARE @TotalCount int
DECLARE @Point int 5000
SET 
@TotalCount = (SELECT MAX(UserUIDFROM PS_GameData.dbo.UserMaxGrow)
SET @Count=1

WHILE ((SELECT COUNT(UserUIDFROM PS_UserData.dbo.Users_Master WHERE UserUID = @Count) != 1)
BEGIN

SET 
@UserID=(SELECT TOP 1 UserID FROM PS_GameData.dbo.Chars WHERE UserUID = @Count)

IF @
UserID IS NULL
BEGIN 
SET 
@UserID[email protected]Count
END

        INSERT INTO 
[dbo].[Users_Master]
           ([
UserUID]
           ,[
UserID]
           ,[
Pw]
           ,[
JoinDate]
           ,[
Admin]
           ,[
AdminLevel]
           ,[
UseQueue]
           ,[
Status]
           ,[
Leave]
           ,[
LeaveDate]
           ,[
UserType]
           ,[
UserIp]
           ,[
ModiIp]
           ,[
ModiDate]
           ,[
Point]
           ,[
Enpassword]
           ,[
Birth])
     
VALUES
           
(@Count,@UserID,@UserID,GETDATE(),0,0,0,0,0,NULL,'N',NULL,NULL,NULL,@Point,NULL,NULL)

IF (@
Count < (@TotalCount+1))
SET @Count = @Count+1
END 
Lube helped me, thanks him if your accounts were deleted



Trayne01 is offline  
Thanks
16 Users
Old   #2
 
elite*gold: 0
Join Date: Apr 2015
Posts: 420
Received Thanks: 107
Nice


SkuulCandy is offline  
Old   #3
 
elite*gold: 0
Join Date: Oct 2015
Posts: 49
Received Thanks: 17
Nice Script Thanks
Pokemee is offline  
Old   #4
 
elite*gold: 0
Join Date: Dec 2016
Posts: 81
Received Thanks: 33
'Users_Master' when IDENTITY_INSERT is set to OFF.
Msg 544, Level 16, State 1, Line 19

how to solve this message ?


[ADM]Beno™ is offline  
Old   #5
 
elite*gold: 0
Join Date: Sep 2011
Posts: 379
Received Thanks: 225
SET IDENTITY_INSERT Users_Master ON

INSERT INTO here

SET IDENTITY_INSERT Users_Master OFF
GO


SnickQ is offline  
Thanks
1 User
Reply



« Previous Thread | Next Thread »

Similar Threads
Users_Master Point problem
Hi pvpers, i have a Shaiya Retro server. Is all good, but i have a big problem, in my server when some one create a new Ultimate Toon and exp it the...
0 Replies - Shaiya PServer Development
[Selling] Selling Accounts Europe West--Buy account with no recover
Account 1 Diamond I 85 champions 5 rune page 41 skins Account 2 Diamond V 73 champions
18 Replies - League of Legends Trading
[Selling] A trick to recover CFEU accounts
Hey epvp members today I'm going to sell a trick to recover cfeu account without first info nor contacting support You only need old account ifno...
18 Replies - CrossFire Trading
Deleted accounts
Hello guys in servers like europa global 1,3 and 6 and us4 been deleted alot of acc's.They re DELETED from DO and they arent in clans in profil...
21 Replies - DarkOrbit
Accounts deleted
ok all of my accounts have just been deleted my archers my tros and taos this also happened to my friends we are on mausoleum server not sure if its...
4 Replies - CO2 Main - Discussions / Questions



All times are GMT +2. The time now is 03:52.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.