SabarTooth14

kind of had a discovery today, seems my loadouts are working from the map tool, certain players can not get in and in bercon i keep seeing this msg when new players who cant get in join up (2013-03-02 | 02:08:54) : Player #0 playername (player ip) connected (2013-03-02 | 02:08:55) : Player #0 playername - GUID: player guid (unverified) (2013-03-02 | 02:08:55) : Verified GUID (player guid) of player #0 playername (2013-03-02 | 02:09:15) : Could not connect to BE Master (2013-03-02 | 02:09:15) : Update attempt failed (2013-03-02 | 02:10:38) : Player #0 playername disconnected so now im thinking its a battleye problem, anyone ever seen this before?? Ive also been thinking of switching over to TheSilentWarrior antihax, gettin rid of BE, im hopping it could be a nice fix and tsw's on like 10euros and it looks like a really nice tool

still lost the cust loadouts and those arnt working and new players cant get in. thats really the big one im working on now, seems like the tents are working fine now the values are adjusted

actually kind of informative, my values are set to 0 on mine, may be my issue aswell, atleast for the tents that is, shall test it later to see if it helps dump the info to php

2013-02-27 16:42:41 Database: [Error] Error 1054 (Unknown column 'Hitpoints' in 'field list') in MySQLQuery SQL: 'select iv.id as id, v.class_name, 0 as owner_id, iv.worldspace, iv.inventory, iv.parts, iv.fuel, iv.damage from `instance_vehicle` iv join `world_vehicle` wv on iv.`world_vehicle_id` = wv.`id` join `vehicle` v on wv.`vehicle_id` = v.`id` where iv.`instance_id` = 1277 union select id.`unique_id`, d.`class_name`, id.`owner_id`, id.`worldspace`, id.`inventory`, `Hitpoints`, `Fuel`, `Damage` from `instance_deployable` id inner join `deployable` d on id.`deployable_id` = d.`id` where id.`instance_id` = 1277 AND `deployable_id` IS NOT NULL' 2013-02-27 16:42:41 Database: [Error] Failed to fetch objects from database 2013-02-27 22:38:34 Database: [Error] Error 1406 (Data too long for column 'hitpoints' at row 1) in MySQLStmtExecute SQL: 'insert into `instance_deployable` (`unique_id`, `deployable_id`, `owner_id`, `instance_id`, `worldspace`, `inventory`, `Damage`,`Hitpoints`, `Fuel`, `created`) select ?, d.id, ?, ?, ?, ?, ?, ?, ?, CURRENT_TIMESTAMP from deployable d where d.class_name = ? VALUES(LOCATION NUMBERS, 753, 1277, "[LOCATION NUMBERS]]", "[]", 0, "[]", 0, "TentStorage")' These are the 3 i found in the respective dates of the incident, nothing showing an Error for the 28th, Im not the best with this stuff and ive pretty much been teaching myself Php I have a guess on what this means, but its still only a guess, Ill wait till the log updates and check again for todays. the other thing about the log though is I'm not seeing a lot of errors around the player stuff but a lot of "pass" logs heres an example: 2013-02-28 20:52:48 HiveExt: [information] Method: 101 Params: 87486086:1277:Uriah: 2013-02-28 20:52:48 HiveExt: [information] Created a new player 87486086 named 'Uriah' 2013-02-28 20:52:49 HiveExt: [information] Created a new character 2024 for player 'Uriah' (87486086) 2013-02-28 20:52:49 HiveExt: [information] Result: ["PASS",true,"2024",[],[["ItemFlashlight","ItemCompass","ItemKnife","Makarov","ItemMap"],["ItemBandage","ItemBandage","FoodCanPasta","8Rnd_9x18_Makarov","8Rnd_9x18_Makarov","8Rnd_9x18_Makarov","8Rnd_9x18_Makarov","ItemSodaCoke","ItemBandage","ItemBandage"]],["DZ_Assault_Pack_EP1",[[],[]],[[],[]]],[0,0,0],"",0.96] 2013-02-28 20:52:49 HiveExt: [information] Method: 999 Params: select replace(cl.`inventory`, '"', '""') inventory, replace(cl.`backpack`, '"', '""') backpack, replace(coalesce(cl.`model`, 'Survivor2_DZ'), '"', '""') model from `cust_loadout` cl join `cust_loadout_profile` clp on clp.`cust_loadout_id` = cl.`id` where clp.`unique_id` = '?':[87486086]: 2013-02-28 20:52:49 HiveExt: [information] Result: ["Land_SS_hangar","[10,[19898.8,12800.8,0.001]]"] 2013-02-28 20:52:49 HiveExt: [information] Method: 102 Params: 2024: 2013-02-28 20:52:49 HiveExt: [information] Result: ["PASS",[false,false,false,false,false,false,false,12000,[],[0,0],0],[0,0,0,0],["","aidlpercmstpsnonwnondnon_player_idlesteady04",36],[],2500] 2013-02-28 20:52:51 HiveExt: [information] Method: 201 Params: 2024:[0,[11104.6,2963.55,0]]:[]:[]:[false,false,false,false,false,false,false,12000,[],[0,0],0,[0,0]]:false:false:0:0:37633:0:[,aidlpercmstpslowwrfldnon_player_0s,100]:0:0:Survivor2_DZ:0: 2013-02-28 20:52:51 HiveExt: [information] Result: ["PASS"] 2013-02-28 20:53:56 HiveExt: [information] Method: 201 Params: 2024:[6,[11104.6,2963.55,0.002]]:[[itemFlashlight,ItemCompass,ItemKnife,Makarov,ItemMap],[itemBandage,ItemBandage,FoodCanPasta,8Rnd_9x18_Makarov,8Rnd_9x18_Makarov,8Rnd_9x18_Makarov,8Rnd_9x18_Makarov,ItemSodaCoke,ItemBandage,ItemBandage]]:[DZ_Assault_Pack_EP1,[[],[]],[[],[]]]:[false,false,false,false,false,false,false,12000,[],[0,0],0,[0,0]]:false:false:0:0:0:1:[,amovpercmstpslowwrfldnon_player_idlesteady02,100]:0:0::0: 2013-02-28 20:53:56 HiveExt: [information] Result: ["PASS"] 2013-02-28 20:53:56 HiveExt: [information] Method: 103 Params: 87486086:2024:2: 2013-02-28 20:53:56 HiveExt: [information] Result: ["PASS"]

