okay,
I tried that just for the hell of it. I changed the headings in my ZONE table from minium_status to min_status and from minium_level to min_level.
I startup my server and load up my game.
I select a level 70 toon parked in sleepers.
I try to zone into earth B with #zone poearthb
I get an error saying that zone is unvailable. I am thinking "okay, atleast I did not crash" I then try to zone into a few other zones that I could get into without problems before I changed the headings.
I got the same message saying that zone is unavailable for each and every zone I tried to get into.
I shut everything down and went back into my database and changed the headings back to minium_status and minium_level.
I start my server and load my game back up. At server select I see my level 70 toon and he is still in sleepers. I try to zone into Fire.
#zone pofire
Shortly after I am standing in fire without any issues. I zone into Water, Time (a and b), justice and a few others without any issues.
I try to zone into Earth B and get booted back to server select.
-------------------------------------------------------------------------------------
I understand what you are talking about with changing the headers of the columns. I even tried it as you guys sure as hell know alot more about this than I do. Did not solve my problem however and only created more.
I am not trying to be a jerk. After going over these forums I can understand the crap you guys put up with. And to all others reading this I can say for a fact that 99% of all questions that I see people asking, have infact been answered in one post or another.
I would like to also reccomend the program MYSQL Control Center for all your database editing. Learn it, Use it, Love it.
Presently I am looking at older databases to see if anything is the same or different for the data inside the ZONE table. However I have found that some tables have different columns all together making this a bit frustrating.
I wanted to get my own server up and running so that my son can play EQ like Daddy does. He has created toons on regular live EQ but with all the jerks in game I would prefer him to be somewhere safe. Plus he always had a habbit of killing any mob that moved, even if another group was killing it first.
Once again, I want to thank all of you for your hard work and if any of you have any ideas as to why PoEarthb is the ONLY zone I can not get into by having my headers as minium_level and minium_status please let me know.
Thanks,
Farmer
|