Custom fields and filters of post

[davidhs]

I was not getting uninstall.

I uninstall the "Enhancements to recent posts" and then went uninstall the Custom fields and filters of post and functioned normally.

This is a problem of SMF mods in SMF 2.0.x

All my mods adds a line in copyright section (Sources/Who.php) and must be uninstalled in reverse order than they was installed... or, if you know PHP you can edit this file and to move this line at beginning of copyright section.

[moyack]

Hi:

I'm still using this mod and I have a lot of faith with it. Now I'm working with a simple thing that is used as a thread categorization item, like a kind of tag. I'm using a combo boz where users can select the status of a thread, like assigned, confirmed, approved, finished and closed.

I've applied the example from the first post of this topic with "fields with several values per member" and I only placed a field with a combo box.

The issue is that when I select an option and I confirm, it doesn't work. it doesn't set the option at all. I'm pretty sure I missed something but I don't know which option is the cause of the failure.

Any help will be really appreciated. Thanks.

[davidhs]

Hi:

I'm still using this mod and I have a lot of faith with it. Now I'm working with a simple thing that is used as a thread categorization item, like a kind of tag. I'm using a combo boz where users can select the status of a thread, like assigned, confirmed, approved, finished and closed.

I've applied the example from the first post of this topic with "fields with several values per member" and I only placed a field with a combo box.

The issue is that when I select an option and I confirm, it doesn't work. it doesn't set the option at all. I'm pretty sure I missed something but I don't know which option is the cause of the failure.

Any help will be really appreciated. Thanks.

I think you want the owner of a thread/topic (or moderator/admin; but not any user) sets the status of him topic. Correct?

You need a group of fields type "fields loose". In a group type "fields with several values per member" several members can insert different values (this can be used for insert comments, opinions....)

This group of field contain only one field, named "Status", a list box with options (assigned, confirmed, approved, finished, closed). If these are all values, the list box must be type "select box". A "combo box" is a "select box" + "text box" and users can select an option of select box or write a new option in text box.

Can be, a topic, to have status without value? If not, select "Not empty value" in field settings.

About the group, unselect "Show on the replies of topic" (only must be seen on first post).

About permissions of group and field:
- View: all
- Modify: owner, moderators, admin.
- Filter: all (if you want filter topics by status).
- Search: all (if you want search topics by status).

[moyack]

Hi:

I'm still using this mod and I have a lot of faith with it. Now I'm working with a simple thing that is used as a thread categorization item, like a kind of tag. I'm using a combo boz where users can select the status of a thread, like assigned, confirmed, approved, finished and closed.

I've applied the example from the first post of this topic with "fields with several values per member" and I only placed a field with a combo box.

The issue is that when I select an option and I confirm, it doesn't work. it doesn't set the option at all. I'm pretty sure I missed something but I don't know which option is the cause of the failure.

Any help will be really appreciated. Thanks.

I think you want the owner of a thread/topic (or moderator/admin; but not any user) sets the status of him topic. Correct?

You need a group of fields type "fields loose". In a group type "fields with several values per member" several members can insert different values (this can be used for insert comments, opinions....)

This group of field contain only one field, named "Status", a list box with options (assigned, confirmed, approved, finished, closed). If these are all values, the list box must be type "select box". A "combo box" is a "select box" + "text box" and users can select an option of select box or write a new option in text box.

Can be, a topic, to have status without value? If not, select "Not empty value" in field settings.

About the group, unselect "Show on the replies of topic" (only must be seen on first post).

About permissions of group and field:
- View: all
- Modify: owner, moderators, admin.
- Filter: all (if you want filter topics by status).
- Search: all (if you want search topics by status).

My apologies for a veeeerrry late answer, but I want to let you know that your suggestion served me pretty well. I've done a lot of make up using the template feature and now I can show the post in the message index nicely.

Just one question: I've added a rate system. one thing I've noticed is that the first rate should be done twice in order to register the score properly. And second, if I try to apply a template, it doesn't show in the message index. Is the template feature disabled for the group "Fields with several values per member"?

