prepare(" SELECT stat, value FROM artifact_stat WHERE artifact = :artifact "); $statement->bindValue(':artifact', $artifact, SQLITE3_INTEGER); $r = $statement->execute()->fetchArray(SQLITE3_ASSOC); if ($r){ $this->stat = $r["stat"]; $this->value = $r["value"]; switch ($this->stat){ case ARTIFACT_STAT_ID::HP: $this->name = "HP"; break; case ARTIFACT_STAT_ID::ATK: $this->name = "ATK"; break; case ARTIFACT_STAT_ID::DEF: $this->name = "DEF"; break; } } } } ?>