0 like 0 dislike
407 views
in Education & Reference by (620 points) | 407 views
0 0
Привет друзья! Есть такой замечательный сайт для заказа бурения скважин на воду. Бурение скважин в Минске компанией АКВАБУРсервис – полный комплекс качественных и разумных по цене услуг. [url=https://aquaburservice.by/]скважина на воду[/url],[url=https://aquaburservice.by/]бурение скважин[/url], [url=https://aquaburservice.by/]скважина минск[/url],[url=https://aquaburservice.by/]скважина на воду цена[/url],[url=https://aquaburservice.by/]бурение скважин в минской области[/url],[url=https://aquaburservice.by/]ремонт скважин[/url] и [url=https://aquaburservice.by/]бурение скважин минск[/url]. Мы бурим любые виды скважин.У нас доступная ценовая политика, рассрочка на услуги и оборудование.Заказывайте скважину для воды в АКВАБУРсервис – получите доступ к экологически чистой природной воде по самым выгодным в Минске ценам!
Увидимся!
http://www.mattglenovich.com/omlb/forum/index.php?action=profile;u=13069
https://www.loveshack.org/forums/members/479446-kapriolxql/
https://traders-union.ru/forexforum/member.php?u=303250
http://sla6.com/moon/profile.php?lookup=245792
http://poster.berdyansk.net/user/kapriolqth/

1 Answer

0 like 0 dislike

Step # 1 Introduce following columns in database table cdr:

starttime
answertime
endtime
cc_caller

unique_identifier
ALTER TABLE asterisk.cdr ADD COLUMN answertime DATETIME NOT NULL DEFAULT '' AFTER sequence;
ALTER TABLE asterisk.cdr ADD COLUMN starttime DATETIME NOT NULL DEFAULT '' AFTER answertime;
ALTER TABLE asterisk.cdr ADD COLUMN endtime DATETIME NOT NULL DEFAULT '' AFTER starttime;
ALTER TABLE asterisk.cdr ADD COLUMN cc_caller VARCHAR(80) NOT NULL DEFAULT '' AFTER endtime;

Step # 2

Add following section in asterisk file i.e. cdr_adaptive_odbc.conf. It will enable the CDR() function to recognize custom fields included in asterisk MySQL CDRs ODBC.

[adaptive_connection]
connection=asterisk
table=cdr
alias start => starttime
alias answer => answertime
alias end => endtime

Step # 3

Following is the dialplan (in file i.e. extensions.conf) to handle custom Asterisk MySQL CDRs ODBC.

[default-context]
exten => _X.,n,Set(CALLERID(num)=${cc_caller})
exten => _X.,n,Set(CDR(cc_caller)=${cc_caller})

Step # 4

You need to restart asterisk to apply such changes.
by (1.4k points)

Related questions

0 like 0 dislike
2 answers
asked May 27, 2014 in Education & Reference by Yogi (180 points) | 136 views
0 like 0 dislike
1 answer
1 like 0 dislike
1 answer
1 like 0 dislike
1 answer
0 like 0 dislike
1 answer
2 like 0 dislike
1 answer
0 like 0 dislike
1 answer
0 like 0 dislike
1 answer
0 like 0 dislike
1 answer

Where your donation goes
Technology: We will utilize your donation for development, server maintenance and bandwidth management, etc for our site.

Employee and Projects: We have only 15 employees. They are involved in a wide sort of project works. Your valuable donation will definitely boost their work efficiency.

How can I earn points?
Awarded a Best Answer 10 points
Answer questions 10 points
Asking Question -20 points

1,225 questions
1,370 answers
559 comments
2,099 users