Suche MySQL Speicherungshilfen & Funktionsbehebung

ocmd:createcardealer(playerid,params[])
{
	new name[32],price,level,Float:xPos[3];
	if(pInfo[playerid][pAdmin] != 5)return 1;
	if(sscanf(params,"dds[32]",price,level,name))return SendClientMessage(playerid,COLOR_GREY,"Benutze: /ccd [Preis] [Level] [Name]");
	for(new i;i<MAX_AUTOHAUS;i++) {
	    if(AHInfo[i][zCreated])continue;
	    new str[256];
	    GetPlayerPos(playerid,xPos[0],xPos[1],xPos[2]);
	    format(str,sizeof str,"INSERT INTO `Cardealers` (`Owner`, `PosX`, `PosY`, `PosZ`, `Name`, `Price`, `Level`, `LPosX`, `LPosY`, `LPosZ`) VALUES ('Niemand', '%f', '%f', '%f', '%s', '%d', '%d', '%f', '%f', '%f')",xPos[0],xPos[1],xPos[2],name,price,level,xPos[0],xPos[1],xPos[2]);
	    mysql_query(str);
	    return LoadCarDealer(i);
	}
	return 1;
}

ocmd:buybiz(playerid,params[])
{
	if(pInfo[playerid][pAH] != -1 && pInfo[playerid][pBiz] != -1)return SendClientMessage(playerid,COLOR_LIGHTRED,"Du hast bereits ein Unternehmen!");
	for(new i;i<MAX_AUTOHAUS;i++) {
	    if(!AHInfo[i][zCreated])continue;
	    if(IsPlayerInRangeOfPoint(playerid,3,AHInfo[i][zPosX],AHInfo[i][zPosY],AHInfo[i][zPosZ])) {
	        if((!strcmp(AHInfo[i][zOwner],"Niemand",true))) {
	            if(pInfo[playerid][pMoney] >= AHInfo[i][zPrice]) {
	                if(GetPlayerScore(playerid) >= AHInfo[i][zLevel]) {
						GetPlayerName(playerid,sendername,sizeof sendername);
	                    pInfo[playerid][pMoney] -= AHInfo[i][zPrice];
	                    pInfo[playerid][pAH] = i;
	                    format(AHInfo[i][zOwner],24,"%s",sendername);
	                    SendClientMessage(playerid,COLOR_LIGHTGREEN,"Du hast dir das Autohaus erfolgreich gekauft!");
	                    SendClientMessage(playerid,COLOR_GREY,"Autohaus verwalten: /cardealer");
	                    KillCarDealer(i);
	                    return LoadCarDealer(i);
	                } else {
	                    return SendClientMessage(playerid,COLOR_LIGHTRED,"Dein Level reicht nicht aus, um dieses Autohaus zu kaufen!");
	                }
	            } else {
					return SendClientMessage(playerid,COLOR_LIGHTRED,"Du hast nicht genug Geld, um dieses Autohaus zu kaufen!");
	            }
	        } else {
				return SendClientMessage(playerid,COLOR_LIGHTRED,"Dieses Autohaus ist nicht zu verkaufen!");
	        }
	    }
	}

stock LoadCarDealers()
{
	mysql_query("SELECT * FROM `Cardealers`");
	mysql_store_result();
	new rows = mysql_num_rows();
	if(rows != 0 && rows <= 5) {
		new str[1024],idx=0;
		while(mysql_fetch_row(str)) {
		    new string[256];
		    sscanf(str, "e<p<|>ds[32]fffds[24]ddddfff>",AHInfo[idx]);
		    if((!strcmp(AHInfo[idx][zOwner],"Niemand",true))) {
				AHInfo[idx][zPickup]=CreatePickup(1273,1,AHInfo[idx][zPosX],AHInfo[idx][zPosY],AHInfo[idx][zPosZ],0);
				format(string,128,"** %s **\nDieses Autohaus ist zu verkaufen!\nPreis: %s€\nLevel: %d\nAutohaus kaufen: /buybiz",AHInfo[idx][zName],inspoints(AHInfo[idx][zPrice]),AHInfo[idx][zLevel]);
				AHInfo[idx][zLabel]=Create3DTextLabel(string,COLOR_AHLABEL,AHInfo[idx][zPosX],AHInfo[idx][zPosY],AHInfo[idx][zPosZ],10,0,1);
				AHInfo[idx][zCreated] = true;
			} else {
				AHInfo[idx][zPickup]=CreatePickup(1272,1,AHInfo[idx][zPosX],AHInfo[idx][zPosY],AHInfo[idx][zPosZ],0);
				format(string,128,"** %s **\nBesitzer: %s",AHInfo[idx][zName],AHInfo[idx][zOwner]);
				AHInfo[idx][zLabel]=Create3DTextLabel(string,COLOR_AHLABEL,AHInfo[idx][zPosX],AHInfo[idx][zPosY],AHInfo[idx][zPosZ],10,0,1);
				AHInfo[idx][zCreated] = true;
			}
		    idx++;
		}
		mysql_free_result();
	}
	return 1;
}