Please Help, Point me in the write Direction

hexlord

Ok, I am a newbie, I wanted to admit that and get it out of the way. What I am trying to do is make code something that would allow me to take a text file and in return turn the contents into variables, once the are in variables I would like to be able to implement them into MySQL. Ther are a couple of problems, I don't want everything in the text file, which means that I want it to skip a couple lines. and some lines have multiple entriess. I hav eincluded a portion of the file:

#PLAYER
Vers 9
SubV 2
Name Testdummy~
Level 1
Trust 0
Id 1126580422 (Mon Sep 12 22:00:22 2005)
LogO 1126583354 (Mon Sep 12 22:49:14 2005)
LogOS 6532254hfc218.tampabay.res.rr.com~
CC `
Plyd 2932 (48 mins, 52 secs)
Pass tYPoFdNhpl.o2~
Remrt 0
Created_from 65.42.234.319(6542254hjk319.someplace.res.rr.com)~
Know_index 14
ShD a male human~
Cla thief~
Race human~
Lang human~
SLvl 0
SubP 0
SubT 0
RXP 0
RRPS 0
Sec 0
Not 1126558873 1126558873 1126580473 1126407673 1126407673
ANote 0
INote 0
MiscN 0
SNote 0
PKNote 0
Rps 4
Rpcnt 2
Merit -3
Karns 3
KCntd 2311
HeroXp 0
RCnt 1
RecallRoom 0
RecallInnRoom 0
ExpireRecallInn 0
Sex male~
TSex male~
Pos standing~
Scro 22
Room 7371
LIcRm 0
HMV 10 10 100 100 100 100
HMVP 10 100 100
Cnd 0 48 48 48
Gold 0
Silv 1000
Exp 1004
Pnts 40
LLev 0
Prac 10
Trai 5
Tired 0
Tryin 0
Alig 0 0
ACs 94 94 94 97
Height 0
Weight 0
NVanish 1126583354
NWorshipTime 1000000
Attr 23 42 20 20 36 20 23 20 29 21
AMod 2 0 -6 -6 0 -6 2 -6 0 -5
APot 25 80 70 76 45 30 80 35 39 50
Act
autoassist
autoexit
autoloot
autoreformat
autogold
autosplit
nosummon
log~
Comm
prompt
combine
show_affects~
Config
objrestrict
autolandonrest
automap
nocharm~
Config2
autodamage~
Colourmode ansi~
channeloff Flame~
Duel_challenged 0
Duel_decline 0
Duel_accept 0
Duel_ignore 0
Duel_bypass 0
Duel_subdues_before_karn_loss 0
Sk 1 'backstab'
Sk 1 'dagger'
Sk 1 'dirt kicking'
Sk 1 'disarm'
Sk 1 'dodge'
Sk 1 'hide'
Sk 100 'human'
Sk 1 'mace'
Sk 1 'peek'
Sk 1 'pick lock'
Sk 50 'recall'
Sk 1 'second attack'
Sk 1 'sneak'
Sk 1 'steal'
Gr 'dawn basics'
Gr 'thief basics'
Gr 'thief default'

this is a player file, I need to find out somehow how to convert this into MySQL data so that I can allow people to interact with their characters via website.

now It would be ten times easier if I just created a Database and Character Creation script with php but then again some peopel I think would perfer to
created through the MUD.

I would like to adventually created a system that would allow players to read thier ingame notes through the website as well. Heck my dream would be to
convert the TEXT database system to Mysql (but that is Really over my head)

I don't want anyone doing this for me, I just want to be pointed in the right direction, maybe a couple examples would be nice.

Thanks in Advance

Hexlord

Sxooter

Assuming your text files are always gonna be moderately small, you can use the file() function to read them in:

$lines = file("path/filename");

will give you an array where each entry (i.e. $lines[0], $lines[1], and so on) represents a line of the file. Note that these entries may have a carriage return / linefeed combo or something like that on the end. Use chop() to clean them up if necessary.

You can iterate over each array element with a foreach. Here's a simple, possibly buggy chunk of code to do some of it.

$filename = "myfile.txt";
$lines = file($filename);
foreach($lines as $l){
    $tmp = split(" ",chop($l));
    $my_arr[$tmp[0]]=$tmp[1];
}

// Now we display the array we built:

foreach($my_arr as $k=>$v){
    print "Key: $k, Value: $v";
    print "<BR>";
}

hexlord

Thank you very much for your quick repy. I played with it a little this morning but I have to head out to work. I will post my progress here.