Template:DungeonNpc: Difference between revisions

From RuneTails
← Older edit
NES (talk | contribs)
Editor
1,799 edits
No edit summary
NES (talk | contribs)
Editor
1,799 edits
No edit summary
Tag: Manual revert
 
Line 1: Line 1:
{| class="wikitable"
! Enemy !! Normal !! Normal (Boss) !! Runic !! Runic (Boss)
|-
{{#get_db_data:
{{#get_db_data:
  db=WikiDB
  db=WikiDB
Line 12: Line 9:
  db=WikiDB
  db=WikiDB
  |from = Npcs
  |from = Npcs
  |where = NpcId = {{{nIDBoss}}}
  |where = NpcId = {{{nID2}}}
  |data = dbNpcNameBoss=NpcName, dbSpriteURLBoss=SpriteURL, dbLevelBoss=Level, dbExpBoss=Exp, dbHPBoss=HP, dbDmgBoss=Dmg, dbDmgCritBoss=DmgCrit, dbBlockBoss=Block
  |data = dbNpcName2=NpcName, dbSpriteURL2=SpriteURL, dbLevel2=Level, dbExp2=Exp, dbHP2=HP, dbDmg2=Dmg, dbDmgCrit2=DmgCrit, dbBlock2=Block
}}
 
{{#get_db_data:
db=WikiDB
|from = Npcs
|where = NpcId = {{{nIDRunic}}}
|data = dbNpcNameRunic=NpcName, dbSpriteURLRunic=SpriteURL, dbLevelRunic=Level, dbExpRunic=Exp, dbHPRunic=HP, dbDmgRunic=Dmg, dbDmgCritRunic=DmgCrit, dbBlockRunic=Block
}}
}}


{{#get_db_data:
{|
db=WikiDB
|from = Npcs
|where = NpcId = {{{nIDRunicBoss}}}
|data = dbNpcNameRunicBoss=NpcName, dbSpriteURLRunicBoss=SpriteURL, dbLevelRunicBoss=Level, dbExpRunicBoss=Exp, dbHPRunicBoss=HP, dbDmgRunicBoss=Dmg, dbDmgCritRunicBoss=DmgCrit, dbBlockRunicBoss=Block
}}
 
| rowspan="7" style="text-align: center;" |
'''{{#external_value:dbNpcName}}'''<br>
{{#external_value:dbSpriteURL}}
|-
|-
| Level: {{#external_value:dbLevel}}
| <center>{{#external_value:dbNpcName}}</center>
| Level: {{#external_value:dbLevelBoss}}
| Level: {{#external_value:dbLevelRunic}}
| Level: {{#external_value:dbLevelRunicBoss}}
|-
|-
| Exp: {{#external_value:dbExp}}
| {{#external_value:dbSpriteURL}}
| Exp: {{#external_value:dbExpBoss}}
| Exp: {{#external_value:dbExpRunic}}
| Exp: {{#external_value:dbExpRunicBoss}}
|-
| HP: {{#external_value:dbHP}}
| HP: {{#external_value:dbHPBoss}}
| HP: {{#external_value:dbHPRunic}}
| HP: {{#external_value:dbHPRunicBoss}}
|-
| Dmg: {{#external_value:dbDmg}}
| Dmg: {{#external_value:dbDmgBoss}}
| Dmg: {{#external_value:dbDmgRunic}}
| Dmg: {{#external_value:dbDmgRunicBoss}}
|-
| Crit Dmg: {{#external_value:dbDmgCrit}}
| Crit Dmg: {{#external_value:dbDmgCritBoss}}
| Crit Dmg: {{#external_value:dbDmgCritRunic}}
| Crit Dmg: {{#external_value:dbDmgCritRunicBoss}}
|-
| Block: {{#external_value:dbBlock}}
| Block: {{#external_value:dbBlockBoss}}
| Block: {{#external_value:dbBlockRunic}}
| Block: {{#external_value:dbBlockRunicBoss}}
|}
|}
||
<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}}</br>
Crit Dmg: {{#external_value:dbDmgCrit}}</br>
Block: {{#external_value:dbBlock}}
</div>
||
<div style="text-align: left; width:100px">
Level: {{#external_value:dbLevel2}}</br>
Exp: {{#external_value:dbExp2}}
HP: {{#external_value:dbHP2}}</br>
Dmg: {{#external_value:dbDmg2}}</br>
Crit Dmg: {{#external_value:dbDmgCrit2}}</br>
Block: {{#external_value:dbBlock2}}
</div>

Latest revision as of 05: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).

The query SELECT NpcName, SpriteURL, Level, Exp, HP, Dmg, DmgCrit, Block FROM Npcs AS Npcs WHERE NpcId = {{{nID2}}}  ; 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.

||

Level: Error: no local variable "dbLevel2" has been set.
Exp: Error: no local variable "dbExp2" has been set.

HP: Error: no local variable "dbHP2" has been set.
Dmg: Error: no local variable "dbDmg2" has been set.
Crit Dmg: Error: no local variable "dbDmgCrit2" has been set.
Block: Error: no local variable "dbBlock2" has been set.

Retrieved from "https://wiki.runetails.com/index.php?title=Template:DungeonNpc&oldid=1865"