Welcome Anonymous !


 


Alpha Squad US TeamSpeak Viewer

SQL Database Access and Custom Loadouts

The forum dedicated to creating missions for ARMA. Share your missions and your knowledge to others here !

SQL Database Access and Custom Loadouts

Postby Firefly_AS » Mon Aug 16, 2010 10:45 pm

In talking with Gnome awhile back, he mentioned briefly that it would be possible to setup an online webpage where users could specify kit loadouts and other features and save these. Then, in the mission we could use something like Jayarma2lib to interface with the database and grab the kit. From there, it's just a matter of making sure the missions support this. I looked into Jayarma2lib today and it has SQLite support. I also read on the forums that "Benny" was possibly working on MySQL integration. Is this something we could start working on? Gnome, did you say that you made some progress towards this or would this be a "start from scratch" job?
User avatar
Firefly_AS
--------------
--------------
 
Posts: 994
Joined: Thu Apr 29, 2010 4:13 am
Location: US

Re: SQL Database Access and Custom Loadouts

Postby Robalo_AS » Mon Aug 16, 2010 11:53 pm

I think it would be something cool to have, but with restrictions.
1. Be able to disable this feature mission-side
2. Check availability of the custom kit items using the new beta commands - grab them from the crates/vehicles available close to insertion.
I can make this working on all missions once we have this implemented in one.
User avatar
Robalo_AS
--------------
--------------
 
Posts: 3085
Joined: Sat Nov 01, 2003 3:32 am
Location: Bucharest

Re: SQL Database Access and Custom Loadouts

Postby Firefly_AS » Tue Aug 17, 2010 12:36 am

#1 - Yep, totally agree.

#2 - This might be kinda tricky. Then we would have to have different loadouts for different missions, it would be a big hassle. Perhaps we could agree on a fairly standard crate loadout using the current "ammo_crate" marker and use this for most missions? Or, if the mission designer wants more restrictive loadouts, just keep it disabled.
User avatar
Firefly_AS
--------------
--------------
 
Posts: 994
Joined: Thu Apr 29, 2010 4:13 am
Location: US

Re: SQL Database Access and Custom Loadouts

Postby Robalo_AS » Tue Aug 17, 2010 12:59 am

#2 not too tricky:

- check if custom primary weapon and ammo for it is available - replace, if not, don't (stay with default unit configured or mission kit)
- repeat for secondary weapon and sidearm as above
- add a backpack, test for custom items availability -> load them in backpack

Was hoping this would be more than just a Domination/other large campaign feature and thinking of using it as a plug-in for any mission without breaking things, just to speed-up a process.
User avatar
Robalo_AS
--------------
--------------
 
Posts: 3085
Joined: Sat Nov 01, 2003 3:32 am
Location: Bucharest

Re: SQL Database Access and Custom Loadouts

Postby Firefly_AS » Tue Aug 17, 2010 6:06 am

Ahh ok, I think I see where you are going. I started a thread about data input/output on BIS forums:

http://forums.bistudio.com/showthread.php?t=105655

Hopefully, someone will have some suggestions. I also posted a request on the JayArma2Lib thread requesting MySQL support. However, it appears Jaynus likes SQLite because of performance reasons.

http://forums.bistudio.com/showpost.php ... stcount=75
User avatar
Firefly_AS
--------------
--------------
 
Posts: 994
Joined: Thu Apr 29, 2010 4:13 am
Location: US

Re: SQL Database Access and Custom Loadouts

Postby kklownboy_AS » Thu Aug 19, 2010 1:48 am

Robalo_AS wrote:I think it would be something cool to have, but with restrictions.
1. Be able to disable this feature mission-side


Well as long as you pick "default" load-outs for "unit type", and you have your own default unit type duh.."Realizum", But then Bows and Arrows, and Rayguns if the Mission Designer wanted that :P
Splinta said it well.







Edit; why not
Last edited by kklownboy_AS on Sun Jun 05, 2011 2:30 am, edited 1 time in total.
User avatar
kklownboy_AS
--------------
--------------
 
Posts: 1617
Joined: Wed Mar 24, 2004 7:44 pm
Location: On the farm

