Simple Machines Community Forum

Customizing SMF => Modifications and Packages => Mod Requests => Topic started by: zapiy on February 25, 2012, 03:02:26 PM

Title: [PAID/FREE/] Personal Collection / Catalogue Database Mod
Post by: zapiy on February 25, 2012, 03:02:26 PM
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.
Title: Re: My Collection Mod
Post by: zapiy on February 27, 2012, 08:55:03 AM
A friendly bump incase its been missed..
Title: Re: My Collection Mod
Post by: kakdr on February 27, 2012, 09:49:27 AM
hi all :)
i am newbie here ;D

somebody please help give me multi quote mods for SMF 2.0.2
thanks
Title: Re: My Collection Mod
Post by: TheListener on February 27, 2012, 01:38:57 PM
Quote from: kakdr on February 27, 2012, 09:49:27 AM
hi all :)
i am newbie here ;D

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

Please do not intrude on another persons request.

Title: Re: My Collection Mod
Post by: XHIBIT911 on April 20, 2012, 08:14:34 AM
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
Title: Re: My Collection Mod
Post by: Motorhed on April 22, 2012, 09:03:25 PM
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...
Title: Re: My Collection Mod
Post by: emanuele on April 23, 2012, 06:04:54 AM
Yeah, that would be nice...
Title: Re: My Collection Mod
Post by: zapiy on September 06, 2012, 02:41:39 PM
Cheers guys, be great if someone would make this please?
Title: Re: My Collection Mod
Post by: emanuele on September 09, 2012, 11:52:39 AM
/me hates zapiy, XHIBIT911 and Motorhed!!! :P

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!
Title: Re: My Collection Mod
Post by: XHIBIT911 on September 12, 2012, 06:56:28 PM
Any demo for this to see what it actually can do ?
Title: Re: My Collection Mod
Post by: emanuele on September 13, 2012, 04:11:00 AM
http://www.simplemachines.org/community/index.php?topic=432690.0 (Localhost Webservers)
Title: Re: My Collection Mod
Post by: Kindred on September 14, 2012, 11:16:38 AM
Ok, emanuele.... I have a use for this now that someone brought it up...

but where is it? :P

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?
Title: Re: My Collection Mod
Post by: emanuele on September 14, 2012, 12:12:01 PM
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... :P
Title: Re: My Collection Mod
Post by: Kindred on September 14, 2012, 12:46:47 PM
there it is... the one spot I apparently didn't look.

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

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)

:)
Title: Re: My Collection Mod
Post by: emanuele on September 14, 2012, 01:32:30 PM
Quote from: Kindred on September 14, 2012, 12:46:47 PM
OK, I add a collection and some elements...
then click "populate"

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... ::)

Quote from: Kindred on September 14, 2012, 12:46:47 PM
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... :P
You can show each "collection" in a different page, or all in one, or any possible combination.

Quote from: Kindred on September 14, 2012, 12:46:47 PM
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. :P
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...
Title: Re: My Collection Mod
Post by: Kindred on September 14, 2012, 03:33:30 PM
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...
Title: Re: My Collection Mod
Post by: emanuele on September 15, 2012, 08:28:28 AM
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 :P).

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! :P);
* 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!
Title: Re: My Collection Mod
Post by: zapiy on September 15, 2012, 06:19:48 PM
This is a brilliant start, thanks for having ago at this..

Can we add images?
Title: Re: My Collection Mod
Post by: emanuele on September 16, 2012, 04:09:57 AM
Not at the moment, maybe later.
Title: Re: My Collection Mod
Post by: Tony Reid on September 16, 2012, 04:38:23 AM
Nice idea/mod - just playing with it on a clean install and thought I'd mention some of these...

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

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

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

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?
Title: Re: My Collection Mod
Post by: emanuele on September 16, 2012, 12:45:27 PM
Even with the last package I posted?...

/me goes back checking his code... :P
Title: Re: My Collection Mod
Post by: Tony Reid on September 16, 2012, 12:47:58 PM
Yep :)
Title: Re: My Collection Mod
Post by: emanuele on September 17, 2012, 04:04:38 PM
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? :P

ETA2: pushed a github repo too at https://github.com/emanuele45/Collections
Title: Re: My Collection Mod
Post by: Kindred on September 17, 2012, 04:17:10 PM
oops...

with 0.1.0b,

in SMF Admin >>   Unable to load the 'Collections/Collections' template.
Title: Re: My Collection Mod
Post by: emanuele on September 17, 2012, 04:37:23 PM
The commit message says it all :P
https://github.com/emanuele45/Collections/commit/48a59751005ba8104729739be4555db60688b296
Title: Re: My Collection Mod
Post by: Kindred on September 17, 2012, 05:41:24 PM
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
Title: Re: My Collection Mod
Post by: zapiy on September 23, 2012, 02:23:31 PM
Great work.. Really look forward to the development of this.
Title: Re: My Collection Mod
Post by: emanuele on September 28, 2012, 05:03:43 PM
Okay, instead of sorting out bugs in 2.1 I decided to spend a bit of time on that one. :P (well, I need it for another thing so... O:))

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>).
Title: Re: My Collection Mod
Post by: emanuele on October 18, 2012, 08:42:32 AM
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").
Title: Re: My Collection Mod
Post by: emanuele on November 18, 2012, 05:53:40 PM
Food for testing. O:)

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 :P),
* 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 :P,
* 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 :P O:)).

ETA: removed, something is wrong... ::)
Title: Re: My Collection Mod
Post by: zapiy on March 15, 2013, 07:49:20 AM
Anymore dev on this?
Title: [PAID/FREE/] Personal Collection / Catalogue Database
Post by: zapiy on July 23, 2014, 07:23:41 AM
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?