i need some idea about change npc spot

[asdalhog]

hello guys
i try to make some think
in npcs
but every time i miss
i need npc to change his spot
like when i talk to him
and get buy some think he move and go another spot

see my code

new Conquer_Online_Server.Database.MySqlCommand(Conquer_Online_Server.Database.MySqlCommandType.UPDATE)
                               .Update("sobnpcs").Set("cellx",433 ).Set("celly", 387).Where("id", 74125)

but this code need to restart server
to reload database
so i make code to reload
only table "sobnpcs"
but npc he never change spot
must restart
anyway
can anyone help me in this
or some one give me idea


sorry i add this in wrong section
can pleas moved to
CO2 PServer - Discussions / Questions

[go for it]

i can't really understand your problem
your problem is with changing a value in the database ?
or your problem is that you want this to take effect without restarting the server ?
if you suffer from the first problem try the next piece of code i made it for the same reason

                                    MySqlCommand cmd = new MySqlCommand(MySqlCommandType.UPDATE);
                                    cmd.Update("npcs").Set("mapid", Npc_Map).Set("cellx", Npc_X).Set("celly", Npc_Y).Where("id", npctochangeid).Execute();

if you suffer from the second problem then i think you need to respawen all npcs again so he move to his new coords

well there is an advanced way to do that which it's used at the bluemouse quest which ill check now cuz i was working on something similar to that

if i found something useful ill edit this post
but tell me if your problem was the first case i mentioned above

[JohnHeatz]

#Moved to the right section

[pro4never]

You're already moving it in the database

now you need to move them in the server memory


to do that just look up the npc in memory and update its location (alternatively just re-load all the npcs but that's a horrible way of handling it)

[asdalhog]

Originally Posted by go for it

i can't really understand your problem
your problem is with changing a value in the database ?
or your problem is that you want this to take effect without restarting the server ?
if you suffer from the first problem try the next piece of code i made it for the same reason

                                    MySqlCommand cmd = new MySqlCommand(MySqlCommandType.UPDATE);
                                    cmd.Update("npcs").Set("mapid", Npc_Map).Set("cellx", Npc_X).Set("celly", Npc_Y).Where("id", npctochangeid).Execute();

if you suffer from the second problem then i think you need to respawen all npcs again so he move to his new coords

well there is an advanced way to do that which it's used at the bluemouse quest which ill check now cuz i was working on something similar to that

if i found something useful ill edit this post
but tell me if your problem was the first case i mentioned above

its second problem and i try to respawen all npcs nothink done
and i try to reload all database no think happen
must restart so what i can do if u have some think can help me ?

Originally Posted by pro4never

You're already moving it in the database

now you need to move them in the server memory


to do that just look up the npc in memory and update its location (alternatively just re-load all the npcs but that's a horrible way of handling it)

i reload all memory of server and no think happen
must restart

[shadowman123]

well i understood what do u mean or what do u want to do u would like to change the cords of the npc when sm1 click on it like ctf or blue mouse quest anyways its peice of cake .. first u should remove the npc from the clicker screen and any other players in the same screen distance .. then u should send npc spawn packet 2030 to every1 in the screen nearby the new npc cords then u should update this on the database so that when restarting server it become in the last location it was at and dont forget to add the npc in client's screen

[asdalhog]

Originally Posted by shadowman123

well i understood what do u mean or what do u want to do u would like to change the cords of the npc when sm1 click on it like ctf or blue mouse quest anyways its peice of cake .. first u should remove the npc from the clicker screen and any other players in the same screen distance .. then u should send npc spawn packet 2030 to every1 in the screen nearby the new npc cords then u should update this on the database so that when restarting server it become in the last location it was at and dont forget to add the npc in client's screen

okay i understand what u need to say
but if it peice of cake like u say
tell me cuz am beginner in .net
so tell me how i can remove the npc from the clicker screen and any other players in the same screen distance
or give me the path to be followed

[shadowman123]

well to be Honest as a beginer u cant do smthing like that cuz u are going too deep for these stuffs .. u need to know how things go inside the source then ask question about the concept

[go for it]

npc spawn packet 2030

try sending the same id with different coords and it should remove the old and show the new
but this is really poor way of doing it
personally i couldn't get to a decent way to get it done
and couldn't change it in memory then send a packet updating it's coords

cuz here
when you update it's coords now for players in the range , if you gone out range the back to the range it will be on the old coords which is in the memory which it got it from the database

im trying the method pro4never mentioned , didn't give it a try yet but personally i think it's the best way to get it done

[shadowman123]

Originally Posted by go for it

npc spawn packet 2030

try sending the same id with different coords and it should remove the old and show the new
but this is really poor way of doing it
personally i couldn't get to a decent way to get it done
and couldn't change it in memory then send a packet updating it's coords

cuz here
when you update it's coords now for players in the range , if you gone out range the back to the range it will be on the old coords

thats y i said you should work on screen part with adding / removing npcs / entities

[go for it]

so you mean that everytime player try to access it you will send another 2030 packet with a "Fake location" then save this location to the database
not a proper way , right ?

[asdalhog]

Originally Posted by shadowman123

well to be Honest as a beginer u cant do smthing like that cuz u are going too deep for these stuffs .. u need to know how things go inside the source then ask question about the concept

why u say that
programming language never end
so we all beginer everything possible to do
If there insistence u will do any think
and my npc is done
and appear for all ppls
in screen

"go for it"
he help from his heart
thanks go for it
For your interest in the Topic

this my npc video

[shadowman123]

Originally Posted by asdalhog

why u say that
programming language never end
so we all beginer everything possible to do
If there insistence u will do any think
and my npc is done
and appear for all ppls
in screen

your npc is done cuz of our help and no it isnt about just Programming its about understanding stuffs in sources to be able to add / remove / update systems

[go for it]

why u say that
programming language never end
so we all beginer everything possible to do
If there insistence u will do any think
and my npc is done
and appear for all ppls
in screen

"go for it"
he help from his heart
thanks go for it
For your interest in the Topic

this my npc video

BigBoS EveNT Drop Cps 5639 - YouTube

aww happy it worked now pm me the code source for this npc i want to try it out jajajja XD XD XD