• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

[HELP] Kick from server

W

Wooq56

Newbie Spellweaver
Joined
Aug 21, 2014
Messages
8
Reaction score
0



Soory English After 1 minute kick from the server
​
r3dlog.txt​

Code: 
--- Log started at Sat Aug 08 16:46:02 2015

000005.138| ComputerID: 0x73772e3fe7e9
000005.138| Game Version: WarZ v1.0  (build: Aug  8 2015 00:37:47) - final
000005.138| Available memory: 4039 MB
000005.182| r3dFS: version:August 7, 2015 21:48, 39762 files
000005.444| readGameOptionsFile: found INI at C:\Users\semih\Documents\Arktos\InFesTaTion\gameSettings.ini
000005.445| writeGameOptionsFile: Saving settings to C:\Users\semih\Documents\Arktos\InFesTaTion\gameSettings.ini
000005.453| readInputMap: found file at C:\Users\semih\Documents\Arktos\InFesTaTion\inputMap.xml
000005.454| writeInputMap: Saving settings to C:\Users\semih\Documents\Arktos\InFesTaTion\inputMap.xml
000005.454| userSettings: found file at C:\Users\semih\Documents\Arktos\InFesTaTion\userSettings.xml
000005.456| userSettings: Saving settings to C:\Users\semih\Documents\Arktos\InFesTaTion\userSettings.xml
000005.456| SOUND: initializing sound system
000005.492| SOUND: '1' sound drivers found
000005.492| SOUND: sound caps = 0xF8, speakermode= 2
000005.492| SOUND: sound driver 'Hoparlör (Conexant SmartAudio HD)'
000005.504| SOUND: sound system ready
000005.504| FMOD: LoadSoundEffects: Loading from Data\Sounds\Sounds.fev
000009.580| Input Devices enabled: Mouse, Keyboard
000009.818| VMEM As seen through DDRaw: 1014
000009.818| VMEM As seen through WMI: 0
000009.818| Setting mode:  1024x768x32 Flags=4
000009.818| Could not initialize NVApi.
000009.819| 
000009.820|  Adapter: AMD Radeon HD 6370M
000009.820|   aticfx32.dll 8.17.10.1063
000009.820|  Monitor: \\.\DISPLAY3 (1366x768)
000009.832|  res adjusted 1024x768->1024x740
000009.833|  r3dRenderLayer::SetMode(x=1024,y=740,bpp=32,windowed=4,hz=60)
000009.834|  Creating d3d device
000010.212|  GPU supports D3DQUERYTYPE_TIMESTAMP
000010.213|  GPU supports D3DQUERYTYPE_TIMESTAMPFREQ
000010.213|  D3D hack support = NullRT: 1, hwPCF: 1, IntZ: 1, ResZ: 1
000010.214|  We have 2775 MB texture memory
000010.409|  r3dFont: Creating Verdana 10pt
000010.409|  r3dFont: Finished creating Verdana 10pt
000010.411| Loading shaders...
000014.618| Finished loading shaders (4.207447 sec)!
000014.861| r3dFont: Creating Tahoma 12pt
000014.863| r3dFont: Finished creating Tahoma 12pt
000014.863| r3dFont: Creating Verdana 10pt
000014.863| r3dFont: Finished creating Verdana 10pt
000015.173| Creating render targets
000015.208| r3dFont: Creating Verdana 8pt
000015.216| r3dFont: Finished creating Verdana 8pt
000015.363| Loaded 12 of 12 grass settings locations from the glist file
000015.507| Loaded 12 grass settings files
000016.168| Trying to load food item with id '301321' that is already loaded!000020.365| SetHomeDir: Levels\WZ_FrontEndLighting
000020.365| We have 2627 MB texture memory
000021.890| r3dFile: can't open Levels\WZ_FrontEndLighting/wind.cfg
000021.891| Loading 'Levels\WZ_FrontEndLighting/LevelSettings.xml'
000026.326| Unloaded 0.0 MB STATIC decal textures
000026.326| Unloaded 0.0 MB DYNAMIC decal textures
000026.326| Loading decal library Data\Decals\library.xml.
000026.341| Loading decal library Levels\WZ_FrontEndLighting\decals.xml.
000026.342| Loaded 0.0 MB STATIC decal textures
000027.318| Loaded 0.8 MB DYNAMIC decal textures
000027.319| LoadLevel_MatLibs...
000027.319| LoadLevel_Objects...
000034.764| LoadGrassLib()...
000035.099| g_pGrassMap->Load...
000035.130| LoadLevel_MatLibs...
000035.130| Building skeleton cache..000035.311| Building obstacles cache..000035.311| done.000035.311| Loading 'Levels\WZ_FrontEndLighting\collections\collections.xml'
000035.312| World loaded
000035.312| Total load time: 14.15
000054.559| Acquired base profile data for 34.245682
000057.374| res adjusted 1024x768->1024x740
000070.958| r3dNetwork: Creating client
000071.128|  IP: 192.168.0.11
000071.128| r3dNetwork: connecting
000071.435| r3dNetwork: external ip: xxx.xxx.xxx:60712
000071.436| connected to master server peer00
000075.524| obj_Zombie::FreePhysSkeletonCache:000075.525| done in 0.00 seconds
000075.571| r3dNetwork: Deinitialize
000075.871| r3dNetwork: Creating client
000075.889|  IP: 192.168.0.11
000075.889| r3dNetwork: connecting
000076.189| r3dNetwork: external ip: xxx.xxx.xxx:60714
000076.453| writeGameOptionsFile: Saving settings to C:\Users\semih\Documents\Arktos\InFesTaTion\gameSettings.ini
000076.454| userSettings: Saving settings to C:\Users\semih\Documents\Arktos\InFesTaTion\userSettings.xml
000076.454| SetHomeDir: Levels\CaliWood
000076.454| We have 2614 MB texture memory
000076.454| r3dFile: can't open levels/caliwood/loadingscreen1.dds
000076.718| r3dFile: can't open Levels\CaliWood/wind.cfg
000076.733| Loading 'Levels\CaliWood/LevelSettings.xml'
000076.736| r3dFile: can't open data/shaders/texture/cclut3d/c2_night_03.dds
000076.782| r3dFile: can't open data/shaders/texture/cclut3d/wz_nvg_03.dds
000078.376| Unloaded 0.0 MB STATIC decal textures
000078.376| Unloaded 0.8 MB DYNAMIC decal textures
000078.376| Loading decal library Data\Decals\library.xml.
000078.377| Loading decal library Levels\CaliWood\decals.xml.
000078.958| Loaded 2.8 MB STATIC decal textures
000078.969| Loaded 0.1 MB DYNAMIC decal textures
000078.970| LoadLevel_MatLibs...
000078.970| LoadLevel_Objects...
000079.371| TERRAIN:  LOADING Levels\CaliWood\TERRAIN
000081.564| TERRAIN2: Finished reading script file
000093.184| TERRAIN:  LOADED
000139.263| r3dapp: SysCmd: f020
000160.677| r3dapp: SysCmd: f120
000162.814| r3dFile: can't open data/objectsdepot/wz_calibuildings/textures/curb_bonaventure_01_s.dds
000173.257| r3dFile: can't open data/objectsdepot/wz_calinature/textures/wz_pinetree_04_l.dds
000180.164| r3dapp: SysCmd: f020
000181.131| r3dapp: SysCmd: f120
000182.417| r3dFile: can't open data/objectsdepot/wz_citybuildings/textures/dinner_details_02_d.dds
000182.418| r3dFile: can't open data/objectsdepot/wz_citybuildings/textures/dinner_details_02_n.dds
000189.723| LoadGrassLib()...
000190.104| g_pGrassMap->Load...
000190.564| LoadLevel_MatLibs...
000190.564| Building skeleton cache..000191.317| Building obstacles cache..000191.317| done.000191.342| Loading 'Levels\CaliWood\collections\collections.xml'
000191.342| r3dFile: can't open Levels\CaliWood\collections\elements.bin
000191.343| COLLECTIONS: Could not open 'Levels\CaliWood\collections\elements.bin'
000191.371| obj_Zombie::InitPhysSkeletonCache..
000195.774| done
000195.775| World loaded
000195.775| Total load time: 119.32
000207.581| Created vehicle -> Data\\ObjectsDepot\\Vehicles\\zombie_killer_car.sco
000209.941| r3dMesh::Load(): Can't load 'data/objectsdepot/env_collision/collisioncar.sco' or 'data/objectsdepot/env_collision/collisioncar.scb', file doesn't exist
 (Loading mesh data/objectsdepot/env_collision/collisioncar.sco)
