<div dir="ltr">This is for update duration (in minutes).<div><div><pre class="" style="margin-top:0px;padding:5px;border:0px;font-size:13px;overflow:auto;width:auto;max-height:600px;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,sans-serif;color:rgb(57,51,24);word-wrap:normal;background-color:rgb(238,238,238)"><code style="margin:0px;padding:0px;border:0px;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,sans-serif;white-space:inherit"><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">delimiter </span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">|</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">
</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,139)">CREATE</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)"> </span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,139)">TRIGGER</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)"> </span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">`</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">end_time_update</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">`</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)"> BEFORE </span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,139)">UPDATE</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)"> </span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,139)">ON</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)"> </span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">`</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">vtiger_pbxmanager</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">`</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)"> 
</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,139)">FOR</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)"> EACH </span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,139)">ROW</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">
</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,139)">BEGIN</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">
   </span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,139)">set</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)"> NEW</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">.</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">endtime </span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">=</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)"> now</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">();</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">
   </span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,139)">set</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)"> NEW</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">.</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">duration </span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">=</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)"> TIMESTAMPDIFF</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">(</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">SECOND</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">,</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)"> NEW</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">.</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">starttime</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">,</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)"> NEW</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">.</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">endtime</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">);</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">
</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,139)">END</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">
</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">|</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">
delimiter </span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">;</span></code></pre><div class="gmail_extra"><br></div><div class="gmail_extra">Additionally, you can create this trigger for UTC time sync, this is because vtiger store times as UTC (+0)</div><div class="gmail_extra"><pre class="" style="margin-top:0px;padding:5px;border:0px;font-size:13px;overflow:auto;width:auto;max-height:600px;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,sans-serif;color:rgb(57,51,24);word-wrap:normal;background-color:rgb(238,238,238)"><code style="margin:0px;padding:0px;border:0px;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,sans-serif;white-space:inherit"><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">delimiter </span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">|</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">
</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,139)">CREATE</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)"> </span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,139)">TRIGGER</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)"> </span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">`</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">end_time_update</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">`</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)"> BEFORE </span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,139)">UPDATE</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)"> </span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,139)">ON</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)"> </span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">`</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">mytable</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">`</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)"> 
</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,139)">FOR</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)"> EACH </span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,139)">ROW</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">
</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,139)">BEGIN</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">
   </span><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;white-space:normal;background-color:rgb(255,255,255)"> set NEW.starttime = UTC_TIMESTAMP();</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">
