[Serusers] seweb-2004

[Atle Samuelsen]

This may be a little to bad...

but www.google.com is a HELL of a good place to find info. I think
Everyboy here started out on that spot.. Or what do you say Klaus?
+ README files are there to be read! 

- Atle

* Klaus Darilion <klaus.mailinglists at pernau.at> [040427 12:45]:
> 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
> 
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>