
In this topic we'll cover all updates done to doom.com.hr / COMPET-N.
TODO:
+ tutorial how to record / play demos
+ check/review coop rules
+ check/review coop demos and categories
+ lmpc online tool http://doom.com.hr/forum/viewtopic.php? ... 3248#p3248
+ remove maps without secrets from nm100s upload script and mark them in database
+ fix stats http://doom.com.hr/forum/viewtopic.php? ... 3596#p3596
+ doom1 episode 2 is not detected correctly, figure what's with that!???? > detected as E3M1
+ fix plutonia episode nightmare upload not detected as nmare but uv
23.01.2019.
- fixed compet-n news page
22.01.2019.
- fixed database editor
- added few missing demos
- fixed bug in uploading script
- fixed calculation of positions (quick fix, this needs complete rewrite)
- fixed issues with database editor
- fixed avatars
21.01.2019.
- fixed player page and youtube linking on forum
2018
- migrated to new host (more memory)
- upgraded services to php 7.1, mysql 8,...
- upgraded phpbb to 3.2.x
- fixed php 7.x related errors
- migrated to new gallery since old one does not support PHP 7
- added privacy settings so user can request removal (gdpr/cookies related)
13.07.2015.
- few minor fixes to upload, comments and download pages
- few database fixes (thanks Jarmo)
- many other things I forgot to write down

01.01.2015.
- tricks section on forum and front page
- some fixes to database editor, comments and database
- added player column to top 100 downloads
- replaced IRC chat as it didn't work with static page with IRC server details
23.12.2014.
- fixed comments on main page and latest 50 comments
- fixed database editor
- added upload_date column
- other minor fixes
18.12.2014.
- updated everything for new competition doom 2.0.3.1, upload, test, faq, ...
- database fix (ty vdgg), some tweak to database, should be cleaner now
- top 100 downloads updated so now it will show total of cndoom, ccompet-n and coop2 records
21.10.2014.
- upload script will not warn anymore for uppercase files and will accept any *crap* you upload
- more work on new database http://doom.com.hr/index.php?page=compet-n_database2, implemented downloads and comments (still not all comments visible...)
- some site fixes
- removed local cndoom bug page as it's all now on github: https://github.com/fx02/chocolate-doom
05.10.2014.
- many fixes and improvements for database, fixes for comments section, some incoming script changes
- all databases upgraded to v0.6 so now all records have "downloads" but still downloads are not fully implemented, only on new database
10.09.2014.
- doing database from scratch, many optimizations, tweaks, and possibility to use it for heretic-n
http://doom.com.hr/index.php?page=compet-n_database1
02.09.2014.
- database now shows hi-score (not 100% checked for movie calculation but works)
- added all scythe maps and enabled in editor
- few minor fixes in database/incoming/upload regarding episode/movies demo paths
- added some nomonster demos (doom1/doom2)
- upload script now automatically parses txt file and saves it to server
16.08.2014. - 22.08.2014.
- menu not shown in db editor (thnx Jartapran)
- time convert tool fixed
- minor fixes
01.07.2014. - 15.08.2014.
- many db editor fixes (thnx vdgg)
- coop3/coop4 added to upload (still wondering what to do with such demos)
- stats page fixed
- database now shows time without leading zeros
- many nomo demos added
- upload script now updates record places after upload so demo is immediately visible in database but needs to be verified by admin

- regarding upload scrpt changes, incoming now shows all demos submitted in last 60 days no matter status / validation...
- other things I forgot in the meantime
28.07.2014. - 06.08.2014.
- rewrote database editor

