[PAID/FREE/] Personal Collection / Catalogue Database Mod

[zapiy]

hope I explain this correctly:

Some people collect videogamer and systems some collect comics, baseball cards collectable miniatures and I was hoping for a program for the site to be able to track your collections.
The program will be able to be edited by the site owner (admin) as to be able to add catagories (sets) etc.
Members would be able to have one of these that they can edit their collection info (with pictures etc.).

Is there any mod like this already existing? I would even pay for this feature!

Thanks..

Simple Collection was being developed but ended sadly.

[zapiy]

A friendly bump incase its been missed..

[kakdr]

hi all
i am newbie here

somebody please help give me multi quote mods for SMF 2.0.2
thanks

[TheListener]

hi all
i am newbie here

somebody please help give me multi quote mods for SMF 2.0.2
thanks

Please do not intrude on another persons request.

[XHIBIT911]

BUMPITY BUMP BUMP...This sounds like it would have nice potential and is noteworthy. Just a friendly bump to get it from the bottom of the heap

[Motorhed]

I would like this, too. It has limitless uses if done right.

Let people make a collection of anything, and it can apply to Pokemon, MMORPG items, toys, comics, movies they've seen, states they've been to, anythong...

[emanuele]

Yeah, that would be nice...

[zapiy]

Cheers guys, be great if someone would make this please?

[emanuele]

* emanuele hates zapiy, XHIBIT911 and Motorhed!!!

It lacks several things (like a proper pages-handling, columns styling, optimization, code cleanup, sorting, etc.), but that package should allow to create any kind of "collection" with any number of columns and several type of elements...it's still a bit messy but it should work!

[XHIBIT911]

Any demo for this to see what it actually can do ?

[emanuele]

http://www.simplemachines.org/community/index.php?topic=432690.0 (Localhost Webservers)

[Kindred]

Ok, emanuele.... I have a use for this now that someone brought it up...

but where is it?

I installed the mod from the package you attached... but there's no admin option and no member option that I can find...

How does one define or create a collection?

[emanuele]

admin > forum > should be the last option (collections I think).
Then define the "elements", take few elements to create a "collection" and finally populate the collection with your entries...I think, I wrote it few days ago and I forgot how it works...

[Kindred]

there it is... the one spot I apparently didn't look.

OK, I add a collection and some elements...
then click "populate"

Code Select Expand


Wrong value type sent to the database. Integer expected. (current_list)


Should throw a warning that you need to assign elements to a collection, instead.

What is this field?
Page    Chose the page this collections should be displayed
what value should go in there? I assume that this determines how the USERS see the collection?

Any permissions with this?
Any way to let the users enter values into the defined collection?
(i.e. "list of the models I own" for each user)

[emanuele]

OK, I add a collection and some elements...
then click "populate"

Code Select Expand


Wrong value type sent to the database. Integer expected. (current_list)

Should throw a warning that you need to assign elements to a collection, instead.

Can you check the error log?
It seems something I forgot to add to the database...

What is this field?
Page    Chose the page this collections should be displayed
what value should go in there? I assume that this determines how the USERS see the collection?

