[WIPz] GHF Census and Excise Office

Post » Fri May 27, 2011 4:58 pm

I have a GUI and code which reads master files, character name, race, class, and level. These are added to the tables.

I'm having trouble reading the stats and skills (I thought I had them, but those are base stats, not actual). The actual stats are 4-byte values (floats I think) held in a character buffer. I think I know how to pull out the characters, but it's cutting off leading 0s (and 32s). Otherwise, the reading of saves is done.

The upload portion is a simple POST request sent to the server. Or may be. I don't know how Fligg wants to handle that side, so all i have there is WinHTTP linked into the program. Until I get instructions on how to do that, I can't upload it (although I may try a few test ways on my sandbox server).

Reading scripts and databases is not yet complete, although I have a few ideas about how that going to work. I'm not sure what info would need read from that, though, since most important data is in the save itself.
User avatar
Tiffany Castillo
 
Posts: 3429
Joined: Mon Oct 22, 2007 7:09 am

Post » Fri May 27, 2011 8:34 am

Fliggerty, you're gonna kill this forum entirely, you realise this?

[EDIT] Sounds like I don't like it- I really do; this is awesome.
User avatar
X(S.a.R.a.H)X
 
Posts: 3413
Joined: Tue Feb 20, 2007 2:38 pm

Post » Fri May 27, 2011 5:19 pm

The upload portion is a simple POST request sent to the server. Or may be. I don't know how Fligg wants to handle that side, so all i have there is WinHTTP linked into the program. Until I get instructions on how to do that, I can't upload it (although I may try a few test ways on my sandbox server).


What do you need from me?
User avatar
Miguel
 
Posts: 3364
Joined: Sat Jul 14, 2007 9:32 am

Post » Fri May 27, 2011 6:20 am

Depends on how you want to do this.

I'm assuming you know what POST data is and how PHP handles it (associative array). I have the program pass the data to a page on your server, sending each part (name, race, class, level) as a string in the POST and let PHP sort it out, set up the query, and put it in the database. That should be secure, at least for the most part (I'm no security expert). On your end would be a single page (or three, at this point, the one to handle the adding, one to list all the players, and one to view them). Page A would receive a request with the POST data and add it to the db. Pages B & C would be visible and let people view players from the db.
I can set it up to send the data (what I have, still can't read the skills right :( ) that way to a URL you give. Or we can figure out another way.
User avatar
oliver klosoff
 
Posts: 3436
Joined: Sun Nov 25, 2007 1:02 am

Post » Fri May 27, 2011 12:51 pm

So my question about that is will it be automatic, run behind the scenes, or is the manual method of updating the character?
User avatar
CHARLODDE
 
Posts: 3408
Joined: Mon Apr 23, 2007 5:33 pm

Post » Fri May 27, 2011 11:31 am

That's how it would happen all the time. At least, in my basic idea. Whether the upload program is triggered by MWSQL or launched by the player and they hit the upload button, it'll send the HTTP request, with the POST data. It's a simple, almost universal way of sending stuff around, and lets us add fields later (it can even support inventory and such, with enough work).
To the user, it'll look like a single request being sent with a few kilobytes of data. The server will handle the actual queries.
User avatar
Eric Hayes
 
Posts: 3392
Joined: Mon Oct 29, 2007 1:57 am

Post » Fri May 27, 2011 8:37 am

any updates on this peachy or flig?
User avatar
TWITTER.COM
 
Posts: 3355
Joined: Tue Nov 27, 2007 3:15 pm

Post » Fri May 27, 2011 2:49 pm

Grounded for two weeks, but in the last few days, I've:
- Figured out the issue with values (crazy conversion stuff, but it works now)
- and found an issue with WinHTTP.
- Downloading a no-ssl cURL distro now
- and working on putting in all the code for all skills/stats (stats & bonuses for them are done).

It can detect stat/skill values and bonuses, as well as (possibly) original starting value for stats (not sure about skills).
I have a mock php script for adding (and viewing) characters, which I'm using to test the data transfer (how I figured out winhttp wasn't working).
User avatar
Timara White
 
Posts: 3464
Joined: Mon Aug 27, 2007 7:39 am

Post » Fri May 27, 2011 2:51 am

Heya peachy, good to see you on.

I've not been able to do much myself either, I've been having a lot of computer problems. I've been trying to reinstall Windoze and get everything working, but keep running into new snags. I'm on the 10th install right now, and things appear to be working....

So it might be time to get back to work now. :hehe:
User avatar
Jessie Butterfield
 
Posts: 3453
Joined: Wed Jun 21, 2006 5:59 pm

Post » Fri May 27, 2011 2:42 pm

Heh, that turrible Winders. I had that issue and just used a different drive....

Anyways, over the course of today, I've now:
- implemented cURL
- it works
- got stats and bonuses read properly and uploaded