- editor is now one file, maintenance mode, logging, debuging, mobile friendly, etc....
- upload script descriptions is broken so it's disabled
- small database fixes (timer, records, etc..)
- other minor changes to page
27.07.2014.
- uploaded descriptions for last update, and for HR coop
- upload script should parse descriptions for compet-n too (I hope/didn't test)
02.07.2014.
- database selection and maintenance mode (disables uploads and database editor)
- more database tweaks and optimizations
- rules changed for UV movies so now all categories are included and second best gets 5 points too
01.07.2014.
- some DB/page fixes reported by Ch0wW
- working on internal DB change that will work better/cleaner/faster and implementing nomonsters category
- other small fixes
11.01.2014.
- contests in DB editor, now competition mods (fx, Sedlo, jartapran, vdgg) can view/edit all compet-n/cndoom/coop/contest records
08.01.2014.
- fixed few bugs in compet-n stats page
- imported all contest to contest DB
- tweaked upload/contest script for easier admin manipulation
- moved contests to 2013 directory
08.12.2013.
- compet-n stats page, needs more tweaking, selection and details but it's good for start

20.09.2013.
- competition doom 2.0.2.1 released
- upload fixes (notifications not sent)
- uploading contest writes it to contest database too (for better manipulation)
- incoming script updated so now contains contests
- user settings fixed (to reflect ports/cndoom/contest)
- config fixes
- upload script creates parsable log for manipulation: http://www.doom.com.hr/public/compet-n/ ... coming.log
- challenge removed from forum and menu as not popular/used/nothing
- doom 3 also removed from forum, no interest
... many other fixes I can't remember now, will try in future

05.09.2013.
- new settings (notifications) to reflect contest and database changes regarding ports
02.09.2013.
- forgot to update changes here :8
- many changes to Competition Doom 2.0.2 and launcher 1.4.3
- new upload script and few fixes
- new column for databases (game_client) so now... you can submit vanilla, chocolate, prboom and tas demos! (not yet publicly available, hehe)
30.07.2013.
- competition doom launcher
- competition doom 0.2.5
26.07.2013.
- reworked upload script for contests
24.07.2013.
- merged old forum into new forum (users, posts, pvt)
- fixed upload script
16.06.2013.
- fixed script for checking/copying new demos
27.05.2013.
- trying to implement automatic detection of uploaded files: http://www.doom.com.hr/lmpc.php
- most of time spent on cleaning up and adjusting Competition Doom to Chocolate Doom v2 code
19.05.2013.
- check for non existent files when downloading + removing non existent file from TOP 100
15.05.2013.
- all coop nightmare, and doom 2 movies in db
12.05.2013.
- demo is now uploaded to correct directory
- old incoming is redirected to incoming page
- incoming page fixes
- fixed database coop calculation
08.05.2013.
- list incoming uploads from database: http://doom.com.hr/index.php?page=compet-n_incoming
- comments page for coop now shows player2
- check for existance of MAP image on comment page
- inserted some d2 movies
- fixed time converter bugs
07.05.2013.
- inserted all d1 movies
- some fixes in database (coop movies)
- movies are now sortable
06.05.2013.
- inserted all (d1, d2, tnt, pl) coop speed and max demos in database
- started to re-code database editor
- changed font with Google free font for faster page load
28.04.2013.
- competn.tk and compet-n.tk domains are working again
- small db fix regarding uploaded records in Incoming
25.04.2013.
- comments code changed, user data merged with forum data
24.04.2013.
- fixed all doom 2 pacifist downloads and comments -> from IRC "dingir: fx02: Some download links from the Doom2 UV Pacifist compet-n database web frontend at doom.com.hr don't work (lv14-020, lv16-011, lv18-021, maybe more where UV Speed = UV Pacifist)."
- upload changes, players must set ID before uploading, otherwise no upload form
22.04.2013.
- changes to database editor regarding new upload feature
- new upload: http://www.doom.com.hr/upload.php
- new setting (player id)
- some code fixes
18.04.2013.
- if user changed forum avatar, url or email, it would not get applied to comments, should be fixed
17.04.2013.
- database is "coop completed" and IWAD only for now
- fixed small bug not showing players/country (reported by vdgg)
12.04.2013.
- fixed few comments/forum bugs
11.04.2013.
- cron script adjusted for incoming (every 30 mins)
- old CN forum is now finally working!
09.04.2013.
- cleanups and fixes
- removed gallery from the main page since it cause a CPU hog

- finished coop hiscore (2 players for now)
08.04.2013.
- new and more options, linked to forum username and saved in database
07.04.2013.
- comments multilingual
- comments style, maybe more tweaks needed
- fixed prosilver
- some styling issues and css cleanup (w3c validation)
- made comment nick linkable
06.04.2013.
- minor comment styling
- fixed previous/next comments
05.04.2013.
- total downloads per demo located in public/compet-n
- some work on (coop) database
- code cleanups and page optimization, should load much faster (below 1 sec!)
- fixed comments unsubscribe, some unneeded comment code cleanup
02.04.2013.
- all maps extracted
31.03.2013.
- database and highscore code completely rewritten and finished
- database is multilingual now (need translations of course)
- comments page will show you demo TXT if you hover "download"
- comments page will show you map if you hover map name
- updated tapatalk
- other fixes
29.03.2013.
- finally finished first part of highscore code (ALL)
- created comments for every single demo! (still some bugs...)
- added latest 5 comments to first page
- fixed some db issues
24.03.2013.
- finished/updated code for current records
- tool for time conversion
23.03.2013.
- finally updated rules page
- fixed mobile page, now menu is shown, database is correctly displayed, report bugs pls
22.03.2013.
- more sql optimization for current records and highscores (not working online yet)
- db fixes (vdgg)
- new 403 page
19.03.2013.
- sql optimization
- some site sleanup
12.03.2013.
- more db fixes (thnx to Archy, vdgg, Altima)
- sortable columns per map only records
- new style and settings active
- more page fixes (Archy is the man)
- old COMPET-N forum is broken... can't find the reason
- new 404 and 500 pages

18.02.2013.
- styled public directory listing http://www.doom.com.hr/public/
- changing HTML code TABLE -> DIV (not available yet for public)
- settings per visitor (style, gallery, forum, servers, etc) (not available yet for public)
- some database fixes (thank you Archy)
08.02.2013.
- when you click on movies you will get actual records now, not all like it was till now, but you can show all records by clicking on show all records
- old forum updated to latest YaBB: http://doom.com.hr/compet-n/oldforum/
07.02.2013.
- more database optimization, still need to speed up highscore query, but normal records query is at least 40% faster now
- when showing all records for some player, current records will be in green, other in gray example
- doom page is pretty slow in combination with database so I recommend to use database on this linkfor faster browsing
- fixed some plutonia missing demos and wrong filnames reported by Jartapran
- added code for displaying maps in tooltips while hovering map collumn: http://www.doom.com.hr/compet-n/databas ... category=1
02.02.2013.
- some work on Heretic-N database was done
- few COMPET-n database fixes
12.11.2012.
- reworked database editor, fixes, new options
- some records fixed: date & player (doom, doom 2, hr)
02.11.2012.
- country and continent highscore
- again reworked maps, secrets are shown now after map (15 -> 15S, 31 -> 31S)
- total speedruning time
- going over record time with mouse will show in tip prboom/nomonsters time for that map
31.10.2012.
- reworked cn_maps.sql
- reworked cn_records.sql to comply with new cn_maps.sql
- more database options, maps are now shown for all WAD's, maps and players listing (previous/next)
- working on country and continent highscore
28.10.2012.
- all known PWAD records are in database. What now? Well, I'd like to ask every player to check his demos/records/filenames if possible and check his score so I could iron out any bugs in calculation if there is any

27.10.2012.
- MM2 speed and nightmare done, vdgg finished all Requiem
- fixed AV and MM2 highscores
25.10.2012.
- finished MM nm, nm100s and tyson, vdgg did RQ speed and some nm
23.10.2012.
- MM speed done, vdgg finished Requiem Max, I wonder when did AdamH found time to play, last few months I played only few hours just to get back in shape and make one demo...


21.10.2012.
- finished all HR records
- since I have some troubles with queries, decided to create test database and add tables with maps for every wad
- I started to write my COMPET-N admin start up and how I migrated to MySQL on my personal blog
17.10.2012.
- finished with HR MAX, NM100s and Pacifist, vdgg started with Requiem records
15.10.2012.
- improved highscore, now you can select highscore per game, IWAD, PWAD or all combined

+ higscore is almost the same as old one and should be official now, wheee! Anyway, it should be easy to hunt bugs now
- added database stats on start to show number of records, players, first and last demo (and more later

- fixed all Doom 2 pacifist demos

- other database fixes
- made "thanks" icon for lucid lime theme and fixed theme
- removed PWAD demo upload from menu since everything is done by one link one
- HR max demos continued
14.10.2012.
- finally fixed highscore calculation for COMPET-N database
+ noticed some Doom2 pacifist demos are missing! (need to import them again from backup)
12.10.2012.
- added Hell Revealed speed and nightmare demos, max in progress
- reordered and removed some duplicated demos in compet-n directory
08.10.2012.
- some work on Competition database, cleaning and optimizing
- Competition Doom v0.2.2 in progress: metadata and second strafe
07.10.2012.
- work on Competition database (miliseconds) and interface is almost done - http://doom.com.hr/competition.php
- records can be sorted by map, player, country, time and date
- points are much better calculated but code needs optimization, and movies are not calculated yet
- changed BBcode "spoiler" to "hide" and improved it
- added two smilies
- added and modified new dark theme, try it here: http://doom.com.hr/forum/index.php?style=3
- merged rules and FAQ for COMPET-N, no point to have it separated
- added Doom 3 Ressurection of Evil codes - http://doom.com.hr/?page=doom_3_codes
- Competition Doom v0.2.1 BETA released: http://www.doom.com.hr/forum/viewtopic.php?f=10&t=103
- Competition Doom (short: cndoom) is now Chocolate doom branch: http://www.chocolate-doom.org/wiki/inde ... oom-branch
21.09.2012.
- players page - http://www.doom.com.hr/index.php?page=compet-n_players
- upgraded tapatalk forum plugin, again

- working on Competition Doom (Chocolate Doom fork), v0.2.0 BETA soon to be released
- some changes to MySQL database and implementation of new records with miliseconds/gametics
- fixed database editor, implemented adding new records to it (miliseconds/gametics)
04.09.2012.
- removed Zdaemon scripts since they do not work for 1.09

- working on COMPET-N player page, player data will be stored in new database
- upgraded tapatalk forum plugin and forum itself
01.09.2012.
- COMPET-N redesigned, new logo
- Kimo Xvirus added all AV demos to new database
- working on db editor most of the time
19.08.2012.
- totaly new COMPET-N theme is almost finished, needs few more fixes but it will be applied soon, thank you Q!
- created Competition forum group
- more work on database interface for moderators/admins: http://doom.com.hr/db/ -> COMPET-N moderators needed!
- finished with simple database output (no scores/country yet): http://www.doom.com.hr/?page=compet-n_database
- still need to fix time on database output

09.08.2012.
- creating interface for database maintenance (add/edit players or records)
08.08.2012.
- redesigned database structure to fit our needs
- created JSON database output for mobile devices (Dashiva wants to build iPhone app!) I think that's awsome

- example of database output: http://doom.com.hr/baza/list.php - not working anymore!
07.08.2012.
- completed database conversion!

06.08.2012.
- work on PHP code for database
05.08.2012.
- working on MySQL database and PHP/jQuery script, importing Doom 1, Plutonia and TNT
04.08.2012.
- small changes to demo upload script, tweaked upload size, separate config file but needs more fixing/tweaking
30.07.2012.
- finished adding all demos! YAY!
- Sedlo in the meantime added lots of ZDaemon 1on1 demos
29.07.2012.
- finished adding all Plutonia demos
- made small forum modifications to prosilver
- added back online icon but smaller
- started rip thread
25.07.2012.
- moved whole page to another (faster) server
20.07.2012.
- added part of Plutonia nightmare
- forum now supports Tapatalk mobile application
14.07.2012.
- added Plutonia speed and max
- addedBBcodes for Plutonia
- added and modified another forum skin/style subsilver2
24.06.2012.
- added Ultimate Doom speed and tyson
- addedBBcodes for Doom
- added main title for forum
22.06.2012.
- added all TNT demos to news and old database
- Archy started work on Plutonia demos!!!

- fixed wrong link for old Incoming
- fixed forum private message settings, hope that's the last one

19.06.2012.
- did some code optimization on doom.com.hr, added configurable/translate-able title file for most pages
17.06.2012.
- added TNT speed + max records to news and old database
- imported/converted all current players and Doom 2 data to MySQL
- more MySQL Doom 2 testing: http://doom.com.hr/images/wip/2012_06_17_cn_mysql.jpg
15.06.2012.
- COMPET-N links for rules, about and faq on "old" page now leads to new pages
- activated COMPET-N style when viewing COMPET-N pages, still needs more tweaking and "new" logo
- added TNT NM records to news and old database
13.06.2012.
- fixed many links in archive pages
- added missing pacifist map07
- more MySQL testing: http://doom.com.hr/images/wip/cn_db1_wip.png
12.06.2012.
- started with COMPET-N database conversion to MySQL, created records and players table, importing of records works, need more polishing http://doom.com.hr/images/wip/db_2012_06_12.png
- crunching SQL... many thinking what and where and how...
- imported last Doom 2 COMPET-N demos (tyson)
11.06.2012.
- some compet-n styling
08.06.2012.
- importing Doom 2 COMPET-N demos (nm, nm100s, respawn, speed, tyson)
- continue work on options / COMPET-N styles
07.06.2012.
- finished merging phpbb3 and start site (phbb3 login on start)
- working on options / COMPET-N styles
- WIP for Compet-n page by Alen 'Q' Stojanac: http://doom.com.hr/images/wip/dc1.jpg and http://doom.com.hr/images/wip/dc2.jpg. If there is anyone who would like to create new style for doom.com.hr/COMPET-N/Challange let me know, I'll be glad to send PS files.
- imported Doom 2 COMPET-N demos (movies)
- challenge demos uploaded
- edited forum template, removed some things (bb code status, rage, doom4 and copyright for more space, sry phpBB coders)
- clicking on forum logo will open http://www.doom.com.hr
06.06.2012.
- forum language defaulted to American English
- enabled forum Avatars, if you want custom Avatar send link to it and we'll reconsider using it
- more forum languages (American English, Czech, Finnish, French & German)
- fixed COMPET-N rules (MAP07), thnx vdgg
- fixed COMPET-N pwad uploading and nostalgia demo links, thnx Archy
- new "Suggestions" forum section
- fixed COMPET-N nostalgia e1m4, and e1m4-3 links, thnx Archy
- added ~130 custom smilies for more fun
- added ranks (noob-0, player-100, veteran-500, pro-1000, master & nightmare are special)
- started merging phpbb3 and start site (phbb3 login on start) + site options and more
- fixed some minor COMPET-N stuff, thnx Archy
05.06.2012.
- started merging "old" COMPET-N page with doom.com.hr for easier maintainance, pages done: uploading, rules, faq, incoming, about and news
- edited COMPET-N logo since I don't have original source for COMPET-N logo, anyone?
- added COMPET-N style to css files
- when opening any COMPET-N page (except incoming/public), site logo will change to COMPET-N logo
- modified variables for all pages so we can do multilingual doom.com.hr/COMPET-N page, some old links will not work, like this one http://doom.com.hr/index.php?page=hr.about_us.php, now it's http://doom.com.hr/index.php?page=about_us.php, and yes, translators are welcome! (Czech, German, Finnish, French, etc.)