Re: [Flightgear-devel] Re : Scenery web and scene models
Pedro Morgan wrote: would it be possible to dump the fgs_* tables and made available as a tarball... I'm not too enthusiastic about making DB dumps publicly available, but as an additional illustration to the table structure here's an example SQL script to add a model and the corresponding position. mo_modelfile is a BASE64-encoded, GNUzip'ed TAR file containing _everything_ which belongs to a model (XML, AC3D, textures), mo_thumbfile is a BASE64-encoded JPEG. http://mapserver.flightgear.org/dl/2454.sql.gz Cheers, Martin. -- Unix _IS_ user friendly - it's just selective about who its friends are ! -- -- Virtualization Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ ___ Flightgear-devel mailing list Flightgear-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/flightgear-devel
Re: [Flightgear-devel] Re : Scenery web and scene models
Pedro Morgan wrote: Have you considered Smarty templating (am biased as am a developer) Most of the code which now makes the Scenemodels web site had been written more than seven (!) years before now and, as far as I can tell, functionality was the foremost obligation, not elegance ;-) That's not an excuse, but maybe at least an explanation. Cheers, Martin. -- Unix _IS_ user friendly - it's just selective about who its friends are ! -- -- Virtualization Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ ___ Flightgear-devel mailing list Flightgear-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/flightgear-devel
Re: [Flightgear-devel] Re : Scenery web and scene models
On Mon, 13 Feb 2012 19:43:17 + (UTC), Martin Spott wrote: To be honest, there's a lot of ugly cruft in some of the web site code and the plan was to cast this into a nicer shape before making it public. Unfortunately the plan was never pursued. Actually it's *mostly* ugly cruft. I had intended splitting the logic from the page layout (my design skills are even worse than my code ;-) but that's been on my todo list for way too long. -- Jon Stockill li...@stockill.net -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d ___ Flightgear-devel mailing list Flightgear-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/flightgear-devel
Re: [Flightgear-devel] Re : Scenery web and scene models
On Tue, Feb 14, 2012 at 4:39 PM, Jon Stockill li...@stockill.net wrote: On Mon, 13 Feb 2012 19:43:17 + (UTC), Martin Spott wrote: To be honest, there's a lot of ugly cruft in some of the web site code and the plan was to cast this into a nicer shape before making it public. Unfortunately the plan was never pursued. Actually it's *mostly* ugly cruft. I had intended splitting the logic from the page layout (my design skills are even worse than my code ;-) but that's been on my todo list for way too long. Have you considered Smarty templating (am biased as am a developer) Pete -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d___ Flightgear-devel mailing list Flightgear-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/flightgear-devel
[Flightgear-devel] Re : Scenery web and scene models
Hi Pedro, So I am at a standstill as some parts are missing.. Notably header.php is missing and other stuff for db connection. and obviously data.. Which is understandable.. we dont want everyone to have access to a not db and the server is apache and probably configured in a custom way.. as is usual. The whole data is not there, it's still getting prepared to be gitted (put the passwords out of the git repositories, etc.). For me it's ok, so I think there will be more data soon, as soon as Martin finds the time to push it. For all of us to play moving forwards, we need a db or a clone or some public access etc...ideal worls.. but Regardless of the server side.. and all its complications with code + access...and then downloading a huge DB... We could possibly make the data scheme public, which could be something good to understand how the FG tables are defined. However most of the DB (out of the pure scenery site) - Martin please correct me - is based on mapserver, so it depends on which part of the website you want to work. So Can I suggest we patch up the server simple and quick to do simple task of returning data in json format.. We are already pulling some info from the server in Ajax, maybe you can be more precise in what you mean by patching. To get started what would be idea would be a list of types/ What do you mean by types ? also a list of models The list of models is here : http://scenemodels.flightgear.org/models.php (mixing shared and static). and a list of authors... The list of authors is here : http://scenemodels.flightgear.org/authors.php. eg with adodb.. $models = $db-getAll(select * from models order by model) headers(Content-type: json) echo json_encode($models); For the moment I wrote some simple PHP functions (not in git yet) to avoid rewriting everything each time. However there are mostly two parts on the scenery site (not talking of mapserver) : the part I wrote (adding, editing, deleting positions) and I'm still working on, and the part Jon wrote. Hopefully, putting all this to GIT will make things more coherent and easier to update. This is still not perfect, but better than nothing. However atmo its an unknown thing happening in some dark room with some parts available.. As already said, this has been the case for many years, and the git data you are seeing is a clear way to showing you that things are changing. There is not enough people working on it, so you'll be welcome to help once the whole data is published (it will make things a lot easier for you). But of course there is a need for human validation on the data pushed back to the server.-- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2___ Flightgear-devel mailing list Flightgear-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/flightgear-devel
Re: [Flightgear-devel] Re : Scenery web and scene models
Olivier wrote: For the moment I wrote some simple PHP functions (not in git yet) to avoid rewriting everything each time. However there are mostly two parts on the scenery site (not talking of mapserver) : the part I wrote (adding, editing, deleting positions) and I'm still working on, and the part Jon wrote. Hopefully, putting all this to GIT will make things more coherent and easier to update. Seconded, we just have to figure out how the merge should be done. However atmo its an unknown thing happening in some dark room with some parts available.. As already said, this has been the case for many years, and the git data you are seeing is a clear way to showing you that things are changing. Aside from that, guess how many readers of this very list had been responding to the various invitations into joining the Scenemodels or MapServer effort Yep, your're right, all of those who did are already involved and and have been contributing code, data or other valuable ressources :-) Cheers, Martin. -- Unix _IS_ user friendly - it's just selective about who its friends are ! -- -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2 ___ Flightgear-devel mailing list Flightgear-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/flightgear-devel
Re: [Flightgear-devel] Re : Scenery web and scene models
Olivier wrote: However atmo its an unknown thing happening in some dark room with some parts available.. As already said, this has been the case for many years, and the git data you are seeing is a clear way to showing you that things are changing. To be honest, there's a lot of ugly cruft in some of the web site code and the plan was to cast this into a nicer shape before making it public. Unfortunately the plan was never pursued. Thus, after long delay, we finally decided to put the stuff into GIT as-is - and maybe to encourage others to do the cleanup, add features, improve the visual experience or whatever pleases. Have fun, Martin. -- Unix _IS_ user friendly - it's just selective about who its friends are ! -- -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2 ___ Flightgear-devel mailing list Flightgear-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/flightgear-devel
Re: [Flightgear-devel] Re : Scenery web and scene models
would it be possible to dump the fgs_* tables and made available as a tarball... even a minimal set with limited records ? Pete On Mon, Feb 13, 2012 at 7:43 PM, Martin Spott martin.sp...@mgras.netwrote: Olivier wrote: However atmo its an unknown thing happening in some dark room with some parts available.. As already said, this has been the case for many years, and the git data you are seeing is a clear way to showing you that things are changing. To be honest, there's a lot of ugly cruft in some of the web site code and the plan was to cast this into a nicer shape before making it public. Unfortunately the plan was never pursued. Thus, after long delay, we finally decided to put the stuff into GIT as-is - and maybe to encourage others to do the cleanup, add features, improve the visual experience or whatever pleases. Have fun, Martin. -- Unix _IS_ user friendly - it's just selective about who its friends are ! -- -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2 ___ Flightgear-devel mailing list Flightgear-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/flightgear-devel -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d___ Flightgear-devel mailing list Flightgear-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/flightgear-devel
