Sql help???

[Freakgood]

Hi need some help dont relay know what i should do and how 2 do it correcly..


Download the lp_sql.zip, extract it and run the lp.sql in the database of your choice, but remember, the database also have to contain the table sm_admins and this database have to be the default one in /addons/configs/databases.cfg
Download the plugin (lp.smx), move it to your plugin folder
Restart your server, so that souremod can create the config file of the plugin (/cfg/sourcemod/plugin.lp.cfg)
Edit the config file after your mind
Restart the server again to activate your settings

[Edge100x]

Download the lp_sql.zip, extract it and run the lp.sql in the database of your choice, but remember, the database also have to contain the table sm_admins

It sounds like this would need to be done through your webhosting account. I would recommend using phpMyAdmin to import the .sql file, but you could also do it through the command line. Before importing the .sql file, you'll need to create a database through the "Databases" page (you can choose any name).

and this database have to be the default one in /addons/configs/databases.cfg

It sounds like this would be on your game server, and they probably actually mean "/addons/sourcemod/configs/databases.cfg". You'll have to edit that file and change the "default" section to have the database information corresponding to your webhosting database. By this, I mean that the database name would need to match the one that you created on the "Databases" page earlier, and the other information would need to match what is given on that same page.

Download the plugin (lp.smx), move it to your plugin folder

This would also be on your game server. It means to upload lp.smx to your "/addons/sourcemod/plugins" folder. Any plugin file in that folder is automatically loaded and executed by Sourcemod when it loads.

Restart your server, so that souremod can create the config file of the plugin (/cfg/sourcemod/plugin.lp.cfg)

You can do this through the "Server control" page for the game server.

Edit the config file after your mind

This is in reference to checking out the file that was just created. You can examine it through the "File manager" page or via FTP.

Restart the server again to activate your settings

[Freakgood]

think u can do it 4 me xD like :


It sounds like this would be on your game server, and they probably actually mean "/addons/sourcemod/configs/databases.cfg". You'll have to edit that file and change the "default" section to have the database information corresponding to your webhosting database. By this, I mean that the database name would need to match the one that you created on the "Databases" page earlier, and the other information would need to match what is given on that same page.

made everything els.. but dont realy understand how 2 do that.. sorry have an database on the web on ZombieBiteAction,,

[Edge100x]

Please take a look at your "Databases" page. After "Currently configured databases are listed below. You can access these databases with installed software using this information: " is the section that contains information that you need to put in the databases.cfg file as I described. The connection from the game server is considered an "external connection", so you'll have to adjust accordingly.

[Freakgood]

Please take a look at your "Databases" page. After "Currently configured databases are listed below. You can access these databases with installed software using this information: " is the section that contains information that you need to put in the databases.cfg file as I described. The connection from the game server is considered an "external connection", so you'll have to adjust accordingly.

man o man... this is trickly


"Databases"
{
"driver_default" "mysql"

"default"
{
"driver" "default"
"host" "3306"
"database" "zombiebiteaction_zbacoop"
"user" "stats"
"pass" ""
//"timeout" "0"
//"port" "0"
}

"storage-local"
{
"driver" "sqlite"
"database" "zombiebiteaction_zbacoop"
}

"clientprefs"
{
"driver" "sqlite"
"host" "3306"
"database" "zombiebiteaction_zbacoop"
"user" "stats"
"pass" ""
//"timeout" "0"
//"port" "0"
}
}


Does it look good man? or is it fuckd up? and also.. removd the pass so no 1 could log in 2 it

[Edge100x]

You only need to edit the "default" section. For "host", you need to use your website DNS (the Databases page talks about this), and not 3306. You need to uncomment the "port" line and put "3306" there. "user" will be your MySQL login name, from the "Databases" page.

[Freakgood]

You only need to edit the "default" section. For "host", you need to use your website DNS (the Databases page talks about this), and not 3306. You need to uncomment the "port" line and put "3306" there. "user" will be your MySQL login name, from the "Databases" page.

Finally i can see that the plugin.ip was created inside cfg/sourcemod so should be working now thx 4 all the help !

[Edge100x]

Glad to hear it

[Freakgood]

Glad to hear it

Well plugin works awsome .. but not it says your not allowd 2 use this command some times? anyides why and how 2 fix it?

[Freakgood]

Glad to hear it

Well plugin works awsome .. but not it says your not allowd 2 use this command some times? anyides why and how 2 fix it?

Found the problem it was inside the sql part...