26.01.2019, 19:28
Hello, i have changed my mysql version from R39 to R41, but ai just got mistmatch to lots of things and my server wont work.
So i just get warnings for every update im tryingto made...
Code:
(14) : warning 213: tag mismatch (16) : warning 213: tag mismatch (49) : warning 213: tag mismatch (50) : warning 213: tag mismatch (54) : warning 213: tag mismatch (55) : warning 213: tag mismatch (59) : warning 213: tag mismatch (60) : warning 213: tag mismatch (64) : warning 213: tag mismatch (65) : warning 213: tag mismatch (69) : warning 213: tag mismatch (70) : warning 213: tag mismatch (74) : warning 213: tag mismatch (75) : warning 213: tag mismatch (79) : warning 213: tag mismatch (80) : warning 213: tag mismatch (84) : warning 213: tag mismatch (85) : warning 213: tag mismatch (89) : warning 213: tag mismatch (90) : warning 213: tag mismatch (94) : warning 213: tag mismatch (95) : warning 213: tag mismatch (99) : warning 213: tag mismatch (100) : warning 213: tag mismatch (104) : warning 213: tag mismatch (105) : warning 213: tag mismatch (109) : warning 213: tag mismatch (110) : warning 213: tag mismatch (114) : warning 213: tag mismatch (115) : warning 213: tag mismatch (119) : warning 213: tag mismatch (120) : warning 213: tag mismatch (124) : warning 213: tag mismatch (125) : warning 213: tag mismatch (129) : warning 213: tag mismatch (130) : warning 213: tag mismatch (134) : warning 213: tag mismatch (135) : warning 213: tag mismatch (139) : warning 213: tag mismatch (140) : warning 213: tag mismatch (144) : warning 213: tag mismatch (145) : warning 213: tag mismatch (557) : warning 213: tag mismatch (558) : warning 213: tag mismatch (756) : warning 213: tag mismatch (806) : warning 213: tag mismatch (807) : warning 213: tag mismatch (826) : warning 213: tag mismatch (827) : warning 213: tag mismatch (844) : warning 213: tag mismatch (959) : warning 213: tag mismatch (960) : warning 213: tag mismatch
PHP Code:
14 handle = mysql_connect(mysql_host, mysql_user, mysql_database, mysql_password);
16 if(handle && mysql_errno(handle) == 0)
49 to 145 - public Update(playerid, type)
{
if(IsPlayerConnected(playerid))
{
new string[256];
new playerName[MAX_PLAYER_NAME];
GetPlayerName(playerid, playerName, sizeof(playerName));
{
switch(type)
{
case pLevelu:
{
mysql_format(handle, string, sizeof(string), "UPDATE players SET `Level`='%d' WHERE `username`='%e'", PlayerInfo[playerid][pLevel], playerName);
mysql_pquery(handle, string);
}
case pAdminu:
{
mysql_format(handle, string, sizeof(string), "UPDATE players SET `AdminLevel`='%d' WHERE `username`='%e'", PlayerInfo[playerid][pAdmin], playerName);
mysql_pquery(handle, string);
}
case pHelperu:
{
mysql_format(handle, string, sizeof(string), "UPDATE players SET `HelperLevel`='%d' WHERE `username`='%e'", PlayerInfo[playerid][pHelper], playerName);
mysql_pquery(handle, string);
}
case pCashu:
{
mysql_format(handle, string, sizeof(string), "UPDATE players SET `Cash`='%d' WHERE `username`='%e'", PlayerInfo[playerid][pCash], playerName);
mysql_pquery(handle, string);
}
case pAccountu:
{
mysql_format(handle, string, sizeof(string), "UPDATE players SET `Account`='%d' WHERE `username`='%e'", PlayerInfo[playerid][pAccount], playerName);
mysql_pquery(handle, string);
}
case pEmailu:
{
mysql_format(handle, string, sizeof(string), "UPDATE players SET `Email`='%e' WHERE `username`='%e'", PlayerInfo[playerid][pEmail], playerName);
mysql_pquery(handle, string);
}
case pRegistredu:
{
mysql_format(handle, string, sizeof(string), "UPDATE players SET `Registred`='%d' WHERE `username`='%e'", PlayerInfo[playerid][pRegistred], playerName);
mysql_pquery(handle, string);
}
case pTutorialu:
{
mysql_format(handle, string, sizeof(string), "UPDATE players SET `Tutorial`='%d' WHERE `username`='%e'", PlayerInfo[playerid][pTutorial], playerName);
mysql_pquery(handle, string);
}
case pSexu:
{
mysql_format(handle, string, sizeof(string), "UPDATE players SET `Sex`='%d' WHERE `username`='%e'", PlayerInfo[playerid][pSex], playerName);
mysql_pquery(handle, string);
}
case pAgeu:
{
mysql_format(handle, string, sizeof(string), "UPDATE players SET `Age`='%d' WHERE `username`='%e'", PlayerInfo[playerid][pAge], playerName);
mysql_pquery(handle, string);
}
case pPhoneNumberu:
{
mysql_format(handle, string, sizeof(string), "UPDATE players SET `PhoneNumber`='%d' WHERE `username`='%e'", PlayerInfo[playerid][pPhoneNumber], playerName);
mysql_pquery(handle, string);
}
case pPremiumAccountu:
{
mysql_format(handle, string, sizeof(string), "UPDATE players SET `PremiumAccount`='%d' WHERE `username`='%e'", PlayerInfo[playerid][pPremiumAccount], playerName);
mysql_pquery(handle, string);
}
case pBannedu:
{
mysql_format(handle, string, sizeof(string), "UPDATE players SET `Banned`='%d' WHERE `username`='%e'", PlayerInfo[playerid][pBanned], playerName);
mysql_pquery(handle, string);
}
case pWarnsu:
{
mysql_format(handle, string, sizeof(string), "UPDATE players SET `Warns`='%d' WHERE `username`='%e'", PlayerInfo[playerid][pWarns], playerName);
mysql_pquery(handle, string);
}
case pLeaderu:
{
mysql_format(handle, string, sizeof(string), "UPDATE players SET `Leader`='%d' WHERE `username`='%e'", PlayerInfo[playerid][pLeader], playerName);
mysql_pquery(handle, string);
}
case pMemberu:
{
mysql_format(handle, string, sizeof(string), "UPDATE players SET `Member`='%d' WHERE `username`='%e'", PlayerInfo[playerid][pMember], playerName);
mysql_pquery(handle, string);
}
case pRanku:
{
mysql_format(handle, string, sizeof(string), "UPDATE players SET `Rank`='%d' WHERE `username`='%e'", PlayerInfo[playerid][pRank], playerName);
mysql_pquery(handle, string);
}
case pSkinu:
{
mysql_format(handle, string, sizeof(string), "UPDATE players SET `Skin`='%d' WHERE `username`='%e'", PlayerInfo[playerid][pSkin], playerName);
mysql_pquery(handle, string);
}
case pIPu:
{
mysql_format(handle, string, sizeof(string), "UPDATE players SET IP='%e' WHERE username='%e'", PlayerInfo[playerid][pIP], playerName);
mysql_pquery(handle, string);
}
case pLastLoginu:
{
mysql_format(handle, string, sizeof(string), "UPDATE players SET `LastLogin`= CURRENT_TIMESTAMP WHERE `username`='%e'", playerName);
mysql_pquery(handle, string);
}
}
}
}
}
and most of them mysql_format(handle, query, sizeof(query), "INSERT INTO `players` (`username`,`password`) VALUES ('%e', MD5('%e'))", pName, password);
mysql_tquery(handle, query, "", "");