An integer (it should be 0 by default, but apparently there is a bug...
You can show each "collection" in a different page, or all in one, or any possible combination.

Any permissions with this?
Any way to let the users enter values into the defined collection?
(i.e. "list of the models I own" for each user)

Not yet...I thrown this out just to see if there was interest.
If so I have several other things I'd like to add...and TBH, I was thinking about a rather crazy thing I could do with that code...

[Kindred]

it's actually pretty cool.

I have a use for it on the Legions of Steel website ang the 40Konline website... (miniatures wargames)
If users can enter their data, then we can start having lists of "models owned"

I also have a use for my own to track props...

[emanuele]

The database error is fixed along with the undefined index (page).
I think there is still a bug in the delete (one of the deletes ).

What I'd like to add is:
* a better page-handling (or at least have a drop down with the current existing pages and "new" for example), maybe even allow for a title;
* columns styling, mainly it would be set the width, but I'd like to set classes too (at the moment I still thinking if the best is to associate this to the element or to the collection: the first would make easier to set a value, but it would make it the same for all the collections, the second would mean a bit more work in setting up a new collection...of course I could do both...);
* optimization (some data type are too broad, even though the general design is not exactly performance-oriented...);
* code cleanup (OMG, I hope someone else will help on that! );
* sorting (that will be tough);
* permissions, of course populate a new collection for sure, but it would be nice to have: create_element (public/private?...doesn't make much sense I think, elements should be public), create_collection, edit_collection (own/any), populate_collection (own/any), view-collection (own/any), anything else?);
* another bunch of permissions could be access...very low priority;
* ownership (each collection should belong to the creator, it already prepared, I just have to insert the data in the db);
* a page to list all the available/visible collections (not sure if it is worth a menu entry), and possibly a page in the profile with "own" collections.
A lot of things!... lol

The funny (and maybe educational) thing is that I'm writing this mod using almost only createList, if you note the template file is 5 lines of code and almost no HTML!

[zapiy]

This is a brilliant start, thanks for having ago at this..

Can we add images?

[emanuele]

Not at the moment, maybe later.

[Tony Reid]

Nice idea/mod - just playing with it on a clean install and thought I'd mention some of these...

Code Select Expand


http://localhost/smf202/index.php?action=collections;page=1
2: Invalid argument supplied for foreach()File: /Applications/MAMP/htdocs/smf202/Sources/Subs-List.php
Line: 85


Code Select Expand


http://localhost/smf202/index.php?action=collections;page=1
2: assert() [<a href='function.assert'>function.assert</a>]: Assertion failedFile: /Applications/MAMP/htdocs/smf202/Sources/Subs-List.php
Line: 26

Code Select Expand


http://localhost/smf202/index.php?action=collections;page=0
The database value you're trying to insert does not exist: current_list
Function: list_getCollectionEntriesFile: /Applications/MAMP/htdocs/smf202/Sources/Subs-Collections.php
Line: 967

Code Select Expand


http://localhost/smf202/index.php?action=collections
The database value you're trying to insert does not exist: current_list
Function: list_getCollectionEntriesFile: /Applications/MAMP/htdocs/smf202/Sources/Subs-Collections.php
Line: 967

Hope that helps.

Aside from the admin area - where is the user interface meant to be? in profile?

[emanuele]

Even with the last package I posted?...

* emanuele goes back checking his code...

[Tony Reid]

Yep

[emanuele]

Okay, I think I fixed the errors reported (I better say I hope, I was not able to replicate all of them), and added the possibility to make elements sortable.

ETA: maybe you want the package too?

ETA2: pushed a github repo too at https://github.com/emanuele45/Collections

[Kindred]

oops...

with 0.1.0b,

in SMF Admin >>   Unable to load the 'Collections/Collections' template.

[emanuele]

The commit message says it all
https://github.com/emanuele45/Collections/commit/48a59751005ba8104729739be4555db60688b296

[Kindred]

hmmmm...
Unknown column 'el.is_sortable' in 'field list'
File: /............./Sources/Subs-Collections.php
Line: 991

I am assuming that the addition of the sort did not update the database since the table already existed from a previous installation.

looks like these got added (so, anyone who instal;ed before will have to manually add them)
smf_collections_list > options
smf_collections_elements > is_sortable

[zapiy]

Great work.. Really look forward to the development of this.

[emanuele]

Okay, instead of sorting out bugs in 2.1 I decided to spend a bit of time on that one. (well, I need it for another thing so... )

Don't remember exactly the database changes from the previous version, though for sure I added a column to the table "{db_prefix}collections_elements" named "options" and type text.

New on this:
* reworked a bit the code (still have to change few things because add new options is a bit of a pain);
* added bbc parsing (of course is possible to enable it per-element);
* added a basic heading and column styling.
I think that's all.

ETA: fixed a small piece in the install (I forgot to use of <database> instead of <code>).

[emanuele]

Just a warning (I realised I didn't before and I apologise for that): the code is broken in many ways, do not use it in any live website without being prepared to things messed up (if you are already using it...let me know, I'll try to help you out during any "upgrade").

[emanuele]

Food for testing.

Rewrite on-going, the previous package was broken (badly I think), this one is a bit better but there are still many issues.

Improvements so far...several:
* I started rewriting it using OOP (no differences for the end user, but better for me ),
* database schema changed drastically to fix many issues and avoid some limitations (it may become slow with a lot of data...that's the cost to pay for generalization...),
* added a first step of extensibility for theming (for the moment there is only one alternative theme to the normal list, I'll expand so that will be possible to use multiple themes)...I did that one this evening and not tested it much, so... you know ,
* maybe something else, but I don't remember.

Not yet ready to be used "live", but I'll soon since I need it (and that's also the reason I'm working on it and not on 2.1 ).

ETA: removed, something is wrong...

[zapiy]

Anymore dev on this?

[zapiy]

Ok Sorry for double posting and having a thread locked.. Here is my original request updated with my new request.


I am looking for a modification that allows members to catalogue there game collection. Now this i feel would have many uses from films to calculators. Whatever you collect really.

So i am looking for to pay someone or if your kind enough to do it free i will not complain lol.

So any takers?