Re-upload
Printable View
Re-upload
Really, I still do not understand, can you tell me where it is?Quote:
Originally Posted by serrinha
thank you
- - - Updated - - -
Really, I still do not understand, can you tell me where it is?Quote:
Originally Posted by Kuchen
thank you
- - - Updated - - -
Really, I still do not understand, can you tell me where it is?Quote:
Originally Posted by Kuchen
thank you
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 ; )
How do you break through the user blocking system, registered and logged in?Quote:
Originally Posted by brunomestre
Quote:
Originally Posted by XxFuR4xX
Open navicat > dbo > functions > WZ_Char_SRV_SetStatus
Find:Replace the red text for:Code:-- update basic character data update UsersChars set
GamePos=@in_GamePos,
GameFlags=1,
Alive=@in_Alive,
Health=@in_Health,
Food=@in_Hunger,
Water=@in_Thirst,
Toxic=@in_Toxic,
TimePlayed=@in_TimePlayed,
LastUpdateDate=GETDATE(),
XP=@in_XP,
Reputation=@in_Reputation,
Stat00=@in_Stat00,
Stat01=@in_Stat01,
Stat02=@in_Stat02,
Stat03=@in_Stat03,
Stat04=@in_Stat04,
Stat05=@in_Stat05
where CharID=@in_CharID
Code:GameFlags=@in_GameFlags,
Hope i help you.
- - - Updated - - -
Enjoy the reupload.
https://mega.nz/#F!Y5YAFLpK!sV8dvFgfY4Swh7g1jHLr0A
friend, open your mssql look for dbo.UsersData table and change the accountStatus field 10100 to 100.Quote:
Originally Posted by zsh7954
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),Quote:
Originally Posted by Kuchen
@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]
Change this Line
update UsersData set AccountStatus=(AccountStatus+10000) where CustomerID @CustomerID
to
update UsersData set AccountStatus=(AccountStatus+100) where CustomerID @CustomerID
or Remove it it should work aswell
--update UsersData set AccountStatus=(AccountStatus+10000) where CustomerID @CustomerID
But first make sure That the default playable accounts have Status 100 cus im not sure i dont use this Source i only Work with Vusions First Release or DNC Education
And Pls Next time use [spoiler ][ /spoiler]
I modified or deleted, it still can't registerQuote:
Originally Posted by Kuchen
- - - Updated - - -
A: hi! Brother. Can you tell me where is it? If there is a screenshot is best.Quote:
Originally Posted by serrinha
Mate Tell me Ur Problem cus u told u cant login and now u Write cant register ?!?
Who can fix crash map codorado v1 ?
I'm sorry, may be because the web translation problems, cause I want to say with the translated content is a little different, I can't be registeredQuote:
Originally Posted by Kuchen
pQuote:
Originally Posted by mysunbite
Look in zombie spawns on studio and edit th death drop to your choice. Also look in the loot in the database.
My last attempt!Quote:
Originally Posted by zsh7954
10100 = Block !!!
100 = Free
http://i.imgur.com/AEp3NKU.png
Oh, brother. I can't even registered now!Quote:
Originally Posted by serrinha
sofar as i see it a Problem with ur Ip i think this msg means that u already have a Account with this ip or so . I would say go into ur db in Userdata seek for ur Ip put a 127.0.0.1 into it and register again if it wont wont work try to edit
wz_Accountcreate in line
Spoiler:
to
Spoiler:
only if u get the "IP already in use" in ur R3dlog this should work ^^ if not idc ^^ i just try to help
use a virtual machine, my virtual machine IP is: 192.168.1.100 192.168.1.105 my host IP, I think that there should not be the case, etc. Have a look at it again this noon. All in all, I appreciate your help. Thank you very much!Quote:
Originally Posted by Kuchen
anyway try to Put all IPS to 127.0.0.1 in DB in Userdata and Accounts or so dont remember and register again or do the steps i Posted
Sad to see 10 pages of "pls help me to remove account block" question, which is so easy. And all this spam only for a source which use Codexpo + addons (copy paste from other release).
And funny to see people who release a source code then remove it. GG
Sadly some people just never learn...Quote:
Originally Posted by FrageDev
Thats True
I'm sorry, I'm just a amateur, and for your language, I can only get the meaning by machine translation.Quote:
Originally Posted by FrageDev
I have a coming, hope you can for the server to do a solution to a tutorial, thank you very much!
i need backup of bin files. ty.
https://mega.nz/#F!2k03yAwT!12lpSxFQwWNrH303VUOaZQQuote:
Originally Posted by Adnan DatLife
download link?