[minimiller]

Map Suggestions
By Stewie!

Description:
So your server is pretty popular, but it seems that the same maps are being played over and over again.
The people that use your server will most probably have ideas of new maps to put on the server but they have no way of contacting you and letting you know.
This plugin allows people on your server to type "amx_suggestmap <mapname>" in console and suggest a map
This command will update an SQL database containing todays date, their name, their steamID and their suggested map.
Inside map_suggestions.zip there is a .php file which can display this information on your website/webpage.
When a player suggests a map, they will get a confirmation message saying that their request has been accepted.

Commands:
amx_suggestmap <mapname> - Suggest a map to add to the server
amx_removemap <mapname> - Remove a map from the database [Admin only]

Coming soon:
If i learn more PHP codes additional web-related stuff will appear including votes on each map etc.
More features and cvars to make it easier to manage

Notes:
Remember to make an SQL database, user, and password before trying to use this plugin
You need to edit the .php aswell if you want to show this info on your website
You also need to add these lines to your amxx.cfg or server.cfg

ms_sql_host ""
ms_sql_user ""
ms_sql_pass ""
ms_sql_db ""

I have also included the php code if you want to display the information on your website

This is my first PHP/SQL related plugin so sorry about any random code sloppiness

Changelog (+ Added - Removed ~ Changed # Other)
v1.3
+ Added ML [thx crazyeffect]
# Learnt XHTML so made the php code compliant

v1.2
# Fixed the plugin. Should work now

v1.1
+ Added the date field
+ Added "amx_removemap <mapname>" for admins to remove maps from the database
~ Changed the names of the cvars so you can use different databases to the SQL admins

v1.0
# Public release

[xPaw]

Mhhh, hi.

[DruGzOG]

:O

[tuty]

:O

[Arkshine]

You should use your own cvars and not the default which may be already used for admin_sql or amxbans for example.

[AntiBots]

Put an Update. Because someone can Flood the SQL Server.

Also check if is a valid map.

amx_suggestmap "I Love Spam "

You understand me?

[crazyeffect]

Gonna try & gonna give feedback

[minimiller]

Originally Posted by Arkshine You should use your own cvars and not the default which may be already used for admin_sql or amxbans for example.

i was thinking about that, but i aparently never changed it

Originally Posted by AntiBots Put an Update. Because someone can Flood the SQL Server. Also check if is a valid map. amx_suggestmap "I Love Spam " You understand me?

How would i stop flooding?
ive put the steamID field in anyway so u can ban any1 who abuses it
i was thinking about adding another table with steamIDs in so they cannot use it
i was gonna put a map checker in aswell, but there is so specific map name layout
i suppose i could check if they include de_ cs_ aim_ etc. but what about random maps that hardly any1 knows?

[crazyeffect]

It works!

I suggested map de_lol

& look whats standing here

[minimiller]

Originally Posted by crazyeffect It works! I suggested map de_lol & look whats standing here

thanks dude <3

not bad seeing as i havent submitted a plugin in about a year :p