Need help to ADD DEV TAG & Admin Commands ! (DNC Source)

[kaijux]

hey guys need help to add DEV TAG & Admin Commands ! i am using dnc source :)

[MentaL]

[javaz97]

add isdev = 1
accounts
userdata

[kaijux]

Okey thanks :) Can you describe it a little bit better because i am really new in this :s

I mean where i exactly find it & and have to change it. would be very thankful to you

[The Owl]

Okey thanks :) Can you describe it a little bit better because i am really new in this :s

I mean where i exactly find it & and have to change it. would be very thankful to you

Navicat.

[kaijux]

Okey thanks i asked google :D

[javaz97]

sql script

-- Add Dev

USE WarZ
GO

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

SET @USER_cID = 'youremail'
SET @Developer = '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

[kaijux]

Thank you very much bro ! <3

and it will work for dnc source ??? :)

[kaijux]

I have tried now and it is working very fine thank you :)