Touch of nostalgia...

[John Adams]

Check out this thread. I keep seeing it as the #2 most-read post on this entire site, so I decided to go check it out.

Interesting read. Who are all those people? Proves, ZexisStryfe is here to stay

[ZexisStryfe]

Was there ever any doubt?

[John Adams]

Speaking of nostalgia (from 2010 /necrofromhell), I was cleaning up some old archives and ran across the very first thing I *ever* did with EQ2Emulator, after discovering it existed in Oct 2007 --

(btw, don't execute this, it's just showing my very first SQL effort heh)

Code: Select all

/*
SQLyog Community Edition- MySQL GUI v5.30
Host - 5.0.27 : Database - eq2
*********************************************************************
Server version : 5.0.27
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*Table structure for table `npcs` */

DROP TABLE IF EXISTS `npcs`;

CREATE TABLE `npcs` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(64) NOT NULL default '',
  `min_level` tinyint(3) unsigned NOT NULL default '0',
  `max_level` tinyint(3) unsigned NOT NULL default '0',
  `enc_level` tinyint(3) unsigned NOT NULL default '0',
  `race` tinyint(3) unsigned NOT NULL default '0',
  `race_type` smallint(5) unsigned NOT NULL default '0',
  `class_` tinyint(3) unsigned NOT NULL default '0',
  `gender` tinyint(3) unsigned NOT NULL default '0',
  `min_group_size` tinyint(3) unsigned NOT NULL default '0',
  `max_group_size` tinyint(3) unsigned NOT NULL default '0',
  `show_name` tinyint(3) unsigned NOT NULL default '1',
  `attackable` tinyint(3) unsigned NOT NULL default '1',
  `show_level` tinyint(3) unsigned NOT NULL default '1',
  `targetable` tinyint(3) unsigned NOT NULL default '1',
  `show_command_icon` tinyint(3) unsigned NOT NULL default '1',
  `display_hand_icon` tinyint(3) unsigned NOT NULL default '0',
  `command_list_type` varchar(32) NOT NULL default '',
  `command_list_subtype` varchar(32) NOT NULL default '',
  `faction_id` int(10) unsigned NOT NULL default '0',
  `hair_type_id` smallint(5) unsigned NOT NULL default '0',
  `facial_hair_type_id` smallint(5) unsigned NOT NULL default '0',
  `wing_type_id` smallint(5) unsigned NOT NULL default '0',
  `chest_type_id` smallint(5) unsigned NOT NULL default '0',
  `legs_type_id` smallint(5) unsigned NOT NULL default '0',
  `soga_hair_type_id` smallint(5) unsigned NOT NULL default '0',
  `soga_facial_hair_type_id` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

/*Data for the table `npcs` */

insert  into `npcs`(`id`,`name`,`min_level`,`max_level`,`enc_level`,`race`,`race_type`,`class_`,`gender`,`min_group_size`,`max_group_size`,`show_name`,`attackable`,`show_level`,`targetable`,`show_command_icon`,`display_hand_icon`,`command_list_type`,`command_list_subtype`,`faction_id`,`hair_type_id`,`facial_hair_type_id`,`wing_type_id`,`chest_type_id`,`legs_type_id`,`soga_hair_type_id`,`soga_facial_hair_type_id`) values (1,'Captain Varlos',2,2,3,9,134,33,1,0,0,1,1,1,1,1,0,'NPC','DEFAULT',0,1126,1166,0,5533,5534,1126,1166);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

Building my own EQ2emu server, inserting the very first NPC - Captain Varlos! NPC ID #1.
File date: 11/4/2007

If only I could have back the 1,000's of hours I put in... what I could have accomplished in this life.

[Chrisworld]

Wow man that was 11 years ago, crazy how time flies eh?