smrealms / smr

Space Merchant Realms open-source game engine
http://www.smrealms.de
GNU Affero General Public License v3.0
25 stars 15 forks source link

Display News: 4 tabs - All news, Player Deaths, NPC Deaths, PRs/PBs #29

Open Red-Cross-Knight opened 12 years ago

Red-Cross-Knight commented 12 years ago

Ref: http://smrcnn.smrealms.de/viewtopic.php?f=102&t=11460&start=10

4 tabs - All news, Player Deaths, NPC Deaths, Port Raids/Planet Shots

Could be displayed using: jquery UI tabs -- http://jqueryui.com/demos/tabs/

Curufir commented 12 years ago

I think efficiency requires amending "news" DB table to add an extra type for the message otherwise there will be too much regexp going on to perform well. Over to Page to do DB change if he thinks it's required.

Page- commented 12 years ago

Yeah, it would probably be good to have, I can probably write SQL queries that would update the existing news entries, we already have the type column that could be repurposed - currently it's only regular/breaking news (although breaking news can also be planet news, so dunno if that'd work).