[iGetty]

pawn Код:

format(query, sizeof(query), "SELECT * FROM kasutajad WHERE nimi = '%s' AND parool = '%s' LIMIT 1", pName, inputtext);
                mysql_query(query);

                if(mysql_num_rows() == 1)

You're not storing the result.

After the query, type:

mysql_store_result();

It should then work, since it's getting data from nothing there.