again, thanks for this mod and big HUGS!!!

[davidhs]

Just one question: I've added a rate system. one thing I've noticed is that the first rate should be done twice in order to register the score properly.

In my test forum this works. When I submit a rate, this is registered.    Can you tell me your steps with images?

And second, if I try to apply a template, it doesn't show in the message index. Is the template feature disabled for the group "Fields with several values per member"?

Template works with this type of group (in message and in the message index).

If you has defined a template in the message index you must use tags in order to insert statistical data (you can see these tags in help button of the field template) but template must be written in PHP code.

In PHP you can also use the following functions:

• {SHOW_GROUP_MSG}(message_ID, group_ID) - Displays the group of a message like in a message.
• {SHOW_GROUP_MSGINDEX}(message_ID, group_ID) - Displays the group of a message like on the message index.
• {SHOW_GROUP_MSG_STATS}(message_ID, group_ID, 'type', 'params') - Displays the statistics for the group of a message (if are activated). The parameter type can be:
  
  
  
  • chart_average - Displays the chart with average. The parameter params indicates chart characteristics. Permitted values: average (shown average value), minmax (shown lowest and highest allowed value), options_text (shown the text of options).
  • chart_hbars - Displays the chart with horizontal bars. The parameter params is not used.
  • chart_vbars - Displays the chart with vertical bars. The parameter params indicates chart characteristics. Permitted values: options_text (shown the text of options).
  • summary - Displays the summary. The parameter params indicates values to display, comma separated. Permitted values: average (average value), max (highest allowed value), min (lowest allowed value), highest (highest used value), lowest (lowest used value), most_frequent (most frequent value), least_frequent (least frequent value), total (total).
  • value - Displays a value of the summary. The parameter params indicates value to display. Permitted values: average (average value), max (highest allowed value), min (lowest allowed value), highest (highest used value), lowest (lowest used value), most_frequent (most frequent value), least_frequent (least frequent value), total (total).

For example, if group ID is 13 and you write this on template:

Code Select Expand

echo 'AVERAGE CHART';
{SHOW_GROUP_MSG_STATS}({ID_MSG}, 13, 'chart_average');
echo 'AVERAGE VALUE = ';
{SHOW_GROUP_MSG_STATS}({ID_MSG}, 13, 'value', 'average');
You see average chart and value.

But this is displayed instead of user rates (if you see various user rate, you will see average data repeated).

Really, I added these function for be used in others groups of fields. For example you have a group of fields "hero of video game" with fields image, type and category. In its template of the index message you wrote some like this:

Code Select Expand

<table><tr>
<td style="width: 100px;"><a href="..."> image </a></td>
<td><strong>Model Type:</strong> type<br>
<strong>Model Category:</strong> category</td>
</tr></table>

You can add here statistical data functions.

[moyack]

In my test forum this works. When I submit a rate, this is registered.    Can you tell me your steps with images?

Sure, here it is:
1. I've created a new topic, in this case is a resource model. I've set some fields so it can describe the topic properly.


    Edit mode...


2. Before the updates to the custom fields, I had to set twice the value in order to get it registered and visible, now when I select into the rating the option in the select box, it doesn't update the score, I've tried many times and in fact it's storing the ratings, but not the value. Check image below



3. Here's the configuration of these fields...

Template works with this type of group (in message and in the message index).

If you has defined a template in the message index you must use tags in order to insert statistical data (you can see these tags in help button of the field template) but template must be written in PHP code.

In PHP you can also use the following functions:

