[RELEASE] Latest Codex Src

[dNi3L]

Heli bounces off the ground

that's awesome you got it to spawn in...

 

[m70b1jr]

that's awesome you got it to spawn in...

It's easy.. in the /vspawn command, change the 14 to a 16, and just do /vspawn 16, and /vspawn 15 for the T80. I'm posting a help thread on the bounce-o-copter right now.

 

[dNi3L]

awesome dude..Im on it..

 

[LukeFire]

Is the drone source in this?

 

[m70b1jr]

Is the drone source in this?

Yes, they're in.

 

[Marcio Ferreira]

ok..ok

 

[m70b1jr]

Friends use this src . and error in api.r3dlog below! plus the connection accession to the mysql database etc ... What happens . I can not create account launcher error to try again. !

000000.754| Starting updater, v:3.3.3, cmd:
000000.755| Checking for new updater
000000.763| Checking for new updater - finished
000014.830| WO_API: returned http404
000015.400| WO_API: returned http404
000015.850| WO_API: returned http404
000018.348| Requested to stop, 0 files in queue
000018.348| CUpdater::Stop()

Check API path in RSUpdate



BTW it's LeftShift to rotate the tank turrets.

 

[rapido15]

how to spawn the helicopter and tank?

 

[m70b1jr]

how to spawn the helicopter and tank?

In the vspawn command change the 14 to 16, then in the server do /vspawn 16

 

[smokey0159]

anyone else having problems with loot not spawning? i cant get the loot to spawn am i missing something?

 

[m70b1jr]

anyone else having problems with loot not spawning? i cant get the loot to spawn am i missing something?

Make sure all your info in dbinfo.inc.php is setup, and the proper port, IP, and API path in WarZ_Server.
Loots working fine for me.

 

[Suycune]

I have 2 problem in the rent server DB any idea how to fix this issue guys? I use the query DB in the "Latest Codex Src"

 

[Bombillo]

Replace with this

-- ----------------------------
-- Procedure structure for [dbo].[WZ_ServerChangeParams]
-- ----------------------------
DROP PROCEDURE [dbo].[WZ_ServerChangeParams]
GO
CREATE PROCEDURE [dbo].[WZ_ServerChangeParams]
	@in_CustomerID int,
	@in_GameServerID int,
	@in_ServerPwd nvarchar(16),
	@in_ServerFlags int
AS
BEGIN
	SET NOCOUNT ON;
	
	declare [USER=334703]Own[/USER]erCustomerID int = 0
	declare [USER=412249]Server[/USER]Flags int = 0
	select [USER=334703]Own[/USER]erCustomerID=OwnerCustomerID, [USER=412249]Server[/USER]Flags=ServerFlags from ServersList where GameServerID=@in_GameServerID
	if [USER=334703]Own[/USER]erCustomerID <> @in_CustomerID) begin
		select 6 as ResultCode, 'no owner' as ResultMsg
		return
	end
	
	-- change pwd
	update ServersList set ServerPwd=@in_ServerPwd, ServerFlags=@in_ServerFlags where GameServerId=@in_GameServerId

	select 0 as ResultCode	
END

GO

-- ----------------------------
-- Procedure structure for [dbo].[WZ_ServerChangeParams2]
-- ----------------------------
DROP PROCEDURE [dbo].[WZ_ServerChangeParams2]
GO
CREATE PROCEDURE [dbo].[WZ_ServerChangeParams2]
	@in_CustomerID int,
	@in_GameServerID int,
	@in_ServerPwd nvarchar(16),
	@in_ServerFlags int,
	@in_GameTimeLimit int
AS
BEGIN
	SET NOCOUNT ON;
	
	declare [USER=334703]Own[/USER]erCustomerID int = 0
	declare [USER=412249]Server[/USER]Flags int = 0
	select [USER=334703]Own[/USER]erCustomerID=OwnerCustomerID, [USER=412249]Server[/USER]Flags=ServerFlags from ServersList where GameServerID=@in_GameServerID
	if [USER=334703]Own[/USER]erCustomerID <> @in_CustomerID) begin
		select 6 as ResultCode, 'no owner' as ResultMsg
		return
	end
	
	-- change pwd
	update ServersList set ServerPwd=@in_ServerPwd, ServerFlags=@in_ServerFlags, GameTimeLimit=@in_GameTimeLimit where GameServerId=@in_GameServerId

	select 0 as ResultCode	
END

GO

-- ----------------------------
-- Procedure structure for [dbo].[WZ_ServerChangePwd]
-- ----------------------------
DROP PROCEDURE [dbo].[WZ_ServerChangePwd]
GO
CREATE PROCEDURE [dbo].[WZ_ServerChangePwd]
	@in_CustomerID int,
	@in_GameServerID int,
	@in_ServerPwd nvarchar(16)
