mysql no insert data help.. -
Код:
new password[32]; GetPVarString(playerid,"Password",password,sizeof(password));
new properties_string[128];
for(new i = 0; i < MAX_PROPERTIES; i++)
{
new sub[20];
if(i == MAX_PROPERTIES-1) format(sub,sizeof(sub),"%s",Player_Properties[playerid][i]);
else format(sub,sizeof(sub),"%s,",Player_Properties[playerid][i]);
strcat(properties_string,sub);
}
new escape[128]; mysql_escape_string(query,escape);
format(query,sizeof(query),"INSERT INTO players (IP,Name,Password,Properties,RegDate,LogDate,Admin,JatekosPenz,JatekosSzint,PosX,PosY,PosZ,JatekosInti,JatekosOles,JatekosHalal,JatekosOra,JatekosPerc,JatekosMPerc,JatekosSkin,JatekosHP,JatekosPancel,JatekosAngle,JatekosWorld,JatekosKick,AdminKick,JatekosMunka,Korhaz,KorhazIdo,PremiumPont,JatekosNem,JatekosKor,JatekosTomeg,JatekosMeret,JatekosSzarmazas) VALUES ('%s','%s',MD5('%s'),'%s','%s','%s',%d,%d,%d,%f,%f,%f,%d,%d,%d,%d,%d,%d,%d,%f,%f,%f,%d,%d,%d,%d,%d,%d,%d,'%s','%s','%s','%s','%s')",
pIP(playerid),
pName(playerid),
password,
properties_string,
GetFormatedDate(),
GetFormatedDate(),
0,
750,
1,
1753.3008,
-1894.0869,
13.5572,
0,
0,
0,
0,
0,
0,
26,
100.00,
0.00,
266.8277,
0,
0,
0,
0,
0,
0,
0,
Player_Properties[playerid][P_SEX],
Player_Properties[playerid][P_AGE],
Player_Properties[playerid][P_HEIGHT],
Player_Properties[playerid][P_WEIGHT],
Player_Properties[playerid][P_COUNTRY]);
mysql_tquery(SQL,query);
Код:
IALOG(DIALOG_P_AGE)
{
if(!response) return ShowRegisterDialog(playerid,PHASE_PROPERTIES);
if(isnull(inputtext)) return ShowRegisterDialog(playerid,PHASE_PROPERTIES);
if(!IsNumeric(inputtext)) {ERR(playerid,"Csak szбmokat нrhatsz be!"); ShowRegisterDialog(playerid,PHASE_PROPERTIES);}
else
{
new sub[16]; format(sub,sizeof(sub),"%s",inputtext);
Player_Properties[playerid][P_AGE] = sub;
ShowRegisterDialog(playerid,PHASE_PROPERTIES);
}
return 1;
}
DIALOG(DIALOG_P_SEX)
{
if(!response) return ShowRegisterDialog(playerid,PHASE_PROPERTIES);
if(isnull(inputtext)) return ShowRegisterDialog(playerid,PHASE_PROPERTIES);
new sub[16]; format(sub,sizeof(sub),"%s",inputtext);
Player_Properties[playerid][P_SEX] = sub;
ShowRegisterDialog(playerid,PHASE_PROPERTIES);
return 1;
}
DIALOG(DIALOG_P_COUNTRY)
{
if(!response) return ShowRegisterDialog(playerid,PHASE_PROPERTIES);
if(isnull(inputtext)) return ShowRegisterDialog(playerid,PHASE_PROPERTIES);
new sub[16]; format(sub,sizeof(sub),"%s",inputtext);
Player_Properties[playerid][P_COUNTRY] = sub;
ShowRegisterDialog(playerid,PHASE_PROPERTIES);
return 1;
}
DIALOG(DIALOG_P_HEIGHT)
{
if(!response) return ShowRegisterDialog(playerid,PHASE_PROPERTIES);
if(isnull(inputtext)) return ShowRegisterDialog(playerid,PHASE_PROPERTIES);
if(!IsNumeric(inputtext)) {ERR(playerid,"Csak szбmokat нrhatsz be!"); ShowRegisterDialog(playerid,PHASE_PROPERTIES);}
else
{
new sub[16]; format(sub,sizeof(sub),"%s",inputtext);
Player_Properties[playerid][P_HEIGHT] = sub;
ShowRegisterDialog(playerid,PHASE_PROPERTIES);
}
return 1;
}
DIALOG(DIALOG_P_WEIGHT)
{
if(!response) return ShowRegisterDialog(playerid,PHASE_PROPERTIES);
if(isnull(inputtext)) return ShowRegisterDialog(playerid,PHASE_PROPERTIES);
if(!IsNumeric(inputtext)) {ERR(playerid,"Csak szбmokat нrhatsz be!"); ShowRegisterDialog(playerid,PHASE_PROPERTIES);}
else
{
new sub[16]; format(sub,sizeof(sub),"%s",inputtext);
Player_Properties[playerid][P_WEIGHT] = sub;
ShowRegisterDialog(playerid,PHASE_PROPERTIES);
}
return 1;
}
Re: mysql no insert data help.. -
Re: mysql no insert data help.. -
no log error... phpmyadmin table
Re: mysql no insert data help.. -