So, lockdown has given me a little time to learn and play this great RPG. Being the GM I found that the information being spread across sooooo many books makes the game an administrative nightmare unless you put in many hours of prep before each session. So I put together a small database to help me manage the game and World Building process, basically linking various references from the books together (with page numbers so I can review detail in the books).

Well this has started to become a monster, there is so much data in so many areas. I've added the following (and this is very far from finished):

• 130+ Adventure Seeds
• 50+ Modular Encounters
• Rebel Bases
• Relics
• Careers, Specialisations & Powers
• Creatures
• 150+ Vehicles, Manufactures
• 150+ Planets
• 150+ Planetary POI's
• 15+ System POI's
• 38 Trade Routes
• & more...

So much work, and my friends and I are the only ones to gain any advantage from it. So here it is for you all.

Currently this isn't the most accessible file, as it is made in Access and it is just the data tables, no queries or forms made just yet. But I did think that some other kind soul on here might help throw this data onto a website. I have a good Star Wars domain name and host. With time I'm sure I could throw this into a PHP site - but there are only 24 hours in a day...

If you want to get involved direct message me.

Here's the current database for you all: http://www.sw-rpg.info

Quick update to the database we now have:

• 270+ Planets
• 70+ Creatures/NPC's
• 200+ POI's
• 180+ Vehicles
• Referencing 23 Source Books...so far

http://www.sw-rpg.info

That looks like a really handy guide.

Must have been a frak ton of work. Welll done.

@JBondoux

From your post, it looks like a very interesting and useful project!

However, Microsoft is demanding a password " Because you're accessing sensitive info ...". Is there any way to may the project accessible without needing yet another login?

@Bellona Yes that original link was just to host it while I sorted out the domain and hosting platform for a site. You can now access it here:

http://www.sw-rpg.info

The site still needs an SSL to avoid the 'Not Secure' warning, but I'm working on it.

If you're up to helping make this a data driven site with this database that would be brill!!!

Huge update today.

Now I'm using it in anger within my own sessions I've added a bunch of stuff to make my GM work easier. Hope this helps some of you too.

http://www.sw-rpg.info

Version 3.1

• 390+ Adventure Seeds
• 450 Allies & Adversaries - now starting to include droid sales prices
• 250+ Vehicles
• Vehicle Attachments, Weapons & Upgrades
• 290+ Weapons
• 60+ Armours
• 240+ Gear Sets
• 160+ Gear Attachments
• Career Rules listings: 24 so far
• 70+ Corporations
• 66 Modular Encounters
• Relics, Holocrons & Talismans
• 40+ Security Forces
• 380+ Talents
• 410+ Planets - Now with Galactic Coordinates
• 100+ Trade Routes
• 130+ Resources - Beginning to consider inserting house-rule pricing for products here such as Foodstuffs etc to accommodate those players wanting to start an import/export business
• Now including The Force Awakens Beginner Game

I had some nice feedback on the trade prices so here's an update with this expanded upon slightly:

SW-RPG.Info

Version 3.2

• 400+ Adventure Seeds
• 70+ Modular Encounters
• 450+ Allies & Adversaries
• 310+ Weapons
• 70+ Armours
• 280+ Gear Sets
• 49 Career Rules listings
• 470+ Talents
• 440+ Planets
• 120+ Trade Routes
• 140+ Resources - The house-rule pricing has proven successful so we've expanded this slightly.

I've been trying to open this, but I don't have Access and nothing else seems to work with it. I just get gibberish when I use OpenOffice to open it.

Any chance of a conversion to an odb or excel format?

Nevermind, I got it open with Dbeaver.

Ok, first draft of a dynamic searchable website for the data is live. It is just weapons for now. It's my first attempt at a dynamic site so forgive the wait to get it all rolled out.

@Twinkee This should be easier for you instead of using the raw database (once of course it is all available on the site).

SW-RPG.Info

Looks very handy! A solid successor to the late swrpg.viluppo site.

Quick update. Adventure seeds have now been incorporated into the dynamic search.

Note the database is still not quite complete but with over 400 adventures listed, it'll keep you going for a short while. 🙂

Another database update and the Modular Encounters are now searchable.

Version 3.5

