TheAlmightyOS

Right off the bat I want to say what this is about cause I tend to meander in my posts: I am having a hard time finding the time to play KSP due to the number of mods available. Personal issue right? Why am I posting here in General Add-on Affairs? If you care to know, I will explain myself. The primary issue for getting back into KSP is the mods. Obviously I could play vanilla KSP and it is fun to do so. But when I know I could make an ultimate battle cruiser and supporting Mun base using B9, NFT, nearly everything from roverdude then vanilla gets old quick. And you just can't go without Firespitter and of course Hooligan labs and KAE for messing around in the planets atmosphere. If you are building anything from B9 on the ground you need Snjo's hanger extender. Can't forget Novapunch and KW rocketry. Did I mention all the space station mods? Annnnd I just passed the ram limit for windows so time to set up a linux install. While I am at it I find about ten other mods I just have to have and install those too. I am not saying the Mods are a bad thing. I love them (too much, it might seem) as I pointed out above. However, both when I first started playing with mods and currently as I am trying to get back into the game I find myself tweaking and installing more then I am actually playing and it is not an enjoyable thing. I am not advocating for an easier way to install or find Mods. That has been done to death here, no one wants to hear about it and some good projects are currently active and addressing these issues. I suppose I just want to play more and install less. Obviously that would mean stop looking for and installing mods. However, that would also mean missing out on some cool stuff like Roverdude's Alcubierre Warp Drive that I just found a few moments ago. How do you guys handle "Mod Overload" if you suffer from this condition and are there any suggestions to help me play more and tweak mods less?

Almost... The bootable linux distro is the easy part (Use Linux MINT for quick results) and if you have a higher spec machine with a higher spec thumb drive you can get away with running it live. HOWEVER, everyone's rig is different so I can not say that someone won't have some strange issues booting or getting a linux vid driver installed properly. Personally, I have a separate SSD with MINT Linux in my gaming rig that I select at boot when I want to play games like KSP and it works very well. Just throwing it out there. Your results may vary.

I have come back from falling off the face of kerbal and am glad to see someone finally did it. I have not had a chance to test CKAN let alone fire up my gaming pc yet, but from what little I have read in this thread it sounds like you have done some amazing work. At some point I might try to pick your brain on how you solved the mod-update issue but for now: Congrats on a job well done

Thank you for the support. It will happen. I just need something more stable than a 6+ year old custom rig. Tested everything I could possibly test. Has to be CPU or mobo. Been wanting a blade server setup. Maybe I will save my money up for something like that. Stuff like that is on craigslist all the time here. Till then, I will work on how to identify changes in FP of threads and cleaning up the php pages.

I am (was) using CentOS7. I would like to maintain it but I put the WTFPL license on it so anyone can pick it up if they want or fork it. Currently I just don't have the resources. Like I put in the first post, anyone want anything I got so far I will provide if available. Would take time to pull the database (data would be stale anyway) but I I have my php files. If I got my hands on some stable hardware I could make this work. I think I saw a pm about hosting. Need to read those still. Thank you for the support

removed the html code bits from the database. Clean data, but now you can't click on any links. Apologies. This is what I am working on currently

some <longstringcurse> tried to hack me over at http://www.phphelp.com/. Thought he was slick "you're using outdated code, run this". I can read SQL. It drops a table called users (which, I have one with over 300 entries, so, um, NO) and then makes a users table. Possibly as back-doors. Supposedly it is all to install PDO which I only know two ways to install that: apt-get install php-pdo OR yum install php-pdo. So complete hacks over there. STAY AWAY! According to w3c, MySQLi is still an up to date and valid way to call for database information but everyone is so stuck on this PDO crap. And I do mean crap. It is a horribly inefficient. Why write for all database types at once when you are only ever going to use SQL? it makes no sense! I am going to see what I can do with both, hopefully I can make something that looks good.

