Jump to content
Sign in to follow this  

Recommended Posts

use this in WHERE clause


regarding to time,
un-updated for 4 days   : LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 4 DAY)
un-updated for 14 days : LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY)

regarding to key,
without key : `CharacterID` = 0
with key       : `CharacterID` <> 0

(If you can't understand how to use them, read textbooks about SQL)

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

  • Similar Content

    • By 2DayZ2Retirement
      -PROBLEM SOLVED-
       
      G'day, Survivors.
      I am having an issue on my server where vehicles which spawn randomly around the map repair themselves upon server restart.
      I use this config in my init.sqf which successfully spawns the vehicles in damaged and with low fuel...
      DynamicVehicleDamageLow = 75;
      DynamicVehicleDamageHigh = 100;
      DynamicVehicleFuelLow = 0;
      DynamicVehicleFuelHigh = 25;
      ...However upon each server restart the vehicles repair themselves (the fuel remains low however) and for the life of me I can't figure out why this is happening. 
      DayZ Version -DayZ Epoch 1.0.6.2
      Scripts Used -DZAI | -DZMS | -Right Click Actions (Suicide, Smoke Drugs, GPS Scan)
      AntiHack - InfiSTAR
      Server Host - GTXGaming
      My HiveEXT.log and arma2oaserver.RPT logs are not showing anything out of the ordinary.
      I'm not sure if it matter, but all Planes/Helicopters and Boats have been removed from the server via the dynamic_vehicle.sqf.
      In addition, all of the traders and trader cities being removed by removing the call for the CfgServerTrader.hpp in the description.ext.
      If there is any other info I can show to assist in fixing this problem please let me know, any help would be greatly appreciated.
      Cheers.
    • By rocalpha
      Bonjour, j’écris aujourd’hui parce que j’aimerais savoir si vous ne pourrez pas m'aider. Je loue un serveur via gportal et j’aimerais pouvoir être mon serveur en PvE, mais aussi créer des éléments de base pour la connexion et des choses simples comme . J'ai un autre problème lorsque j'achète une voiture chère à pied cela me met une flèche rouge puis rien non aucun véhicule il apparait qu'après un redémarrage du serveur
    • By sjd6795
      Having issues with the epoch events, I don't seem to be getting my correct schedule timing the way I have it setup I should be getting an event spawn at 5 minutes and then another event spawn every 30, 5, and 20 minutes right?
       
      EpochEvents = [["any","any","any","any",5,"event1"],["any","any","any","any",35,"event1"],["any","any","any","any",5,"event2"],["any","any","any","any",10,"event2"],["any","any","any","any",5,"event3"],["any","any","any","any",25,"event3"]];
       
      So with event number 2 it seems to spawn the first one around 5 minutes and then the other one around 10 minutes but it doesn't continue to spawn after the first two initial ones.
       
       
    • By Warburgg
      I installed the dynamic climate script and it happens that it rains on the server but only lasts 10 seconds and stops. Is it because I use the script that speeds server time? I currently use Control Time which allows the server to have 2 hours of day and 1 hour night.
      The other climates such as overcast and fog last the forecast time 5-20 minutes but the rain does not.
      In my logs show: 16:52:30 "39:2 Debug: Rain set to 0.92421 for 10.6582 minutes". It rains until it rains but soon stops.
    • By Hanse
      Hello i am knew to this and i need someone to show me the ropes
      Steam
      IGN:Hanse
  • Advertisement
  • Supporters
  • Discord

×
×
  • Create New...