Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Help] How add new account dev

Newbie Spellweaver
Joined
Jun 26, 2013
Messages
15
Reaction score
1
ok ty but can you add on skype / steam for order question ??
 
Upvote 0
Custom Title Activated
Loyal Member
Joined
May 18, 2006
Messages
1,425
Reaction score
119
-- sql update
-- Add Dev or Admin

USE [WarZ]
GO

DECLARE @CustomerID VARCHAR(100);
DECLARE @USER_cID VARCHAR(50);
DECLARE @Developer VARCHAR(10);

SET @USER_cID = 'your-email'
SET @Developer = 'Yes'; // yes, your are admin

IF @Developer = 'Yes'
BEGIN;
SET @Developer = '1'
END;

IF @Developer = 'No'
BEGIN;
SET @Developer = '0'
END;

SET @CustomerID = (SELECT CustomerID FROM dbo.Accounts WHERE email=@USER_cID)
UPDATE dbo.Accounts SET IsDeveloper=@Developer WHERE email=@USER_cID
UPDATE dbo.UsersData SET IsDeveloper=@Developer WHERE CustomerID=@CustomerID
GO
 
Upvote 0
Back
Top