BubblesDev PlayerNPCs Fix

ALTER TABLE `odinms`.`playernpcs` MODIFY COLUMN `gender` INT(11) NOT NULL DEFAULT 0;
ALTER TABLE `odinms`.`playernpcs` MODIFY COLUMN `dir` INT(11) NOT NULL DEFAULT 0;
ALTER TABLE `odinms`.`playernpcs_equip` ADD COLUMN `equippos` INT(11) UNSIGNED NOT NULL AFTER `type`;

Run those SQLs

you rock if this works.

Is this only for BubbleDev?

yeah. it works though for bubblesdev since I tested it today.
There's still something wrong with equips though so as of now, you have to equip them yourself LOL

Your not the only one ^^^.

Quote:

---

Originally Posted by ToyFork

Your not the only one ^^^.

---

Sorry, but I didn't understand that. I'm not the only one what? With player npc problems?

ty works

Quote:

---

Originally Posted by ongdeetz

ty works

---

Please look at the date next time before bumping any thread.

Nice i guess.

Quote:

---

Originally Posted by ongdeetz

ty works

---

Nice bump

This still doesn't fix Player NPC's

I still get the error: Field 'type' doesn't have a default value.

How can I make it so 'type' has a default value?

execute this in your mysql
ALTER TABLE `odinms`.`playernpcs_equip` MODIFY COLUMN `type` INT(11) NOT NULL DEFAULT 0;
thank me if helped:rolleyes:

Quote:

---

Originally Posted by ongdeetz

execute this in your mysql
ALTER TABLE `odinms`.`playernpcs_equip` MODIFY COLUMN `type` INT(11) NOT NULL DEFAULT 0;
thank me if helped:rolleyes:

---

Stop bumping old thread,dude. :mad:

Quote:

---

Originally Posted by iTouchyou

Stop bumping old thread,dude. :mad:

---

Apparently, you haven't seen the post above his.
He's trying to help others.

Quote:

---

Originally Posted by whichboy

Apparently, you haven't seen the post above his.
He's trying to help others.

---

Then he should make a new thread. :cool: