Zugg Software :: View topic - Help with script to log info into database

Magician Joined: 29 Nov 2005 Posts: 482

What i need is a script that will take this log that is sent to zmud and have it do a couple of things

1.) only pick the lines that have to do with Deposit of clan gemstones.

2.) Need it to put in some form (variable or database) TAMLIN 7 MONTH

3.) basically i wanna track how many each person from clan puts in over the course of the month. We have a requirement of 100 so I need it to store the info so i can pull it into an alias

EXAMPLE OUTPUT

Wizard Joined: 15 Jan 2002 Posts: 1644 Location: USA

Not too hard

#TRIGGER {Clan 96 ~((%w)~): Deposit of (%d) clan gemstones.} {
#ADD Gemstones.%1 %2
}

#ALIAS showcount {
#SHOW Clan Kindred Root Tally
#SHOW Members who met their goal
#PRIO {#LOOPDB @gemstones {
#ADD monthtotal %val
#IF (%val>=100) {#SHOW %key %val}}}
#SHOW Those Who didn't
#PRIO {#LOOPDB @gemstones {#IF (%val<100) {#SHOW %key %val}}
#SHOW Total for the month @monthtotal
}

Magician Joined: 29 Nov 2005 Posts: 482

that part works great it talls the roots etc.. awesome job

However the log only holds so many entries so we have to run it more than 1 time per month and the log will hold information on previous months as well. we want to keep a running total of the current month balance

We are going to add a clan log entry to seperate the log as we count it i.e. seperator ---------------Root Log Pulled---------------------------
so we can stop the count at that point so we dont do more them more than 1 time

What i have so far