Plz help me for add account dev and commande /gi
Printable View
Plz help me for add account dev and commande /gi
Navicat -> Accounts -> IsDeveloper -> Set "0" to "1"
Navicat -> UsersData -> IsDeveloper -> Set "0" to "1"
- - - Updated - - -
the command "gi" is already included in any source
ok ty but can you add on skype / steam for order question ??
-- 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