ah, not that simple my friend. First, I need to edit all the HTML links inside the database. I suppose I could do some sort of extract and remove the junk with your stripper and then do a bulk update but I would have to be careful. Second, I need to update the websites to see cells with web addresses as links. As they are almost purely coded in php I need to investigate how to conditionally format cells that have "*HTTP*" content. Since I was already going to need to look into conditional formatting this just accelerates the need. Last, the DB_Extractor I created that makes the BBCode table in the first post needs to be edited. Of all of them, this might be the easiest. I think I might be able to use sed

kOS has bee updated based on info from the link provided. New problem. I was a complete and put the links into the database complete with HTML tags. I thought it was brilliant at the time. Just realized they store in the database something like this: <a href>fake.link</a> I should have known better. You never add formatting marks to a database. Working on a way to fix that now. Going to need to change both the code on the main sites and my extractor as well as bulk edit those database entries.

Quick response: it's enough for now. Sending the data to the database Longer response: we will fix it up proper later with all the correct information. Thank you for the info

Do you have the information for the new kOS? If it is too much trouble I will search when I get home but right now I am at work and time is limited

I know where you are going with this. I did think about this during the design phase. I came to the conclusion that I could always build up with a database so to start small with the necessities. Issue I am having is how to uniquely identify mods within the database. Right now I am using mod name and that, as we see in the case of kOS causes issues. I can't simply auto-generate an alpha-numeric because I want the public to be able to identify the mod by that ID and submit change requests. Just like Steven Mading did. I have a plan much like what you are talking about here floating around in my laptop somewhere. When this concept db has been proven to be maintainable we can scale up.

No data mining is going on. Just a guy with a database . When the system works as designed, people come together and find and fix little mistakes like this one. Right now, the DB is just a rough copy of the Community mods plugins library. Link in sig. We should tell them too. As for using mod names as the primary keys I struggled with this during the design phase. I do not know what to use as a proper identifier. Any suggestions? As for kOS, I will update it with the new information when I get a chance

Ok, so for any mod authors out there that want to update their mod on KMC themselves (or any volunteers that want to help out the cause) Send me a text file named with EXACT NAME of the mod (find it in the db list in the first post) and say what changed. Anything that is not mentioned in the file is not changed That simple. Here is the syntax: Database_Key='your new value' Database_Key2='another new value' And if you want to remove something, lets say a curse url: Database_Key3=NULL That is it. Nothing else to it. Below is a list of database keys and what they mean. Mod authors are open to change any value. Volunteers may only change the KSP Version, AVC participation and add/change locations. ALL changes are vetted. If someone submits a file saying saying Farram made DangIt!, I am going to be sending an PM to Ippo and Farram, as well as an PM to the mods to report possible malicious behavior. Also, if one of the mods is called ;drop tables; or the such (not that it would work) I will send a request to have your account terminated. I don't play. This is my personal server and I never intended for it to be used this way. Authors and volunteers, please contact me via PM to submit a file. There will be a more automated submission process later, however I want PM's so I know there is no impersonation going on. Database Keys: KSP_V_Major KSP_V_Minor KSP_V_Rev KSP_V_Build These keys indicate the most recent version of KSP the mod is compatible with. It is separated out into Major, Minor, Revision and Build. At this time Build is not used (thankfully). Mod_Type Usually "Plugin", "Part" or "Craft", however can be whatever describes what the mod "is" Mod_Author The PRIMARY author of the mod. Can be a team name. Sorry, no lists. Looking into multi-authored parts in future enhancements. Mod_Comments A summery of what the mod does. No formatting. Try to keep it short, maybe a paragraph. License What is the License for the mod. Be specific. Don't just say GPL. Put the version. Example "GPLv3". Also, if using a custom License, just put "Custom". I will be adding a sub-table of licenses in one of the enhancements. Forum_Thread Curse_Site KStuff_Site GitHub_Site Other_Site These are all url's, the first is the forum thread, the others are other url's the mod can be found at. This is the only time I will ever change the information as shown on the thread. The mod author will often direct link to a download. I change the link to go to the mod's page on these sites without the direct download. Private sites like private servers or gdrive and media fire are simply not added. Other_Name Name of the other site listed in the section above KSP_AVC Does the mod participate in KSP_AVC? YES/NO If there is any questions about any part of the process I am more than happy to answer them.

