View Single Post
  #6  
Old 02-18-2003, 12:31 PM
deeque
Fire Beetle
 
Join Date: Feb 2003
Posts: 16
Default

ive been thinking about those tables as well and here is would i have been messing around with .. by altering the zone_points table a little bit by adding another colum called heading before the keepx and keep y not sure what they do either ..doesnt seem to be much of anything all the records for them all have been 0 in all the entries.


CREATE TABLE zone_points (
id int(11) NOT NULL auto_increment,
zone char(16) NOT NULL default '',
y float NOT NULL default '0',
x float NOT NULL default '0',
z float NOT NULL default '0',
target_zone char(16) NOT NULL default '',
target_y float NOT NULL default '0',
target_x float NOT NULL default '0',
target_z float NOT NULL default '0',
heading float NOT NULL default '0',
keep_x tinyint(1) NOT NULL default '0',
keep_y tinyint(1) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

---

and also adding an extra number in into a new version of the zone_points data dump file where the heading of 45 would make the toon zone into those coords and facing the heading of 45 like this :


REPLACE INTO zone_points VALUES (1,'qeynos',464,-440,351,'qeynos2',-155,-7,351,45,0,0);

but they only thing is the admin tool doesnt load this extra colum and i tryed to use the #goto Y X Z H (H meaning Heading) Command along with the extra heading # to tell what direction to face. .but i guess the Emulator would need some extra coding or adding something to the goto command to recgognize that 4th variable.

by doing the #loc command it gives the x= ,y= ,z= , Heading=


this is just my idea of how to fix the facing the wrong way thing
also to update the file easily by using the REPLACE INTO command
until there is that perfect zone_points.sql file
__________________
Links are your friend ;p
Reply With Quote