59GVR6

T'es inscrie sur le forum depuis Novembre 21, 2015 Et c'est maintenant que tu te presente après 1 ans ? Bienvenue

Nop lol

Oh merci voilà le problème étais trop petit Merci à Lionel & DeeJas tu m'as appris qu'on pouvais pas un grand merci ps merci pour la boucle mais c'étais déjà dans le gm que j'ai pris lol

J'ai complètement changer le code mais le problème c'est que tous dans la base de donnée est par defaut "0" code SQL_SaveCharacter(playerid) { if (pInfo[playerid][pLogged] == 0) { return 0; } SQL_SaveCharacter1(playerid); SQL_SaveCharacter2(playerid); SQL_SaveCharacter3(playerid); return 1; } SQL_SaveCharacter1(playerid) { new query[500]; printf("compte enregistrer"); pInfo[playerid][Skin] = GetPlayerSkin(playerid); GetPlayerHealth(playerid, pInfo[playerid][Health]); GetPlayerArmour(playerid, pInfo[playerid][Armour]); format(query, sizeof(query), "UPDATE `accounts` SET `Enregistrer` = '%d', `Admin` = '%d', `Level` = '%d', `Exp` = '%d', `MaxExp` = '%d', `Skin` = '%d', `Sexe` = '%d', `Vie` = '%d', `Gillet` = '%d', `Cash` = '%d', `BanqueCash` = '%d', `Masque` = '%d', `MasqueID` = '%d', `NumeroTel` = '%d', `Maison` = '%d', `Commerce` = '%d', `FactionProprio` = '%d', `Vehicule1` = '%d', `Vehicule2` = '%d', `Vehicule3` = '%d', `Faction` = '%d', `Grade` = '%d' WHERE `ID` = '%d'", pInfo[playerid][Registered], pInfo[playerid][Admin], pInfo[playerid][Level], pInfo[playerid][Exp], pInfo[playerid][MaxExp], pInfo[playerid][Skin], pInfo[playerid][Gender], pInfo[playerid][Health], pInfo[playerid][Armour], pInfo[playerid][HandMoney], pInfo[playerid][BankMoney], pInfo[playerid][Mask], pInfo[playerid][MaskID], pInfo[playerid][PhoneNumber], pInfo[playerid][HouseOwner], pInfo[playerid][BizOwner], pInfo[playerid][FacOwner], pInfo[playerid][VehicleOwner], pInfo[playerid][VehicleOwner2], pInfo[playerid][VehicleOwner3], pInfo[playerid][SecteID], pInfo[playerid][Grade], pInfo[playerid][ID] ); mysql_tquery(g_iHandle, query); return 1; } SQL_SaveCharacter2(playerid) { new query[500]; format(query, sizeof(query), "UPDATE `accounts` SET `ChequeJob` = '%d', `TempsTravail` = '%d', `Montre` = '%d', `GPS` = '%d', `Canne` = '%d', `Telephone` = '%d', `Credits` = '%d', `Identite` = '%d', `GramDrogue1` = '%d', `GramDrogue2` = '%d', `GramDrogue3` = '%d', `Cocaine` = '%d', `Heroine` = '%d', `Ecstacy` = '%d', `Mort` = '%d', `JailTemps` = '%d', `Amende` = '%d', `Facture` = '%d', `Emprunt` = '%d', `Lotto` = '%d', `Warn` = '%d' WHERE `ID` = '%d'", //query, pInfo[playerid][PayeCheck], pInfo[playerid][PayeTime], pInfo[playerid][Montre], pInfo[playerid][Gps], pInfo[playerid][Canne], pInfo[playerid][Phone], pInfo[playerid][Credits], pInfo[playerid][CarteIden], pInfo[playerid][DrogueFab1], pInfo[playerid][DrogueFab2], pInfo[playerid][DrogueFab3], pInfo[playerid][Cocaine], pInfo[playerid][Heroine], pInfo[playerid][Ecstacy], pInfo[playerid][Mort], pInfo[playerid][JailTime], pInfo[playerid][Amende], pInfo[playerid][Facture], pInfo[playerid][Emprunt], pInfo[playerid][Lotto], pInfo[playerid][Warn], pInfo[playerid][ID] ); mysql_tquery(g_iHandle, query); return 1; } SQL_SaveCharacter3(playerid) { new query[500]; format(query, sizeof(query), "UPDATE `accounts` SET `Bannis` = '%d', `Permis` = '%d', `PointPermis` = '%d', `PortArme` = '%d', `Situation` = '%d', `Arme1` = '%d', `Minution1` = '%d', `Arme2` = '%d', `Minution2` = '%d', `Arme3` = '%d', `Minution3` = '%d', `Arme4` = '%d', `Minution4` = '%d', `Arme5` = '%d', `Minution5` = '%d', `Arme6` = '%d', `Minution6` = '%d', `Arme7` = '%d', `Minution7` = '%d' WHERE `ID` = '%d'", //query, pInfo[playerid][Baned], pInfo[playerid][Permis], pInfo[playerid][PermisPoint], pInfo[playerid][PortArme], pInfo[playerid][LastPos], pInfo[playerid][Weapon1], pInfo[playerid][Wep1Ammo], pInfo[playerid][Weapon2], pInfo[playerid][Wep2Ammo], pInfo[playerid][Weapon3], pInfo[playerid][Wep3Ammo], pInfo[playerid][Weapon4], pInfo[playerid][Wep4Ammo], pInfo[playerid][Weapon5], pInfo[playerid][Wep5Ammo], pInfo[playerid][Weapon6], pInfo[playerid][Wep6Ammo], pInfo[playerid][Weapon7], pInfo[playerid][Wep7Ammo], pInfo[playerid][ID] ); mysql_tquery(g_iHandle, query); return 1; }

Oui cependant je l'ai modifier aucun erreur dans le mysql_log mais le problème c'est que célà n'enregistre pas et dans tous mes champ dans mon account j'ai tous 0 Nouveau code SQL_SaveCharacter(playerid) { if (pInfo[playerid][pLogged] == 0) { return 0; } new query[1048]; printf("compte enregistrer"); pInfo[playerid][Skin] = GetPlayerSkin(playerid); GetPlayerHealth(playerid, pInfo[playerid][Health]); GetPlayerArmour(playerid, pInfo[playerid][Armour]); format(query, sizeof(query), "UPDATE `accounts` SET `Enregistrer` = '%d', `Admin` = '%d', `Level` = '%d', `Exp` = '%d', `MaxExp` = '%d', `Skin` = '%d', `Sexe` = '%d', `Vie` = '%d', `Gillet` = '%d', `Cash` = '%d', `BanqueCash` = '%d', `Masque` = '%d', `MasqueID` = '%d', `NumeroTel` = '%d', `Maison` = '%d', `Commerce` = '%d', `FactionProprio` = '%d', `Vehicule1` = '%d', `Vehicule2` = '%d', `Vehicule3` = '%d', `Faction` = '%d', `Grade` = '%d' WHERE `ID` = '%d'", pInfo[playerid][Registered], pInfo[playerid][Admin], pInfo[playerid][Level], pInfo[playerid][Exp], pInfo[playerid][MaxExp], pInfo[playerid][Skin], pInfo[playerid][Gender], pInfo[playerid][Health], pInfo[playerid][Armour], pInfo[playerid][HandMoney], pInfo[playerid][BankMoney], pInfo[playerid][Mask], pInfo[playerid][MaskID], pInfo[playerid][PhoneNumber], pInfo[playerid][HouseOwner], pInfo[playerid][BizOwner], pInfo[playerid][FacOwner], pInfo[playerid][VehicleOwner], pInfo[playerid][VehicleOwner2], pInfo[playerid][VehicleOwner3], pInfo[playerid][SecteID], pInfo[playerid][Grade] ); format(query, sizeof(query), "UPDATE `accounts` SET `ChequeJob` = '%d', `TempsTravail` = '%d', `Montre` = '%d', `GPS` = '%d', `Canne` = '%d', `Telephone` = '%d', `Credits` = '%d', `Identite` = '%d', `GramDrogue1` = '%d', `GramDrogue2` = '%d', `GramDrogue3` = '%d', `Cocaine` = '%d', `Heroine` = '%d', `Ecstacy` = '%d', `Mort` = '%d', `JailTemps` = '%d', `Amende` = '%d', `Facture` = '%d', `Emprunt` = '%d', `Lotto` = '%d', `Warn` = '%d' WHERE `ID` = '%d'", query, pInfo[playerid][PayeCheck], pInfo[playerid][PayeTime], pInfo[playerid][Montre], pInfo[playerid][Gps], pInfo[playerid][Canne], pInfo[playerid][Phone], pInfo[playerid][Credits], pInfo[playerid][CarteIden], pInfo[playerid][DrogueFab1], pInfo[playerid][DrogueFab2], pInfo[playerid][DrogueFab3], pInfo[playerid][Cocaine], pInfo[playerid][Heroine], pInfo[playerid][Ecstacy], pInfo[playerid][Mort], pInfo[playerid][JailTime], pInfo[playerid][Amende], pInfo[playerid][Facture], pInfo[playerid][Emprunt], pInfo[playerid][Lotto], pInfo[playerid][Warn] ); format(query, sizeof(query), "UPDATE `accounts` SET `Bannis` = '%d', `Permis` = '%d', `PointPermis` = '%d', `PortArme` = '%d', `Situation` = '%d', `Arme1` = '%d', `Minution1` = '%d', `Arme2` = '%d', `Minution2` = '%d', `Arme3` = '%d', `Minution3` = '%d', `Arme4` = '%d', `Minution4` = '%d', `Arme5` = '%d', `Minution5` = '%d', `Arme6` = '%d', `Minution6` = '%d', `Arme7` = '%d', `Minution7` = '%d' WHERE `ID` = '%d'", query, pInfo[playerid][Baned], pInfo[playerid][Permis], pInfo[playerid][PermisPoint], pInfo[playerid][PortArme], pInfo[playerid][LastPos], pInfo[playerid][Weapon1], pInfo[playerid][Wep1Ammo], pInfo[playerid][Weapon2], pInfo[playerid][Wep2Ammo], pInfo[playerid][Weapon3], pInfo[playerid][Wep3Ammo], pInfo[playerid][Weapon4], pInfo[playerid][Wep4Ammo], pInfo[playerid][Weapon5], pInfo[playerid][Wep5Ammo], pInfo[playerid][Weapon6], pInfo[playerid][Wep6Ammo], pInfo[playerid][Weapon7], pInfo[playerid][Wep7Ammo], pInfo[playerid][ID] ); mysql_tquery(g_iHandle, query); return 1; }

Ah oui oups cependant Quand je créer un compte elle se créer bien dans la base de donnée mais le problème c'est que partout c'est 0 & égalment quand je m'enregistre j'ai ça [14:50:08] [ERROR] CMySQLQuery::Execute[] - (error #1064) Erreur de syntaxe près de '`Arme6' à la ligne 1 Et quand je me déconnecte j'ai ceci [14:51:17] [ERROR] CMySQLQuery::Execute[] - (error #1064) Erreur de syntaxe près de ''0' à la ligne 1

Salut, Voilà j'ai fais une table pour les joueurs et quand il se créer un compte je optient ça [23:48:38] [ERROR] CMySQLQuery::Execute[] - (error #1064) Erreur de syntaxe près de '' à la ligne 1 Le compte se creer bien dans la base de donnée Le code quand je m'enregistre (PS juste le pseudo & ID & Mot de passe & l'IP s'enregistre bien) case DIALOG_REGISTER: { if(!response) return Kick(playerid); if(strlen(inputtext) < 5) { SendClientMessage(playerid, -1, "mot pas de passe avec 4 charac."); return ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "Inscription", "enregistre ton passe", "S'inscrire", "Quitter"); } new query[1024], playername[MAX_PLAYER_NAME], playerip[16]; GetPlayerName(playerid, playername, sizeof(playername)); GetPlayerIp(playerid, playerip, sizeof(playerip)); WP_Hash(pInfo[playerid][Pass], 129, inputtext); mysql_format(g_iHandle, query, sizeof(query), "INSERT INTO `accounts` (`Name`, `Password`, `IP`) VALUES ('%s', '%s', '%e')", playername, pInfo[playerid][Pass], playerip); mysql_tquery(g_iHandle, query, "OnAccountRegister", "i", playerid); pInfo[playerid][Level] = 1; pInfo[playerid][Skin] = 0; pInfo[playerid][Exp] = 1; pInfo[playerid][MaxExp] = 8; pInfo[playerid][Gender] = 0; pInfo[playerid][Registered] = 1; pInfo[playerid][Armour] = 0; pInfo[playerid][Health] = 100; pInfo[playerid][SecteID] = 0; pInfo[playerid][Grade] = 0; pInfo[playerid][PayeCheck] = 0; pInfo[playerid][PayeTime] = 0; pInfo[playerid][Vip] = 0; pInfo[playerid][Montre] = 0; pInfo[playerid][Gps] = 0; pInfo[playerid][Canne] = 0; pInfo[playerid][Phone] = 0; pInfo[playerid][Credits] = 0; pInfo[playerid][CarteIden] = 0; pInfo[playerid][DrogueFab1] = 0; pInfo[playerid][DrogueFab2] = 0; pInfo[playerid][DrogueFab3] = 0; pInfo[playerid][Cocaine] = 0; pInfo[playerid][Heroine] = 0; pInfo[playerid][Ecstacy] = 0; pInfo[playerid][Mort] = 0; pInfo[playerid][JailTime] = 0; pInfo[playerid][Amende] = 0; pInfo[playerid][Facture] = 0; pInfo[playerid][Emprunt] = 0; pInfo[playerid][Lotto] = 0; pInfo[playerid][Warn] = 0; pInfo[playerid][Baned] = 0; pInfo[playerid][Permis] = 0; pInfo[playerid][PermisPoint] = 0; pInfo[playerid][PortArme] = 0; pInfo[playerid][HandMoney] = 250; pInfo[playerid][BankMoney] = 0; pInfo[playerid][Mask] = 0; pInfo[playerid][MaskID] = 0; pInfo[playerid][PhoneNumber] = 0; pInfo[playerid][HouseOwner] = 9999; pInfo[playerid][VehicleOwner] = 9999; pInfo[playerid][VehicleOwner2] = 9999; pInfo[playerid][VehicleOwner3] = 9999; pInfo[playerid][BizOwner] = 9999; pInfo[playerid][FacOwner] = 9999; pInfo[playerid][Weapon1] = 0; pInfo[playerid][Wep1Ammo] = 0; pInfo[playerid][Weapon2] = 0; pInfo[playerid][Wep2Ammo] = 0; pInfo[playerid][Weapon3] = 0; pInfo[playerid][Wep3Ammo] = 0; pInfo[playerid][Weapon4] = 0; pInfo[playerid][Wep4Ammo] = 0; pInfo[playerid][Weapon5] = 0; pInfo[playerid][Wep5Ammo] = 0; pInfo[playerid][Weapon6] = 0; pInfo[playerid][Wep6Ammo] = 0; pInfo[playerid][Weapon7] = 0; pInfo[playerid][Wep7Ammo] = 0; GivePlayerMoney(playerid, pInfo[playerid][HandMoney]); ShowPlayerDialog(playerid, DIALOG_GENDER, DIALOG_STYLE_MSGBOX, "le sexze", "veuillez choisir votre sexe homme ou femme.", "Homme", "Femme"); SendClientMessage(playerid, -1, " "); SendClientMessage(playerid, -1, " "); SendClientMessage(playerid, -1, " "); SendClientMessage(playerid, -1, " "); SendClientMessage(playerid, -1, " "); SendClientMessage(playerid, -1, " "); SendClientMessage(playerid, -1, " "); SendClientMessage(playerid, -1, " "); SendClientMessage(playerid, -1, " "); SendClientMessage(playerid, -1, " "); SendClientMessage(playerid, -1, " "); SendClientMessage(playerid, -1, " "); SendClientMessage(playerid, -1, " "); format(string, sizeof(string), "bienvenue sur le server, %s!", pname); SendClientMessage(playerid, COLOR_GENERAL, string); SetSpawnInfo(playerid, 0, 0, 0.00, 0.00, 0.00, 0.00, 0, 0, 0, 0, 0, 0); SpawnPlayer(playerid); TogglePlayerControllable(playerid, 0); pInfo[playerid][pLogged] = 1; Puis quand le joueur se déconnecte célà fais ça [23:56:40] [ERROR] CMySQLQuery::Execute[] - (error #1366) Incorrect integer value: '' for column 'Arme3' at row 1 Et le code de sauvegarde du joueur SQL_SaveCharacter(playerid) { if (pInfo[playerid][pLogged] == 0) { return 0; } new query[1048]; printf("compte enregistrer"); pInfo[playerid][Skin] = GetPlayerSkin(playerid); GetPlayerHealth(playerid, pInfo[playerid][Health]); GetPlayerArmour(playerid, pInfo[playerid][Armour]); format(query, sizeof(query), "UPDATE `accounts` SET `Enregistrer` = '%d', `Admin` = '%d', `Level` = '%d', `Exp` = '%d', `MaxExp` = '%d', `Skin` = '%d', `Sexe` = '%d', `Vie` = '%d', `Gillet` = '%d', `Cash` = '%d', `BanqueCash` = '%d', `Masque` = '%d', `MasqueID` = '%d', `NumeroTel` = '%d', `Maison` = '%d', `Commerce` = '%d', `FactionProprio` = '%d', `Vehicule1` = '%d', `Vehicule2` = '%d', `Vehicule3` = '%d', `Faction` = '%d', `Grade` = '%d'", pInfo[playerid][Registered], pInfo[playerid][Admin], pInfo[playerid][Level], pInfo[playerid][Exp], pInfo[playerid][MaxExp], pInfo[playerid][Skin], pInfo[playerid][Gender], pInfo[playerid][Health], pInfo[playerid][Armour], pInfo[playerid][HandMoney], pInfo[playerid][BankMoney], pInfo[playerid][Mask], pInfo[playerid][MaskID], pInfo[playerid][PhoneNumber], pInfo[playerid][HouseOwner], pInfo[playerid][BizOwner], pInfo[playerid][FacOwner], pInfo[playerid][VehicleOwner], pInfo[playerid][VehicleOwner2], pInfo[playerid][VehicleOwner3], pInfo[playerid][SecteID], pInfo[playerid][Grade] ); format(query, sizeof(query), "%s, `ChequeJob` = '%d', `TempsTravail` = '%d', `Montre` = '%d', `GPS` = '%d', `Canne` = '%d', `Telephone` = '%d', `Credits` = '%d', `Identite` = '%d', `GramDrogue1` = '%d', `GramDrogue2` = '%d', `GramDrogue3` = '%d', `Cocaine` = '%d', `Heroine` = '%d', `Ecstacy` = '%d', `Mort` = '%d', `JailTemps` = '%d', `Amende` = '%d', `Facture` = '%d', `Emprunt` = '%d', `Lotto` = '%d', `Warn` = '%d'", query, pInfo[playerid][PayeCheck], pInfo[playerid][PayeTime], pInfo[playerid][Montre], pInfo[playerid][Gps], pInfo[playerid][Canne], pInfo[playerid][Phone], pInfo[playerid][Credits], pInfo[playerid][CarteIden], pInfo[playerid][DrogueFab1], pInfo[playerid][DrogueFab2], pInfo[playerid][DrogueFab3], pInfo[playerid][Cocaine], pInfo[playerid][Heroine], pInfo[playerid][Ecstacy], pInfo[playerid][Mort], pInfo[playerid][JailTime], pInfo[playerid][Amende], pInfo[playerid][Facture], pInfo[playerid][Emprunt], pInfo[playerid][Lotto], pInfo[playerid][Warn] ); format(query, sizeof(query), "%s, `Bannis` = '%d', `Permis` = '%d', `PointPermis` = '%d', `PortArme` = '%d', `Situation` = '%d', `Arme1` = '%d', `Minution1` = '%d', `Arme2` = '%d', `Minution2` = '%d', `Arme3` = '%s', `Minution3` = '%d', `Arme4` = '%d', `Minution4` = '%d', `Arme5` = '%d', `Minution5` = '%d', `Arme6` = '%d', `Minution6` = '%d', `Arme7` = '%d', `Minution7` = '%d' WHERE `ID` = '%d'", query, pInfo[playerid][Baned], pInfo[playerid][Permis], pInfo[playerid][PermisPoint], pInfo[playerid][PortArme], pInfo[playerid][LastPos], pInfo[playerid][Weapon1], pInfo[playerid][Wep1Ammo], pInfo[playerid][Weapon2], pInfo[playerid][Wep2Ammo], pInfo[playerid][Weapon3], pInfo[playerid][Wep3Ammo], pInfo[playerid][Weapon4], pInfo[playerid][Wep4Ammo], pInfo[playerid][Weapon5], pInfo[playerid][Wep5Ammo], pInfo[playerid][Weapon6], pInfo[playerid][Wep6Ammo], pInfo[playerid][Weapon7], pInfo[playerid][Wep7Ammo], pInfo[playerid][ID] ); mysql_tquery(g_iHandle, query); return 1; }

Oui

Oui

Résolu enft c'étais dans dans "Vie" il y'avais %d alors que sa devais être %4.0f

Plus maintenant sauf le SQL que je maitrise qu'as moitier

J'suis à l'aise avec le PAWN o_O quesque que tu raconte

Oui je vais essayer quand je retourne chez moi je vous tient au courant

SVP

UP alors vos nouvelle ?