Charmy
05-07-2004, 05:52 PM
ok been trying to set the default zone bind spots to 0,0,10 in the nexus. i tried using eqadmin and for some reason it wouldn't save any of the changes i made, so i used mysqlfront and used the following queries.
First i wanted to only try one class/race
i choose iksar necro
UPDATE start_zones SET x=0 WHERE player_race=128 and player_class=11;
UPDATE start_zones SET y=0 WHERE player_race=128 and player_class=11;
UPDATE start_zones SET z=10 WHERE player_race=128 and player_class=11;
UPDATE start_zones SET zone_id=152 WHERE player_race=128 and player_class=11;
UPDATE start_zones SET bind_x=0 WHERE player_race=128 and player_class=11;
UPDATE start_zones SET bind_y=0 WHERE player_race=128 and player_class=11;
UPDATE start_zones SET bind_z=10 WHERE player_race=128 and player_class=11;
UPDATE start_zones SET start_zone=152 WHERE player_race=128 and player_class=11;
After running this the values changed and i made an ikky necro who was bound in the nexus! yay!
So i decided to make a generic sql script to change all the race/class combo to start and bind in the nexus at 0,0,10
so i ran this....
UPDATE start_zones SET x=0;
UPDATE start_zones SET y=0;
UPDATE start_zones SET z=10;
UPDATE start_zones SET zone_id=152;
UPDATE start_zones SET bind_x=0;
UPDATE start_zones SET bind_y=0;
UPDATE start_zones SET bind_z=10;
UPDATE start_zones SET start_zone=152;
Sourced them in and now the start_zones table has all the values filled out, and when compared to the necro are exactly the same. so i figured this would work, but...........................
Didn't work.
I have been toying with it forEVER now, and can't get it to work, any suggestions will help thanks again for all the help everyone has given me to getting this thing running the way i want!
First i wanted to only try one class/race
i choose iksar necro
UPDATE start_zones SET x=0 WHERE player_race=128 and player_class=11;
UPDATE start_zones SET y=0 WHERE player_race=128 and player_class=11;
UPDATE start_zones SET z=10 WHERE player_race=128 and player_class=11;
UPDATE start_zones SET zone_id=152 WHERE player_race=128 and player_class=11;
UPDATE start_zones SET bind_x=0 WHERE player_race=128 and player_class=11;
UPDATE start_zones SET bind_y=0 WHERE player_race=128 and player_class=11;
UPDATE start_zones SET bind_z=10 WHERE player_race=128 and player_class=11;
UPDATE start_zones SET start_zone=152 WHERE player_race=128 and player_class=11;
After running this the values changed and i made an ikky necro who was bound in the nexus! yay!
So i decided to make a generic sql script to change all the race/class combo to start and bind in the nexus at 0,0,10
so i ran this....
UPDATE start_zones SET x=0;
UPDATE start_zones SET y=0;
UPDATE start_zones SET z=10;
UPDATE start_zones SET zone_id=152;
UPDATE start_zones SET bind_x=0;
UPDATE start_zones SET bind_y=0;
UPDATE start_zones SET bind_z=10;
UPDATE start_zones SET start_zone=152;
Sourced them in and now the start_zones table has all the values filled out, and when compared to the necro are exactly the same. so i figured this would work, but...........................
Didn't work.
I have been toying with it forEVER now, and can't get it to work, any suggestions will help thanks again for all the help everyone has given me to getting this thing running the way i want!