Unfortunatelly, your patch does not work fine. It cannot find a default tariff (not assigned to any group/account) - did you really check it?
----- Original Message ----- From: "Kompnet" <kompnet@xxxxxxxxx>
Sent: Friday, October 22, 2004 9:03 AM
Michal, hi.
The new patch works fine with default and other groups.
In attachment you can find EXPLAIN ANALYZE output.
I hope you'll apply it to the CVS. I thought it was in CVS at least 1.5 month
ago.
Igor.
On Tuesday 31 August 2004 17:21, you wrote:And assign it to each new account... Not the best idea too. But your patch is very useful, so I will modify it a bit to work well with default tariffs too and apply it to the cvs.
Did you check the query with EXPLAIN? Is it using indices in a correct way, so it is fast?
----- Original Message ----- From: "Kompnet" <kompnet@xxxxxxxxx> Sent: Tuesday, August 31, 2004 3:11 PM
> I've not checked it, but it (default tariff with no group/selector) is
> not necessary in my way: you can set 'default' group 1.
>
> On Tuesday 31 August 2004 16:52, you wrote:
> > I've got the idea - it's good. But isn't your patch breaking
> > tariff matching for default tariffs (with no group/selector)?
> >
> > ----- Original Message -----
> > From: "Kompnet" <kompnet@xxxxxxxxx>
> > To: <openh323gk-users@xxxxxxxxxxxxxxxxxxxxx>; "Zygmuntowicz Michal"
> > <m.zygmuntowicz@xxxxxxx> Sent: Tuesday, August 31, 2004 1:51 PM
> > Subject: Changes in match_tariff function > > (sqlbill)
> >
> > > Hi, Michal.
> > > I've changed you match_tariff function a little.
> > > If it's needed to apply this schema:
> > > the 1-st user must can place calls whit prefix 1234# with common
> > > price, for the 2-nd user tariffs must be different for different
> > > destinations, but he use 1234# prefix too,
> > > and we use your variance of match_tariff, we need to write all
> > > destinations for both users:
> > > user1 1234#1 price1
> > > user2 1234#1 price2
> > > user1 1234#2 price1
> > > user2 1234#2 price3
> > > user1 1234#3 price1
> > > user2 1234#3 price4
> > > ...
> > > In my variance we can to write destinations separately for each > > > user:
> > > user1 1234# price1
> > > user2 1234#1 price2
> > > user2 1234#2 price3
> > > user2 1234#2 price4
> > > .....
> > > --
> > > Best regards,
> > > Igor Prokhorov
>
> --
> Best regards,
> Igor Prokhorov
-- Best regards, Igor Prokhorov
-------------------------------------------------------
This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
Use IT products in your business? Tell us what you think of them. Give us
Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more
http://productguide.itmanagersjournal.com/guidepromo.tmpl
_______________________________________________________
List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx
Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549
Homepage: http://www.gnugk.org/
------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more http://productguide.itmanagersjournal.com/guidepromo.tmpl
_______________________________________________________
List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549 Homepage: http://www.gnugk.org/
