def __init__(self, smsdb, abookdb=None, abimgdb=None):

QtGui.QMainWindow.__init__(self)

self.chat_session_list = []

self.address_book_list = []

if smsdb == None:

self.smsdb = None

else:

self.smsdb = smsdb

if abookdb == "" or abookdb is None:

self.abookdb = None

else:

self.abookdb = abookdb

if abimgdb == "" or abimgdb is None:

self.abimgdb = None

else:

self.abimgdb = abimgdb

self.ui = Ui_frmSMS()

self.ui.setupUi(self)

self.setAttribute(QtCore.Qt.WA_DeleteOnClose)

QtCore.QObject.connect(self.ui.tableViewChats, QtCore.SIGNAL("itemSelectionChanged()"), self.onTreeClick)

QtCore.QObject.connect(self.ui.actionReport, QtCore.SIGNAL("triggered(bool)"), self.printReport)

QtCore.QObject.connect(self.ui.actionExtract, QtCore.SIGNAL("triggered(bool)"), self.extractApp)

if self.abookdb is not None:

self.address_book_list = get_addressbook(self.abookdb, self.abimgdb)

msgstore = sqlite3.connect(self.smsdb)

msgstore.row_factory = sqlite3.Row

c1 = msgstore.cursor()

self.chat_session_list = getChatSessions(c1, self.address_book_list)

self.chat_session_list = getChatMessages(c1, self.chat_session_list)

chatsmodel = ChatsTableModel(self.chat_session_list)

self.ui.tableViewChats.setModel(chatsmodel)

self.ui.tableViewChats.setSortingEnabled(True)

def onTreeClick(self):

index = self.ui.tableViewChats.currentIndex()

row = index.row()

msgmodel = MessagesTableModel(self.chat_session_list[row].msg_list)

self.ui.tableViewMessages.setModel(msgmodel)

def extractApp(self):

pass

def printReport(self):

path = expanduser("~")

outdir = QtGui.QFileDialog.getExistingDirectory(self, "Open Directory", path,

QtGui.QFileDialog.ShowDirsOnly | QtGui.QFileDialog.DontResolveSymlinks);

if (outdir == None) or (len(outdir) == 0):

return None

outfile = outdir + "/SMS-Report"

def __init__(self, chats=None, parent=None):

super(ChatsTableModel, self).__init__(parent)

if chats is None:

self.chats = []

else:

self.chats = chats

def rowCount(self, parent):

return len(self.chats)

def columnCount(self, parent):

return 6

def data(self, index, role=QtCore.Qt.DisplayRole):

if not index.isValid():

return None #QtCore.QVariant()

elif role != QtCore.Qt.DisplayRole:

return None #QtCore.QVariant()

col = index.column()

row = index.row()

if col == 0:

return self.chats[row].row_id

if col == 1:

if self.chats[row].ab_contact == "" or self.chats[row].ab_contact is None or self.chats[row].ab_contact is False:

return self.chats[row].chat_id

else:

return self.chats[row].ab_contact + " (" + self.chats[row].chat_id + ")"

if col == 2:

return self.chats[row].service_name

if col == 3:

return self.chats[row].state

if col == 4:

return self.chats[row].msg_count

if col == 5:

return self.chats[row].last_msgdate

def headerData(self, section, orientation, role=QtCore.Qt.DisplayRole):

if role != QtCore.Qt.DisplayRole:

return None #QtCore.QVariant()

if orientation == QtCore.Qt.Horizontal:

if section == 0:

return "RowID"

elif section == 1:

return "ChatID"

elif section == 2:

return "Service Name"

elif section == 3:

return "State"

elif section == 4:

return "#Msg"

elif section == 5:

return "Last Msg"

def sort(self, Ncol, order):

"""Sort table by given column number.

"""

self.layoutAboutToBeChanged.emit()

self.chats = sorted(self.chats, self.chats[0].row_id)

if order == Qt.DescendingOrder:

self.chats.reverse()

def __init__(self, messages=None, parent=None):

super(MessagesTableModel, self).__init__(parent)

if messages is None:

self.messages = []

else:

self.messages = messages

def rowCount(self, parent):

return len(self.messages)

def columnCount(self, parent):

return 5

def data(self, index, role=QtCore.Qt.DisplayRole):

if not index.isValid():

return None #QtCore.QVariant()

elif role != QtCore.Qt.DisplayRole:

return None #QtCore.QVariant()

