Origins Server?

HI . do you guys know . how to make battleye working ?

i am using P server to start server . and the battleys is not working . when i allow battleye . no one can join the server.
 
Drew Reid said:
1) Make sure you are executing pCleanup & pMain when your server starts

2) Make sure there are no invalid values in your Database
Click to expand...
i get this when i run pMain
MySQL said: #1054 - Unknown column 'Inventory' in 'field list'

All my choppers/aircrafts dissapered when i did run the cleanups :D

Any tip on how to get back all my vehicles but not cleaning out them i already have?
 
AlexHjelm said:
i get this when i run pMain
MySQL said: #1054 - Unknown column 'Inventory' in 'field list'

All my choppers/aircrafts dissapered when i did run the cleanups :D

Any tip on how to get back all my vehicles but not cleaning out them i already have?
Click to expand...


use this sql file

https://www.dropbox.com/s/vlv6olvegx7bk8b/origins.sql

It´s already fixed and has an additional table character_data_dead and a function pMoveDead i use for statistics. Please note that i have called the database "origins" instead of "dayz_origins".
 
AlexHjelm said:
Ye but i dont wanna remove all my players.
Click to expand...
create an export of your existing data and reimport just the "insert into"´s afterwards.

You can also manually add the missing fields Inventory (Longtext) and Hitpoints (Varchar) to the table object_data.
I made fix for pMain to spawn vehicles after they got destroyed with empty inventory

Code: 
BEGIN
 
DECLARE sInstance VARCHAR(8) DEFAULT '1';
 
DECLARE iVehSpawnMax INT DEFAULT 387;
 
DECLARE iTimeoutMax INT DEFAULT 450;
DECLARE iTimeout INT DEFAULT 0;
DECLARE iNumVehExisting INT DEFAULT 0;
DECLARE iNumClassExisting INT DEFAULT 0;
DECLARE i INT DEFAULT 1;
 
 
CALL pCleanup();
 
SELECT COUNT(*)
    INTO iNumVehExisting
FROM object_data
    WHERE Instance = sInstance
        AND Classname != 'Hedgehog_DZ'
        AND Classname != 'Wire_cat1'
        AND Classname != 'Sandbag1_DZ'
        AND Classname != 'TrapBear'
        AND Classname != 'TentStorage'
        AND Classname != 'TentStorageR' AND
        Classname != 'wooden_shed_lvl_1' AND
        Classname != 'log_house_lvl_2' AND
        Classname != 'wooden_house_lvl_3' AND
        Classname != 'large_shed_lvl_1' AND
        Classname != 'small_house_lvl_2' AND
        Classname != 'big_house_lvl_3' AND
        Classname != 'small_garage' AND
        Classname != 'big_garage' AND
        Classname != 'object_x';
 
WHILE (iNumVehExisting < iVehSpawnMax) DO
 
 
    SELECT Classname, Chance, MaxNum, Damage
    INTO @rsClassname, @rsChance, @rsMaxNum, @rsDamage
    FROM object_classes ORDER BY RAND() LIMIT 1;
 
 
    SELECT COUNT(*)
    INTO iNumClassExisting
    FROM object_data
    WHERE Instance = sInstance
    AND Classname = @rsClassname;
 
    IF (iNumClassExisting < @rsMaxNum) THEN
        IF (rndspawn(@rschance) = 1) THEN
            INSERT INTO `object_data` (ObjectUID, Instance,Classname, Damage, CharacterID, Worldspace, Inventory, Hitpoints, Fuel, Datestamp)
        SELECT ot.ObjectUID, '1', ot.Classname, ot.Damage, '0', ot.Worldspace, '[]', ot.Hitpoints, '0.01', SYSDATE()
            FROM (SELECT oc.Classname, oc.Chance, oc.MaxNum, oc.Damage, oc.Hitpoints, os.ObjectUID, os.Worldspace
                FROM object_classes AS oc
                INNER JOIN `object_spawns` AS os
                ON oc.Classname = os.Classname
                ORDER BY RAND()) AS ot
            WHERE NOT EXISTS (SELECT od.ObjectUID
                            FROM `object_data` AS od
                            WHERE ot.ObjectUID = od.ObjectUID)
            AND fGetClassCount(ot.Classname) < ot.MaxNum
            AND fGetSpawnFromChance(ot.Chance) = 1
            LIMIT 1;
 
            SELECT COUNT(*)
            INTO iNumVehExisting
            FROM object_data
            WHERE Instance = sInstance
            AND Classname != 'Hedgehog_DZ'
            AND Classname != 'Wire_cat1'
            AND Classname != 'Sandbag1_DZ'
            AND Classname != 'TrapBear'
            AND Classname != 'TentStorage'
            AND Classname != 'TentStorageR' AND
            Classname != 'wooden_shed_lvl_1' AND
            Classname != 'log_house_lvl_2' AND
            Classname != 'wooden_house_lvl_3' AND
            Classname != 'large_shed_lvl_1' AND
            Classname != 'small_house_lvl_2' AND
            Classname != 'big_house_lvl_3' AND
            Classname != 'small_garage' AND
            Classname != 'big_garage' AND
            Classname != 'object_x'; 
 
         
            SELECT COUNT(*)
            INTO iNumClassExisting
            FROM object_data
            WHERE Instance = sInstance
            AND Classname = @rsClassname;
 
        END IF;
    END IF; 
 
    SET iTimeout = iTimeout + 1;
    IF (iTimeout >= iTimeoutMax) THEN
        SET iNumVehExisting = iVehSpawnMax;
    END IF;
