Jump to content

shan1784

Member
  • Posts

    9
  • Joined

  • Last visited

Posts posted by shan1784

  1. Hello Everyone,

     

    Just as the title says. I'm looking for a way to prevent someone being able to lock a vehicle when someone is currently inside the vehicle.

     

    I just added vehicles as indestructable when locked but now I have people locking the vehicle when someone is in it and then going on a rampage.

     

    I looked at the ability to make the vehicle destructable when someone is in it but haven't had any luck so now am looking to attack this from a different angle and remove the option to lock the vehicle in the first place...

     

    Any help would be appreciated.. Thank you all...

  2. Hello Everyone,

     

    Just as the title says. I'm looking for a way to prevent someone being able to lock a vehicle when someone is currently inside the vehicle.

     

    I just added vehicles as indestructable when locked but now I have people locking the vehicle when someone is in it and then going on a rampage.

     

    I looked at the ability to make the vehicle destructable when someone is in it but haven't had any luck so now am looking to attack this from a different angle and remove the option to lock the vehicle in the first place...

     

    Any help would be appreciated.. Thank you all...

  3. Our server started getting popular so we needed to find a way to remove bases and objects no longer being used by their owners... Created teh queries below. The first on is to test and see what is currenty out there, the second will remove the objects.. Could be set as an event and ran daily...

    Note - on our server we have the PlayerUID being added to the Object_DATA.CharacterID field...

    Find Objects from people that haven’t logged in in 30 days

    SELECT o.`Classname`, p.PlayerName, o.`CharacterID`, c.`LastLogin` FROM `Object_DATA` o, `Player_DATA` p, `Character_DATA` c WHERE p.`PlayerUID`=o.`CharacterID` and c.`PlayerUID`=p.`PlayerUID` and c.`Alive`=1 and o.`CharacterID` IN (SELECT `PlayerUID` FROM `Character_DATA` WHERE `Alive`='1' and DATE(`LastLogin`) < CURDATE() - INTERVAL 30 DAY)

     

     

    Remove Objects from people that haven’t logged in in 30 days

    DELETE FROM `Object_DATA` WHERE `CharacterID` IN (SELECT `PlayerUID` FROM `Character_DATA` WHERE `Alive`='1' and DATE(`LastLogin`) < CURDATE() - INTERVAL 30 DAY)

×
×
  • Create New...