Template:DungeonNpc: Difference between revisions

From RuneTails
Created page with "{{#get_db_data: db=WikiDB |from = Npcs |where = NpcId = 67 |data = dbNpcName=NpcName, dbSpriteURL=SpriteURL, dbLevel=Level, dbExp=Exp, dbHP=HP, dbDmg=Dmg, dbDmgCrit=DmgCrit, dbBlock=Block }} {| | <center>{{#external_value:dbNpcName}}</center> |- | {{#external_value:dbSpriteURL}} |} !! <div style="text-align: left; width:100px"> Level: {{#external_value:dbLevel}}</br> Exp: {{#external_value:dbExp}} HP: {{#external_value:dbHP}}</br> Dmg: {{#external_value:dbDmg}}</..."
 
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 02:33, 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.