Template:DungeonNpc: Difference between revisions

From RuneTails
← Older editNewer edit →
NES (talk | contribs)
Editor
1,799 edits
No edit summary
NES (talk | contribs)
Editor
1,799 edits
No edit summary
Line 1: Line 1:
{| class="wikitable"
! Enemy !! Normal !! Normal (Boss) !! Runic !! Runic (Boss)
|-
{{#get_db_data:
{{#get_db_data:
  db=WikiDB
  db=WikiDB
Line 9: Line 12:
  db=WikiDB
  db=WikiDB
  |from = Npcs
  |from = Npcs
  |where = NpcId = {{{nID2}}}
  |where = NpcId = {{{nIDBoss}}}
  |data = dbNpcName2=NpcName, dbSpriteURL2=SpriteURL, dbLevel2=Level, dbExp2=Exp, dbHP2=HP, dbDmg2=Dmg, dbDmgCrit2=DmgCrit, dbBlock2=Block
  |data = dbNpcNameBoss=NpcName, dbSpriteURLBoss=SpriteURL, dbLevelBoss=Level, dbExpBoss=Exp, dbHPBoss=HP, dbDmgBoss=Dmg, dbDmgCritBoss=DmgCrit, dbBlockBoss=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
}}
}}


{| class="wikitable"
| rowspan="6" style="text-align: center;" |
|+ Dungeon NPCs
'''{{#external_value:dbNpcName}}'''<br>
|-
[[File:{{#external_value:dbSpriteURL}}|100px]]
! Enemy !! Normal !! Normal (Boss) !! Runic !! Runic (Boss)
|-
|-
| rowspan=6 align="center" |
| Level: {{#external_value:dbLevel}}
  {{#external_value:dbNpcName}} <br/>
| Level: {{#external_value:dbLevelBoss}}
  {{#external_value:dbSpriteURL}}  
| Level: {{#external_value:dbLevelRunic}}
|-
| Level: {{#external_value:dbLevelRunicBoss}}
| Level: {{#external_value:dbLevel}}  
|-
|-
| Exp: {{#external_value:dbExp}}
| Exp: {{#external_value:dbExp}}
| Exp: {{#external_value:dbExpBoss}}
| Exp: {{#external_value:dbExpRunic}}
| Exp: {{#external_value:dbExpRunicBoss}}
|-
|-
| HP: {{#external_value:dbHP}}  
| HP: {{#external_value:dbHP}}
|-
| HP: {{#external_value:dbHPBoss}}
| Dmg: {{#external_value:dbDmg}}  
| HP: {{#external_value:dbHPRunic}}
|-
| HP: {{#external_value:dbHPRunicBoss}}
| Crit Dmg: {{#external_value:dbDmgCrit}}
|-
| Block: {{#external_value:dbBlock}}
|-
| {{#external_value:dbNpcName2}} <br/>
  <img src="{{#external_value:dbSpriteURL2}}" alt="Sprite" />
|-
| Level: {{#external_value:dbLevel2}}
|-
| Exp: {{#external_value:dbExp2}}
|-
| HP: {{#external_value:dbHP2}}  
|-
|-
| Dmg: {{#external_value:dbDmg2}}  
| Dmg: {{#external_value:dbDmg}}
| Dmg: {{#external_value:dbDmgBoss}}
| Dmg: {{#external_value:dbDmgRunic}}
| Dmg: {{#external_value:dbDmgRunicBoss}}
|-
|-
| Crit Dmg: {{#external_value:dbDmgCrit2}}  
| Crit Dmg: {{#external_value:dbDmgCrit}}
| Crit Dmg: {{#external_value:dbDmgCritBoss}}
| Crit Dmg: {{#external_value:dbDmgCritRunic}}
| Crit Dmg: {{#external_value:dbDmgCritRunicBoss}}
|-
|-
| Block: {{#external_value:dbBlock2}}  
| Block: {{#external_value:dbBlock}}
| Block: {{#external_value:dbBlockBoss}}
| Block: {{#external_value:dbBlockRunic}}
| Block: {{#external_value:dbBlockRunicBoss}}
|}
|}

Revision as of 05:15, 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 = {{{nIDBoss}}}  ; 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 = {{{nIDRunic}}}  ; 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 = {{{nIDRunicBoss}}}  ; 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).
Enemy Normal Normal (Boss) Runic Runic (Boss)

Error: no local variable "dbNpcName" has been set.
[[File:Error: no local variable "dbSpriteURL" has been set.|100px]]

Level: Error: no local variable "dbLevel" has been set. Level: Error: no local variable "dbLevelBoss" has been set. Level: Error: no local variable "dbLevelRunic" has been set. Level: Error: no local variable "dbLevelRunicBoss" has been set.
Exp: Error: no local variable "dbExp" has been set. Exp: Error: no local variable "dbExpBoss" has been set. Exp: Error: no local variable "dbExpRunic" has been set. Exp: Error: no local variable "dbExpRunicBoss" has been set.
HP: Error: no local variable "dbHP" has been set. HP: Error: no local variable "dbHPBoss" has been set. HP: Error: no local variable "dbHPRunic" has been set. HP: Error: no local variable "dbHPRunicBoss" has been set.
Dmg: Error: no local variable "dbDmg" has been set. Dmg: Error: no local variable "dbDmgBoss" has been set. Dmg: Error: no local variable "dbDmgRunic" has been set. Dmg: Error: no local variable "dbDmgRunicBoss" has been set.
Crit Dmg: Error: no local variable "dbDmgCrit" has been set. Crit Dmg: Error: no local variable "dbDmgCritBoss" has been set. Crit Dmg: Error: no local variable "dbDmgCritRunic" has been set. Crit Dmg: Error: no local variable "dbDmgCritRunicBoss" has been set.
Block: Error: no local variable "dbBlock" has been set. Block: Error: no local variable "dbBlockBoss" has been set. Block: Error: no local variable "dbBlockRunic" has been set. Block: Error: no local variable "dbBlockRunicBoss" has been set.
Retrieved from "https://wiki.runetails.com/index.php?title=Template:DungeonNpc&oldid=1863"