EQEmulator Forums - No gravity for PC's

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

Code:

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.