i know, now, im still having some problems though, new tents laid are not dumping into the instance_deployable table, it keeps saying its empty, also when i try to manually add one it just crashes the server. The other weird prob im having aswell is somewhere in the process of doing this all the tables for cust loadouts got wiped (beats me how, never touched them) when i make a new one with the map tool it also wont dump in to php, worst part about it is no new ppl can join the server, anyone who has been on previously is good, anyone got any ideas before i send off the ticket? lol

yeah thats how i did it, just blanked and didnt see the add thing at the bottom. anyway added them fine, but im getting the crash. no msg recieved when i join, im trying to get it working now with out doing a data base wipe, if so, any idea if exporting the table and wiping them importing them will work? or maybe can just wipe the instance_deployables without vehicles and survivor, dont want to lose everything i have a few regulars who have quite a bit ***Edit**** Got it working, had to wipe the instance_deployable table only, and now everythings working at the loss of tents and wire runs I have not tried to import the backup i exported but i have a feeling when i do itll crash again, just going to manually add the tents from a pdf i exported as well, should keep most of the players happy

so i thought i was pretty good php but i cant figure out how to add these columns I thought there was an easy was to do it without SQL like through insert, but i must be dreaming, can anyone help me figure it out ***Edit Found the easy way to add them but Rid, your posts get a little fuzzy about the columns, does only the hitpoints need to be varchar and the other 2 int or just do all 3 as varchar? ** anyway so i added them hp is Varchar and damage and fuel set to int defaults set to null and i checked the null box Values all had to have a number so i put 0 testing in server now