Make account legend

[KidJB]

How to set an acc as legend/pioneer in allrightsource?

[MentaL]

[vSimpleDie]

Go in your database, find out the customerid and set accounttype to 0

[KidJB]

Go in your database, find out the customerid and set accounttype to 0

got it thanks any idea how to set account premium in allrightsource?

[vSimpleDie]

what do you mean with premium?

[javaz97]

-- Add Punisher ID

USE [WarZ]
GO

DECLARE @CustomerID int;
DECLARE @user_cID VARCHAR(128);

SET @user_cID = 'xxxxx'; -- email
SET @CustomerID = (SELECT CustomerID FROM dbo.Accounts WHERE email @user_cID)

update dbo.UsersData set IsPunisher = '1' where CustomerID = @CustomerID
GO

[manhun1222]

-- Add Punisher ID

USE [WarZ]
GO

DECLARE @CustomerID int;
DECLARE @user_cID VARCHAR(128);

SET @user_cID = 'xxxxx'; -- email
SET @CustomerID = (SELECT CustomerID FROM dbo.Accounts WHERE email @user_cID)

update dbo.UsersData set IsPunisher = '1' where CustomerID = @CustomerID
GO

error :\
http://kepfeltoltes.hu/view/140406/e...toltes.hu_.png

[skyone]

error :\
http://kepfeltoltes.hu/view/140406/e...toltes.hu_.png

SET @user_cID = 'xxxxx'; // the user id of the player that you want to add premium.

[fadhli123]

SORRY DISTURB THIS POST.ANYONE KNOW HOW TO SETUP MOSIANG SERVER? WITH TUTORIALS AND DATABASE SETUP TOO.

AND HELP ME HOW TO DO THIS >>>>

MHCmember>chr_log_info is where the accounts data are stored. (userlevel 4 is for GM ID)
MHCmember>TB_OPERATOR is where GM's ID are placed (for alt+enter on gm tool)
MHCmember>TB_OPERIP is where GM's Ip addresses are located (check here for forbidden IP problem)
MHCmember>TB_OPERIPGAME is where the game IP is hosted(i think) Just insert your computer IP here.
MHGame>TB_CHARACTER is where the character data is stored such as your character level ;)


Change all those settings to your liking.If you did you shouldn't have much problem on it.
P/s : add your ip to TB_OPERIP and TB_OPERIPGAME.