Voir les contributions
Cette section vous permet de consulter les contributions (messages, sujets et fichiers joints) d'un utilisateur. Vous ne pourrez voir que les contributions des zones auxquelles vous avez accès.
[MySQL 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 ''pName', 'pPassword', 'pMail', 'pAge', 'pSexe') values('Dean_Corll', '19FA61D755' at line 1, connection 1, callback '', query: 'INSERT INTO accounts('pName', 'pPassword', 'pMail', 'pAge', 'pSexe') values('Dean_Corll', '19FA61D75522A4669B44E39C1D2E1726C530232130D407F89AFEE0964997F7A73E83BE698B288FEBCF88E3E03C4F0757EA8964E59B63D93708B138CC42A66EB3', '[email protected]', '16', '0')'
/**** RolePlay Name Check ****/
new charCount[4], playerName[MAX_PLAYER_NAME];
GetPlayerName(playerid, playerName, MAX_PLAYER_NAME);
for(new i = 0; i < MAX_PLAYER_NAME; i++)
{switch(playerName[i]){case '[', ']', '(', ')' : charCount[0]++;case '0' .. '9' : charCount[1]++;case 'a' .. 'z' : charCount[2]++;case 'A' .. 'Z' : charCount[3]++;}
}
if(charCount[0])
{SendClientMessage(playerid, COLOR_RED, "Votre nom est invalide. \nil contient un caractére interdit.");SendClientMessage(playerid, COLOR_ORANGE, "Exemple de nom_prenom valide : John_Carter");return Kick(playerid);
}
if(charCount[1])
{SendClientMessage(playerid, COLOR_RED, "Votre nom est invalide.\n il contient un chiffre.");SendClientMessage(playerid, COLOR_ORANGE, "Exemple de nom_prenom valide : John_Carter");return Kick(playerid);
}
if(charCount[2] < 3)
{SendClientMessage(playerid, COLOR_RED, "un nom doit contenir au minimum 3 caractéres minuscules");SendClientMessage(playerid, COLOR_ORANGE, "Exemple de nom_prenom valide : John_Carter");return Kick(playerid);
}
if(charCount[3] != 2)
{SendClientMessage(playerid, COLOR_RED, "un nom_prenom doivent commencer par des majuscules");SendClientMessage(playerid, COLOR_ORANGE, "Exemple de nom_prenom valide : John_Carter");return Kick(playerid);
}
else ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_LIST, "Menu Inscription", "Suivre le tutoriel RolePlay\nS'incrire", "Choisir", "Annuler");
if(regex_match(playerName, "^[A-Z]{1}[a-zA-Z]{2,12}_[A-Z]{1}[a-z]{2,12}$"))
{
/ **** que faire si le nom est valide ****/
}
else // nom invalide
{
SendClientMessage(playerid, COLOR_RED, "Votre est incorrect. veuillez inserer un nom correct");
SendClientMessage(playerid, COLOR_ORANGE, "Exemple : John_Carter");
}
new engine,lights,alarm,doors,bonnet,boot,objective;
GetVehicleParamsEx(vid,engine,lights,alarm,doors,bonnet,boot,objective);
SetVehicleParamsEx(vid,1,lights,alarm,doors,bonnet,boot,objective);
CMD:gotop(playerid, params[])
{
new pid,
str[128],
Float:pos[3];
if(sscanf(params, "i", pid)) return SendClientMessage(playerid, COLOR_ERROR, "Usage : gotop [playerid]");
if(!IsPlayerConnected(pid)) return SendClientMessage(playerid, COLOR_ERROR, "Id invalide du joueur");
GetPlayerPos(pid,pos[0],pos[1],pos[2]);
SetPlayerPos(playerid, pos[0], pos[1], pos[2]);
format(str, sizeof(str), "Vous voues etes teleporté au joueur : %s", PlayerName(pid));
return SendClientMessage(playerid, COLOR_GREEN, str);
}
// Executez cette requete dans votre base de donnes //
DROP TABLE IF EXISTS `banlist`;
CREATE TABLE `banlist` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`name` varchar(25) NOT NULL,
`ip` varchar(50) NOT NULL,
`time` int(29) NOT NULL,
`reason` varchar(256) NOT NULL,
`adminname` varchar(25) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
// Voici le Code A recopier //
SetTimer("CountTimeBan", 60000, true); // Dans OnGameModeIni
// a la fin de votre Code //
public CountTimeBan()
{
new query[129], time;
for (new i = 1; i < 100 ; i++)
{
format(query, sizeof(query), "SELECT time FROM banlist WHERE id = %d",i);
mysql_query(query);
mysql_store_result();
time = mysql_fetch_int();
if (mysql_num_rows() !=0)
{
if(time == 0)
{
format(query, sizeof(query), "DELETE FROM banlist WHERE id = %d ",i );
mysql_query(query);
}
else
{
format(query, sizeof(query), "UPDATE banlist SET time = %d WHERE id = %d",time-1, i);
mysql_query(query);
}
}
mysql_free_result();
}
return 1;
}
CMD:freeze(playerid, params[])
{
new pid;
if (sscanf(params[], "i", pid)) return SendClientMessage(playerid, COLOR_RED, "Usage : freeze[playerid]");
if(!IsPlayerConnected(pid)) return SendClientMessage(playerid, COLOR_ERROR, "Id invalide du joueur");
TogglePlayerControllable(pid, 0);
}
CMD:unfreeze(playerid, params[])
{
new pid;
if (sscanf(params[], "i", pid)) return SendClientMessage(playerid, COLOR_RED, "Usage : unfreeze[playerid]");
if(!IsPlayerConnected(pid)) return SendClientMessage(playerid, COLOR_ERROR, "Id invalide du joueur");
TogglePlayerControllable(pid, 1);
}
// Au debut de votre Code
forward AFKTimer();
new Float:gPlayerPos[MAX_PLAYERS][6];
// Dans OnGameModeIni
SetTimer("AFKTimer", 3 * 60000, true);
// Au fin de votre code
public AFKTimer() {
for(new i =0 ; i< MAX_PLAYERS; i++)
{
GetPlayerPos(i, gPlayerPos[i][0], gPlayerPos[i][1], gPlayerPos[i][2]);
if(gPlayerPos[i][0] == gPlayerPos[i][3] && gPlayerPos[i][1] == gPlayerPos[i][4] && gPlayerPos[i][2] == gPlayerPos[i][5])
{
RemovePlayerFromVehicle(i);
SendClientMessage(i, COLOR_GREY, "Vous avait éte deconnecté a cause de votre inactivité.");
Kick(i);
}
else
{
gPlayerPos[i][3] = gPlayerPos[i][0];
gPlayerPos[i][4] = gPlayerPos[i][1];
gPlayerPos[i][5] = gPlayerPos[i][2];
}
}
}
stock PlayerName(playerid)
{
new pname[25];
GetPlayerName(playerid,pname,sizeof(pname));
return pname;
}
for(new i = 0; i < MAX_PLAYERS; i++)
{
if(IsPlayerConnected(i))
{
SetPlayerInterior(i, 1);
SetPlayerVirtualWorld(i, i);//tous des vw différents
SetPlayerPos(i, 1982.321, 1243.3213, 1005.31);
}
else
{
return break;
}
}
for ( new i = 0; i < MAX_PLAYER; i++)
{
SendClientMessage(playerid, COLOR_RED, "test");
}
for ( new i = 0; i < MAX_PLAYER; i++)
{
if(IsPlayerConnected(i))
{
SendClientMessage(playerid, COLOR_RED, "test");
}
else {return break;}
}
id _ auto increment
model
price
col1
col2
secured
x
y
z
a
enum vInfoE
{
id,
owner[25],
model,
price,
col[2],
secured,
Float:pos[4],
}
new VehicleInfo[MAX_VEHICLES][vInfoE];
stock LoadVehicles() // You might want to make this an public so you could call it on an timer.
{
new query[255];
for(new i = 1; i < MAX_VEHICLES; i++) // Makes an loop so all vehicles get loaded.
{
format(query, sizeof(query), "SELECT * FROM vehicles WHERE id= %d", i);
mysql_query(query); // Querys the "Query" Variable.
mysql_store_result(); // Stores the result from Query
if(mysql_num_rows() == 0){ continue; } // Checks if theres anyrow.
mysql_fetch_row_format(query, "|");
sscanf(query, "e<p<|>is[25]iiiffff>", VehicleInfo[i]);
new str[128];
format(str,sizeof(str),"veh %s",VehicleInfo[i][owner]);
print(str);
CreateVehicle(VehicleInfo[i][model],VehicleInfo[i][pos][0],VehicleInfo[i][pos][1],VehicleInfo[id][pos][2],VehicleInfo[i][pos][3],VehicleInfo[i][col][0],VehicleInfo[i][col][1], 10);
} CMD:vcreate(playerid, params[]) // Create vehicle command, not Tested.
{
new vmodel,vcol1,vcol2,Query[200];
if(sscanf(params, "iii", vmodel,vcol1,vcol2)) return SendClientMessage(playerid, COLOR_ADMIN, "Usage: /vreate [Model] [col1] [col2]");
new Float:pPOS[4];
GetPlayerPos(playerid, pPOS[0], pPOS[1], pPOS[2]);
GetPlayerFacingAngle(playerid , pPOS[3]);
format(Query, sizeof(Query), "INSERT INTO vehicles (owner, model, price, col1, col2, secured, x, y, z, a) VALUES ('%s', %d, %d, %d, %d, 0, %f, %f, %f, %f);",DEFAULT_VEHICLE_OWNER, vmodel, DEFAULT_SELL_PRICE, vcol1, vcol2, pPOS[0], pPOS[1], pPOS[2], pPOS[3]);
mysql_query(Query);
CreateVehicle(vmodel,pPOS[0],pPOS[1],pPOS[2],pPOS[3],vcol1,vcol2,10);
format(Query, sizeof(Query), "Created an %d at x: %f y: %f z: %f a: %f);",vmodel ,pPOS[0], pPOS[1], pPOS[2], pPOS[3]);
SendClientMessage(playerid, COLOR_ADMIN, Query);
return 1;
}
(const string1[], const string2[], bool:ignorecase, length)