vtiger_search.php modification to add comments and title

[Noah]

Quick summary of the problem. Typing any comments in the vicidial agent gui would not transfer to the vtiger CRM, Simply added the Value Comments, similarly title was not posting as well.

Edit vtiger_search.php

With your favorite editor and compar

#Insert values into vtiger_crmentity edited by noah 1-17-2011 added comments and '$comments'
$stmt = "INSERT INTO vtiger_crmentity (crmid, smcreatorid, smownerid, modifiedby, setype, description, createdtime, modifiedtime, viewedtime, status, version, presence, deleted) VALUES ('$leadid', '$user_id', '$user_id','$user_id', 'Leads', '$comments', '$NOW_TIME', '$NOW_TIME', '$NOW_TIME', NULL, '0', '1', '0');";
if ($DB) {echo "|$stmt|\n";}
$rslt=mysql_query($stmt, $linkV);
if ($DB) {echo "|$leadid|\n";}
if (!$rslt) {die('Could not execute: ' . mysql_error());}

#Insert values into vtiger_leaddetails edited by noah 1-17-2011 added comments and '$comments' and title to designation
$stmt = "INSERT INTO vtiger_leaddetails (leadid,salutation,firstname,lastname,company,comments) values('$leadid','$title','$first_name','$last_name','$first_name $last_name','$comments');";
if ($DB) {echo "|$stmt|\n";}
$rslt=mysql_query($stmt, $linkV);
if (!$rslt) {die('Could not execute: ' . mysql_error());}

[williamconley]

when you post, please post your entire configuration including (but not limited to) your installation method and vicidial version with build.

this IS a requirement for posting along with reading the stickies (at the top of each forum) and the manager's manual (available on EFLO.net, both free and paid versions)

You should also post: Asterisk version, telephony hardware (model number is helpful here), cluster information if you have one, and whether any other software is installed in the box. If your installation method is "from scratch" you must post your operating system and should also post the .iso version from which you installed your original operating system.

Similar to This:

Vicibox X.X from .iso | Vicidial X.X.X-XXX Build XXXXXX-XXXX | Asterisk X.X.X | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation
_______________

If you were to post this to the Vicidial Issue Tracker (as a ".diff" file against the latest version of Vicidial, easily created) ... it may get into the actual code (so you won't have to re-patch after your next upgrade ... )

[johngrossi]

Now for the vtiger database update -

* email_campaign will be my note title in vtiger.
* email_body will be the note contents.
* user '148' is a user called 'admin' that I created specifically for these mass updates.