Jump to content

Youpala

Member
  • Content Count

    10
  • Joined

  • Last visited

  • Medals

  • Medals

Posts posted by Youpala


  1. Hi Torndeco, I recently came back to Arma 3 to develop a mission using extDB3 and i got kinda confused when i tried to retrieve Char values from the database; They're not wrapped with commas like they used to in extDB2, Even after using the 'TEXT' & 'TEXT2' options. I wanted to know if it was a design choice and if it possible to have this feature in the next update ?

     

    0 call BIS_fnc_recompile;
    
    [] call WAR_fnc_dbAPIReset;
    ["Warzone_Dev"] call WAR_fnc_dbAddDatabase;
    ["Warzone_Dev","SQL","Warzone_Dev_SQL","TEXT2-NULL"] call WAR_fnc_dbAddDatabaseProtocol;
    //["Warzone_Dev_SQL","SELECT * FROM player"] call WAR_fnc_dbQuery;
    var = "extdb3" callExtension "0:Warzone_Dev_SQL:SELECT * FROM player";
    
    /*
    --- Query's return :
    [1,[[1,76561197995843303,Name,NameProfile,NameSteam,'Description',...
    
    --- Should be :
    [1,[[1,'76561197995843303','Name','NameProfile','NameSteam','Description',...
    
    --- Table construction :
    CREATE TABLE Player(
            ID          INT UNSIGNED Auto_increment  NOT NULL ,
            UID         CHAR (17) NOT NULL ,
            Name        CHAR (31),
            NameProfile CHAR (31),
            NameSteam   CHAR (31),
            Description Varchar (1023),
            FirstName   CHAR (31),
            LastName    CHAR (31),
            Email       CHAR (254),
            Fund        FLOAT ,
            ID_Object_Player INT UNSIGNED,
            ID_Object_Inventory INT UNSIGNED,
            PRIMARY KEY (ID ) ,
            UNIQUE (UID )
    )ENGINE=InnoDB;

     

    Youpala.


  2. You're maybe right then. There must be a problem with the server not creating a unit or not assigning the created unit to the player. You should try something : Create a unit and switch to it via scripts.

    _unit = "O_Soldier_F" createVehicle positionCameraToWorld[0,0,0];
    _unit allowDamage false;
    selectPlayer _unit;
    
    hint format["Unit created : %1 | Unit is player : %2",isNull _unit, _unit == player];

    Do it from the debug console and execute it localy.


  3. I noticed that the maximum character count the format command can output is 8191. Its a really annoying engine limitation as you can get a lot more with the + command.

     

    A code to test in the debug console : 

    a=[]; for "_i" from 1 to 5E4 do {a pushback 48};
    
    a = toString a;
    b = format["%1",a];
    
    hint format ["Format command : %1 chars | Workaround : %2 chars",count b, count a];
    

  4. I had this issue on my server too. Everytime I let the server run for too long. All players spawned as a seagull. I also noticed that when it occured. I couldn't spawn any East unit from Zeus. However there wasn't a lot of unit on the server. 

     

    In fact, this "seagull" problem occurs when Arma has reach the group count limit. That's why it doesn't allow the player to spawn. All you need to do is execute this :

    {if !(count units group > 0) then {deleteGroup _x}} foreach 
    

    I think its time for BIS to raise some engine limits as hardwares get faster and faster.

     

    PS: I see in your video that there are some patrolling groups. Are they placed in 3den or are they spawned in a script ?


  5. Hello Bi Forum !

    I come today because i've got some various problem with the first addon im creating.

    Today i figured out how to import a 3D model ingame. I followed some tut's and I came up with this :

    http://puu.sh/2sbgL (759 kB)

    http://puu.sh/2sbgE (759 kB)

    We can see hands through the gun

    And we can also see the muzzleflash even when not shooting

    http://puu.sh/2sbgY (926 kB)

    Shadowing issues + the fact bullet collision works (not everywhere), but not the collision box itself...

    Hope you can find the solution

    -Youp

×