Page 5 of 7

Re: [DEV] Reviews System

Posted: Wed Mar 04, 2009 9:39 pm
by enix
Xanta Media, this is a nice mod idea!
we will wait ;)

Re: [DEV] Reviews System

Posted: Sun Mar 08, 2009 2:15 pm
by Neverbirth
I wonder how this MOD was being developed since there are several ways for something like this. I've also made my own reviews system MOD, although it's not standalone, ACP support is still incomplete (missing mainly minor features like language files, cache cleaning, etc), and there are a few things (like checkboxes or lists) that I haven't tested and may not work since I haven't had any need for them so far.

The system is built on top of the Mini Knowledge Base MOD. I may release it when I finish the features left, but with just minor support from my part since it's something I just built for myself and my needs. Also, I'm currently too busy with my job, so it will take, at least, one or two weeks before the release.

Re: [DEV] Reviews System

Posted: Mon Mar 23, 2009 8:16 pm
by rebirth101
Any news about this?
Neverbirth, would you be prepared sharing your version of your reviews system?

Re: [DEV] Reviews System

Posted: Thu Mar 26, 2009 3:30 pm
by Neverbirth
I'm lately utterly busy with a project at job that is taking most of my time, plus I'm gonna be soon father, so that takes some of my spare time as well.

If people here want it I could release what I already have, although it's not production quality at all, and one feature I later added isn't fully working... but of course I'd fix that later on together with all the other main missing things.

I don't how longer will it be before I continue working on this tho, it may even take one month.

Re: [DEV] Reviews System

Posted: Fri Mar 27, 2009 6:59 am
by toomedic
Neverbirth wrote:I'm lately utterly busy with a project at job that is taking most of my time, plus I'm gonna be soon father, so that takes some of my spare time as well.

If people here want it I could release what I already have, although it's not production quality at all, and one feature I later added isn't fully working... but of course I'd fix that later on together with all the other main missing things.

I don't how longer will it be before I continue working on this tho, it may even take one month.
Please do, anyting we can work with and maybe help and give you feedback on! Thanks!

Re: [DEV] Reviews System

Posted: Fri Mar 27, 2009 8:44 am
by Neverbirth
OK, I'll release what I've made so far during this weekend.

Re: [DEV] Reviews System

Posted: Fri Mar 27, 2009 7:18 pm
by rebirth101
Great, and thanks Neverbirth!
And do take your time to enjoy the fact you are becoming a father.
It's a truly wonderfull experience! Congratulations! ;)

Re: [DEV] Reviews System

Posted: Sat Mar 28, 2009 8:38 pm
by Neverbirth
Well... here you have what I made so far. Note several things:
  • As I said it is not production quality, so a lot of things are missing for making it a proper release: installer, it uses phpbb_ as the prefix of databases, etc.
  • As I said there are several ways for making a dynamic reviews form system, some may like the way I did it and others may not. Well, I made it this way because it is what I wanted and needed, so... :P.
  • I'm not a web programmer (and actually, I don't like it, I prefer RIA and desktop development), so there may be things that aren't as good as they could (for example, I use the same id for all the divs containing editors, I should have made my own style for them, but I haven't had time for it). Help is always welcome.
  • Also, as I said, this isn't a standalone MOD, it uses the Mini Knowledge Base.
The following things are missing or incomplete:
  • ACP support:
    • I haven't had time for adding any language file...
    • There are no specific checks for errors or mandatory fields (since I know what to add... XD)
    • Choosing the fields parent isn't well done, I used two list boxes because it was developed faster this way, so if you select some field as the parent be sure to choose its corresponding category as well. This is one of the first things I wanted to change, but I couldn't touch the MOD for weeks.
    • Once you've selected the parent for some category or field, you can't change it. The code for this is another thing I wanted to add.
    • The template editor is missing the special codes for inserting data.
    • The overview sections is completely missing.
    • When adding or editing most things, the corresponding cache isn't cleared.
  • Forms:
    • The field list feature isn't fully working.
Things that may not work or aren't as good as they could be heh:
  • As I said, I haven't tested lists and checkboxes, I don't know if they'll work.
  • Date fields are worthless... I wanted to add some datepicker, but I don't know which ones can perfectly fit into the system.
  • Numeric fields work as expected, but they are just simple input textboxes, I'd have loved to use some nice updown control (or numeric stepper, whatever you name it), but the only one I found that looked good didn't fit very well and gave some alignment problems.
