• NOW LIVE! Into the Woods--new character species, eerie monsters, and haunting villains to populate the woodlands of your D&D games.

Building a Web Database

From the screenshots, that looks PERFECT Snotling!!! The only thing missing is a d100....LOL

I downloaded it, but am getting ready for bed.....From your comments, this is an EXE, and not a web chat room???

Thanks for the heads up.....Gives me somewhere to start from....LOL

James
 

log in or register to remove this ad

Mercule said:
I do ASP.NET (not ASP classic) development for my job, so the basic understanding is there, but PHP is enough different that it would be a time-sink for me. Since I want to do this to save time, that'd be a bit counter-productive. That's also why I've not really done much with PHP-Nuke or Post-Nuke -- slow learning curve, and I had a royal pain trying to figure out how to maintain them.

If you do ASP.NET in C#, then there is little difference, except that database access is way more straightforward in PHP. A lot of code would run just fine by switching variable types to all say var and replace <% %> with <? ?>

php.net really is a good source of info. It really isn't much work to learn if you already know the basics. Plus you could always come back and ask questions. There's quite a few developers on here. :)
 

I took some time and played with the D&D Chat this morning......I don't think I'll make it part of my site, but that will give us a place to do what we need.....Thanks again for the heads up....

James
 

JamesL85 -
Yes, being that it is a windows exe (not a web module thingie) it will not work with the site.. But it is rather slick. If you do end of finding anything, I'd like to hear about it.

Mercule -
reanjr is right, if you know asp.net then php will be easy. (I have been amazed at what I have pumped out with php, and I am NOT a programmer)
 

reanjr said:
If you do ASP.NET in C#, then there is little difference, except that database access is way more straightforward in PHP. A lot of code would run just fine by switching variable types to all say var and replace <% %> with <? ?>.

Interesting. I'd have expected it to be a lot more like ASP classic, and my limited experience with that has been less than thrilling.

I actually use VB. Although I've putzed with C#, the syntax is still a bit odd for me. My problem is that, while I've done Windows development for quite some time, I just moved to web dev about a year ago. I pretty much rely on VB code-behind modules for ASP.NET and try to minimize actually working with the HTML side of things. I did some HTML stuff over a decade ago (when Mosaic was the new thing), but I'm largely unfamiliar with what's available, now.

I've been lucky in that my host has point-and-click install for a slew of things (Mambo, PHP-Nuke, Post-Nuke, Xoops, PHPBB, etc.) and the mods I've installed myself have been very by-the numbers.

Maybe between the wine DB and the PHP.net site, I can put something together that'll work, though.
 

XCorvis said:
Most of the Content Management Systems are free and use MySQL as a back end database. It is also free. There are also very detailed how-tos on the Apache+PHP+MySQL combo. As snotling said, PHP-Nuke is probably what you're looking for.

I'd like to highly recommend Xaraya (http://www.xaraya.com), an offshoot of the Nuke family. It's much much much more customizeable as far as columns go than any other nuke. For example, you can see my website. I have basically one "articles" module for Xaraya where I set up different types of articles, each having it's own set of columns. this lets me organize everything by item type (feats, spells, etc) without having to do any coding, which you would need to do for php-nuke or postnuke, in order to get those extra columns. The only thing you'll need to know is HTML and some basic coding skills to write the various templates to make everything look the way you want.
 

Mercule said:
Interesting. I'd have expected it to be a lot more like ASP classic, and my limited experience with that has been less than thrilling.

