[Sidicer]

maptier
Get surf map tier from database (chat/console)

Usage

PHP Code:

# In chat:
!tier / !tier <mapname>

# In console
sm_tier / sm_tier <mapname>
# [Server] surf_nyx map is tier 1! 


Requirements

• Sourcemod and Metamod
• MySQL Database connected to the server (sourcemod/configs/databases.cfg)
• morecolors.inc (For compiling the plugin only)

Setup

Download

1. Grab the latest release from the release page or download from this post
   

   git clone https://github.com/noillt/maptier.git

Prepare the database

1. Create a new database or choose the one you're already using
2. Import surf map tiers into the database:
   
   PHP Code:

   mysql -u username -p database < maplist.sql 


Plugin installation

1. Place plugins and translations into addons/sourcemod/
2. Set maptier-db in addons/sourcemod/configs/databases.cfg
   
   PHP Code:

   "maptier-db"
{
    "driver" "mysql"
    "host" "127.0.0.1"
    "database" ""
    "user" ""
    "pass" ""
} 

3. Restart the server or type sm plugins load maptier in the console to load the plugin.

Configuration

• You can modify the phrases in addons/sourcemod/translations/maptier.phrases.txt
• Change which database is used in addons/sourcemod/configs/databases.cfg (maptier-db)

Notice

• maplist.sql is a direct replica of OuiSURF/Surf_Maps maintained spreadsheet of all the maps.
• We will be updating maplist.sql regurarily to match it.
• Current map count: 819

Changelog

• v0.0.7 - 2023-12-10
  • Added new maps to maplist.sql
  • Current map count: 819
• v0.0.6 - 2023-06-16
  • Added surf_seaside maplist.sql
  • Changed DROP TABLE IF EXISTS for easier update
  • Changed surf_assail, surf_intra, surf_undergrowth tiers fixed
• v0.0.5 - 2023-06-15
  • Fixed Invalid query Handle 0 (error: 4)