Comments on: “wait” “-1″;”message” “help!” http://www.quaddicted.com/quaddictedcom/wait-1messagehelp/ The greatest Quake 1 Singleplayer site on this planet. Tue, 09 Aug 2011 22:15:18 +0000 hourly 1 By: Spirit http://www.quaddicted.com/quaddictedcom/wait-1messagehelp/comment-page-1/#comment-2736 Spirit Tue, 16 Nov 2010 14:49:39 +0000 http://www.quaddicted.com/?p=1257#comment-2736 Yeah, in retrospect the title is bollocks. I'll probably make it a valuable bounty (I AM RICH!) and write exactly what is needed. Yeah, in retrospect the title is bollocks. I’ll probably make it a valuable bounty (I AM RICH!) and write exactly what is needed.

]]>
By: negke http://www.quaddicted.com/quaddictedcom/wait-1messagehelp/comment-page-1/#comment-2735 negke Tue, 16 Nov 2010 09:06:15 +0000 http://www.quaddicted.com/?p=1257#comment-2735 I'm pessimistic about anyone stepping up to help soon. Still, since this is an important request, I suggest adding a permanent link to top of the front page, similar to the ad, so the chances of someone reading it are slightly increased. And with a better title. I’m pessimistic about anyone stepping up to help soon. Still, since this is an important request, I suggest adding a permanent link to top of the front page, similar to the ad, so the chances of someone reading it are slightly increased. And with a better title.

]]>
By: The Injector database is now dynamically created from the main database http://www.quaddicted.com/quaddictedcom/wait-1messagehelp/comment-page-1/#comment-2685 The Injector database is now dynamically created from the main database Mon, 25 Oct 2010 17:48:37 +0000 http://www.quaddicted.com/?p=1257#comment-2685 [...] “wait” “-1″;”message” “help!” [...] [...] “wait” “-1″;”message” “help!” [...]

]]>
By: Spirit http://www.quaddicted.com/quaddictedcom/wait-1messagehelp/comment-page-1/#comment-2681 Spirit Sat, 23 Oct 2010 20:36:10 +0000 http://www.quaddicted.com/?p=1257#comment-2681 Import is done. Export for the Injector not. Import is done. Export for the Injector not.

]]>
By: Spirit http://www.quaddicted.com/quaddictedcom/wait-1messagehelp/comment-page-1/#comment-2675 Spirit Thu, 14 Oct 2010 14:43:12 +0000 http://www.quaddicted.com/?p=1257#comment-2675 1) The problem is mostly doing the xml export in a good way. I fear SQL joins for their complexity. And it would be quite slow in any case. So it is depending how to structure the data well. The rest should not be too hard. "start map" means "any included bsp file". It is named badly. One can (or should be able to) select each included map in the Injector to directly load it. That's very useful for map packs. The logic behind dependencies is easy, but again I have no idea if it would not be more simple to simply use one additional field in the maps table and store it as csv (eg "quoth;hipnotic"). 3) Should be rather easy once 1) is decided. 1) The problem is mostly doing the xml export in a good way. I fear SQL joins for their complexity. And it would be quite slow in any case. So it is depending how to structure the data well. The rest should not be too hard.

“start map” means “any included bsp file”. It is named badly. One can (or should be able to) select each included map in the Injector to directly load it. That’s very useful for map packs.

The logic behind dependencies is easy, but again I have no idea if it would not be more simple to simply use one additional field in the maps table and store it as csv (eg “quoth;hipnotic”).

3) Should be rather easy once 1) is decided.

]]>
By: dfsp_spirit http://www.quaddicted.com/quaddictedcom/wait-1messagehelp/comment-page-1/#comment-2671 dfsp_spirit Mon, 11 Oct 2010 10:01:56 +0000 http://www.quaddicted.com/?p=1257#comment-2671 1) and 3) don't sound very time consuming. My time is limited but I could have a look at these. If I got you right 1) is about parsing XML and writing the parsed info it into a DB. I should be able to do that in PHP or Perl in reasonable time. On your question about where to store the data: I don't know whether you got a separate entry in a 'maps' table for every (start) map in your DB. But if you need nothing but the name of the map you should make it a field of the map/episode/release (whatever it's called, I'll assume 'release' here) table. (Or are there episodes with >1 start map?) The dependencies are more complicated since one release can depend on more than one other release I guess. I would suggest to create a new table 'dependencies' that has the fields 'release_id' and 'dep_release_id' (both are of type release.release_id). For each dependency of each map, write one entry into that table and you're done. 3) is a HTML upload form that one (you or the public?) can use to add new maps to the DB I guess. It needs to do CRC (which means simply calling md5() on the file I guess) and write to the DB instead of a text/HTML file, right? You can reply via email if you prefer that, I left a valid one. 1) and 3) don’t sound very time consuming. My time is limited but I could have a look at these.

If I got you right 1) is about parsing XML and writing the parsed info it into a DB. I should be able to do that in PHP or Perl in reasonable time.

On your question about where to store the data: I don’t know whether you got a separate entry in a ‘maps’ table for every (start) map in your DB. But if you need nothing but the name of the map you should make it a field of the map/episode/release (whatever it’s called, I’ll assume ‘release’ here) table. (Or are there episodes with >1 start map?)

The dependencies are more complicated since one release can depend on more than one other release I guess. I would suggest to create a new table ‘dependencies’ that has the fields ‘release_id’ and ‘dep_release_id’ (both are of type release.release_id). For each dependency of each map, write one entry into that table and you’re done.

3) is a HTML upload form that one (you or the public?) can use to add new maps to the DB I guess. It needs to do CRC (which means simply calling md5() on the file I guess) and write to the DB instead of a text/HTML file, right?

You can reply via email if you prefer that, I left a valid one.

]]>
By: negke http://www.quaddicted.com/quaddictedcom/wait-1messagehelp/comment-page-1/#comment-2670 negke Sat, 09 Oct 2010 09:05:55 +0000 http://www.quaddicted.com/?p=1257#comment-2670 As a matter of fact, I QUADHATE you now!!!!!! >:( As a matter of fact, I QUADHATE you now!!!!!! >:(

]]>