Template:DungeonNpc: Difference between revisions

From RuneTails
No edit summary
No edit summary
Line 2: Line 2:
  db=WikiDB
  db=WikiDB
  |from = Npcs
  |from = Npcs
  |where = NpcId = 67
  |where = NpcId = {{{nID}}}
  |data = dbNpcName=NpcName, dbSpriteURL=SpriteURL, dbLevel=Level, dbExp=Exp, dbHP=HP, dbDmg=Dmg, dbDmgCrit=DmgCrit, dbBlock=Block
  |data = dbNpcName=NpcName, dbSpriteURL=SpriteURL, dbLevel=Level, dbExp=Exp, dbHP=HP, dbDmg=Dmg, dbDmgCrit=DmgCrit, dbBlock=Block
}}
}}

Revision as of 03:16, 27 February 2025

The query SELECT NpcName, SpriteURL, Level, Exp, HP, Dmg, DmgCrit, Block FROM Npcs AS Npcs WHERE NpcId = {{{nID}}}  ; is invalid (odbc_exec(): SQL error: [Microsoft][ODBC Driver 17 for SQL Server]Syntax error, permission violation, or other nonspecific error, SQL state 37000 in SQLExecDirect).

Error: no local variable "dbNpcName" has been set.
Error: no local variable "dbSpriteURL" has been set.

||

Level: Error: no local variable "dbLevel" has been set.
Exp: Error: no local variable "dbExp" has been set.

HP: Error: no local variable "dbHP" has been set.
Dmg: Error: no local variable "dbDmg" has been set.
Crit Dmg: Error: no local variable "dbDmgCrit" has been set.
Block: Error: no local variable "dbBlock" has been set.