Re: [Serusers] seweb-2004

1. no direct mails -> mail to the list! 2. maybe you should make yourself familiar with php, mysql and SQL first! 3. gaillac harry wrote: >Here is my missed_calls.php > >Where is the SQL query file ??? > > $q="select username, domain from ".$config->table_aliases. > " where >'sip:".$auth->auth["uname"]."@".$config->default_domain."'=contact"; > this is an SQL query oh, here is antohter one > $q="delete from ".$config->table_missed_calls. > " where username='".$row."' and > domain='".$dom."' ". > " and time<'".gmdate("Y-m-d H:i:s", > $page_loaded_timestamp)."'"; > $res=mySQL_query($q); > if (!$res) {$errors[]="error in SQL query, line: > ".__LINE__; } and again a query! > */ > $q="(SELECT t1.from_uri, t1.sip_from, t1.time, t1.sip_status ". > "FROM missed_calls t1 ". > "WHERE t1.username='".$auth->auth["uname"]."' and >t1.domain='".$config->default_domain."' ) ". > "UNION ". > "(SELECT t1.from_uri, t1.sip_from, t1.time, t1.sip_status ". > "FROM missed_calls t1, aliases t2 ". > "WHERE > 'sip:".$auth->auth["uname"]."@".$config->default_domain."'". > "=t2.contact AND t2.username=t1.username AND > t2.domain=t1.domain ) >". > "ORDER BY time DESC"; That's probably not very useful for you (as it looks like you have no glue what you are talking about - sorry), but I will give you another hint from your previous mail: > >I've still a problem with missed_calls.php from serweb "error in SQL > > query, line: 77 No missed calls". --> check line 77 and you will find a query just before it! klaus