Hello all, rnrnI have been trying to find some information to help me with coding of a pluginrnthat uses a MySQL database.rnrnI will tell you what I'm wanting to achieve so if you can think of a better way of doing it just say.rnrnI want to use Deagles Map management for map rotation on my server.rnI wish to be able to enable and disable the maps through a web front,rnSo to save admins from touching the server files.rnrnI'm able to do the web page side fine, so don't need help there.rnrnI though of two ways do achieve this.rnrnFirst:rnMake a new plugin to wright over the existing .ini files with a command in serverrnlike "amx_reloadmaps"rnThat would get the plugin to read a table in the database and wright that table to a .ini replacing the existing file used by Deagles Map management.rnrnSecond:rnEdit the .sma file so that it is able to read straight from the necessary table for the list of maps.rnAlso i would like to edit the .sma so it would upload to a tables for some light stats,rnLike how many votes that map has had total, how many times a map has been nominated, rnand that's probably it, as i wish to show the admin how and what maps are liked by the players.rnrnThe second method is my preferred way as, it offers me the stats.rnrnAny help would be great.

Lolz,rnI searched all through there and never came across those plugins.rnrnAnother question is when fetching the cvar strings for the SQL it says to get the one i have setup for my AmxBans.rnrn

public sql_init() {rn    new host[64], username[32], password[32], dbname[32], error[32]rn	rn    get_cvar_string("amx_sql_host",host,64)rn    get_cvar_string("amx_sql_user",username,32)rn    get_cvar_string("amx_sql_pass",password,32)rn    get_cvar_string("amx_sql_db",dbname,32)

public sql_init() {rn    new host[64], username[32], password[32], dbname[32], error[32]rn	rn    get_cvar_string("amx_maps_sql_host",host,64)rn    get_cvar_string("amx_maps_sql_user",username,32)rn    get_cvar_string("amx_maps_sql_pass",password,32)rn    get_cvar_string("amx_maps_sql_db",dbname,32)

Whats the diffrence between the two includes?nnAs i found some of the database ones use the dbi & not sqlxnn

 n#include <dbi>n#include <sqlx>n

Thanks for your help so far!nnIts going to be like 3000 lines when im done,nShould i split the plugin up into smaller plugins?nWould this help with like any lagg?nnAlso i want to get the plugin to auto download the maps from thendatabase, every x amount of maps. nHow would I do this?nIm making a command of "amx_reloadmaps" to load the maps, I neednto issue that every x amount of maps right?nnThanks.

After I posted I decided to scrap that idea, as like you said "start small"nnWould single large plugin create more lagg over smaller ones, eg, if 3000 lines splitninto smaller plugins? (just wondering :P)nnSo far i have got it logging into the database and creating two different tablesnwith there fields.nnPlanning on filling these fields with something, then as you said "write it to a test file"nnSo will get back when i managed it, or if i get stuck :DnThanks