Re: SQL Database Access and Custom Loadouts

Postby Robalo_AS » Thu Aug 19, 2010 2:28 am

IMO unrestricted access to every piece of gear in every mission would be worse than playing with limited gear (and I think the mission designer knows better, if the mission gear changes due to adding mods, like ACE creating a need for earplugs or batteries, then the fixes can also be done through mods).
Another restriction I'd like to see would be to limit a unit to it's army's weapons. For example, a sniper from USMC can get a DMR, M40 or a M39 EMR while a sniper from US Army would get M110, M24, or the Mk14 EBR.
User avatar
Robalo_AS
--------------
--------------
 
Posts: 3085
Joined: Sat Nov 01, 2003 3:32 am
Location: Bucharest

Re: SQL Database Access and Custom Loadouts

Postby Splint » Thu Aug 19, 2010 8:44 am

Default load outs for the unit type is good, personal load outs is even better for some missions, but unit specific load outs adds a certain amount of realism that I think we all like and strive for, and it forces each player to rely more on his/her squad mates. I think the admin for the evening should call the vote and decide.
Why not have our cake and eat it to.
User avatar
Splint
 
Posts: 938
Joined: Sat Mar 28, 2009 8:47 pm
Location: Nevada

Re: SQL Database Access and Custom Loadouts

Postby lightspeed_aust » Thu Aug 19, 2010 3:29 pm

mission designer knows best :)

and i hate ammo boxes generally bcoz you do away with specialists when anyone can grab any weapon/ammo they want. and also, its 10 minutes pissing around b4 mission starts while players work out what they want to take.
set and forget...

a mission makers 0.02c ;)
lightspeed_aust
 
Posts: 6
Joined: Mon Aug 16, 2010 8:40 am

Re: SQL Database Access and Custom Loadouts

Postby kklownboy_AS » Thu Aug 19, 2010 6:24 pm

Robalo_AS wrote:IMO unrestricted access to every piece of gear in every mission would be worse than playing with limited gear

And why would the Mission maker do that? Either theirs a crate or not. If crate you can use your web load out with what is in the crate.
Robalo_AS wrote: (and I think the mission designer knows better, if the mission gear changes due to adding mods, like ACE creating a need for earplugs or batteries, then the fixes can also be done through mods).

We wont know till we play it.
Robalo_AS wrote:Another restriction I'd like to see would be to limit a unit to it's army's weapons. For example, a sniper from USMC can get a DMR, M40 or a M39 EMR while a sniper from US Army would get M110, M24, or the Mk14 EBR.
Its up to the Mission maker or the crate... This is easy stuff.
The whole point is to have a fast way to gear up at insert in a "persistent" game.If a mission maker has a load out and no crate then duh. But less USMC more small team load outs.
Last edited by kklownboy_AS on Sun Jun 05, 2011 3:01 am, edited 1 time in total.
User avatar
kklownboy_AS
--------------
--------------
 
Posts: 1617
Joined: Wed Mar 24, 2004 7:44 pm
Location: On the farm

Re: SQL Database Access and Custom Loadouts

Postby Splint » Thu Aug 19, 2010 7:31 pm

Maybe pissing around on some other server but that doesnt happen much on the Alpha servers at least not of late, unless we are all just pissing around,..lol. Ill tell you on some servers even with mission briefing its at least 15 minutes to game play if your really lucky.
I like the weapons mods and the ammo boxes. When I want it quicker I play Modern Warfare ;486
User avatar
Splint
 
Posts: 938
Joined: Sat Mar 28, 2009 8:47 pm
Location: Nevada

Re: SQL Database Access and Custom Loadouts

Postby Gnome_AS » Fri Aug 20, 2010 8:52 pm

Chime in while I'm chiming on things.

Heres a thought, on a slightly more Gnome plane if you will. I very much like the idea and concept of custom loadouts for players. And a web interface to support those loudouts.

My initial thought with a system like this was like this:

A website registered player would be able to set a certain number of kits. Each "kit" being oriented to a particular skill set. (ie.. Rifleman, Anti-Tank, Demo, Heavy Weapon.. etc.)(things that the squad would need to decide on)

