Sign in to follow this  
Followers 0
NuFaN

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

16 posts in this topic

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

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 by NuFaN

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
Advertisement

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.

2 people like this

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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'

Share this post


Link to post
Share on other sites
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.