View Single Post
  #10  
Old 06-17-2008, 02:15 PM
Avarion
Sarnak
 
Join Date: Apr 2004
Posts: 31
Default

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".
Reply With Quote