Template:DungeonNpc: Difference between revisions
RTWikiAdmin (talk | contribs) No edit summary |
No edit summary Tag: Manual revert |
||
| (5 intermediate revisions by 2 users not shown) | |||
| Line 4: | Line 4: | ||
|where = NpcId = {{{nID}}} | |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 | ||
}} | |||
{{#get_db_data: | |||
db=WikiDB | |||
|from = Npcs | |||
|where = NpcId = {{{nID2}}} | |||
|data = dbNpcName2=NpcName, dbSpriteURL2=SpriteURL, dbLevel2=Level, dbExp2=Exp, dbHP2=HP, dbDmg2=Dmg, dbDmgCrit2=DmgCrit, dbBlock2=Block | |||
}} | }} | ||
| Line 22: | Line 29: | ||
Crit Dmg: {{#external_value:dbDmgCrit}}</br> | Crit Dmg: {{#external_value:dbDmgCrit}}</br> | ||
Block: {{#external_value:dbBlock}} | 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> | </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 "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.
