Zugg Software :: View topic

Adept Joined: 12 Nov 2000 Posts: 268 Location: Canada

I'm trying to make a database of all the players on my mud using their pfiles..

The pfiles, unfortunatly, are not tab delimated, and i also have 700...Anyone know of a program (or way to do in zmud) so that I can do this?

Posted: Tue Dec 18, 2001 9:02 am

How about you tell us what the files do look like..

I assume you can read them as text files, in which case you should be able to parse each line seperately... ?

In what sort of database are you trying to import them?

Lady C.

Adept Joined: 12 Nov 2000 Posts: 268 Location: Canada

Well..I'd love to get it into a sql type database, except MySQL is a bitch to run..

And they are standard smaug pfiles...i can send you one.

What I want to do is I want to database certain lines, and then use the database program to either make an excel sheet, or find a way to export to tab or comma delimited(sp) files, so I can mail merge 'em in word and send an email to all the players.

Newbie Joined: 16 Jan 2003 Posts: 1

wow, this is almost exactly what i am looking for.. but for stat mobs...
output of stat 20.serpant is as follows, note that the line wraps are due to the mud, and is as shown here (as long as the webpage doesnt further wrap it...

H:184 M:492 V:99 590417 stat mob 20.serpent
NEUTRAL-SEX MOB - Name : serpent giant black [R-Number1818], In room
[56728]
V-Number [56700]
Short description: a giant black Serpent
Title: None
Long description: A Giant Black Serpent is coiled here, ready to
STRIKE!

Monster Class: Normal Level [38] Alignment[-780]
Birth : [1042665334]secs, Logon[1042665334]secs, Played[0]secs
Age: [17] Years, [0] Months, [5] Days, [19] Hours
Height [198]cm Weight [200]pounds
Hometown[0], Speaks[0/0/0], (STL[0/0/0/0]/per[25]/NSTL[5])
Str:[23] Int:[25] Wis:[25] Dex:[24] Con:[25]
Mana p.:[100/100+38] Hit p.:[4082/4082+38] Move p.:[50/50+38]
AC:[-120/10 -90], Coins: [4831/0], Exp: [149136], Hitroll: [31],
Damroll: [82]
Position: Standing, Fighting: Nobody, Hunting: Nobody
Default position: Fighting,NPC flags: SENTINEL ISNPC AGGRESSIVE
STAY-ZONE BACKSTAB_AWARE ,Timer [0]

Mobile Special procedure : None
NPC Bare Hand Damage 6d9.
Carried weight: 0 Carried items: 0
Items in inventory: 0, Items in equipment: 1
Apply saving throws: [2] [2] [2] [2] [2]
Thirst: -1, Hunger: -1, Drunk: -1
Master is 'NOBODY'
Followers are:
Affected by: DETECT-INVISIBLE SENSE-LIFE SANCTUARY HASTE DODGE
SNEAK HIDE BALL-O-LIGHT

would really like to get the idea of how to capture these values as variables, into an excel file, any format