04.10.2014, 23:30
It successfully loads but doesn't successfully save
[19:22:41] [DEBUG] cache_get_row_count - connection: 1
[19:22:41] [WARNING] cache_get_row_count - no active cache
[19:22:41] [DEBUG] cache_get_row_count - connection: 1
[19:22:41] [WARNING] cache_get_row_count - no active cache
pawn Код:
public OnDoorSave()
{
new saved = 0;
if(cache_num_rows())
{
for(new dd = 0; dd <cache_num_rows(); dd++)
{
new query[500];
mysql_format(mysql, query, sizeof(query), "UPDATE `dynamicdoors` SET `Created`=%d, `Owner`=%s, `Name`=%s, `Password`=%s, `PassSwitch`=%s, WHERE `ID`=%d", \
DynamicDoor[dd][ddCreated], DynamicDoor[dd][ddOwner], DynamicDoor[dd][ddName], DynamicDoor[dd][ddPassword], DynamicDoor[dd][ddPasswordSwitch], DynamicDoor[dd][ddID]);
mysql_tquery(mysql, query, "", "");
mysql_format(mysql, query, sizeof(query), "UPDATE `dynamicdoors` SET `Entry_X`=%f, `Entry_Y`=%f, `Entry_Z`=%f, `Entry_Y`=%f,`Entry_VW`=%d, `Entry_Int`=%d, WHERE `ID`=%d", \
DynamicDoor[dd][ddEnt][0], DynamicDoor[dd][ddEnt][1], DynamicDoor[dd][ddEnt][2], DynamicDoor[dd][ddEnt][3], DynamicDoor[dd][ddEntVW], DynamicDoor[dd][ddEntInt], DynamicDoor[dd][ddID]);
mysql_tquery(mysql, query, "", "");
mysql_format(mysql, query, sizeof(query), "UPDATE `dynamicdoors` SET `Ex_X`=%f, `Ex_Y`=%f, `Ex_Z`=%f, `Ex_Y`=%A,`Ex_VW`=%d, `Ex_Int`=%d, WHERE `ID`=%d", \
DynamicDoor[dd][ddEx][0], DynamicDoor[dd][ddEx][1], DynamicDoor[dd][ddEx][2], DynamicDoor[dd][ddEx][3], DynamicDoor[dd][ddExVW], DynamicDoor[dd][ddExInt], DynamicDoor[dd][ddID]);
mysql_tquery(mysql, query, "", "");
saved++;
}
}
printf("Doors Saved: %d", saved);
return 1;
}