New Maps for the mapcyclevote

[natirips]

@havoc: If he's having fun, then what's the problem?

[Pirat]

judging by his early screenie and the user rating thing, it definitely went a bit complicated and a bit sideways :)

w000t?!

Yeah, you wanted something simpler, but I hate imposing
arbitrary limits on such a project, so I went for something
bigger. :-}

If all goes well and I really decide to implement the template
system I was thinking about, everybody can have his own
frontend layout. But it's too early to say something definite
about it.

Okay, so much for "a bit complicated", but what do you mean
by "a bit sideways"? The main goal of that project is:

• let users view maps with (hopefully any desired) sort
  and filter criteria
• let users rate every possible aspect of a map
• have an interface between users and the server, so that
  the server can take into account if a map is playable (maybe
  for a certain mode) or not, or how many spawn points are
  in the map etc.

Or did you picture something else as main goal?
The project is still young, you can still bring in your
ideas!


.

[Pirat]

hmm...
can u do something like "SHOW CREATE TABLE <tablename>;" and copypaste it here?

Sure (<pre> rulez! :-):

CREATE TABLE `t_tags` (
  `filename` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `tag` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `tagvalue` mediumtext COLLATE utf8_bin NOT NULL,
  `note` mediumtext COLLATE utf8_bin,
  `user` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`filename`,`tag`,`tagvalue`(78),`user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin

A few notes:
.

1. The table is not necessarily final -- if you see any problems with
   it, please tell me!
   .
2. mediumtext = VARCHAR(65535).
   .
   I somewhere read that mediumtext is is stored externally,
   in the file system. I don't know if that is good performance-wise
   -- and I don't know if that matters at all, regarding the relatively
   few entries this database has to handle (250 maps at first, then
   maybe growing to max. 1,000 or something). Where is the limit
   for in-database-storage and external storage? Is it 255 chars?
   Then I'm gonna leave it this way, because 255 is definitely too
   small. This is not SMS or twitter. =)
   .
3. tagvalue(78): primary key can be 1,000 chars max, and
   with an UTF8 char taking up up to 3 chars, there were only
   78 chars left.
   .
4. Why does "SHOW CREATE TABLE" show a single create
   statement incl. "PRIMARY KEY"? I thought composite
   primary keys had to be added after the create statement?
   But I'm not sure about that.
   .
5. The default engine is MyISAM, but I'm not sure about the
   implications of picking a certain engine. What I would like
   to have is something (probably) transaction based.
   Reason: I want to be able to cancel the last N actions
   (editing, creating, deleting, ...) of user $BADUSER. Do you
   think that is possible? And which engine would I need for
   that? InnoDB?

I currently have another (yet unused) table carrying
information about each tag (mainly if something is a
string or numeric). Don't know how exactly I am going
to use that, but I'll post it anyway:

CREATE TABLE `t_taginfo` (
  `tag` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `format` tinyint(3) NOT NULL,
  `description` mediumtext COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`tag`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin

.

[Pirat]

@havoc: If he's having fun, then what's the problem?

... said a bystander regarding a Nazi bashing a jew. ;-) Okay, seriously now. :-)
Yes, I'm having fun with it (at least partly, it's also a burden,
but one that I'm willing to shoulder), and that is mainly because
this project should add to everyone's welfare: admins and players.

.

[havoc]

nati: what...?

pirat: i wrote you a big reply, but i decided not to post it :) you wouldnt listen anyways :) and maybe its for good you wouldnt.

(ok heres the complete truth. i want you to do it, but in my cold-hearted no-fun logical way. i cant help you now, while you are still having fun with it, and im so sick and tired of that disgusting php/mysql thing anyways. but with time it all will become a torture for you just like it became for me, and just then when you have suffered enough, you will be ready to listen. then you will become my php/mysql-slave, broken, burning slowly in eternal php/mysql hell.)

ahem.

so anyways, i thought the main goal was to make a decent map list?

[havoc]

[havoc]

p.s. the main difference between myisam and innodb is one locks the whole table on certain operations (good for transactions) the other only the affected row. for the map thing doesnt really matter.

[Pirat]

[...]
pirat: i wrote you a big reply, but i decided not to post it :)

w00000t?!

Okay, did that, too:
$ wc -l post-1-of-3.txt
221 post-1-of-3.txt
$

:-P

you wouldnt listen anyways :) and maybe its for good you wouldnt.

|-)

(ok heres the complete truth. i want you to do it, but in my cold-hearted no-fun logical way. i cant help you now, while you are still having fun with it, and im so sick and tired of that disgusting php/mysql thing anyways. but with time it all will become a torture for you just like it became for me, and just then when you have suffered enough, you will be ready to listen. then you will become my php/mysql-slave, broken, burning slowly in eternal php/mysql hell.)

Nice picture of my future! 8-) *lol*

But seriously, can you roughly sketch what you had
in mind?

ahem.

so anyways, i thought the main goal was to make a decent map list?

Errr, yeah, just what I'm trying to implement right now -- except if
your definition of "decent" differs from mine. :-) In that case, please
tell me what you pictured as decent map list.

.

[natirips]

nati: what...?

If he's still at it, that means he's still got some enthusiasm, which means he's probably having fun.

And afaik, dswp revolves around fun.

[havoc]

nati: sure! whatever...

pirat: irc?