Developers How To's

UPDATE `vtiger_def_org_field` SET `visible`=0 WHERE `tabid`=15 AND `fieldid`=252 or `fieldid`=253

if(duplicate)
{
//alert("You have selected < "+duplicate_products+" > more than once in line items "+positions+".\n It is advisable to select the product just once but change the Qty. Thank You");
if(!confirm("You have selected the following product(s) more than once. \n"+duplicate_products+"\n Do you want to Continue?"))
return false;
}

 var $debugging = false;

 if(in_array($tabid,$childArr))
 {
  $parent_tabname= $parent_tab_info_array[$parid];
 }

 if(in_array($tabid,$childArr))
 {
  $parent_tabname= $parent_tab_info_array[$parid];
  break;
 }

 header("Location: index.php?action=index&module=Home");

 header("Location: index.php");

$xyz$
$leads-firstname$
$test$
$bodydetails .= "<a href='".$PORTAL_URL."/index.php?action=index&module=Tickets&ticketid=".$focus->id."&fun=detail'>Ticket Details</a>";

 //send mail to the assigned to user and the parent to whom this ticket is assigned
 require_once('modules/Emails/mail.php');
 $user_emailid = getUserEmailId('id',$focus->column_fields['assigned_user_id']);
 if($user_emailid != '')
 {
  $mail_status = send_mail( 'HelpDesk', $user_emailid, $HELPDESK_SUPPORT_NAME, $HELPDESK_SUPPORT_EMAIL_ID, $subject, $email_body );
  $mail_status_str = $user_emailid."=".$mail_status."&&&";
 }

 global $current_user;
 $user_emailid = getUserEmailId('id',$current_user->id);
 if($user_emailid != '')
 {
  $mail_status = send_mail( 'HelpDesk', $user_emailid, $HELPDESK_SUPPORT_NAME, $HELPDESK_SUPPORT_EMAIL_ID, $subject, $email_body );
  $mail_status_str = $user_emailid."=".$mail_status."&&&";
}

