Razerz
Membru-
Posts
19 -
Joined
-
Last visited
Razerz's Achievements
-
UP
-
Up, am scos ce am aduagat si acu am ajuns iara la eroarea "CMySQLResult::GetRowDataByName()",1,"invalid row index('0)",('0');". Cand apare aceasta eroare se pierd Cashu/Scoru si coinsii uneori..
-
Up, stie cineva?
-
Salut SA-MP.RO ! Problema intalnita: De ceva timp primesc mai multe erori in Mysql Log carora nu le dau de cap. Acestea sunt doar 2 erori. Log("12:25:16","CMySQLQuery::Execute[()]",1,"(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 's Casino' WHERE `Key` = 1' at line 1",1);Log("09:55:00","CMySQLQuery::Execute[()]",1,"(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 'm not in DANGER ,',`Description2` = 'I'm the DANGER !',`Description3` = '',`Posi' at line 1",1);Imagini/Video: Inainte sa primesc aceste erori, primeam urmatoarea eroare CMySQLResult::GetRowDataByName()",1,"invalid row index('0)",('0'); de la callback-ul CheckAccountPassword. Am adaugat in acest CallBack acest cod new Rows, Fields; cache_get_data(Rows, Fields); if (Rows == 0) return 0; Dup adaugarea acestui cod, eroarea CMySQLResult::GetRowDataByName()",1,"invalid row index('0)",('0'); a disparut dar, au aparut cele de mai sus. Sa imi ziceti ce mai este nevoie sa postez, Multumesc Mult.
-
Problema server ( CMySQLResult::GetRowDataByName() )
Razerz replied to Razerz's question in Suport Servere
O sa revin cu edit daca mai apare eroarea ( sa nu dati TC la topic ) -
Problema server ( CMySQLResult::GetRowDataByName() )
Razerz replied to Razerz's question in Suport Servere
Nu am inteles, mai exact trebuie sa iti dau tabelu unde sunt cont-urile creeate? sau astea //--------------------------- Account INSERT ---------------------// gsString[ 0 ] = EOS; format( gsString, 2048, "INSERT INTO `Accounts`(`Key`, `Name`, `IP`, `Password`, `RegisterDate`, `LoggedIn`, `Level`, `Vip`, `rVip`, `LastOn`, \ `Cash`, `Score`, `Kills`, `Deaths`, `Online`, `Rank`, `BestKillings`, `KillingSpree`, `Drugs`, `TimesOnServer`," ); format( gsString, 2048, "%s`Coins`, `SAdmin`, `FavSkin`, `UseSkin`, `Description1`, `Description2`, `Description3`, `Positive`, `Negative`, \ `Clan`, `ClanRank`, `E-Mail`, `ClanPoints`, `ClanDeaths`, `ClanOnline`, `ClanJoined`, `Kicks`, `Bans`, `Jails`,", gsString ); format( gsString, 2048, "%s`Warns`, `ClearChats`, `ReactionTest`, `MathTest`, `Mutes`, `ARatio`, `Property`, `Jailed`, `JailTime`, `Frozen`, \ `FreezeTime`, `RAdmin`, `ChatColor`, `RaceScore`, `StuntScore`, `DriftScore`, `DuelScore`, `CNRScore`, `vSpawn_X`, `vSpawn_Y`, `vSpawn_Z`, `vSpawn_A`, \ `TopOnline`, `AdminWarns`, `OwnedCarID`, `SavingSts`, `HouseID`, `BankMoney`,", gsString ); format( gsString, 2048, "%s`Lang`, `GangID`,`GangKills`,`GangDeaths`,`GangRank`,`GangWarns`,`GangCaptures`,`GangPoints`, `NoPM`, `NoGoto`, `NoSpec`)", gsString ); format( gsString, 2048, "%s VALUES (0, '%s', '%s', '%s', '%d-%d-%d', 1, 0, 0, 0, '%d-%d-%d', \ 500000, 50, 0, 0, '00:00:00', 0, 0, 0, 0, 1, \ 0, 0, 0, 0, ' ', ' ', ' ', 0, 0,", gsString, PlayerName( playerid ), GetPlayerIPEx( playerid ), Buf, liYear, liMonth, liDay, liYear, liMonth, liDay ); format( gsString, 2048, "%s'None', 0, ' ', 0, 0, '00:00:00', 'None', 0, 0, 0, \ 0, 0, 0, 0, 0, 0, 0, 0, '00:00', 0, \ '00:00', 0, '0xFFFFFFFF', 0, 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, \ 0, 0, 0, '0,0', 0, 0, %d, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)", gsString, Lang[ playerid ] ); mysql_function_query( g_Handle, gsString, false, "OnAccountCreated", "i", playerid ); SavePlayer( playerid ) { new Ratio[ 7 ], h, m, s, c_h, c_m, c_s, szYear, szMonth, szDay; Ratio[ 0 ] = PlayerInfo[ playerid ][ PKicks ] + PlayerInfo[ playerid ][ PBans ]; Ratio[ 1 ] = Ratio[ 0 ] + PlayerInfo[ playerid ][ PWarns ]; Ratio[ 2 ] = Ratio[ 1 ] + PlayerInfo[ playerid ][ PJails ]; Ratio[ 3 ] = Ratio[ 2 ] + PlayerInfo[ playerid ][ PClearCH ]; Ratio[ 4 ] = Ratio[ 3 ] + PlayerInfo[ playerid ][ PReactions ]; Ratio[ 5 ] = Ratio[ 4 ] + PlayerInfo[ playerid ][ PMaths ]; Ratio[ 6 ] = Ratio[ 5 ] + PlayerInfo[ playerid ][ PMutes ]; TotalGameTime( playerid, h, m, s ); TotalClanTime( playerid, c_h, c_m, c_s ); getdate( szYear, szMonth, szDay ); gsString[ 0 ] = EOS; format( gsString, 3048, "UPDATE `Accounts` SET `LoggedIn` = 0,`Level` = %d,`Vip` = %d,`rVip` = %d,`LastOn` = '%d-%d-%d',`Cash` = %d", PlayerInfo[ playerid ][ Level ], PlayerInfo[ playerid ][ pVip ], PlayerInfo[ playerid ][ rVip ], szYear, szMonth, szDay, GetPlayerMoney( playerid ) ); format( gsString, 3048, "%s,`Score` = %d,`Kills` = %d,`Deaths` = %d,`Online` = '%02d:%02d:%02d',`Rank` = '%s',`BestKillings` = '%d'", gsString, GetPlayerScore( playerid ), PlayerInfo[ playerid ][ Kills ], PlayerInfo[ playerid ][ Deaths ], h, m, s, PlayerInfo[ playerid ][ RankName ], PlayerInfo[ playerid ][ bKillingSpree ] ); format( gsString, 3048, "%s,`KillingSpree` = '%d',`Drugs` = '%d',`TimesOnServer` = `TimesOnServer`+1,`Coins` = '%d',`SAdmin` = '%d'", gsString, PlayerInfo[ playerid ][ KillingSpree ], PlayerInfo[ playerid ][ Drugs ], PlayerInfo[ playerid ][ Coins ], PlayerInfo[ playerid ][ SAdmin ] ); format( gsString, 3048, "%s,`FavSkin` = '%d',`UseSkin` = '%d',`Description1` = '%s',`Description2` = '%s',`Description3` = '%s',`Positive` = '%d',`Negative` = '%d'", gsString, PlayerInfo[ playerid ][ FavSkin ], PlayerInfo[ playerid ][ UseSkin ], PlayerInfo[ playerid ][ Description1 ], PlayerInfo[ playerid ][ Description2 ], PlayerInfo[ playerid ][ Description3 ], PlayerInfo[ playerid ][ PosRespect ], PlayerInfo[ playerid ][ NegRespect ] ); format( gsString, 3048, "%s,`Clan` = '%s',`ClanRank` = '%d',`ClanPoints` = %d,`ClanDeaths` = %d,`ClanOnline` = '%02d:%02d:%02d',`ClanJoined` = '%s'", gsString, PlayerInfo[ playerid ][ Clan ], PlayerInfo[ playerid ][ rank ], PlayerInfo[ playerid ][ c_points ], PlayerInfo[ playerid ][ c_deaths ], c_h, c_m, c_s, PlayerInfo[ playerid ][ JoinedInClan ] ); format( gsString, 3048, "%s,`Kicks` = '%d',`Bans` = '%d',`Jails` = '%d',`Warns` = '%d',`ClearChats` = '%d',`ReactionTest` = '%d',`MathTest` = '%d'", gsString, PlayerInfo[ playerid ][ PKicks ], PlayerInfo[ playerid ][ PBans ], PlayerInfo[ playerid ][ PJails ], PlayerInfo[ playerid ][ PWarns ], PlayerInfo[ playerid ][ PClearCH ], PlayerInfo[ playerid ][ PReactions ], PlayerInfo[ playerid ][ PMaths ] ); format( gsString, 3048, "%s,`Mutes` = '%d',`ARatio` = '%d',`Property` = '%d',`Jailed` = '%d',`JailTime` = '%d:%d',`Frozen` = %d,`FreezeTime` = '%d:%d'", gsString, PlayerInfo[ playerid ][ PMutes ], Ratio[ 6 ], PlayerInfo[ playerid ][ Property ], PlayerInfo[ playerid ][ Jailed ], gTime[ playerid ][ 0 ], gTime[ playerid ][ 1 ], PlayerInfo[ playerid ][ Frozen ], gTime[ playerid ][ 0 ], gTime[ playerid ][ 1 ] ); format( gsString, 3048, "%s,`RAdmin` = '%d', `ChatColor` = %d, `RaceScore` = '%d', `StuntScore` = '%d', `CNRScore` = %d", gsString, PlayerInfo[ playerid ][ rAdmin ], PlayerInfo[ playerid ][ p_TextColor ], PlayerInfo[ playerid ][ Race_Score ], PlayerInfo[ playerid ][ Stunt_Score ], PlayerInfo[ playerid ][ CNR_Score ] ); format( gsString, 3048, "%s,`DriftScore` = '%d',`DuelScore` = '%d',`vSpawn_X` = %.2f, `vSpawn_Y` = %.2f, `vSpawn_Z` = %.2f, `vSpawn_A` = %.2d", gsString, PlayerInfo[ playerid ][ Drift_Score ], PlayerInfo[ playerid ][ D_Score ], GetPVarFloat( playerid, "vSpawn_X" ), GetPVarFloat( playerid, "vSpawn_Y" ), GetPVarFloat( playerid, "vSpawn_Z" ), GetPVarFloat( playerid, "vSpawn_A" ) ); format( gsString, 3048, "%s,`TopOnline` = %02d%02d%02d,`OwnedCarID` = %d,`AdminWarns` = %d,`SavingSts` = '%d,%d',`HouseID` = %d", gsString, PlayerInfo[ playerid ][ hours ], PlayerInfo[ playerid ][ mins ], PlayerInfo[ playerid ][ secs ], PlayerInfo[ playerid ][ CarID ], PlayerInfo[ playerid ][ AdminWarns ], PlayerInfo[ playerid ][ p_HoldSaving ], PlayerInfo[ playerid ][ p_VehicleHoldSaving ], PlayerInfo[ playerid ][ szOwnedHouseID ] ); format( gsString, 3048, "%s,`BankMoney` = %d,`Lang` = %d,`NoPM` = %d,`NoGoto` = %d,`NoSpec` = %d", gsString, PlayerInfo[ playerid ][ P_BANK_MONEY ], Lang[ playerid ], PlayerInfo[ playerid ][ NoPM ], PlayerInfo[ playerid ][ GotoIgnored ], PlayerInfo[ playerid ][ Ignore_Spec ] ); format( gsString, 3048, "%s,`GangID` = %d,`GangRank` = %d,`GangKills` = %d,`GangDeaths` = %d,`GangWarns` = %d,`GangCaptures` = %d,`GangPoints` = %d WHERE `Key` = %d", gsString, Users[ playerid ][ gang ], Users[ playerid ][ isLeader ], Users[ playerid ][ g_Kills ], Users[ playerid ][ g_Deaths ], Users[ playerid ][ g_Warns ], Users[ playerid ][ g_Captures ], Users[ playerid ][ g_Points ], PlayerInfo[ playerid ][ AccID ] ); mysql_function_query( g_Handle, gsString, false, "", "" ); ...continuare.... -
Problema server ( CMySQLResult::GetRowDataByName() )
Razerz replied to Razerz's question in Suport Servere
SQL_Function CheckAccountPassword( playerid, password[ ] ) { if ( !IsPlayerConnected( playerid ) ) return ( 1 ); new Login_Field[ 256 ], xxstring[512]; cache_get_field_content( 0, "Password", Login_Field, g_Handle ); if ( strmatch( password, Login_Field ) ) { new LastOnline[ 256 ], RegisterDate[ 256 ]; PlayerPlaySound(playerid,1057,0.0,0.0,0.0); format( gsQuery, 128, "UPDATE `Accounts` SET `LoggedIn` = 1,`IP` = '%s',`Lang` = %d WHERE `Name` = '%s'", GetPlayerIPEx( playerid ), Lang[ playerid ], PlayerName( playerid ) ); mysql_function_query( g_Handle, gsQuery, false, "", "" ); //----------------------------- Loggin' Into Account -----------------// PlayerInfo[ playerid ][ LoggedIn ] = 1; PlayerInfo[ playerid ][ AccID ] = cache_get_field_content_int( 0, "Key", g_Handle ); PlayerInfo[ playerid ][ pVip ] = cache_get_field_content_int( 0, "Vip", g_Handle ); PlayerInfo[ playerid ][ Level ] = cache_get_field_content_int( 0, "Level", g_Handle ); PlayerInfo[ playerid ][ rVip ] = cache_get_field_content_int( 0, "rVip", g_Handle ); PlayerInfo[ playerid ][ bKillingSpree ] = cache_get_field_content_int( 0, "BestKillings", g_Handle ); PlayerInfo[ playerid ][ KillingSpree ] = cache_get_field_content_int( 0, "KillingSpree", g_Handle ); PlayerInfo[ playerid ][ Drugs ] = cache_get_field_content_int( 0, "Drugs", g_Handle ); PlayerInfo[ playerid ][ Coins ] = cache_get_field_content_int( 0, "Coins", g_Handle ); PlayerInfo[ playerid ][ PosRespect ] = cache_get_field_content_int( 0, "Positive", g_Handle ); PlayerInfo[ playerid ][ NegRespect ] = cache_get_field_content_int( 0, "Negative", g_Handle ); PlayerInfo[ playerid ][ SAdmin ] = cache_get_field_content_int( 0, "SAdmin", g_Handle ); PlayerInfo[ playerid ][ FavSkin ] = cache_get_field_content_int( 0, "FavSkin", g_Handle ); PlayerInfo[ playerid ][ rank ] = cache_get_field_content_int( 0, "ClanRank", g_Handle ); PlayerInfo[ playerid ][ c_points ] = cache_get_field_content_int( 0, "ClanPoints", g_Handle ); PlayerInfo[ playerid ][ c_deaths ] = cache_get_field_content_int( 0, "ClanDeaths", g_Handle ); PlayerInfo[ playerid ][ PKicks ] = cache_get_field_content_int( 0, "Kicks", g_Handle ); PlayerInfo[ playerid ][ PBans ] = cache_get_field_content_int( 0, "Bans", g_Handle ); PlayerInfo[ playerid ][ PJails ] = cache_get_field_content_int( 0, "Jails", g_Handle ); PlayerInfo[ playerid ][ PWarns ] = cache_get_field_content_int( 0, "Warns", g_Handle ); PlayerInfo[ playerid ][ PClearCH ] = cache_get_field_content_int( 0, "ClearChats", g_Handle ); PlayerInfo[ playerid ][ PReactions ] = cache_get_field_content_int( 0, "ReactionTest", g_Handle ); PlayerInfo[ playerid ][ PMaths ] = cache_get_field_content_int( 0, "MathTest", g_Handle ); PlayerInfo[ playerid ][ PMutes ] = cache_get_field_content_int( 0, "Mutes", g_Handle ); PlayerInfo[ playerid ][ Property ] = cache_get_field_content_int( 0, "Property", g_Handle ); PlayerInfo[ playerid ][ Jailed ] = cache_get_field_content_int( 0, "Jailed", g_Handle ); PlayerInfo[ playerid ][ Frozen ] = cache_get_field_content_int( 0, "Frozen", g_Handle ); PlayerInfo[ playerid ][ Kills ] = cache_get_field_content_int( 0, "Kills", g_Handle ); PlayerInfo[ playerid ][ Deaths ] = cache_get_field_content_int( 0, "Deaths", g_Handle ); PlayerInfo[ playerid ][ rAdmin ] = cache_get_field_content_int( 0, "RAdmin", g_Handle ); PlayerInfo[ playerid ][ p_TextColor ] = cache_get_field_content_int( 0, "ChatColor", g_Handle ); PlayerInfo[ playerid ][ D_Score ] = cache_get_field_content_int( 0, "DuelScore", g_Handle ); PlayerInfo[ playerid ][ Race_Score ] = cache_get_field_content_int( 0, "RaceScore", g_Handle ); PlayerInfo[ playerid ][ Stunt_Score ] = cache_get_field_content_int( 0, "StuntScore", g_Handle ); PlayerInfo[ playerid ][ Drift_Score ] = cache_get_field_content_int( 0, "DriftScore", g_Handle ); PlayerInfo[ playerid ][ CarID ] = cache_get_field_content_int( 0, "OwnedCarID", g_Handle ); PlayerInfo[ playerid ][ szOwnedHouseID ] = cache_get_field_content_int( 0, "HouseID", g_Handle ); PlayerInfo[ playerid ][ P_BANK_MONEY ] = cache_get_field_content_int( 0, "BankMoney", g_Handle ); Lang[ playerid ] = cache_get_field_content_int( 0, "Lang", g_Handle ); Users[ playerid ][ gang ] = cache_get_field_content_int( 0, "GangID", g_Handle ); Users[ playerid ][ g_Kills ] = cache_get_field_content_int( 0, "GangKills", g_Handle ); Users[ playerid ][ g_Deaths ] = cache_get_field_content_int( 0, "GangDeaths", g_Handle ); Users[ playerid ][ isLeader ] = cache_get_field_content_int( 0, "GangRank", g_Handle ); Users[ playerid ][ g_Warns ] = cache_get_field_content_int( 0, "GangWarns", g_Handle ); Users[ playerid ][ g_Captures ] = cache_get_field_content_int( 0, "GangCaptures", g_Handle ); Users[ playerid ][ g_Points ] = cache_get_field_content_int( 0, "GangPoints", g_Handle ); PlayerInfo[ playerid ][ NoPM ] = cache_get_field_content_int( 0, "NoPM", g_Handle ); PlayerInfo[ playerid ][ GotoIgnored ] = cache_get_field_content_int( 0, "NoGoto", g_Handle ); PlayerInfo[ playerid ][ Ignore_Spec ] = cache_get_field_content_int( 0, "NoSpec", g_Handle ); cache_get_field_content( 0, "E-Mail", Login_Field, g_Handle ); format( PlayerInfo[ playerid ][ EMail ], 128, "%s", Login_Field ); SetPVarFloat( playerid, "vSpawn_X", cache_get_field_content_float( 0, "vSpawn_X", g_Handle ) ); SetPVarFloat( playerid, "vSpawn_Y", cache_get_field_content_float( 0, "vSpawn_Y", g_Handle ) ); SetPVarFloat( playerid, "vSpawn_Z", cache_get_field_content_float( 0, "vSpawn_Z", g_Handle ) ); SetPVarFloat( playerid, "vSpawn_A", cache_get_field_content_float( 0, "vSpawn_A", g_Handle ) ); ResetPlayerMoney( playerid ); GivePlayerMoney( playerid, cache_get_field_content_int( 0, "Cash", g_Handle ) ); SetPVarInt( playerid, "sMoney", cache_get_field_content_int( 0, "Cash", g_Handle ) ); SetPlayerScore( playerid, cache_get_field_content_int( 0, "Score", g_Handle ) ); cache_get_field_content( 0, "Online", Login_Field, g_Handle ); sscanf( Login_Field, "p<:>iii", PlayerInfo[ playerid ][ hours ], PlayerInfo[ playerid ][ mins ], PlayerInfo[ playerid ][ secs ] ); cache_get_field_content( 0, "LastOn", LastOnline, g_Handle ); cache_get_field_content( 0, "RegisterDate", RegisterDate, g_Handle ); cache_get_field_content( 0, "Rank", Login_Field, g_Handle ); format( PlayerInfo[ playerid ][ RankName ], 25, Login_Field ); cache_get_field_content( 0, "Description1", Login_Field, g_Handle ); format( PlayerInfo[ playerid ][ Description1 ], 128, "%s", Login_Field ); cache_get_field_content( 0, "Description2", Login_Field, g_Handle ); format( PlayerInfo[ playerid ][ Description2 ], 128, "%s", Login_Field ); cache_get_field_content( 0, "Description3", Login_Field, g_Handle ); format( PlayerInfo[ playerid ][ Description3 ], 128, "%s", Login_Field ); cache_get_field_content( 0, "ClanJoined", Login_Field, g_Handle ); format( PlayerInfo[ playerid ][ JoinedInClan ], 50, Login_Field ); cache_get_field_content( 0, "Clan", Login_Field, g_Handle ); format( PlayerInfo[ playerid ][ Clan ], 25, "%s", Login_Field ); cache_get_field_content( 0, "ClanOnline", Login_Field ); sscanf( Login_Field, "p<:>iii", PlayerInfo[ playerid ][ clan_H ], PlayerInfo[ playerid ][ clan_M ], PlayerInfo[ playerid ][ clan_S ] ); cache_get_field_content( 0, "SavingSts", Login_Field, g_Handle ); sscanf( Login_Field, "p<,>ii", PlayerInfo[ playerid ][ p_HoldSaving ], PlayerInfo[ playerid ][ p_VehicleHoldSaving ] ); if ( PlayerInfo[ playerid ][ Jailed ] >= 1 ) { cache_get_field_content( 0, "JailTime", Login_Field, g_Handle ); sscanf( Login_Field, "p<:>ii", gTime[ playerid ][ 0 ], gTime[ playerid ][ 1 ] ); } if ( PlayerInfo[ playerid ][ Frozen ] == 1 ) { cache_get_field_content( 0, "FreezeTime", Login_Field, g_Handle ); sscanf( Login_Field, "p<:>ii", gTime[ playerid ][ 0 ], gTime[ playerid ][ 1 ] ); } if ( PlayerInfo[ playerid ][ CarID ] != 0 ) { format( gsQuery, 128, "SELECT * FROM `PersonalVehicles` WHERE `Owner` = '%s'", PlayerName( playerid ) ); mysql_function_query( g_Handle, gsQuery, true, "LoadPersonalVehicleInfo", "i", playerid ); } if ( !strmatch( PlayerInfo[ playerid ][ Clan ], "None" ) ) { format( gsQuery, 256, "SELECT * FROM `Clans` WHERE `name` = '%s'", PlayerInfo[ playerid ][ Clan ] ); mysql_function_query( g_Handle, gsQuery, true, "LoadClanDetails", "i", playerid ); } { switch( Lang[ playerid ] ) { case 0: { format(xxstring, 512, "{1DEE01}Hi {FF0000}%s\n\ {1DEE01}You have been LoggedIn:\n\n\ {FF0000}• {1DEE01}Admin Level: {00BBF6}%d\n\ {FF0000}• {1DEE01}VIP Level: {00BBF6}%d\n\ {FF0000}• {1DEE01}Stats Note: {00BBF6}%d/10\n\n\ {1DEE01}Use {FF0000}/Stats{1DEE01} for more details!", PlayerName(playerid), PlayerInfo[playerid][Level], PlayerInfo[playerid][pVip], GiveNote(playerid)); return ShowPlayerDialog(playerid, 0, DIALOG_STYLE_MSGBOX, "{0066CC}X{FFFF00}X{FF0000}X{AFAFAF} - Account Info", xxstring, "Ok",""); } case 1: { format(xxstring, 512, "{1DEE01}Salut {FF0000}%s\n\ {1DEE01}Ai fost logat cu succes:\n\n\ {FF0000}• {1DEE01}Admin Level: {00BBF6}%d\n\ {FF0000}• {1DEE01}VIP Level: {00BBF6}%d\n\ {FF0000}• {1DEE01}Stats Note: {00BBF6}%d/10\n\n\ {1DEE01}Foloseste {FF0000}/Stats{1DEE01} pentru mai multe detalii!", PlayerName(playerid), PlayerInfo[playerid][Level], PlayerInfo[playerid][pVip], GiveNote(playerid)); return ShowPlayerDialog(playerid, 0, DIALOG_STYLE_MSGBOX, "{0066CC}X{FFFF00}X{FF0000}X{AFAFAF} - Account Info", xxstring, "Ok",""); } } } } else { PlayerInfo[ playerid ][ FailLogin ]++; if ( PlayerInfo[ playerid ][ FailLogin ] == MAX_FAIL_LOGINS ) { format( gsString, 144, "*** {00FF00}%s(%d) {FFF1AF}has been kicked. Reason: {FF0000}Failed Logins{FFF1AF}!", PlayerName( playerid ), playerid ); SendClientMessageToAll( COLOR_GREY, gsString ); Kick( playerid ); } switch( Lang[ playerid ] ) { case 0: format( gsString, 256, "\t\t\t{FF0000}ACCOUNT:\n\n{ACACAC}Login failed! Incorrect Password.\nATTEMPTS: {FF0000}%d/%d\n\n{00FF00}PONT: {ACACAC}Change your '{FF0000}Name{ACACAC}' if this isn't your account name.", PlayerInfo[ playerid ][ FailLogin ], MAX_FAIL_LOGINS ); case 1: format( gsString, 256, "\t\t\t\t{FF0000}CONT:\n\n{ACACAC}Logarea nu a reusit! Parola Incorecta.\nINCERCARI: {FF0000}%d/%d\n\n{00FF00}PONT: {ACACAC}Schimbati '{FF0000}Numele{ACACAC}' daca acesta nu este numele accountului tau.", PlayerInfo[ playerid ][ FailLogin ], MAX_FAIL_LOGINS ); } ShowPlayerDialog( playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "{FFFFFF}Login your account", gsString, "Login", "New Name" ); } return ( 1 ); } http://s30.postimg.org/uahnl0oo1/tab1.png http://s9.postimg.org/4uxrho7z3/tab2.png -- -- Table structure for table `Accounts` -- CREATE TABLE IF NOT EXISTS `Accounts` ( `Key` int(11) NOT NULL AUTO_INCREMENT, `Name` text, `IP` text, `Password` text, `RegisterDate` date DEFAULT NULL, `LoggedIn` int(11) DEFAULT NULL, `Level` int(11) DEFAULT NULL, `Vip` int(11) DEFAULT NULL, `rVip` int(11) DEFAULT NULL, `LastOn` date DEFAULT NULL, `Cash` int(11) DEFAULT NULL, `Score` int(11) DEFAULT NULL, `Kills` int(11) DEFAULT NULL, `Deaths` int(11) DEFAULT NULL, `Online` text, `Rank` text NOT NULL, `BestKillings` int(11) DEFAULT NULL, `KillingSpree` int(11) DEFAULT NULL, `Drugs` int(11) DEFAULT NULL, `TimesOnServer` int(11) DEFAULT NULL, `Coins` int(11) DEFAULT NULL, `SAdmin` int(11) DEFAULT NULL, `FavSkin` int(11) DEFAULT NULL, `UseSkin` int(11) DEFAULT NULL, `Description1` text NOT NULL, `Description2` text NOT NULL, `Description3` text NOT NULL, `Positive` int(11) DEFAULT NULL, `Negative` int(11) DEFAULT NULL, `Clan` text, `ClanRank` int(11) DEFAULT NULL, `E-Mail` text, `ClanPoints` int(11) DEFAULT NULL, `ClanDeaths` int(11) DEFAULT NULL, `ClanOnline` text, `ClanJoined` text, `Kicks` int(11) DEFAULT NULL, `Bans` int(11) DEFAULT NULL, `Jails` int(11) DEFAULT NULL, `Warns` int(11) DEFAULT NULL, `ClearChats` int(11) DEFAULT NULL, `ReactionTest` int(11) DEFAULT NULL, `MathTest` int(11) DEFAULT NULL, `Mutes` int(11) DEFAULT NULL, `ARatio` int(11) DEFAULT NULL, `Property` int(11) DEFAULT NULL, `Jailed` int(11) DEFAULT NULL, `JailTime` text, `Frozen` int(11) DEFAULT NULL, `FreezeTime` text, `RAdmin` int(11) DEFAULT NULL, `ChatColor` int(11) NOT NULL, `RaceScore` int(11) DEFAULT NULL, `StuntScore` int(11) DEFAULT NULL, `DriftScore` int(11) DEFAULT NULL, `DuelScore` int(11) DEFAULT NULL, `CNRScore` int(11) DEFAULT NULL, `vSpawn_X` float NOT NULL, `vSpawn_Y` float NOT NULL, `vSpawn_Z` float NOT NULL, `vSpawn_A` float NOT NULL, `TopOnline` int(11) NOT NULL, `AdminWarns` int(11) NOT NULL, `OwnedCarID` int(11) NOT NULL, `SavingSts` text NOT NULL, `HouseID` int(11) NOT NULL, `BankMoney` int(11) NOT NULL, `Lang` int(11) NOT NULL, `GangID` int(11) NOT NULL, `GangRank` int(11) NOT NULL, `GangKills` int(11) NOT NULL, `GangDeaths` int(11) NOT NULL, `GangWarns` int(11) NOT NULL, `GangCaptures` int(11) NOT NULL, `GangPoints` int(11) NOT NULL, `NoPM` int(11) DEFAULT NULL, `NoGoto` int(11) DEFAULT NULL, `NoSpec` int(11) DEFAULT NULL, PRIMARY KEY (`Key`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12959 ; -
Problema server ( CMySQLResult::GetRowDataByName() )
Razerz replied to Razerz's question in Suport Servere
Up, ma poate ajuta cineva? -
Problema server ( CMySQLResult::GetRowDataByName() )
Razerz replied to Razerz's question in Suport Servere
Up, nu stie nimeni? -
Salut SA-MP.RO ! Problema intalnita : De ceva timp a aparut o problema, mai exact uneori se pierd banii/ scor-ul si vip-ul. Eroarea/Warning-ul : in mysql log primesc eroarea CMySQLResult::GetRowDataByName()",1,"invalid row index('0)",('0');"de la CallBack-ul CheckAccountPassword(nu stiu daca asta este problema) aici aveti mysql log http://pastebin.com/7tiaKbtJ si aici callback-ul checkaccountpassword http://pastebin.com/DvzpyiZh Imagini/video : imagine cu eroarea Ai incercat sa o rezolvi singur: ? Da, dar nu am reusit. Multumesc mult.
-
Nu functioneaza, am marit stringu si l-am tot marit.. ( initial era de 1024 ).
-
Up, chiar nu ma poate ajuta nimeni ? ( scuzati-mi insistentele dar ma enerveaza foarte tare aceasta problema )
-
Up, nu stie nimeni?
-
Am observat alta problema, cand dau de exemplu /warn id reason a textul apare dar, daca dau /warn id reason limbaju textu nu mai apare.. Am incercat sa maresc string-ul de la reason, crezand ca poate de acolo este problema dar tot asa face..
-
Am marit string-ul si degeaba : normal trebuia sa fie asa