10
« le: 02 Décembre 2009, 13:08:23 »
Hellow !
j'essaye de passé mon système de compte en SQL (en me basant sur Radmin)
donc voili voilou ca marche pas
Code :
<?php // pour metre les couleurs
public OnPlayerRegister(playerid, password[])
{
if(IsPlayerNPC(playerid)){ return 1; }
if(IsPlayerConnected(playerid))
{
new PlayerName[256];
new RPassword[60];
new string[256];
GetPlayerName(playerid, PlayerName, sizeof(PlayerName));
samp_mysql_real_escape_string(password[], RPassword);
if(MySQLCheckUserExistance(playerid))
{
format(string, sizeof(string), "ERREUR: le compte %s existe déjà. faites /login [password]", PlayerName);
SendClientMessage(playerid, COLOR_RED, string);
return 1;
}
format(query, sizeof(query), "INSERT INTO `users` (reg_id, Nom, Key, Level, AdminLevel, DonateRank, UpgradePoints, ConnectedTime, Registered, Sex, Age, Origin, CK, Muted, Respect, Money, Bank, Crimes, Kills, Deaths, Arrested, WantedDeaths, Phonebook, LottoNr, Fishes, BiggestFish, Job, Paycheck, HeadValue, Jailed, JailTime, Materials, Drugs, Leader, Member, FMember, Rank, Char, ContractTime, DetSkill, SexSkill, LawSkill, MechSkill, JackSkill, CarSkill, DrugsSkill, CookSkill, FishSkill, pSHealth) VALUES(0, \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", 750, 10000, \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", 50.0)",
PlayerName, RPassword,PlayerInfo[playerid][pLevel],PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pDonateRank],PlayerInfo[playerid][gPupgrade],PlayerInfo[playerid][pConnectTime],
PlayerInfo[playerid][pReg],PlayerInfo[playerid][pSex],PlayerInfo[playerid][pAge],PlayerInfo[playerid][pOrigin],PlayerInfo[playerid][pCK],PlayerInfo[playerid][pMuted],PlayerInfo[playerid][pExp],
PlayerInfo[playerid][pCrimes],PlayerInfo[playerid][pKills],PlayerInfo[playerid][pDeaths],PlayerInfo[playerid][pArrested],PlayerInfo[playerid][pWantedDeaths],PlayerInfo[playerid][pPhoneBook],
PlayerInfo[playerid][pLottoNr],PlayerInfo[playerid][pFishes],PlayerInfo[playerid][pBiggestFish],PlayerInfo[playerid][pJob],PlayerInfo[playerid][pPayCheck],PlayerInfo[playerid][pHeadValue],
PlayerInfo[playerid][pJailed],PlayerInfo[playerid][pJailTime],PlayerInfo[playerid][pMats],PlayerInfo[playerid][pDrugs],PlayerInfo[playerid][pLeader],PlayerInfo[playerid][pMember],
PlayerInfo[playerid][pFMember],PlayerInfo[playerid][pRank],PlayerInfo[playerid][pChar],PlayerInfo[playerid][pContractTime],PlayerInfo[playerid][pDetSkill],PlayerInfo[playerid][pSexSkill],
PlayerInfo[playerid][pBoxSkill],PlayerInfo[playerid][pLawSkill],PlayerInfo[playerid][pMechSkill],PlayerInfo[playerid][pJackSkill],PlayerInfo[playerid][pCarSkill],PlayerInfo[playerid][pDrugsSkill],
PlayerInfo[playerid][pCookSkill],PlayerInfo[playerid][pFishSkill]
);
samp_mysql_query(query);
format(query, sizeof(query), "SELECT `reg_id` FROM `users` WHERE `name` = '%s'", PlayerName);
samp_mysql_query(query);
samp_mysql_store_result();
SendClientMessage(playerid, COLOR_YELLOW, "Compte crée , merci à vous, vous pouvez désormais vous loggué (/login [password]).");
}
return 1;
}
Erreurs:
C:\Atlanta-RP\SAMP\samp0.3a\gamemodes\larp.pwn(10823) : error 029: invalid expression, assumed zero
C:\Atlanta-RP\SAMP\samp0.3a\gamemodes\larp.pwn(10829) : error 075: input line too long (after substitutions)
C:\Atlanta-RP\SAMP\samp0.3a\gamemodes\larp.pwn(10830) : error 037: invalid string (possibly non-terminated string)
C:\Atlanta-RP\SAMP\samp0.3a\gamemodes\larp.pwn(10830) : error 017: undefined symbol "INSERT"
C:\Atlanta-RP\SAMP\samp0.3a\gamemodes\larp.pwn(10830) : error 029: invalid expression, assumed zero
C:\Atlanta-RP\SAMP\samp0.3a\gamemodes\larp.pwn(10830) : fatal error 107: too many error messages on one line
Compilation aborted.Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase
6 Errors.
voila j'espert qu'on pourra m'aider !
++D4++