000209.941| WARNING: Object data/objectsdepot/env_collision/CollisionCar.sco can't be loaded!
000209.941| Created vehicle -> Data\\ObjectsDepot\\Vehicles\\zombie_killer_car.sco
000210.644| r3dMesh::Load(): Can't load 'data/objectsdepot/env_collision/collisioncar.sco' or 'data/objectsdepot/env_collision/collisioncar.scb', file doesn't exist
 (Loading mesh data/objectsdepot/env_collision/collisioncar.sco)
000210.644| WARNING: Object data/objectsdepot/env_collision/CollisionCar.sco can't be loaded!
000210.644| Created vehicle -> Data\\ObjectsDepot\\Vehicles\\zombie_killer_car.sco
000211.384| r3dMesh::Load(): Can't load 'data/objectsdepot/env_collision/collisioncar.sco' or 'data/objectsdepot/env_collision/collisioncar.scb', file doesn't exist
 (Loading mesh data/objectsdepot/env_collision/collisioncar.sco)
000211.384| WARNING: Object data/objectsdepot/env_collision/CollisionCar.sco can't be loaded!
000211.385| Created vehicle -> Data\\ObjectsDepot\\Vehicles\\Drivable_Buggy_02.sco
000212.118| r3dMesh::Load(): Can't load 'data/objectsdepot/env_collision/collisioncar.sco' or 'data/objectsdepot/env_collision/collisioncar.scb', file doesn't exist
 (Loading mesh data/objectsdepot/env_collision/collisioncar.sco)
