Come if ur good =D

08/30/2011 20:01 kadajxs#1

Hello , im new in co sector, i have a 5375 simple source...
theres a too much querys to add npcs in a 5095 source... like

PHP Code:


			
INSERT INTO `cq_npc` VALUES (94544, 0, 0, 'Santa' 2, 2090, -1, 1036, 206, 196, 99887701, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);



INSERT INTO `cq_action` VALUES ('99887701', '99887702', '0', '101', '0', 'Merry~Christmas~%user_name~from~all~the~staff');

INSERT INTO `cq_action` VALUES ('99887702', '99887703', '0', '101', '0', 'We~hope~that~you~have~a~very~enjoyable~christmas~and~keep~safe.');

INSERT INTO `cq_action` VALUES ('99887703', '99887704', '0', '102' '0', 'Merry~Christmas%user_name. 99887706');

INSERT INTO `cq_action` VALUES ('99887704', '610122', '0', '102', '0', 'Nah~I~am~Jahova. 0');

INSERT INTO `cq_action` VALUES ('99887706', '99887707', '0', '125', '2011', 'Merry~Christmas~from~%user_name!');

INSERT INTO `cq_action` VALUES ('99887707', '99887708', '0', '101', '0', 'Big~thank~you~from~everyone.');

INSERT INTO `cq_action` VALUES ('99887708', '610122', '0', '102', '0', 'No~Problem!~Hev~Fun~And~Please~Vote~xD~BYE~BYE. 0');

And i cant do that in a 5375, its not the same db.. everyone knows..
but how i can add thats npcs.. in my 5375 source?
If you dont understand please mp me if u can do these things...
whatever i need a guide how to make npcs in a 5375 source or edit existents... thx and sorry bad english im br x.x

PHP Code:


			
I NEED HELP TO ADD NPCS , AND BOSSES LIKE CITY BOSSES PER HOUR... NPCS TO SELL ITENS +12.. and all like that. thx

08/30/2011 20:37 BaussHacker#2

Try search. It's maybe your lucky day.

08/30/2011 21:09 kadajxs#3

Quote:

Originally Posted by BaussHacker

Try search. It's maybe your lucky day.

iv tried but dont find nothing to help me...
if u cant help me please stop posting random answers...

i cant edit their dialog , and what they sell , cant change their skins ...

if someone can help me please answ ...
if u cant help me please dont post useless answers...

08/30/2011 23:55 pro4never#4

Well I released some sample code of how to log all npc spawns from official conquer using a proxy so that would work just fine or you could use a addnpc command to place them manually.

There's no reason to run a million queries to place these things.

As for city bosses and npcs that do stuff... you have to code all of that manually obviously.

08/31/2011 04:19 Spirited#5

Use the ones that are already there as examples.
I would say that's common sense but I guess common sense doesn't exist anymore.

08/31/2011 11:23 BaussHacker#6

I think you two misunderstood what he wanted to do.

I think he wants to convert the npcs from the sql in binaries to the 5375 source.

08/31/2011 12:00 pro4never#7

If he means spawns then it's super simple. You just write a method to pull all values from the existing table, structure them as needed for the new table and execute them... Like 10-15 min of coding max.

If he means make npcs work with tq's actual sql npcs (options and such) then it's quite a bit of work. I know immune's source used them though so I mean there are examples out there as to how.