$rs=$adb->query("select smcreatorid from vtiger_crmentity where crmid=$ticketid");
$row=$adb->fetch_array($rs);
$user_emailid = getUserEmailId('id',$row['smcreatorid']);

 //added condition to check the emailoptout(this is for contacts and  vtiger_accounts.)
 if($emailoptout == 0)
 {
 //send mail to parent
 //The below commented out part is what sets the opt out for sending customers notifications that their tickets have been created/modified.
 //Uncomment the following lines in order allow customer to be sent a notification
 //   if($_REQUEST['parent_id'] != '' && $_REQUEST['parent_type'] != '')
 //        {
 //                $parentmodule = $_REQUEST['parent_type'];
 //                $parentid = $_REQUEST['parent_id'];
 //
 //      $parent_email = getParentMailId($parentmodule,$parentid);
 //      $mail_status =  send_mail('HelpDesk',$parent_email,$HELPDESK_SUPPORT_NAME,$HELPDESK_SUPPORT_EMAIL_ID,$subject,$email_body);
 //      $mail_status_str .= $parent_email."=".$mail_status."&&&";
 //        }
 }

 'LBL_NEWNOTIFICATION_TITLE'=>'New Notification',
 'LBL_NEWNOTIFICATION_DESC'=>'New Notification Short Description',

  $newnotifyid = $adb->getUniqueID("vtiger_notificationscheduler");
  $adb->query("INSERT INTO `vtiger_notificationscheduler`
(`schedulednotificationid`, `schedulednotificationname`, `active`,
`notificationsubject`, `notificationbody`, `label`)
 VALUES
($newnotifyid, 'LBL_NEWNOTIFICATION_TITLE', 1, 'Notification Subject',
 'This is a reminder notification for ...', 'LBL_NEWNOTIFICATION_DESC');");

backup_date_time.sql
//Added language for Parent Tab

'My Home Page'=>'My Home Page',
'Marketing'=>'Marketing',
'Sales'=>'Sales',
'Support'=>'Support',
'Analytics'=>'Analytics',
'Inventory'=>'Inventory',
'Tools'=>'Tools',
'Settings'=>'Settings',

 <?php
 //This file contains the commonly used variables

 $parent_tab_info_array = array(1=>'My Home Page', 2=>'Marketing', 3=>'Sales', 4=>'Support', 5=>'Analytics', 6=>'Inventory', 7=>'Tools', 8=>'Settings');

 $parent_child_tab_rel_array = array(1=>array(3,9,10,), 2=>array(26,6,4,10,7,9,8,), 3=>array(7,6,4,2,20,22,23,14,19,8,9,), 4=>array(13,15,6,4,14,8,10,9,), 5=>array(1,25,), 6=>array(14,18,19,21,22,20,23,), 7=>array(24,27,8,), 8=>array(),);
 ?>

 $parent_tab_info_array = array(1=>'My Home Page', /*2=>'Marketing',*/ 3=>'Sales', 5=>'Analytics', 6=>'Inventory', 4=>'Support', 7=>'Tools', 8=>'Settings');

 $parent_child_tab_rel_array=array( 1=>array(3,9,10,21,),

$deletesql = 'delete from vtiger_customview where cvid =".$cvid;

function calculate_font_name($locale) {
    global $log;
    $log->debug("Entering calculate_font_name(".$locale.") method ...");
    switch($locale) {
        case 'pl_pl':
            $log->debug("Exiting calculate_font_name method ...");
            return FF_ARIAL;

if (isset($_SERVER['SystemRoot'])) {
    define('IMAGE_CANVAS_SYSTEM_FONT_PATH', $_SERVER['SystemRoot'] . '/Fonts/');

$text = iconv($default_charset, 'utf-8', $text);

if(function_exists('iconv')
$text = iconv($default_charset, 'utf-8', $text);

if(($uitype == 102) && ($insertion_mode != 'edit') && ($fldvalue == 0))

if(($uitype == 102) && ($insertion_mode != 'edit'))

elseif ($uitype == 102)
{
 $editview_fldname[] = $fieldname;
 if ($mod_strings[$fieldlabel]) $editview_label[] = $mod_strings[$fieldlabel];
 else $editview_label[] = $fieldlabel;
 if ((! isset($value)) || (!$value)) $fieldvalue[] = "0";
 else $fieldvalue[] = $value;
}

SELECT fieldname FROM field WHERE fieldname LIKE 'cf_%' AND uitype = 15;

CREATE TABLE <name> (<name> character varying(255));

<td width=25% class="dvtCellInfo" align="left" id="mouseArea_{$label}" onmouseover="hndMouseOver({$keyid},'{$label|escape:'quotes'}');" onmouseout="fnhide('crmspanid');"> <span id="dtlview_{$label}">{if $MOD.$keyval}{$MOD.$keyval}{else}{$keyval}{/if}</span>

{$MOD.$keyval}
{if $MOD.$keyval}{$MOD.$keyval}{else}{$keyval}{/if}
if($generatedtype == 2)

if($generatedtype == 2 and empty($mod_strings[$fieldlabel]))

if($generatedtype == 2)

if($generatedtype == 2 and empty($mod_strings[$fieldlabel]))

'Address'=>'Direccion',

 $invoice_number = getInvoiceNumber();
 $focus->column_fields['subject'] = $invoice_number;

 // Extra function to create unique invoice_number
 function getInvoiceNumber() {
 global $adb;
 $sql="select max(subject) as aantal from vtiger_invoice where
 Year(invoicedate) = year(now())";
 $result = $adb->query($sql);
 $invoice_subject= $adb->query_result($result,0,"aantal");

 $invoice_subject = substr($invoice_subject,4,4);
 // raise last invoice_number of invoice with 1
 $invoice_count = $invoice_subject + 1;
 $invoice_count = str_repeat("0",4-strlen($invoice_count)).$invoice_count;
 $invoice_year = date("Y");
 $invoice_number= $invoice_year.$invoice_count;
 return $invoice_number;
 }

$default_module = 'Home';

'Home'
'Contacts'
 $allKeys = array_keys($HTTP_POST_VARS);

 $allKeys = array_keys($_REQUEST);

mysqld-nt --install MySQL --defaults-file=D:\vtigerCRM\vtigercrm5\mysql\my.ini

// maximum file size for uploaded files in bytes also used when uploading import files
// upload_maxsize default value = 3000000
$upload_maxsize = 3000000;

<INPUT TYPE="hidden" NAME="MAX_FILE_SIZE" VALUE="<?php echo $upload_maxsize; ?>">

<INPUT TYPE="hidden" NAME="MAX_FILE_SIZE" VALUE="1000000">

$bodydetails .= "<a href='".$PORTAL_URL."/index.php?action=index&module=Tickets&ticketid=".$focus->id."&fun=detail'>Ticket Details</a>";

global $entityDel;
global $display;

putenv("TZ=US/Eastern");

$query="select vtiger_products.productname, vtiger_products.product_description, vtiger_products.unit_price, vtiger_products.qtyinstock, vtiger_inventoryproductrel.* from vtiger_inventoryproductrel inner join vtiger_products on vtiger_products.productid=vtiger_inventoryproductrel.productid where id=".$focus->id." ORDER BY sequence_no";

select vtiger_products.productname, vtiger_inventoryproductrel.comment, vtiger_products.unit_price, vtiger_products.qtyinstock, vtiger_inventoryproductrel.* from vtiger_inventoryproductrel inner join vtiger_products on vtiger_products.productid=vtiger_inventoryproductrel.productid where id=".$focus->id." ORDER BY sequence_no

$prod_description[$i] = $associated_products[$i]['productDescription'.$i];

$prod_description[$i] = $associated_products[$i]['comment'.$i];

vtiger_inventoryproductrel.description AS product_description,

vtiger_inventoryproductrel.comment AS product_description,

 function hndMouseOver(uitype,fieldLabel)
 {
 return true;
 var mouseArea="";
 mouseArea="mouseArea_"+ fieldLabel;
 ...

$focus->save("Contact");

$focus->column_fields["title"] = $current_user->user_name;

mysql -u root -p

drop database vtigercrm4_2;

create database vtigercrm4_2;

mysql --user=root --password= --port=3306 -h localhost vtigercrm4_2 --force < vtigercrm_dump.txt

<tr><th>Loan Purpose:</th>
<td><select name="loanpurpose">
<option value="Purchase">Purchase</option>
<option value="Refi - Rate,Term">Refi - Rate,Term</option>
<option value="Refi - Cash-out">Refi - Cash-out</option>
<option value="Second">Second</option>
<option value="Other">Other</option>
</select></td>
</tr>

 'loanpurpose'=>"$loanpurpose" 
if($_REQUEST['create'] == 'lead')
$loanpurpose = $_POST['loanpurpose'];

$params = array(
$focus->column_fields['cf_453'] = $loanpurpose; <-- this is where the new form value gets mapped to the custom field ID.

 alter table vtiger_inventoryproductrel change column quantity quantity decimal(11,3) default NULL;

 $viewBox = 'listview';

 $viewBox = 'hourview';

'LBL_MYNEW_LABEL' => 'What ever the title in you language'

 INSERT INTO profile2field (SELECT profileid, 9, (SELECT fieldid FROM field WHERE tabid = 9 AND columnname = 'eventstatus'), 0, 1 FROM profile);

 INSERT INTO def_org_field (SELECT 9, fieldid, 0, 1 FROM field WHERE tabid = 9 AND columnname = 'eventstatus');

softed
$default_theme
$default_theme = 'woodspice';

patch -p0< $patchname

// list_max_entries_per_page default value = 20
$list_max_entries_per_page = '20';

teKvqLqm1UZPg
$ticket->save("HelpDesk");
$ticket->column_fields[assigned_user_id]=1;

$_REQUEST['assigned_user_id'] = $parnet_id;
$_REQUEST['assigned_user_id'] = 1;
 $smarty->assign("ALL_TAG",$freetag->get_tag_cloud_html("",$current_user->id));

 $smarty->assign("ALL_TAG",$freetag->get_tag_cloud_html(""));

</script>
var soundfile="Notify.wav" //path to sound file, or pass in filename directly into playsound()
function playsound(soundfile){
    document.getElementById("soundeffect").innerHTML= "<embed src='"+soundfile+"' hidden=true autostart=true loop=false>";
}

playsound(soundfile)
#!/bin/sh

# "Marketing_Mailer.sh" for marketing campaigns - all associated files are in the same directory.
#  Tuesday February 13th 2007
#  Usage: ./marketing_mailer.sh emails_and_firstname.txt

PATH=$PATH:$HOME/bin:.
BASH_ENV=$HOME/.bashrc
USERNAME=""
export USERNAME BASH_ENV PATH
PATH=.:/usr/local/bin:$PATH
REPLYTO="user@example.com"
export PATH REPLYTO
HOME=/home/admin; export HOME

maillist=`cat $1`

for i in $maillist
do
  EMAIL=`echo $i | awk -F: '{ print $1 }'`
  NAME=`echo $i | awk -F: '{ print $2 }'`
  echo "sending email to ($NAME) at ($EMAIL)"
  mutt -F /admin/marketing_email/Feb20/muttrc -s "mail-shot subject" $EMAIL -a attachment.pdf <<!EOF
Dear $NAME,

<body content here>

!EOF
done

# To ensure that mutt does not put 'username@localhost.localdomain in From
set from="user@example.com"
set use_from=yes
set envelope_from="yes"
set editor=vi

email_address:first_name
ben@blah.com:Ben
bev@blah.co.uk:Beverley
bob@blah.co.uk:Bob

#!/bin/sh

# Make certain the EMAIL_LIST file contains addresses that are in vtiger!

EMAIL_LIST=./email-list.txt
EMAIL_CAMPAIGN="20070220_Email"
EMAIL_BODY=" \
Email body text here
\
Name
Sig. "

# DO NOT CHANGE BELOW HERE

for i in `cat $EMAIL_LIST`
do
echo "Updating CRM with note for $i"

mysql -uusername -ppassword --host=mysql_host database_name <<!EOF

set autocommit=0;
commit;

update crmentity_seq set id = id +1;

insert into crmentity
(crmid, smcreatorid, smownerid, modifiedby, setype, description, createdtime, modifiedtime, viewedtime, status, version, presence, deleted)
select id, 148, 148, 0, 'Notes', '', now(), now(), null, null, 0, 1, 0
from crmentity_seq;

insert into notes
(notesid, contact_id, title, filename, notecontent)
select id, 0, '$EMAIL_CAMPAIGN', null, '$EMAIL_BODY'
from crmentity_seq;

insert into senotesrel (crmid, notesid)
select ld.leadid, cs.id
from leaddetails ld, crmentity_seq cs
where ld.email = '$i';

commit;
!EOF
done

'LBL_DELETE_BUTTON_KEY' => 'D',

{if $LABEL.location neq ''}
<tr>
<td class="cellLabel" align="right" valign="top"><b>{$LABEL.location}</b></td>
<td class="cellInfo" colspan=3 align="left" >{$ACTIVITYDATA.location}</td>
</tr>
{if}

$languages = Array('en_us'=>'US English','ru_ru'=>'Russian',);

 $default_charset = 'ISO-8859-1';

 $default_charset = 'UTF-8';

$mail_server = '';
$mail_server_username = '';
$mail_server_password = '';

{if $fldvalue eq 1}
if
</td>
 {elseif $fldname eq emailoptout AND $MODE neq edit}
 <td width="30%" align=left class="dvtCellInfo">
 <input name="{$fldname}" type="checkbox" tabindex="{$vt_tab}" checked>
 </td>

	Main Page \| About \| Help \| FAQ \| Special pages \| Log in
	Printable version \| Disclaimers \| Privacy policy

Developers How To's

Contents

[edit] How to make the questions & answers in the FAQ module visible

[edit] How to add the same service a number of times on the same invoice

[edit] How to determine what templates are being used

[edit] How to Set the default login module

[edit] How to change the char set for the tables in the MySQL database to CP1251

[edit] How to customize Trouble ticket email sending

[edit] How to modify the trouble ticket email templates

[edit] How to change email templates for notifications

[edit] How to handle $ truncated text in non-html email

[edit] How to set IMAP to not delete email

[edit] How to fix the Customer portal address in response email

[edit] How to send a copy of the email to the person who opened the trouble ticket

[edit] How to resolve problem of duplicate email going to the person who posted the trouble ticket

[edit] How to turn off notification mails of new tickets

[edit] How to Re-create Notifications

[edit] How to do E-mail notifications translation

[edit] How to Create New Notifications

[edit] How to bulk email outside of vTiger and update records

[edit] How to import a CSV file

[edit] How to Import using SQL

[edit] How to import Notes

[edit] How to migrate Sugar data to vtiger CRM

[edit] How to back up data

[edit] How to edit/modify tab names

[edit] How to add or remove Modules from tabs

[edit] How to remove dashboard tab

[edit] How to remove modules from the dashboard tab

[edit] How to remove menu items from quick access

[edit] How to disable Help and About Us

[edit] How to remove main tabs

[edit] How to remove the secondary tabs under the main tabs

[edit] How to change tab ID

[edit] How to remove a theme

[edit] How to remove "Delete" from custom views

[edit] How to change the PDF layout for invoices and quotes

[edit] How to change the font to support other languages

[edit] How to set up Auto-increment fields

[edit] How to show "read only" on the screen for a custom field

[edit] How to restore picklists after data restore

[edit] How to make Translatable Picklists

[edit] How to make Translatable Custom field labels

[edit] How to create a unique series of invoice numbers without gaps

[edit] How to sort leads by company name instead of by contact

[edit] How to change titles in the chart of Pipeline By Sales Stage

[edit] How to configure a filter

[edit] How to set the user's home page

[edit] How to change a field length

[edit] How to change a field label

[edit] How to use variables when creating views

[edit] How to handle dissappearing views in leads, contacts, accounts, and potential

[edit] How to customize vtiger Web Forms

[edit] How to determine if a contact has been marked as deleted

[edit] How to determine which tables the Leads and Potentials are saved in

[edit] How to remove 2 page in invoice

[edit] How to create a new Color theme for vtiger CRM 5

[edit] How to create a new module or tab in vtiger 5

[edit] How to submit a module for addition to vtiger CRM project

[edit] How to set up mysql service

[edit] How to change the crmid in vtiger_crmentity

[edit] How to restrict users from adding new URL/Websites to this module

[edit] How to host vtiger crm in a multitenant fashion

[edit] How to see the database Schema

[edit] How to view/change the attachment size limit

[edit] How to change ticket detail in Customer portal

[edit] How to handle servers on different timezones

[edit] How to change the default currency

[edit] How to format "Amount" field to include commas

[edit] How to view 'vtigercrm.log' file WITHOUT having Apache root

[edit] How to get the "comment" from the area below product to add to an invoice

[edit] How to enter and track serial numbers for each item in an inventory

[edit] How to remove the Java script edit per field

[edit] How to save extra data like the user id for every saved contact

[edit] How to change or enable the settings in FCKeditor

[edit] How to set username and password as default

[edit] How to reset password

[edit] How to hide or remove system details from the user

[edit] How to back up and restore a 4.2 database

[edit] How to call custom fields in a webform