000212.119| WARNING: Object data/objectsdepot/env_collision/CollisionCar.sco can't be loaded!
000219.658| 
Time between load end and game start: 23.88
000248.867| ######## idx 4, footStepsSound: 216 
000266.973| ***** disconnected from game server
000266.973| r3dNetwork: Deinitialize
000268.489| obj_Zombie::FreePhysSkeletonCache:000268.489| .000268.490| .000268.491| .000268.493| .000268.494| .000268.495| .000268.496| .000268.498| .000268.499| .000268.500| .000268.501| .000268.502| .000268.502| .000268.503| .000268.505| .000268.505| .000268.507| .000268.508| .000268.509| .000268.509| .000268.511| .000268.511| .000268.512| .000268.513| .000268.514| .000268.515| .000268.515| .000268.516| .000268.517| .000268.518| .000268.518| .000268.519| .000268.522| done in 0.03 seconds
000269.975| SetHomeDir: Levels\WZ_FrontEndLighting
000269.975| We have 2530 MB texture memory
000270.869| r3dFile: can't open Levels\WZ_FrontEndLighting/wind.cfg
000270.870| Loading 'Levels\WZ_FrontEndLighting/LevelSettings.xml'
000276.613| Unloaded 2.8 MB STATIC decal textures
000276.613| Unloaded 0.1 MB DYNAMIC decal textures
000276.613| Loading decal library Data\Decals\library.xml.
000276.622| Loading decal library Levels\WZ_FrontEndLighting\decals.xml.
000276.624| Loaded 0.0 MB STATIC decal textures
000277.021| Loaded 0.8 MB DYNAMIC decal textures
000277.029| LoadLevel_MatLibs...
000277.029| LoadLevel_Objects...
000293.992| LoadGrassLib()...
000294.390| g_pGrassMap->Load...
000294.404| LoadLevel_MatLibs...
000294.404| Building skeleton cache..000294.557| Building obstacles cache..000294.557| done.000294.557| Loading 'Levels\WZ_FrontEndLighting\collections\collections.xml'
000294.558| World loaded
000294.558| Total load time: 24.47
000296.502| Acquired base profile data for 26.800724

