Server is up... friends cannot log in

[VeteranWizard]

Mata Muram is up and nobody can connect to it, have a friend in teamspeak that is able to connect to grand creation and other various servers and friend cannot connect to mine or several others.... friend crashes to login screen...


any help is appreciated, thanks

[trevius]

This could be one of many possible issues. Most importantly though, make sure you have port ranges 7000 to 7100 and 9000 all forwarded on your router to the server.

[VeteranWizard]

hey trevius greatly appreciate your help, I ended up having to set up static i.p. addresses for my computers in my house, and then port forwarding and instantly people could begin logging into my server

Have a brand new question here, and let me know if I should have started up another thread here...

Left server running for about 16 hours and then the zones stopped working, i'm not running any static zones yet, but for some odd reason every character in the character select screen are showing up in UNKNOWN ZONE.. and the world.exe is showing the following

[Debug] [WORLD_CLIENT_ERR] nameofaccounthere: Zone not found in database zone_id=0, moveing char to arena character: characternamehere

i replaced the blue text and red text with generic info btw

I did look into the character tables and attempted to manually set characters to be moved to poknowledge with zoneid 202 and this was reverted back to arena with zoneid 0 over and over... any help is very much appreciated

[trevius]

Try increasing your dynamic zone count in the launcher_zones table. Default is 5 and zone crashes will cause issues if you run out. I currently run 50 and never have an issue.

[VeteranWizard]

as it turns out it looks like the zone table somehow got deleted, when i try to copy paste it back in i get an error 1146 - Table 'peq.zone' doesn't exist

[Rocker8956]

If the zone table got deleted you will probably need to run the SQL query below to recreate it. There are a lot of values that go in the table. If you need those shoot me a PM with your email address and I will email them to you. Probably would not be good on the forum to post all the values.

This is the PEQ 1128 zone table

CREATE TABLE `zone` (
  `short_name` varchar(16) NOT NULL default '',
  `file_name` varchar(16) default NULL,
  `long_name` text NOT NULL,
  `safe_x` float NOT NULL default '0',
  `safe_y` float NOT NULL default '0',
  `safe_z` float NOT NULL default '0',
  `graveyard_id` float NOT NULL default '0',
  `min_level` tinyint(3) unsigned NOT NULL default '0',
  `min_status` tinyint(3) unsigned NOT NULL default '0',
  `zoneidnumber` int(4) NOT NULL default '0',
  `timezone` int(5) NOT NULL default '0',
  `maxclients` int(5) NOT NULL default '0',
  `weather` smallint(6) NOT NULL default '1',
  `note` varchar(80) default NULL,
  `underworld` float NOT NULL default '0',
  `minclip` float NOT NULL default '450',
  `maxclip` float NOT NULL default '450',
  `fog_minclip` float NOT NULL default '450',
  `fog_maxclip` float NOT NULL default '450',
  `fog_blue` tinyint(3) unsigned NOT NULL default '0',
  `fog_red` tinyint(3) unsigned NOT NULL default '0',
  `fog_green` tinyint(3) unsigned NOT NULL default '0',
  `sky` tinyint(3) unsigned NOT NULL default '1',
  `ztype` tinyint(3) unsigned NOT NULL default '1',
  `zone_exp_multiplier` decimal(6,2) NOT NULL default '0.00',
  `walkspeed` float NOT NULL default '0.4',
  `time_type` tinyint(3) unsigned NOT NULL default '2',
  `fog_red1` tinyint(3) unsigned NOT NULL default '0',
  `fog_green1` tinyint(3) unsigned NOT NULL default '0',
  `fog_blue1` tinyint(3) unsigned NOT NULL default '0',
  `fog_minclip1` float NOT NULL default '450',
  `fog_maxclip1` float NOT NULL default '450',
  `fog_red2` tinyint(3) unsigned NOT NULL default '0',
  `fog_green2` tinyint(3) unsigned NOT NULL default '0',
  `fog_blue2` tinyint(3) unsigned NOT NULL default '0',
  `fog_minclip2` float NOT NULL default '450',
  `fog_maxclip2` float NOT NULL default '450',
  `fog_red3` tinyint(3) unsigned NOT NULL default '0',
  `fog_green3` tinyint(3) unsigned NOT NULL default '0',
  `fog_blue3` tinyint(3) unsigned NOT NULL default '0',
  `fog_minclip3` float NOT NULL default '450',
  `fog_maxclip3` float NOT NULL default '450',
  `fog_red4` tinyint(3) unsigned NOT NULL default '0',
  `fog_green4` tinyint(3) unsigned NOT NULL default '0',
  `fog_blue4` tinyint(3) unsigned NOT NULL default '0',
  `fog_minclip4` float NOT NULL default '450',
  `fog_maxclip4` float NOT NULL default '450',
  `flag_needed` varchar(128) NOT NULL default '',
  `canbind` tinyint(4) NOT NULL default '1',
  `cancombat` tinyint(4) NOT NULL default '1',
  `canlevitate` tinyint(4) NOT NULL default '1',
  `castoutdoor` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`short_name`),
  UNIQUE KEY `zoneidnumber` (`zoneidnumber`)
) TYPE=InnoDB;