SQL needed that re-add/heals crashed vehicles for donators?

[NuFaN 5]

i now use this, but i rather have an event that does this for me!

DELETE FROM `vehicle` WHERE `id` = 107;
INSERT INTO `vehicle` (`id`, `class`, `spawned_at`, `account_uid`, `is_locked`, `fuel`, `damage`, `hitpoints`, `position_x`, `position_y`, `position_z`, `direction_x`, `direction_y`, `direction_z`, `up_x`, `up_y`, `up_z`, `cargo_items`, `cargo_magazines`, `cargo_weapons`, `cargo_container`, `pin_code`) VALUES ('107', 'O_MRAP_02_hmg_F', '2015-10-24 10:36:45', '76561198077053361', '-1', '1', '0', '[["HitLFWheel",0],["HitLF2Wheel",0],["HitRFWheel",0],["HitRF2Wheel",0],["HitReserveWheel",0],["HitFuel",0],["HitEngine",0],["HitBody",0],["HitGlass1",0],["HitGlass2",0],["HitGlass3",0],["HitGlass4",0],["HitGlass5",0],["HitGlass6",0],["HitGlass7",0],["HitGlass8",0],["HitGlass9",0],["HitGlass10",0],["HitGlass11",0],["HitRGlass",0],["HitLGlass",0],["HitLBWheel",0],["HitLMWheel",0],["HitRBWheel",0],["HitRMWheel",0]]', '2740.853516', '22091.515625', '-0.0762691', '0.566101', '-0.823725', '-0.0317383', '0.016307', '-0.0273038', '0.999494', '[[],[]]', '[]', '[]', '[]', '2077');

Also when it is allready deleted it should just insert. cause it prob hangs on delete now!

Edited October 25, 2015 by NuFaN

[DeathBinder 7]

I'm using a custom build of a garage system kinda like altis life has I'll ask my co admin if can put it on here was his idea.

Idea is on restart all player cars are saved to DB and not map spawned untill a player request it at flag

[Paul 104]

But why would you want to? Surely that then makes is that the donors dont have to work for anything.

If I crash a vehicle on our server, we buy another. If you have to work to buy that new vehicle, then so be it.

[- VJ - 13]

https://www.bistudio.com/monetization

Some told me the other day if you are caught monetizing your server by BI that can turn you battleye off 

Just a head up   

Edited October 26, 2015 by - VJ -

[Paul 104]

I think it depends on what you're donating for. If you're donating towards the clan and get extra benefits for it, you're fine. If you're buying perks specifically in the game, then that's not allowed. That's how I've always understood it, anyway.

[second_coming 836]

I think it depends on what you're donating for. If you're donating towards the clan and get extra benefits for it, you're fine. If you're buying perks specifically in the game, then that's not allowed. That's how I've always understood it, anyway.

It doesn't matter how you word it, paying and receiving items in game is only allowed if you get the go ahead from Bohemia.

[Paul 104]

That would surely mean that anyone who owns a clan is breaking the rules? I pay to be in our clan. I get 'benefits' for my role (server admin) in the way of admin tools and being able to spawn things. We look after our members as well and happily give them things if they need them which we wouldn't necessarily give to other non-clan players

[Paul 104]

In fact, it doesn't actually matter. From BI's site:

• Charging players to access your server, if the fees and associated perks do not affect gameplay in any way, is allowed. Cosmetic perks are allowed. Limiting access to only paying players is allowed.
• Product placement, in-game advertising and sponsorship is allowed.
• Selling of in-game items, that don’t affect gameplay, is allowed.
• Accepting donations is allowed, but to avoid any doubts: not providing donations must not prevent anyone from accessing the content.

Original Page: https://www.bistudio.com/monetization 

[- VJ - 13]

I think it depends on what you're donating for. If you're donating towards the clan and get extra benefits for it, you're fine. If you're buying perks specifically in the game, then that's not allowed. That's how I've always understood it, anyway.

Then the question is...

what "extra benefits" are you/your clan getting?

[Paul 104]

Well, we dont really get extras. We pay to be a member of the clan anyway to help us pay for the dedicated server which we rent. But it our players need help in game we'll happily TP them back to their bodies. Give them guns where needed, repair their stuff when the break it, give them build boxes sometimes. All are considered game changes 'extras'