[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

distinct moves problem

Subject: distinct moves problem
From: Ahmad J Reeves <ahmad@xxxxxxxxxxxxxx>
Date: Mon, 07 Jan 2002 14:04:25 +0000
unique moves for cheers
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

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.