vbFEngine Create your own Mods by vbFreelancers

[Olympic]

Removed by the Author
due to luck of free time to support it.
------------------------------------------------------------


vbFEngine
The Polymorphic Module
by vBulletin Freelancers (http://www.vbulletinfreelancers.com)

Credit goes to Maria (MicroHellas)
as this module has developed 100% from her.
I just did some corrections according to
vBulletin prototype for security.

1.- What's this?

vbFEngize is a polymorphic module. The package contains the engine which is a set of functions and templates, and thanks to the power of the organized in fieldsets custom fields, you can produce any type of module which is base in database records.

2.- Examples

By setting the correct custom fields, you can produce Module for:

Profiles
Articles
Receipts
Photos
Videos
Catalogs
Links
Classifieds
Profiles
Collections
and anything else related to database records3.- Standard Fields

Category
Userid
Title
Description (using vbEditor)
Main Photo
Photo Gallery for each record4.- Including in Lite version Features (functions)

Categories
RSS for each category
Sponsored Records
Premium Records
Top Records
Editor Choice records
Newest Records
Popular Records
Top Users
Search by Category, Username, Keywords
Bookmarks
vbSeo friendly
Ability to setup different template in your module
Ability to setup different template per category(1) Records means: Profiles, Articles, Receipts, Items etc

5.- Extra fields

Extra fields are reusable (and here is the real power). Eg if you want to use a field "Age" multiple times in a form, you don't need to create it twice. You create it once and then you can assign it to as many fieldsets you want in the same form.
Group fields (or fieldsets). No more ungly listing. You can organize the custom fields in fieldgroups, and then assign each field group in one, multi, or all available categories.6.- Extra field types

Text
Radio button
Checkboxes
Textarea
Drop list (single select)
Drop list (multiple select)7.- Installation

Upload all files and directories including at "vbulletin" directory to the directory where vBulletin is installed.
CMOD the following directories to 777
/photos (inside vbfengine directory)
/tmp (inside vbfengine/photos directory)
/thumbs (inside vbfengine/photos directory)
For security reasons backup your database AND turn your board off
Check at your AdminCP->vBulletin Options->Plugin/Hook System that Plugin system is enabled.
From your AdminCP->Plugin System->Manage Products choose Add/Import Product and import the product: product_vbfengine.xml
If you want to add a link to your nav bar then you must edit the NAVBAR template:

Search For: <td class="vbmenu_control"><a href="calendar.php$session[sessionurl_q]">$vbphrase[calendar]</a></td>
Add Below: <td class="vbmenu_control"><a href="vbfengine.php$session[sessionurl_q]">Profiles</a></td>
....or use any other word you want
By default none usergroup has permissions to use vbfengine, so you need to give permissions to any group. Goto AdminCP->Usergroups->Usergroup Manager and edit any usergroup you like to give permissions.
*** IMPORTANT *** If you don't give to Guest at least "can use" permissions, then they must NOT be able to see the links (Tell a Friend function).
If you've installed vbSEO, Login into vbSEO Control Panel, click "Custom Rewrite Rules", insert rewrite rules (attached in vbseo-rules.txt to not lose formatting) and save settings.8.- First steps in use

Set the various options at vbFEngine->Options
Setup the categories
Setup (if you need them) Custom fields. Please note that fields are reusable, so in case that for example you want to use twice the field "Age" you don't need to create it 2 times. One is enought.
Setup Custom fields groups. You can add as many fields as you want to a group, and then to assign this group to one or more, or all categories. Please pay attention for unique display order of the groups.9.- Authorization for reuse and redistribute (but please read carefully!!)

For Personal use: You can modify the code as you want by adding or removing features and/or templates, but in this case you can't share these modifications with other usres/members
For Coders:
You've the permission to:
Rename the files (so you can produce different modules).
You can setup the extra fields as you want and then to modify the file: products-vbfengine.xml to auto insert the field's values in database.
You can post the final product (including my files) for FREE only and only in vBulletin.org. Nowhere else, except if it's a vBulletin community operating by you.
You don't have permission to:

Modify the code
To add more functions (features)
To add more extra field types
To remove my copyright. But you can add yours, one line over mine.
And for sure you don't have permission to sell the module.

[edenx]

Seems cool but can you give more examples on uses for this?

[vbFreelancers]

Seems cool but can you give more examples on uses for this?
Really unlimited. See the screenshoots. By adding some extra fields related to job seeking I did a module for job seeking. In the other screenshoot, by adding some fields (questions) about dating I did a dating module. This way, you can easily create a module for Business directory, for Receipts, for Articles etc etc.

Let's say that you did a module for Receipts. The included standard functions, can show:

Top Receipts
Popular receipts (according to views)
Editor choice receipts
Sponsored receipts
Premium receipts
Newest receipts

[steadicamop]

Is this compatible with 3.6.2 (I haven't been able to upgrade yet) - I am getting database errors for accessing the main page and when trying to add New Extra Fields Group. (Exact database error can be found here - http://www.steadiforum.com/vbfengine.php)

Is this able to pull existing data from the tables, ie - username, date of birth etc ... ?

This is exactly what I have been looking for for a number of years, I hope this works!!

TIA

Jason

[vbFreelancers]

Is this compatible with 3.6.2 (I haven't been able to upgrade yet) - I am getting database errors for accessing the main page and when trying to add New Extra Fields Group. (Exact database error can be found here - http://www.steadiforum.com/vbfengine.php)

Is this able to pull existing data from the tables, ie - username, date of birth etc ... ?

This is exactly what I have been looking for for a number of years, I hope this works!!

TIA

Jason

Hello Jason,

Please give permissions to Guest, at least "Can use" to be able to enter. What I can imagine for database errors is that you haven't setup categories yet.

Marina

[steadicamop]

My apologies I totally forgot about that - it's done, you should be able to access it now.

I have set one category up - and one extra field - so there is something populated in those tables.

Thanks for your help,

Jason

[steadicamop]

Sorry to reply to myself - it would appear the table vbfengine_subcategories is missing from the database, I've just checked and it hasn't been set up by the install.

[vbFreelancers]

My apologies I totally forgot about that - it's done, you should be able to access it now.

I have set one category up - and one extra field - so there is something populated in those tables.

Thanks for your help,

Jason

I found the problem, but don't know if I can resolve it right now as I'm connect from my appartment. Olympic removed the subcategories table from the product-vbengine.xml file. This causes the database error
I'll try to see if I've in my laptop any FTP client to connect to the server, to get the code. Otherwise tomorrow morning. I apologize for troubles.

[steadicamop]

No problems, glad it's something minor, I really want to be able to add this to my community and feel relieved that it's not just a backwards compatible issue!

Will keep an eye on the thread over the next 24 hours, thanks once again for your help.

Jason

[yahoooh]

wow , thanks

[vbFreelancers]

For those who have installed vbFEngine till this post, please uninstall it and import the attached xml file, as the zip file contains xml file with missing some tables.

Marina

[Olympic]

Zip file updated with the correct product-vbfengine.xml file.

Sorry for troubles
Chris

[steadicamop]

After manually removing some of the tables I successfully installed the mod - but ....

Database error in vBulletin 3.6.2:

Invalid SQL:
INSERT INTO vbfengine_items (id, categoryid, subcategoryid, userid,
title, description, paypalemail, price, active, currency, hidden, approved, activateddate,
featured, editor, bold) VALUES (NULL, 1, 0, 1, 'Jason Williams', 'Test posting test test test', '',
'', 0, , 0, 1, 1199914009, 0, 0, 0);

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 ' 0, 1, 1199914009, 0, 0, 0)' at line 4
Error Number : 1064

I get this error when trying to create a new profile.

[Nordinho]

Really unlimited. See the screenshoots. By adding some extra fields related to job seeking I did a module for job seeking. In the other screenshoot, by adding some fields (questions) about dating I did a dating module. This way, you can easily create a module for Business directory, for Receipts, for Articles etc etc.

Let's say that you did a module for Receipts. The included standard functions, can show:

Top Receipts
Popular receipts (according to views)
Editor choice receipts
Sponsored receipts
Premium receipts
Newest receipts

This looks pretty interesting, but still I'm wondering is this to be used with VBClassifieds or VBadvanced, or MAdeByMary products??

[aycan555]

Thanxs for this great hack....

[Olympic]

I get this error when trying to create a new profile.

This is happening when someone tries to remove features from a full version to build a lite one. Upload the attached file in your vB directory.
** Zip file updated **

[Jon_Simmonds]

Whats the difference between the lite and full version (which I guess is not available at the moment?)

[Olympic]

Whats the difference between the lite and full version (which I guess is not available at the moment?)

Yes, commercial version is on Beta testing. Additional to Lite features are:

More field types (Numeric, Date, Links)
A custom field can be Required or not
A custom field can be Searchable or not
Advanced Search in all fields marked as searchable. For numeric fields the search can be perform on =, >=, <= or in range (From ... To). Same applies to date fields.
Supports Subcategories (and so RSS for subcategories)
Setting Categories/Subcategories you can setup that posts in this category/subcategory can has its own Forum for discussion (in Lite there is only rating)
Categories/Subcategories can be setup for paid posts (in Lite all posts are free).
And finally Support and lifetime free upgrades.

[Jon_Simmonds]

Sounds good, think this can be adpated to something I have been thinking off.

Could the total value of all items within a category be added up to produce a figure? eg on a car forum could it be used as a members car database and give output such as:
-total number of cars in the database
-total retail value of the cars in the database
-combined power of the cars in the database

[Olympic]

Whats the difference between the lite and full version (which I guess is not available at the moment?)

And something else that I forgot:

Import/Export Custom fields schema
The license in not per domain/installation, but only per domain. So, you can setup as many different modules as you want in the same domain.

[Olympic]

Sounds good, think this can be adpated to something I have been thinking off.

Could the total value of all items within a category be added up to produce a figure? eg on a car forum could it be used as a members car database and give output such as:
-total number of cars in the database
-total retail value of the cars in the database
-combined power of the cars in the database

Even if I didn't got your meaning for the 3nd option (do you mean the average value), yes it can be done as its a simple query.

[Olympic]

This looks pretty interesting, but still I'm wondering is this to be used with VBClassifieds or VBadvanced, or MAdeByMary products??

None of them. It's a MadeByMary product, but it dosen't needs anything else (except vBulletin) to work. Install it and you'll understand it. Even without adding any extra field it works fine.

[Jon_Simmonds]

Even if I didn't got your meaning for the 3nd option (do you mean the average value), yes it can be done as its a simple query.
I ment the combined total (i.e the sum) of all of the cars powers, if it can be done then great!

[gael11]

Hi, very very very nice and usefull hack !!!

Easy to install and use it, but I've got a SQL error when I'm editing a new profiles.
I give permissions to all usergroups to use the vbfengine.
I still use vb on my computer with wamp.

This is my sql error:
Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE vbfengine_items SET description='Test roadbook ;)', paypalemail='',
price='', currency=, hidden=0 , title='Roadbook test'
WHERE id=1;

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 ' hidden=0 , title='Roadbook test'
WHERE id=1' at line 2
Error Number : 1064
Date : Thursday, January 10th 2008 @ 04:21:07 PM

Thanks for your help !

[Olympic]

price='', currency=, hidden=0 , title='Roadbook test'
WHERE id=1;


The error is here: currency=, . It should be currency='',
Could you please upload the attached file and try again? When you downloaded the zip file?

Chris

[Olympic]

I ment the combined total (i.e the sum) of all of the cars powers, if it can be done then great!
Much easier. Yes, it can be done.

[gael11]

The error is here: currency=, . It should be currency='',
Could you please upload the attached file and try again? When you downloaded the zip file?

Chris
Thanks for the file, I've downloaded the hack, about two hours ago.

It doesn't work :/

[Olympic]

Thanks for the file, I've downloaded the hack, about two hours ago.

It doesn't work :/

Please try again the attached file. I just noticed that there was a second referrence to currency. Sorry for troubles.

[gael11]

Thanks again, works perfectly now !!!

Congratulations for your excellent work

[steadicamop]

The fixed file worked perfectly, thank you - but I'm noticing images aren't uploading, it is selected but doesn't seem to upload, it's too quick and nothing appears on the profile page.

[vbFreelancers]

The fixed file worked perfectly, thank you - but I'm noticing images aren't uploading, it is selected but doesn't seem to upload, it's too quick and nothing appears on the profile page.

Have you cmod 777 directories:

photos
photos/thumbs
photos/tmpAlso in usergroup permissions, have you setup any number? (default = 0)

[djbaxter]

I get the following error when I try to download:

Invalid Attachment specified. If you followed a valid link, please notify the administrator

[TCE Killa]

Is this basically a hack in to create your own mods/hacks?

[vbFreelancers]

I get the following error when I try to download:
Strange. I just clicked download and it works. If you continue having problems try the version from 3.7.x Its the same.

[vbFreelancers]

Is this basically a hack in to create your own mods/hacks?

Yes and no. To create mods that are based in database records. eg Articles, Links, Listings, Catalogs, Books etc.

[steadicamop]

Have you cmod 777 directories:

photos
photos/thumbs
photos/tmpAlso in usergroup permissions, have you setup any number? (default = 0)

I had chmod'd the directories ... but the usergroup option had thrown me - because I have issues uninstalling it - all working perfectly now though - thank you once again!

Is there any way of allowing existing data from other tables (such as date of birth) to be used in this mod - would save having to type it in twice.

Fantastic mod - thank you so much, just what I've needed for a long time.

Jason

[vbFreelancers]

Is there any way of allowing existing data from other tables (such as date of birth) to be used in this mod - would save having to type it in twice.
Jason

That's a good suggestion to include vB's fields in the available field list to include them in groups, but to be honest, if we add this feature it will be add to commercial version and not to free one.

Marina

[ragtek]

i have some uncached templates on editing and adding items:
# editor_clientscript
# (1)editor_css
# (1)editor_jsoptions_font
# (1)editor_jsoptions_size
# (11)editor_smilie
# (1)editor_smiliebox
# (4)editor_smiliebox_row
# (1)editor_smiliebox_straggler
# (1)newpost_disablesmiliesoption

[steadicamop]

That's a good suggestion to include vB's fields in the available field list to include them in groups, but to be honest, if we add this feature it will be add to commercial version and not to free one.

Marina

In all honesty, I've been looking for something exactly like this for a few years - for those extra features, I'd happily pay for the commercial version.

Jason

[vbFreelancers]

In all honesty, I've been looking for something exactly like this for a few years - for those extra features, I'd happily pay for the commercial version.

Jason

There are much more in the commercial version. Give a look at:
https://vborg.vbsupport.ru/showpost.php?p=1418815&postcount=18

[vbFreelancers]

i have some uncached templates on editing and adding items:
# editor_clientscript
# (1)editor_css
# (1)editor_jsoptions_font
# (1)editor_jsoptions_size
# (11)editor_smilie
# (1)editor_smiliebox
# (4)editor_smiliebox_row
# (1)editor_smiliebox_straggler
# (1)newpost_disablesmiliesoption

I've transfered your post by email to Olympic.

[steadicamop]

I have it running well now - just one query, is there any way of adding a break tag after each extra field? There is no gap between each one and it can be tricky to read. Also, when you use a long text box, it doesn't recognise when you press return - you have to use the break tag to start a new line ... is there any way to parse the returns in the long text field?

Jason

[jmar]

Wow! This has high potential. I've looking for something like this for a long time.

When will the commercial license be available?

Johannes

[Olympic]

I have it running well now - just one query, is there any way of adding a break tag after each extra field? There is no gap between each one and it can be tricky to read.
Yes, I've also noticed it testing the demo and of course I'll correct it.

Also, when you use a long text box, it doesn't recognise when you press return - you have to use the break tag to start a new line ... is there any way to parse the returns in the long text field?

Jason

Yes, I'll convert carriage returns to line breaks.

Chris

[Olympic]

Wow! This has high potential. I've looking for something like this for a long time.

When will the commercial license be available?

Johannes

Hopefully at Jan 15th. It's in Beta testing right now.

Chris

[steadicamop]

Yes, I've also noticed it testing the demo and of course I'll correct it.



Yes, I'll convert carriage returns to line breaks.

Chris

Thank you very much, when I buy the commercial version, will the upgrade keep all existing data - so anyone who enters details won't have to re-do all the information again?

Thanks once again,

Jason

[klaush]

Thanks for this stuff!

After installing i got the following error when trying to add a profile:

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 'ORDER BY displayorder' at line 2

Any idea?

Thanks.

[vbFreelancers]

Thanks for this stuff!

After installing i got the following error when trying to add a profile:

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 'ORDER BY displayorder' at line 2

Any idea?

Thanks.

I need the full error message so I can understand where exactly it happen. Display order is using in many tables.

[klaush]

Sorry, here we are:

Invalid SQL:
SELECT id, name FROM vb3_vbfengine_subcategories
WHERE categoryid= ORDER BY displayorder;

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 'ORDER BY displayorder' at line 2
Fehler-Nr. : 1064
Datum : Sunday, January 13th 2008 @ 03:41:11 PM
Skript : http://www.xxxxxx/vbfengine.php?do=edititem
Referrer : http://www.xxxxxx/vbfengine.php
IP-Adresse : 217.xxx.xxx.xx

[vbFreelancers]

WHERE categoryid=

Here is the error. You haven't setup categories.

[klaush]

Arrglll..., that´s it! Thanks!

[Olympic]

Seems, that most of the members didn't understood the hidden power of vbFEngine. Even if the article is for the full version, lite has also many of the features, so please read:
http://www.vbulletinfreelancers.com/showthread.php?t=23

[Defkalion]

I need help from my greek fellows. I've installed the mod, but it has two problems concerning greek characters;

1. It doesn't recognize greek letters or words when searching. Search only works with english words.

2. It truncates the characters at the list display. If for example I have the option to show 100 chars from the description of each 'profile' on my list, it shows much less when they are written in greek.


any help with this? :)

[Defkalion]

Ok I sorted it out, this only happens in VB3.7 (maybe something wrong with the charset in 3.7? who knows)

I have another situation.

In vb3.6.8, when setting a profile as premium, it doesn't chang its background to the selected color.. It simply stays the same background. The profile takes the tag "premium" but it doesn't change the color.

Any ideas? (if it helps, in vb3.7 this works ok - which is rather weird).

[Defkalion]

Anyone encountered any problems regarding this option?

In the default VB template, making an item premium changes the color. In a custom template, the color stays the same.

Anyone?

[dfe]

How will this add/mod be "implicated" once we upgrade to the new v3.7 when it is finally released? Will it be compatible?

[Lott]

Do the extra fields in this Hack work in postbit, and threadbit?
At the moment that is what I need it for, but this is a very powerful tool for other functions.

[TCE Killa]

I get this when trying to add a new profile:

Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT id, name FROM HHRCvbfengine_subcategories
WHERE categoryid= ORDER BY displayorder;

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 'ORDER BY displayorder' at line 2
Error Number : 1064
Date : Friday, February 15th 2008 @ 07:27:45 PM
Script : http://hhglobal.com/forums/vbfengine.php?do=edititem
Referrer : http://hhglobal.com/forums/vbfengine.php
IP Address : 81.154.101.49
Username : TCEKilla
Classname : vb_database

Hope you can help, thanks.

[TCE Killa]

Whoops, sorry, someone else had it to... Working now, thanks alot.

[xony]

Whoops, sorry, someone else had it to... Working now, thanks alot.

[cougar networks]

Great mod with huge potential.

I am trying to set up a business directory. I've set up my categories but I don't see how to set up sub categories?

Where is it?

Matt

[Jah-Hools]

If designing this for business directory use (thats my interest in this + pay per thread classifieds....)

'Country' / State / Town, profile data entry drop down options for user geographic location would be great.

Then a geographic locater - 'nearest to you' search function would be awesome. (international please!, not just USA zip codes!)

A tie in with Google Maps would be the cherry on top!

OK thats my 2c

I have been looking for a business directory software....

Thanks

[stwilson]

Great mod with huge potential.

I am trying to set up a business directory. I've set up my categories but I don't see how to set up sub categories?

Where is it?

Matt

Click on the category link, which should pull up a list of categories. Look for the Actions column on the right side of the screen. Click drop-down, select edit sub-categories.:)

[Jah-Hools]

Desperate for alphabetical order in categories..

[Jah-Hools]

If designing this for business directory use (thats my interest in this + pay per thread classifieds....)

'Country' / State / Town, profile data entry drop down options for user geographic location would be great.

Then a geographic locater - 'nearest to you' search function would be awesome. (international please!, not just USA zip codes!)

A tie in with Google Maps would be the cherry on top!

OK thats my 2c

I have been looking for a business directory software....

Thanks

I think they added this in the paid version just out! :up:

[cougar networks]

Click on the category link, which should pull up a list of categories. Look for the Actions column on the right side of the screen. Click drop-down, select edit sub-categories.:)

Thanks :)