Mutiegenesis

This graph represents data pulled from /status and is representative of the following components: 2017-04-05 22-57-01| 18 [b]players [/b]in memory, 258 registered 2017-04-05 22-57-01| 112 [b]factions [/b]in memory, 1134 registered 2017-04-05 22-57-01| 47 [b]sectors [/b]in memory, 20038 sectors in total full width of the graph is 7-days, but I only have about 2 days of data on this.

Can you make something to do some garbage collection with the factions in memory? PUHLEEEEEESE? Server consistently gets real laggy as in-mem factions exceed 200 or so (I got the data to prove it).

Based on my data collection, it is likely not the sector info remaining resident (they seem to clear out properly), but the factions and players info just stays resident forever, until the eventual lag.

Seeing strange / degraded performance on fairly beefy server. Looks like while the Sectors are getting properly maintained (cleared from ram), the Factions and Players just linger forever. Any chance this can be improved? Objects in Memory: AvorionServer Load (as reported by AvorionServer in logs): System Load Averages: Players In Game: Live stats are available here: https://www.mutant.enterprises/display/AFR/Server+Info

A player placing the bounty must have the cash/resources available when posted, and is held in escrow until revoked or completed. Could be fun.

I've cleaned up my scripts a bit, and added some new stuff Users Online Gauge Who's Playing Now (NEW) In-Game Chat Feed (NEW) See them in action here: https://avorion.mutant.enterprises/ HowTos and examples here: https://www.mutant.enterprises/display/AFR/Website+Scripts Requirements are bash, mysql, cron, tmux, and some general LAMPP knowledge. .MutieG.

So I was running under screen at the time, because I wanted to 'stuff' text into the console (think MOTD banner / Plug for Donations kinda thing). That worked well, but I believe that running in screen was the issue. Haven't seen anything like it since going back to plain old 'nohup ./server.sh &' Working on a solution using named pipes instead of screen.

