[AirPlus]

Hi Guys my MySQL Selfmade donґt Save the Accounts
heres my SaveCode:

Код:

function SpielerSpeichern(playerid) {
	new Query[2500];
	new PlayerName[MAX_PLAYER_NAME];
	GetPlayerName(playerid,PlayerName,sizeof(PlayerName));
	new Escapee[24];
	mysql_real_escape_string(PlayerName,Escapee);
	
    GetPlayerPos(playerid, SpielerInfo[playerid][Spawn][0],SpielerInfo[playerid][Spawn][1],SpielerInfo[playerid][Spawn][2]);
    GetPlayerFacingAngle(playerid, SpielerInfo[playerid][Spawn][3]);
    SpielerInfo[playerid][InteriorSpawn] = GetPlayerInterior(playerid);
    SpielerInfo[playerid][WorldSpawn] = GetPlayerVirtualWorld(playerid);
	
	format(Query,sizeof(Query),"UPDATE `accounts` SET `AdminLevel` = '%i', `Money` = '%i', `Bank` = '%i', `Faction` = '%i', `Rank` = '%i', `HouseKey` = '%i' WHERE `Name` = '%s'",SpielerInfo[playerid][AdminLevel],GetPlayerCash(playerid),SpielerInfo[playerid][Bank],SpielerInfo[playerid][Faction],SpielerInfo[playerid][Rank],SpielerInfo[playerid][HouseKey],Escapee);
	mysql_query(Query);
	mysql_store_result();
	
	format(Query,sizeof(Query),"UPDATE `accounts` SET `BizKey` = '%i', `Skin` = '%i', `Spawn1` = '%f', `Spawn2` = '%f', `Spawn3` = '%f', `Spawn4` = '%f', `Spawn5` = '%i', `Reg` = '%i' WHERE `Name` = '%s'",SpielerInfo[playerid][BizKey],GetPlayerSkin(playerid),SpielerInfo[playerid][Spawn][0],SpielerInfo[playerid][Spawn][1],SpielerInfo[playerid][Spawn][2],SpielerInfo[playerid][Spawn][3],SpielerInfo[playerid][InteriorSpawn],SpielerInfo[playerid][Reg],Escapee);
	mysql_query(Query);
	mysql_store_result();
	
	format(Query,sizeof(Query),"UPDATE `accounts` SET `Sex` = '%i', `Wallet` = '%i', `Renting` = '%i', `Products` = '%i' `PhoneNumber` = '%i', `Minuted` = '%i', `Spawn6` = '%i', `Prisoned` = '%i' WHERE `Name` = '%s'",SpielerInfo[playerid][Sex],GetPlayerWalletCash(playerid),SpielerInfo[playerid][Renting],SpielerInfo[playerid][Products],SpielerInfo[playerid][PhoneNumber],SpielerInfo[playerid][Minutes],
	SpielerInfo[playerid][WorldSpawn],SpielerInfo[playerid][Prisoned],Escapee);
	mysql_query(Query);
	mysql_store_result();
	
	format(Query,sizeof(Query),"UPDATE `accounts` SET `Jailed` = '%i', `JailTime` = '%i', `Cell` = '%i', `Towe` = '%i', `License` = '%i', `Linked` = '%i', `ForumName` = 'i' `ForumPassword` = '%i', `wLicense` = '%i' WHERE `Name` = '%s'",SpielerInfo[playerid][Jailed],SpielerInfo[playerid][JailTime],SpielerInfo[playerid][Cell],SpielerInfo[playerid][Towe],SpielerInfo[playerid][License],SpielerInfo[playerid][Linked],
	SpielerInfo[playerid][ForumName],SpielerInfo[playerid][ForumPassword],SpielerInfo[playerid][wLicense],Escapee);
	mysql_query(Query);
	mysql_store_result();
	
	format(Query,sizeof(Query),"UPDATE `accounts` SET `Job` = '%i', `Donator` = %i', `CarParts` = '%i', `PlayingTime` = '%i', `FightingStyle` = '%i', `Materials` = '%i' WHERE NAME `Name` = '%s'",SpielerInfo[playerid][pJob],SpielerInfo[playerid][Donator],SpielerInfo[playerid][CarParts],SpielerInfo[playerid][PlayingTime],SpielerInfo[playerid][FightingStyle],SpielerInfo[playerid][Materials],Escapee);
	mysql_query(Query);
	mysql_store_result();
	
	mysql_free_result();
	print("Spieler gespeichert...");
	return 1;
}

[[HiC]TheKiller]

Use

pawn Код:

mysql_debug(1);

on OnGameModeInit and paste your mysql_log in your server directory here.