• {SHOW_GROUP_MSG}(message_ID, group_ID) - Displays the group of a message like in a message.
• {SHOW_GROUP_MSGINDEX}(message_ID, group_ID) - Displays the group of a message like on the message index.
• {SHOW_GROUP_MSG_STATS}(message_ID, group_ID, 'type', 'params') - Displays the statistics for the group of a message (if are activated). The parameter type can be:
  
  
  
  • chart_average - Displays the chart with average. The parameter params indicates chart characteristics. Permitted values: average (shown average value), minmax (shown lowest and highest allowed value), options_text (shown the text of options).
  • chart_hbars - Displays the chart with horizontal bars. The parameter params is not used.
  • chart_vbars - Displays the chart with vertical bars. The parameter params indicates chart characteristics. Permitted values: options_text (shown the text of options).
  • summary - Displays the summary. The parameter params indicates values to display, comma separated. Permitted values: average (average value), max (highest allowed value), min (lowest allowed value), highest (highest used value), lowest (lowest used value), most_frequent (most frequent value), least_frequent (least frequent value), total (total).
  • value - Displays a value of the summary. The parameter params indicates value to display. Permitted values: average (average value), max (highest allowed value), min (lowest allowed value), highest (highest used value), lowest (lowest used value), most_frequent (most frequent value), least_frequent (least frequent value), total (total).

For example, if group ID is 13 and you write this on template:

Code Select Expand

echo 'AVERAGE CHART';
{SHOW_GROUP_MSG_STATS}({ID_MSG}, 13, 'chart_average');
echo 'AVERAGE VALUE = ';
{SHOW_GROUP_MSG_STATS}({ID_MSG}, 13, 'value', 'average');
You see average chart and value.

But this is displayed instead of user rates (if you see various user rate, you will see average data repeated).

Really, I added these function for be used in others groups of fields. For example you have a group of fields "hero of video game" with fields image, type and category. In its template of the index message you wrote some like this:

Code Select Expand

<table><tr>
<td style="width: 100px;"><a href="..."> image </a></td>
<td><strong>Model Type:</strong> type<br>
<strong>Model Category:</strong> category</td>
</tr></table>

You can add here statistical data functions.

AHHHHH!!! I seeeeeeeeee!!!!! you don't have to put the <php? /?> tags....

That solved my issue, now as you can see, I've been able to inject the average into the field. It really looks nice. THANKS FOR THE ADVICE!!!!


Just one question: it's possible to get in the ratings the numerical values, this in order to do some calculation in php with the values (like showing stars for ratings instead a number)... thanks.

[davidhs]

In my test forum this works. When I submit a rate, this is registered.    Can you tell me your steps with images?

Sure, here it is:
1. I've created a new topic, in this case is a resource model. I've set some fields so it can describe the topic properly.
    Edit mode...
2. Before the updates to the custom fields, I had to set twice the value in order to get it registered and visible, now when I select into the rating the option in the select box, it doesn't update the score, I've tried many times and in fact it's storing the ratings, but not the value. Check image below
3. Here's the configuration of these fields...

Sorry, I do not see any mistake
I can login in your forum and test this... Can you create a test user in your forum and send login/password by PM?

Some comments:

1. In group WC3 Models, field Keywords is a text button. User can write here keywords comma separated, but he can write

Code Select Expand

undead, knight, demon
or a mistake

Code Select Expand

unndead, knight, demon

You can define this field as a combo box with multiple selections.

2. In group Rating, field Score is a select box button with options 1, 2, 3, 4, 5 (only numbers, without text).

Code Select Expand

( ) 1_______________ Text  _________________________
( ) 2_______________ Text  _________________________
( ) 3_______________ Text  _________________________
( ) 4_______________ Text  _________________________
( ) 5_______________ Text  _________________________
You can write on fields text of each option this

Code Select Expand

( ) 1_______________ Text  Bad resource
( ) 2_______________ Text  Below average resource
( ) 3_______________ Text  Average resource
( ) 4_______________ Text  Bad resource
( ) 5_______________ Text  Excellent or very useful resource
or

Code Select Expand

( ) 1_______________ Text  1 - Bad resource
( ) 2_______________ Text  2 - Below average resource
( ) 3_______________ Text  3 - Average resource
( ) 4_______________ Text  4 - Bad resource
( ) 5_______________ Text  5 - Excellent or very useful resource
And then users view a select box with these text instead of numbers.

3. In group Rating, field Score, templates text are

Code Select Expand

<div></div>
I do not undestand why you wrote this. Templates can be empty.

Template works with this type of group (in message and in the message index).

