Editing Merethrond

Jump to navigation Jump to search

Warning: You are not logged in. Your IP address will be recorded in this page's edit history instead of a username. Either log in, or remember to sign your entry. (Unless you want to post anonymously.)

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.

Latest revision Your text
Line 33: Line 33:
  
 
--[[User:Admin|Admin]] 11 January 2006 14:30 (GMT)
 
--[[User:Admin|Admin]] 11 January 2006 14:30 (GMT)
 
 
 
== Path Posts ==
 
 
Originally at [[Talk:Faramir tells them of Denethor’s involvement]]
 
 
=== Admin-ish question to all ===
 
 
The [[Path:Faramir tells them of Denethor’s involvement|Path]] list - is that useful to anyone? Worth doing for all chapters?
 
 
You could see it as the chapter's private little chapter [[overview]] list - not all chapters, just the chapters that went before this one. And to make a new one, you just take the list of the previous chapter and add the option you followed to the bottom of the list.
 
 
-[[User:Iris|Iris]] 17 February 2006 16:51 (GMT)
 
 
=== About the chapter path ===
 
 
Dear Iris, I noticed it, and I loved it! The chapters chart is getting very complicated, no matter how it had improved impressively. But still, I got lost while tracing the path to find where a current chapter was originally from. So the private path worth the work. Thanks a lot! I hope it's not manually done though.<br>
 
Dream
 
 
===The path===
 
 
Yes, I also found myself tracing back (especially whenever we got a post in a thread that had been dormant for a while), and going through the 'What links here' page was just too many steps.
 
 
But it is still a manual system, I'm afraid. I've been thinking about an automatic one, but that would involve labelling the chapters somehow to reflect the hierarchy. Right now, the system does not know we always have one page that links to two pages that both link to two new pages, and so on. It just thinks they’re links, like any other.
 
 
So you’d have to label the pages with a code that reflects their position in the hierarchy. The system would have to calculate this code automatically and place it in a new cell in the database. That’s one part of the coding.
 
 
The other part is generating the path pages (and the overview page - that could also be done automatically once each chapter has a hierarchy code). You could either do a query (a ‘search’) each time want to display a path page, and search for all the pages that are in a direct line up the hierarchy before the one you’re looking at and spit out that list, or you could generate a path page once, when the source page is created, by adding an extra link to the current page at the end of the path list of the previous page (since the system would now know what the 'previous page' is).
 
 
But that’s all a lot of coding... and for one chapter every other week, I don’t know if it’s worth it - especially since the manual process is very simple (copy the page from the previous chapter and stick a link to the new chapter on the end). <br>
 
I mean, this would be some serious hours of coding vs a manual process of maybe 20 seconds per chapter. That’s a lot of chapters before break-even.
 
 
But if there’s a PHP/MySQL ace out there reading this, to whom a simple hack like this is peanuts,  please get in touch and we’ll work on this!
 
 
-[[User:Admin|Admin]] 18 February 2006 09:21 (GMT)
 
 
=== About the path ===
 
 
Gee! I thought Wiki is doing such things already, but when read the about link below, realized it is only a content management system.
 
To have the linkage trace back and forth and dynamically generate the path report page, we need some good and smart design, then, some serious and smarter coding. Unless we can sale it for money, guess sorting by hand would work for a while. In either case, sorry my dear Admin, you are the one who do the works. Admire, admire!
 
Dream
 
 
===Path, and the limits of CMSes===
 
 
Yes, it is nothing but a CMS. A nice one, but still.
 
 
[[Image:Links1.png|frame|left|A normal site]] [[Image:Links2.png|frame|left|Our Interactive Story]]
 
Or really, it's our Interactive Story that's a bit funny. Normal sites are never this organized, they have cross links going everywhere in a chaotic pattern. Drawing a map for 7 pages is still doable, but when you have 70 or 700 pages (or almost 1,000,000 like [[wikipedia:main page|English Wikipedia]]) it quickly becomes impossible, as well as illogical to even want such a map - so these sites were never designed to produce one.
 
 
The 'What links here' option in the toolbox is already a very nice tool to trace your way back up the hierachy of chapters - and not one that every CMS has; certainly one of the reasons to prefer MediaWiki.
 
 
Of course I'd like to code something clever so it's all custom fit for this Interactive Story, but as long as the manual process is this easy, it's just not worth it.
 
 
-[[User:Iris|Iris]] 18 February 2006 16:28 (GMT)
 
 
=== The path ===
 
 
I was thinking to store each page into a database table. Each page as a node in a binary tree, having a page_id, parent_page_id, first_child_id, second_child_id. Only first chapter can have null parent, all page can have null children. As you said, the qury could be a very painful one with god-knows-how-many-layers of self join. It is like giving a bad design and have an unlucky programer to do the coding. I think we all had enough such luck in RL, we can avoid the troubles here. And saving time and energy and most of all, passion, on some nice fiction writing! :-) <br>
 
Dream
 
 
=== Path ===
 
 
Yup- that sounds like a good plan. Are you any good at PHP/MySQL programming? Want me to send you the files so you can have a look at the implementation?
 
 
-[[User:Iris|Iris]] 19 February 2006 13:07 (GMT)
 
 
=== The Path ===
 
 
Oh dear, the more I talk the more I got myself into... something.
 
But sorry, I am not good at anthing that start or end or include SQL (PL/SQL, MySQL, MS SQL, SQLPlus....) Whenever there is a query involves more than three tables to join or selfjoin N times, I need to find someone else to write the query, and I do anything else. ;-) Spoiled to have DBA friends. But yes, you can send me the file (what file?), but I don't have MySQL installed and never worked with MS SQL Server. I am currently working with MSAccess. sigh....
 
Dream
 

Please note that all contributions to FaraWiki can be edited by all visitors. If you don't want to risk your writing being edited, then don't submit it here, or have it protected.
You are also promising us that you wrote this yourself, or copied it with permission from the author.

To edit this page, please answer the question that appears below (more info):

Cancel Editing help (opens in new window)