Install instructions:
  • Insert the SQL provided.
  • Uncompress the attached files into the phpBB root folder.
  • Go to the ACP MOD area, and add the review forms modules into the Mini KB area.
That's all, no edits needed...

SQL statements:

Code: Select all

CREATE TABLE `phpbb_review_datasources` (
  `source_id` mediumint(8) unsigned NOT NULL auto_increment,
  `source_name` varchar(255) collate utf8_bin NOT NULL,
  `source_texts` text collate utf8_bin NOT NULL,
  `source_values` varchar(255) collate utf8_bin NOT NULL,
  PRIMARY KEY  (`source_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

CREATE TABLE `phpbb_review_fields` (
  `field_id` mediumint(8) unsigned NOT NULL auto_increment,
  `section_id` mediumint(8) unsigned NOT NULL,
  `field_type` tinyint(4) unsigned NOT NULL default '0',
  `field_parent_id` mediumint(8) unsigned NOT NULL default '0',
  `left_id` mediumint(8) unsigned NOT NULL,
  `right_id` mediumint(8) unsigned NOT NULL,
  `field_name` varchar(255) collate utf8_bin NOT NULL,
  `field_header` varchar(255) collate utf8_bin NOT NULL,
  `field_desc` varchar(255) collate utf8_bin NOT NULL,
  `field_sufix` varchar(255) collate utf8_bin NOT NULL,
  `field_datatype` tinyint(4) unsigned NOT NULL default '0',
  `field_defaultdata` varchar(255) collate utf8_bin NOT NULL default '',
  `field_mandatory` tinyint(1) unsigned NOT NULL default '1',
  `field_islist` tinyint(1) unsigned NOT NULL default '0',
  `field_listlimit` smallint(4) unsigned NOT NULL default '0',
  `source_id` mediumint(8) unsigned NOT NULL default '0',
  `field_width` smallint(4) unsigned NOT NULL default '0',
  `field_height` smallint(4) unsigned NOT NULL default '0',
  `field_maxlength` smallint(4) unsigned NOT NULL default '0',
  `field_minvalue` smallint(4) NOT NULL default '0',
  `field_maxvalue` smallint(4) NOT NULL default '0',
  `file_id` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`field_id`),
  KEY `section_id` (`section_id`),
  KEY `left_right_id` (`left_id`,`right_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE `phpbb_review_files` (
  `file_id` mediumint(8) unsigned NOT NULL auto_increment,
  `file_name` varchar(255) collate utf8_bin NOT NULL,
  `file_extensions` varchar(255) collate utf8_bin NOT NULL,
  `file_isimage` tinyint(1) unsigned NOT NULL default '0',
  `file_minwidth` smallint(4) unsigned NOT NULL default '0',
  `file_minheight` int(4) unsigned NOT NULL default '0',
  `file_maxwidth` int(4) unsigned NOT NULL default '0',
  `file_maxheight` int(4) unsigned NOT NULL default '0',
  `file_maxsize` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`file_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE `phpbb_review_forms` (
  `form_id` mediumint(8) NOT NULL auto_increment,
  `group_id` mediumint(8) unsigned NOT NULL,
  `left_id` mediumint(8) unsigned NOT NULL,
  `right_id` mediumint(8) unsigned NOT NULL,
  `form_name` varchar(255) collate utf8_bin NOT NULL,
  `form_desc` varchar(255) collate utf8_bin NOT NULL default '',
  PRIMARY KEY  (`form_id`),
  KEY `group_id` (`group_id`),
  KEY `left_right_id` (`left_id`,`right_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

CREATE TABLE `phpbb_review_sections` (
  `section_id` mediumint(8) unsigned NOT NULL auto_increment,
  `form_id` mediumint(8) unsigned NOT NULL default '0',
  `left_id` mediumint(8) unsigned NOT NULL,
  `right_id` mediumint(8) unsigned NOT NULL,
  `section_title` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL,
  `section_titletype` tinyint(4) unsigned NOT NULL default '3',
  `section_fieldset_style` tinyint(4) unsigned NOT NULL default '0',
  `section_column_number` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`section_id`),
  KEY `form_id` (`form_id`),
  KEY `left_right_id` (`left_id`,`right_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

CREATE TABLE `phpbb_review_templates` (
  `template_id` mediumint(8) unsigned NOT NULL auto_increment,
  `form_id` mediumint(8) unsigned NOT NULL,
  `article_title` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL,
  `article_desc` text character set utf8 collate utf8_unicode_ci NOT NULL,
  `article_category` varchar(255) collate utf8_bin NOT NULL,
  `article_type` varchar(255) collate utf8_bin NOT NULL,
  `template_text` mediumtext collate utf8_bin NOT NULL,
  PRIMARY KEY  (`template_id`),
  UNIQUE KEY `form_id` (`form_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
Needed files:

-

Well, here you have. I'm sorry, but I don't have enough time for explaining everything from the MOD, if you have any question feel free to ask. I'll try to write later or tomorrow about the special commands, aside from standard BBCode, recognized by the templating system.

Hope you like it, if not, well, bad luck, move ahead :P.

EDIT: Removed download link. Outdated version with some bugs.

Re: [DEV] Reviews System

Posted: Sun Mar 29, 2009 4:19 pm
by Neverbirth
The templating system of the MOD has language support. In order to use you just have to use {L_xxx} and the corresponding variable defined in the reviews.php language file.

Special tags that can be used in the templating system:
  • [upper]text[/upper]: Makes text uppercase.
  • {S_USERNAME}: Adds the name of the user that posted the review.
  • [field=x]text[/field]: Adds the corresponding text when field with id x has data.
  • {F_VALUE}: Adds the field inserted data. Used inside the [field=x][/field] tag.
  • {F_TEXT}: Adds the field text when used with checkboxes, lists, combos and radio buttons, and the file original name with file inputs. Used inside the [field=x][/field] tag.
Tags used for field lists (they are used inside the [field=x][/field] tag, excluding the last one):
  • [list_start]text[/list_start]: Used to define the header of a list.
  • [list_*]text[/list_*]: Used to add text for each field in the field list.
  • [list_end]text[/list_end]: Used to define the foot of a list.
  • [list_item=x]text[/list_item]: Used to retrieve just some item of a field list.
  • [list_separator]text[/list_separator]: Defines a separator to use on all items, excluding the last one.
  • [field_group=x]text[/field_group]: Used when you set a field group as a list.
Some examples:

Themplates:
Ex1:

Code: Select all

Overview:
[field=1]{F_VALUE}[/field]
Ex2:

Code: Select all

[field=2]Characters in the movie:
[list][list_*][*]{F_VALUE}[/list_*][/list][/field]
Ex3:

Code: Select all

[field_group=3][field=4]Friend's name: {F_VALUE}[/field]
[field=5]Friend's Phone Numbers:
[list][list_*][*]{F_VALUE}[/list_*][/list][/field][/field_group]
Outputs:
Ex1:
Overview:
Intro of the item reviewed
Ex2:
Characters in the movie:
  • Char 1
  • Char 2
  • Char 3
Ex3:
Friend's name: Friend 1
Friend's Phone Numbers:
  • Phone
Friend's name: Friend 2
Friend's Phone Numbers:
  • Phone 1
  • Phone 2
Friend's name: Friend 3
Friend's Phone Numbers:
When I added the list_start and list_end items they made some sense, although I'm not sure if they are actually worth it right now... Also, note that lists aren't fully working... I just had time to add some quick code and it doesn't work on all field types. I wanted to finish it asap, but haven't had time.

EDIT: Forgot to say that language variables are supported on any review part. And the special tags are supported on any template field (template body, title, review type and review category).

Re: [DEV] Reviews System

Posted: Wed Apr 01, 2009 4:38 am
by toomedic
Thanks for the info... I couldn't download from that location, it says it is unavailable.

Re: [DEV] Reviews System

Posted: Wed Apr 01, 2009 6:19 pm
by zake black
Is this one dead in the water???

Re: [DEV] Reviews System

Posted: Wed Apr 01, 2009 10:18 pm
by Neverbirth
toomedic wrote:Thanks for the info... I couldn't download from that location, it says it is unavailable.
No problem at my home PC, nor my job one, MegaUpload may be banning your IP range, dunno. If nobody can upload it to somewhere else I'll do it tomorrow or past tomorrow.

Re: [DEV] Reviews System

Posted: Fri Apr 03, 2009 7:58 pm
by Neverbirth
Uploaded the file to another site. Get it from here.

EDIT: Removed download link. Outdated version with some bugs.

Re: [DEV] Reviews System

Posted: Fri Apr 10, 2009 7:41 pm
by Neverbirth
I found a 'bug' today so fixed it, and then realized the files I uploaded weren't the newest ones, and were from a test version with some serious bugs. Anyway, since the feedback has been null I guess nobody liked the MOD.

Re: [DEV] Reviews System

Posted: Sat Apr 11, 2009 11:42 pm
by zake black
Do you have a demo or screenies? plz