AS
BEGIN
	SET NOCOUNT ON;
	
	declare [USER=334703]Own[/USER]erCustomerID int = 0
	declare [USER=412249]Server[/USER]Flags int = 0
	select [USER=334703]Own[/USER]erCustomerID=OwnerCustomerID, [USER=412249]Server[/USER]Flags=ServerFlags from ServersList where GameServerID=@in_GameServerID
	if [USER=334703]Own[/USER]erCustomerID <> @in_CustomerID) begin
		select 6 as ResultCode, 'no owner' as ResultMsg
		return
	end
	
	-- SFLAGS_Passworded = 1 << 0
	--if( [USER=412249]Server[/USER]Flags & 1) = 0) begin
	--	select 6 as ResultCode, 'no pwd change' as ResultMsg
	--	return
	--end
	
	-- change pwd
	update ServersList set ServerPwd=@in_ServerPwd where GameServerId=@in_GameServerId

	select 0 as ResultCode	
END

GO

-- ----------------------------
-- Procedure structure for [dbo].[WZ_ServerCheckCanDonate]
-- ----------------------------
DROP PROCEDURE [dbo].[WZ_ServerCheckCanDonate]
GO
CREATE PROCEDURE [dbo].[WZ_ServerCheckCanDonate]
	@in_CustomerID int
AS
BEGIN
	SET NOCOUNT ON;

	declare @hours int = 0
	select @hours=DATEDIFF(hour, dateregistered, GETDATE()) from UsersData where CustomerID=@in_CustomerID
	
	select 0 as ResultCode
	if(@hours >= 14 * 24)
		select 0 as 'HoursLeft'
	else
		select (14 * 24) - @hours as 'HoursLeft'
END

GO

-- ----------------------------
-- Procedure structure for [dbo].[WZ_ServerGetList]
-- ----------------------------
DROP PROCEDURE [dbo].[WZ_ServerGetList]
GO
CREATE PROCEDURE [dbo].[WZ_ServerGetList]
	@in_CustomerID int
AS
BEGIN
	SET NOCOUNT ON;
	
	select 0 as ResultCode	
	
	if(@in_CustomerID > 0)
		select * from ServersList where OwnerCustomerID=@in_CustomerID order by GameServerID asc
	else
		select * from ServersList where WorkHours<RentHours order by GameServerID asc
END

GO

