[Coicatak]

Hi, I got a big problem that I can't fix for HOURS.

here's the buggy function, actually totalannonce is supposed to be 10 but after the line "mysql_fetch_field_row(Field,"text");" it magically sets itself to 101 for no appearent reason...

pawn Code:

#define MAX_ANNOUNCEMENTS  10
enum rInfo
{
    rName[30],
    rText[128],
    rContact[20],
    rBusy
}new Recuiting[MAX_ANNOUNCEMENTS+1][rInfo];

stock LoadSQLRecuiting()
{
      new totalannonce;
    new Field[64];
    new Data[256];
    new sql[80];
    format(sql, sizeof(sql), "SELECT COUNT(*) FROM annonces");
    mysql_query(sql);
    mysql_store_result();
    mysql_fetch_row(Data);
    totalannonce = strval(Data);
    mysql_free_result();
    for (new idx=1; idx<=totalannonce; idx++)
    {
      format(sql, sizeof(sql), "SELECT * FROM annonces WHERE id=%d", idx);
      mysql_query(sql);
      mysql_store_result();
      if (mysql_num_rows() > 0)
      {
          mysql_fetch_row(Data);
      
          mysql_fetch_field_row(Field,"name");
          printf("%s, %d, %d", Field, totalannonce, idx);
          strmid(Recuiting[idx][rName],Field,0,strlen(Field),50);
          mysql_fetch_field_row(Field,"text");
          printf("%s, %d", Field, totalannonce);
          strmid(Recuiting[idx][rText],Field,0,strlen(Field),128);
          mysql_fetch_field_row(Field,"contact");
          printf("%s, %d", Field, totalannonce);
          strmid(Recuiting[idx][rContact],Field,0,strlen(Field),20);
          mysql_fetch_field_row(Field,"busy");
          Recuiting[idx][rBusy] = strval(Field);
        }
        mysql_free_result();
    }
    printf("%d recuiting announcements loaded from DB.", totalannonce);
    return 1;
}

Here are server logs:

Quote:

[17:35:14][17:35:14] Sweeper, 10, 1 [17:35:14] Vous conduisez une balayeuse а travers Los Santos afin de nettoyer les rues, 101 [17:35:14] ((/sweeper)), 101 [17:35:14] Aucun, 101, 2 [17:35:14] Aucun, 101 [17:35:14] Aucun, 101 [17:35:14] Aucun, 101, 3 [17:35:14] Aucun, 101 [17:35:14] Aucun, 101 [17:35:14] Aucun, 101, 4 [17:35:14] Aucun, 101 [17:35:14] Aucun, 101 [17:35:14] Aucun, 101, 5 [17:35:14] Aucun, 101 [17:35:14] Aucun, 101 [17:35:14] Aucun, 101, 6 [17:35:14] Aucun, 101 [17:35:14] Aucun, 101 [17:35:14] Aucun, 101, 7 [17:35:14] Aucun, 101 [17:35:14] Aucun, 101 [17:35:14] Aucun, 101, 8 [17:35:14] Aucun, 101 [17:35:14] Aucun, 101 [17:35:14] Aucun, 101, 9 [17:35:14] Aucun, 101 [17:35:14] Aucun, 101 [17:35:14] Aucun, 101, 10 [17:35:14] Aucun, 101 [17:35:14] Aucun, 101 [17:35:14] 101 recuiting announcements loaded from DB.

here is a screen of the DB:


This is really annoying, so if anyone could help me... Thanks