Mysql Konum Çekmiyor

[doqu10]

Merhaba, xpdevilin analttığı basit bir mysql sistemi kullanıyorum. Kendim oyuncuların konumunu çekip kaydedicek şekilde ekleme yaptım, ama oyundan çıktığımda konum değerlerini 0 0 0 olarak gösteriyor. Yani değer çekmiyor OnPlayerDisconnectteki kodları ekliyorum, acaba nerde yanlış yapıyor olabilirim?

PAWN Kodu: Seç

public OnPlayerDisconnect(playerid, reason)
{
        new query[128], isim[24], Float:posx, Float:posy, Float:posz;
        GetPlayerName(playerid, isim, 24);
        GetPlayerPos(playerid, posx, posy, posz);
        format(query, sizeof(query),"UPDATE `Kullanicilar` SET `Skor`='%d',`Para`='%d','KonumX'='%f','KonumY'='%f','KonumZ'='%f' WHERE `Isim`='%s'", GetPlayerScore(playerid), GetPlayerMoney(playerid), posx, posy, posz, isim);
        mysql_query(mysqlC, query);
        return 1;
}

[Eamon]

mysql loglarına bir göz at genelde yazar orda

[doqu10]

mysql loglarına bir göz at genelde yazar orda

mysql loglarına nerden ulaşabilirim?

[Superman]

mysql loglarına bir göz at genelde yazar orda

mysql loglarına nerden ulaşabilirim?

oyun_modu>Logs>plugins>mysql-log

[doqu10]

Hocam ben pek bir şey anlamadım ama sebebi vs yazıyormu bilmiyorum aşağıya bırakıyorum kodları

PAWN Kodu: Seç

