[mrsmith]

Originally Posted by Yourkind123 Hii! Can anyone please help me set up a MySQL Database?? I have no idea of how!!

Feel free to post your problem in your post. It may helping others.

How to Mysql:

1.
Server in Stamm.cfg (Options)

// Your Stamm Table Name. It appends '_<serverid>' at the end! // - // Default: "STAMM_DB" stamm_table_name "STAMM_DB"

Enter your Stamm Table Name:
first Server with Default is: STAMM_DB_1 (it will auto add _1)
below there is a cvar: stamm_serverid "1".
--
2.
Server in sourcemod/configs/databases
Add:

"stamm_sql" { "driver" "mysql" "host" "ServerIP(localhost)" "database" "Databasename(not Stamm_DB_1 .. the name of the Database)" "user" "Databaseuser" "pass" "Databaseuser" }

!!! If the Database and the Server is not on the same host (localhost) your Database have to be extern !!!
3.
On Webserver Server/config.php

$servername = ""; // DB hostname $dbusername = ""; // DB username $dbpassword = ""; // DB password $dbname = ""; // DB name $table = "STAMM_DB_1"; // Name of your Stamm Table

(Now you have to enter _1 or the number of your Server(stamm_serverid "1"))

4. Upload dbsql.sql
You can find this file in the root of the webinterface.zip or on github: Link
Just go to your Mysql Database Interface, klick your Databasename(If Stamm_DB_x is allready created, ignore it(Dont klick on this, klick on your Databasename). Go on "Import",
simple upload the file.

5. Start your Server
6. Visit your Stamm Page

---------------------
Your Mysql should look like this:

Databasename:
payments
Stamm_DB_1
Stamm_DB_1_Happy
---------------------

If you have any questions , feel free to post it.

[ApexPredator]

Originally Posted by Popoklopsi Sounds good The main problem currently is, that i have to put each feature in the auto downloader. That's really annoying^^. So i want to change my auto downloader system first, so you can directly change the .cfg file and i don't have to include each convar with input fields. Than i want to fix some minor issue with the webinterface and stamm. Also my aim is an better overview over the hole stamm system, include a much better documentation. After that i like to add a lot of new features and release stamm 2.2 Final, which displace the currently final version.

Is there anything I can do to help on the testing side of things?
Also do you have an estimated release date?
Also, can you tell me how (or where to find the info) to make the attacker effects work on a chance? like to burn enemy or for knife infect, there is X chance?

[Aim4Fame]

Hallo popo,
ich kann das neue stamm script nichtmehr compilen.
Er sagt: ...\stamm/sqlib.sp(26) : fatal error 120: cannot read from file: "stringescape"

[dordnung]

Originally Posted by ApexPredator Is there anything I can do to help on the testing side of things? Also do you have an estimated release date? Also, can you tell me how (or where to find the info) to make the attacker effects work on a chance? like to burn enemy or for knife infect, there is X chance?

Currently i'm on an other project, which i will release today, after that stamm will get a bit more attention.^^ Maybe i can add this, too.

Originally Posted by Aim4Fame Hallo popo, ich kann das neue stamm script nichtmehr compilen. Er sagt: ...\stamm/sqlib.sp(26) : fatal error 120: cannot read from file: "stringescape"

You need this snippet^^:

https://forums.alliedmods.net/showthread.php?t=212230

[Aim4Fame]

thx and where can i find all includes like the updater?

[dordnung]

Here:

Updater
Colors

[[-NiN-] Decoy]

Idea for when you have time to work on this, can you maybe input a kill modifier for weapons (knife x3, pistol x2... so on and so forth)

Great work, thanks!

[ApexPredator]

Originally Posted by Popoklopsi Sounds good The main problem currently is, that i have to put each feature in the auto downloader. That's really annoying^^. So i want to change my auto downloader system first, so you can directly change the .cfg file and i don't have to include each convar with input fields. Than i want to fix some minor issue with the webinterface and stamm. Also my aim is an better overview over the hole stamm system, include a much better documentation. After that i like to add a lot of new features and release stamm 2.2 Final, which displace the currently final version.

When you make the new version, will the database change?
So if I put stamm back on my server, will players still have their lvls and points if I update to new version?

[mrsmith]

The old Database will be compatible with the new Patch. You may have to start a script on your Mysql but i think you dont have to. Players will still have all their lvls and points

[dordnung]

Originally Posted by [-NiN-] Decoy Idea for when you have time to work on this, can you maybe input a kill modifier for weapons (knife x3, pistol x2... so on and so forth) Great work, thanks!

Yes, sounds great!

Originally Posted by ApexPredator When you make the new version, will the database change? So if I put stamm back on my server, will players still have their lvls and points if I update to new version?

Like mrsmith said, no one loses his points, stamm converts the database how it needs it.




I already updated the downloader, so it's easier for me to add new features.

http://popoklopsi.de/stamm/downloader/test/