voipswitch modification
Project ID:
1437645Project Type:
FixedBudget:
$30-$250 USD
(Approx. $39-$334 NZD)
Project Description:
voipswitch also known as vps is a retail switch. it is a windows based applicated with mysql database. we are looking to modify the call duration of each call. anybody will skills in databases can do it.Skills required:
Database Administration, MySQL, SQL, VoIP
Last seen: May 16, 2012 3:20 AM NZST
Public Clarification Board
Awarded Bids
All Bids ()
|
|
core4voip
 From Bangladesh
 Offline
|
General Orientation (80%, 90th percentile)
Foundation EUFreelance.com Member
$200
in 1 day
$200 Milestone Requested
$200 Milestone Requested
3 months ago
hi,this task is too simple for me.you will love my work.so ..what do u think
chk my site core4voip.com
$100
in 10 days
$80 Milestone Requested
$80 Milestone Requested
3 months ago
Dear Sir/Madam,
I have enough knowledge in MS SQL Server to do this. Please send me Your data so I can start working.
Best Regards
$50
in 1 day
$25 Milestone Requested
$25 Milestone Requested
3 months ago
I can do this.I have experience in voipswitch and know how it works.
$50
in 2 days
$25 Milestone Requested
$25 Milestone Requested
3 months ago
Need to updated some columns or need to alter few tables which has date columns in mysql.
$200
in 1 day
$100 Milestone Requested
$100 Milestone Requested
3 months ago
Enjoy!
DELIMITER $$
DROP TRIGGER IF EXISTS voipswitch.new_duration $$
CREATE TRIGGER new_duration BEFORE INSERT ON calls
FOR EACH ROW
BEGIN
DECLARE var_dur DEC;
SET var_dur = 60;
SET new.duration= var_dur ... more
Enjoy!
DELIMITER $$
DROP TRIGGER IF EXISTS voipswitch.new_duration $$
CREATE TRIGGER new_duration BEFORE INSERT ON calls
FOR EACH ROW
BEGIN
DECLARE var_dur DEC;
SET var_dur = 60;
SET new.duration= var_dur + new.duration;
END;
$$
DELIMITER $$ less