If you has defined a template in the message index you must use tags in order to insert statistical data (you can see these tags in help button of the field template) but template must be written in PHP code.

In PHP you can also use the following functions:

• {SHOW_GROUP_MSG}(message_ID, group_ID) - Displays the group of a message like in a message.
• {SHOW_GROUP_MSGINDEX}(message_ID, group_ID) - Displays the group of a message like on the message index.
• {SHOW_GROUP_MSG_STATS}(message_ID, group_ID, 'type', 'params') - Displays the statistics for the group of a message (if are activated). The parameter type can be:
  
  
  
  • chart_average - Displays the chart with average. The parameter params indicates chart characteristics. Permitted values: average (shown average value), minmax (shown lowest and highest allowed value), options_text (shown the text of options).
  • chart_hbars - Displays the chart with horizontal bars. The parameter params is not used.
  • chart_vbars - Displays the chart with vertical bars. The parameter params indicates chart characteristics. Permitted values: options_text (shown the text of options).
  • summary - Displays the summary. The parameter params indicates values to display, comma separated. Permitted values: average (average value), max (highest allowed value), min (lowest allowed value), highest (highest used value), lowest (lowest used value), most_frequent (most frequent value), least_frequent (least frequent value), total (total).
  • value - Displays a value of the summary. The parameter params indicates value to display. Permitted values: average (average value), max (highest allowed value), min (lowest allowed value), highest (highest used value), lowest (lowest used value), most_frequent (most frequent value), least_frequent (least frequent value), total (total).

For example, if group ID is 13 and you write this on template:

Code Select Expand

echo 'AVERAGE CHART';
{SHOW_GROUP_MSG_STATS}({ID_MSG}, 13, 'chart_average');
echo 'AVERAGE VALUE = ';
{SHOW_GROUP_MSG_STATS}({ID_MSG}, 13, 'value', 'average');
You see average chart and value.

But this is displayed instead of user rates (if you see various user rate, you will see average data repeated).

Really, I added these function for be used in others groups of fields. For example you have a group of fields "hero of video game" with fields image, type and category. In its template of the index message you wrote some like this:

Code Select Expand

<table><tr>
<td style="width: 100px;"><a href="..."> image </a></td>
<td><strong>Model Type:</strong> type<br>
<strong>Model Category:</strong> category</td>
</tr></table>

You can add here statistical data functions.

AHHHHH!!! I seeeeeeeeee!!!!! you don't have to put the <php? /?> tags....

If template type is PHP you can put <php? /?> tags or not.
If template type is not PHP and you put <php? /?> tags, system do not read this as PHP, else HTML or BBC (as template type field)

Just one question: it's possible to get in the ratings the numerical values, this in order to do some calculation in php with the values (like showing stars for ratings instead a number)... thanks.

Yes

In templates of the message index you can use this function in order to insert average value:

Code Select Expand

{SHOW_GROUP_MSG_STATS}(ID_MSG, ID_GROUP, 'value', 'average');

Now, you want get this value (not display) and display stars instead of number. You can use PHP function for this: ob_start(), ob_get_contents() and ob_end_clean().
PHP code can be

Code Select Expand

<?php

$id_group = 5; // ID of your group with statistical data.

// Display average value.
echo '<br />Average value = ';
{SHOW_GROUP_MSG_STATS}({ID_MSG}, $id_group, 'value', 'average');

// Saves average value in $avg var.
ob_start();
{SHOW_GROUP_MSG_STATS}({ID_MSG}, $id_group, 'value', 'average');
$avg = ob_get_contents();
ob_end_clean();

// Display stars.
$img_star = '<img src="..." alt="*" />';
echo '<br />Average with stars = ', $avg, ' = ';
for ($i = 0; $i < $avg; $i++)
echo $img_star;

echo '<br />';

?>

[moyack]

The issue with the group field of type "fields with several values per member" that it was not registering the values submitted by the users was already solved. It was caused by the conflict with a SEF mod which rewrites the standard URLs with nice ones. In my case I use in my forum Search Engine Friendly URL (SEF) Manager from PortaMX and the solution was to add in the "actions to be ignored" field this ones: cffpeditgroup and cffpsearch.

