1. Welcome to skUnity!

    Welcome to skUnity! This is a forum where members of the Skript community can communicate and interact. Skript Resource Creators can post their Resources for all to see and use.

    If you haven't done so already, feel free to join our official Discord server to expand your level of interaction with the comminuty!

    Now, what are you waiting for? Join the community now!

  2. LOOKING FOR A VERSION OF SKRIPT??:

    You can always check our our Wiki for downloads and any other information about Skript!

Dismiss Notice
This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Skript MySQL with SkQuery

Discussion in 'Skript' started by GameGang10, Mar 10, 2019.

Thread Status:
Not open for further replies.
  1. GameGang10

    GameGang10 Member

    Joined:
    May 5, 2018
    Messages:
    5
    Likes Received:
    0
    English/Englisch:

    Hey, I want to connect my scripts to MySQL. I know how it works. But I have a problem.
    If I reload or stope and start with my server, all variables are deleted from the cloud system what is wanted, so that the map resets and all old data is loaded. So I would like to take already registered things from the MySQL again and set to a variable. Example: the player plays and every minute 1 is added to {time.% player%}. if I reload the sever, then {time.% player%} will be back to 0.
    so the {time.% player%} stored in the MySQL should be retrievable against the server.

    Translate with google translator

    German/Deutsch:

    Hey ich möchte meine Skripts mit MySQL verbinden. Dies weiß ich wie es geht. aber ich habe ein problem.
    Wenn ich bei mir mein server Reloade oder stope und starte, werden alle variablen gelöscht vom Cloud System was gewollt ist, damit sich die map zurücksetzt und alle alten daten geladen werden. also möchte ich schon eingetragene sachen aus der MySQL wieder nehmen und zu eine Variable setzen. beispiel: der spieler spielt und jede minute wird 1 zu {time.%player%} dazugezehlt. wenn ich den sever reloade, ist dann {time.%player%} wieder auf 0.
    also soll die {time.%player%} die in der MySQL gespeichert wird wider auf dem server abrufbar sein.
     
  2. Yodaylay22

    Yodaylay22 Member

    Joined:
    Jul 24, 2018
    Messages:
    15
    Likes Received:
    1
    No use Skquery Mysql use Skript DB !
     
  3. GameGang10

    GameGang10 Member

    Joined:
    May 5, 2018
    Messages:
    5
    Likes Received:
    0
    Can you send me all events with MySQL than I can use skript db
     
  4. TPGamesNL

    TPGamesNL Well-Known Member

    Joined:
    Jan 20, 2018
    Messages:
    1,311
    Likes Received:
    73
    Medals:
    You could also create something that deletes the variables.csv file and copies the original variables.csv file back to the server, but that doesn't use MySQL
     
  5. GameGang10

    GameGang10 Member

    Joined:
    May 5, 2018
    Messages:
    5
    Likes Received:
    0
    I will use MySQL because I will do a minigames Server and i will do Stats. The statistics should also be displayed in the lobby
     
  6. TPGamesNL

    TPGamesNL Well-Known Member

    Joined:
    Jan 20, 2018
    Messages:
    1,311
    Likes Received:
    73
    Medals:
    In that case, you make every variable that should be reset afterwards start with a certain string (e.g. '{tempvar::something}') and when you stop the server, it executes a code that deletes {tempvar::*}, which will delete all of the variables in the MySQL database.
     
  7. GameGang10

    GameGang10 Member

    Joined:
    May 5, 2018
    Messages:
    5
    Likes Received:
    0
    You don’t under stand me. When I stop and start the server the server reset to the last time when I copied the server
     
  8. TPGamesNL

    TPGamesNL Well-Known Member

    Joined:
    Jan 20, 2018
    Messages:
    1,311
    Likes Received:
    73
    Medals:
    Then make a program that deletes the server and copies the original server to the folder
     
  9. GameGang10

    GameGang10 Member

    Joined:
    May 5, 2018
    Messages:
    5
    Likes Received:
    0
    I have a Programm that deletes the server because wegen he deletes the server he is deleting alle settings, that ist the reson Why i would like to use MySQL. Pls don’t answer if you can’t help me
     
Thread Status:
Not open for further replies.
Loading...