Got a bizzarre hang a moment ago, with the following dump in the logs. Thoughts? Of interesting note is the line reading: failed to aquire /home/.../Server/PlayerCommunicator.cpp: 788, accessMutex after 1000000 tries Sat Mar 18 03:39:49 2017| starting event alienattack Sat Mar 18 03:39:56 2017| <> Jump route calculated. Sat Mar 18 03:40:01 2017| <> *------------------------------------------------------------------------------------* Sat Mar 18 03:42:43 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x6322cf 2>&1 Sat Mar 18 03:42:43 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x63260a 2>&1 Sat Mar 18 03:42:44 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x69a934 2>&1 Sat Mar 18 03:42:44 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x62732e 2>&1 Sat Mar 18 03:42:44 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x627466 2>&1 Sat Mar 18 03:42:44 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x6322cf 2>&1 Sat Mar 18 03:42:44 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x71e39b 2>&1 Sat Mar 18 03:42:45 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x63260a 2>&1 Sat Mar 18 03:42:45 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x7215d5 2>&1 Sat Mar 18 03:42:45 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x62753c 2>&1 Sat Mar 18 03:42:45 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0xad63dd 2>&1 Sat Mar 18 03:42:45 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x62775a 2>&1 Sat Mar 18 03:42:45 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0xad9394 2>&1 Sat Mar 18 03:42:45 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x6b4d07 2>&1 Sat Mar 18 03:42:45 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0xad6b69 2>&1 Sat Mar 18 03:42:46 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x6813c0 2>&1 Sat Mar 18 03:42:46 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0xad5a59 2>&1 Sat Mar 18 03:42:46 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x723d4b 2>&1 Sat Mar 18 03:42:46 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0xad6e91 2>&1 Sat Mar 18 03:42:46 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x7252bd 2>&1 Sat Mar 18 03:42:46 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0xacd5e8 2>&1 Sat Mar 18 03:42:46 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0xad63dd 2>&1 Sat Mar 18 03:42:46 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x637ed1 2>&1 Sat Mar 18 03:42:46 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0xad9394 2>&1 Sat Mar 18 03:42:47 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x66f258 2>&1 Sat Mar 18 03:42:47 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0xad6b69 2>&1 Sat Mar 18 03:42:47 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x62c772 2>&1 Sat Mar 18 03:42:47 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0xad5a59 2>&1 Sat Mar 18 03:42:47 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x6af6b7 2>&1 Sat Mar 18 03:42:47 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0xad6e91 2>&1 Sat Mar 18 03:42:47 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x6b3949 2>&1 Sat Mar 18 03:42:47 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0xacd5e8 2>&1 Sat Mar 18 03:42:47 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x6b4166 2>&1 Sat Mar 18 03:42:48 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x6b1bf8 2>&1 Sat Mar 18 03:42:48 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x6a1e60 2>&1 Sat Mar 18 03:42:48 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x6aefaa 2>&1 Sat Mar 18 03:42:48 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x69cd11 2>&1 Sat Mar 18 03:42:48 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x7f7cb4eb1ba0 2>&1 Sat Mar 18 03:42:48 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x6b8cc3 2>&1 Sat Mar 18 03:42:48 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x7f7cb46d3dc5 2>&1 Sat Mar 18 03:42:48 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x6b9c44 2>&1 Sat Mar 18 03:42:49 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x7f7cb44016ed 2>&1 Sat Mar 18 03:42:49 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x62dec2 2>&1 Sat Mar 18 03:42:49 2017| 140172960913152 failed to aquire /home/koonschi/buildbot/slave/steamrt-release/build/SpaceServer/Server/PlayerCommunicator.cpp: 788, accessMutex after 1000000 tries Sat Mar 18 03:42:49 2017| backtrace() returned 25 addresses Sat Mar 18 03:42:49 2017| [bt] #1 bin/AvorionServer(_ZN11MutexLockerISt15recursive_mutexLb0EE4lockEv+0xff) [0x6322cf] Sat Mar 18 03:42:49 2017| [bt] #2 bin/AvorionServer(_ZN11MutexLockerISt15recursive_mutexLb0EEC2ERS0_RKSsS4_+0x6a) [0x63260a] Sat Mar 18 03:42:49 2017| [bt] #3 bin/AvorionServer(_ZN18PlayerCommunicator11sendMessageERK7Messagei+0xb4) [0x69a934] Sat Mar 18 03:42:49 2017| [bt] #4 bin/AvorionServer(_ZN6Server9broadcastERK7Messagei+0x13e) [0x62732e] Sat Mar 18 03:42:49 2017| [bt] #5 bin/AvorionServer(_ZN6Server20broadcastChatMessageERK11ChatMessage+0x46) [0x627466] Sat Mar 18 03:42:49 2017| [bt] #6 bin/AvorionServer(_ZN12ScriptServer20broadcastChatMessageERKSsiS1_OSt6vectorISsSaISsEE+0x5b) [0x71e39b] Sat Mar 18 03:42:49 2017| [bt] #7 bin/AvorionServer(_ZN26ScriptServer_script_detail27member_broadcastChatMessageEP9lua_State+0x1e5) [0x7215d5] Sat Mar 18 03:42:49 2017| [bt] #8 bin/AvorionServer() [0xad63dd] Sat Mar 18 03:42:49 2017| [bt] #9 bin/AvorionServer() [0xad9394] Sat Mar 18 03:42:49 2017| [bt] #10 bin/AvorionServer() [0xad6b69] Sat Mar 18 03:42:49 2017| [bt] #11 bin/AvorionServer() [0xad5a59] Sat Mar 18 03:42:49 2017| [bt] #12 bin/AvorionServer() [0xad6e91] Sat Mar 18 03:42:49 2017| [bt] #13 bin/AvorionServer(lua_pcallk+0x58) [0xacd5e8] Sat Mar 18 03:42:49 2017| [bt] #14 bin/AvorionServer(_ZN6Script6doCallISt6vectorI8LuaValueSaIS2_EEEET_RKSsj+0xf1) [0x637ed1] Sat Mar 18 03:42:49 2017| [bt] #15 bin/AvorionServer(_ZN15ScriptedCommand7executeEP18PlayerCommunicatorP6ServeriPPKcRSoS7_+0x458) [0x66f258] Sat Mar 18 03:42:49 2017| [bt] #16 bin/AvorionServer(_ZN6Server14executeCommandEP18PlayerCommunicatorRK11ChatMessage+0x732) [0x62c772] Sat Mar 18 03:42:49 2017| [bt] #17 bin/AvorionServer(_ZN19InputCommandHandler11handleInputERKN5boost6system10error_codeEm+0x6e7) [0x6af6b7] Sat Mar 18 03:42:49 2017| [bt] #18 bin/AvorionServer(_ZN5boost4asio6detail19read_until_delim_opINS0_5posix23basic_stream_descriptorINS3_25stream_descriptor_serviceEEESaIcENS_3_bi6bind_tIvNS_4_mfi3mf2Iv19InputCommandHandlerRKNS_6system10error_codeEmEENS8_5list3INS8_5valueIPSC_EEPFNS_3argILi1EEEvEPFNSM_ILi2EEEvEEEEEEclESG_mi+0xb9) [0x6b3949] Sat Mar 18 03:42:49 2017| [bt] #19 bin/AvorionServer(_ZN5boost4asio6detail18descriptor_read_opINS0_17mutable_buffers_1ENS1_19read_until_delim_opINS0_5posix23basic_stream_descriptorINS5_25stream_descriptor_serviceEEESaIcENS_3_bi6bind_tIvNS_4_mfi3mf2Iv19InputCommandHandlerRKNS_6system10error_codeEmEENSA_5list3INSA_5valueIPSE_EEPFNS_3argILi1EEEvEPFNSO_ILi2EEEvEEEEEEEE11do_completeEPNS1_15task_io_serviceEPNS1_25task_io_service_operationESI_m+0xc6) [0x6b4166] Sat Mar 18 03:42:49 2017| [bt] #20 bin/AvorionServer(_ZN5boost4asio6detail15task_io_service3runERNS_6system10error_codeE+0x3c8) [0x6b1bf8] Sat Mar 18 03:42:49 2017| [bt] #21 bin/AvorionServer(_ZN19InputCommandHandler3runEv+0x2a) [0x6aefaa] Sat Mar 18 03:42:49 2017| [bt] #22 /usr/lib64/libstdc++.so.6(+0xb1ba0) [0x7f7cb4eb1ba0] Sat Mar 18 03:42:49 2017| [bt] #23 /lib64/libpthread.so.0(+0x7dc5) [0x7f7cb46d3dc5] Sat Mar 18 03:42:49 2017| [bt] #24 /lib64/libc.so.6(clone+0x6d) [0x7f7cb44016ed] Sat Mar 18 03:42:49 2017| ??:? Sat Mar 18 03:42:49 2017| ??:? Sat Mar 18 03:42:49 2017| ??:? Sat Mar 18 03:42:49 2017| ??:? Sat Mar 18 03:42:49 2017| ??:? Sat Mar 18 03:42:49 2017| ??:? Sat Mar 18 03:42:49 2017| ??:? Sat Mar 18 03:42:49 2017| crtstuff.c:? Sat Mar 18 03:42:49 2017| crtstuff.c:? Sat Mar 18 03:42:49 2017| crtstuff.c:? Sat Mar 18 03:42:49 2017| crtstuff.c:? Sat Mar 18 03:42:49 2017| crtstuff.c:? Sat Mar 18 03:42:49 2017| ??:? Sat Mar 18 03:42:49 2017| ??:? Sat Mar 18 03:42:49 2017| ??:? Sat Mar 18 03:42:49 2017| ??:? Sat Mar 18 03:42:49 2017| ??:? Sat Mar 18 03:42:49 2017| ??:? Sat Mar 18 03:42:49 2017| ??:? Sat Mar 18 03:42:49 2017| ??:? Sat Mar 18 03:42:49 2017| ??:? Sat Mar 18 03:42:49 2017| ??:0 Sat Mar 18 03:42:49 2017| ??:0 Sat Mar 18 03:42:49 2017| ??:0 Sat Mar 18 03:42:49 2017| Sat Mar 18 03:42:49 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x62e964 2>&1 Sat Mar 18 03:42:49 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x607182 2>&1 Sat Mar 18 03:42:49 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x60efba 2>&1 Sat Mar 18 03:42:50 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x7f7cb432bb35 2>&1 Sat Mar 18 03:42:50 2017| addr2line -i -e /home/ec2-user/Steam/steamapps/common/AvorionServer/bin/AvorionServer 0x6049b9 2>&1 Sat Mar 18 03:42:50 2017| 140173599121984 failed to aquire /home/koonschi/buildbot/slave/steamrt-release/build/SpaceServer/Server/Server.cpp: 548, communicatorsMutex after 1000000 tries Sat Mar 18 03:42:50 2017| backtrace() returned 26 addresses Sat Mar 18 03:42:50 2017| [bt] #1 bin/AvorionServer(_ZN11MutexLockerISt15recursive_mutexLb0EE4lockEv+0xff) [0x6322cf] Sat Mar 18 03:42:50 2017| [bt] #2 bin/AvorionServer(_ZN11MutexLockerISt15recursive_mutexLb0EEC2ERS0_RKSsS4_+0x6a) [0x63260a] Sat Mar 18 03:42:50 2017| [bt] #3 bin/AvorionServer(_ZNK6Server16getCommunicatorsEv+0xac) [0x62753c] Sat Mar 18 03:42:50 2017| [bt] #4 bin/AvorionServer(_ZN6Server15getCommunicatorEi+0x1a) [0x62775a] Sat Mar 18 03:42:50 2017| [bt] #5 bin/AvorionServer(_ZN6Galaxy10getFactionEi+0x17) [0x6b4d07] Sat Mar 18 03:42:50 2017| [bt] #6 bin/AvorionServer(_ZN13ScriptFactionC2EP6Galaxyi+0x30) [0x6813c0] Sat Mar 18 03:42:50 2017| [bt] #7 bin/AvorionServer(_ZN12ScriptGalaxy15getLocalFactionEii+0x5b) [0x723d4b] Sat Mar 18 03:42:50 2017| [bt] #8 bin/AvorionServer(_ZN26ScriptGalaxy_script_detail22member_getLocalFactionEP9lua_State+0x6d) [0x7252bd] Sat Mar 18 03:42:50 2017| [bt] #9 bin/AvorionServer() [0xad63dd] Sat Mar 18 03:42:50 2017| [bt] #10 bin/AvorionServer() [0xad9394]

