[Serusers] seweb-2004

[gaillac harry]

I've got this version for ser-8.0.12 but i have a problem with
missed_calls.php. I'm about to update mysql 

Thanks 
Harry

Le mar 27/04/2004 à 15:15, Atle Samuelsen a écrit :
> I know this version works, with ser 0.8.12.
> ftp://ftp.berlios.de/pub/ser/latest/contrib/serweb_2004-01-04.tar.gz
> 
> 
> - Atle
> 
> * Klaus Darilion <klaus.mailinglists at pernau.at> [040427 14:39]:
> > I think the problem is, that there is no stable serweb.
> > 
> > klaus
> > 
> > gaillac harry wrote:
> > >Ok thanks !
> > >
> > >I'm not a php/mysql developper I can't rewrite serweb, I try my best to
> > >correct configs files (config.php). it would be a good thing stables
> > >ser+serweb releases match.
> > >
> > >Harry
> > > 
> > >Le mar 27/04/2004 ?  12:44, Klaus Darilion a ??crit :
> > >
> > >>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
> > 
> 
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers