fix compilage and integrate into buildsystem

directory structure is a mess though...

5 files changed, 19 insertions, 6 deletions

diff --git a/noncore/apps/qashmoney/config.in b/noncore/apps/qashmoney/config.in
new file mode 100644
index 0000000..94c39b6
--- a/dev/null
+++ b/noncore/apps/qashmoney/config.in
@@ -0,0 +1,4 @@
+  config QASHMONEY
+    boolean "opie-qashmoney (money manager)" 
+    default "n"
+    depends ( LIBQPE || LIBQPE-X11 ) && LIBOPIE
diff --git a/noncore/apps/qashmoney/qashmoney.pro b/noncore/apps/qashmoney/qashmoney.pro
index 1070767..8b4646a 100755
--- a/noncore/apps/qashmoney/qashmoney.pro
+++ b/noncore/apps/qashmoney/qashmoney.pro
@@ -1,41 +1,49 @@
 TEMPLATE = app
 CONFIG = qt warn_on release
 HEADERS =	qashmoney.h \
 			accountdisplay.h \
                         account.h \
                         transaction.h \
                         transactiondisplay.h \
                         newtransaction.h \
                         transfer.h \
                         transferdialog.h \
                         preferences.h \
                         preferencedialogs.h \
                         memory.h \
                         memorydialog.h \
                         newaccount.h \
                         calculator.h \
                         datepicker.h \
                         budget.h \
                         budgetdisplay.h \
                         currency.h
 SOURCES =	qashmoney.cpp \
 			accountdisplay.cpp \
                         account.cpp \
                         transaction.cpp \
                         transactiondisplay.cpp \
                         newtransaction.cpp \
                         transfer.cpp \
                         transferdialog.cpp \
                         preferences.cpp \
                         preferencedialogs.cpp \
                         memory.cpp \
                         memorydialog.cpp \
                         newaccount.cpp \
                         calculator.cpp \
                         datepicker.cpp \
 			main.cpp \
                         budget.cpp \
                         budgetdisplay.cpp \
                         currency.cpp
+INCLUDEPATH = $(OPIEDIR)/include
+DEPENDPATH = $(OPIEDIR)/include
+
+DESTDIR = $(OPIEDIR)/bin
+
 unix:LIBS += -lm
 LIBS += -lqpe -lqte -lstdc++ -lsqlite
