Please help me (mysql)
#6

Quote:
Originally Posted by Mencent
Посмотреть сообщение
Hello!

You have to write it so:
PHP код:
cache_get_field_content(0,"pEmail",PlayerInfo[playerid][pEmail],connectionhandle,30);
// 0 = row
// pEmail = name
// PlayerInfo[playerid][pEmail] = your enum variable
// connectionhandle = The Connection handle (MySQL)
// 30 = length of pEmail 
Mencent
Thanks I fixed this. in my mysql_log onplayerdissconnect i found this

Код:
[16:01:18] [DEBUG] mysql_format - connection: 1, len: 1000, format: "UPDATE `players` SET `Pari`=%d, `Admin`=%d, `Spawn`=%d, `Pol`=%d, `Drzava`=%d, `Godini`=%d, `Email`=%s, `Skin`=%d, `GM`=%d, `Lev..."
[16:01:18] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `players` SET `Pari`=10000, `Admin`=0, `Spawn`=0, `Pol`=0", callback: "(null)", format: "(null)"
[16:01:18] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[16:01:18] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' `Skin`=7, `GM`=0, `Level`=0, `Exp`=0, `Rep`=0, `Kukja`=0, `Rent`=0, `Stan`=0, `' at line 1
[16:01:18] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
Reply


Messages In This Thread
Please help me (mysql) - by ilepopivanov - 11.04.2015, 12:53
Re: Please help me (mysql) - by JaKe Elite - 11.04.2015, 13:00
Re: Please help me (mysql) - by ilepopivanov - 11.04.2015, 13:35
AW: Please help me (mysql) - by Mencent - 11.04.2015, 13:42
Re: Please help me (mysql) - by Konstantinos - 11.04.2015, 13:42
Re: AW: Please help me (mysql) - by ilepopivanov - 11.04.2015, 14:05
Re: Please help me (mysql) - by Konstantinos - 11.04.2015, 14:09

Forum Jump:


Users browsing this thread: 1 Guest(s)