hey guys need help to add DEV TAG & Admin Commands ! i am using dnc source :)
Printable View
hey guys need help to add DEV TAG & Admin Commands ! i am using dnc source :)
add isdev = 1
accounts
userdata
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 :/:
Okey thanks i asked google :D
sql script
Code:-- 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
Thank you very much bro ! :lol:<3
and it will work for dnc source ??? :)
I have tried now and it is working very fine thank you :)