Crash on PoP zones or newer.

Dr Zauis · #1 09-08-2005, 06:30 PM

Sorry..I made a mistake..Got my clients mixed up. LOL.. Its a 6.1..And its a pre 5/11 version.
Even though #zone is enabled there is still a way to limit the zones a player can go to.(Im pretty sure I seen that in Database)
But i will check in right now and see..BRB dude!

EDIT>>>And yes the stones..They should be there in most zones and all but one in POK.

Dr Zauis · #2 09-08-2005, 06:50 PM

OK..I try to #zone poknowledge and Im not high enuff. I went to North Qeynos and see the stone there. I click it and it sends me to differnt loc but same zone. So you need to edit the status for POK.
I was using msql-front for this. But I found something thats free.
Its called sqlyog. I will get the link and edit this post with it.

EDIT>>>http://www.webyog.com/sqlyog/index2.php

And then its in zone table..after safe x,y.z entries..There will be min level entry and then status entry. You need to change pok to status 0 and I can try to zone there then.

Kikaro · #3 09-08-2005, 07:02 PM

ok i will be home in an hour and try that. thanks a lot for helping with this by the way.

Dr Zauis · #4 09-08-2005, 07:29 PM

OK I dont know if its necessary to restart server or not. I will log on when I get up(3am here!).
If I get there i will probably fall to my death LOL! It zones ya to loc 0,0,0 and POK floor is alot lower than than that. But If I get there Im sure the stones are there as I seen the one in qeynos2 just where it should be.

Dr Zauis · #5 09-11-2005, 04:04 AM

Quote:

Originally Posted by Kikaro

ok i will be home in an hour and try that. thanks a lot for helping with this by the way.

Yo..Just wondering if you tried the prog I mentioned. Also try mysql-front.
Thes progs really help me to understand whats in the database. From what I understand they are windows based programs to do all the sql querys for ya.(all or most)Much easier for me as I have used dos very little in my life.

Anyway Im almost 100% sure if I had the priviledge to zone to POK I could get there. But if you dont want to use POK or any of the zones past velious then dont mess with it(zones table in DB) and status 0 users cant zone there.

Kikaro · #6 09-17-2005, 09:22 PM

Digging up this thread as I got too busy with other things to work on this.

Ok I installed the link up there, but I am not 100% sure I know what I am doing with it. I got my database open in it but where do I find the tables or whatever? Ive never done this so im sorry if I sound like an idiot.

Dr Zauis · #7 09-18-2005, 06:44 AM

On the left hand side is the treeview of the database. You can open it to see
the tables. The main view has a few tab buttons there but the one you want is Table Data. There you can replace a value. And then use save as to save it. It should be save but they made a mistake with the prog.

Kikaro · #8 09-18-2005, 09:17 AM

Ok, I found it, However none of the Planes of Power zones or newer are there, so I have to enter them all. Sounds like fun.

Dr Zauis · #9 09-18-2005, 10:02 AM

Quote:

Originally Posted by Kikaro

Ok, I found it, However none of the Planes of Power zones or newer are there, so I have to enter them all. Sounds like fun.

I dont know about that..But check this out..If you can get Cavedudes Database sourced..You can chage the tables in your Database. So what I am doing is..Say I want all his doors. I replace doors files from one DB folder to the other. Say I want his zones tables. Replace them in the folder..ect..
Its just like I said before with the varables table. I replaced mine with Cavedudes and I have alot mor options now..I dont know if doing that kind of thing is right but it works for me..

Kikaro · #10 09-18-2005, 12:29 PM

Hmm. Interesting idea. I am actually using his database right now but I never thought abotu combining databases though. I will have to play with this some more. as of right now it doesnt look like anyoen can zone into luclin or higher without being some kind of GM. I would like to have all zones open if possible. will do more searching when i get home.

Koshoji · #11 09-09-2005, 10:32 AM

Quote:

Originally Posted by Dr Zauis

I was using msql-front for this. But I found something thats free.
Its called sqlyog. I will get the link and edit this post with it.

EDIT>>>http://www.webyog.com/sqlyog/index2.php

And then its in zone table..after safe x,y.z entries..There will be min level entry and then status entry. You need to change pok to status 0 and I can try to zone there then.

Awesome! Thanks for this link Dr. Zauis

I thought I liked MSQL Front, but this one is great. /em Cheers Dr. Zauis heartily

You're a very helpful fellow indeed!

Dr Zauis · #12 09-11-2005, 03:53 AM

Quote:

Originally Posted by Koshoji

Awesome! Thanks for this link Dr. Zauis

I thought I liked MSQL Front, but this one is great. /em Cheers Dr. Zauis heartily

You're a very helpful fellow indeed!

Hey..Your welcome..I found the link on this site one day..I forget who first posted it. Frak..I know I was editing with it but now i cant remember what I was doing. Im a total noob myself..More practice I guess.