Cannot connect to my server

Avarion · #1 06-17-2008, 02:06 PM

I tryed to execute all SQL-Commands from the changelog but most of em seemed to be included in the database.

Code:

CREATE TABLE `graveyard` (
  `id` int(11) NOT NULL auto_increment,
  `zone_id` int(4) NOT NULL default '0',
  `x` float NOT NULL default '0',
  `y` float NOT NULL default '0',
  `z` float NOT NULL default '0',
  `heading` float NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `zone_id` (`zone_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

This code does nothing. Still there is no table graveyard in my database.

Avarion · #2 06-17-2008, 02:15 PM

here is an describe from my zonetable:

Code:

"Field","Type","Null","Key","Default","Extra"
"short_name","varchar(16)","NO","PRI","",""
"file_name","varchar(16)","YES","","",""
"long_name","text","NO","","",""
"safe_x","float","NO","","0",""
"safe_y","float","NO","","0",""
"safe_z","float","NO","","0",""
"graveyard_id","float","NO","","0",""
"min_level","tinyint(3) unsigned","NO","","0",""
"min_status","tinyint(3) unsigned","NO","","0",""
"zoneidnumber","int(4)","NO","UNI","0",""
"timezone","int(5)","NO","","0",""
"maxclients","int(5)","NO","","0",""
"weather","smallint(6)","NO","","1",""
"note","varchar(80)","YES","","",""
"underworld","float","NO","","0",""
"minclip","float","NO","","450",""
"maxclip","float","NO","","450",""
"fog_minclip","float","NO","","450",""
"fog_maxclip","float","NO","","450",""
"fog_blue","tinyint(3) unsigned","NO","","0",""
"fog_red","tinyint(3) unsigned","NO","","0",""
"fog_green","tinyint(3) unsigned","NO","","0",""
"sky","tinyint(3) unsigned","NO","","1",""
"ztype","tinyint(3) unsigned","NO","","1",""
"zone_exp_multiplier","float","NO","","1",""
"walkspeed","float","NO","","0.4",""
"time_type","tinyint(3) unsigned","NO","","2",""
"fog_red1","tinyint(3) unsigned","NO","","0",""
"fog_green1","tinyint(3) unsigned","NO","","0",""
"fog_blue1","tinyint(3) unsigned","NO","","0",""
"fog_minclip1","float","NO","","450",""
"fog_maxclip1","float","NO","","450",""
"fog_red2","tinyint(3) unsigned","NO","","0",""
"fog_green2","tinyint(3) unsigned","NO","","0",""
"fog_blue2","tinyint(3) unsigned","NO","","0",""
"fog_minclip2","float","NO","","450",""
"fog_maxclip2","float","NO","","450",""
"fog_red3","tinyint(3) unsigned","NO","","0",""
"fog_green3","tinyint(3) unsigned","NO","","0",""
"fog_blue3","tinyint(3) unsigned","NO","","0",""
"fog_minclip3","float","NO","","450",""
"fog_maxclip3","float","NO","","450",""
"fog_red4","tinyint(3) unsigned","NO","","0",""
"fog_green4","tinyint(3) unsigned","NO","","0",""
"fog_blue4","tinyint(3) unsigned","NO","","0",""
"fog_minclip4","float","NO","","450",""
"fog_maxclip4","float","NO","","450",""
"flag_needed","varchar(128)","NO","","",""
"canbind","tinyint(4)","NO","","1",""
"cancombat","tinyint(4)","NO","","1",""
"canlevitate","tinyint(4)","NO","","1",""
"castoutdoor","tinyint(4)","NO","","1",""

Perhaps you can see something that helps.

Btw. canlevitate and castoutdoor are the only SQL-commands which were missing. But the problem continues. "zone not avaliable".

Avarion · #3 06-17-2008, 02:22 PM

Btw. please ignore the "no graveyard" post two above. Blind on both eyes.

**Congdar** · #4 06-17-2008, 02:49 PM

show us your start.bat file

Avarion · #5 06-17-2008, 03:16 PM

Code:

@echo off
start minilogin.exe 
Echo Please wait for Minilogin to fully boot up. 
pause
start world.exe 
Echo Wait for World to finish loading... Press Enter when done. 
pause 
start eqlaunch.exe zone 
exit

Here it is.

By the way. The eqlaunch window doesnt show anything. Is this correct?

**Congdar** · #6 06-17-2008, 03:28 PM

make sure your table 'launcher' has the name 'zone' and some number for 'dynamics'

yes, should be blank

Avarion · #7 06-17-2008, 03:31 PM

Code:

"name","dynamics"
"zone",6

it has :(