fix for rollback when pets name is greater then 12 letters

[xphire]

Well, here is a simple fix for a problem that your character gets rolled back if your pets name is greater then 12 letters.

Just run this SQL script:

ALTER TABLE `odinms`.`pets` MODIFY COLUMN `name` VARCHAR(999) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL;

Enjoy.

Edit: this is a permanent fix so you just have to run this once.

 

[ch1nkayy]

Re: [release]fix for rollback when pets name is greater then 12 letters

is this a permanent fix? =o

 

[xphire]

Re: [release]fix for rollback when pets name is greater then 12 letters

is this a permanent fix? =o

yea

 

[slipandslide]

Re: [release]fix for rollback when pets name is greater then 12 letters

do you know where the petid release is? :S cant seem to find it =/ one of the sources i have doesnt have the name tag

 

[kirbyhood]

Re: [release]fix for rollback when pets name is greater then 12 letters

Nice!!!!!!!!!!!!

 

[xaodx]

Re: [release]fix for rollback when pets name is greater then 12 letters

Bumps because its important and this guy pwns

 

[OmgItsParm]

Re: [release]fix for rollback when pets name is greater then 12 letters

Nice.

 

[CptObvious]

Re: [release]fix for rollback when pets name is greater then 12 letters

Applauses*


Sir, your epic fucking win and I hope you know that

 

[megoesrawr]

Re: [release]fix for rollback when pets name is greater then 12 letters

But now you can fix it by limiting through the source

 

[bluelaserman]

Re: [release]fix for rollback when pets name is greater then 12 letters

My Pets dont work at all...

 

[EspadaFung]

Re: [release]fix for rollback when pets name is greater then 12 letters

i wanna ask, is there any SQL that change the character name limit in mysql?

 

[EspadaFung]

Re: [release]fix for rollback when pets name is greater then 12 letters

 ALTER TABLE `odinms`.`characters` MODIFY COLUMN `name` VARCHAR(999) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL;

is this the correct sql for name limit? o.o

Edit : this don't work, tried. will dc lol

 

[xaodx]

Re: [release]fix for rollback when pets name is greater then 12 letters

worked for meee
*bump cuz this pwns*

 

[XenZy]

Re: [release]fix for rollback when pets name is greater then 12 letters

wow i lol amazingly i almost dropped off my chair if you didn't know this you pretty much fail..?how about doing it the hard way and set a limit on the nametag :|If someone has their pet name 999 characters it'll cover the whole map and thats really annoying ;

 

[chuayaowei]

Re: [release]fix for rollback when pets name is greater then 12 letters

Wow cool