Jump to content

Logan

Member
  • Posts

    174
  • Joined

  • Last visited

Posts posted by Logan

  1.  

    Are you sure you have turned events on? 

    Click the main database tab and execute these commands to see:

    SET GLOBAL event_scheduler = ON;
    SET @@global.event_scheduler = ON;
    SET GLOBAL event_scheduler = 1;
    SET @@global.event_scheduler = 1;
    

     

    SET GLOBAL event_scheduler = ON;
    SET @@global.event_scheduler = ON;
    SET GLOBAL event_scheduler = 1;
    SET @@global.event_scheduler = 1;
    /* Affected rows: 0  Found rows: 0  Warnings: 0  Duration for 4 queries: 0.000 sec. */
     
    How would I check if they are on after running? That's all it showed in the log on Heidi
     
    Just check in the options on MySQL Workbench, seems event scheduler was turned off. Just turned it on, hopefully this works, thanks!

    Is the table name object_data? For me (but using thre linux version) it's Object_DATA and table names are case sensitive.

     

    Yep, first thing I checked.

  2. Can't seem to figure out the issue with my events. Running standalone MySQL database, switched to dedicated server about 2-3 weeks ago. Getting around the time for maintenance and no one can maintain. No cars being deleted, etc, etc.

     

    All are enabled, set to every day, used the same ones on my hosted servers from Vert, no issues. 

     

    Only thing I can think causing it would be my definer 

     

    http://i.imgur.com/ZEAoI6B.png

     

    User (PoTW) has all privileges. 

     

    Everything else is working fine, no idea on the issue.

     

    EDIT: Posted in wrong section, reported to get a mod to move.

  3. Anyone who wants to remove the default Maintain Area and Maintain Area Preview, this is what you need to do.

     

    Original from NON SINGLE COIN

    	 if (_canDo && (speed player <= 1) && (_cursorTarget isKindOf "Plastic_Pole_EP1_DZ")) then {
    	 if (s_player_plotManagement < 0) then {
        _adminList = ["0152"]; // Add admins here if you admins to able to manage all plotpoles
        _owner = _cursorTarget getVariable ["CharacterID","0"];
        _friends = _cursorTarget getVariable ["plotfriends", []];
        _fuid = [];
        {
        _friendUID = _x select 0;
        _fuid = _fuid + [_friendUID];
        } forEach _friends;
        _allowed = [_owner];    
        _allowed = [_owner] + _adminList + _fuid;
        if(_owner == dayz_characterID || (getPlayerUID player) in _allowed)then{            
        s_player_plotManagement = player addAction ["<t color='#0059FF'>Manage Plot</t>", "custom\plotManagement\initPlotManagement.sqf", [], 5, false];
        };
    };
    		 if (s_player_maintain_area < 0) then {
    		  	s_player_maintain_area = player addAction [format["<t color='#ff0000'>%1</t>",localize "STR_EPOCH_ACTIONS_MAINTAREA"], "\z\addons\dayz_code\actions\maintain_area.sqf", "maintain", 5, false];
    		 	s_player_maintain_area_preview = player addAction [format["<t color='#ff0000'>%1</t>",localize "STR_EPOCH_ACTIONS_MAINTPREV"], "\z\addons\dayz_code\actions\maintain_area.sqf", "preview", 5, false];
    		 };
    	 } else {
        player removeAction s_player_plotManagement;
        s_player_plotManagement = -1;
        player removeAction s_player_maintain_area;
        s_player_maintain_area = -1;
        player removeAction s_player_maintain_area_preview;
        s_player_maintain_area_preview = -1;
    };
    

    Remove

     

    player removeAction s_player_maintain_area;
    s_player_maintain_area = -1;
    player removeAction s_player_maintain_area_preview;
    s_player_maintain_area_preview = -1;

     

    and

     

             if (s_player_maintain_area < 0) then {
                 s_player_maintain_area = player addAction [format["<t color=#ff0000'>%1</t>",localize "STR_EPOCH_ACTIONS_MAINTAREA], "\z\addons\dayz_code\actions\maintain_area.sqf", "maintain", 5, false];
                 s_player_maintain_area_preview = player addAction [format["<t color=#ff0000'>%1</t>",localize "STR_EPOCH_ACTIONS_MAINTPREV], "\z\addons\dayz_code\actions\maintain_area.sqf", "preview", 5, false];
             };

     

     

    So it looks like this. Make sure to use your own directory to your PlotManagement folder

    	 if (_canDo && (speed player <= 1) && (_cursorTarget isKindOf "Plastic_Pole_EP1_DZ")) then {
    	 if (s_player_plotManagement < 0) then {
        _adminList = ["0152"]; // Add admins here if you admins to able to manage all plotpoles
        _owner = _cursorTarget getVariable ["CharacterID","0"];
        _friends = _cursorTarget getVariable ["plotfriends", []];
        _fuid = [];
        {
        _friendUID = _x select 0;
        _fuid = _fuid + [_friendUID];
        } forEach _friends;
        _allowed = [_owner];    
        _allowed = [_owner] + _adminList + _fuid;
        if(_owner == dayz_characterID || (getPlayerUID player) in _allowed)then{            
        s_player_plotManagement = player addAction ["<t color='#0059FF'>Manage Plot</t>", "custom\plotManagement\initPlotManagement.sqf", [], 5, false];
        };
    };
    	 } else {
        player removeAction s_player_plotManagement;
        s_player_plotManagement = -1;
    };
    
  4. Tried this

     

    BEGIN
    DELETE FROM dayz_epoch.object_data
    WHERE
    Classname LIKE '%Storage",1%'
    AND object_data.LastUpdated < NOW() - INTERVAL 35 DAY;

    END

     

     

    Doesn't seem to work, tried editing it around a bit and still can't get it.

     

    Currently running the safe unlock after 25 days.

     

    Just looking for a way to delete safes and other storage after a certain amount of time.

  5. Getting kicked for a Public Variable restriction #3 when I deposit coins into the bank

     

    Not updating in banking_data but taking it away from CashMoney, started with 500,000 after testing 3 times I have 499,997

     

    I have

     

    5 "" !"PVDZE_" !"norrn" !"usec" !="remExField" !="remExFP" !="drn_AskServerDynamicWeatherEventArgs" !="norrinRAlie" !="BIS_effects_gepv" !="dayzPlayerLogin" !="dayzPlayerLogin2" !"PVAHR_" !="PVAH_AdminReq" !="PVAH_WriteLogReq" !="PVDZE_bank_Save"
     
    in my publicvariable.txt
  6. Well Zupa wasn't originally going to do it.

    No use crying over it.... If Zupa wants to release he can, its not up to us to really decided on what he should do(He is a person after all).

    Over half of the server owners here wouldn't want anyone else to have it, if it was for their server only. it's such a unique thing to have.

    Why don't you think ruubje11 or Maca wont release it either?

    Where did I say I cared if it was released or I was crying about it? Simply stating it's sad he paid to not have it released.

×
×
  • Create New...