[Serusers] seweb-2004
Klaus Darilion
klaus.mailinglists at pernau.at
Tue Apr 27 14:38:29 CEST 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
>
>
>
More information about the sr-users
mailing list