Gameserver log
Code: 
000000.012| r3dFS: there is no volume file wo_00.bin000000.012| Connecting to master server at 151.80.79.88:34000
000000.012|  r3dNetwork: Creating client
000000.186|   IP: 151.80.79.88
000000.186|  r3dNetwork: connecting to 151.80.79.88:34000
000000.186|  waiting: connecting, 10.0 sec left
000000.217|  r3dNetwork: external ip: 151.80.79.88:55084
000000.217| Game: Initializing with 32 players
000000.217|  Server time is Sun Feb 17 10:29:54 2036
000000.218|  CAsyncApiMgr starting
000000.218| Starting server on port 34011
000000.218| r3dNetwork: Creating host at port 34011
000000.342|  IP: 151.80.79.88
000000.357| Getting shop data
000000.505| Reading game rewards
000000.508| Loading armory config
000000.530| Trying to load food item with id '301321' that is already loaded!000000.530| Reading loot boxes
000000.575| There is no LootBox 301117
000000.576| There is no LootBox 301321
000000.576| Starting game server
000000.577| SetHomeDir: Levels\CaliWood
000001.659| TERRAIN:  LOADING Levels\CaliWood\TERRAIN
000001.668| TERRAIN2: Finished reading script file
000003.198| TERRAIN:  LOADED
000003.201| Vehicle Model Created: Data\\ObjectsDepot\\Vehicles\\zombie_killer_car.sco
000003.218| Vehicle Model Created: Data\\ObjectsDepot\\Vehicles\\Drivable_Buggy_02.sco
000003.231| Vehicle Model Created: Data\\ObjectsDepot\\Vehicles\\Drivable_Buggy_02.sco
000003.233| Vehicle Model Created: Data\\ObjectsDepot\\Vehicles\\zombie_killer_car.sco
000003.233| Vehicle Model Created: Data\\ObjectsDepot\\Vehicles\\zombie_killer_car.sco
000003.234| Vehicle Model Created: Data\\ObjectsDepot\\Vehicles\\Drivable_Stryker.sco
000003.245| Vehicle Model Created: Data\\ObjectsDepot\\Vehicles\\Drivable_Stryker.sco
000003.246| Vehicle Model Created: Data\\ObjectsDepot\\Vehicles\\zombie_killer_car.sco
000003.246| Vehicle Model Created: Data\\ObjectsDepot\\Vehicles\\Drivable_Buggy_02.sco
000003.250| Vehicle Model Created: Data\\ObjectsDepot\\Vehicles\\Drivable_Buggy_02.sco
000003.251| Vehicle Model Created: Data\\ObjectsDepot\\Vehicles\\zombie_killer_car.sco
000003.254| Vehicle Model Created: Data\\ObjectsDepot\\Vehicles\\zombie_killer_car.sco
000003.255| Vehicle Model Created: Data\\ObjectsDepot\\Vehicles\\Drivable_Buggy_02.sco
000003.255| Vehicle Model Created: Data\\ObjectsDepot\\Vehicles\\Drivable_Buggy_02.sco
000003.255| Vehicle Model Created: Data\\ObjectsDepot\\Vehicles\\Drivable_Stryker.sco
000003.256| Vehicle Model Created: Data\\ObjectsDepot\\Vehicles\\Drivable_Buggy_02.sco
000003.257| Vehicle Model Created: Data\\ObjectsDepot\\Vehicles\\zombie_killer_car.sco
000003.258| Vehicle Model Created: Data\\ObjectsDepot\\Vehicles\\Drivable_Buggy_02.sco
000004.630| Loading 'Levels\CaliWood\collections\collections.xml'
000004.630| r3dFile: can't open Levels\CaliWood\collections\elements.bin
000004.630| COLLECTIONS: Could not open 'Levels\CaliWood\collections\elements.bin'
000004.630| NavMesh.Load...
000004.648| AutodeskNav: Failed to connect to navigation lab
000004.651| LootBox: 04F7A168 with ItemID 301321, tick: 60
000004.651| LootBox: 04F7A518 with ItemID 301128, 6 items, tick: 60
000004.651| LootBox: 04F7AA70 with ItemID 301122, 22 items, tick: 60
000004.652| LootBox: 04F7CE20 with ItemID 301132, 10 items, tick: 60
000004.652| LootBox: 04F7D1D0 with ItemID 301321, tick: 60
000004.652| LootBox: 04F7D580 with ItemID 301125, 14 items, tick: 60
000004.652| LootBox: 04F7D930 with ItemID 101398, tick: 60
000004.653| LootBox: 04F7DCE0 with ItemID 301126, 30 items, tick: 60
000004.653| LootBox: 04F7E090 with ItemID 301120, 16 items, tick: 60
000004.653| LootBox: 04F7E440 with ItemID 101398, tick: 60
000004.653| LootBox: 06E3C450 with ItemID 301118, 12 items, tick: 60
000004.654| LootBox: 06E3C800 with ItemID 301321, tick: 60
000004.654| LootBox: 06E3CBB0 with ItemID 301123, 4 items, tick: 60
000004.654| LootBox: 06E3CF60 with ItemID 301133, 12 items, tick: 60
000004.654| LootBox: 06E3D310 with ItemID 301136, 125 items, tick: 60
000004.655| LootBox: 06E3D6C0 with ItemID 301121, 22 items, tick: 60
000004.655| LootBox: 06E57508 with ItemID 301119, 14 items, tick: 60
000004.655| LootBox: 06E578D0 with ItemID 301135, 11 items, tick: 60
000004.656| LootBox: 06E57C98 with ItemID 301121, 22 items, tick: 60
000004.656| LootBox: 06E58060 with ItemID 301125, 14 items, tick: 60
000004.656| LootBox: 06E58428 with ItemID 301127, 22 items, tick: 60
000004.656| LootBox: 06E587F0 with ItemID 301129, 16 items, tick: 60
000004.657| LootBox: 06E58BB8 with ItemID 301135, 11 items, tick: 60
000004.657| LootBox: 06E58F80 with ItemID 301121, 22 items, tick: 60
000004.657| LootBox: 06E59348 with ItemID 301137, 20 items, tick: 60
000006.314| server main loop started
000006.314| net_mapLoaded_LastNetID: 318
000006.314| CAsyncApiWorker 0 executing CJobGetServerNotes 04D9F338
000006.324| time: 6, plrs:0/32, net_lastFreeId: 318, objects: 124, async:0 0 0 0 
000006.336| CAsyncApiWorker 0 finished CJobGetServerNotes 04D9F338
000006.347| Job CJobGetServerNotes 04D9F338: Creating 0 Notes
000066.327| time: 66, plrs:0/32, net_lastFreeId: 427, objects: 189, async:0 0 0 0 
000126.329| time: 126, plrs:0/32, net_lastFreeId: 427, objects: 189, async:0 0 0 0 
000133.907| peer00 PKT_C2S_JoinGameReq: CID:7, ip:178.233.83.49
000133.907| CAsyncApiWorker 0 executing CJobProcessUserJoin[0] 0EC11A98
000133.933| CAsyncApiWorker 0 finished CJobProcessUserJoin[0] 0EC11A98
000186.339| time: 186, plrs:0/32, net_lastFreeId: 427, objects: 189, async:0 0 0 0 
000246.342| time: 246, plrs:0/32, net_lastFreeId: 427, objects: 189, async:0 0 0 0 
000264.289| peer00 PKT_C2S_StartGameReq, startGameAns: 1, lastNetID: 300
000264.290|  NETHELPER: CODEXPERT: on create - entered visibility of network object 1 CODEXPERT
000264.290|  NETHELPER: CODEXPERT: entered visibility of network object 300 Zombie_killer_car
000264.290|  NETHELPER: CODEXPERT: entered visibility of network object 307 Zombie_killer_car
000264.291|  NETHELPER: CODEXPERT: entered visibility of network object 311 Zombie_killer_car
000264.291|  NETHELPER: CODEXPERT: entered visibility of network object 315 Drivable_Buggy_02
000280.597| cmd: /gi 101088 admin:1
000306.351| time: 306, plrs:1/32, net_lastFreeId: 427, objects: 190, async:0 0 0 0 
000324.291| CAsyncApiWorker 0 executing CJobUpdateChar[7] 0EE92A18
000324.317| WO_API: failed with error code 5 SQL Select Failed: Procedure or function 'WZ_Char_SRV_SetStatus' expects parameter '@in_GamePoints', which was not supplied.
000324.317| !!!! UpdateCharThread failed, code: 5, ans: SQL Select Failed: Procedure or function 'WZ_Char_SRV_SetStatus' expects parameter '@in_GamePoints', which was not supplied.
000324.318| CAsyncApiWorker 0 finished CJobUpdateChar[7] 0EE92A18
000324.318| !!!! CAsyncApiWorker 0 job CJobUpdateChar[7] 0EE92A18 failed
000324.326| CAsyncApiWorker 0 job CJobUpdateChar[7] 0EE92A18 failed
000324.327| LogInfo: peer00, r:DisconnectPeer API FAILED, CID:7 [CODEXPERT], ip:178.233.83.49
000324.327| DeletePlayer: CODEXPERT, playerIdx: 0
000324.327| CAsyncApiWorker 0 executing CJobAddLogInfo
000324.341| CAsyncApiWorker 0 finished CJobAddLogInfo
000324.341| CAsyncApiWorker 0 executing CJobUserLeftGame[7] 04F0D378
000324.359| CAsyncApiWorker 0 finished CJobUserLeftGame[7] 04F0D378
000360.616| Control-c ...
 
