[Serusers] seweb-2004
gaillac harry
gaillacharry at yahoo.fr
Tue Apr 27 13:44:59 CEST 2004
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
More information about the sr-users
mailing list