PlayerNPCs fix in ThePack ll

._. As I said before, why do you think that the so called "player npc" will work even without the y cord? Seriously now, a player npc is still an npc as that, it needs a frickin x/y cord.

Heres the real fix..

PHP Code:

---

--
-- Definition of table `playernpcs`
--

DROP TABLE IF EXISTS `playernpcs`;
CREATE TABLE `playernpcs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(13) NOT NULL,
  `hair` int(11) NOT NULL,
  `face` int(11) NOT NULL,
  `skin` int(11) NOT NULL,
  `dir` int(11) NOT NULL,
  `x` int(11) NOT NULL DEFAULT '0',
  `y` int(11) NOT NULL DEFAULT '0',
  `cy` int(11) NOT NULL DEFAULT '0',
  `map` int(11) NOT NULL,
  `gender` int(11) NOT NULL,
  `ScriptId` int(10) unsigned NOT NULL DEFAULT '0',
  `Foothold` int(11) NOT NULL DEFAULT '0',
  `rx0` int(11) NOT NULL DEFAULT '0',
  `rx1` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Definition of table `playernpcs_equip`
--

DROP TABLE IF EXISTS `playernpcs_equip`;
CREATE TABLE `playernpcs_equip` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `npcid` int(11) NOT NULL,
  `equipid` int(11) NOT NULL,
  `equippos` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_playernpcs_equip_1` (`npcid`),
  CONSTRAINT `FK_playernpcs_equip_1` FOREIGN KEY (`npcid`) REFERENCES `playernpcs` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=latin1; 


---

lol troll,cy = y....

Quote:

---

Originally Posted by Lejgolacsz

lol troll,cy = y....

---

._. The sql I posted works 100%.

Quote:

---

Originally Posted by Bye

._. The sql I posted works 100%.

---

So did mine, troll.

quality does this sql also work for xotic source ?

Quote:

---

Originally Posted by Lejgolacsz

lol troll,cy = y....

---

Gtfo.

Quote:

---

Originally Posted by kokrong

quality does this sql also work for xotic source ?

---

i w0nder, d03s it?

I don't think so, check MSDartz' one for the xotic.

Quote:

---

Originally Posted by Qualitys

I don't think so, check MSDartz' one for the xotic.

---

Don't even bring his name up..,

So have you check or fix the problem that the npc won't load once you restart the server?

Works 100% braw.

It Works
Thx!

Glad it worked for you.

Quote:

---

Originally Posted by mspirate217

what exactly is a player npc? 0_0

---

^he shouldnt be here, even had in most repacks from v.55 and above -.-

Quote:

---

Originally Posted by Qualitys

I don't know.

---

^lol, obvious sarcasm

Quote:

---

Originally Posted by xqrzd

How can you take full credits when you don't know what a player NPC is?

---

I LMFAOED ON THIS LOLO LOL OLOLO LOLOLOLOL

Quote:

---

Originally Posted by Qualitys

Did you seriously belive that I don't know what playernpcs are o_o?

---

hahahahahahaahaAHAHAAHAA

good shit, nice release

Thanks !!!

This works perfectly for me, nice release.