END WHILE;
SET i = i + 1;
END
 
Sharkking said:
create an export of your existing data and reimport just the "insert into"´s afterwards.

You can also manually add the missing fields Inventory (Longtext) and Hitpoints (Varchar) to the table object_data.
I made fix for pMain to spawn vehicles after they got destroyed with empty inventory

Code: 
BEGIN
 
DECLARE sInstance VARCHAR(8) DEFAULT '1';
 
DECLARE iVehSpawnMax INT DEFAULT 387;
 
DECLARE iTimeoutMax INT DEFAULT 450;
DECLARE iTimeout INT DEFAULT 0;
DECLARE iNumVehExisting INT DEFAULT 0;
DECLARE iNumClassExisting INT DEFAULT 0;
DECLARE i INT DEFAULT 1;
 
 
CALL pCleanup();
 
SELECT COUNT(*)
    INTO iNumVehExisting
FROM object_data
    WHERE Instance = sInstance
        AND Classname != 'Hedgehog_DZ'
        AND Classname != 'Wire_cat1'
        AND Classname != 'Sandbag1_DZ'
        AND Classname != 'TrapBear'
        AND Classname != 'TentStorage'
        AND Classname != 'TentStorageR' AND
        Classname != 'wooden_shed_lvl_1' AND
        Classname != 'log_house_lvl_2' AND
        Classname != 'wooden_house_lvl_3' AND
        Classname != 'large_shed_lvl_1' AND
        Classname != 'small_house_lvl_2' AND
        Classname != 'big_house_lvl_3' AND
        Classname != 'small_garage' AND
        Classname != 'big_garage' AND
        Classname != 'object_x';
 
WHILE (iNumVehExisting < iVehSpawnMax) DO
 
 
    SELECT Classname, Chance, MaxNum, Damage
    INTO @rsClassname, @rsChance, @rsMaxNum, @rsDamage
    FROM object_classes ORDER BY RAND() LIMIT 1;
 
 
    SELECT COUNT(*)
    INTO iNumClassExisting
    FROM object_data
    WHERE Instance = sInstance
    AND Classname = @rsClassname;
 
    IF (iNumClassExisting < @rsMaxNum) THEN
        IF (rndspawn(@rschance) = 1) THEN
            INSERT INTO `object_data` (ObjectUID, Instance,Classname, Damage, CharacterID, Worldspace, Inventory, Hitpoints, Fuel, Datestamp)
        SELECT ot.ObjectUID, '1', ot.Classname, ot.Damage, '0', ot.Worldspace, '[]', ot.Hitpoints, '0.01', SYSDATE()
            FROM (SELECT oc.Classname, oc.Chance, oc.MaxNum, oc.Damage, oc.Hitpoints, os.ObjectUID, os.Worldspace
                FROM object_classes AS oc
                INNER JOIN `object_spawns` AS os
                ON oc.Classname = os.Classname
                ORDER BY RAND()) AS ot
            WHERE NOT EXISTS (SELECT od.ObjectUID
                            FROM `object_data` AS od
                            WHERE ot.ObjectUID = od.ObjectUID)
            AND fGetClassCount(ot.Classname) < ot.MaxNum
            AND fGetSpawnFromChance(ot.Chance) = 1
            LIMIT 1;
 
            SELECT COUNT(*)
            INTO iNumVehExisting
            FROM object_data
            WHERE Instance = sInstance
            AND Classname != 'Hedgehog_DZ'
            AND Classname != 'Wire_cat1'
            AND Classname != 'Sandbag1_DZ'
            AND Classname != 'TrapBear'
            AND Classname != 'TentStorage'
            AND Classname != 'TentStorageR' AND
            Classname != 'wooden_shed_lvl_1' AND
            Classname != 'log_house_lvl_2' AND
            Classname != 'wooden_house_lvl_3' AND
            Classname != 'large_shed_lvl_1' AND
            Classname != 'small_house_lvl_2' AND
            Classname != 'big_house_lvl_3' AND
            Classname != 'small_garage' AND
            Classname != 'big_garage' AND
            Classname != 'object_x';
 
       
            SELECT COUNT(*)
            INTO iNumClassExisting
            FROM object_data
            WHERE Instance = sInstance
            AND Classname = @rsClassname;
 
        END IF;
    END IF;
 
    SET iTimeout = iTimeout + 1;
    IF (iTimeout >= iTimeoutMax) THEN
        SET iNumVehExisting = iVehSpawnMax;
    END IF;
