Right. Now, if you took and just stored a checksum of the database, and checks against that before uploading, you would use almost no space. But have to upload it all. Possibly split the db into a few pieces?

Maybe. My brain has kicked in and said that it is probably better leaving it and only trying to speed things up if the upload data is too large or fliggs server is getting to many UPDATE querys.

To be perfectly honest, you guys lost me. I'm working frantically to learn all about PHP+MySQL, but there are some fundamentals I need to work out first. I am right now working on building the basic databse, and reading that to display on the site; also I have almost got the user registration system functioning. Beyond that, this is still greek to me. So I'll certainly be reading all of this again in the future.

So what I am to understand about MyMWSQL is that it cannot write to a local database, only a remote. MWSQL is the opposite? But if we use SQLite, it will have somewhat of a different structure, or different syntax?



How can this be made to run automatically while the player is actually playing?

Oh, and as for the journal, I don't see any reason why it wouldn't be sufficient for the player to manually upload it. When we get it, we will rename it and place it in a specific directory and place the new filename in the database. It will take a little bit of modifying the file itself to remove the special characters and such, though I think that will be simple.

Right. So, basically, that will cause you all sorts of issues. Especially if MWSQL is ever used in a mod, which would complicate what you had to run.
A fix may be to add a command to MWSQL to trigger another app, which will then push the data to your server using POST. That app can also be triggered outside of the game.

So you would send:

xFileWrite "|pk_mwsql" "-upsave you.ess"

and MWSQL will start upload.exe with you.ess.
Next, upload.exe will read data from you.ess and send this data:

name=you&class=mage&whatnot

in the POST to the page http://fliggerty.com/upchar.php
which reads (at least, your code copy):

$mscon = mysql_connect(localhost, you, password);$msquery = "INSERT INTO characters (`name`, `class`) VALUES ('".$_POST['name']."', '".$_POST['class']."');";

My PHP is rusty, but that's the idea.

About the earlier mentioned abilities of companions, It could probably work to have about mabye four or five companion "skeletons"
Just blank companions of unspecified race, defaulting as a dunmer if the race shown is not found.

Injecting the data to the specified NPC's, they could even update levels and stats as the player went on, but dont include the equipment as that could easily turn into farming for gold every three minutes.


Good luck my buddy Fliggerty, if you pull this off Ill certainly be coming back to morrowind for some time.

Marbred made a header banner that really captures the feel I was hoping for. The detail is exquisite!

http://i53.photobucket.com/albums/g60/Kagouti_MW/GHF_CensusBannerW1.gif

Well, here's the slightly better version I forgot to give Fliggerty
http://i53.photobucket.com/albums/g60/Kagouti_MW/GHF_CensusBannerW02r.gif

Glad you like it, Fligg, thank you!

Yes, I really do like the new one!

Here's my take on the banner:

http://www.4shared.com/file/100456318/a00221c3/linorabanner.html

Just throwing the idea out their. Maybe have a banner that one side fades to a certain color. Then it doesn't look bad with variable width layouts

Something like this, which fades to black
http://www.metoffice.gov.uk/

But better

Hmm.. good idea. Back to Gimp I go!
Edit: Actually, since fliggerty is going to make the general theme and such, as read below. I'll let him do his "photoshop magic" should he want to do this.

It's a good theme I'm designing this with multiple themes in mind. I now have two good banners, one for each of the themes I'll create while designing the site.

That is a good idea Yacoby, though it doesn't entirely work with the banners that have been contributed so far. No worry though, I can work some Photoshop magic as needed. :goodjob:

Thanks everyone!

Just had to pop in and say WOW! This is an amazingly fantastic idea. I believe in you and your ability to do this well. *Cheerleading smiley*

Ok, here is my take on all three banners submitted so far.

I really like the background on the ones by Marbred, as I think it captures the concept of the site and the Census and Excise office.

I like the official seal and Great House Fliggerty Presents (I think this should be on here as that is what they are doing) (Also, the seal is so well done that it looks very 3d which makes it all look real and official)

I like the font of Linora's banner, though I would be really picky and say I would prefer to have TES font.

It may get too busy, but I really do also like the coin in the first one. Again it is 3d and it goes well with the concepts.

Thems my 4 cents worth. Great work everyone. Keep it up.

Cheers!

Holy crap. Yes.

I agree. That seal looks great, Linora.

just putting this out, there...BUT, since one could make characters and fight them in the arena with this, would it be possible to put a generic companion script on the chars that you download? maybe also lvl up and update the character and items from the internet.

(i know nothing on how to work scripting or programing, so just throwing it out there)

Perhaps...
It's not in the realm of possibility to download characters yet; that's going to take some real thought and tinkering around. Which is why I've decided to not even focus on that at all until the system is up and running.


I've been cobbling together little bits of code as I learn it. I have built a login system with user access controls and a very basic screenshot upload gallery (I haven't yet sorted out how to edit or delete pics yet, just display them.)

You can see what I have here: http://24.10.131.119/cne/main.php (you'll have to register to see most of it.)

a visit to http://whatsmyip.org/ should fix the 192.x.x.x local IP address error in the above link

Ah, whoops. Just an oversight. I think that I copy+pasted from the wrong browser window. :hehe:

I like the text on Linora's banner (and, truth be told, the background), but I think it would look best with Linora's text with Marbred's first banner (with the dark logo, not the read one). Marbred's current text just reminds me too much of a boot camp-type thing.

I spent today playing around with Qt. If I can figure out how to use a GUI system for Windows, I know exactly how to make the save translator/uploader. Have it all planned, down to flow (and know how to read the save). It takes a minor update to MWSQL, and another app that can be run commandline (by MWSQL, ingame upload) or GUI (external, pick which save).
BAsically, two panes. Left is a list of saves, right has two tabs, lists save info (for selected) in one, plugins (for save, if stored there, which I think they are) in the other. Upload button under the info section.

Well that's good news!

I do have some concerns though about reading only from a save. First of all, it won't be all that dynamic; it won't update as the player plays unless they save. Of course anybody who knows what they are doing saves often. It also doesn't allow for acquiring custom data that I can get via scripting; things like current weather and a custom message from the player. Any ideas?

Why is the save file necessarily a valid source for information to gather from?

I'm no programmer by any means but wouldn't it make it much more dynamic to pass it through a pipe with scripts and onto the database? I have been following the posts slightly, understanding very little of the discussion so I'm sorry if it's been considered and I'm just grasping for used air.

Have the program be able to read from a pipe as well. That way it satisfies both groups of people, those who don't want anything else running in the background, and those who don't mind it.

You also end up being able to share code for a lot of the things. (I.E. HTTP requests)