col = index.column()

row = index.row()

if col == 0:

return self.messages[row].row_id

if col == 1:

return self.messages[row].msg_date

if col == 2:

return self.messages[row].date_read

if col == 3:

return self.messages[row].contact_from

if col == 4:

return self.messages[row].msg_text

def headerData(self, section, orientation, role=QtCore.Qt.DisplayRole):

if role != QtCore.Qt.DisplayRole:

return None #QtCore.QVariant()

if orientation == QtCore.Qt.Horizontal:

if section == 0:

return "RowID"

if section == 1:

return "Msg Date"

if section == 2:

return "Date Read"

if section == 3:

return "From"

if section == 4:

global PYTHON_VERSION

if PYTHON_VERSION == 2:

newtext = convert_smileys_python_2.convertsmileys_python2 (text)

elif PYTHON_VERSION == 3:

newtext = convert_smileys_python_2.convertsmileys_python3 (text)

outfile = '%s.html' % outfile

wfile = open(outfile,'wb')

print ("printing output to "+outfile+" ...")

# writes page header

wfile.write('<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"\n'.encode('utf-8'))

wfile.write('"http://www.w3.org/TR/html4/loose.dtd">\n'.encode('utf-8'))

wfile.write('<html><head><title>{}</title>\n'.format(outfile).encode('utf-8'))

wfile.write('<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>\n'.encode('utf-8'))

wfile.write('<meta name="GENERATOR" content="SMS Xtract v2.0"/>\n'.encode('utf-8'))

# adds page style

wfile.write(css_style.encode('utf-8'))

# adds javascript to make the tables sortable

wfile.write('\n<script type="text/javascript">\n'.encode('utf-8'))

wfile.write(popups.encode('utf-8'))

wfile.write(sortable.encode('utf-8'))

wfile.write('</script>\n\n'.encode('utf-8'))

wfile.write('</head><body>\n'.encode('utf-8'))

# H1 Title

wfile.write('<h1>iOS Forensic<h1>'.encode('utf-8'))

# H2 DB Owner

wfile.write('<a name="top"></a><h2>'.encode('utf-8'))

wfile.write('SMS '.encode('utf-8'))

wfile.write('<img src="data/img/message.png" alt="" '.encode('utf-8'))

wfile.write('style="width:40px;height:40px;vertical-align:middle"/>'.encode('utf-8'))