The code itself is not meant to be included, only the output from the script. Here's how to use it: 1) gain access to the shell (bash pref'd for me) on your linux host. 2) perform the instructions above, adjusting paths and values to suit your use case. 3) run the script to generate HTML which can be included in a webpage (add to cron if desired). 4) embed the output html fragment in your webpage via an html include, php include, etc) 5) profit? .MutieG.

lol, sorry for that. Wanted to get it posted fast cuz I knew someone wanted it.

The actual command in your playerNow var might be different. It works for my steam-networking=false server, running in AWS. Now if you like that little doodad, check out the in-game chat feed I've got running, my online maps, or my still-a-bit-buggy "Whos Online" thingamabob. Those were/are a bit more complex to implement. Coming soon to the Free Realms will be a "New Ships Register" widgetything which displays the previous (configurable whenever's [hour/day/centon/etc]) ship builds. .MutieG.

Sounds like something my players may enjoy. ServerSide? ClientSide? Do you modify the existing trade AI to prefer player stations for their own routes (if that is how that works), or whole new scripts being processed?

A cool widget thingy for your community website. Displays online users in a dial gauge (via google charts api). no mysql needed! See the shiny in action: https://avorion.mutant.enterprises/ Here's the DIY: create a template file called dial.template.playersNow containing this: <!-- start of ./dial.template.playersNow --> <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script> <script type="text/javascript"> google.charts.load('current', {'packages':['gauge']}); google.charts.setOnLoadCallback(drawChart); function drawChart() { var data = google.visualization.arrayToDataTable([ ['Label', 'Value'], ['', ###PLAYERS###] ]); var options = { height:64 , width:64 , min:0, max: ###MAX###, greenFrom:0, greenTo: ###GRN###, yellowFrom:###GRN###, yellowTo: ###YLW###, redFrom: ###YLW###, redTo: ###MAX###, majorTicks: 2, minorTicks: 1 }; var chart = new google.visualization.Gauge(document.getElementById('chart_div')); chart.draw(data, options); } </script> <div id="chart_div"></div> <!-- end of ./dial.template.playersNow --> create a script called userDial.sh with this (changing values and paths to suit your use case): #!/bin/bash toGRN=9 toYLW=12 playersMAX=16 htmlPath='/var/www/html/FreeRealms' tmpPath='.' playersNOW=$(netstat -aN | grep -i '27000'| grep -i ' ip-'|wc -l) cat ${tmpPath}/dial.template.playersNow | sed -e 's/###PLAYERS###/'${playersNOW}'/g;s/###MAX###/'${playersMAX}'/g;s/###GRN###/'${toGRN}'/g;s/###YLW###/'${toYLW}'/g;' > ${tmpPath}/online.dial.html.tmp cat ${tmpPath}/online.dial.html.tmp > ${htmlPath}/online.dial.html set perms so you can run it: chmod +x ./userDial.sh then run it (twice the first time): ./userDial.sh add to cron at whatever intervals blows your dress up. I'm happy with 1min. enjoy

