dswp.de
http://www.dswp.de/old/

New Maps for the mapcyclevote
http://www.dswp.de/old/nice-maps/new-maps-for-the-mapcyclevote-t2526-100.html		 Page 11 of 16
Author:  havoc [ 02.17.12 ]
Post subject:  Re: New Maps for the mapcyclevote
irc in the weekend?
Author:  Pirat [ 02.18.12 ]
Post subject:  Re: New Maps for the mapcyclevote
havoc wrote:
irc in the weekend?

Will probably be there,
although I will probably need to discuss the database design on Mumble.
Author:  wurst [ 02.18.12 ]
Post subject:  Re: New Maps for the mapcyclevote
mumble in the weekend?
Author:  Pirat [ 02.18.12 ]
Post subject:  Re: New Maps for the mapcyclevote
wurst wrote:
mumble in the weekend?

Oh yes! :-)

Don't know if I can make it today, but tomorrow, I should be prepared!


.
Author:  Pirat [ 02.21.12 ]
Post subject:  Re: New Maps for the mapcyclevote
Pirat wrote:
wurst wrote:
mumble in the weekend?

Oh yes! :-)

Don't know if I can make it today, but tomorrow, I should be prepared!

Weeeeell ... I was in mumble indeed, but too tired to talk about
databases.

Nevertheless, it seems I have found a working database structure
that lets me do whatever is needed to implement the map list.

Now I just need:
  • Short discussion with Wursti about using primary keys
  • Some thought put into the map properties which users
    can edit. After some initial thought, I will share my ideas here
    in the forum and together, we'll find a nice solution. :-)
  • The PHP frontend. Basic database access works, but the
    interface is totally unfinished. =)

.
Author:  havoc [ 02.21.12 ]
Post subject:  Re: New Maps for the mapcyclevote
just add a table for comments with these columns:

comment id
map id
date/time
user id/name/whatever
comment text
type of comment

with type of comment being one of 3 - a pro, a con, or just comment

can u please paste your maps table?


p.s. your primary in the maps table should be the map id
Author:  wurst [ 02.21.12 ]
Post subject:  Re: New Maps for the mapcyclevote
yea.
we have automatic backup btw, db and flies
Author:  Crusher [ 02.21.12 ]
Post subject:  Re: New Maps for the mapcyclevote
Flies? :)
Author:  havoc [ 02.22.12 ]
Post subject:  Re: New Maps for the mapcyclevote
files
Author:  Pirat [ 02.22.12 ]
Post subject:  Re: New Maps for the mapcyclevote
havoc wrote:
just add a table for comments with these columns:

comment id
map id
date/time
user id/name/whatever
comment text
type of comment

with type of comment being one of 3 - a pro, a con, or just comment
[...]
p.s. your primary in the maps table should be the map id

AFAIK, this won't work, as in your table, there is more than one row
for each map (because there can be more than one comment per
map). Therefore, the map id is not unique and thus cannot act
as a primary key.

Would should work, however, is using a composite primary key that
comprises all columns. I'll probably use such a key for all of my
tables except for my main table where the map name/id is the
primary key.

havoc wrote:
type of comment

with type of comment being one of 3 - a pro, a con, or just comment

Ah, this let another idea pop up in my head ... thanks, havoc! :-)

havoc wrote:
can u please paste your maps table?

I will do so today or -- at the latest -- tomorrow.

But some sparse info I can give you now:

Currently, I have one main table (urtmaps) with columns that
describe the non-list/unique data for each map (filename, filesize,
levelshot, homepage, release date, is installed on dswp, can be
voted for, etc.).

List data for the maps are stored in other tables, like urtmaptags,
urtmapauthors, urtmaplicenses (a map can be dual-licensed, for
instance), urtmapdownloads, etc.

Accusations of over-engineering this map list are automatically
redirected to /dev/null. ;-)


.
Page 11 of 16 All times are UTC + 1 hour
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/