TinyPortal

General => Chit chat => Topic started by: Moocat on September 17, 2005, 04:38:44 AM

Title: MySQL "encyclopedia"
Post by: Moocat on September 17, 2005, 04:38:44 AM
okay one of my users, today, came up with a brilliant idea for a feature on my site. the only problem is, i don't know how to implement it.
he wants me to implement a searchable database of ideas or concepts that he and his associates have for this mmorpg they are creating. i figure i could enter it into a mysql database manually, but it would be sooo much better to have some sort of script, like smf (except not like smf :P ) that would allow my members to go to the page and search it, while a select few members would have the ability to add entries into this "encyclopedia". is there any script i can install, or easy way to program this by myself ? i'm sure there must be some kind of script i can install that would allow me this capability, but i've searched and couldn't find anything adequate. any help would be wonderful :) thx
Title: Re: MySQL "encyclopedia"
Post by: borgBOB on September 17, 2005, 04:54:23 AM
Try this site, it seems to have lots of choices.

http://www.hotscripts.com/PHP/Scripts_and_Programs/index.html (http://www.hotscripts.com/PHP/Scripts_and_Programs/index.html)
Title: Re: MySQL "encyclopedia"
Post by: eldacar on September 17, 2005, 05:34:37 AM
For that I'd just use a wiki.
However someone was discussing turning SMF into a wiki too with a mod.. that would be interesting
Title: Re: MySQL "encyclopedia"
Post by: Moocat on September 17, 2005, 07:40:21 AM
a wiki?
Title: Re: MySQL "encyclopedia"
Post by: eldacar on September 17, 2005, 08:34:32 AM
http://en.wikipedia.org/wiki/Wiki
Title: Re: MySQL "encyclopedia"
Post by: PhilH on September 17, 2005, 10:32:38 AM
How about using a glossary? Look here (http://sourceforge.net/search/?type_of_search=soft&forum_id=0&group_id=0&atid=0&words=glossary&imageField.x=10&imageField.y=10)
Title: Re: MySQL "encyclopedia"
Post by: bloc on September 17, 2005, 11:03:23 AM
SMF could act like a wiki with just a theme really..and set some permissions accordingly. It won't have rollback features of course, but post+comment, and of course search.And you could limit it to a board, even using child boards as the "sections" and not using the actual parent board for other than overview/info. 
Title: Re: MySQL "encyclopedia"
Post by: eldacar on September 17, 2005, 03:08:57 PM
My idea was that each post in the topic would be the latest edit, and that normally you just see the last post. Its not a true wiki without a history in my opinion. The talk pages could be a topic in a secondary board that is "paired" to the first topic.
Title: Re: MySQL "encyclopedia"
Post by: bloc on September 18, 2005, 12:09:29 AM
I see. Actually displaying the last post, and using previous posts as "history" could be done I think. Since all info is there, its a matter of filtering it accordingly..you will have "back links" to earlier posts, and they will contain a pointer to show that message as the "current". As for "roll-back" it would ahve to be deleted of course, thats where it differs from wiki perhaps.

Point is, its really depending on how much of wiki features you need.Too many, and it will be better to actually use the real one. ;)
Title: Re: MySQL "encyclopedia"
Post by: Moocat on September 18, 2005, 05:26:01 AM
i tried wiki, but it would let anyone submit or edit articles, which i dislike. i want just one user with writing permissions and everyone else can just read thru it. i would do it in smf, but this database will be pretty massive, to be honest. the guy tried to organize it in smf, but its far too hard to do.
Title: Re: MySQL "encyclopedia"
Post by: eldacar on September 18, 2005, 01:48:34 PM
TikiWiki (http://tikiwiki.org/) Allows you to set full permissions however you like.
Title: Re: MySQL "encyclopedia"
Post by: Moocat on September 18, 2005, 05:51:27 PM
lol haven't tried that yet, i'm trying lore right now. if this one doesn't work out i'll go for tikiwiki ;) ty for advice :D
Title: Re: MySQL "encyclopedia"
Post by: Xarcell on November 03, 2005, 05:14:50 AM
Can I check out that mmorpg? do they have a site?