Avorion uptime at time of posting is > 3 days and running pretty well. I think I've allocated way too may threads (128 - heh), and may reconfig for something more reasonable like: (( MaxUsers * 2 threads ) + foo%) or ((14*2)+4) = 32 I've had much higher threads enabled, but mostly they just sit there consuming cycles and nothing else. One item which seems to help a bit for me is after starting the server, renice the process to -16 and its children to -2, just to prioritize things a bit. Still playing with tuning the thing, but current server info is available here: https://www.mutant.enterprises/display/AFR/Server+Info Here is a graph of server side Frame Skipping on my server for the past 24 hours. Seems pretty random and intermittent, and rarely exceeds 1 or 2 now, a few times per hour. Generally worse when far away out of region players are on. I've seen the frame skipping get a lot worse than this with Steam Networking enabled. ;)

It'd be kinda cool if I could print my ships.

Factions map (one of over 100 available maps) for our players at the Free Realms [uS-east] dedicated server. Server Details here: https://avorion.mutant.enterprises/ Come on over and start a war :)

try this: http://www.avorion.net/forum/index.php/topic,2739.0.html

Alles was ich sehe ist eine Standard-IIS-Seite. Ist das, was Sie erwartet haben? All I see is a default Windows IIS site. Is that what you wanted?

I'm not a lua guy, atm, but the link below seems to indicate a solid maybe. It all depends on how the devs are treating the output. If they are using some form of terminal emulation for the output, then I would think yes. Anyone wanna poke around here? http://lua.2524044.n2.nabble.com/Colored-text-td5297072.html

Nr. Nicht server.ini Bearbeiten Sie diese Datei: <InstallDir> /data/scripts/server/server.lua <InstallDir> = wo Avorion installiert ist

my pleasure. I'm glad I posted it cuz I had a small server issue and needed it again ;)

NEW in the AvorionMaps mod: Show in-game users (partial-html for inclusion in a web page) Show in-game chat (partial-html for inclusion in a web page) better graphs for "Users Online Now" and CPU

That'd be so super useful to have. I get a few strays with dial-up or of wifi, who really harsh our mellow. .MutieG.

It depends on your skill level. I've been living the Linux dream for a couple of decades now, so there were only a few challenges. Biggest challenge was programatically creating 100+ pages in Confluence (one for each resource). If you've never touched linux and think a LAMP is for reading by you will be in for a world of hurt. If you are intimate with the cli and understand some sql, you should be ok.

My Mapping scripts are on github now: AvorionMaps