-- ----------------------------
-- Procedure structure for [dbo].[WZ_ServerGetPrices]
-- ----------------------------
DROP PROCEDURE [dbo].[WZ_ServerGetPrices]
GO
CREATE PROCEDURE [dbo].[WZ_ServerGetPrices]
AS
BEGIN
	SET NOCOUNT ON;

	select 0 as ResultCode
	
	-- GAMESERVER prices
	select
		6600	as 'Base_US',		-- 8500 base price per server per month in US region. 0 if region is disabled
		6600	as 'Base_EU',		-- 8500 base price per server per month in europe region. 0 if region is disabled
		8580	as 'Base_RU',		-- 8500 base price per server per month in russian region. 0 if region is disabled
		0		as 'Base_SA',		-- South america. Should be 3x price of US\EU server due to high cost of renting server equipment in Brazil
		-- percents of base price per each option
		0		as 'PVE',
		0		as 'PVP',
		9999	as 'Slot1',			-- not used right now. was 30 plr
		20		as 'Slot2',			-- 50 plr
		40		as 'Slot3',			-- 70 plr
		100		as 'Slot4',			-- 100
		9999	as 'Slot5',			-- not used now - will be 250
		0		as 'Passworded',
		0		as 'MonthX2',		-- 
		-10		as 'MonthX3',		-- 
		-15		as 'MonthX6',
		-70		as 'WeekX1', -- for renting one week only
		0		as 'OptNameplates',
		0		as 'OptCrosshair',
		0		as 'OptTracers'
		
	-- STRONGHOLD prices
	select
		750		as 'Base_US',		-- base price per server per month in US region. 0 if region is disabled
		750		as 'Base_EU',		-- base price per server per month in europe region. 0 if region is disabled
		975		as 'Base_RU',		-- base price per server per month in russian region. 0 if region is disabled
		0		as 'Base_SA',
		-- percents of base price per each option
		0		as 'PVE',
		0		as 'PVP',
		0		as 'Slot1',			-- 10 plr
		50		as 'Slot2',			-- 20 plr
		100		as 'Slot3',			-- 30 plr
		150		as 'Slot4',			-- 40 plr
		200		as 'Slot5',			-- 50 plr
		0		as 'Passworded',
		0		as 'MonthX2',		-- 
		0		as 'MonthX3',		-- 
		0		as 'MonthX6',
		-40		as 'WeekX1', -- for renting one week only
		0		as 'OptNameplates',
		0		as 'OptCrosshair',
		0		as 'OptTracers'
		
	-- games CAPACITY report
	declare [USER=21783]Game[/USER]s_US int = 0
	declare [USER=21783]Game[/USER]s_EU int = 0
	declare [USER=21783]Game[/USER]s_RU int = 0
	declare [USER=21783]Game[/USER]s_SA int = 0
	select [USER=21783]Game[/USER]s_US = count(*) from ServersList where ServerRegion=1  and WorkHours<RentHours and ServerMap<>3
	select [USER=21783]Game[/USER]s_EU = count(*) from ServersList where ServerRegion=10 and WorkHours<RentHours and ServerMap<>3
	select [USER=21783]Game[/USER]s_RU = count(*) from ServersList where ServerRegion=20 and WorkHours<RentHours and ServerMap<>3
	select [USER=21783]Game[/USER]s_SA = count(*) from ServersList where ServerRegion=30 and WorkHours<RentHours and ServerMap<>3

	select
		-- modify numbers here. 1st is global server capacity. 2nd is our HOSTED server number
		-- mul by 2 as with hibernate we can support more servers now
		(1500*2) - 80 as 'Capacity_US', [USER=21783]Game[/USER]s_US as 'Games_US',
		(1440*2) - 80 as 'Capacity_EU', [USER=21783]Game[/USER]s_EU as 'Games_EU',
		(280+50) - 50 as 'Capacity_RU', [USER=21783]Game[/USER]s_RU as 'Games_RU',
		(90*2)   - 80 as 'Capacity_SA', [USER=21783]Game[/USER]s_SA as 'Games_SA'

	-- strongholds CAPACITY report
	select [USER=21783]Game[/USER]s_US = count(*) from ServersList where ServerRegion=1  and WorkHours<RentHours and ServerMap=3
	select [USER=21783]Game[/USER]s_EU = count(*) from ServersList where ServerRegion=10 and WorkHours<RentHours and ServerMap=3
	select [USER=21783]Game[/USER]s_RU = count(*) from ServersList where ServerRegion=20 and WorkHours<RentHours and ServerMap=3
	select [USER=21783]Game[/USER]s_SA = count(*) from ServersList where ServerRegion=30 and WorkHours<RentHours and ServerMap=3

	select
		-- modify numbers here. 1st is global server capacity. 2nd is our HOSTED server number
		-- mul by 4 as with hibernate we can support more servers now
		(650*4) - 0 as 'Capacity_US', [USER=21783]Game[/USER]s_US as 'Games_US',
		(650*4) - 0 as 'Capacity_EU', [USER=21783]Game[/USER]s_EU as 'Games_EU',
		(50*4)      as 'Capacity_RU', [USER=21783]Game[/USER]s_RU as 'Games_RU',
		0           as 'Capacity_SA', [USER=21783]Game[/USER]s_SA as 'Games_SA'
		
END

GO

-- ----------------------------
-- Procedure structure for [dbo].[WZ_ServerRenew]
-- ----------------------------
DROP PROCEDURE [dbo].[WZ_ServerRenew]
GO
CREATE PROCEDURE [dbo].[WZ_ServerRenew]
	@in_CustomerID int,
	@in_GameServerID int,
	@in_PriceGP int,
	@in_RentHours int
AS
BEGIN
	SET NOCOUNT ON;
	
	-- check if have money and price is valid
	if(@in_PriceGP <= 0) begin
		select 6 as ResultCode, 'bad gp' as ResultMsg
		return
	end

	declare [USER=21783]Game[/USER]Points int = 0
	select [USER=21783]Game[/USER]Points=GamePoints from UsersData where CustomerID=@in_CustomerID
	if [USER=21783]Game[/USER]Points < @in_PriceGP) begin
		select 6 as ResultCode, 'no gp' as ResultMsg
		return
	end
	
	-- check if server exists
	declare [USER=1333468744]ServerName[/USER] nvarchar(128)
	select [USER=1333468744]ServerName[/USER]=ServerName from ServersList where GameServerId=@in_GameServerID
	if(@@ROWCOUNT = 0) begin
		select 6 as ResultCode, 'no server' as ResultMsg
		return
	end
	
	-- renew server
	update ServersList set 
		NumRents=NumRents+1, 
		RentHours=RentHours+@in_RentHours,
		PriceGP=PriceGP+@in_PriceGP
	where GameServerId=@in_GameServerID

	-- perform transaction
	INSERT INTO FinancialTransactions VALUES (
		@in_CustomerID,
		@in_GameServerID,
		2000, 
		GETDATE(), 
		@in_PriceGP, 
		'1', 
		'APPROVED',
		'SERVER_RENEW')

	declare @GPAlterDesc nvarchar(512) = 'Server Renew: ' + [USER=1333468744]ServerName[/USER]
	declare [USER=143066]alter[/USER]GP int = -@in_PriceGP
	exec FN_AlterUserGP @in_CustomerID, [USER=143066]alter[/USER]GP, 'SERVER_RENEW', @GPAlterDesc
	
	select 0 as ResultCode
	select @in_GameServerID as 'ServerID'