PHP is far more like ASP classic (though I understand hardcore PHP guys have various ways of modularizing things to clear up the code soup that produces), except that the programming language is a C derivative (or really a stripped-down Perl derivative). My understanding (I'm an ASP.NET guy, and a shameless VB advocate*, myself) is that JSP/Struts is probably the closest analogue to ASP.NET in the Open Source world... but if I had to get my code running on a Linux box, I'd probably find some way to install Mono/XSP...

* I know some C derivatives well enough to get by -- and C# rather better than that -- but that doesn't mean I have to use them :D .
 

I've been using various methods for online organization of my game, and pondering the ideal solution for a while now.

I've pretty much come to the conclusion that I may need to write a GMS (Game Management System) myself, as I seem to want it to do most everything for me. I thought a web-based, php system would be nice, with the following features:

World management (complete world stats, marked either for DM or Player view, as well as special groups - so your northern barbarian would have access to the northern customs and geography sections, etc; map indexing - including virtual lat/long coded in so you could place a city description in the world guide and just link its location, etc; Sections for different cultures, races, areas, cities, religion - down to as specific detail as you cared for, with customizable entry fields, etc..)

Feats, Spells, Equipment, Monsters etc - data collections for each, with an appropriate 'ok for play in this campaign' setting, so it would only show the appropriate equipment for a Dark Sun campaign, for instance. Each would be customizable as well as having the 'standard' fields (need a 'description' field for a specific sword? no probl, just add it in).

Character Tracker - probably the same system for NPC and PC, with different output views for the DM (just want a stat block? check this box..) This would track character xp (so the player would always know what their total is (my players are so bad about not putting this down right.. I swear..) - and could even help calculate it by CR and EL if you put those in. It would be easy to update your character between sessions, then it would auto calc your encumbrance (if desired) and all the other bookkeeping crud that players don't want to deal with (for the most part). It would hold a wizard's spellbook and keep track of pages as well.

Integrated messaging for players to leave notes for the GM, and vice versa - it would email you when you had new messages waiting. The DM could configure it to allow players to PM (basically) each other as well if he liked.

Multiple campaign options - the DM could create a campaign, assign which data sets (books/sources) he wants available (with indivicual exceptions if he wanted (all of the FR stuff, but no tattoo magic, for instance). The players would create a character, tie it to that campaign, and then would automatically be given the correct options to choose from when picking a feat/spell/equipment.

I would use it for tabletop play, but I could see adding a chat module or somesuch for online play as well, with a dice roller and a database link to browse your character and/or world info at the same time. Wouldn't necessarily need to have this integrated though.

I also like the idea of making a table of 'keywords' that would be processed and linked dynamically - so that when the php processor sees 'Great Cleave' written, it knows that is a feat and links it to the great cleave description. That could get annoying, so there would of course be an option to turn that off or customize what categories of keywords it links.

I have some notes somewhere, but that's the gist of it. The beauty of the whole thing being online is that I could use a tablet PC or whatever at game if needed, or print off stuff if that's how I wanted to go. I really like the idea of being able to add a city idea, or a new monster from wherever, when the idea hits me (assuming I'm near a computer, which I pretty much always am). Player forgot his character sheet (or didnt' show and someone else has to play him)? - zip online and print the absolute latest copy from your DM account. Forgot your printed notes? Just do them again! Want to add a new city that you made up on the fly when your players' teleport went awry? Take a 5 minute bathroom break and plop that sucker in.

That, to me, would be the greatest. Kinda like what I hoped E-tools would be in the beginning, but fully networked and online. It combines a lot of other functions into one, and gears them specifically for RPGing. I have yet to see a product like this, other than 'you could take this CMS, add a mod here, tweak that there..." - and it still doesn't necessarily do it quite the way I had in mind.

I did some work on this, actually - getting the spell data module mostly built, but then the 3.5 revision and a severe lack of time kinda punted it back into the land of 'pipe dreams'. I hadn't really planned it well from the point of view of integrating it with the other modules though, so it lacked session support and such. If I did this now, I'd do a framework, then each individual module to make sure it worked right. It is certainly a feasible project, but quite a lot of work (including the huge data entry chore). Would be worth it if I had the time to do it though.

If anyone has something out there that seems similar - by all means let me know. I certainly haven't seen anything quite like this yet though.
 

Wow spacemonkey, sounds cool. If you search Sourceforge for "rpg cms" and "game cms", you get a few potential hits. Most projects of that type are still in the planning phase, tho...
 

SpaceMonkey, when you get that thing even to an alpha, I'll happily give it a whirl. When you get it done, I may well pee myself.

LadyOfDragons, Xaraya looks pretty cool. I grabbed it and tried to install it, but it looks like my host doesn't give me enough permission to do so.
 

Into the Woods

Remove ads

Top