[piranha]

Sure.. Just change the trigger to:

CREATE TRIGGER [deleteKeep]
BEFORE DELETE ON [call]
FOR EACH ROW WHEN (select count(*) from call)<1000
BEGIN
insert into call
select null,address,date,duration,flags,id from call
where call.ROWID=OLD.ROWID ;
END

Attached updated file.

[Reako]

I barely use the caller, and I have no idea how to help change the Triggers for the SMS. I hope you figure it out.

Reako

[sserg007]

Piranha, thanks a lot!!!

[vikasmal]

Thanks a lot, will try this out.

Cheers, Vikas.

Originally Posted by piranha

For those who want to test unlimited size of last call list, use attached file.
After unzipping replace /var/root/Library/CallHistory/call_history.db with the new one.
I recommend to keep a copy of the old one just to be safe.
Please note it will erase all your current history.
Reboot your iPhone to start the trigger.

Please note that it may slow down the "last calls" screen, depending on how big your list will be.

So far mine works fine, with 3000 records.
Remember that I take no responsibility if it blows up your phone

[Kyle Matthews]

Good work, pirahna. Very useful tweak!

[recoil]

I'm sure this works, but it would be great if you could clear it once in a while, which does not work. the calld application also doesn't work, I'm sure you guys noticed this.. so I guess the next question is if there is a way to increase the call history count without (partially) loosing list functionality. thanks!

[piranha]

I am in the talks with BigBoss and his speed dial program, which may use this for intelligent creation of speed dial list based on how often we call people.

I think we'll just create separate table where we'll archive older data (as I did with SMS).
The speed dial program will be able to switch this on or off.
(by the way I have over 4000 entries in my callhistory table, and I see no slowdown).

[recoil]

yeah, that would be great. any idea when this application is due? thanks

[Kyle Matthews]

Could you also upload a file with the default settings?

[wjding]

Good idea!

Steven

[aceaspades909]

Originally Posted by recoil

I'm sure this works, but it would be great if you could clear it once in a while, which does not work. the calld application also doesn't work, I'm sure you guys noticed this.. so I guess the next question is if there is a way to increase the call history count without (partially) loosing list functionality. thanks!

I want to swap out the files because id really like a 500+ history but you cant erase it? What functions does it get rid of exactly?

[recoil]

as you have read, the trigger tampers with the deleting of lines from the .db file. that means that not only the deletion of lines from the end of the file (>100) doesn't work, deletion does not work at all. so if u swap the files, you can't clear the list and you can't use calld to erase lines one by one, the application crashes. I am personally waiting for a way to archive the list into a separate table. hope it's clear now, bye

[TikoRacer]

WOW!!!! This is AWESOME!!!!!! Great work man!!!

Just one question, can you modify and limit it up to 5000, pls???



Thanks in advance!


Ka

[vikasmal]

Hi.

can anyone please post the original callhistory.db file as I have misplaced mine and want to revert to the old one? Thank You.

[fadybran]

Originally Posted by piranha

For those who want to test unlimited size of last call list, use attached file.
After unzipping replace /var/root/Library/CallHistory/call_history.db with the new one.

I recommend to keep a copy of the old one just to be safe.
Please note it will erase all your current history.
Reboot your iPhone to start the trigger.

Please note that it may slow down the "last calls" screen, depending on how big your list will be.

So far mine works fine, with 3000 records.
Remember that I take no responsibility if it blows up your phone

Thanks Piranha, i applied this "BTW in 1.1.4 the locaqtion is: /private/var/mobile/Library/CallHistory"

I guess i need 2-3 busy days to confirm that it's working for me

do you think you can make it a bit limited? like 500 calls instead of limited

thanks again for the effort