View unanswered posts | View active topics
Author |
Message |
natirips
|
Posted: 03.25.12 |
|
![Offline Offline](./styles/blackbox_blue/imageset/en/icon_user_offline.gif) |
[dswp]R.Stallman |
![User avatar](./download/file.php?avatar=453_1295281752.jpg) |
Joined: 04.13.09 Posts: 2946 Location: Solar System/≈Zagreb
-----tdm:
nick: [ntr]Shortly
skill: 497.05
kills: 3446
deaths: 4411
ratio: 0.78
-----bomb:
nick: [ntr]Shortly
skill: 707.602
kills: 526
deaths: 863
ratio: 0.60
|
@havoc: If he's having fun, then what's the problem?
_________________ ssh natirips@*.255.255.255 sudo chown -R natirips / \; echo Also, »QUESTION EVERYTHING«
![](http://dswp.de/old/images/tdm-banner/453)
|
|
Top |
|
![](images/spacer.gif) |
Pirat
|
Posted: 03.25.12 |
|
![Offline Offline](./styles/blackbox_blue/imageset/en/icon_user_offline.gif) |
Godlike |
Joined: 03.29.10 Posts: 1447
-----tdm:
nick: Pirat
skill: 507.365
kills: 402
deaths: 636
ratio: 0.63
|
havoc wrote: 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! .
![](http://dswp.de/old/images/tdm-banner/922)
|
|
Top |
|
![](images/spacer.gif) |
Pirat
|
Posted: 03.25.12 |
|
![Offline Offline](./styles/blackbox_blue/imageset/en/icon_user_offline.gif) |
Godlike |
Joined: 03.29.10 Posts: 1447
-----tdm:
nick: Pirat
skill: 507.365
kills: 402
deaths: 636
ratio: 0.63
|
wurst wrote: 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: . - The table is not necessarily final -- if you see any problems with
it, please tell me! . - 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. =) . - 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. . - 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. . - 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 .
![](http://dswp.de/old/images/tdm-banner/922)
|
|
Top |
|
![](images/spacer.gif) |
Pirat
|
Posted: 03.25.12 |
|
![Offline Offline](./styles/blackbox_blue/imageset/en/icon_user_offline.gif) |
Godlike |
Joined: 03.29.10 Posts: 1447
-----tdm:
nick: Pirat
skill: 507.365
kills: 402
deaths: 636
ratio: 0.63
|
natirips wrote: @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. .
![](http://dswp.de/old/images/tdm-banner/922)
|
|
Top |
|
![](images/spacer.gif) |
havoc
|
Posted: 03.25.12 |
|
![Offline Offline](./styles/blackbox_blue/imageset/en/icon_user_offline.gif) |
Godlike |
![User avatar](./download/file.php?avatar=684_1346885891.jpg) |
Joined: 06.26.09 Posts: 674
|
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?
_________________ "It is the first responsibility of every citizen to question authority." -- Benjamin Franklin
![](http://dswp.de/old/images/tdm-banner/684)
|
|
Top |
|
![](images/spacer.gif) |
havoc
|
Posted: 03.25.12 |
|
![Offline Offline](./styles/blackbox_blue/imageset/en/icon_user_offline.gif) |
Godlike |
![User avatar](./download/file.php?avatar=684_1346885891.jpg) |
Joined: 06.26.09 Posts: 674
|
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.
_________________ "It is the first responsibility of every citizen to question authority." -- Benjamin Franklin
![](http://dswp.de/old/images/tdm-banner/684)
|
|
Top |
|
![](images/spacer.gif) |
Pirat
|
Posted: 03.25.12 |
|
![Offline Offline](./styles/blackbox_blue/imageset/en/icon_user_offline.gif) |
Godlike |
Joined: 03.29.10 Posts: 1447
-----tdm:
nick: Pirat
skill: 507.365
kills: 402
deaths: 636
ratio: 0.63
|
havoc wrote: [...] 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 havoc wrote: you wouldnt listen anyways :) and maybe its for good you wouldnt. |-) havoc wrote: (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? havoc wrote: 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. .
![](http://dswp.de/old/images/tdm-banner/922)
|
|
Top |
|
![](images/spacer.gif) |
natirips
|
Posted: 03.25.12 |
|
![Offline Offline](./styles/blackbox_blue/imageset/en/icon_user_offline.gif) |
[dswp]R.Stallman |
![User avatar](./download/file.php?avatar=453_1295281752.jpg) |
Joined: 04.13.09 Posts: 2946 Location: Solar System/≈Zagreb
-----tdm:
nick: [ntr]Shortly
skill: 497.05
kills: 3446
deaths: 4411
ratio: 0.78
-----bomb:
nick: [ntr]Shortly
skill: 707.602
kills: 526
deaths: 863
ratio: 0.60
|
havoc wrote: 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.
_________________ ssh natirips@*.255.255.255 sudo chown -R natirips / \; echo Also, »QUESTION EVERYTHING«
![](http://dswp.de/old/images/tdm-banner/453)
|
|
Top |
|
![](images/spacer.gif) |
havoc
|
Posted: 03.25.12 |
|
![Offline Offline](./styles/blackbox_blue/imageset/en/icon_user_offline.gif) |
Godlike |
![User avatar](./download/file.php?avatar=684_1346885891.jpg) |
Joined: 06.26.09 Posts: 674
|
nati: sure! whatever...
pirat: irc?
_________________ "It is the first responsibility of every citizen to question authority." -- Benjamin Franklin
![](http://dswp.de/old/images/tdm-banner/684)
|
|
Top |
|
![](images/spacer.gif) |
Who is online |
Users browsing this forum: No registered users and 1 guest |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot post attachments in this forum
|
|
voice server |
|
|
|
top 20 players
name | skill | kills |
---|
-Dws.BLINGBLING*-* | 1730.63 | 418631 | NormaSnockers | 1865.75 | 400492 | Zottel | 1760.8 | 276378 | make.them.suffer | 1846.17 | 269872 | >8v= | 1825.35 | 230156 | moon | 1777.56 | 195615 | sjas | 1692.49 | 192315 | peace | 1878.86 | 190660 | Wagner_Moura | 1562.9 | 188001 | Goomba | 1859.75 | 182677 | z0rn | 1608.41 | 181016 | Mad | 1803.76 | 179124 | [dswp]PLZ | 1847.85 | 178516 | Graf_ZahlIII | 1835.73 | 167407 | Zohan | 1611.07 | 159737 | ubercunt | 1634.93 | 159240 | Yarrr! | 1917.33 | 156233 | I_am_nOOb | 1909.64 | 151268 | Pandageddon | 1891.75 | 148319 | Pirat | 1664.08 | 145798 |
|
![](./images/spacer.gif)
|
|