+
+include ( $(OPIEDIR)/include.pro )
+
diff --git a/noncore/apps/qashmoney/transaction.cpp b/noncore/apps/qashmoney/transaction.cpp
index a3bd9e7..dcf46b1 100755
--- a/noncore/apps/qashmoney/transaction.cpp
+++ b/noncore/apps/qashmoney/transaction.cpp
@@ -1,346 +1,346 @@
 // RESERVEDONE COLUMN NAME REPRESENTS THE LINEITEMID AND SHOULD BE CHANGED IN
 // FUTURE VERSIONS OF QASHMONEY
 
 // RESERVEDTWO REPRESENTS THE TRANSACTION DESCRIPTION
 
 #include "transaction.h"
 #include "account.h"
 #include "transactiondisplay.h"
 
 #include <stdlib.h>
 #include <iostream.h>
 
 extern Account *account;
 extern Preferences *preferences;
 
 Transaction::Transaction ()
   {
     tdb = sqlite_open ( "qmtransactions.db", 0, NULL );
   }
 
 Transaction::~Transaction ()
   {
     sqlite_close ( tdb );
   }
 
 void Transaction::addTransaction ( QString description, QString payee, int accountid, int parentid, int number, int day, int month, int year, float amount, int cleared, int budgetid, int lineitemid )
   {
-    sqlite_exec_printf ( tdb, "insert into transactions values ( '%q', %i, %i, %i, %i, %i, %i, %.2f, %i, %i, 0, 0, 0, 0, 0, 0, %i, '%q', 0,
-    0, 0, 0, NULL );", 0, 0, 0, ( const char * ) payee, accountid, parentid, number, day, month, year, amount, cleared, budgetid, lineitemid, ( const char * ) description );
+    sqlite_exec_printf ( tdb, "insert into transactions values ( '%q', %i, %i, %i, %i, %i, %i, %.2f, %i, %i, 0, 0, 0, 0, 0, 0, %i, '%q', 0, "
+    "0, 0, 0, NULL );", 0, 0, 0, ( const char * ) payee, accountid, parentid, number, day, month, year, amount, cleared, budgetid, lineitemid, ( const char * ) description );
   }
 
 void Transaction::updateTransaction ( QString description, QString payee, int number, int day, int month, int year, float amount, int cleared, int budgetid, int lineitemid, int transactionid )
   {
-    sqlite_exec_printf ( tdb, "update transactions set reservedtwo = '%q', payee = '%q', number = %i, day = %i, month = %i, year = %i, amount = %.2f,
-      cleared = %i, budgetid = %i, reservedone = %i where transid = %i;", 0, 0, 0, ( const char * ) description, ( const char * ) payee, number, day, month, year,
+    sqlite_exec_printf ( tdb, "update transactions set reservedtwo = '%q', payee = '%q', number = %i, day = %i, month = %i, year = %i, amount = %.2f,"
+      "cleared = %i, budgetid = %i, reservedone = %i where transid = %i;", 0, 0, 0, ( const char * ) description, ( const char * ) payee, number, day, month, year,
       amount, cleared, budgetid, lineitemid, transactionid );
   }
 
 void Transaction::deleteTransaction ( int transid )
   {
     sqlite_exec_printf ( tdb, "delete from transactions where transid = %i;", 0, 0, 0, transid );
   }
 
 void Transaction::deleteAllTransactions ( int accountid )
   {
     sqlite_exec_printf ( tdb, "delete from transactions where accountid = %i;", 0, 0, 0, accountid );
   }
 
 int Transaction::getAccountID ( int id )
   {
     char **results;
     sqlite_get_table_printf ( tdb, "select accountid from transactions where transid= %i;", &results, NULL, NULL, NULL, id );
     return atol ( results [ 1 ] );
   }
 
 int Transaction::getNumberOfTransactions ()
   {
     char **results;
     sqlite_get_table ( tdb, "select count() from transactions;", &results, NULL, NULL, NULL );
     return atoi ( results [ 1 ] );
   }
 
 int Transaction::getNumberOfTransactions ( int accountid )
   {
     char **results;
     sqlite_get_table_printf ( tdb, "select count() from transactions where accountid = %i;", &results, NULL, NULL, NULL, accountid );
     return atol ( results [ 1 ] );
   }
 
 QString Transaction::getPayee ( int id )
   {
     char **results;
     sqlite_get_table_printf ( tdb, "select payee from transactions where transid= %i;", &results, NULL, NULL, NULL, id );
     return results [ 1 ];
   }
 
 QString Transaction::getTransactionDescription ( int id )
   {
     char **results;
     sqlite_get_table_printf ( tdb, "select reservedtwo from transactions where transid= %i;", &results, NULL, NULL, NULL, id );
     return results [ 1 ];
   }
 
 QString Transaction::getNumber ( int id )
   {
     char **results;
     sqlite_get_table_printf ( tdb, "select number from transactions where transid= %i;", &results, NULL, NULL, NULL, id );
     return results [ 1 ];
   }
 
 QString Transaction::getAmount ( int id )
   {
     char **results;
     sqlite_get_table_printf ( tdb, "select amount from transactions where transid= %i;", &results, NULL, NULL, NULL, id );
     return results [ 1 ];
   }
 
 QString Transaction::getAbsoluteAmount ( int id )
   {
     char **results;
     sqlite_get_table_printf ( tdb, "select abs ( amount ) from transactions where transid= %i;", &results, NULL, NULL, NULL, id );
     return results [ 1 ];
   }
 
 int Transaction::getCleared ( int id )
   {
     char **results;
     sqlite_get_table_printf ( tdb, "select cleared from transactions where transid= %i;", &results, NULL, NULL, NULL, id );
     QString cleared = results [ 1 ];
     return cleared.toInt();
   }
 
 void Transaction::setCleared ( int id, int cleared )
   {
     sqlite_exec_printf ( tdb, "update transactions set cleared = %i where transid = %i;", 0, 0, 0, cleared, id );
   }
 
 int Transaction::getBudgetID ( int id )
   {
     char **results;
     sqlite_get_table_printf ( tdb, "select budgetid from transactions where transid = %i;", &results, NULL, NULL, NULL, id );
     QString budgetid = results [ 1 ];
     return budgetid.toInt();
   }
 
 int Transaction::getLineItemID ( int id )
   {
     char **results;
     sqlite_get_table_printf ( tdb, "select reservedone from transactions where transid = %i;", &results, NULL, NULL, NULL, id );
     QString lineitemid = results [ 1 ];
     return lineitemid.toInt();
   }
 
 int Transaction::getDay ( int id )
   {
     char **results;
     sqlite_get_table_printf ( tdb, "select day from transactions where transid= %i;", &results, NULL, NULL, NULL, id );
     QString daystring = results [ 1 ];
     return daystring.toInt();
   }
 
 int Transaction::getMonth ( int id )
   {
     char **results;
     sqlite_get_table_printf ( tdb, "select month from transactions where transid= %i;", &results, NULL, NULL, NULL, id );
     QString monthstring = results [ 1 ];
     return monthstring.toInt();
   }
 
 int Transaction::getYear ( int id )
   {
     char **results;
     sqlite_get_table_printf ( tdb, "select year from transactions where transid= %i;", &results, NULL, NULL, NULL, id );
     QString yearstring = results [ 1 ];
     return yearstring.toInt();
   }
 
 char ** Transaction::selectAllTransactions ( QDate fromdate, bool children, const char *limit, int id )
   {
     // initialize variables
     char **results;
     int showcleared = preferences->getPreference ( 3 );
     QDate today = QDate::currentDate();
     int fromyear = fromdate.year();
     int toyear = today.year();
     int frommonth = fromdate.month();
     int tomonth = today.month();
     int fromday = fromdate.day();
 
     // construct the first part of the string
     QString query = "select day, month, year, payee, amount, transid, accountid from transactions where";
 
     if ( frommonth == tomonth && fromyear == toyear ) // our dates cross neither a month nor a year
       {
         query.append ( " year = " );
         query.append ( QString::number ( toyear ) );
         query.append ( " and month = " );
         query.append ( QString::number ( tomonth ) );
         query.append ( " and day >= " );
         query.append ( QString::number ( fromday ) );
         query.append ( " and" );
       }
     else if ( frommonth != tomonth && fromyear == toyear ) // our dates cross a month within the same year
       {
         query.append ( " year = " );
         query.append ( QString::number ( toyear ) );
         query.append ( " and ( ( month <= " );
         query.append ( QString::number ( tomonth ) );
         query.append ( " and month > " );
         query.append ( QString::number ( frommonth ) );
         query.append ( " ) or ( month = " );
         query.append ( QString::number ( frommonth ) );
         query.append ( " and day >= " );
         query.append ( QString::number ( fromday ) );
         query.append ( " ) ) and " );
       }
     else if ( fromyear != toyear && fromyear != 1900 ) // here we are showing transactions from an entire year
       {
         // divide this taks into two parts - get the transactions from the prior and then the current year
         // current year part
         int tmpfrommonth = 1; // set temporary from months and days to Jan. 1
         int tmpfromday = 1;
         query.append ( " ( year >= " );
         query.append ( QString::number ( fromyear ) );
         query.append ( " and ( month <= " );
         query.append ( QString::number ( tomonth ) );
         query.append ( " and month > " );
         query.append ( QString::number ( tmpfrommonth ) );
         query.append ( " ) or ( month = " );
         query.append ( QString::number ( tmpfrommonth ) );
         query.append ( " and day >= " );
         query.append ( QString::number ( tmpfromday ) );
         query.append ( " ) ) or" );
 
         // prior year part
         int tmptomonth = 12;
         query.append ( " ( year = " );
         query.append ( QString::number ( fromyear ) );
         query.append ( " and ( ( month <= " );
         query.append ( QString::number ( tmptomonth ) );
         query.append ( " and month > " );
         query.append ( QString::number ( frommonth ) );
         query.append ( " ) or ( month = " );
         query.append ( QString::number ( frommonth ) );
         query.append ( " and day >= " );
         query.append ( QString::number ( fromday ) );
         query.append ( " ) ) ) and " );
       }
 
     if ( account->getParentAccountID ( id ) == -1 && children == TRUE )
       query.append ( " parentid = %i and payee like '%q';" );
     else
       query.append ( " accountid = %i and payee like '%q';" );
 
     sqlite_get_table_printf ( tdb, query, &results, &rows, &columns, NULL, id, limit );
     return results;
   }
 
 char ** Transaction::selectNonClearedTransactions ( QDate fromdate, bool children, const char *limit, int id )
   {
     char **results;
     if ( account->getParentAccountID ( id ) == -1 && children == TRUE )
      sqlite_get_table_printf ( tdb, "select day, month, year, payee, amount, transid, accountid from transactions where cleared = 0 and parentid = %i and payee like '%q';", &results, &rows, &columns, NULL, id, limit );
     else
       sqlite_get_table_printf ( tdb, "select day, month, year, payee, amount, transid, accountid from transactions where cleared = 0 and accountid = %i and payee like '%q';", &results, &rows, &columns, NULL, id, limit );
     return results;
   }
 
 void Transaction::displayTransactions ( QListView *listview, int id, bool children, const char *limit, QDate displaydate )
   {
     int showcleared = preferences->getPreference ( 3 );
 
     char **results;
     if ( showcleared == 0 )
       results = selectNonClearedTransactions ( displaydate, children, limit, id );
     else
       results = selectAllTransactions ( displaydate, children, limit, id );
 
     // iterate through the result list and display each item
     int counter = 7;
     while ( counter < ( ( rows + 1 ) * columns ) )
       {
         //QDate testdate ( atoi ( results [ counter + 2 ] ), atoi ( results [ counter + 1 ] ), atoi ( results [ counter ] ) );
         QString date = preferences->getDate ( atoi ( results [ counter + 2 ] ), atoi ( results [ counter + 1 ] ), atoi ( results [ counter ] ) );
 
 	// construct transaction name, amount, id
 	QString payee = results [ counter + 3 ];
 	QString amount = results [ counter + 4 ];
 	QString transferid = results [ counter + 5 ];
 
         //determine the account name of the child accounts that we're displaying
         QString accountname = account->getAccountName ( atoi ( results [ counter + 6 ] ) );
 
         // fill in values
         if ( account->getParentAccountID ( id ) != -1 ) // use these constructors if we're showing a child account
           {
 	    if ( showcleared == 1 && getCleared ( transferid.toInt() ) == 1 )
 	     ColorListItem *item = new ColorListItem ( listview, date, payee, amount, transferid );
 	    else
 	      QListViewItem *item = new QListViewItem ( listview, date, payee, amount, transferid );
           }
         else
           {
 	    if ( showcleared == 1 && getCleared ( transferid.toInt() ) == 1 )
 	      ColorListItem *item = new ColorListItem ( listview, date, payee, amount, transferid, accountname );
 	    else
 	      QListViewItem *item = new QListViewItem ( listview, date, payee, amount, transferid, accountname );
           }
 
 	// advance counter
 	counter = counter + 7;
       }
   }
 
 QString Transaction::getBudgetTotal ( int budgetid, int lineitemid, int year, int month, int viewtype )
   {
     // determine if we are viewing a years, months, or days budget
     // we have to pick a different sum for each
     char **results;
     switch ( viewtype )
       {
         case 1: // we are viewing a year
         sqlite_get_table_printf ( tdb, "select abs ( sum ( amount ) ) from transactions where year = %i and amount < 0 and budgetid = %i and reservedone = %i;", &results, NULL, NULL, NULL, year, budgetid, lineitemid );
         break;
 
         case 0: // we are viewing a month
         sqlite_get_table_printf ( tdb, "select abs ( sum ( amount ) ) from transactions where year = %i and month = %i and amount < 0 and budgetid = %i and reservedone = %i;", &results, NULL, NULL, NULL, year, month, budgetid, lineitemid );
         break;
       }
     QString amount = results [ 1 ];
     float total  = amount.toFloat();
     amount.setNum ( total, 'f', 2 );
     return amount;
   }
 
 QString Transaction::getActualTotal ( int budgetid, int year, int month, int viewtype )
   {
     // determine if we are viewing a years, months, or days budget
     // we have to pick a different sum for each
     char **results;
     switch ( viewtype )
       {
         case 1: // we are viewing a year
         sqlite_get_table_printf ( tdb, "select abs ( sum ( amount ) ) from transactions where year = %i and amount < 0 and budgetid = %i;", &results, NULL, NULL, NULL, year, budgetid );
         break;
 
         case 0: // we are viewing a month
         sqlite_get_table_printf ( tdb, "select abs ( sum ( amount ) ) from transactions where year = %i and month = %i and amount < 0 and budgetid = %i;", &results, NULL, NULL, NULL, year, month, budgetid );
         break;
       }
     QString amount = results [ 1 ];
     float total  = amount.toFloat();
     amount.setNum ( total, 'f', 2 );
     return amount;
   }
 
 void Transaction::clearBudgetIDs ( int budgetid, int lineitemid )
   {
     sqlite_exec_printf ( tdb, "update transactions set budgetid = -1 where budgetid = %i and reservedone = %i;", 0, 0, 0, budgetid, lineitemid );
   }
 
 void Transaction::clearBudgetIDs ( int budgetid )
   {
     sqlite_exec_printf ( tdb, "update transactions set budgetid = -1 where budgetid = %i;", 0, 0, 0, budgetid );
   }
 
diff --git a/noncore/apps/qashmoney/transfer.cpp b/noncore/apps/qashmoney/transfer.cpp
index 568d584..c4bbaf9 100755
--- a/noncore/apps/qashmoney/transfer.cpp
+++ b/noncore/apps/qashmoney/transfer.cpp
@@ -1,260 +1,260 @@
 #include "transfer.h"
 #include "account.h"
 #include "transactiondisplay.h"
 #include <stdlib.h>
 #include <iostream.h>
 
 extern Account *account;
 extern Preferences *preferences;
 
 Transfer::Transfer ()
   {
     db = sqlite_open ( "qmtransfers.db", 0, 0 );
   }
 
 Transfer::~Transfer ()
   {
     sqlite_close ( db );
   }
 
 void Transfer::addTransfer ( int fromaccount, int fromparent, int toaccount, int toparent, int day, int month, int year, float amount, int cleared )
   {
     int nextrowid = -1;
     char **results;
     sqlite_get_table ( db, "select count() from transfers;", &results, 0, 0, 0 );
     if ( atoi ( results [ 1 ] ) != 0 )
       {
         char **results;
         sqlite_get_table ( db, "select min ( rowid ) from transfers;", &results, 0, 0, 0 );
         nextrowid = ( atoi ( results [ 1 ] ) ) - 1;
       }
     sqlite_exec_printf ( db, "insert into transfers values ( %i, %i, %i, %i, %i, %i, %i, 0, 0, %.2f, %i, 0, 0, 0, 0, 0, %i );", 0, 0, 0, fromaccount, fromparent, toaccount, toparent, day, month, year, amount, cleared, nextrowid );
   }
 
 void Transfer::updateTransfer ( int fromaccount, int fromparent, int toaccount, int toparent, int day, int month, int year, float amount, int cleared, int transferid )
   {
-    sqlite_exec_printf ( db, "update transfers set fromaccount = %i, fromparent = %i, toaccount = %i, toparent = %i, day = %i, month = %i, year = %i,
-      amount = %.2f, cleared = %i where transferid = %i;", 0, 0, 0, fromaccount, fromparent, toaccount, toparent, day, month, year, amount, cleared, transferid );
+    sqlite_exec_printf ( db, "update transfers set fromaccount = %i, fromparent = %i, toaccount = %i, toparent = %i, day = %i, month = %i, year = %i,"
+     "amount = %.2f, cleared = %i where transferid = %i;", 0, 0, 0, fromaccount, fromparent, toaccount, toparent, day, month, year, amount, cleared, transferid );
   }
 
 void Transfer::deleteTransfer ( int transferid )
   {
     sqlite_exec_printf ( db, "delete from transfers where transferid = %i;", 0, 0, 0, transferid );
   }
 
 void Transfer::deleteAllTransfers ( int accountid )
   {
     sqlite_exec_printf ( db, "delete from transfers where fromaccount = %i;", 0, 0, 0, accountid );
     sqlite_exec_printf ( db, "delete from transfers where toaccount = %i;", 0, 0, 0, accountid );
   }
 
 int Transfer::getNumberOfTransfers ()
   {
     char **results;
     sqlite_get_table ( db, "select count() from transfers;", &results, 0, 0, 0 );
     return atoi ( results [ 1 ] );
   }
 
 int Transfer::getNumberOfTransfers ( int accountid )
   {
     char **results;
     sqlite_get_table_printf ( db, "select count() from transfers where fromaccount = %i;", &results, 0, 0, 0, accountid );
     int transfers = atoi ( results [ 1 ] );
     sqlite_get_table_printf ( db, "select count() from transfers where toaccount = %i;", &results, 0, 0, 0, accountid );
     transfers = transfers + atoi ( results [ 1 ] );
     return transfers;
   }
 
 void Transfer::displayTransfers ( QListView *listview, int accountid, bool children, QDate displaydate )
   {
     int showcleared = preferences->getPreference ( 3 );
 
     // select the from transfers to display
     char **results;
     int rows, columns;
     if ( account->getParentAccountID ( accountid ) == -1 && children == TRUE )
       {
         if ( showcleared == 0 )
           sqlite_get_table_printf ( db, "select day, month, year, amount, transferid, fromaccount, toaccount from transfers where cleared = 0 and toparent = %i;", &results, &rows, &columns, 0, accountid );
         else
           sqlite_get_table_printf ( db, "select day, month, year, amount, transferid, fromaccount, toaccount from transfers where toparent = %i;", &results, &rows, &columns, 0, accountid );
       }
     else
       {
         if ( showcleared == 0 )
           sqlite_get_table_printf ( db, "select day, month, year, amount, transferid, fromaccount, toaccount from transfers where cleared = 0 and toaccount = %i;", &results, &rows, &columns, 0, accountid );
         else
           sqlite_get_table_printf ( db, "select day, month, year, amount, transferid, fromaccount, toaccount from transfers where toaccount = %i;", &results, &rows, &columns, 0, accountid );
       }
 
     // iterate through the list and display the from items
     int counter = 7;
     int position = 0;
     while ( counter < ( ( rows + 1 ) * columns ) )
       {
         // construct the date
 	QString daystring = results [ counter ];
 	int day = daystring.toInt ();
 	QString monthstring = results [ counter + 1 ];
 	int month = monthstring.toInt ();
 	QString yearstring = results [ counter + 2 ];
 	int year = yearstring.toInt ();
 	QString date = preferences->getDate ( year, month, day );
         QDate testdate ( year, month, day );
 
         //construct the amount and id strings
         QString amount = results [ counter + 3 ];
         QString id = results [ counter + 4 ];
 
         // construct the transaction name
         QString transactionname = "FROM: ";
         QString temp1 = results [ counter + 5 ];
         transactionname.append ( account->getAccountName ( temp1.toInt() ) );
 
         QString toaccount = account->getAccountName ( atol ( results [ counter + 6 ] ) );
 
         if ( testdate >= displaydate || showcleared == 0 )
           {
             // display this transfer
             if ( account->getParentAccountID ( accountid ) == -1 )
               {
                 if ( showcleared == 1 && getCleared ( id.toInt() ) == 1 )
                   ColorListItem *item = new ColorListItem ( listview, date, transactionname, amount, id, toaccount );
                 else
                   QListViewItem *item = new QListViewItem ( listview, date, transactionname, amount, id, toaccount );
               }
             else
               {
                 if ( showcleared == 1 && getCleared ( id.toInt() ) == 1 )
                   ColorListItem *item = new ColorListItem ( listview, date, transactionname, amount, id );
                 else
                   QListViewItem *item = new QListViewItem ( listview, date, transactionname, amount, id );
               }
           }
         counter = counter + 7;
       }
 
     // select the to transfers to display
     char **toresults;
     rows = 0;
     columns = 0;
     if ( account->getParentAccountID ( accountid ) == -1 && children == TRUE )
       {
         if ( showcleared == 0 )
           sqlite_get_table_printf ( db, "select day, month, year, amount, transferid, fromaccount, toaccount from transfers where cleared = 0 and fromparent = %i;", &toresults, &rows, &columns, 0, accountid );
         else
           sqlite_get_table_printf ( db, "select day, month, year, amount, transferid, fromaccount, toaccount from transfers where fromparent = %i;", &toresults, &rows, &columns, 0, accountid );
       }
     else
       {
         if ( showcleared == 0 )
           sqlite_get_table_printf ( db, "select day, month, year, amount, transferid, fromaccount, toaccount from transfers where cleared = 0 and fromaccount = %i;", &toresults, &rows, &columns, 0, accountid );
         else
           sqlite_get_table_printf ( db, "select day, month, year, amount, transferid, fromaccount, toaccount from transfers where fromaccount = %i;", &toresults, &rows, &columns, 0, accountid );
       }
 
     // iterate through the list and display the from items
     counter = 7;
     position = 0;
     while ( counter < ( ( rows + 1 ) * columns ) )
       {
         // construct the date
 	QString daystring = toresults [ counter ];
 	int day = daystring.toInt ();
 	QString monthstring = toresults [ counter + 1 ];
 	int month = monthstring.toInt ();
 	QString yearstring = toresults [ counter + 2 ];
 	int year = yearstring.toInt ();
 	QString date = preferences->getDate ( year, month, day );
         QDate testdate ( year, month, day );
 
         //construct the amount and id strings
         QString amount = toresults [ counter + 3 ];
         amount.prepend ( "-" );
         QString id = toresults [ counter + 4 ];
 
         // construct the transaction name
         QString transactionname = "TO: ";
         QString temp1 = toresults [ counter + 6 ];
         transactionname.append ( account->getAccountName ( temp1.toInt() ) );
 
         QString fromaccount = account->getAccountName ( atol ( toresults [ counter + 5 ] ) );
 
          if ( testdate >= displaydate || showcleared == 0 )
            {
              // display this transfer
              if ( account->getParentAccountID ( accountid ) == -1 )
               {
                 if ( showcleared == 1 && getCleared ( id.toInt() ) == 1 )
                   ColorListItem *item = new ColorListItem ( listview, date, transactionname, amount, id, fromaccount );
                 else
                   QListViewItem *item = new QListViewItem ( listview, date, transactionname, amount, id, fromaccount );
               }
             else
               {
                 if ( showcleared == 1 && getCleared ( id.toInt() ) == 1 )
                   ColorListItem *item = new ColorListItem ( listview, date, transactionname, amount, id );
                 else
                   QListViewItem *item = new QListViewItem ( listview, date, transactionname, amount, id );
               }
           }
 
         counter = counter + 7;
       }
   }
 
 int Transfer::getCleared ( int id )
   {
     char **results;
     sqlite_get_table_printf ( db, "select cleared from transfers where transferid= %i;", &results, 0, 0, 0, id );
     return atoi ( results [ 1 ] );
   }
 
 void Transfer::setCleared ( int id, int cleared )
   {
     sqlite_exec_printf ( db, "update transfers set cleared = %i where transferid = %i;", 0, 0, 0, cleared, id );
   }
 
 int Transfer::getFromAccountID ( int id )
   {
     char **results;
     sqlite_get_table_printf ( db, "select fromaccount from transfers where transferid= %i;", &results, 0, 0, 0, id );
     return atoi ( results [ 1 ] );
   }
 
 int Transfer::getToAccountID ( int id )
   {
     char **results;
     sqlite_get_table_printf ( db, "select toaccount from transfers where transferid= %i;", &results, 0, 0, 0, id );
     return atoi ( results [ 1 ] );
   }
 
 int Transfer::getDay ( int id )
   {
     char **results;
     sqlite_get_table_printf ( db, "select day from transfers where transferid= %i;", &results, 0, 0, 0, id );
     return atoi ( results [ 1 ] );
   }
 
 int Transfer::getMonth ( int id )
   {
     char **results;
     sqlite_get_table_printf ( db, "select month from transfers where transferid= %i;", &results, 0, 0, 0, id );
     return atoi ( results [ 1 ] );
   }
 
 int Transfer::getYear ( int id )
   {
     char **results;
     sqlite_get_table_printf ( db, "select year from transfers where transferid= %i;", &results, 0, 0, 0, id );
     return atoi ( results [ 1 ] );
   }
 
 QString Transfer::getAmount ( int id )
   {
     char **results;
     sqlite_get_table_printf ( db, "select amount from transfers where transferid= %i;", &results, 0, 0, 0, id );
     return results [ 1 ];
   }
 
 
diff --git a/packages b/packages
index c48eee8..0e6340f 100644
--- a/packages
+++ b/packages
@@ -1,191 +1,192 @@
 CONFIG_ADDRESSBOOK	core/pim/addressbook	addressbook.pro
 CONFIG_ADVANCEDFM	noncore/apps/advancedfm	advancedfm.pro
 CONFIG_APPEARANCE2	noncore/settings/appearance2	appearance2.pro
 CONFIG_APPSKEY	noncore/settings/appskey	appskey.pro
 CONFIG_AQPKG	noncore/apps/aqpkg	aqpkg.pro
 CONFIG_BACKGAMMON	noncore/games/backgammon backgammon.pro
 CONFIG_BACKUP	noncore/settings/backup	backup.pro
 CONFIG_BATTERYAPPLET	core/applets/batteryapplet	batteryapplet.pro
 CONFIG_BEND	noncore/mail/bend	bend.pro
 CONFIG_BINARY	noncore/tools/calc2/binary	binary.pro
 CONFIG_BLUE-PIN	noncore/net/opietooth/blue-pin	blue-pin.pro
 CONFIG_BOUNCE	noncore/games/bounce	bounce.pro
 CONFIG_BUTTON-SETTINGS	core/settings/button	button.pro
 CONFIG_BUZZWORD	noncore/games/buzzword	buzzword.pro
 CONFIG_CALC2	noncore/tools/calc2	calc.pro
 CONFIG_CALCULATOR	noncore/tools/calculator	calculator.pro
 CONFIG_CALIBRATE	core/apps/calibrate	calibrate.pro
 CONFIG_CAMERA	noncore/multimedia/camera	camera.pro
 CONFIG_CARDMON	core/applets/cardmon	cardmon.pro
 CONFIG_CHECKBOOK	noncore/apps/checkbook	checkbook.pro
 CONFIG_CITYTIME	core/settings/citytime	citytime.pro
 CONFIG_CLIPBOARDAPPLET	core/applets/clipboardapplet	clipboardapplet.pro
 CONFIG_CLOCK	noncore/tools/clock	clock.pro
 CONFIG_CLOCKAPPLET	core/applets/clockapplet	clockapplet.pro
 CONFIG_CONFEDIT	noncore/apps/confedit	confedit.pro
 CONFIG_DASHER	inputmethods/dasher	dasher.pro
 CONFIG_DATEBOOK	core/pim/datebook	datebook.pro
 CONFIG_DECO_FLAT	noncore/decorations/flat	flat.pro
 CONFIG_DECO_LIQUID	noncore/decorations/liquid	liquid.pro
 CONFIG_DECO_POLISHED	noncore/decorations/polished	polished.pro
 CONFIG_DICTIONARY	noncore/apps/dictionary	dictionary.pro
 CONFIG_DRAWPAD	noncore/graphics/drawpad	drawpad.pro
 CONFIG_DVORAK	inputmethods/dvorak	dvorak.pro
 CONFIG_EMBEDDEDKONSOLE	core/apps/embeddedkonsole	embeddedkonsole.pro
 CONFIG_EUROCONV		noncore/tools/euroconv/ euroconv.pro
 CONFIG_FIFTEEN	noncore/games/fifteen	fifteen.pro
 CONFIG_FILEBROWSER	core/apps/filebrowser	filebrowser.pro
 CONFIG_FLAT	noncore/styles/flat	flat.pro
 CONFIG_FORMATTER	noncore/tools/formatter	formatter.pro
 CONFIG_FREETYPE	freetype	freetype.pro
 CONFIG_FRESH	noncore/styles/fresh	fresh.pro
 CONFIG_FTPLIB	noncore/net/ftplib	ftplib.pro
 CONFIG_GO	noncore/games/go	go.pro
 CONFIG_GSMTOOL	noncore/comm/gsmtool	gsmtool.pro
 CONFIG_HANDWRITING	inputmethods/handwriting	handwriting.pro
 CONFIG_HELPBROWSER	core/apps/helpbrowser	helpbrowser.pro
 CONFIG_HOMEAPPLET	core/applets/homeapplet	homeapplet.pro
 CONFIG_INTERFACES	noncore/settings/networksettings/interfaces	interfaces.pro
 CONFIG_IRDAAPPLET	core/applets/irdaapplet	irdaapplet.pro
 CONFIG_JUMPX	inputmethods/jumpx	jumpx.pro
 CONFIG_KBILL	noncore/games/kbill	kbill.pro
 CONFIG_KCHECKERS	noncore/games/kcheckers	kcheckers.pro
 CONFIG_KEYBOARD	inputmethods/keyboard	keyboard.pro
 CONFIG_KEYPEBBLE	noncore/comm/keypebble	keypebble.pro
 CONFIG_KEYVIEW	development/keyview	keyview.pro
 CONFIG_KJUMPX	inputmethods/kjumpx	kjumpx.pro
 CONFIG_KPACMAN	noncore/games/kpacman	kpacman.pro
 CONFIG_LANGUAGE	noncore/settings/language	language.pro
 CONFIG_LAUNCHER-SETTINGS	core/settings/launcher	launcher.pro
 CONFIG_LAUNCHER_CORE	core/launcher	server.pro
 CONFIG_LIBFFMPEG	core/multimedia/opieplayer/libffmpeg	libffmpeg.pro
 CONFIG_LIBFLASH	core/multimedia/opieplayer/libflash	libflash.pro
 CONFIG_LIBKATE  noncore/apps/tinykate/libkate libkate.pro
 CONFIG_LIBMAD	core/multimedia/opieplayer/libmad	libmad.pro
 CONFIG_LIBMAIL	noncore/mail/libmail	libmail.pro
 CONFIG_LIBMPEG3	core/multimedia/opieplayer/libmpeg3	libmpeg3.pro
 CONFIG_LIBOPIE	libopie	libopie.pro
 CONFIG_LIBOPIE2CORE	libopie2/opiecore	opiecore.pro
 CONFIG_LIBOPIE2DB	libopie2/opiedb	opiedb.pro
 CONFIG_LIBOPIE2EXAMPLES	libopie2/examples	examples.pro
 CONFIG_LIBOPIE2NET	libopie2/opienet	opienet.pro
 CONFIG_LIBOPIE2PIM	libopie2/opiepim	opiepim.pro
 CONFIG_LIBOPIE2UI	libopie2/opieui	opieui.pro
 CONFIG_LIBOPIE2MM	libopie2/opiemm	opiemm.pro
 CONFIG_LIBOPIETOOTH	noncore/net/opietooth/lib	lib.pro
 CONFIG_LIBOPIE_PIM	libopie/pim	pim.pro
 CONFIG_LIBQPE	library	library.pro
 CONFIG_LIBQPE-X11	x11/libqpe-x11	libqpe-x11.pro
 CONFIG_LIBSQL	libsql	libsql.pro
 CONFIG_LIBTREMOR core/multimedia/opieplayer/vorbis/tremor tremor.pro
 CONFIG_LIBTREMORPLUGIN core/multimedia/opieplayer/vorbis libtremor.pro
 CONFIG_LIGHT-AND-POWER	core/settings/light-and-power	light-and-power.pro
 CONFIG_LIQUID	noncore/styles/liquid	liquid.pro
 CONFIG_LOGOUTAPPLET	core/applets/logoutapplet	logoutapplet.pro
 CONFIG_MAILIT		noncore/net/mailit		mailit.pro
 CONFIG_MEDIUMMOUNT	noncore/settings/mediummount	mediummount.pro
 CONFIG_MEMORYAPPLET	noncore/applets/memoryapplet	memoryapplet.pro
 CONFIG_METAL	noncore/styles/metal	metal.pro
 CONFIG_MINDBREAKER	noncore/games/mindbreaker	mindbreaker.pro
 CONFIG_MINESWEEP	noncore/games/minesweep	minesweep.pro
 CONFIG_MOBILEMSG	noncore/comm/mobilemsg	mobilemsg.pro
 CONFIG_MODPLUG	core/multimedia/opieplayer/modplug	modplug.pro
 CONFIG_MULTIKEY	inputmethods/multikey	multikey.pro
 CONFIG_NETSYSTEMTIME	noncore/settings/netsystemtime	netsystemtime.pro
 CONFIG_NETWORKAPPLET	noncore/applets/networkapplet	networkapplet.pro
 CONFIG_NETWORKSETUP	noncore/settings/networksettings	networksettings.pro
 CONFIG_NOTESAPPLET	noncore/applets/notesapplet	notesapplet.pro
 CONFIG_OAPP	core/apps/oapp	oapp.pro
 CONFIG_OBEX	core/applets/obex2	obex.pro
 CONFIG_ODICT	noncore/apps/odict	odict.pro
 CONFIG_OIPKG	core/apps/oipkg	oipkg.pro
 CONFIG_OPIE-CONSOLE	noncore/apps/opie-console	opie-console.pro
 CONFIG_OPIE-LOGIN	core/opie-login	opie-login.pro
 CONFIG_OPIE-READER	noncore/apps/opie-reader	opie-reader.pro
 CONFIG_OPIE-SH	noncore/tools/opie-sh	opie-sh.pro
 CONFIG_OPIE-SHEET	noncore/apps/opie-sheet	opie-sheet.pro
 CONFIG_OPIE-WRITE	noncore/apps/opie-write	opie-write.pro
 CONFIG_OPIEALARM	core/opiealarm
 CONFIG_OPIEFTP	noncore/net/opieftp	opieftp.pro
 CONFIG_OPIEIRC	noncore/net/opieirc	opieirc.pro
 CONFIG_OPIEMAIL2	noncore/mail mail.pro
 CONFIG_OPIEPLAYER	core/multimedia/opieplayer	opieplayer.pro
 CONFIG_OPIEPLAYER2	noncore/multimedia/opieplayer2	opieplayer2.pro
 CONFIG_OPIE-RDESKTOP	noncore/net/opierdesktop	opierdesktop.pro
 CONFIG_OPIEREC		noncore/multimedia/opierec	opierec.pro
 CONFIG_OPIETOOTH-APPLET	noncore/net/opietooth/applet	applet.pro
 CONFIG_OPIETOOTH-MANAGER	noncore/net/opietooth/manager	manager.pro
 CONFIG_OSEARCH	core/pim/osearch	osearch.pro
 CONFIG_OXYGEN	noncore/apps/oxygen	oxygen.pro
 CONFIG_PARASHOOT	noncore/games/parashoot	parashoot.pro
 CONFIG_PICKBOARD	inputmethods/pickboard	pickboard.pro
 CONFIG_QASTEROIDS	noncore/games/qasteroids	qasteroids.pro
+CONFIG_QASHMONEY	noncore/apps/qashmoney	qashmoney.pro
 CONFIG_QCOP	core/apps/qcop	qcop.pro
 CONFIG_QPDF	noncore/graphics/qpdf	qpdf.pro
 CONFIG_QPDF2	noncore/graphics/qpdf2	qpdf2.pro
 CONFIG_QUICKLAUNCHER core/tools/quicklauncher quicklauncher.pro
 CONFIG_QWS	core/qws	qws.pro
 CONFIG_REMOTE	noncore/tools/remote	remote.pro
 CONFIG_RESTARTAPPLET	core/applets/restartapplet	restartapplet.pro
 CONFIG_RESTARTAPPLET2	core/applets/restartapplet2	restartapplet2.pro
 CONFIG_ROTATEAPPLET	core/applets/rotateapplet	rotateapplet.pro
 CONFIG_ROTATION	noncore/settings/rotation	rotation.pro
 CONFIG_RUNAPPLET	core/applets/runapplet	runapplet.pro
 CONFIG_SCREENSHOTAPPLET	core/applets/screenshotapplet	screenshotapplet.pro
 CONFIG_SECURITY	core/settings/security	security.pro
 CONFIG_SFCAVE	noncore/games/sfcave	sfcave.pro
 CONFIG_SFCAVE-SDL	noncore/games/sfcave-sdl	sfcave-sdl.pro
 CONFIG_SHOWIMG	noncore/multimedia/showimg	showimg.pro
 CONFIG_SIMPLE	noncore/tools/calc2/simple	simple.pro
 CONFIG_SINGLE	single	single.pro
 CONFIG_SNAKE	noncore/games/snake	snake.pro
 CONFIG_SOLITAIRE	noncore/games/solitaire	solitaire.pro
 CONFIG_SOUND	noncore/settings/sound	sound.pro
 CONFIG_SSHKEYS	noncore/settings/sshkeys	sshkeys.pro
 CONFIG_SUSPENDAPPLET	core/applets/suspendapplet	suspendapplet.pro
 CONFIG_SYSINFO	noncore/apps/sysinfo	sysinfo.pro
 CONFIG_TABLEVIEWER	noncore/apps/tableviewer	tableviewer.pro
 CONFIG_TABMANAGER	noncore/settings/tabmanager	tabmanager.pro
 CONFIG_TABOAPP	core/apps/taboapp	taboapp.pro
 CONFIG_TEST	libsql/test	test.pro
 CONFIG_TEST	noncore/apps/opie-console/test	test.pro
 CONFIG_TETRIX	noncore/games/tetrix	tetrix.pro
 CONFIG_TEXTEDIT	core/apps/textedit	textedit.pro
 CONFIG_THEME	noncore/styles/theme	theme.pro
 CONFIG_TICTAC	noncore/games/tictac	tictac.pro
 CONFIG_TINYKATE noncore/apps/tinykate	tinykate.pro
 CONFIG_TODAY	core/pim/today	today.pro
 CONFIG_TODAY_ADDRESSBOOK core/pim/today/plugins/addressbook addressbook.pro
 CONFIG_TODAY_DATEBOOK	core/pim/today/plugins/datebook	datebook.pro
 CONFIG_TODAY_FORTUNE	noncore/todayplugins/fortune	fortune.pro
 CONFIG_TODAY_MAIL	core/pim/today/plugins/mail	mail.pro
 CONFIG_TODAY_STOCKTICKER	noncore/todayplugins/stockticker/stockticker	stockticker.pro
 CONFIG_TODAY_STOCKTICKERLIB	noncore/todayplugins/stockticker/stocktickerlib	stocktickerlib.pro
 CONFIG_TODAY_TODOLIST	core/pim/today/plugins/todolist	todolist.pro
 CONFIG_TODAY_WEATHER	noncore/todayplugins/weather weather.pro
 CONFIG_TODO	core/pim/todo	todo.pro
 CONFIG_UBROWSER	noncore/net/ubrowser	ubrowser.pro
 CONFIG_UNIKEYBOARD	inputmethods/unikeyboard	unikeyboard.pro
 CONFIG_USERMANAGER	noncore/settings/usermanager	usermanager.pro
 CONFIG_VMEMO	core/applets/vmemo	vmemo.pro
 CONFIG_VOLUMEAPPLET	core/applets/volumeapplet	volumeapplet.pro
 CONFIG_VTAPPLET	core/applets/vtapplet	vtapplet.pro
 CONFIG_WAVPLUGIN	core/multimedia/opieplayer/wavplugin	wavplugin.pro
 CONFIG_WELLENREITER	noncore/net/wellenreiter	wellenreiter.pro
 CONFIG_WIRELESSAPPLET	noncore/applets/wirelessapplet	wirelessapplet.pro
 CONFIG_WLAN	noncore/settings/networksettings/wlan	wlan.pro
 CONFIG_PPP	noncore/settings/networksettings/ppp	ppp.pro
 CONFIG_WORDGAME	noncore/games/wordgame	wordgame.pro
 CONFIG_ZSAFE	noncore/apps/zsafe zsafe.pro
 CONFIG_MAIN_TAB_EXAMPLE	examples/main-tab	example.pro
 CONFIG_SIMPLE_EXAMPLE	examples/simple	example.pro
 CONFIG_SIMPLE_ICON	examples/simple-icon	example.pro
 CONFIG_SIMPLE_MAIN	examples/simple-main	example.pro
 <<<<<<< packages
 CONFIG_SIMPLE_PIM	examples/simple-pim	example.pro
 CONFIG_BIGSCREEN_EXAMPLE       libopie/big-screen/example      osplitter_mail.pro
 
 =======
 CONFIG_SIMPLE_PIM	examples/simple-pim	example.pro
 CONFIG_APPLET_EXAMPLE	examples/applet	example.pro
 >>>>>>> 1.56