search -  faq -  rulez -  staff

forums






map cycle
irc              pwnalizer
voice         dswp bar




Register

Login


It is currently 03.28.24

 

All times are UTC + 1 hour




Post new topic Reply to topic  [ 155 posts ]  Go to page Previous  1 ... 12, 13, 14, 15, 16  Next
Author Message
PostPosted: 03.25.12 
Offline
[dswp]R.Stallman
User avatar

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«



 


Top
 Profile  
 
PostPosted: 03.25.12 
Offline
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!


.



 


Top
 Profile  
 
PostPosted: 03.25.12 
Offline
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:
.
  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


.



 


Top
 Profile  
 
PostPosted: 03.25.12 
Offline
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.

.



 


Top
 Profile  
 
PostPosted: 03.25.12 
Offline
Godlike
User avatar

Joined: 06.26.09
Posts: 672
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



 


Top
 Profile  
 
PostPosted: 03.25.12 
Offline
Godlike
User avatar

Joined: 06.26.09
Posts: 672
Image

_________________
"It is the first responsibility of every citizen to question authority."
-- Benjamin Franklin



 


Top
 Profile  
 
PostPosted: 03.25.12 
Offline
Godlike
User avatar

Joined: 06.26.09
Posts: 672
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



 


Top
 Profile  
 
PostPosted: 03.25.12 
Offline
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.

.



 


Top
 Profile  
 
PostPosted: 03.25.12 
Offline
[dswp]R.Stallman
User avatar

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«



 


Top
 Profile  
 
PostPosted: 03.25.12 
Offline
Godlike
User avatar

Joined: 06.26.09
Posts: 672
nati: sure! whatever...

pirat: irc?

_________________
"It is the first responsibility of every citizen to question authority."
-- Benjamin Franklin



 


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 155 posts ]  Go to page Previous  1 ... 12, 13, 14, 15, 16  Next

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 0 guests


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

Search for:
Jump to:  
cron
Imprint

Powered by phpBB © 2000, 2002, 2005, 2007, 2008, 2009, 2010 phpBB Group

Skin by Lucas Kane
we use apache2 mod rewrite with phpBB SEO
map train_beta1-100 © 2009 by SteveMcQueen
Statistics Backend + Database by XLR Stats and B3 Bot
mapvote robot and gameserver monitor © 2009 by BlinKy
mumble viewer Copyright © 2008 Dominik Radner (aka Urmel)
mumble switcher and integration © 2008 by XTJ7, Unclefragger and Wursti
Localisation Plugin © 2009, Team Leads Plugin © 2009 and Knifer Plugin © 2009 by SvaRoX
for our stats we use Chart.js Copyright (c) 2013-2015 Nick Downie.
the stats also use some jQuery jQuery v2.1.4 | (c) 2005, 2015 jQuery Foundation, Inc.



voice server
top 20 players


nameskillkills
-Dws.BLINGBLING*-*1730.63418631
NormaSnockers1865.75400492
Zottel1760.8276378
make.them.suffer1846.17269872
>8v=1825.35230156
moon1777.56195615
sjas1692.49192315
peace1878.86190660
Wagner_Moura1562.9188001
Goomba1859.75182677
z0rn1608.41181016
Mad1803.76179124
[dswp]PLZ1847.85178516
Graf_ZahlIII1835.73167407
Zohan1611.07159737
ubercunt1634.93159240
Yarrr!1917.33156233
I_am_nOOb1909.64151268
Pandageddon1891.75148319
Pirat1664.08145798