[Serusers] accounting

Hello, If somebody is interested to send voicemessages to both user account and their aliases: sip:alice@mydomain or sip:123456789@mydomain or sip:s.alice@mydomain for example. I add in AnswerMachine.cpp file (voicemail module): ////////////////////////////////////////////////////// if(AmConfig::SendMethod == "fifo"){ DBG("`P-Email-Address' has not been found: trying fifo db\n"); SerDBQuery email_query("aliases"); email_query.addKey("email_address"); email_query.addWhereClause("username = \"" + cmd.user + "\""); int query_res = email_query.execute(); if(query_res < 0) ERROR("voicemail: error while fetching user's email address"); else if(query_res > 0) { cmd.email = email_query.getVal(0,0); DBG("email address for user '%s': <%s>\n", cmd.user.c_str(),cmd.email.c_str()); } } /////////////////////////////////////////////////////// i added column email-address in aliases table: /////////////////////////////////////////////////////// mysql> select * from aliases; +----------+------------+----------------------+-----------------------+----------+---------------------+------+---------------------------------------------------------------------+------+----------------+-----------+-------+-------+-------------------------+ | username | domain | contact | email_address | received | expires | q | callid | cseq | last_modified | replicate | state | flags | user_agent | +----------+------------+----------------------+-----------------------+----------+---------------------+------+---------------------------------------------------------------------+------+----------------+-----------+-------+-------+-------------------------+ | 85 | nxs.yi.org | sip:bob@nxs.yi.org | gaillacharry(a)yahoo.fr | NULL | 2005-07-24 18:08:41 | 1.00 | The-Answer-To-The-Ultimate-Question-Of-Life-Universe-And-Everything | 42 | 20050725153201 | 0 | 0 | 128 | SIP Express Router FIFO | | 84 | nxs.yi.org | sip:alice@nxs.yi.org | gaillacharry(a)yahoo.fr | NULL | 2005-07-24 18:09:19 | 1.00 | The-Answer-To-The-Ultimate-Question-Of-Life-Universe-And-Everything | 42 | 20050725153232 | 0 | 0 | 128 | SIP Express Router FIFO | +----------+------------+----------------------+-----------------------+----------+---------------------+------+---------------------------------------------------------------------+------+----------------+-----------+-------+-------+-------------------------+ 2 rows in set (0.00 sec) /////////////////////////////////////////////////////// ___________________________________________________________________________ Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger Téléchargez cette version sur http://fr.messenger.yahoo.com