END WHILE;
SET i = i + 1;
END
Click to expand...

I did import your file, seems that all the characters is still there and the other stuff.
 
^ what sharkking said is probably the best way to go about it.

Also...

overview.png

Marks Origin Mod AI with debug (shows AI tracking on map)
Download here

Marks Origin Mod AI without debug (doesn't show AI tracking on map)
Download here

I can only provide limit support on it, use it as you like.
 
Drew Reid said:
^ what sharkking said is probably the best way to go about it.

Also...


Marks Origin Mod AI with debug (shows AI tracking on map)
Download here

Marks Origin Mod AI without debug (doesn't show AI tracking on map)
Download here

I can only provide limit support on it, use it as you like.
Click to expand...

Wont that destroy our servers with even more AIs?

Btw, my choppers/airplanes still dont re-spawn.
 
AlexHjelm said:
Btw, my choppers/airplanes still dont re-spawn.
Click to expand...
how many vehicles do you have on your server?
because the pMain limits them to 387
the vehicles arent respawning until your vehicle count is lower than the limit...
you can try and set the limit higher...
 
AlexHjelm said:
Wont that destroy our servers with even more AIs?

Btw, my choppers/airplanes still dont re-spawn.
Click to expand...

destroying as in using system resources?
SAR AI running on any other server can handle, with AI on Salvo, it only slightly increases load, not system but bandwidth resources.

Although we've been getting lots of malicious attacks on our server which sucks too
 
Drew Reid said:
^ what sharkking said is probably the best way to go about it.

Also...


Marks Origin Mod AI with debug (shows AI tracking on map)
Download here

Marks Origin Mod AI without debug (doesn't show AI tracking on map)
Download here

I can only provide limit support on it, use it as you like.
Click to expand...

many thanks for sharing this.
As far i have ssen from the tests it just adds new AI but does not replace the old one ? I disabled the Origins AI but then eg Salvation is empty
 
.=QUACK=.Major.Pain said:
Your dayz_server.pbo didn't pack properly.
Did you use Pbo Manager? cpbo seems to cause too many issue.
Click to expand...

I tried to do that with PBOManager and other tools, but the result was the same.
I will be grateful if we continue to chat on Skype. If necessary, I'll even pay you for your time. I would be very grateful, my skype: zaxarko4.
 
Dmitry said:
I tried to do that with PBOManager and other tools, but the result was the same.
I will be grateful if we continue to chat on Skype. If necessary, I'll even pay you for your time. I would be very grateful, my skype: zaxarko4.
Click to expand...

you need to set the prefix correctly
for dayz_server it would be
z\addons\dayz_server
 
Hey guys, im using cortez´s files and i can no longer change my inventory in mysql, whenever i do it and save it reverts when i log back in to the game, is there anyway to fix this?
 
Dmitry said:
I tried to do that with PBOManager and other tools, but the result was the same.
I will be grateful if we continue to chat on Skype. If necessary, I'll even pay you for your time. I would be very grateful, my skype: zaxarko4.
Click to expand...


I will just put a working copy in the git to save people any issues.
They folder can then be used to reference the file contained in it.
 
You must log in or register to reply here.
Back
Top