[xsl] distinct moves problem

Subject: [xsl] distinct moves problem
From: Ahmad J Reeves <ahmad@xxxxxxxxxxxxxx>
Date: Mon, 07 Jan 2002 14:04:25 +0000
Hi all,

Just wanted to say thanks once again for helping
questions. This is the best list I've seen for
genral helpfulness and good things!

Just a quick question, with the same data..

<LOG>      
      <DIRECT>
      <COMMUNICATION_TYPE> PAGETELL </COMMUNICATION_TYPE>
      <Invoc_serial> 27 </Invoc_serial>
      <Serial> 3087908 </Serial>
      <USAGE> TELL </USAGE>
      <MESSAGE_TYPE> EMOTE </MESSAGE_TYPE>
      <CHARACTER_ID> 10010 </CHARACTER_ID>
      <CHARACTER_STATUS> 3 </CHARACTER_STATUS>
      <LOCATION_ID> 45040 </LOCATION_ID>
      <TARGET_CHARACTER_ID> 444444 </TARGET_CHARACTER_ID>
      <TARGET_CHARACTER_STATUS> 6 </TARGET_CHARACTER_STATUS>
      <TARGET_CHARACTER_LOCATION_ID> 23222
</TARGET_CHARACTER_LOCATION_ID>
      <MESSAGE>hello</MESSAGE>
      <TIME> 'Mon, 26 Nov 2001 15:40:29 +0000' </TIME>
      </DIRECT>

etc etc 50,000 or so times
</LOG>

I also need to track the movement of a character. So
for example I know that a certain character_id has
been in say 25 rooms of which 9 were unique, but
I cant see how I can work out the number of distinct moves he makes
using xsl.

So I can get output like this:-

Ch-ID   in-room     Message  Target-ID  time
23470  45040        Hello    12345      10:19
23470  43333        Hi       23432      10:23
23470  45040        Yo       43333      10:44

etc..
etc..

This tells me he was in a total of three rooms of which
2 were unique AND he has made 2 MOVES so far. So I need
to work out the total number of distinct moves per character-ID,
with a total and average for all of them.

Any help gratfully received,

Cheers

Ahmad

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Current Thread