Sort by date Sort by votes
Nikita505

Nikita505

Experienced Elementalist
10 Happy Years
Joined
Mar 24, 2014
Messages
238
Reaction score
167
Re: After 1 minute kick from the server

000324.317| WO_API: failed with error code 5 SQL Select Failed: Procedure or function 'WZ_Char_SRV_SetStatus' expects parameter '@in_GamePoints', which was not supplied.
Click to expand...

That's your problem
 
Upvote 0
The Best DDoS Protected Servers
LukasCCB

LukasCCB

01001100 01000011 01000011 01000010
Loyal Member
Discord 1000 Posts Got A Reaction 10 Happy Years Notable Release
Joined
Apr 23, 2013
Messages
1,172
Reaction score
1,797
Code: 
-- ----------------------------
-- Procedure structure for [dbo].[WZ_Char_SRV_SetStatus]
-- ----------------------------
DROP PROCEDURE [dbo].[WZ_Char_SRV_SetStatus]
GO
CREATE PROCEDURE [dbo].[WZ_Char_SRV_SetStatus]
	@in_CustomerID int,
	@in_CharID int,
	@in_Alive int,
	@in_GamePos varchar(256),
	@in_GameFlags int,
	@in_Health float,
	@in_Hunger float,
	@in_Thirst float,
	@in_Toxic float,
	@in_TimePlayed int,
	@in_XP int,
	@in_Reputation int,
	@in_GameDollars int,
	@in_Stat00 int,
	@in_Stat01 int,
	@in_Stat02 int,
	@in_Stat03 int,
	@in_Stat04 int,
	@in_Stat05 int,
	@in_ResWood int = 0,
	@in_ResStone int = 0,
	@in_ResMetal int = 0,
	@in_CharData varchar(4000) = ''
