Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

fix for rollback when pets name is greater then 12 letters

for(alive>0){makeMoney()}
Loyal Member
Joined
Aug 1, 2006
Messages
357
Reaction score
68
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:
PHP:
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.
 
Custom Title Activated
Loyal Member
Joined
Apr 5, 2008
Messages
1,025
Reaction score
5
Re: [release]fix for rollback when pets name is greater then 12 letters

is this a permanent fix? =o
 
Banned
Banned
Joined
Apr 6, 2008
Messages
80
Reaction score
0
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
 
Newbie Spellweaver
Joined
Jun 24, 2008
Messages
63
Reaction score
7
Re: [release]fix for rollback when pets name is greater then 12 letters

Nice!!!!!!!!!!!!
 
Junior Spellweaver
Joined
Jun 19, 2008
Messages
115
Reaction score
0
Re: [release]fix for rollback when pets name is greater then 12 letters

Bumps because its important and this guy pwns
 
Legendary Battlemage
Loyal Member
Joined
Apr 8, 2008
Messages
668
Reaction score
12
Re: [release]fix for rollback when pets name is greater then 12 letters

Nice.
 
Junior Spellweaver
Joined
Aug 1, 2008
Messages
145
Reaction score
0
Re: [release]fix for rollback when pets name is greater then 12 letters

Applauses*


Sir, your epic Ducking win and I hope you know that
 
Legendary Battlemage
Joined
May 23, 2008
Messages
628
Reaction score
4
Re: [release]fix for rollback when pets name is greater then 12 letters

But now you can fix it by limiting through the source :p
 
Newbie Spellweaver
Joined
Aug 2, 2008
Messages
63
Reaction score
0
Re: [release]fix for rollback when pets name is greater then 12 letters

My Pets dont work at all...
 
Master Summoner
Loyal Member
Joined
Jul 22, 2008
Messages
573
Reaction score
0
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?
 
Master Summoner
Loyal Member
Joined
Jul 22, 2008
Messages
573
Reaction score
0
Re: [release]fix for rollback when pets name is greater then 12 letters

Code:
 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
 
Junior Spellweaver
Joined
Jun 19, 2008
Messages
115
Reaction score
0
Re: [release]fix for rollback when pets name is greater then 12 letters

worked for meee o_O
*bump cuz this pwns*
 
Experienced Elementalist
Joined
Jul 10, 2008
Messages
299
Reaction score
3
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 o_O;
 
Supreme Arcanarch
Loyal Member
Joined
Jul 21, 2008
Messages
969
Reaction score
1
Re: [release]fix for rollback when pets name is greater then 12 letters

Wow cool
 
Back
Top