Template:DungeonNpcBoss: Difference between revisions

From RuneTails
No edit summary
No edit summary
 
(2 intermediate revisions by the same user not shown)
Line 2: Line 2:
  db=WikiDB
  db=WikiDB
  |from = Npcs
  |from = Npcs
  |where = NpcId = 75
  |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
}}
}}
Line 15: Line 15:
|}
|}
</div>
</div>
<div style="display: inline-block; text-align: left; width:100px; position: absolute; padding-top: 30px;">
<div style="display: inline-block; text-align: left; width:100px; position: absolute; padding-top: 30px; padding-left: 20px">
Level: {{#external_value:dbLevel}}</br>
Level: {{#external_value:dbLevel}}</br>
Exp: {{#external_value:dbExp}}
Exp: {{#external_value:dbExp}}

Latest revision as of 03:59, 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.