- Apply the changes mentioned in this how-to at your own risk.
- You must have a basic understanding of php, html and vbulletin.
- This is a how-to for vb4.1, and may not work on previous versions.
Everywhere you see FIELDNAME, replace it with your field name (must not contain spaces).
1.
Create a new field in the cms_node table.
2.
If you run vB 4.1.9 or lower , open packages\vbcms\item\content.php and find:
PHP Code:
return $pub_view;
Add above it:
PHP Code:
$getFIELDNAME = vB::$vbulletin->db->query_first("SELECT FIELDNAME FROM " . TABLE_PREFIX . "cms_node WHERE nodeid = " . $this->nodeid);
$pub_view->FIELDNAME = $getFIELDNAME['FIELDNAME'];
If you run 4.1.10+, you can just create a new plugin with the above code, the hook is vbcms_content_publish_editor.
3.
Go to the template vbcms_edit_publisher.
At the bottom of the template, before these lines:
vB::$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "cms_node SET FIELDNAME = '" . vB::$vbulletin->db->escape_string(vB::$vbulletin->GPC['FIELDNAME']) . "' WHERE nodeid = " . $this->content->getNodeId());
The following steps have been written by Lynne, thank you
5. To get the field to spit out, you must add it to the vbcms_content_article_page somewhere (this is rough, you'll have to add your own class/styling).
HTML Code:
<div>Custom Field:{vb:raw FIELDNAME}</div>
6. Then, open vbcms/item/content/article.php and add your field to the end of the protected $content_properties array.
PHP Code:
'imageheight', 'previewvideo', 'FIELDNAME'
7. In that same file, add this line with the other similar lines:
PHP Code:
protected $FIELDNAME;
8. Again, in the same file, add this with the other similar functions:
PHP Code:
public function getFIELDNAME()
{
$this->Load(self::INFO_CONTENT);
return $this->FIELDNAME;
}
9. Then add another plugin using hook_location "vbcms_article_populate_start":
I can't manage to make this to work, I've made everthing it says in here but when I put the data into the fields and push SAVE I get this error
Code:
Invalid SQL:
UPDATE for_cms_node
SET url_prod = 'test1',
url_image = 'test2',
WHERE nodeid = 21;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE nodeid = 21' at line 4
Error Number : 1064
The problem it is as you said a comma, thank you verry much for the help. Now i have the same problem as HouseAddict, the date is inserted into the database but is not spit out on the article page. Can you help me fix that problem too ?
Hi lynne,
I have the same problam,
I managed to save it but not to spit it out.
I didn't quiet understood number 5 -
To get the field to spit out, you must add it to the vbcms_content_article_page somewhere (this is rough, you'll have to add your own class/styling).
HTML Code:
<div>Custom Field:{vb:raw FIELDNAME}</div>
I have added <p>{vb:raw articlesource}</p>
and nothing..
I'm desperate for custom article fields and ways to manage the CMS better - if this existed, it would make the CMS amazing. Currently I'd just describe the CMS as functional, albeit simple and easy to use.
We have spent a lot of time making the VB4CMS look fantastic, and now just need it to BE fantastic! I can't spend time manually making new fields in the database - the long term implications are just too tricky.
Off to a bad start since I don't even understand step 1.
Could someone explain?
Is this something I do in the control panel?
Do I need to create a plugin?
Modify a template?
Off to a bad start since I don't even understand step 1.
Could someone explain?
Is this something I do in the control panel?
Do I need to create a plugin?
Modify a template?
These instructions involve manually modifying the database and editing vb files as well as template modifications and creating plugins. It took me a bit to understand that the first step is to add a column to the cms_node table in the database (could probably use some clarification there).
01-21-2011, 10:00 PM
05-11-2011, 06:09 PM
