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 16:40

  • 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: 916
[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 11/22/2015, 18:38   #2
 
elite*gold: 0
Join Date: Apr 2015
Posts: 420
Received Thanks: 107
Nice


SkuulCandy is offline  
Old 11/25/2015, 13:02   #3
 
elite*gold: 0
Join Date: Oct 2015
Posts: 49
Received Thanks: 17
Nice Script Thanks
Pokemee is offline  
Old 12/01/2017, 17:55   #4
 
elite*gold: 0
Join Date: Dec 2016
Posts: 101
Received Thanks: 34
'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 12/01/2017, 21:07   #5
 
elite*gold: 0
Join Date: Sep 2011
Posts: 389
Received Thanks: 230
SET IDENTITY_INSERT Users_Master ON

INSERT INTO here

SET IDENTITY_INSERT Users_Master OFF
GO


SnickQ is offline  
Thanks
1 User
Reply



« [RELEASE] PHP DropFinder V3 | [Release] LV 15/30/70 custom sets »

Similar Threads
Users_Master Point problem
01/09/2015 - Shaiya PServer Development - 0 Replies
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 player take Point free. Like 80 Point for 60 lvl.. how i can delete this bag?? ty for attenction....
[Selling] Selling Accounts Europe West--Buy account with no recover
10/27/2014 - League of Legends Trading - 18 Replies
Account 1 Diamond I 85 champions 5 rune page 41 skins Account 2 Diamond V 73 champions
[Selling] A trick to recover CFEU accounts
01/08/2014 - CrossFire Trading - 18 Replies
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 ( before you sell or get scammed ) 250e*gold @quickk] can vouch I'm legit
Deleted accounts
04/15/2013 - DarkOrbit - 21 Replies
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 search not stelead or hacked DELETED:rtfm::rtfm::rtfm::rtfm: 2 of this accs was mine ;d :mad:
Accounts deleted
03/20/2007 - CO2 Main - Discussions / Questions - 4 Replies
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 only this server its happned to let us know if it happened to you too and what server you are on. ...



All times are GMT +2. The time now is 16:40.


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.