[/CODE][/CODE][/CODE]
Open Navicat go to ur DB Functions WZ_Accountcreate search for Account Status and Change it to 100 safe it and done should work
And stop Spam would be rly cool ; )
Friend, to be honest, I don't know these, I attach code now, would you please have a look at where is wrong,[code]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_CustomerID int,
@in_SerialEmail varchar(128)
/*@in_Event varchar(128),
@in_ADMEvent varchar(128)*/
AS
BEGIN
SET NOCOUNT ON;
--
-- 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 = 2
-- 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=100
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
if exists (SELECT CustomerID from Accounts WHERE lastloginIP=@in_IP) begin
select 5 as ResultCode, 'IP already in use' as ResultMsg;
return;
end
-- validate that IP is unique
--if exists (SELECT CustomerID from Accounts WHERE lastloginIP=@in_IP) begin
-- select 2 as ResultCode, 'Already registered' 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
-- SELECT
CustomerID=CustomerID from UsersData set AccountStatus=(AccountStatus+100)
-- create all needed user tables
INSERT INTO UsersData (
CustomerID,
AccountType,
GamePoints,
GameDollars,
dateregistered
/*Event,
ADMEvent*/
) VALUES (
CustomerID,
KEYSerialType,
'5000',
'0',
GETDATE()
/*@in_Event,
@in_ADMEvent*/
)
if
KEYSerialType = 3 or
KEYSerialType = 50) begin
-- guest accounts have 24hrs play time (sync with WZ_ACCOUNT_APPLYKEY also)
declare
dateActiveUntil datetime = DATEADD(hour, 24, GETDATE())
update UsersData set DateActiveUntil
dateActiveUntil where CustomerID
CustomerID
end
if
KEYSerialType = 7) begin
-- warinc guest accounts have 7days play time (sync with WZ_ACCOUNT_APPLYKEY also)
set
dateActiveUntil = DATEADD(hour, 168, 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
exec FN_AddItemToUser
CustomerID, 20184, 2000 -- hero: girl
-- CBT TEST HEROES
exec FN_AddItemToUser
CustomerID, 20182, 2000
exec FN_AddItemToUser
CustomerID, 20184, 2000
exec FN_AddItemToUser
CustomerID, 20189, 2000
exec FN_AddItemToUser
CustomerID, 20193, 2000
exec FN_AddItemToUser
CustomerID, 20194, 2000
exec FN_AddItemToUser
CustomerID, 20195, 2000
update UsersData set AccountStatus=(AccountStatus+10000) where CustomerID
CustomerID
-- 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
--exec WZ_ACCOUNT_FN_GiveBonus
CustomerID,
KEYSerialType
-- STEAM accounts
--if
KEYSerialType = 10) begin
-- -- basic STEAM account - no bonuses
--end
-- success
select 0 as ResultCode
select
CustomerID as CustomerID,
KEYSerialType as 'AccountType'
return
END
[/code]