[Serusers] seweb-2004

[Klaus Darilion]

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