• 400+ Adventure Seeds
• 70+ Modular Encounters
• 480+ Allies & Adversaries
• 330+ Weapons
• 80+ Armours
• 180 Attachments
• 310+ Vehicles
• 60+ Vehicle Attachments
• 30+ Vehicle Weapons
• 320+ Gear Sets
• 90+ Corporations
• 70+ Career Rules listings
• 510+ Talents
• 160+ Species
• 440+ Planets
• 120+ Trade Routes
• 140+ Resources

The main table I've been wanting to get live has been the planets. I've put this online now, the searching facility isn't fully realised, but at least you have all have access to the data.

SW-RPG.Info

Another small update but one that I hope you'll find useful. The Planets page is now displaying a table for resources with the house-rule pricing we use for hyperlane trading. I would be interested to hear your experiences with this or your comments/suggestions.

SW-RPG.Info

Ok, we now have Allies & Adversaries; Armour & Weapons and Armour Attachments tables all live. I've also promoted relevant community services under the tables. If you think of any we should add just let me know.

SW-RPG.Info

This is great and something I'll definitely use.

Ok, nice update today. Vehicles, Vehicle Weapons, Vehicle Attachments & Vehicle Components are all available.

SW-RPG.Info

Small but powerful update today. The vehicle database has had the following fields completed: Price, Rarity, Hyperdrive and our custom category, vehicle reason allowing another method in choosing the correct ship/speeder etc.

I have also added a pre-programmed search for the three core rulesets to find a starter ship for a new group.

SW-RPG.Info

Keep up the good work!

So a build-up of the existing service has been uploaded today.

The vehicles, vehicle attachments, weapons, armours and attachments pages have all begun to start showing the item special properties. This is a work in progress but you'll find all the core rulesets have been completed for now.

The live database has also been updated to include the following:

• 407 Individual Item Special Properties
• 356 Weapons
• 90 Armours
• 194 Attachments
• 330 Vehicles
• 69 Vehicle Attachments
• 32 Vehicle Weapons
• 170 Species
• 449 Planets

Happy GMing.

So the beginning of something new...

I have uploaded the core careers from the main three books. You will see a couple of new columns for each career though. These are the primary and secondary career 'types' I have created, these have been added so you can of course find a perfect career for your playstyle. The rest of the careers are being updated - many already exist but I want to upload them when a whole core set is complete - but I am updating all the weapons, gear etc specials from each book as we go.

However, I have also added one of the first tables I made for myself - career rule tables. Here if you want to find the book and page number of, say, that crafting table you've lost track of - head here.

SW-RPG.Info

11 hours ago, JBondoux said:

So the beginning of something new...

I have uploaded the core careers from the main three books. You will see a couple of new columns for each career though. These are the primary and secondary career 'types' I have created, these have been added so you can of course find a perfect career for your playstyle. The rest of the careers are being updated - many already exist but I want to upload them when a whole core set is complete - but I am updating all the weapons, gear etc specials from each book as we go.

However, I have also added one of the first tables I made for myself - career rule tables. Here if you want to find the book and page number of, say, that crafting table you've lost track of - head here.

SW-RPG.Info

Just checked it for my next character and noticed that "Heroic Fortitude" reads "Heroric Fortitude".

Great features! Keep up the good work!

8 hours ago, Rimsen said:

Just checked it for my next character and noticed that "Heroic Fortitude" reads "Heroric Fortitude".

Great features! Keep up the good work!

Thank you.

Updating now...

Wow great database. Just what I was hoping for. Thank you!!!

Sorry for being so silent, I've been updating the special properties of the various weapons, armours, attachments etc along with updating the properties of the careers and species. We're not quite there yet but the end is in sight. As it is nearly Christmas I thought I'd update the database with where we're at right now...

This is what has been updated this time round.

• 383 Weapons
• 100 Armours
• 206 Attachments
• 349 Vehicles
• 77 Vehicle Attachments
• 38 Vehicle Weapons
• 136 Career Specialisations with many updated properties
• Dozens of new Species properties updated
• 456 Planets with many updated properties
• 688 Individual Item Special Properties (who knew there could be so many unique specials!?!)
• Hundreds of Special properties on Weapons, Attachments & Armour added

SW-RPG.Info

Happy Christmas.