[19:58:24] [WARNING] mysql_connect: no password specified
[12:09:58] [WARNING] mysql_connect: no password specified
[12:10:02] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #2002 'Can't connect to MySQL server on 'localhost' (10061)'
[12:10:18] [WARNING] mysql_connect: no password specified
[12:16:11] [WARNING] mysql_connect: no password specified
[12:17:52] [WARNING] mysql_connect: no password specified
[12:24:04] [WARNING] mysql_connect: no password specified
[12:28:59] [WARNING] mysql_connect: no password specified
[12:29:04] [WARNING] mysql_connect: no password specified
[12:35:34] [WARNING] mysql_connect: no password specified
[12:39:18] [WARNING] mysql_connect: no password specified
[12:45:59] [WARNING] mysql_connect: no password specified
[12:47:15] [WARNING] mysql_connect: no password specified
[14:02:51] [WARNING] mysql_connect: no password specified
[14:07:21] [WARNING] mysql_connect: no password specified
[14:07:42] [WARNING] mysql_connect: no password specified
[14:12:03] [WARNING] mysql_connect: no password specified
[14:14:14] [WARNING] mysql_connect: no password specified
[14:17:23] [WARNING] mysql_connect: no password specified
[14:27:51] [WARNING] mysql_connect: no password specified
[22:55:20] [WARNING] mysql_connect: no password specified
[22:55:35] [WARNING] mysql_connect: no password specified
[22:56:04] [WARNING] mysql_connect: no password specified
[22:56:16] [WARNING] mysql_connect: no password specified
[23:13:04] [WARNING] mysql_connect: no password specified
[23:16:43] [WARNING] mysql_connect: no password specified
[23:32:57] [WARNING] mysql_connect: no password specified
[23:34:57] [WARNING] mysql_connect: no password specified
[23:57:27] [WARNING] mysql_connect: no password specified
[23:57:31] [WARNING] mysql_connect: no password specified
[00:08:18] [WARNING] mysql_connect: no password specified
[00:09:34] [WARNING] mysql_connect: no password specified
[00:12:23] [WARNING] mysql_connect: no password specified
[00:13:14] [WARNING] mysql_connect: no password specified
[00:14:42] [WARNING] mysql_connect: no password specified
[00:15:55] [WARNING] mysql_connect: no password specified
[00:23:38] [WARNING] mysql_connect: no password specified
[00:25:13] [WARNING] mysql_connect: no password specified
[00:27:25] [WARNING] mysql_connect: no password specified
[00:29:44] [WARNING] mysql_connect: no password specified
[00:44:02] [WARNING] mysql_connect: no password specified
[09:14:41] [WARNING] mysql_connect: no password specified
[09:14:54] [WARNING] mysql_connect: no password specified
[09:29:29] [WARNING] mysql_connect: no password specified
[09:58:16] [WARNING] mysql_connect: no password specified
[10:14:34] [WARNING] mysql_connect: no password specified
[10:14:41] [WARNING] mysql_connect: no password specified
[10:22:21] [WARNING] mysql_connect: no password specified
[11:16:39] [WARNING] mysql_connect: no password specified
[11:25:50] [WARNING] mysql_connect: no password specified
[11:27:53] [WARNING] mysql_connect: no password specified
[11:32:40] [WARNING] mysql_connect: no password specified
[11:36:07] [WARNING] mysql_connect: no password specified
[11:39:32] [WARNING] mysql_connect: no password specified
[11:41:05] [WARNING] mysql_connect: no password specified
[11:47:13] [WARNING] mysql_connect: no password specified
[11:52:51] [WARNING] mysql_connect: no password specified
[11:54:29] [WARNING] mysql_connect: no password specified
[12:13:41] [WARNING] mysql_connect: no password specified
[12:15:10] [WARNING] mysql_connect: no password specified
[12:17:44] [WARNING] mysql_connect: no password specified
[12:19:40] [WARNING] mysql_connect: no password specified
[12:21:17] [WARNING] mysql_connect: no password specified
[13:26:24] [WARNING] mysql_connect: no password specified
[13:28:34] [WARNING] mysql_connect: no password specified
[13:50:22] [WARNING] mysql_connect: no password specified
[13:55:16] [WARNING] mysql_connect: no password specified
[14:00:58] [WARNING] mysql_connect: no password specified
[14:02:05] [WARNING] mysql_connect: no password specified
[14:12:02] [WARNING] mysql_connect: no password specified
[14:16:50] [WARNING] mysql_connect: no password specified
[14:34:48] [WARNING] mysql_connect: no password specified
[14:36:12] [WARNING] mysql_connect: no password specified
[14:40:33] [WARNING] mysql_connect: no password specified
[14:46:27] [WARNING] mysql_connect: no password specified
[15:09:47] [WARNING] mysql_connect: no password specified
[15:13:06] [WARNING] mysql_connect: no password specified
[15:14:23] [WARNING] mysql_connect: no password specified
[16:03:53] [WARNING] mysql_connect: no password specified
[16:03:58] [WARNING] mysql_connect: no password specified
[16:09:03] [WARNING] mysql_connect: no password specified
[17:16:01] [WARNING] mysql_connect: no password specified
[17:38:25] [WARNING] mysql_connect: no password specified
[17:58:57] [WARNING] mysql_connect: no password specified
[18:16:30] [WARNING] mysql_connect: no password specified
[18:28:34] [WARNING] mysql_connect: no password specified
[18:33:09] [WARNING] mysql_connect: no password specified
[18:33:24] [WARNING] mysql_connect: no password specified
[18:59:49] [WARNING] mysql_connect: no password specified
[19:06:00] [WARNING] mysql_connect: no password specified
[19:10:16] [WARNING] mysql_connect: no password specified
[19:58:11] [WARNING] mysql_connect: no password specified
[20:23:50] [WARNING] mysql_connect: no password specified
[20:44:02] [WARNING] mysql_connect: no password specified
[21:09:00] [WARNING] mysql_connect: no password specified
[21:14:58] [WARNING] mysql_connect: no password specified
[21:15:15] [WARNING] mysql_connect: no password specified
[21:48:03] [WARNING] mysql_connect: no password specified
[22:39:07] [WARNING] mysql_connect: no password specified
[22:39:16] [WARNING] mysql_connect: no password specified
[23:14:31] [WARNING] mysql_connect: no password specified
[15:51:13] [WARNING] mysql_connect: no password specified
[15:51:27] [WARNING] mysql_connect: no password specified
[15:52:13] [WARNING] mysql_connect: no password specified
[17:46:30] [WARNING] mysql_connect: no password specified
[18:03:50] [WARNING] mysql_connect: no password specified
[19:12:54] [WARNING] mysql_connect: no password specified
[19:29:48] [WARNING] mysql_connect: no password specified
[20:52:04] [WARNING] mysql_connect: no password specified
[20:57:52] [WARNING] mysql_connect: no password specified
[21:22:00] [WARNING] mysql_connect: no password specified
[22:45:30] [WARNING] mysql_connect: no password specified
[22:53:05] [WARNING] mysql_connect: no password specified
[23:56:55] [WARNING] mysql_connect: no password specified
[10:08:30] [WARNING] mysql_connect: no password specified
[10:16:54] [WARNING] mysql_connect: no password specified
[10:27:50] [WARNING] mysql_connect: no password specified
[10:36:07] [WARNING] mysql_connect: no password specified
[10:46:17] [WARNING] mysql_connect: no password specified
[10:47:27] [WARNING] mysql_connect: no password specified
[13:25:49] [WARNING] mysql_connect: no password specified
[13:28:06] [WARNING] mysql_connect: no password specified
[13:45:01] [WARNING] mysql_connect: no password specified
[13:45:48] [WARNING] mysql_connect: no password specified
[20:10:59] [WARNING] mysql_connect: no password specified
[23:02:22] [WARNING] mysql_connect: no password specified
[23:29:41] [WARNING] mysql_connect: no password specified
[23:38:43] [WARNING] mysql_connect: no password specified
[23:54:10] [WARNING] mysql_connect: no password specified
[23:57:43] [WARNING] mysql_connect: no password specified
[00:00:28] [WARNING] mysql_connect: no password specified
[00:07:10] [WARNING] mysql_connect: no password specified
[12:48:18] [WARNING] mysql_connect: no password specified
[12:54:53] [WARNING] mysql_connect: no password specified
[12:57:16] [WARNING] mysql_connect: no password specified
[13:01:38] [WARNING] mysql_connect: no password specified
[13:04:07] [WARNING] mysql_connect: no password specified
[14:31:26] [WARNING] mysql_connect: no password specified
[14:32:32] [WARNING] mysql_connect: no password specified
[14:33:38] [WARNING] mysql_connect: no password specified
[18:26:35] [WARNING] mysql_connect: no password specified
[19:27:07] [WARNING] mysql_connect: no password specified
[19:45:46] [WARNING] mysql_connect: no password specified
[19:54:12] [WARNING] mysql_connect: no password specified
[12:44:18] [WARNING] mysql_connect: no password specified
[12:44:35] [WARNING] mysql_connect: no password specified
[13:27:36] [WARNING] mysql_connect: no password specified
[13:38:40] [WARNING] mysql_connect: no password specified
[20:23:15] [WARNING] mysql_connect: no password specified
[11:53:44] [WARNING] mysql_connect: no password specified
[11:53:48] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #2002 'Can't connect to MySQL server on 'localhost' (10061)'
[11:53:52] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #2002 'Can't connect to MySQL server on 'localhost' (10061)'
[11:55:11] [WARNING] mysql_connect: no password specified
[11:57:46] [WARNING] mysql_connect: no password specified
[12:07:04] [WARNING] mysql_connect: no password specified
[12:17:24] [WARNING] mysql_connect: no password specified
[15:18:18] [WARNING] mysql_connect: no password specified
[15:23:04] [WARNING] mysql_connect: no password specified
[10:11:36] [WARNING] mysql_connect: no password specified
[14:51:33] [WARNING] mysql_connect: no password specified
[14:51:45] [WARNING] mysql_connect: no password specified
[16:55:25] [WARNING] mysql_connect: no password specified
[16:58:13] [WARNING] mysql_connect: no password specified
[22:11:24] [WARNING] mysql_connect: no password specified
[22:13:37] [WARNING] mysql_connect: no password specified
[22:20:51] [WARNING] mysql_connect: no password specified
[22:23:08] [WARNING] mysql_connect: no password specified
[22:24:17] [WARNING] mysql_connect: no password specified
[22:25:27] [WARNING] mysql_connect: no password specified
[22:26:55] [WARNING] mysql_connect: no password specified
[22:37:01] [WARNING] mysql_connect: no password specified
[22:39:10] [WARNING] mysql_connect: no password specified
[22:43:39] [WARNING] mysql_connect: no password specified
[15:31:03] [WARNING] mysql_connect: no password specified
[15:31:07] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #2002 'Can't connect to MySQL server on 'localhost' (10061)'
[15:31:14] [WARNING] mysql_connect: no password specified
[15:34:05] [WARNING] mysql_connect: no password specified
[15:43:44] [WARNING] mysql_connect: no password specified
[15:55:25] [WARNING] mysql_connect: no password specified
[16:02:32] [WARNING] mysql_connect: no password specified
[16:03:25] [WARNING] mysql_connect: no password specified
[16:04:31] [WARNING] mysql_connect: no password specified
[16:10:10] [WARNING] mysql_connect: no password specified
[16:11:13] [WARNING] mysql_connect: no password specified
[13:48:37] [WARNING] mysql_connect: no password specified
[13:48:46] [WARNING] mysql_connect: no password specified
[14:17:28] [WARNING] mysql_connect: no password specified
[15:08:08] [WARNING] mysql_connect: no password specified
[15:12:18] [WARNING] mysql_connect: no password specified
[15:15:02] [WARNING] mysql_connect: no password specified
[15:15:41] [WARNING] mysql_connect: no password specified
[15:18:24] [WARNING] mysql_connect: no password specified
[15:19:31] [WARNING] mysql_connect: no password specified
[16:04:51] [WARNING] mysql_connect: no password specified
[16:05:37] [WARNING] mysql_connect: no password specified
[16:06:40] [WARNING] mysql_connect: no password specified
[16:35:52] [WARNING] mysql_connect: no password specified
[16:36:51] [WARNING] mysql_connect: no password specified
[16:38:34] [WARNING] mysql_connect: no password specified
[16:43:13] [WARNING] mysql_connect: no password specified
[17:35:41] [WARNING] mysql_connect: no password specified
[18:05:00] [WARNING] mysql_connect: no password specified
[18:06:43] [WARNING] mysql_connect: no password specified
[19:20:25] [WARNING] mysql_connect: no password specified
[22:15:09] [WARNING] mysql_connect: no password specified
[22:17:19] [WARNING] mysql_connect: no password specified
[22:19:19] [WARNING] mysql_connect: no password specified
[22:20:05] [WARNING] mysql_connect: no password specified
[22:24:33] [WARNING] mysql_connect: no password specified
[22:25:06] [WARNING] mysql_connect: no password specified
[23:19:03] [WARNING] mysql_connect: no password specified
[23:19:47] [WARNING] mysql_connect: no password specified
[23:25:39] [WARNING] mysql_connect: no password specified
[23:29:00] [WARNING] mysql_connect: no password specified
[23:30:39] [WARNING] mysql_connect: no password specified
[08:50:19] [WARNING] mysql_connect: no password specified
[08:50:23] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #2002 'Can't connect to MySQL server on 'localhost' (10061)'
[08:50:27] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #2002 'Can't connect to MySQL server on 'localhost' (10061)'
[08:50:33] [WARNING] mysql_connect: no password specified
[08:51:45] [WARNING] mysql_connect: no password specified
[08:52:59] [WARNING] mysql_connect: no password specified
[08:58:30] [WARNING] mysql_connect: no password specified
[08:59:14] [WARNING] mysql_connect: no password specified
[09:25:12] [WARNING] mysql_connect: no password specified (d:\SAMP\Kullandığım Samp Server\gamemodes\test4.pwn:359)
[09:25:12] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #1049 'Unknown database 'dbalyatesql''
[09:25:12] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #1049 'Unknown database 'dbalyatesql''
[09:25:12] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #1049 'Unknown database 'dbalyatesql''
[09:25:12] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #1049 'Unknown database 'dbalyatesql''
[09:25:28] [WARNING] mysql_connect: no password specified (d:\SAMP\Kullandığım Samp Server\gamemodes\test4.pwn:359)
[09:25:28] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #1049 'Unknown database 'dbalyatesql''
[09:25:28] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #1049 'Unknown database 'dbalyatesql''
[09:25:28] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #1049 'Unknown database 'dbalyatesql''
[09:25:28] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #1049 'Unknown database 'dbalyatesql''
[09:25:56] [WARNING] mysql_connect: no password specified (d:\SAMP\Kullandığım Samp Server\gamemodes\test4.pwn:359)
[09:25:56] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #1049 'Unknown database 'dbalyatesql''
[09:25:56] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #1049 'Unknown database 'dbalyatesql''
[09:25:56] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #1049 'Unknown database 'dbalyatesql''
[09:25:56] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #1049 'Unknown database 'dbalyatesql''
[03:12:34] [WARNING] mysql_connect: no password specified (d:\SAMP\aYENİİ KULLANACAGIM SERVERRRRR\gamemodes\osk.pwn:94)
[03:13:02] [ERROR] error #1064 while executing query "SELECT * FROM 'Kullanicilar' WHERE Isim = 'Dogu'": You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''Kullanicilar' WHERE Isim = 'Dogu'' at line 1 (d:\SAMP\aYENİİ KULLANACAGIM SERVERRRRR\gamemodes\osk.pwn:136)
[03:14:34] [WARNING] mysql_connect: no password specified (d:\SAMP\aYENİİ KULLANACAGIM SERVERRRRR\gamemodes\osk.pwn:94)
[03:14:51] [ERROR] error #1064 while executing query "SELECT * FROM 'kullanicilar' WHERE Isim = 'Dogu'": You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''kullanicilar' WHERE Isim = 'Dogu'' at line 1 (d:\SAMP\aYENİİ KULLANACAGIM SERVERRRRR\gamemodes\osk.pwn:136)
[03:15:57] [WARNING] mysql_connect: no password specified (d:\SAMP\aYENİİ KULLANACAGIM SERVERRRRR\gamemodes\osk.pwn:90)
[03:16:14] [ERROR] error #1064 while executing query "SELECT * FROM 'kullanicilar' WHERE Isim = 'Dogu'": You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''kullanicilar' WHERE Isim = 'Dogu'' at line 1 (d:\SAMP\aYENİİ KULLANACAGIM SERVERRRRR\gamemodes\osk.pwn:132)
[12:52:02] [WARNING] mysql_connect: no password specified (d:\SAMP\Kullandığım Samp Server\gamemodes\test.pwn:43)
[12:52:26] [WARNING] mysql_connect: no password specified (d:\SAMP\Kullandığım Samp Server\gamemodes\test.pwn:43)
[12:52:46] [ERROR] error #1064 while executing query "SELECT * FROM 'Kullanicilar' WHERE Isim = 'Dogu'": You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''Kullanicilar' WHERE Isim = 'Dogu'' at line 1 (d:\SAMP\Kullandığım Samp Server\gamemodes\test.pwn:76)
[12:56:15] [WARNING] mysql_connect: no password specified
[12:57:23] [WARNING] mysql_connect: no password specified
[15:01:55] [WARNING] mysql_connect: no password specified (d:\SAMP\Kullandığım Samp Server\gamemodes\test.pwn:43)
[15:02:08] [WARNING] mysql_connect: no password specified (d:\SAMP\Kullandığım Samp Server\gamemodes\test.pwn:43)
[15:02:43] [ERROR] error #1064 while executing query "SELECT * FROM 'Kullanicilar' WHERE Isim = 'Dogu'": You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''Kullanicilar' WHERE Isim = 'Dogu'' at line 1 (d:\SAMP\Kullandığım Samp Server\gamemodes\test.pwn:76)
[15:13:36] [WARNING] mysql_connect: no password specified
[18:15:55] [WARNING] mysql_connect: no password specified
[18:25:44] [WARNING] mysql_connect: no password specified
[18:27:44] [WARNING] mysql_connect: no password specified
[18:59:47] [WARNING] mysql_connect: no password specified
[19:23:39] [WARNING] mysql_connect: no password specified
[19:26:36] [WARNING] mysql_connect: no password specified
[19:27:44] [WARNING] mysql_connect: no password specified
[19:43:52] [WARNING] mysql_connect: no password specified
[01:34:07] [WARNING] mysql_connect: no password specified
[01:34:11] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #2002 'Can't connect to MySQL server on 'localhost' (10061)'
[01:34:22] [WARNING] mysql_connect: no password specified
[03:35:55] [WARNING] mysql_connect: no password specified
[03:39:49] [WARNING] mysql_connect: no password specified
[03:40:24] [WARNING] mysql_connect: no password specified
[03:40:32] [WARNING] mysql_connect: no password specified
[13:52:27] [WARNING] mysql_connect: no password specified
[13:57:41] [WARNING] mysql_connect: no password specified
[14:14:56] [WARNING] mysql_connect: no password specified
[14:24:07] [WARNING] mysql_connect: no password specified
[14:31:43] [WARNING] mysql_connect: no password specified
[14:34:23] [WARNING] mysql_connect: no password specified
[14:41:55] [WARNING] mysql_connect: no password specified
[17:14:09] [WARNING] mysql_connect: no password specified
[17:14:13] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #2002 'Can't connect to MySQL server on 'localhost' (10061)'
[17:14:20] [WARNING] mysql_connect: no password specified
[17:18:41] [WARNING] mysql_connect: no password specified
[17:18:53] [WARNING] mysql_connect: no password specified
[19:34:48] [WARNING] mysql_connect: no password specified
[19:44:21] [WARNING] mysql_connect: no password specified
[19:47:58] [WARNING] mysql_connect: no password specified
[20:35:27] [WARNING] mysql_connect: no password specified