Justin Kerbice is working to bring a very important part of KMC to realization and that is update notifications. This is not a notification for you, this is a notification for the database itself, a flag that indicates "hay! this mod has been updated! you might need to update the db!". When we get that functionality it will be much easier to keep track of updates. I am noticing more authors than I realized keep all their mods in one thread. Will need to seriously think about this, maybe even change the db.

Sorry for the lack of updates. Was looking into CKAN and what it would provide the user in a completed state. I am now satisfied that the functionality of KMC and CKAN do not overlap to an extent that warrants the discontinuing of KMC. Still waiting for user / modder input on the project. I can make this as big or as small as you guys want. The framework is done. New features would be easy to add at this point

I have not had the chance to look at this as thoroughly as I would like, but I am behind the idea of the project. Will keep working on my database, however I think CKAN would make that obsolete before it ever took off. And I am ok with that

Hi all. Paused work momentarily on the Modification Catalog to throw this out to the collective wolves then run back to what I was doing. One of the reasons I started work on the Modification Catalog is because two guys (Won't name any names but you know who you are ) said they had some ideas on how to at least identify when the first post of a mod (where major updates are most likely to be made) have been changed. Well, I have not heard back from them. So here is what I found: http://baruch.ev-en.org/proj/websec/ It is a very old perl program BUT IT WORKS. One caveat: it picks up the time at the bottom of the forum as a change. So every time you run it it will say the page changed and highlight the time. I tried to ignore the time in the settings however I was unsuccessful. But I am sure you programming folks can figure it out, right Well I am off to fix some database scripts....

OP has become a mess. Going to move everything but a shortened About, Proof of concept and links. Everything else is going off site, if I keep it at all.

I pinged ya Ippo, but looks like you are "a little busy" I want to thank Cybutek over at KSP-AVC for his assistance identifying mods that most likely have AVC installed. Writing a script now to add that new information to the database

I'll test for ya MacTee. You prefer linux or windows testing? got both on my gaming rig. oops, pm. Doing that now

Interesting. The HTML>BBCode conversion mangles the links for the forum. That is understandable. Also, the "NULL" values are from me cleaning the database up. Will need to tweak the scripts a bit to fix both when I get home. EDIT: Ok, I was working for hours, got roughly 15 mods updated. That was vastly under my expectations. I thought I was making some headway . If anyone would like to help, follow these steps: 1. Post here and let me know your helping so we can co-ordinate 2. Choose a section of the Community Mods and Plugins Library to work on. 3. Open up notepad++ or your preferred text editor. Please do not use Word. 4. For each mod, use this template: UPDATE CMPL SET License='', Forum_Thread='<a href></a>', Curse_Site='<a href></a>', KStuff_Site='<a href></a>', GitHub_Site='<a href></a>', Other_Site='<a href></a>', Other_Name='' WHERE Mod_Name=''; NOTE: I removed KSP status because I have a different way to set that now 5. Go to the mod's forum page and collect information. DO NOT collect direct links to downloads 6. Copy a new template below the first and continue with the next mod 7. Continue until done or bored. 8. Save the file as yourname.sql and send me a pm. Will send you my gdrive info. Important: The Mod_Name must match the Mod name from the database or Community Library exactly. Here is an example I did earlier: UPDATE CMPL SET License='CC BY-NC-SA 4.0', Forum_Thread='<a href>http://forum.kerbalspaceprogram.com/threads/61040</a>', Curse_Site='<a href>http://kerbal.curseforge.com/parts/220359-s-service-compartment-tubes</a>', KStuff_Site='<a href></a>', GitHub_Site='<a href></a>', Other_Site='<a href></a>', Other_Name='', KSP_AVC='' WHERE Mod_Name='6S Service'; UPDATE CMPL SET License='GPLv3', Forum_Thread='<a href>http://forum.kerbalspaceprogram.com/threads/94426</a>', Curse_Site='<a href></a>', KStuff_Site='<a href></a>', GitHub_Site='<a href></a>', Other_Site='<a href>http://forum.kerbalspaceprogram.com/threads/94811-Addon-Controller-Toggle-addons-and-parts-on-off-for-individual-saves</a>', Other_Name='Development Thread', KSP_AVC='' WHERE Mod_Name='Addon Controller'; UPDATE CMPL SET License='', Forum_Thread='<a href>http://forum.kerbalspaceprogram.com/threads/91998</a>', Curse_Site='<a href></a>', KStuff_Site='<a href></a>', GitHub_Site='<a href>https://github.com/BobPalmer/CommunityResourcePack/releases</a>', Other_Site='<a href>https://docs.google.com/spreadsheets/d/1F2NYLj47O6VdThCXqBcI_hB-bDIMh4ZWB2FFyrjMLkg/edit#gid=650840806</a>', Other_Name='The CRP working document', KSP_AVC='' WHERE Mod_Name='Community Resource Pack'; UPDATE CMPL SET License='CC BY-NC-SA 4', Forum_Thread='<a href>Connected Living Space</a>', Curse_Site='<a href></a>', KStuff_Site='<a href>http://beta.kerbalstuff.com/mod/11/Connected_Living_Space</a>', GitHub_Site='<a href>https://github.com/codepoetpbowden/ConnectedLivingSpace/releases/</a>', Other_Site='<a href>http://forum.kerbalspaceprogram.com/threads/68617</a>', Other_Name='Development Thread', KSP_AVC='' WHERE Mod_Name='Connected Living Space'; UPDATE CMPL SET License='LGPLv3', Forum_Thread='<a href>http://forum.kerbalspaceprogram.com/threads/83755</a>', Curse_Site='<a href></a>', KStuff_Site='<a href>http://beta.kerbalstuff.com/mod/39/CrewFiles</a>', GitHub_Site='<a href>https://github.com/Ippo343/CrewFiles/releases/</a>', Other_Site='<a href></a>', Other_Name='', KSP_AVC='' WHERE Mod_Name='CrewFiles'; UPDATE CMPL SET License='MIT', Forum_Thread='<a href>http://forum.kerbalspaceprogram.com/threads/96729</a>', Curse_Site='<a href></a>', KStuff_Site='<a href></a>', GitHub_Site='<a href>https://github.com/sarbian/DDSLoader/</a>', Other_Site='<a href></a>', Other_Name='', KSP_AVC='' WHERE Mod_Name='DDSLoader'; For those that take professional pride in such things, I could add a "db_update_by" field so everyone knows you are the one who updated that entry last. Or not. Depends on what people want to see and not see and I have not heard much in that department.

Fixed now. When I added search by column I had to change the PHP code I used to indicate the query and I did not add the wildcards back into the statement. But it is there now. Thank you for the catch!

Crap. Fixed the column dropdown variable and killed the wildcard search. Looking into it. The search has been the hardest part of this whole business and given me many issues. PHP and MySQL don't go together. Except when they do. But not like that. Sometimes Reading the PHP manual site was like reading a hackers manual.

While I am waiting for those opinions, development continues. Noticed a huge issue as I was testing out update scripts.... No links The HTML location is displayed but you can't click on it. This is a major issue. It may be the way I am displaying the data. Looking into it Fixed it. I don't necessarily LIKE the fix, but it works. I have created an update script for the database. It is just a SQL script laid out with the different columns on each line. With the right documentation a mod author could submit changes to their mod's database entry. However, this is being designed so the authors could be hands off unless they decide to be active with the project. So I got the scripting, hyperlinks, added search for other columns..... I guess it is just data entry for me at this point so you won't see many more posts from me except to update the table on the OP. Until I get some more input I am about finished with the initial development.