wfile.write('Xtract &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.encode('utf-8'))

wfile.write('<img src="data/img/apple.png" alt="" '.encode('utf-8'))

wfile.write('style="width:35px;height:35px;"/>'.encode('utf-8'))

wfile.write('&nbsp;{}</h2>\n'.format(owner).encode('utf-8'))

# writes 1st table header "CHAT SESSION"

wfile.write('<table class="sortable" id="chatsession" border="1" cellpadding="2" cellspacing="0">\n'.encode('utf-8'))

wfile.write('<thead>\n'.encode('utf-8'))

wfile.write('<tr>\n'.encode('utf-8'))

wfile.write('<th>ROWID</th>\n'.encode('utf-8'))

wfile.write('<th>CHATID</th>\n'.encode('utf-8'))

wfile.write('<th>SERVICE NAME</th>\n'.encode('utf-8'))

wfile.write('<th>STATE</th>\n'.encode('utf-8'))

wfile.write('<th># Msg</th>\n'.encode('utf-8'))

wfile.write('<th>Last Msg</th>\n'.encode('utf-8'))

wfile.write('</tr>\n'.encode('utf-8'))

wfile.write('</thead>\n'.encode('utf-8'))

# writes 1st table content

wfile.write('<tbody>\n'.encode('utf-8'))

for i in chat_session_list:

wfile.write('<tr>\n'.encode('utf-8'))

wfile.write('<td>{}</td>\n'.format(i.row_id).encode('utf-8'))

if i.ab_contact == "" or i.ab_contact is None or i.ab_contact is False:

wfile.write('<td class="contact"><a href="#{}">{}</a></td>\n'.format(i.chat_id, i.chat_id).encode('utf-8'))

else:

wfile.write('<td class="contact"><a href="#{}">{}</a></td>\n'.format(i.chat_id, i.ab_contact + " (" + i.chat_id + ")").encode('utf-8'))

wfile.write('<td>{}</td>\n'.format(i.service_name).encode('utf-8'))

wfile.write('<td>{}</td>\n'.format(i.state).encode('utf-8'))

wfile.write('<td>{}</td>\n'.format(i.msg_count).encode('utf-8'))

wfile.write('<td><a href="#{}">{}</a></td>\n'.format(str(i.last_msgdate).replace(" ", "&nbsp;"),str(i.last_msgdate).replace(" ", "&nbsp;")).encode('utf-8'))

wfile.write('</tr>\n'.encode('utf-8'))

wfile.write('</tbody>\n'.encode('utf-8'))

# writes 1st table footer

wfile.write('</table>\n'.encode('utf-8'))

global content_type

# writes a table for each chat session

for i in chat_session_list:

if i.ab_contact == "" or i.ab_contact is None or i.ab_contact is False:

wfile.write('<h3>Chat session <a href="#top">#</a> {}: <a name="{}">: {}</a></h3>\n'.format(i.chat_id, i.chat_id, i.msg_count).encode('utf-8'))

else:

wfile.write('<h3>Chat session <a href="#top">#</a> {}: <a name="{}">: {}</a></h3>\n'.format(i.ab_contact, i.chat_id, i.msg_count).encode('utf-8'))

wfile.write('<table class="sortable" id="msg_{}" border="1" cellpadding="2" cellspacing="0">\n'.format(i.chat_id).encode('utf-8'))

wfile.write('<thead>\n'.encode('utf-8'))

wfile.write('<tr>\n'.encode('utf-8'))

wfile.write('<th>RowID</th>\n'.encode('utf-8'))

wfile.write('<th>ChatID</th>\n'.encode('utf-8'))

wfile.write('<th>Msg date</th>\n'.encode('utf-8'))

wfile.write('<th>Read Date</th>\n'.encode('utf-8'))

wfile.write('<th>From</th>\n'.encode('utf-8'))

wfile.write('<th>Msg content</th>\n'.encode('utf-8'))

wfile.write('</tr>\n'.encode('utf-8'))

wfile.write('</thead>\n'.encode('utf-8'))

# writes table content

wfile.write('<tbody>\n'.encode('utf-8'))

for y in i.msg_list:

#print "%s %s %s" %(i.row_id, i.chat_id, y.msg_text)

# Determine type of content (for future use)

content_type = None

# handle only text messages

content_type = CONTENT_TEXT

# row class selection

#if content_type == CONTENT_NEWGROUPNAME:

# wfile.write('<tr class="newgroupname">\n'.encode('utf-8'))

#el

if str(y.is_fromme) == "1":

wfile.write('<tr class="me">\n'.encode('utf-8'))

else:

wfile.write('<tr class="other">\n'.encode('utf-8'))

wfile.write('<td>{}</td>\n'.format(y.row_id).encode('utf-8'))

# ChatID

wfile.write('<td>{}</td>\n'.format(i.chat_id).encode('utf-8'))

# Chat name

#wfile.write('<td class="contact">{}</td>\n'.format(y.contact_from).encode('utf-8'))

# Msg date <a href="#top">#</a><a name="{}">: {}</a>

wfile.write('<td><a href="#top">#</a><a name="{}">: {}</a></td>\n'.format(str(y.msg_date).replace(" ","&nbsp;"),str(y.msg_date).replace(" ","&nbsp;")).encode('utf-8'))

# Msg read date

wfile.write('<td>{}</td>\n'.format(str(y.date_read).replace(" ","&nbsp;")).encode('utf-8'))

# From

wfile.write('<td class="contact">{}</td>\n'.format(y.contact_from).encode('utf-8'))

# date elaboration for further use

date = str(y.msg_date)[:10]

if date != 'N/A' and date != 'N/A error':

date = int(date.replace("-",""))

if content_type == CONTENT_TEXT or content_type == CONTENT_OTHER:

msgtext = convertsmileys ( y.msg_text )

msgtext = re.sub(r'(http[^\s\n\r]+)', r'<a onclick="image(this.href);return(false);" target="image" href="\1">\1</a>', msgtext)

msgtext = re.sub(r'((?<!\S)www\.[^\s\n\r]+)', r'<a onclick="image(this.href);return(false);" target="image" href="http://\1">\1</a>', msgtext)

msgtext = msgtext.replace ("\n", "<br>\n")

try:

wfile.write('<td class="text">{}'.format(msgtext).encode('utf-8'))

except:

wfile.write('<td class="text">N/A'.encode('utf-8'))

# wfile.write(str(content_type)) #Debug

wfile.write('</td>\n'.encode('utf-8'))

wfile.write('</tbody>\n'.encode('utf-8'))

# writes 1st table footer

wfile.write('</table>\n'.encode('utf-8'))

# writes page footer

wfile.write('</body></html>\n'.encode('utf-8'))

wfile.close()

print ("done!")

#END

# gets all the chat sessions

count_chats = 0

chat_session_list = []

try:

c1.execute("SELECT m.rowid as ROWID, m.chat_identifier as CHATID, m.service_name as SERVICENAME, m.state as STATE, h.rowid as HNDLROWID, h.id as HNDLID, h.country as HNDLCOUNTRY, h.service as HNDLSERVICE FROM chat m, handle h Where m.chat_identifier = h.id and m.service_name = h.service")

for chats in c1:

count_chats = count_chats + 1

abcontact = ""

if address_book_list is not None:

abcontact = search_number_in_ab(address_book_list, chats["HNDLID"])

#print chats

curr_chat = MSGChat(chats["ROWID"],chats["CHATID"],chats["HNDLROWID"],chats["SERVICENAME"],chats["STATE"],chats["HNDLID"],chats["HNDLCOUNTRY"],chats["HNDLSERVICE"], abcontact)

chat_session_list.append(curr_chat)

chat_session_list = sorted(chat_session_list, key=lambda Chatsession: Chatsession.chat_id, reverse=True)

return chat_session_list

except sqlite3.Error as msg:

print('Error: {}'.format(msg))

# for each chat session, gets all messages

count_chats = 0

for chats in chat_session_list:

count_chats = count_chats + 1

try:

sqlcmd = "SELECT m.rowid as ROWID, m.date as DATE, m.date_read AS DATEREAD, m.is_delivered AS ISDELIVERED, m.is_finished AS ISFINISHED, m.is_read AS ISREAD, m.is_sent AS ISSENT, m.is_from_me as ISFROMME, m.handle_id AS HDLID, m.text as MSGTEXT FROM message m WHERE m.handle_id = %s" %chats.handle_rowid

c1.execute(sqlcmd)

count_messages = 0

for msgs in c1:

count_messages = count_messages + 1

#print "%s %s" %(chats.chat_id, msgs["MSGTEXT"])

try:

curr_message = MSGMessage(msgs["ROWID"],msgs["DATE"],msgs["DATEREAD"],msgs["ISDELIVERED"],msgs["ISFINISHED"],msgs["ISREAD"],msgs["ISSENT"],msgs["ISFROMME"],chats.chat_id,msgs["MSGTEXT"])

except sqlite3.Error as msg:

print('Error while reading message #{} in chat #{}: {}'.format(count_messages, chats.row_id, msg))

curr_message = MSGMessage(None,None,None,None,None,None,None,None,None,"_Error: sqlite3.Error, see output in window")

except TypeError as msg:

print('Error while reading message #{} in chat #{}: {}'.format(count_messages, chats.row_id, msg))

curr_message = MSGMessage(None,None,None,None,None,None,None,None,None,"_Error: TypeError, see output in window")

chats.msg_list.append(curr_message)

chats.set_last_msg_date(curr_message.msg_date)

chats.msg_count = count_messages

except sqlite3.Error as msg:

print('Error sqlite3.Error while reading chat #{}: {}'.format(chats.row_id, msg))

return None

except TypeError as msg:

print('Error TypeError while reading chat #{}: {}'.format(chats.row_id, msg))

return None

chat_session_list = []

address_book_list = []

global mode

global PYTHON_VERSION

# parser options

parser = ArgumentParser(description='Converts a iOS SMS database to HTML.')

parser.add_argument('-s', '--smsdb', dest='smsfile',

help="input 'SMS Database' (iPhone) file to scan")

parser.add_argument('-a', '--abdb', dest='abfile',

help="input 'Addressbook Database' (iPhone) file to scan")

parser.add_argument('-o', '--outfile', dest='outfile',

help="optionally choose name of output file")

options = parser.parse_args()

# checks for the input file

if options.smsfile is None:

parser.print_help()

sys.exit(1)

if not os.path.exists(options.smsfile):

print('"{}" file is not found!'.format(options.smsfile))

sys.exit(1)

if options.abfile is not None:

if not os.path.exists(options.abfile):

print('"{}" file is not found!'.format(options.abfile))

address_book_list = get_addressbook(options.abfile)

# connects to the database(s)

msgstore = sqlite3.connect(options.smsfile)

msgstore.row_factory = sqlite3.Row

c1 = msgstore.cursor()

# check on platform

mode = IPHONE

print ("iPhone mode!\n")

chat_session_list = getChatSessions(c1, address_book_list)

chat_session_list = getChatMessages(c1, chat_session_list)

# OUTPUT

if options.outfile is None:

outfile = "SMS-Report"

else:

outfile = options.outfile

<style type="text/css">

body {

font-family: calibri;

background-color: #f5f5f5;

}

h1 {

font-family: courier;

font-style:italic;

color: #444444;

}

h2 {

font-style:italic;

color: #444444;

}

h3 {

font-style:italic;

}

table {

text-align: center;

}

th {

font-style:italic;

}

td.text {

width: 600px;

text-align: left;

}

td.contact {

width: 250px;

}

tr.even {

background-color: #DDDDDD

}

tr.me {

background-color: #88FF88;

}

tr.other {

background-color: #F5F5F5;

}

tr.newgroupname {

background-color: #FFCC33;

}

</style>

function media( url )

{

if (typeof(newwindow) !== "undefined" && !newwindow.closed)

{

newwindow.close();

} else

{

}

newwindow=window.open("about:blank", "media", "menubar=0,location=1");

newwindow.document.write('<html><body><embed src="' + url + '" width="800" height="600" /></body></html>');

//newwindow.document.write('<video src="' + url + '" controls="controls">video doesn't work</video>');

}

function image( url )

{

if (typeof(imagewindow) !== "undefined" && !imagewindow.closed)

{

imagewindow=window.open(url,'image','menubar=0,location=1');

imagewindow.focus();

} else

{

imagewindow=window.open(url,'image','menubar=0,location=1');

}

}

/*

Table sorting script by Joost de Valk, check it out at http://www.joostdevalk.nl/code/sortable-table/.

Based on a script from http://www.kryogenix.org/code/browser/sorttable/.

Distributed under the MIT license: http://www.kryogenix.org/code/browser/licence.html .

Copyright (c) 1997-2007 Stuart Langridge, Joost de Valk.

Version 1.5.7

*/

/* You can change these values */

var image_path = "data/sort-table/";

var image_up = "arrow-up.gif";

var image_down = "arrow-down.gif";

var image_none = "arrow-none.gif";

var europeandate = true;

var alternate_row_colors = true;

/* Don't change anything below this unless you know what you're doing */

addEvent(window, "load", sortables_init);

var SORT_COLUMN_INDEX;

var thead = false;

function sortables_init() {

// Find all tables with class sortable and make them sortable

if (!document.getElementsByTagName) return;

tbls = document.getElementsByTagName("table");

for (ti=0;ti<tbls.length;ti++) {

thisTbl = tbls[ti];

if (((' '+thisTbl.className+' ').indexOf("sortable") != -1) && (thisTbl.id)) {

ts_makeSortable(thisTbl);

}

}

}

function ts_makeSortable(t) {

if (t.rows && t.rows.length > 0) {

if (t.tHead && t.tHead.rows.length > 0) {

var firstRow = t.tHead.rows[t.tHead.rows.length-1];

thead = true;

} else {

var firstRow = t.rows[0];

}

}

if (!firstRow) return;

// We have a first row: assume it's the header, and make its contents clickable links

for (var i=0;i<firstRow.cells.length;i++) {

var cell = firstRow.cells[i];

var txt = ts_getInnerText(cell);

if (cell.className != "unsortable" && cell.className.indexOf("unsortable") == -1) {

cell.innerHTML = '<a href="#" class="sortheader" onclick="ts_resortTable(this, '+i+');return false;">'+txt+'<span class="sortarrow">&nbsp;&nbsp;<img src="'+ image_path + image_none + '" alt="&darr;"/></span></a>';

}

}

if (alternate_row_colors) {

alternate(t);

}

}

function ts_getInnerText(el) {

if (typeof el == "string") return el;

if (typeof el == "undefined") { return el };

if (el.innerText) return el.innerText; //Not needed but it is faster

var str = "";

var cs = el.childNodes;

var l = cs.length;

for (var i = 0; i < l; i++) {

switch (cs[i].nodeType) {

case 1: //ELEMENT_NODE

str += ts_getInnerText(cs[i]);

break;

case 3: //TEXT_NODE

str += cs[i].nodeValue;

break;

}

}

return str;

}

function ts_resortTable(lnk, clid) {

var span;

for (var ci=0;ci<lnk.childNodes.length;ci++) {

if (lnk.childNodes[ci].tagName && lnk.childNodes[ci].tagName.toLowerCase() == 'span') span = lnk.childNodes[ci];

}

var spantext = ts_getInnerText(span);

var td = lnk.parentNode;

var column = clid || td.cellIndex;

var t = getParent(td,'TABLE');

// Work out a type for the column

if (t.rows.length <= 1) return;

var itm = "";

var i = 0;

while (itm == "" && i < t.tBodies[0].rows.length) {

var itm = ts_getInnerText(t.tBodies[0].rows[i].cells[column]);

itm = trim(itm);

if (itm.substr(0,4) == "<!--" || itm.length == 0) {

itm = "";

}

i++;

}

if (itm == "") return;

sortfn = ts_sort_caseinsensitive;

if (itm.match(/^\d\d[\/\.-][a-zA-z][a-zA-Z][a-zA-Z][\/\.-]\d\d\d\d$/)) sortfn = ts_sort_date;

if (itm.match(/^\d\d[\/\.-]\d\d[\/\.-]\d\d\d{2}?$/)) sortfn = ts_sort_date;

if (itm.match(/^-?[£$€Û¢´]\d/)) sortfn = ts_sort_numeric;

if (itm.match(/^-?(\d+[,\.]?)+(E[-+][\d]+)?%?$/)) sortfn = ts_sort_numeric;

SORT_COLUMN_INDEX = column;

var firstRow = new Array();

var newRows = new Array();

for (k=0;k<t.tBodies.length;k++) {

for (i=0;i<t.tBodies[k].rows[0].length;i++) {

firstRow[i] = t.tBodies[k].rows[0][i];

}

}

for (k=0;k<t.tBodies.length;k++) {

if (!thead) {

// Skip the first row

for (j=1;j<t.tBodies[k].rows.length;j++) {

newRows[j-1] = t.tBodies[k].rows[j];

}

} else {

// Do NOT skip the first row

for (j=0;j<t.tBodies[k].rows.length;j++) {

newRows[j] = t.tBodies[k].rows[j];

}

}

}

newRows.sort(sortfn);

if (span.getAttribute("sortdir") == 'down') {

ARROW = '&nbsp;&nbsp;<img src="'+ image_path + image_down + '" alt="&darr;"/>';

newRows.reverse();

span.setAttribute('sortdir','up');

} else {

ARROW = '&nbsp;&nbsp;<img src="'+ image_path + image_up + '" alt="&uarr;"/>';

span.setAttribute('sortdir','down');

}

// We appendChild rows that already exist to the tbody, so it moves them rather than creating new ones

// don't do sortbottom rows

for (i=0; i<newRows.length; i++) {

if (!newRows[i].className || (newRows[i].className && (newRows[i].className.indexOf('sortbottom') == -1))) {

t.tBodies[0].appendChild(newRows[i]);

}

}

// do sortbottom rows only

for (i=0; i<newRows.length; i++) {

if (newRows[i].className && (newRows[i].className.indexOf('sortbottom') != -1))

t.tBodies[0].appendChild(newRows[i]);

}

// Delete any other arrows there may be showing

var allspans = document.getElementsByTagName("span");

for (var ci=0;ci<allspans.length;ci++) {

if (allspans[ci].className == 'sortarrow') {

if (getParent(allspans[ci],"table") == getParent(lnk,"table")) { // in the same table as us?

allspans[ci].innerHTML = '&nbsp;&nbsp;<img src="'+ image_path + image_none + '" alt="&darr;"/>';

}

}

}

span.innerHTML = ARROW;

alternate(t);

}

function getParent(el, pTagName) {

if (el == null) {

return null;

} else if (el.nodeType == 1 && el.tagName.toLowerCase() == pTagName.toLowerCase()) {

return el;

} else {

return getParent(el.parentNode, pTagName);

}

}

function sort_date(date) {

// y2k notes: two digit years less than 50 are treated as 20XX, greater than 50 are treated as 19XX

dt = "00000000";

if (date.length == 11) {

mtstr = date.substr(3,3);

mtstr = mtstr.toLowerCase();

switch(mtstr) {

case "jan": var mt = "01"; break;

case "feb": var mt = "02"; break;

case "mar": var mt = "03"; break;

case "apr": var mt = "04"; break;

case "may": var mt = "05"; break;

case "jun": var mt = "06"; break;

case "jul": var mt = "07"; break;

case "aug": var mt = "08"; break;

case "sep": var mt = "09"; break;

case "oct": var mt = "10"; break;

case "nov": var mt = "11"; break;

case "dec": var mt = "12"; break;

// default: var mt = "00";

}

dt = date.substr(7,4)+mt+date.substr(0,2);

return dt;

} else if (date.length == 10) {

if (europeandate == false) {

dt = date.substr(6,4)+date.substr(0,2)+date.substr(3,2);

return dt;

} else {

dt = date.substr(6,4)+date.substr(3,2)+date.substr(0,2);

return dt;

}

} else if (date.length == 8) {

yr = date.substr(6,2);

if (parseInt(yr) < 50) {

yr = '20'+yr;

} else {

yr = '19'+yr;

}

if (europeandate == true) {

dt = yr+date.substr(3,2)+date.substr(0,2);

return dt;

} else {

dt = yr+date.substr(0,2)+date.substr(3,2);

return dt;

}

}

return dt;

}

function ts_sort_date(a,b) {

dt1 = sort_date(ts_getInnerText(a.cells[SORT_COLUMN_INDEX]));

dt2 = sort_date(ts_getInnerText(b.cells[SORT_COLUMN_INDEX]));

if (dt1==dt2) {

return 0;

}

if (dt1<dt2) {

return -1;

}

return 1;

}

function ts_sort_numeric(a,b) {

var aa = ts_getInnerText(a.cells[SORT_COLUMN_INDEX]);

aa = clean_num(aa);

var bb = ts_getInnerText(b.cells[SORT_COLUMN_INDEX]);

bb = clean_num(bb);

return compare_numeric(aa,bb);

}

function compare_numeric(a,b) {

var a = parseFloat(a);

a = (isNaN(a) ? 0 : a);

var b = parseFloat(b);

b = (isNaN(b) ? 0 : b);

return a - b;

}

function ts_sort_caseinsensitive(a,b) {

aa = ts_getInnerText(a.cells[SORT_COLUMN_INDEX]).toLowerCase();

bb = ts_getInnerText(b.cells[SORT_COLUMN_INDEX]).toLowerCase();

if (aa==bb) {

return 0;

}

if (aa<bb) {

return -1;

}

return 1;

}

function ts_sort_default(a,b) {

aa = ts_getInnerText(a.cells[SORT_COLUMN_INDEX]);

bb = ts_getInnerText(b.cells[SORT_COLUMN_INDEX]);

if (aa==bb) {

return 0;

}

if (aa<bb) {

return -1;

}

return 1;

}

function addEvent(elm, evType, fn, useCapture)

// addEvent and removeEvent

// cross-browser event handling for IE5+, NS6 and Mozilla

// By Scott Andrew

{

if (elm.addEventListener){

elm.addEventListener(evType, fn, useCapture);

return true;

} else if (elm.attachEvent){

var r = elm.attachEvent("on"+evType, fn);

return r;

} else {

alert("Handler could not be removed");

}

}

function clean_num(str) {

str = str.replace(new RegExp(/[^-?0-9.]/g),"");

return str;

}

function trim(s) {

return s.replace(/^\s+|\s+$/g, "");

}

function alternate(table) {

// Take object table and get all it's tbodies.

var tableBodies = table.getElementsByTagName("tbody");

// Loop through these tbodies

for (var i = 0; i < tableBodies.length; i++) {

// Take the tbody, and get all it's rows

var tableRows = tableBodies[i].getElementsByTagName("tr");

// Loop through these rows

// Start at 1 because we want to leave the heading row untouched

for (var j = 0; j < tableRows.length; j++) {

// Check if j is even, and apply classes for both possible results

if ( (j % 2) == 0 ) {

if ( !(tableRows[j].className.indexOf('odd') == -1) ) {

tableRows[j].className = tableRows[j].className.replace('odd', 'even');

} else {

if ( tableRows[j].className.indexOf('even') == -1 ) {

tableRows[j].className += " even";

}

}

} else {

if ( !(tableRows[j].className.indexOf('even') == -1) ) {

tableRows[j].className = tableRows[j].className.replace('even', 'odd');

} else {

if ( tableRows[j].className.indexOf('odd') == -1 ) {

tableRows[j].className += " odd";

}

}

}

}

}

}