VTiger form for lead generation

Today I had the problem of having to create a form for leads for my website. Using the native functions of VTiger the form was saved correctly, but the fields were not present. I have installed the version 6.4
Searching the net I found the solution to this link:

In practice operate in this way:

1.

CREATE TABLE `vtiger_webforms_field` ( `id` int(19) NOT NULL AUTO_INCREMENT, `webformid` int(19) NOT NULL, `fieldname` varchar(50) NOT NULL, `neutralizedfield` varchar(50) NOT NULL, `defaultvalue` varchar(200) DEFAULT NULL, `required` int(10) NOT NULL DEFAULT ‘0’, `captcha` int(1) NOT NULL DEFAULT ‘0’, `roundrobin` int(1) NOT NULL DEFAULT ‘0’, `roundrobin_userid` varchar(256) DEFAULT NULL, `roundrobin_logic` int(11) NOT NULL DEFAULT ‘0’, PRIMARY KEY (`id`), KEY `webforms_webforms_field_idx` (`id`), KEY `fk_1_vtiger_webforms_field` (`webformid`), KEY `fk_2_vtiger_webforms_field` (`fieldname`), CONSTRAINT `fk_1_vtiger_webforms_field` FOREIGN KEY (`webformid`) REFERENCES `vtiger_webforms` (`id`) ON DELETE CASCADE, CONSTRAINT `fk_3_vtiger_webforms_field` FOREIGN KEY (`fieldname`) REFERENCES `vtiger_field` (`fieldname`) ON DELETE CASCADE )

2.

ALTER TABLE `vtiger_webforms_field` ADD `sequence` INT NULL DEFAULT NULL AFTER `required` , ADD `hidden` INT NULL DEFAULT NULL AFTER `sequence`

CAUTION:
to me it worked but before I made a backup of the database

This information DATES ARE WITHOUT ANY WARRANTY OF SAFETY AND IF THEY WORK ON OTHER VERSIONS VTiger

Vtiger Customer Portal

 Today I had to set up the Customer Portal module of VTiger on my website, in the part related to crm, but did not know where to begin.

Searching the net I found this interesting link which explains how to set the Customer Portal and services associated with it step by step:

https://www.vtexperts.com/how-to-install-setup-and-configure-vtiger-customer-portal-module-2/

I hope to help other people with my same problem.

Show query result in more rows

 Every time we execute a mysql query in a table with mor fields or a query with few join, we have the problem to show the result because it appears in one single line and it is difficult to read the data quickly.

Searching in google I have found the solution to show the query result as each field per row. The syntax is very simple, you must add \G at the end of the query like this:

select * from students where country=’Italy’\G;

and the result will be something like to:

*************************** 1. row ***************************
id: 1
name: giak
surname: camp
city: Ancona
state: AN
country: Italy
modifiedtime: 2015-19-11 11:52:32
modifiedby: 1
*************************** 2. row ***************************
id: 2
name: micky
surname: mouse
city: Pesaro
state: PU
country: Italy
modifiedtime: 2015-12-11 08:11:45
modifiedby: 1
*************************** 3. row ***************************
…..

 

 

Include js file into another js file

In the last days I had a big problem: how I can include a javascript file into another javascript file without use the tag script?
Searching on Google I have found the answer to my problem with this simple javascript function:

function addJavascript(jsname,pos) {
     var th = document.getElementsByTagName(pos)[0];
     var s = document.createElement(‘script’);
     s.setAttribute(‘type’,’text/javascript’);
     s.setAttribute(‘src’,jsname);
     th.appendChild(s);
}

the variable jsname is the name of the javascript file
the variable pos is the tag where you want to add the file

An example of usage:
addJavascript(‘newExternal.js’,’body’);
addJavascript(‘newExternal2.js’,’head’);

It works for me, I hope for you too!

[ the original news ]

Php tools

Last days I searched on the web a place where I find simple help to common problems with php tools. The search game me this site: apptools.com.

Here you can find more information and example about php and Apache. It was very useful for me.

 

Enable usb devices on VirtualBox

Last days I had  big problem: active the usb on VirtulBox un Ubuntu 10.04. The first idea was to recompile the kernel, but my friend ( a very strong linux system administrator, here his linkedin profile) suggest me to use this command before start VirtualBox:

mount –bind /dev/bus /proc/bus

I tried the command on latest version of VirtualBox: 4.2.6

Align list item to the left in unordered list

During last days I need to find a solution to align the unsorted list <ul> to align to left. In all browsers the problem is you see space in the left side of the list, so I need a solution for this problem for a jQuery accordion menu.

My solution is to add this property padding-left: 0pt to the ul block.

You must use the rule in this way:

ul {

float: left;

width: 215px;

margin: 15px 0;

padding: 0pt;

background: #ececec;

}

This property is supported by all browsers. I hope this tip could help other developers.

Open embedded links in comments in new window

Last week I need to find out a solution for a my friend. He want to open all links embedded in comments in a new windows.

I searched on google for more time unti I found the solution, to use an hook.

Because I think other people will need a solution for this problem or maybe for a similar problem, I will describe it the solution, step by step. Are you ready? Go…

Step 1 Find the file named functions.php in your theme folder (every theme has this file) and open it for edit

Step 2 At the end of the file you can create the function to open the links in new windows, like this:

function comment_text_target_blank( $comment ) {
    $pos =  strrpos($comment,”_blank”);
    if ($pos===FALSE) {
        $theComment = str_replace(“<a”,”<a target=’_blank’ “, $comment);
    } else {
        $theComment = $comment;
    }

    return $theComment;
}

Step 3 create the hook to apply new function

add_filter(‘comment_text’, ‘comment_text_target_blank’, 1000);

This solution works for me from version 3.4.2 and newer of wordpress. I hope I helped you.

How to change the default wordpress avatar

During the current week I need to change the default avatar in the wordpress site.

Searching in google I have found this article very interesting:

http://wphacks.com/how-to-changing-the-default-wordpress-avatar/

where the author expains very well the simple steps to do to set your own default avatar.

To change the avatar is very simple: you need to search the follow part of code in all files of the wordpress:

get_avatar($comment, 50 );


in this case the second parameter is the dimension of the avatar assuming the avatar has the width euqals to the height.

You can add a third parameter that rapresents your own images like

get_avatar($comment, 50, 'http://www.wphacks.com/wp-content/themes/HackWordPressPro/images/nophoto.gif');


Enjoy with wordpress!

Welcome back

Hi to all!!!!

The giak is come back! After my old experiences this my new and defitive blog. Here I would share with you my experiences, my dreams, my idea.

The core of my blog is the IT technologis, programming languages, databases and all the topics that revolve around information technology. The main actor is LINUX and his techologies, because LINUX is all, the other are nothing.

Ok…let’s go… and if you like to follow me you are welcome!

and remember, this blog is Linux powered!