AS
BEGIN
	SET NOCOUNT ON;
	
	--
	-- this function should be called only by server, so we skip all validations
	--
	
	-- record last game update and update GameDollars with DELTA value
	update UsersData set GameDollars=(GameDollars+@in_GameDollars), lastgamedate=GETDATE() where CustomerID=@in_CustomerID
	
	if(@in_GameDollars > 0) begin
		insert into DBG_GDLog (RecordTime, CustomerID, CharID, GameDollars) 
			values (GETDATE(), @in_CustomerID, @in_CharID, @in_GameDollars)
	end


	-- update basic character data
	update UsersChars set
		GamePos=@in_GamePos,
		GameFlags=@in_GameFlags,
		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
	
	-- update generic character data (if provided)
	if(@in_CharData <> '')
		update UsersChars set CharData=@in_CharData where CharID=@in_CharID


	-- update resources	
	update UsersData set ResWood=@in_ResWood, ResStone=@in_ResStone, ResMetal=@in_ResMetal where CustomerID=@in_CustomerID
	
	if(@in_Alive = 0) begin
		update UsersChars set DeathUtcTime=GETUTCDATE() where CharID=@in_CharID
		-- set default backpack on death
		update UsersChars set BackpackID=20176, BackpackSize=12 where CharID=@in_CharID
		-- delete stuff from backpack
		delete from UsersInventory where CustomerID=@in_CustomerID and CharID=@in_CharID


		exec DBG_StoreApiCall 'Death', 0, @in_CustomerID, @in_CharID
	end


	select 0 as ResultCode