The current version only works with a specific host that is built into it, I may make it get that from an INI. Not sure (Fligg?).
Otherwise, I have a pair of prototype php scripts and the built program. The app can't upload (on most systems, you need a LAMP server at localhost), but it's here:
http://www.mediafire.com/?nud4jzyztth
for anyone who wants to see (and maybe test to make sure it reads things in right).
(Source: http://www.mediafire.com/?iyioxmtmyym )
Fligg, I'll PM you a link to the php scripts as soon as I get them off my other comp. If we get that set up, I would like to somehow test the upload to your server to make sure it works like on mine (closed beta?). Not all the data is sent, so it's not ready for public consumption, but I want to make sure this way works.
Not everything is functional yet, but I don't want to add skills (all 30 of em) in until I know that's how it'll be done.
User avatar
Victoria Vasileva
 
Posts: 3340
Joined: Sat Jul 29, 2006 5:42 pm

Post » Fri May 27, 2011 7:50 am

how's progress?
User avatar
W E I R D
 
Posts: 3496
Joined: Tue Mar 20, 2007 10:08 am

Post » Fri May 27, 2011 5:01 am

I put all of my projects on hold for a bit while I bought a house and moved. But now I'm in my own home, and ready to get back to work!
User avatar
Josh Trembly
 
Posts: 3381
Joined: Fri Nov 02, 2007 9:25 am

Post » Fri May 27, 2011 4:08 am

I've still got all my files and code, and with a bit of figuring out the app <-> server interface (specifically how and what fields), progress shall go on!
User avatar
Ally Chimienti
 
Posts: 3409
Joined: Fri Jan 19, 2007 6:53 am

Post » Fri May 27, 2011 12:23 pm

I would be very glad to help with this project. I can help arrange the site and help with making the headers and other artistically related objects. I've worked with designing sites for a while, since about 7th grade, more or less every once in a while, I'm not very proficient but I can help, and I'm very good with G.I.M.P. and Photoshop so I can really help with designing the site. Just pm me or email me.
User avatar
Céline Rémy
 
Posts: 3443
Joined: Sat Apr 07, 2007 12:45 am

Post » Fri May 27, 2011 11:20 am

So.....how goes this?

I need this!!! :P
User avatar
Shae Munro
 
Posts: 3443
Joined: Fri Feb 23, 2007 11:32 am

Post » Fri May 27, 2011 5:05 pm

I'm waiting on Fligg to get his CnE server working again, then we'll be working on data transfer. I can't release anything till I have the transfer method and address and compile those into the app. Skills still need read, as well as inventory and databases. Character name, race, class, and stats (as well as bonuses) are currently read.
User avatar
Adam Porter
 
Posts: 3532
Joined: Sat Jun 02, 2007 10:47 am

Post » Fri May 27, 2011 8:54 am

I might be going on a Limb here, but can you read what quests are completed?
User avatar
GabiiE Liiziiouz
 
Posts: 3360
Joined: Mon Jan 22, 2007 3:20 am

Post » Fri May 27, 2011 7:11 am

I believe we can to an extent using journal indexes. I do intend to implement that at some point in the future.

I'm still having some issues with my server, I can't get it online for some odd reason. I think my router is gradually dying. As soon as I get it back online though, I'll be able to really get down to brass tacks on this project.
User avatar
JLG
 
Posts: 3364
Joined: Fri Oct 19, 2007 7:42 pm

Post » Fri May 27, 2011 7:06 am

I'll look into reading journal entries. It should be possible, maybe from the save. We can certainly (if it's in the save, and I'm pretty sure it is) find out the status on particular quests.
User avatar
Makenna Nomad
 
Posts: 3391
Joined: Tue Aug 29, 2006 10:05 pm

Post » Fri May 27, 2011 4:05 pm

would this check for cheating too?
User avatar
Chase McAbee
 
Posts: 3315
Joined: Sat Sep 08, 2007 5:59 am

Post » Fri May 27, 2011 1:01 am

No, there's no way to really do that.
User avatar
Alyna
 
Posts: 3412
Joined: Wed Aug 30, 2006 4:54 am

Post » Fri May 27, 2011 10:00 am

It could grab insane stats (impossible ones), although some scrolls can do that. There isn't really a good way to catch cheaters, so...

Have honor!
User avatar
Charity Hughes
 
Posts: 3408
Joined: Sat Mar 17, 2007 3:22 pm

Post » Fri May 27, 2011 8:10 am

Exactly. I intend to have a user-input box that can be checked if the console or a cheat mod was used. But it will be entirely on the honor system.
User avatar
Eileen Müller
 
Posts: 3366
Joined: Fri Apr 13, 2007 9:06 am

Post » Fri May 27, 2011 8:48 am

It should be possible to search the mod list for known cheat mods.
User avatar
Queen
 
Posts: 3480
Joined: Fri Dec 29, 2006 1:00 pm

Post » Fri May 27, 2011 5:59 am

So summed up, this is kind of like a Facebook/Myspace for my Morrowind character? :lol:
User avatar
Penny Courture
 
Posts: 3438
Joined: Sat Dec 23, 2006 11:59 pm

PreviousNext

Return to III - Morrowind