END

GO

-- ----------------------------
-- Procedure structure for [dbo].[WZ_ServerRent]
-- ----------------------------
DROP PROCEDURE [dbo].[WZ_ServerRent]
GO
CREATE PROCEDURE [dbo].[WZ_ServerRent]
	@in_CustomerID int,
	@in_PriceGP int,
	@in_ServerRegion int,
	@in_ServerType int,
	@in_ServerFlags int,
	@in_ServerMap int,
	@in_ServerSlots int,
	@in_ServerName nvarchar(64),
	@in_ServerPwd nvarchar(16),
	@in_RentHours int
AS
BEGIN
	SET NOCOUNT ON;
	
	-- check if have money and price is valid
	if(@in_PriceGP <= 0) begin
		select 6 as ResultCode, 'bad gp' as ResultMsg
		return
	end

	declare [USER=21783]Game[/USER]Points int = 0
	select [USER=21783]Game[/USER]Points=GamePoints from UsersData where CustomerID=@in_CustomerID
	if [USER=21783]Game[/USER]Points < @in_PriceGP) begin
		select 6 as ResultCode, 'no gp' as ResultMsg
		return
	end
	
	-- check for unique name
	if(exists (select ServerName from ServersList where ServerName=@in_ServerName)) begin
		select 9 as ResultCode, 'name already exists' as ResultMsg
		return
	end

	-- create admin key, must not be 0
	declare [USER=2000166712]admin[/USER]Key int = CHECKSUM(NEWID())
	if [USER=2000166712]admin[/USER]Key = 0) set [USER=2000166712]admin[/USER]Key = 1
	
	-- create server entry
	insert into ServersList (
		OwnerCustomerID,
		PriceGP,
		CreateTimeUtc,
		AdminKey,
		ServerRegion,
		ServerType,
		ServerFlags,
		ServerMap,
		ServerSlots,
		ReservedSlots,
		ServerName,
		ServerPwd,
		RentHours,
		WorkHours
	) values (
		@in_CustomerID,
		@in_PriceGP,
		GETUTCDATE(),
	 [USER=2000166712]admin[/USER]Key,
		@in_ServerRegion,
		@in_ServerType,
		@in_ServerFlags,
		@in_ServerMap,
		@in_ServerSlots,
		0,
		@in_ServerName,
		@in_ServerPwd,
		@in_RentHours,
		0
	)
	declare [USER=502185]serveri[/USER]D int = SCOPE_IDENTITY()

	-- perform transaction
	INSERT INTO FinancialTransactions VALUES (
		@in_CustomerID,
	 [USER=502185]serveri[/USER]D, 
		2000, 
		GETDATE(), 
		@in_PriceGP, 
		'1', 
		'APPROVED',
		'SERVER_RENT')

	declare @GPAlterDesc nvarchar(512) = 'Server Rent: ' + @in_ServerName
	declare [USER=143066]alter[/USER]GP int = -@in_PriceGP
	exec FN_AlterUserGP @in_CustomerID, [USER=143066]alter[/USER]GP, 'SERVER_RENT', @GPAlterDesc
	
	select 0 as ResultCode
	select [USER=502185]serveri[/USER]D as 'ServerID'
END

 

[m70b1jr]

Anyone got the .flas?

 

[Marcio Ferreira]

ok..ok

 

[Rigor Mortis]

Heli bounces off the ground

Yeah the Heli needs alot of work.

 

[m70b1jr]

m70b1jr friend after looking at it that this came across the below error WO_API : http500 returned ! . the error is in the same cpp file rsupdate ?

const char * gDomainIP = " 127.0.0.1 " ;
const char * gDomainBaseUrl = "/ wz / api / " ;

Don't have spaces in your file path.

Yeah the Heli needs alot of work.

I got em working with simulated physx but I'm not posting a full fix until I got the .flas

 

[NNT]

It work fine

 

[LukeFire]

How do i get the drone working? m70b1jr

 

[czs3333]

Excuse me, do you need to change the IP?
I use this server's 127.0.0.1 IP
Server tip set up successfully
But the game client login failed