[Serusers] seweb-2004
Atle Samuelsen
clona at camaro.no
Tue Apr 27 15:15:30 CEST 2004
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
>
More information about the sr-users
mailing list