[Asterisk-bsd] CDR-MYSQL additional columns

[Tim St. Pierre]

I'm trying to write an additional column to the CDR database, both the mysql 
cdr, and the built-in cdr.

I would like to be able to set CDR(ratecenter) and have it show up on the text 
log, and also be inserted into the database as another column, much like 
CDR(userfield), but I'm already using that for something else.

I'm not a C programmer, but I thought I would take a stab at it.  Eventually, 
I got it to work, but it only works properly when there is a single call (the 
most recently dialed call works, the rest don't have any info).

Interestingly enough, the record is not NULL, it's blank.

Is there any way to do this in Asterisk 1.4.17 without re-inventing the wheel?

If not, is there anyone who would be able to help me out on this?

Currently, I had to modify:

main/cdr.c
funcs/func_cdr.c
cdr/cdr_csv.c
asterisk-addons/cdr/cdr_addon_mysql.c

If you are up for it, I'll send my versions of these files, and you can have a 
look.

I wish I were better at this, but C is 4th down the list of programming / 
scripting languages I have to learn in the next few months.

Thanks for any help at all

-Tim
-- 
Tim St. Pierre

IP telephony specialist
sip://5101@communicatefreely.net
Toronto: 647 722 6930
Toll-Free 1 888 488 6940
tim at communicatefreely.net