[MySQL] Multi Account does't save
#1

Hey, i made an Multi Accounting System, and i have copied my normal save Function, and changed it to the Multi Account Variables and so on, and it doesn't do anything really, i don't know why
Can someone help me?
Reply
#2

without the code we can do nothing
Reply
#3

Can you at least post any code?
Reply
#4

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;
}
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)