Re: [Serusers] seweb-2004

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 > > >