Just for the record. And thanks to Davidhs for his great support in finding the issue. BIG HUGS!!!

[moyack]

Hi again:

I've been tinkering with this mod and I'm enjoying how well the customization is evolving. Right now I has some small questions about some related things about this mod:

The custom fields work perfectly, but now I want to show them into custom blocks in my portal. right now I have in my site at the homepage custom blocks that shows the post content from some boards with custom fields, but I want to add the fields with the template designed for each of them. I've seen this functions in display.template.php called

cffpLoad

, but I'm not sure how to use it. An example could come handy to get the idea about how it works.

Thanks

[davidhs]

The custom fields work perfectly, but now I want to show them into custom blocks in my portal. right now I have in my site at the homepage custom blocks that shows the post content from some boards with custom fields, but I want to add the fields with the template designed for each of them. I've seen this functions in display.template.php called

cffpLoad

, but I'm not sure how to use it. An example could come handy to get the idea about how it works.

I an out from home and now I can not write code.

My mod have not functions for display groups of fields in blocks of portal. cffpLoad is a private function.

But you can create a block of PHP code (if your portal have this) and use tags/functions {...}(id_group, id_msg,...) in order to display templates.

[vjones]

The error I get is:

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 'FROM smf_cffp_settings_groups
WHERE active = 1
ORDER BY group_order ASC' at line 2
File: C:\inetpub\wwwroot\simple_machines_forum\Sources\Themes-CustomFieldFilterPost.php
Line: 43

it looks like database_2.0.php isn't getting run on install

[davidhs]

The error I get is:

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 'FROM smf_cffp_settings_groups
WHERE active = 1
ORDER BY group_order ASC' at line 2
File: C:\inetpub\wwwroot\simple_machines_forum\Sources\Themes-CustomFieldFilterPost.php
Line: 43

it looks like database_2.0.php isn't getting run on install

Are you install the last version of this mod?

Sorry, I do not know why you have this error...
Can you attach here your file C:\inetpub\wwwroot\simple_machines_forum\Sources\Themes-CustomFieldFilterPost.php ?
Can you see the schema of table smf_cffp_settings_groups? What are its columns?

[vjones]

I am installing the most recent version using the package manager built in the SMF. My install process was to input the url to download ( http://custom.simplemachines.org/mods/index.php?action=download;mod=3818;id=245288 ) and the name of the mod ( Custom fields and filters of post ) and then I get MySql errors. Additionally I have not been able to find a way to this plugin in the browse section of the package manager. I was able to find the plugin, but download was not an option.

The error I get is:

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 'FROM smf_cffp_settings_groups
WHERE active = 1
ORDER BY group_order ASC' at line 2
File: C:\inetpub\wwwroot\simple_machines_forum\Sources\Themes-CustomFieldFilterPost.php
Line: 43

it looks like database_2.0.php isn't getting run on install

Are you install the last version of this mod?

Sorry, I do not know why you have this error...
Can you attach here your file C:\inetpub\wwwroot\simple_machines_forum\Sources\Themes-CustomFieldFilterPost.php ?
Can you see the schema of table smf_cffp_settings_groups? What are its columns?

[davidhs]

The error I get is:

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 'FROM smf_cffp_settings_groups
WHERE active = 1
ORDER BY group_order ASC' at line 2
File: C:\inetpub\wwwroot\simple_machines_forum\Sources\Themes-CustomFieldFilterPost.php
Line: 43

it looks like database_2.0.php isn't getting run on install

Are you install the last version of this mod?

Sorry, I do not know why you have this error...
Can you attach here your file C:\inetpub\wwwroot\simple_machines_forum\Sources\Themes-CustomFieldFilterPost.php ?
Can you see the schema of table smf_cffp_settings_groups? What are its columns?

I am installing the most recent version using the package manager built in the SMF. My install process was to input the url to download ( http://custom.simplemachines.org/mods/index.php?action=download;mod=3818;id=245288 ) and the name of the mod ( Custom fields and filters of post ) and then I get MySql errors. Additionally I have not been able to find a way to this plugin in the browse section of the package manager. I was able to find the plugin, but download was not an option.

If you have MySQL errrors during install process... perhaps you have an error in your forum... I do not know...

You can try search my mod with your forum:
1. Go to package section of your forum (Administration Center > Package Manager > Download Packages > Download New Packages > Package server):
2. Clic on [ Browse ] of server "Simple Machines Third-party Mod Site".
3. Clic on  New Feature > View the 2xx mods in this section.
4. Search my mod, Custom fields and filters of post, and clic on [ Download ].
5. This copy my mod on your server. Clic on install.

This process can fail because are many mods.

You can try download from SMF site, upload to your forum and install:
1. Visit download page http://custom.simplemachines.org/mods/index.php?action=download;mod=3818;id=245288 in your explorer/navigator.
2. Clic on CustomFieldFilterPost_1.4.tar.gz and download to your disk.
3. Go to package section of your forum (Administration Center > Package Manager > Download Packages > Upload a Package).
4. Upload file CustomFieldFilterPost_1.4.tar.gz
5. Install mod if there are not errors.

I hope you can install my mod without errors!

[vjones]

The error I get is:

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 'FROM smf_cffp_settings_groups
WHERE active = 1
ORDER BY group_order ASC' at line 2
File: C:\inetpub\wwwroot\simple_machines_forum\Sources\Themes-CustomFieldFilterPost.php
Line: 43

it looks like database_2.0.php isn't getting run on install

Are you install the last version of this mod?

Sorry, I do not know why you have this error...
Can you attach here your file C:\inetpub\wwwroot\simple_machines_forum\Sources\Themes-CustomFieldFilterPost.php ?
Can you see the schema of table smf_cffp_settings_groups? What are its columns?

I am installing the most recent version using the package manager built in the SMF. My install process was to input the url to download ( http://custom.simplemachines.org/mods/index.php?action=download;mod=3818;id=245288 ) and the name of the mod ( Custom fields and filters of post ) and then I get MySql errors. Additionally I have not been able to find a way to this plugin in the browse section of the package manager. I was able to find the plugin, but download was not an option.

If you have MySQL errrors during install process... perhaps you have an error in your forum... I do not know...

You can try search my mod with your forum:
1. Go to package section of your forum (Administration Center > Package Manager > Download Packages > Download New Packages > Package server):
2. Clic on [ Browse ] of server "Simple Machines Third-party Mod Site".
3. Clic on  New Feature > View the 2xx mods in this section.
4. Search my mod, Custom fields and filters of post, and clic on [ Download ].
5. This copy my mod on your server. Clic on install.

This process can fail because are many mods.

You can try download from SMF site, upload to your forum and install:
1. Visit download page http://custom.simplemachines.org/mods/index.php?action=download;mod=3818;id=245288 in your explorer/navigator.
2. Clic on CustomFieldFilterPost_1.4.tar.gz and download to your disk.
3. Go to package section of your forum (Administration Center > Package Manager > Download Packages > Upload a Package).
4. Upload file CustomFieldFilterPost_1.4.tar.gz
5. Install mod if there are not errors.

I hope you can install my mod without errors!

I'll see what I can do. For reference I am working off of a fresh install of SMF no other mods are installed and no Topics or Posts have been written yet. A couple of users have been created but thats it.

[davidhs]

Compatible with SMF 2.0.12.

[aegersz]

what an amazing mod !

[davidhs]

Compatible with SMF 2.0.13.

[Americano]

Hello
I have a question.

A member of my forum, posted a message, but forgot to post the custom field. After a message has been posted, as a rule, only the moderator or administrator can post the custom field for that member in the same message, but this custom field is not computed for the member and, yes, for which he launched the custom field, in the case the moderator or administrator.

How do I make the custom field be computed to whoever posted the message?

[davidhs]

How do I make the custom field be computed to whoever posted the message?

You can add one permission to this group of fields: Owner of post (or Owner of group, if group type is "Fields with several values per member") --> Modify