[Eamon]

Sunucunuz, mysql veri tabanı ile bağlantı kuramıyor, mysql bilgilerinizi kontrol edin.

[doqu10]

Sunucunuz, mysql veri tabanı ile bağlantı kuramıyor, mysql bilgilerinizi kontrol edin.

Hocam para, skor gibi değerleri kaydediyor ama ve server.exe de bağlantı kuruldu ibaresini görüyorum.

[Eamon]

Bu kodu

Kod Seç Expand

format(query, sizeof(query),"UPDATE `Kullanicilar` SET `Skor`='%d',`Para`='%d','KonumX'='%f','KonumY'='%f','KonumZ'='%f' WHERE `Isim`='%s'", GetPlayerScore(playerid), GetPlayerMoney(playerid), posx, posy, posz, isim);

Bununla değiştirir misin

Kod Seç Expand

format(query, sizeof(query),"UPDATE `Kullanicilar` SET `Skor`='%d',`Para`='%d',`KonumX`='%f',`KonumY`='%f',`KonumZ`='%f' WHERE `Isim`='%s'", GetPlayerScore(playerid), GetPlayerMoney(playerid), posx, posy, posz, isim);

Tablolarda " ' " yerine " ` " kullanmalısınız onu düzelttim, başka yerde varsa sizde düzeltip öyle deneyin. Örnek 'KonumZ' yerine  `KonumZ`

