Pwnozor DAYZ PSP 1.7.3 Vehicles doesnt spawn

[ashkart]

Hi! Ive set Pwnozor DAYZ PSP 1.7.3 and Vehicles didnt spawn .
Or i cant see them. What the reason can be? ((((

in db table "objects_data" are 18 vehicles, but no one can see one. I placed myself on some different cordinates from table, but it was empty place(

 

[shinkicker]

Do you have the instance set correctly?

 

[ashkart]

yes i did. everywhere is "1".
PS: in older server versions in vehicles table it was "222"

 

[shinkicker]

Also check in pSpawn as its hardcoded in there:

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;

 

[Guidez]

The issue is with pMain.

Current:

CREATE DEFINER=`root`@`` PROCEDURE `pMain`()
BEGIN
 
    DECLARE iSpawnNumVeh SMALLINT(3) DEFAULT 11;   
 
    CALL pCleanup();
    CALL pFixMaxNum;
 
    SELECT SUM(MaxNum) FROM object_classes INTO @iMaxNumTotal;
    IF (iSpawnNumVeh < @iMaxNumTotal) THEN
        SET iSpawnNumVeh = @iMaxNumTotal;
    END IF;
 
    WHILE (fGetVehCount() < iSpawnNumVeh) DO
        CALL pSpawn();
    END WHILE;
 
END

Think it should be:

CREATE DEFINER=`root`@`` PROCEDURE `pMain`()
BEGIN
 
    DECLARE iSpawnNumVeh SMALLINT(3) DEFAULT 0;   
 
    CALL pCleanup();
    CALL pFixMaxNum;
 
    SELECT SUM(MaxNum) FROM object_classes INTO @iMaxNumTotal;
    IF (iSpawnNumVeh < @iMaxNumTotal) THEN
        SET iSpawnNumVeh = @iMaxNumTotal;
    END IF;
 
    WHILE (fGetVehCount() < iSpawnNumVeh) DO
        CALL pSpawn();
    END WHILE;
 
END

Basically, the initial spawn amount should be 0, not 11, and the "check" should see if iSpawnNumVeh is LESS then @iMaxNumTotal. Only then should iSpawnNumVeh should equal @iMaxNumTotal

 

[Guidez]

Note: I had to rename my Skoda% classname in objects_classes to just Skoda, as the script was failing as well at that point.

 

[Quarterbreed]

thers no motorcycles on 1.7.3 -1.3 pack