Проблема Mysql

[Bandit377 0]

Перевел систему на mysql, почему не загружаются? Сохраняется все нормально, работает, но не загружается

Таблица

padik.sql

//=======================================================================
stock LoadPadik()
{
	new query[2000]
	mysql_query("SELECT * FROM `"TABLE_PADIK"` ORDER BY `"TABLE_PADIK"`.`ID` ASC ");
 	mysql_store_result();
 	for(new padik = 1; padik <= AllPadik; padik++)
    if(mysql_num_rows() > 0)
 	{
		for(new idx = 1; idx <= mysql_num_rows(); idx++)
		{
			mysql_fetch_row(query);
			sscanf(query, "p<|>iffffffiii",
			Padik[idx][paID],
			Padik[idx][paiX],
			Padik[idx][paiY],
			Padik[idx][paiZ],
			Padik[idx][pavX],
			Padik[idx][pavY],
			Padik[idx][pavZ],
			Padik[idx][paInt],
			Padik[idx][pavWorld],
			Padik[idx][pavInt]);
			AllPadik++;
  	      	new p[64];
			format(p,64,"{FF0000}??????? ?????: {33AA33}%d",padik);
			Create3DTextLabel(p,COLOR_BLUE,Padik[padik][pavX], Padik[padik][pavY], Padik[padik][pavZ],50.0,0,1);
			Padik[padik][paPic] = CreateDynamicPickup(1318, 1, Padik[padik][pavX], Padik[padik][pavY], Padik[padik][pavZ],Padik[padik][pavWorld],Padik[padik][pavInt]);
			Padik[padik][paPic2] = CreateDynamicPickup(1318, 1, Padik[padik][paiX], Padik[padik][paiY], Padik[padik][paiZ], padik, Padik[padik][paInt]);
		}
	}
	mysql_free_result();
	print("\n----------------------------------");
    return printf("???? ????????? %d ?????????.", AllPadik);
}

CMD:addpadik(playerid,params[])
{
	if(Player[playerid][pAdmin] <= 6) return  SendClientMessage(playerid, COLOR_WHITE, "??? ?? ???????? ?????? ???????");
	AllPadik++;
	new i = AllPadik;
    new Float:POS[3];
	GetPlayerPos(playerid, POS[0], POS[1], POS[2]);
	Padik[i][pavX] = POS[0], Padik[i][pavY] = POS[1], Padik[i][pavZ] = POS[2];
	Padik[i][paiX] = 2403.1;
	Padik[i][paiY] = -2503.5;
	Padik[i][paiZ] = -50.1;
	Padik[i][paInt] = i;
	Padik[i][pavWorld] = GetPlayerVirtualWorld(playerid);
	Padik[i][pavInt] = GetPlayerInterior(playerid);
	Padik[i][paPic] = CreateDynamicPickup(1318, 1, Padik[i][pavX], Padik[i][pavY], Padik[i][pavZ],Padik[i][pavWorld],Padik[i][pavInt]);
	Padik[i][paPic2] = CreateDynamicPickup(1318, 1, Padik[i][paiX], Padik[i][paiY], Padik[i][paiZ], AllPadik, Padik[i][paInt]);
	format(Query, 1000, "INSERT INTO "TABLE_PADIK" (ID, paiX, paiY, paiZ, pavX, pavY, pavZ, paInt, pavWorld, pavInt) VALUES ('%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i')", i, Padik[i][paiX], Padik[i][paiY], Padik[i][paiZ], Padik[i][pavX], Padik[i][pavY], Padik[i][pavZ], Padik[i][paInt], Padik[i][pavWorld], Padik[i][pavInt]);
    mysql_query(Query);
	SendClientMessage(playerid,COLOR_GRAD2,"[??????]: ?? ??????? ??????? ???????!");
	new p[64];
	format(p,64,"{FF0000}??????? ?????: {33AA33}%d",i);
	Create3DTextLabel(p,COLOR_BLUE,Padik[AllPadik][pavX], Padik[AllPadik][pavY], Padik[AllPadik][pavZ],50.0,0,1);
	return true;
}

Изменено 23 ноября, 2015 пользователем Smolin

[Smolin 1,410]

LoadPadik в OnGameModeInit есть?

[Bandit377 0]

@Smolin, Конечно

[Bandit377 0]

UP

[Bandit377 0]

UP