Hadeszeus
New member
Got this error
[SQL]: DB error - Incorrect table name ''[Debug]: at npc.c:1432 - SELECT `name`, `itemid`, `amount` FROM ``
When I check that line I saw this
I check my database and I have npc_market_data <-- table
I also created npc_market_data_db
but stil getting npc.c error on this line.
[SQL]: DB error - Incorrect table name ''[Debug]: at npc.c:1432 - SELECT `name`, `itemid`, `amount` FROM ``
When I check that line I saw this
Code:
void npc_market_fromsql(void) { SqlStmt* stmt = SQL->StmtMalloc(map->mysql_handle); char name[NAME_LENGTH+1]; int itemid; int amount; if ( SQL_ERROR == SQL->StmtPrepare(stmt, "SELECT `name`, `itemid`, `amount` FROM `%s`", map->npc_market_data_db) || SQL_ERROR == SQL->StmtExecute(stmt) ) { SqlStmt_ShowDebug(stmt); SQL->StmtFree(stmt); return; }I also created npc_market_data_db
but stil getting npc.c error on this line.