END


GO
 
Upvote 0
W

Wooq56

Newbie Spellweaver
Joined
Aug 21, 2014
Messages
8
Reaction score
0
lukasccb said:
Code: 
-- ----------------------------
-- Procedure structure for [dbo].[WZ_Char_SRV_SetStatus]
-- ----------------------------
DROP PROCEDURE [dbo].[WZ_Char_SRV_SetStatus]
GO
CREATE PROCEDURE [dbo].[WZ_Char_SRV_SetStatus]
    @in_CustomerID int,
    @in_CharID int,
    @in_Alive int,
    @in_GamePos varchar(256),
    @in_GameFlags int,
    @in_Health float,
    @in_Hunger float,
    @in_Thirst float,
    @in_Toxic float,
    @in_TimePlayed int,
    @in_XP int,
    @in_Reputation int,
    @in_GameDollars int,
    @in_Stat00 int,
    @in_Stat01 int,
    @in_Stat02 int,
    @in_Stat03 int,
    @in_Stat04 int,
    @in_Stat05 int,
    @in_ResWood int = 0,
    @in_ResStone int = 0,
    @in_ResMetal int = 0,
    @in_CharData varchar(4000) = ''
AS
BEGIN
    SET NOCOUNT ON;
    
    --
    -- this function should be called only by server, so we skip all validations
    --
    
    -- record last game update and update GameDollars with DELTA value
    update UsersData set GameDollars=(GameDollars+@in_GameDollars), lastgamedate=GETDATE() where CustomerID=@in_CustomerID
    
    if(@in_GameDollars > 0) begin
        insert into DBG_GDLog (RecordTime, CustomerID, CharID, GameDollars) 
            values (GETDATE(), @in_CustomerID, @in_CharID, @in_GameDollars)
    end


    -- update basic character data
    update UsersChars set
        GamePos=@in_GamePos,
        GameFlags=@in_GameFlags,
        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
    
    -- update generic character data (if provided)
    if(@in_CharData <> '')
        update UsersChars set CharData=@in_CharData where CharID=@in_CharID


    -- update resources    
    update UsersData set ResWood=@in_ResWood, ResStone=@in_ResStone, ResMetal=@in_ResMetal where CustomerID=@in_CustomerID
    
    if(@in_Alive = 0) begin
        update UsersChars set DeathUtcTime=GETUTCDATE() where CharID=@in_CharID
        -- set default backpack on death
        update UsersChars set BackpackID=20176, BackpackSize=12 where CharID=@in_CharID
        -- delete stuff from backpack
        delete from UsersInventory where CustomerID=@in_CustomerID and CharID=@in_CharID


        exec DBG_StoreApiCall 'Death', 0, @in_CustomerID, @in_CharID
    end


    select 0 as ResultCode
END


GO
Click to expand...


How to do that ?
 
Upvote 0
Bombillo

Bombillo

☆Dying Dawn☆
Joined
Jan 30, 2012
Messages
971
Reaction score
727
Wooq56 said:
How to do that ?
Click to expand...
goto WarZ Db ->Programmability -> Stored Procedures -> dbo.WZ_Char_SRV_SetStatus -> Modify -> Delete all data and paste the query that lukasccb has given you -> Press F5... and !wuala!

