Jump to content

JohnyMST

Member
 View Profile  See their activity

  • Posts

    208

  • Joined

  • Last visited

 Content Type 

Posts posted by JohnyMST

  3. Can we make the garage door frame a bit taller to allow the passage of cargo trucks

    in General Discussion.

    Posted

    I have placed a metal floor before and after garage doorway which stops all the bullets to go further.

    Alternatively, you can think about 2 small v-shape walls as shown in the draft below

     

    23i6p8p.jpg

     

    I have done this on one of my bases where my garage doorway was raised up 3 times.

    Players will not be able to slide under it or shoot anything behind the v-shape wall other then the wall itself.

     

    I have no trouble with entering any vehicles with this solution at all.

     

    But of course, your idea to make the gate taller is good. +1

  6. How to update SQL when entry is not showing up

    in Scripting

    Posted

    I tried your way now and still the same "Duplicate Entry" message...

     

    I ran :

    select * from traders_data where item like '%PartPlankPack%'

and

select * from traders_data where item like '%PartPlywoodPack%'

    and no values returned.

     

    Yes Revoplay, I use navicat :)

     

     

    Is there any command to REMOVE specific item from trader within the SQL?

  8. How to update SQL when entry is not showing up

    in Scripting

    Posted

    When I run the SQL query again the same as above I get the below answer from Navicat:
     

    1062 - Duplicate entry '["PartPlankPack",1]-508' for key 'item'
1062 - Duplicate entry '["PartPlankPack",1]-530' for key 'item'
1062 - Duplicate entry '["PartPlankPack",1]-662' for key 'item'
1062 - Duplicate entry '["PartPlankPack",1]-678' for key 'item'
1062 - Duplicate entry '["PartPlankPack",1]-680' for key 'item'
1062 - Duplicate entry '["PartPlywoodPack",1]-508' for key 'item'
1062 - Duplicate entry '["PartPlywoodPack",1]-530' for key 'item'
1062 - Duplicate entry '["PartPlywoodPack",1]-662' for key 'item'
1062 - Duplicate entry '["PartPlywoodPack",1]-678' for key 'item'
1062 - Duplicate entry '["PartPlywoodPack",1]-680' for key 'item'

    I cannot find the Plywood or Plank packs anywhere in my SQL after searching in every single table...
    Also I cant see entry "1062" so there is no way that there is a duplicate in there...

     

    How can I remove these "INVISIBLE" entries from my SQL database? The price is incorrect and it needs to be modified.

    Please help someone :(

  9. [SOLVED] Problem with Tow / Lift

    in Scripting

    Posted

    You sir have resolved my problem :)

     

    i'm just starting with this stuff so i'm sorry if I'm a bit annoying with my misunderstanding of some things :D

    I learn a lot I must say :)

     

    At least I have managed to add some custom buildings into my server without any issues :O progress! :D

     

    THANK YOU AXE COP

     

    Problem solved :) If anyone needs help with the same issue I am happy to go over what we done in this thread with Axe Cop

    Just let me know.

  13. Sarge AI, Side Chat, Tow and Lift issues questions and solutions

    in Server Install

    Posted

    2)

    My VonID is set as below:
    vonID = 1;

    Should this be set to 0 to show player names?

     

    Can you confirm if I should change the VONID to 0? Don't want to mess things up with this :)

     

    3)

    By missions I mean "Events" that show up on screen as "A helicopter has crashed, Kill the survivors and secure the loot" and there is a green/red dot on the map.

    When player arrives there there are NPC's with Crates of loot and 1 vehicle.

    Apologize if "Missions" is something else.

     

     

    4)
    Found the SAR_HUMANITY_HOSTILE_LIMIT and Now changed to below value:
    SAR_HUMANITY_HOSTILE_LIMIT = 50000;

    I have also changed the skill levels on the NPC's to the same as below on all of them:

        ["aimingAccuracy",0.95, 0.10], // skilltype, <min value>, <random value added to min>;
        ["aimingShake",   0.95, 0.10],
        ["aimingSpeed",   0.90, 0.20],
        ["spotDistance",  0.90, 0.30],
        ["spotTime",      0.95, 0.20],
        ["endurance",     0.90, 0.20],
        ["courage",       0.90, 0.20],
        ["reloadSpeed",   0.90, 0.20],
        ["commanding",    0.90, 0.20],
        ["general",       0.90, 0.20]

     

    It worked, NPC's are much better now :) Thank you

  15. How to update SQL when entry is not showing up

    in Scripting

    Posted

    I decided to add some Lumber and Plywood to my neutral traders with below SQL code:
     

    INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlankPack",1]', 50, '[4,"ItemSilverBar",1]', '[3,"ItemSilverBar",1]', 508, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlankPack",1]', 50, '[4,"ItemSilverBar",1]', '[3,"ItemSilverBar",1]', 530, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlankPack",1]', 50, '[4,"ItemSilverBar",1]', '[3,"ItemSilverBar",1]', 662, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlankPack",1]', 50, '[4,"ItemSilverBar",1]', '[3,"ItemSilverBar",1]', 678, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlankPack",1]', 50, '[4,"ItemSilverBar",1]', '[3,"ItemSilverBar",1]', 680, 'trade_items');

INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlywoodPack",1]', 15, '[5,"ItemSilverBar",1]', '[4,"ItemSilverBar",1]', 508, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlywoodPack",1]', 50, '[5,"ItemSilverBar",1]', '[4,"ItemSilverBar",1]', 530, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlywoodPack",1]', 50, '[5,"ItemSilverBar",1]', '[4,"ItemSilverBar",1]', 662, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlywoodPack",1]', 50, '[5,"ItemSilverBar",1]', '[4,"ItemSilverBar",1]', 678, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["PartPlywoodPack",1]', 50, '[5,"ItemSilverBar",1]', '[4,"ItemSilverBar",1]', 680, 'trade_items');

    I now would like to modify the price on them however when I run the query again, navicat says that there is a duplicate entry

    OK So I go into Traders_Data table and look for PartPlankPack or PartPlywoodPack but there is nothing there...?

    How can I edit the price on this if it's not displaying in my SQL database? I can still buy it in traders tho... Isn't this strange?

  16. Sarge AI, Side Chat, Tow and Lift issues questions and solutions

    in Server Install

    Posted

    Thanks for your reply Torndeco :)

    2)

    My VonID is set as below:
    vonID = 1;

    Should this be set to 0 to show player names?

     

    3)

    By missions I mean "Events" that show up on screen as "A helicopter has crashed, Kill the survivors and secure the loot" and there is a green/red dot on the map.

    When player arrives there there are NPC's with Crates of loot and 1 vehicle.

    Apologize if "Missions" is something else.

     

    4)
    Found the SAR_HUMANITY_HOSTILE_LIMIT and Now changed to below value:
    SAR_HUMANITY_HOSTILE_LIMIT = 50000;

    I have also changed the skill levels on the NPC's to the same as below on all of them:

        ["aimingAccuracy",0.95, 0.10], // skilltype, <min value>, <random value added to min>;
        ["aimingShake",   0.95, 0.10],
        ["aimingSpeed",   0.90, 0.20],
        ["spotDistance",  0.90, 0.30],
        ["spotTime",      0.95, 0.20],
        ["endurance",     0.90, 0.20],
        ["courage",       0.90, 0.20],
        ["reloadSpeed",   0.90, 0.20],
        ["commanding",    0.90, 0.20],
        ["general",       0.90, 0.20]

     

    This should now give me a hardcore experience LOL. Will restart soon and provide feedback how it's going!

  17. Sarge AI, Side Chat, Tow and Lift issues questions and solutions

    in Server Install

    Posted

    First of all, thank you to everyone who helped me with my server on this forum. I got so far and now the only thing that is left to do is Correct some minor issues.

     

    I have made a list of things that I need to do in order to have the server "perfectly" setup :D

     

    Green = Fixed

    Red = Not fixed

     

    1. BattlEye Restriction Kicks

    Random Kicks from the game by BattlEye with various restrictions when Lifting/Towing/Shooting etc.

     

    2. Side Chat names not displaying

    When someone uses Side Chat, I am unable to see their names so I cannot warn them in anyway. Is there a solution to this?

     

    3. No "Red" missions with Sarge AI's

    I have 2 missions per server restart (every 3h) however all of the missions are "Green" and not a single one was "Red" Yet. Is there something missing from my Sarge AI's scripts? How can I enable the red missions?

     

    4. Modify Sarge AI's Bot difficulty

    Players are able to walk and take loot in front of the AI's on the server. I want AI's to shoot players on sight. How can I change the difficulty on AI's to maximum?

     

    5. Fix Tow/Lift

    Helis seem to lift everything they see even tho my code states that they should only be able to lift planes.

    Axe Cop is currently helping me with this however let me know if you came across this before.

    Axe Cop fixed my problem. Please reach out if you have similar problems with Tow/Lift script. I will help you out as much as I can.

     

    6. Vehicles disappearing from Sarge AI missions

    The minute a player completes the AI mission, the vehicle that was spawned with the mission disappears immediately. The loot stays however only vehicles/helis are vanishing.

    How can that be fixed? I want players to have the spawned vehicles until next restart.

     

     

    If you have some ideas on the problems above please reply with the number corresponding to the issue and it's title.
    Once specific issue is solved I will mark it Green and will show How it was fixed for others that might have similar problem.

     

    Thank you in advance!!!

  18. [SOLVED] Problem with Tow / Lift

    in Scripting

    Posted

    Oh wait a minute... So if I have them in as Towable they can also be lifted?

     

    I just want to lift planes because they usually spawn in places where it is impossible to take off. Forrests etc.

     

    So I need to modify my R3F_ARTY_AND_LOG\R3F_LOG\config.sqf to the following:
    "AN2_DZ",
    "GNT_C185C",
    "GNT_C185R",
    "GNT_C185U",
    "GNT_C185",
    "C130J_US_EP1",

     

    In both, Towable AND Liftable sections, right?

     

    Do I need to have anything in the R3F_ARTY_AND_LOG.7z\R3F_ARTY_AND_LOG\R3F_LOG\addons_config file? Or can I just remove every vehicle from this file? (to avoid confusion)

  22. [SOLVED] Problem with Tow / Lift

    in Scripting

    Posted

    Thanks,

    I edited my config.sqf so Helis can only lift planes... However ingame, I can lift anything I want with a heli? ;/

     

    There has to be something else allowing players to lift everything even tho my code states clearly:
     

    /**
 * List of class names of liftables objects.
 * Liste des noms de classes des objets h�liportables.
 */
