27 Apr
2004
27 Apr
'04
12:44 p.m.
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
27 Apr
27 Apr
1:39 p.m.
New subject: [Serusers] seweb-2004
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(a)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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
1:44 p.m.
New subject: [Serusers] seweb-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
1:50 p.m.
New subject: [Serusers] seweb-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(a)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:
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers 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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
2:38 p.m.
New subject: [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
3:03 p.m.
New subject: [Serusers] seweb-2004
Do you think $q would be the problem with mysql-server-3.23.56-1.9
/* we have here a UNION statement -- that speeds up queries a lot as
opposed to having an OR condition; it takes mysql 4.0.0 at least
*/
---------------------------------------------------------------------------
$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";
------------------------------------------------------------------------------
$mc_res=mySQL_query($q);
if (!$mc_res) {$errors[]="error in SQL query, line: ".__LINE__; break;}
Harry
Le mar 27/04/2004 à 14:38, Klaus Darilion a écrit :
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
>
>
>
3:15 p.m.
New subject: [Serusers] seweb-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(a)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 :
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
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
3:27 p.m.
New subject: [Serusers] seweb-2004
I've got this version for ser-8.0.12 but i have a problem with
missed_calls.php. I'm about to update mysql
Thanks
Harry
Le mar 27/04/2004 à 15:15, Atle Samuelsen a écrit :
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(a)pernau.at> [040427 14:39]:
I think the problem is, that there is no stable
serweb.
klaus
gaillac harry wrote:
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers 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 :
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
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
3:43 p.m.
New subject: [Serusers] seweb-2004
yes, you need mysql 4 for UNIONS
klaus
gaillac harry wrote:
Do you think $q would be the problem with
mysql-server-3.23.56-1.9
/* we have here a UNION statement -- that speeds up queries a lot as
opposed to having an OR condition; it takes mysql 4.0.0 at least
*/
---------------------------------------------------------------------------
$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";
------------------------------------------------------------------------------
$mc_res=mySQL_query($q);
if (!$mc_res) {$errors[]="error in SQL query, line: ".__LINE__; break;}
Harry
Le mar 27/04/2004 à 14:38, Klaus Darilion a écrit :
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
>
>
>
7325
days inactive
7325
days old
8 comments
3 participants
participants (3)
-
Atle Samuelsen -
gaillac harry -
Klaus Darilion