[Serusers] seweb-2004
gaillac harry
gaillacharry at yahoo.fr
Tue Apr 27 13:50:40 CEST 2004
Thanks Atle
I use google everyday as many people.if you find my problem on google
please send it me back .
Regards
Le mar 27/04/2004 à 13:39, Atle Samuelsen a écrit :
> 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
> >
>
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
More information about the sr-users
mailing list