Then when joining the game the player would have the ability to select a the appropriate kit based on the mission leaders request.

The kits would be accessable by the player via a simple comm menu, or perhaps if one of us learns the dialog structure well enough, we make a fairly simple 2 click dialog or whatever.

Thats about it. That was my initial thought.

The challenge in this is that there are so many options. And I agree with most of the thoughts here at some level. Really though, I intended it to be a method of resolving some things and standardizing others.

Specifically the concept of re-introducing class specific roles on our servers.

Saving time at insert and giving players at AS a cool feature to help them better identify themselves thru some personalization are added bonuses. And of course we could have a couple, few generic kits that could be available in the persistant missions.

Anyway though, glad to see you're looking into things Firefly, it can be done. My current thought is that we need some core systems/functions that are generic in nature. Like a server/client communication structure, which would be inclusive of whatever kind of db connection stuff we can sort out. If we can get that stuff sorted and working, then we can easily customize things and make new tools that do many different things.

I would prefer to use something a little more friendly than SQLite, but I think theres plenty that can be done with it. Maybe just not on a "produce for the masses" type level. Which may mean it doesn't interest you, I don't know.

We should just try it though I think. I'm sure we can help you with a testing enviroment without much trouble if needed. I'm really short on "productive" hobby time right now, and probably will be through the end of the month. But I'll help where I can.
User avatar
Gnome_AS
--------------
--------------
 
Posts: 1186
Joined: Fri Mar 21, 2008 12:58 am
Location: Las Vegas, NV

Re: SQL Database Access and Custom Loadouts

Postby Firefly_AS » Sat Aug 21, 2010 12:56 am

Yeah, I didn't get much in terms of responses on the forums. Just someone suggesting I wait until Benny finishes his MySQL stuff. I really think that would be ideal.

You mentioned briefly a few days ago the client/server stuff but I guess I'm still a little unsure what that's all about. I'm assuming this is some way to pass data between the clients and the server and make it easy to manage data.

Anyway, I guess I'll just wait and see at this point.
User avatar
Firefly_AS
--------------
--------------
 
Posts: 994
Joined: Thu Apr 29, 2010 4:13 am
Location: US

Re: SQL Database Access and Custom Loadouts

Postby Gnome_AS » Sun Aug 22, 2010 5:49 pm

Yeah we need a core set of functions for say the following:

- JIP onconnect/disconnect
Really need a clean and accurate way of keeping up with the players from the start.

Then theres all the communication once connected.
- Client -> Server
- Server -> Client
- Client -> Client
- Server -> Clients

Nothing extremely complicated, just need our own means of pushing info around. One that would hopefully allow us to ensure things are happening, or more importantly when things aren't. Which is what we are lacking with the default BIS stuff. We often don't know whats happening. It's just broke.

We want a slightly less disfunctional method of keeping up with players, and then communicating with them. All mostly related to JIP functionality. But a standard system would also allow for extended use, whether it be mission/sql stuff or mod related things.

Of course the goal being to make this all mod side stuff so it's available for others to utilize also.
User avatar
Gnome_AS
--------------
--------------
 
Posts: 1186
Joined: Fri Mar 21, 2008 12:58 am
Location: Las Vegas, NV

Re: SQL Database Access and Custom Loadouts

Postby Firefly_AS » Sat Sep 25, 2010 7:03 am

http://www.kegetys.net/forum/index.php?topic=2202.0

Got a response. I need to look into this supposed API for JayArma2Lib and see if we can hook into it. I'm not quite sure about it though.
User avatar
Firefly_AS
--------------
--------------
 
Posts: 994
Joined: Thu Apr 29, 2010 4:13 am
Location: US

Next

Return to ARMA :: Mission Editing

cron
  • View new posts
  • View unanswered posts
  • Who is online
  • In total there is 1 user online :: 0 registered, 0 hidden and 1 guest (based on users active over the past 3 minutes)
  • Most users ever online was 311 on Wed Dec 12, 2018 4:22 pm
  • Users browsing this forum: No registered users and 1 guest
Presets
Main Style
Patterns
Accent Color
Apply