[knuckleduster5]

Hello guys,

I'm trying to learn MySQL with easy-mysql.inc. I want to code dynamic pickup system but my system doesn't work/save veriables.

Here is my database:

Код:

    if(!SQL::ExistsTable("doors")) 
    {
        new database = SQL::Open(SQL::CREATE, "doors");
        SQL::AddTableEntry(database, "d_sqlid", SQL_TYPE_INT, 11, true);
        SQL::AddTableEntry(database, "d_pickupid", SQL_TYPE_INT);
        SQL::AddTableEntry(database, "d_posx", SQL_TYPE_FLOAT);
        SQL::AddTableEntry(database, "d_posy", SQL_TYPE_FLOAT);
        SQL::AddTableEntry(database, "d_posz", SQL_TYPE_FLOAT);
        SQL::Close(database);
	}

/createdoor code:

Код:

CMD:createdoor(playerid, params[])
{
	new k = SQL::CountRows("doors")+1;
	for(new id = -1; id < k; id++)
	{
	new pickup;
	if(sscanf(params, "d", pickup)) return SendClientMessage(playerid, -1, "SYNTAX: /createdoor (pickupid)");
	new Float:X, Float:Y, Float:Z, label[96];
	GetPlayerPos(playerid, X, Y, Z);
	DoorInfo[id][d_pickupid] = pickup;
        DoorInfo[id][d_posx] = X;
        DoorInfo[id][d_posy] = Y;
        DoorInfo[id][d_posz] = Z;
	DoorInfo[id][doorpickup] = CreateDynamicPickup(DoorInfo[id][d_pickupid], 1, DoorInfo[id][d_posx], DoorInfo[id][d_posy], DoorInfo[id][d_posz], -1);
	SaveDoor(id);
	}
	return 1;
}

SaveDoor stock:

Код:

stock SaveDoor(id)
{
	new save = SQL::Open(SQL::INSERT, "doors");
	SQL::ToggleAutoIncrement(save, true);
	SQL::WriteInt(save, "k_pickupid", DoorInfo[id][d_pickupid]);
	SQL::WriteFloat(save, "k_posx", DoorInfo[id][d_posx]);
	SQL::WriteFloat(save, "k_posy", DoorInfo[id][d_posy]);
	SQL::WriteFloat(save, "k_posz", DoorInfo[id][d_posz]);
	DoorInfo[id][d_sqlid] = SQL::Close(save);
}

OnGameModeInit codes:

Код:

    new k = SQL::CountRows("doors")+1;
	for(new id = -1; id < k; id++)
	{
	new islem = SQL::Open(SQL::READ, "doors", "d_sqlid", DoorInfo[id][d_sqlid]);
	SQL::ReadInt(islem, "d_pickupid", DoorInfo[id][d_pickupid]);
	SQL::ReadFloat(islem, "d_posx", DoorInfo[id][d_posx]);
	SQL::ReadFloat(islem, "d_posy", DoorInfo[id][d_posy]);
	SQL::ReadFloat(islem, "d_posz", DoorInfo[id][d_posz]);
	SQL::Close(islem);
	DoorInfo[id][doorpickup] = CreateDynamicPickup(DoorInfo[id][d_pickupid], 1, DoorInfo[id][d_posx], DoorInfo[id][d_posy], DoorInfo[id][d_posz], -1);

Where am I doing wrong?

[knuckleduster5]

bump

[amirm3hdi]

Don't just give us big ass codes...

Try to use printf() function and see what loads and what saves...
You can debug easily.

[knuckleduster5]

Quote:

Originally Posted by amirm3hdi Don't just give us big ass codes... Try to use printf() function and see what loads and what saves... You can debug easily.

Can you give an example?

[knuckleduster5]

bump

[FreAkeD]

https://sampwiki.blast.hk/wiki/Printf
https://sampwiki.blast.hk/wiki/Debugging

[knuckleduster5]

Quote:

Originally Posted by amirm3hdi Don't just give us big ass codes... Try to use printf() function and see what loads and what saves... You can debug easily.

Fixed, thank you.

[amirm3hdi]

Quote:

Originally Posted by knuckleduster5 Fixed, thank you.

Always debug as much as you can before posting a thread