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!

Orange names help !

Initiate Mage
Joined
Apr 13, 2014
Messages
24
Reaction score
1
The names of new enrollees appears in orange color on the speech area of the game.
How do I fix ?



-- ----------------------------
-- Procedure structure for [WZ_ACCOUNT_CREATE]
-- ----------------------------


ALTER PROCEDURE [dbo].[WZ_ACCOUNT_CREATE]
@in_IP varchar(64),
@in_Email varchar(128),
@in_Password varchar(64),
@in_ReferralID int,
@in_SerialKey varchar(128),
@in_SerialEmail varchar(128)
AS
BEGIN
SET NOCOUNT ON;

-- Close Register from Launcher
-- select 2 as ResultCode, 'Registeration from Patcher/Launcher was closed.' as ResultMsg;
-- return;

--
-- NOTE: add new ResultCodes to updater CUpdater::CreateAccThreadEntry
--



-- check for serial key
--declare KEYResultCode int = 99
--declare KEYCustomerID int = 99
--declare KeyserialType int = 99
--exec [BreezeNet].[dbo].[BN_WarZ_SerialGetInfo]
-- @in_SerialKey,
-- @in_SerialEmail,
-- KEYResultCode out,
-- KEYCustomerID out,
-- KeyserialType out

--if KEYResultCode <> 0 or KEYCustomerID > 0) begin
-- select 3 as ResultCode, 'Serial not valid' as ResultMsg;
-- return
--end
declare KeyserialType int = 0 -- Legend Package


-- check if that account was created and refunded before (status 999)
declare ReFundCustomerID int = 0
select ReFundCustomerID=CustomerID from Accounts WHERE email=@in_Email and AccountStatus=999
if ReFundCustomerID > 0) begin
-- change email to some unique one so it can be used again.
declare dateTime varchar(128)
set dateTime = REPLACE(CONVERT(VARCHAR, GETDATE(),111),'/','') + REPLACE(CONVERT(VARCHAR, GETDATE(),108),':','')
declare ReFundedEmail varchar(128) = '(' + dateTime + ') ' + @in_Email
update Accounts set email ReFundedEmail where CustomerID ReFundCustomerID
end

-- validate that email is unique
if exists (SELECT CustomerID from Accounts WHERE email=@in_Email) begin
select 2 as ResultCode, 'Email already in use' as ResultMsg;
return;
end

-- create user
declare MD5FromPwd varchar(100)
exec FN_CreateMD5Password @in_Password, MD5FromPwd OUTPUT
INSERT INTO Accounts (
email,
MD5Password,
dateregistered,
ReferralID,
lastlogindate,
lastloginIP
) VALUES (
@in_EMail,
MD5FromPwd,
GETDATE(),
@in_ReferralID,
GETDATE(),
@in_IP
)


-- get new CustomerID
declare CustomerID int
SELECT CustomerID=CustomerID from Accounts where email=@in_Email


-- create all needed user tables
INSERT INTO UsersData (
CustomerID,
AccountType,
dateregistered,
IsPunisher
) VALUES (
CustomerID,
'2',
GETDATE(),
'0'
)


update UsersData set GamePoints=(GamePoints+999999) where CustomerID CustomerID
update UsersData set GameDollars=(GameDollars+999999) where CustomerID CustomerID

-- guest accounts have 48hrs play time (sync with WZ_ACCOUNT_APPLYKEY also)
if KeyserialType = 3) begin
declare dateActiveUntil datetime = DATEADD(hour, 48, GETDATE())
update UsersData set DateActiveUntil dateActiveUntil where CustomerID CustomerID
end

-- register CustomerID in BreezeNet
-- exec [BreezeNet].[dbo].[BN_WarZ_SerialSetCustomerID] @in_SerialKey, CustomerID


-- default items and bonuses for account types


exec FN_AddItemToUser CustomerID, 20174, 2000 -- hero: regular guy


-- CBT TEST HEROES
exec FN_AddItemToUser CustomerID, 20182, 2000
exec FN_AddItemToUser CustomerID, 20184, 2000


-- 10 of each
--declare @i int = 0
--while(@i < 10) begin
-- set @i = @i + 1


-- exec FN_AddItemToUser CustomerID, 101306, 2000 -- Flashlight
-- exec FN_AddItemToUser CustomerID, 101261, 2000 -- Bandages
-- exec FN_AddItemToUser CustomerID, 101296, 2000 -- Can of Soda
-- exec FN_AddItemToUser CustomerID, 101289, 2000 -- Granola Bar
--end


-- BONUSES for packages - do not forget to sync them with [WZ_ACCOUNT_APPLYKEY]

-- success
select 0 as ResultCode
select CustomerID as CustomerID, KeyserialType as 'AccountType'


return
END

I think the problem here has
Please help me.......
 
Back
Top