Search replace and upload?

mko123

Well I've a .txt file right here, with alot of text.
I would like to take certain lines containing what I want and transfer them to a MySQL server. I do think this might be a quite hard one but alright.
Here some lines from my .txt file:

Loading Ambient.scr
player::Sentient::DeactivateWeapon : Tried to deactivate a non-active weapon in hand 0

local.weap = $("w" + local.n).model  (global/weapontrade.scr, 8)
local.weap = $("w" + local.n)^

^~^~^ Script Error: Field 'model' applied to NULL listener

clientCommand: †|RCR|† sƒ¢.Sef^  *{Wa}* : 195 : _lias screenshot say I have been caught with a hacked SS
clientCommand: Skullcandy : 178 : score
Cvar_Set2: bertox 0
clientCommand: †|RCR|† sƒ¢.Sef^  *{Wa}* : 196 : dmmessage 0 lose at bash

And the line I would like to get out is this one:

clientCommand: †|RCR|† sƒ¢.Sef^  *{Wa}* : 196 : dmmessage 0 lose at bash

Alright, now when I have said that. I would like some help making a script which finds these kinda lines, aka chat.
Than transfer them into variables:

clientCommand: †|RCR|† sƒ¢.Sef^  *{Wa}* : 196 : dmmessage 0 lose at bash

†|RCR|† sƒ¢.Sef^  *{Wa}* :  lose at bash

So it removes the unneeded commands as: clientcommand, dmmessage, numbers.

Than i would like the name and the message to be each a variable which i could upload too a mysql like this.

$send = "INSERT into logs (type, name)
VALUES('$name', '$message')"

I've seen this been done, do anyone here know how to do it? Remember the file with logg wil also be uploaded once a day, so I would like the script to know where it stopped and where too start.

If further explanation is needed please post.

Thanks!

messels

what i didn't get is are you looking for the same thing over and over again or are you having to create a new pattern each time?

like, will the script simply be locating the same data over and over again or is the "code" [you'll ultimately upload to the db] changing over time?

if it's changing over time, how does it work? like, what changes and how?

if it's the "same thing" over and over again it shouldnt' be too hard using preg_match [which i've been playing with over and over again for the last few weeks myself]. if the "pattern" changes then you'll have to write a script for managing the changes so that the "pattern-hunter" script is correctly configured to locate the pattern [and then separate and upload to the server].

mko123

that's the problem, I've a log file here, which continues writing information from server and such.
What I want is to upload this file to an ftp server (easy, ill do it) once a day, at the night. (Cron job).
Well than do as I said find those lines and change them into variables and upload them to a mysql.
Nvm the over again, I will delete it at night and stat a new one each day. So theres only 1 file each day which i want to change into variable. Like for example this:

†|RCR|† sƒ¢.Sef^  *{Wa}* :  lose at bash

To this:

$name : $message

You see where im heading? I could explain word by word but i hope u you get what I mean now, nvm the things with same thing over again.

mko123

gonna bumb this one, anyone?

mko123

Anyone?
I really need this asap, does noone know how to do this?
Help please.