if you still don't know how to do it
please Press the bottom "Kill YourSelf"
 
Upvote 0
W

Wooq56

Newbie Spellweaver
Joined
Aug 21, 2014
Messages
8
Reaction score
0
Bombillo said:
goto WarZ Db ->Programmability -> Stored Procedures -> dbo.WZ_Char_SRV_SetStatus -> Modify -> Delete all data and paste the query that lukasccb has given you -> Press F5... and !wuala!

if you still don't know how to do it
please Press the bottom "Kill YourSelf"
Click to expand...

Wooq56 - [HELP] Kick from server - RaGEZONE Forums


Hey
 
Upvote 0
LukasCCB

LukasCCB

01001100 01000011 01000011 01000010
Loyal Member
Discord 1000 Posts Got A Reaction 10 Happy Years Notable Release
Joined
Apr 23, 2013
Messages
1,172
Reaction score
1,797
Wooq56 said:
Wooq56 - [HELP] Kick from server - RaGEZONE Forums


Hey
Click to expand...

Change DROP for ALTER

-- ----------------------------
-- Procedure structure for [dbo].[WZ_Char_SRV_SetStatus]
-- ----------------------------
ALTER PROCEDURE [dbo].[WZ_Char_SRV_SetStatus]
GO
ALTER PROCEDURE [dbo].[WZ_Char_SRV_SetStatus]
@in_CustomerID int,
@in_CharID int,
@in_Alive int,
@in_GamePos varchar(256),
@in_GameFlags int,
@in_Health float,
@in_Hunger float,
@in_Thirst float,
@in_Toxic float,
@in_TimePlayed int,
@in_XP int,
@in_Reputation int,
@in_GameDollars int,
@in_Stat00 int,
@in_Stat01 int,
@in_Stat02 int,
@in_Stat03 int,
@in_Stat04 int,
@in_Stat05 int,
@in_ResWood int = 0,
@in_ResStone int = 0,
@in_ResMetal int = 0,
@in_CharData varchar(4000) = ''
AS
BEGIN
SET NOCOUNT ON;

--
-- this function should be called only by server, so we skip all validations
--

-- record last game update and update GameDollars with DELTA value
update UsersData set GameDollars=(GameDollars+@in_GameDollars), lastgamedate=GETDATE() where CustomerID=@in_CustomerID

if(@in_GameDollars > 0) begin
insert into DBG_GDLog (RecordTime, CustomerID, CharID, GameDollars)
values (GETDATE(), @in_CustomerID, @in_CharID, @in_GameDollars)
end


-- update basic character data
update UsersChars set
GamePos=@in_GamePos,
GameFlags=@in_GameFlags,
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

-- update generic character data (if provided)
if(@in_CharData <> '')
update UsersChars set CharData=@in_CharData where CharID=@in_CharID


-- update resources
update UsersData set ResWood=@in_ResWood, ResStone=@in_ResStone, ResMetal=@in_ResMetal where CustomerID=@in_CustomerID

if(@in_Alive = 0) begin
update UsersChars set DeathUtcTime=GETUTCDATE() where CharID=@in_CharID
-- set default backpack on death
update UsersChars set BackpackID=20176, BackpackSize=12 where CharID=@in_CharID
-- delete stuff from backpack
delete from UsersInventory where CustomerID=@in_CustomerID and CharID=@in_CharID


exec DBG_StoreApiCall 'Death', 0, @in_CustomerID, @in_CharID
end


select 0 as ResultCode
END


GO
 
Upvote 0
You must log in or register to reply here.

About Us

RaGEZONE® is a website dedicated to the development of massively multiplayer online role-playing games (MMORPGs).

Online statistics

Members online
124
Guests online
11,774
Total visitors
11,898
Totals may include hidden visitors.

Forum statistics

Threads
429,198
Messages
4,590,913
Members
281,305
Latest member
ismodev
Most visitors online was 12720 , on 2 May 2024

RaGEZONE Sponsor

    HyperFilter
Back
Top