Housing Mysql System Problem - Printable Version

Housing Mysql System Problem - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Housing Mysql System Problem (/showthread.php?tid=189544)

Housing Mysql System Problem - Kyle - 12.11.2010

I have Made a housing system for my server on mysql.

But The problem is that when I enter the house checkpoints house cp 1-11 work fine.

But the 12+ dont work, when I go inside nothing shows its weird.

Ive got this upon when it creates the checkpoint:

HouseCheckpoint2[count] = CreateDynamicCP(....); (Dont worry about count)

pawn Код:

new stringer[156],count;
    
format(stringer,sizeof(stringer),"SELECT * FROM houses");
mysql_query(stringer);
mysql_store_result();


count = mysql_affected_rows();
count = count ++;

Loop(h, count) 
{
if(checkpointid == HouseCheckpoint2[h]) 
{
    SHOWTEXTDRAWHERE
}

I printed the values of HouseCheckpoint2[h] and they work fine uptill cp 11. Where the varible is always +1 ahead of checkpoint id.

Help please