Quote:
Originally Posted by willbedie
Can you at least post any code?
|
Yea, here:
My Saving FUnction that is working for my normal Account system:
Код:
savePlayer(playerid)
{
if(onmulti[playerid] == 1)return 1;
new query[1024];
if(gespawnt[playerid] != 2)return 1;
if(SkinVorschau[playerid] == 1)
{
format(query,sizeof(query),"UPDATE user SET level='%i',alevel='%i',euro='%i',fraktion='%i',rang='%i',wanteds='%i',payday='%i',auto='%i',aSchein='%i',konto='%i',rpname='%s',frakwarnings='%i',paydaytime='%i',banreason='%s',banned='%i',perso='%i',salter='%i',wohnort='%s',multi='%i' WHERE id='%i'",
sInfo[playerid][level],sInfo[playerid][alevel],sInfo[playerid][euro],sInfo[playerid][fraktion],sInfo[playerid][rang],sInfo[playerid][wanteds],sInfo[playerid][payday],sInfo[playerid][auto],sInfo[playerid][aSchein],sInfo[playerid][konto],sInfo[playerid][rpname],sInfo[playerid][frakwarnings],sInfo[playerid][paydaytime],sInfo[playerid][banreason],sInfo[playerid][banned],sInfo[playerid][perso],sInfo[playerid][alter],sInfo[playerid][wohnort],sInfo[playerid][multi],sInfo[playerid][db_id]);
mysql_function_query(dbhandle,query,false,"","");
return 1;
}
if(lspdduty[playerid] == 1)
{
format(query,sizeof(query),"UPDATE user SET level='%i',alevel='%i',euro='%i',fraktion='%i',rang='%i',wanteds='%i',payday='%i',auto='%i',aSchein='%i',konto='%i',rpname='%s',frakwarnings='%i',paydaytime='%i',banreason='%s',banned='%i',perso='%i',salter='%i',wohnort='%s',multi='%i' WHERE id='%i'",
sInfo[playerid][level],sInfo[playerid][alevel],sInfo[playerid][euro],sInfo[playerid][fraktion],sInfo[playerid][rang],sInfo[playerid][wanteds],sInfo[playerid][payday],sInfo[playerid][auto],sInfo[playerid][aSchein],sInfo[playerid][konto],sInfo[playerid][rpname],sInfo[playerid][frakwarnings],sInfo[playerid][paydaytime],sInfo[playerid][banreason],sInfo[playerid][banned],sInfo[playerid][perso],sInfo[playerid][alter],sInfo[playerid][wohnort],sInfo[playerid][multi],sInfo[playerid][db_id]);
mysql_function_query(dbhandle,query,false,"","");
return 1;
}
if(sarcduty[playerid] == 1)
{
format(query,sizeof(query),"UPDATE user SET level='%i',alevel='%i',euro='%i',fraktion='%i',rang='%i',wanteds='%i',payday='%i',auto='%i',aSchein='%i',konto='%i',rpname='%s',frakwarnings='%i',paydaytime='%i',banreason='%s',banned='%i',perso='%i',salter='%i',wohnort='%s',multi='%i' WHERE id='%i'",
sInfo[playerid][level],sInfo[playerid][alevel],sInfo[playerid][euro],sInfo[playerid][fraktion],sInfo[playerid][rang],sInfo[playerid][wanteds],sInfo[playerid][payday],sInfo[playerid][auto],sInfo[playerid][aSchein],sInfo[playerid][konto],sInfo[playerid][rpname],sInfo[playerid][frakwarnings],sInfo[playerid][paydaytime],sInfo[playerid][banreason],sInfo[playerid][banned],sInfo[playerid][perso],sInfo[playerid][alter],sInfo[playerid][wohnort],sInfo[playerid][multi],sInfo[playerid][db_id]);
mysql_function_query(dbhandle,query,false,"","");
return 1;
}
format(query,sizeof(query),"UPDATE user SET level='%i',alevel='%i',skin='%i',euro='%i',fraktion='%i',rang='%i',wanteds='%i',payday='%i',auto='%i',aSchein='%i',konto='%i',rpname='%s',frakwarnings='%i',paydaytime='%i',banreason='%s',banned='%i',perso='%i',salter='%i',wohnort='%s',multi='%i' WHERE id='%i'",
sInfo[playerid][level],sInfo[playerid][alevel],sInfo[playerid][skin],sInfo[playerid][euro],sInfo[playerid][fraktion],
sInfo[playerid][rang],sInfo[playerid][wanteds],sInfo[playerid][payday],sInfo[playerid][auto],sInfo[playerid][aSchein],sInfo[playerid][konto],sInfo[playerid][rpname],sInfo[playerid][frakwarnings],sInfo[playerid][paydaytime],sInfo[playerid][banreason],sInfo[playerid][banned],sInfo[playerid][perso],sInfo[playerid][alter],sInfo[playerid][wohnort],sInfo[playerid][multi],sInfo[playerid][db_id]);
mysql_function_query(dbhandle,query,false,"","");
return 1;
}
my not working saveMultiPlayer Code:
Код:
saveMultiPlayer(playerid)
{
if(onmulti[playerid] == 0)return 1;
new query[1024];
if(SkinVorschau[playerid] == 1)
{
format(query,sizeof(query),"UPDATE multiuser SET level='%i',euro='%i',fraktion='%i',rang='%i',wanteds='%i',payday='%i',auto='%i',aSchein='%i',konto='%i',rpname='%s',frakwarnings='%i',paydaytime='%i',perso='%i',salter='%i',wohnort='%s' WHERE id='%i'",
smInfo[playerid][mlevel],smInfo[playerid][meuro],smInfo[playerid][mfraktion],smInfo[playerid][mrang],smInfo[playerid][mwanteds],smInfo[playerid][mpayday],smInfo[playerid][mauto],smInfo[playerid][maSchein],smInfo[playerid][mkonto],smInfo[playerid][mrpname],smInfo[playerid][mfrakwarnings],smInfo[playerid][mpaydaytime],smInfo[playerid][mperso],smInfo[playerid][malter],smInfo[playerid][mwohnort],smInfo[playerid][db_id]);
mysql_function_query(dbhandle,query,false,"","");
return 1;
}
if(lspdduty[playerid] == 1)
{
format(query,sizeof(query),"UPDATE multiuser SET level='%i',euro='%i',fraktion='%i',rang='%i',wanteds='%i',payday='%i',auto='%i',aSchein='%i',konto='%i',rpname='%s',frakwarnings='%i',paydaytime='%i',perso='%i',salter='%i',wohnort='%s' WHERE id='%i'",
smInfo[playerid][mlevel],smInfo[playerid][meuro],smInfo[playerid][mfraktion],smInfo[playerid][mrang],smInfo[playerid][mwanteds],smInfo[playerid][mpayday],smInfo[playerid][mauto],smInfo[playerid][maSchein],smInfo[playerid][mkonto],smInfo[playerid][mrpname],smInfo[playerid][mfrakwarnings],smInfo[playerid][mpaydaytime],smInfo[playerid][mperso],smInfo[playerid][malter],smInfo[playerid][mwohnort],smInfo[playerid][db_id]);
mysql_function_query(dbhandle,query,false,"","");
return 1;
}
if(sarcduty[playerid] == 1)
{
format(query,sizeof(query),"UPDATE multiuser SET level='%i',euro='%i',fraktion='%i',rang='%i',wanteds='%i',payday='%i',auto='%i',aSchein='%i',konto='%i',rpname='%s',frakwarnings='%i',paydaytime='%i',perso='%i',salter='%i',wohnort='%s' WHERE id='%i'",
smInfo[playerid][mlevel],smInfo[playerid][meuro],smInfo[playerid][mfraktion],smInfo[playerid][mrang],smInfo[playerid][mwanteds],smInfo[playerid][mpayday],smInfo[playerid][mauto],smInfo[playerid][maSchein],smInfo[playerid][mkonto],smInfo[playerid][mrpname],smInfo[playerid][mfrakwarnings],smInfo[playerid][mpaydaytime],smInfo[playerid][mperso],smInfo[playerid][malter],smInfo[playerid][mwohnort],smInfo[playerid][db_id]);
mysql_function_query(dbhandle,query,false,"","");
return 1;
}
format(query,sizeof(query),"UPDATE multiuser SET level='%i',skin='%i',euro='%i',fraktion='%i',rang='%i',wanteds='%i',payday='%i',auto='%i',aSchein='%i',konto='%i',rpname='%s',frakwarnings='%i',paydaytime='%i',perso='%i',salter='%i',wohnort='%s' WHERE id='%i'",
smInfo[playerid][mlevel],smInfo[playerid][mskin],smInfo[playerid][meuro],smInfo[playerid][mfraktion],smInfo[playerid][mrang],smInfo[playerid][mwanteds],smInfo[playerid][mpayday],smInfo[playerid][mauto],smInfo[playerid][maSchein],smInfo[playerid][mkonto],smInfo[playerid][mrpname],smInfo[playerid][mfrakwarnings],smInfo[playerid][mpaydaytime],smInfo[playerid][mperso],smInfo[playerid][malter],smInfo[playerid][mwohnort],smInfo[playerid][db_id]);
mysql_function_query(dbhandle,query,false,"","");
return 1;
}