Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Help] Organize rows

Newbie Spellweaver
Joined
Jan 13, 2008
Messages
26
Reaction score
0
I don't know if this is the right place to ask, but how do we orgazine rows in a table. Right now i'm working on k_npcpos and the 1st column is the zone id and i got all messed up. Isn't there a way to make them organized from 1 to 203...
thanks
 
Last edited by a moderator:
Experienced Elementalist
Joined
Jan 3, 2008
Messages
299
Reaction score
1
Re: Organize rows

Put This In Query Analyzer And Hit Execute said:
select * from k_npcpos order by k_npcpos

Copy the whole thing.

Then said:
truncate table k_npcpos

Then, go open the k_npcpos and paste the code.
 
Newbie Spellweaver
Joined
Jan 13, 2008
Messages
26
Reaction score
0
thanks for your reply, but for some reason that's not working(when i try to run
select
* from k_npcpos order by k_npcpos
):

Invalid column name 'k_npcpos'.


edit: ok, i just figured it out myself. thanks =)
 
Last edited:
Experienced Elementalist
Joined
Aug 18, 2007
Messages
204
Reaction score
0
I don't know if this is the right place to ask, but how do we orgazine rows in a table. Right now i'm working on k_npcpos and the 1st column is the zone id and i got all messed up. Isn't there a way to make them organized from 1 to 203...
thanks

sql query the table and use command:

order by zoneid
then execute it

or if you want to just display a certain zone's data sql query the table and use this command (example will be zone 201 = Colonyzone)

where (zoneid = '201')
then execute it

You can also then add order by npcid at the end to order it by npcid's like this

where (zoneid = '201') order by npcid
then execute it

to display more than 1 zone use:

where (zoneid = '201') or (zoneid = '21')
then execute

this will display only the colony zone and Moradon
 
Experienced Elementalist
Joined
Jan 3, 2008
Messages
299
Reaction score
1
thanks for your reply, but for some reason that's not working(when i try to run
select
*from k_npcpos orderby k_npcpos
):

Invalid column name 'k_npcpos'.


edit: ok, i just figured it out myself. thanks =)
Whoops, gave you the wrong order by command. And,

You left out the spaces.

select * from k_npcpos order by zoneid
 
Back
Top