MySQL Veri Göndermiyor!

Bartuzen

Bedrock Kaşifi
En iyi cevaplar
0
SQLLibrary eklentisini kurdum. Config'de gerekli ayarları yaptım. Hata vermiyor. Fakat siteye veri de göndermiyor.
Config Dosyam:
Kod:
databases:
    # Databases to store variables in. These can either be used as a simple one-server-storage
    # where variables are written constantly but only read at server start,
    # or as a connection between multiple servers by monitoring the database(s) for changes.
    #
    # You can define as many databases as you want, just make sure to choose a distinct name for each one, and don't forget to set all options correctly.
    #
    # To be able to use a database you'll need to download the plugin 'SQLibrary' from http://dev.bukkit.org/server-mods/sqlibrary/files/
    # and install it in your server's plugin directory like other plugins.
    #
    # Please note that '/skript reload' will not reload this section, i.e. you'll have to restart Skript for changes to take effect.
   
    # Each database definition must be in a separate section. You can choose any name for the sections, as long as it's not already used.
    puan:
        # an example database to describe all possible options.
       
        type: MySQL
        # The type of this database. Allowed values are 'CSV', 'SQLite', 'MySQL' and 'disabled'.
        # CSV uses a text file to store the variables, while SQLite and MySQL use databases, and 'disabled' makes Skript ignore the database as if it wasn't defined at all.
       
        pattern: puan.*
        # Defines which variables to save in this database.
        # This pattern uses Regex syntax, e.g. use 'db_.*' (without the quotes) to store all variables prefixed with 'db_' in this database,
        # or use '.*' (the default value) to store all variables here (recommended for the last database in this list, as otherwise some variables might not be saved).
        # Please note that variables are only stored in one database, and databases are checked from top to bottom,
        # e.g. if a variable matches the topmost database's pattern it will be saved there and nowhere else.
        # BTW: Patterns are checked in a separate thread, i.e. your server likely won't run slower when using complicated patterns.
       
        monitor changes: true
        monitor interval: 5 seconds
        # If 'monitor changes' is set to true, variables will repeatedly be checked for updates in the database (in intervals set in 'monitor interval').
        # ! Please note that you should set 'pattern', 'monitor changes' and 'monitor interval' to the same values on all servers that access the same database!
       
        # == MySQL configuration ==
        host: mysql1.000webhost.com # Where the database server is located at, e.g. 'example.com', 'localhost', or '192.168.1.100'
        port: 3306 # 3306 is MySQL's default port, i.e. you likely won't need to change this value
        user: a3264806_123
        password: *****
        database: a3264806_123 # The database to use. Skript will automatically create a table 'variables21' in this database if it doesn't exist
                        # (If the table exists but is defined differently that how Skript expects it to be you'll get errors and no variables will be saved and/or loaded)
       
        # == SQLite/CSV configuration ==
        file: ./plugins/Skript/variables.db
        # Where to save the variables to. For a CSV file, the file extension '.csv' is recommended, but not required, but SQLite database files must end in '.db' (SQLibrary forces this).
        # The file path can either be absolute (e.g. 'C:\whatever\...' [Windows] or '/usr/whatever/...' [Unix]), or relative to the server directory (e.g. './plugins/Skript/...').
       
        backup interval: 2 hours
        # Creates a backup of the file every so often. This can be useful if you ever want to revert variables to an older state.
        # Variables are saved constantly no matter what is set here, thus a server crash will never make you loose any variables.
        # Set this to 0 to disable this feature.
Kullandığım Skript:
Kod:
command /s:
    trigger:
        add 1 to {puan.%player%}
command /a:
    trigger:
        send "%{puan.%player%}%"
 
S

sergun26

Ziyaretçi
000webhost sanırım dışarıdan bağlantılara izin vermiyordu, başka bir yerden ücretli bir host alıp deneyin. Yada db4free.net üzerinden deneyin.
 

Bartuzen

Bedrock Kaşifi
En iyi cevaplar
0
00webhost sanırım dışarıdan bağlantılara izin vermiyordu, başka bir yerden ücretli bir host alıp deneyin. Yada db4free.net üzerinden deneyin.
Tamam. Bide şöyle bir hata verdiğini farkettim:
Kod:
#!#!
#!#! ===!!!=== Skript variable load error ===!!!===
#!#! Unable to load (all) variables:
#!#! Cannot connect to the database 'puan'!
#!#!
#!#! Skript will work properly, but old variables might not be available at all and new ones may or may not be saved until Skript is able to create a backup of the old file and/or is able to connect to the database (which requires a restart of Skript)!
#!#!
db4free.net'i deneyeceğim.[DOUBLEPOST=1433861110,1433860926][/DOUBLEPOST]Bide şu siteye kayıt olurken zar zor oluyorum :D Sürekli istenen biçimi eşleştirin diyor.
 

Won5

Patates Avcısı
En iyi cevaplar
0
Tamam. Bide şöyle bir hata verdiğini farkettim:
Kod:
#!#!
#!#! ===!!!=== Skript variable load error ===!!!===
#!#! Unable to load (all) variables:
#!#! Cannot connect to the database 'puan'!
#!#!
#!#! Skript will work properly, but old variables might not be available at all and new ones may or may not be saved until Skript is able to create a backup of the old file and/or is able to connect to the database (which requires a restart of Skript)!
#!#!
db4free.net'i deneyeceğim.[DOUBLEPOST=1433861110,1433860926][/DOUBLEPOST]Bide şu siteye kayıt olurken zar zor oluyorum :D Sürekli istenen biçimi eşleştirin diyor.
puan adlı veritabanına bağlanamamış...
 

Bartuzen

Bedrock Kaşifi
En iyi cevaplar
0
puan adlı veritabanına bağlanamamış...
Dışarıdan bağlantılara izin vermediği içinmiş. db4free.net de sürekli istenen biçimi eşleştirin diyor deniyom deniyom ama bulamıyom :D[DOUBLEPOST=1433861416,1433861378][/DOUBLEPOST]Tamam yaptım. Şimdi deniyorum.
 

Bartuzen

Bedrock Kaşifi
En iyi cevaplar
0
Tabloda hangi stünlar var
Pardon yanlış söylemişim. Orada otomatik oluşturulacağı yazıyordu.
Skript will automatically create a table 'variables21' in this database if it doesn't exist[DOUBLEPOST=1433865369,1433861777][/DOUBLEPOST]
000webhost sanırım dışarıdan bağlantılara izin vermiyordu, başka bir yerden ücretli bir host alıp deneyin. Yada db4free.net üzerinden deneyin.
Hostinger dışarıdan bağlantılara izin veriyor mu?
 
Üst