Surprise! We've been running on hardware provided by BuyVM for a few months and wanted to show them a little appreciation.
Running a paste site comes with unique challenges, ones that aren't always obvious and hard to control. As such, BuyVM offered us a home where we could worry less about the hosting side of things and focus on maintaining a clean and useful service! Go check them out and show them some love!
Description: SQL NPC spawns example
Submitted by Logan on February 18, 2017

Download - Report

New Paste 1 (SQL)

123456789101112131415 
CREATE TABLE IF NOT EXISTS `server2146_npc_spawns` (
  `spawnId` int(11) NOT NULL AUTO_INCREMENT,
  `npcId` int(11) NOT NULL,
  `npcX` int(11) NOT NULL,
  `npcY` int(11) NOT NULL,
  `npcHeight` int(11) NOT NULL,
  `walkingType` int(11) NOT NULL,
  `npcHP` int(11) NOT NULL,
  `maxHit` int(11) NOT NULL,
  `attack` int(11) NOT NULL,
  `defence` int(11) NOT NULL,
  `npcAggressive` tinyint(1) NOT NULL,
  `spawnDesc` varchar(255) NOT NULL,
  PRIMARY KEY (`spawnId`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;