EQEMU Database: Revision history

From EQArchives
Jump to navigationJump to search

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

15 June 2023

14 June 2023

29 May 2023

28 May 2023

10 May 2023

  • curprev 14:3514:35, 10 May 2023Nazwahdi talk contribs 2,642 bytes +2,642 Created page with "This page is intended to provide information regarding Database Administration for an EQEMU Database. ==SQL Snippets== === Disable merchantlist entries by item === <pre> UPDATE `merchantlist` SET probability = 0 WHERE item = 38399 </pre> === Get all loottable entry fields for all npc_types with enabled spawns === <pre> SELECT lte.loottable_id, lte.lootdrop_id, lte.multiplier, lte.droplimit, lte.mindrop, lte.probability, n.name, lt.name FROM loottable_entries AS lte INN..." Tag: Visual edit: Switched