</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,139)">END</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">
</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">|</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">
delimiter </span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,0)">;</span></code></pre></div><div class="gmail_extra"><div class="gmail_extra"><br></div><div class="gmail_extra">  </div><div class="gmail_extra"><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">2015-10-13 17:04 GMT+02:00 Vladimir Karažija <span dir="ltr"><<a href="mailto:vladimir@kosacrta.hr" target="_blank">vladimir@kosacrta.hr</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><p dir="ltr">Hi Michele,</p>
<p dir="ltr">would you be so kind to share solution for this problem?</p>
<p dir="ltr">regards, Vladimir</p>
<p dir="ltr">Vladimir Karažija</p>
<p dir="ltr">Kosa crta d.o.o.<br>
Jagnedje 1<br>
10090 Zagreb<br>
OIB: 57724075047</p>
<p dir="ltr">t. <a href="tel:%2B385%201%20777%2033%2085" value="+38517773385" target="_blank">+385 1 777 33 85</a><br>
m. <a href="tel:%2B385%2091%20122%200511" value="+385911220511" target="_blank">+385 91 122 0511</a><br>
<a href="http://www.kosacrta.hr" target="_blank">www.kosacrta.hr</a></p>
<p dir="ltr">    </p>
<div class="gmail_quote"><div><div class="h5">On Oct 13, 2015 12:41 PM, "Michele Mastropieri" <<a href="mailto:michele.mastropieri@gmail.com" target="_blank">michele.mastropieri@gmail.com</a>> wrote:<br type="attribution"></div></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div><div class="h5"><div dir="ltr">Solved manually, I've create a mysql trigger before update into table vtigerpbxmanager</div><div class="gmail_extra"><br><div class="gmail_quote">2015-10-12 11:55 GMT+02:00 Michele Mastropieri <span dir="ltr"><<a href="mailto:michele.mastropieri@gmail.com" target="_blank">michele.mastropieri@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div dir="ltr">Hi to all,<div><br></div><div>when I open PBX Manager module I can see all pbx calls. The problem is that the duration is always 60 seconds. But the actual duration is minimum 10 minutes or more.</div><div><br></div><div>How resolve?<span><font color="#888888"><br clear="all"><div><br></div>-- <br><div><div dir="ltr"><span style="color:rgb(42,42,42)"><pre style="line-height:17px;white-space:normal"><hr style="font-size:10pt;font-family:'Segoe UI',Tahoma,Verdana,Arial,sans-serif"><font size="2" face="verdana, sans-serif">dott. Michele Mastropieri<br></font><span style="font-family:verdana,sans-serif;font-size:small">Email: </span><a href="mailto:michele.mastropieri@gmail.com" style="font-family:verdana,sans-serif;font-size:small" target="_blank">michele.mastropieri@gmail.com</a><br><span style="font-family:verdana,sans-serif;font-size:small">Skype: thebookison<br></span><span style="font-family:verdana,sans-serif;font-size:small">Mobile: 3403050591<br></span><span style="font-family:verdana,sans-serif;font-size:small">Fax: </span><font color="#2a2a2a" style="font-family:verdana,sans-serif;font-size:small;line-height:normal"><span style="line-height:17px">1782280825<br></span></font><span style="font-family:verdana,sans-serif;font-size:small">Ai sensi del D.Lgs.196/2003 si precisa che le informazioni contenute in questo messaggio sono riservate ed a uso esclusivo del destinatario.<br></span><span style="font-family:verdana,sans-serif;font-size:small">N.B. Rispetta l'ambiente. Non stampare questa mail se non è necessario.</span><span style="font-family:verdana,sans-serif;font-size:small"><br></span></pre></span></div></div>
</font></span></div></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div><div dir="ltr"><span style="color:rgb(42,42,42)"><pre style="line-height:17px;white-space:normal"><hr style="font-size:10pt;font-family:'Segoe UI',Tahoma,Verdana,Arial,sans-serif"><font size="2" face="verdana, sans-serif">dott. Michele Mastropieri<br></font><span style="font-family:verdana,sans-serif;font-size:small">Email: </span><a href="mailto:michele.mastropieri@gmail.com" style="font-family:verdana,sans-serif;font-size:small" target="_blank">michele.mastropieri@gmail.com</a><br><span style="font-family:verdana,sans-serif;font-size:small">Skype: thebookison<br></span><span style="font-family:verdana,sans-serif;font-size:small">Mobile: 3403050591<br></span><span style="font-family:verdana,sans-serif;font-size:small">Fax: </span><font color="#2a2a2a" style="font-family:verdana,sans-serif;font-size:small;line-height:normal"><span style="line-height:17px">1782280825<br></span></font><span style="font-family:verdana,sans-serif;font-size:small">Ai sensi del D.Lgs.196/2003 si precisa che le informazioni contenute in questo messaggio sono riservate ed a uso esclusivo del destinatario.<br></span><span style="font-family:verdana,sans-serif;font-size:small">N.B. Rispetta l'ambiente. Non stampare questa mail se non è necessario.</span><span style="font-family:verdana,sans-serif;font-size:small"><br></span></pre></span></div></div>
</div>
<br></div></div>_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br></blockquote></div>
<br>_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr"><span style="color:rgb(42,42,42)"><pre style="line-height:17px;white-space:normal"><hr style="font-size:10pt;font-family:'Segoe UI',Tahoma,Verdana,Arial,sans-serif"><font size="2" face="verdana, sans-serif">dott. Michele Mastropieri<br></font><span style="font-family:verdana,sans-serif;font-size:small">Email: </span><a href="mailto:michele.mastropieri@gmail.com" style="font-family:verdana,sans-serif;font-size:small" target="_blank">michele.mastropieri@gmail.com</a><br><span style="font-family:verdana,sans-serif;font-size:small">Skype: thebookison<br></span><span style="font-family:verdana,sans-serif;font-size:small">Mobile: 3403050591<br></span><span style="font-family:verdana,sans-serif;font-size:small">Fax: </span><font color="#2a2a2a" style="font-family:verdana,sans-serif;font-size:small;line-height:normal"><span style="line-height:17px">1782280825<br></span></font><span style="font-family:verdana,sans-serif;font-size:small">Ai sensi del D.Lgs.196/2003 si precisa che le informazioni contenute in questo messaggio sono riservate ed a uso esclusivo del destinatario.<br></span><span style="font-family:verdana,sans-serif;font-size:small">N.B. Rispetta l'ambiente. Non stampare questa mail se non è necessario.</span><span style="font-family:verdana,sans-serif;font-size:small"><br></span></pre></span></div></div>
</div></div></div></div>