R3F_LOG_CFG_objets_heliportables = [


            "AN2_DZ",
            "C130J_US_EP1",
            "GNT_C185U",
            "GNT_C185",
            "GNT_C185R",
            "GNT_C185C"
];

    From my understanding, this should only allow players to lift the above objects.

     

    I just tried again with this and still able to lift helis/cars with other helis...

    Anyone knows where the problem is with this?

  23. [RESOLVED] Getting kicked by Battleye when someone is using restricted items

    in Server Install

    Posted

    Hi again,

     

    We were testing our new heli AH64D_EP1 and I got kicked when my buddy used the Hydras with BattlEye Restritction #17

     

    Why Am I getting kicked for using such weapons and not the player that uses it himself?

     

    Can you tell me how I can disable the restriction 17 kick?

    I got all my battleye lines set to "1" so not sure why I am still getting kicked...

     

    Can you help me figure this out? Thanks...
     

  24. Help with new Heli in Hero Camp

    in Scripting

    Posted

    Guys,

    I decided to spawn in a an Apache heli in Hero Traders with the below SQL command:
     

    INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["AH64D_EP1",1]', 15, '[7,"ItemBriefcase100oz",1]', '[3,"ItemBriefcase100oz",1]', 493, 'trade_any_vehicle');

    The Heli spawns in with Ammo and Hydras. How can I disable in the above line that heli spawns in with NO Ammunition?

    Is there some code to add to tell the database that heli should have no ammo when it spawns?

     

    Thanks a lot!

×
×
  • Create New...