lords8n

If this has been placed in the wrong area please advise? 1) The real question for this thread: How do I read and write to the Exile database via script? I know this question might seem simple enough, but i've never had to do it, and can't find immediately any example to go by. 2) Do you think what I present below is a good idea? Why/Why not? The Idea... The premise of this idea is to have players earn the ability to rearm vehicles at their base via rearm vehicles and/or VG recycling. The desired affect is to slow down people sitting in their bases with tanks and MRAPS, etc... and just firing away with only the minor inconvenience of putting the vehicle away and retrieving it from their VG to rearm, or rearming with a rearm vehicle. How it is imagined to work... All vehicles in the VG are rearmed at restart. Each player or vehicle (undecided which would be the best route here) is given two free rearms at restart. Each player can earn another rearm for a predetermined amount of tabs earned, tracked possibly via SOLD transactions. There would be a cap on how many rearms each player can earn per server session, and rearms reset to two at restart. The intent is hoped to be that, regardless if just hauling a load of loot to the trader to engage in transactions that earn rearms, the player will be forced out of their base. This is hoped to eliminate players spending entire server sessions camping in their bases with armed vehicles shooting at anything that moves. Player or vehicle based: This is a question still undecided. Although per-vehicle sounds good, having 20 Gorgons in a VG, plus the two starting rearms, would give 22 effective rearms at restart. So a player based earning system may be the best direction. I am a very long time MS SQL DB developer in my 9to5. I've done a good amount of work with the Exile DBs via Navicat, and have created a nice library of queries and reports to aid in daily administration of our GADD Militarized Malden and Tanoa Exile servers. So I am well able to handle any DB coding required, I just need to know how to do it from within a script. From the DB side this venture would simply require a new table containing the fields; account_uid, accumulated_tabs, current_rearms. Data types set to match with the current DB and as necessary for the task. A config file would hold the static values; Starting_Rearms, Max_Rearms, Rearm_Cost From a scripting perspective I imagine I would like to leave things as database-centric as possible. Some ideas for functions (thinking from a database point of view of course)... Init_Rearms - Initialize the rearm table at restart Calc_Rearm (account_uid, tabs) - Check current_rearms and deny if equals Max_Rearms...ELSE...Add tabs to accumulated_tabs of account_uid. If > Rearm_Cost add one to current_rearms, set accumulated_tabs to left over tabs, message player that they earned a rearm. Check if left over tabs > Rearm_Cost. If yes loop above...Else exit. bool Allow_Rearm (account_uid) - Check if a player is allowed to rearm (current_rearms > 0). Denied message, or just deny the rearm, if not, allow rearm and subtract one from current_rearms if allowed. I know this is a lot to read and I apologize. I'm just looking for a starting point, and the thoughts of others that may steer me away from this for reason I have yet to think of. Thanks for any help or thoughts on this. lords8n

I know this is an old thread, but my question directly relates... We like to do adhoc events on our server. I would like to be able to place an icon with text on the map and delete it when the event is done. I haven't tried yet, but I believe there is code above to place and icon. If that would work I would just need to know how to delete it manually. Can someone help me with the F3 debug screen code to do this please?

So I looked into fn_SpawnAIGroup_MultiPos (used in static mission) and fn_SpawnAIGroup (used in random bandit missions) which both end up calling fn_SpawnAISoldier in the end. This is what I think is happening... fn_SpawnAIGroup (used in random bandit missions) takes _pos as an argument. But _pos is the randomly chosen mission center best I can tell. It loops through ai count number of times and because all of the ai are showing their position as _pos it randomly places them around that point. Consequently, fn_SpawnAIGroup_MultiPos has no way to handle relative positioning. In this function each individual position is passed to the ai creation function. As seen in static missions, it will take pure positions on the map. Also, you are passing FIVE center positions, _pos, values at the end ( _AISoldierSpawnLocations+[_pos,_pos,_pos,_pos,_pos], ) where the comment I found says to just pass three (_AISoldierSpawnLocations+[_pos,_pos,_pos], // Pass the regular spawn locations as well as the center pos 3x). FYI, this is only for static missions, although, in walking down the above functions I found no practical use for these three (or five in your case) extra passes of _pos for anything other than spawning a few extra ai, or for somehow handling if your ai count (in static missions) is greater than you specified ai count. In this case it would randomly spawn the remaining ai randomly around the center of the mission. Hope all of this makes sense and maybe helps some.

Exactly. Obj plabement above ai placement for sure...IF this is the issue. We need to wait to hear back from him. Not to derail, but if there is a relative export I'd love to know about it!

@red_ned I don't think he's trying to randomly spawn ai. I think he trying to specifically place ai in exact places relative to mission center (or some other object). I asked if the ai were spawning at all, but just not where they are intended height-wise. This could have to do with the ai loading in before buildings, objects, etc... placement.

Are the ai not spawning in at all? Or are they not spawning in up where you want them?

Is this for DMS static missions? Hope this helps. Try this...