No gravity for PC's

[narcberry]

I just upgraded from 0.7.0 to 0.7.0-975. I have no bugs that I'm aware of except this one.

I can run around and play on perfectly flat surfaces(provided that I start touching the ground). Once my feet leave the ground even to the slightest amount, I slow down (like when you stop on a horse), come to a stop and from thenceforth and forever are stuck.

The only thing I know of dealing with gravity is hard coded to a static number.

Any ideas what may be causing this?

[Angelox]

You have to follow though with all the changelogs posted at the eqemu download page. This problem is probably becuase of an SQL update you left out (posted in the changelogs).

[narcberry]

Thank you very much, I'll post what it was when/if I find it.

[narcberry]

Im at work and cant test it yet. Here are the database changes I did to bring my server from version 0.7.0 to 0.7.0-975

ALTER TABLE spawnentry DROP spawn_limit;
ALTER TABLE spawngroup ADD spawn_limit tinyint(4) NOT NULL default '0';
ALTER TABLE altadv_vars ADD class_type int unsigned NOT NULL DEFAULT 0;
alter table account DROP packencrypt;
alter table character_ change extprofile extprofile blob NULL;
alter table player_corpses change data data blob NULL;
alter table player_corpses_backup change data data blob NULL;
ALTER TABLE `npc_types` CHANGE `hp_regen_rate` `hp_regen_rate` INT( 11 ) NOT
NULL DEFAULT '0';
ALTER TABLE `npc_types` CHANGE `mana_regen_rate` `mana_regen_rate` INT( 11 ) NOT
NULL DEFAULT '0';
UPDATE `npc_types` SET `hp_regen_rate` = '0' WHERE `hp_regen_rate` = '-1';
UPDATE `npc_types` SET `mana_regen_rate` = '0' WHERE `mana_regen_rate` = '-1';
ALTER TABLE `npc_types` CHANGE `hp_regen_rate` `hp_regen_rate` INT( 11 ) NOT
NULL DEFAULT '0';
ALTER TABLE `npc_types` CHANGE `mana_regen_rate` `mana_regen_rate` INT( 11 ) NOT
NULL DEFAULT '0';
ALTER TABLE `account` ADD `rulesflag` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `npc_types` DROP walkspeed;
ALTER TABLE `traps` ADD `message` VARCHAR( 200 ) NOT NULL AFTER `effectvalue2` ;
CREATE TABLE rule_sets (
ruleset_id TINYINT UNSIGNED NOT NULL auto_increment,
name VARCHAR(255) NOT NULL,
PRIMARY KEY(ruleset_id)
);
INSERT INTO rule_sets VALUES(0, "default");
UPDATE rule_sets SET ruleset_id=0;
CREATE TABLE rule_values (
ruleset_id TINYINT UNSIGNED NOT NULL,
rule_name VARCHAR(64) NOT NULL,
rule_value VARCHAR(10) NOT NULL,
INDEX(ruleset_id),
PRIMARY KEY(ruleset_id,rule_name)
);
CREATE TABLE skill_caps (
skillID TINYINT UNSIGNED NOT NULL,
class TINYINT UNSIGNED NOT NULL,
level TINYINT UNSIGNED NOT NULL,
cap MEDIUMINT UNSIGNED NOT NULL,
PRIMARY KEY(skillID,class,level)
);
ALTER TABLE `zone` ADD `cancombat` tinyint(4) NOT NULL default '1';
UPDATE `zone` SET `cancombat` = 0 WHERE short_name = 'nexus';
UPDATE `zone` SET `cancombat` = 0 WHERE short_name = 'poknowledge';
UPDATE `zone` SET `cancombat` = 0 WHERE short_name = 'potranquility';
ALTER TABLE `npc_types` ADD `see_hide` tinyint(4) NOT NULL default '0';
ALTER TABLE `npc_types` ADD `see_improved_hide` tinyint(4) NOT NULL default '0';
UPDATE `npc_types` SET `see_hide` = 1 WHERE see_invis = '1';
UPDATE `npc_types` SET `see_hide` = 1 WHERE see_invis_undead = '1';
ALTER TABLE quest_globals CHANGE expdate expdate INT;

I use the PEQ database, and some of these changes were uneccessary and resulted in error. I'll report success/failure once someone tests it (likely my brother) my server: Chunkahunk. Its up and listed if someone reads this and is excited to see if it worked.

[narcberry]

Must have fixed it since Im watching someone zone around on my server. Thanks for the help.