[Vtigercrm-developers] example does not work

[gabor]

alex svetos <alex.svetos at gmail.com> írta:

> I don't understand what you want to do. But if you want to
add a new field

Actually I have defined a new table in vtiger database
(vtiger_login_hist). I wan to make the certain contact's
last login time to be displayed on Contacts/More Information
tab.
Technically I don't know for 100% sure how this should be
achieved. This is why I bother you here on this list:)
I have made some attempt based on online documentation on
vtiger page but those were failed. And I don't know where to
start to looking for my fault.  

> in a Contact you should do something like this :
> if you want to add a new field on Contact, assuming your
field ids called
> 'card_number' you should insert a new line in vtiger field
with thoses
> values :
> 
> insert into a vtiger_contact values (4,
an_unused_field_id, 'card_number',
> 'card_number',
>
'vtiger_contactdetails',1,7,'card_number','card_number',1,0,0,15,0,4,1,'I~O',1,NULL,'ADV'
> )
> 
> And add a the new column in vtiger_contactdetails.
> 
> (assuming your new field is called 'mobile_phone' and is
used to store a
> phone number.)
> 
Did I get it right that I have to update three tables in
database for this case? These table are: vtiger_field,
vtiger_contact and vtiger_contactdetails, aren't they?

thanks for help so far!

Gabor

___________________________________________________________
A legjobb AKCIÓS utazások oldala - Budavár Tours
http://ad.adverticum.net/b/cl,1,6022,99401,161631/click.prm