Ek olarak

[ERROR] error #1064 while executing query "SELECT * FROM 'Kullanicilar' WHERE Isim = 'Dogu'": You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''Kullanicilar' WHERE Isim = 'Dogu'' at line 1 (d:\SAMP\aYENİİ KULLANACAGIM SERVERRRRR\gamemodes\osk.pwn:136)

Yukarıda bahsettiğim işlemi bu query kodunu bulup düzenleyin.

[Talhq1.]

Bu kodu

Kod Seç Expand

format(query, sizeof(query),"UPDATE `Kullanicilar` SET `Skor`='%d',`Para`='%d','KonumX'='%f','KonumY'='%f','KonumZ'='%f' WHERE `Isim`='%s'", GetPlayerScore(playerid), GetPlayerMoney(playerid), posx, posy, posz, isim);

Bununla değiştirir misin

Kod Seç Expand

format(query, sizeof(query),"UPDATE `Kullanicilar` SET `Skor`='%d',`Para`='%d',`KonumX`='%f',`KonumY`='%f',`KonumZ`='%f' WHERE `Isim`='%s'", GetPlayerScore(playerid), GetPlayerMoney(playerid), posx, posy, posz, isim);

Tablolarda " ' " yerine " ` " kullanmalısınız onu düzelttim, başka yerde varsa sizde düzeltip öyle deneyin. Örnek 'KonumZ' yerine  `KonumZ`

Ek olarak

[ERROR] error #1064 while executing query "SELECT * FROM 'Kullanicilar' WHERE Isim = 'Dogu'": You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''Kullanicilar' WHERE Isim = 'Dogu'' at line 1 (d:\SAMP\aYENİİ KULLANACAGIM SERVERRRRR\gamemodes\osk.pwn:136)

Yukarıda bahsettiğim işlemi bu query kodunu bulup düzenleyin.

güzel anlatım

[Anestezi]

Açılan taleplerin son iletisi 10 günü geçmesi durumunda; konu kilitlenip, kilitli konular bölümüne taşınacaktır. Sorunu çözülen konularınızı kilitleyip, moderatörlere bildiriniz.

Konu kilit+arşiv