TQ binarys npcs

I want to create an npc in TQ binarys ... hehe i don't know from where ??
can any1 write here the code of npc trade cps for money?? thanks ..

I am work with TQ Binary, I can help u to add CPAdmin...

Quote:

UPDATE cq_npc SET name="CPAdmin" WHERE id=431 AND name="StoreKeeper"; UPDATE cq_npc SET lookface=3337 WHERE id=431; UPDATE cq_action SET id_next=9600151 WHERE id_next=9600154 AND id=9600150; INSERT INTO cq_action VALUES (9600151,9600152,0000,0101,0,"~I~also~love~DragonB alls~and~if~you~gave~me~some~I~will~pay~you~respec tively!"); INSERT INTO cq_action VALUES (9600152,9600153,0000,0101,0,"~"); INSERT INTO cq_action VALUES (9600153,9600154,0000,0101,0,"~"); # UPDATE cq_action SET id=9600159 WHERE id_next=610183 AND id=9600157; INSERT INTO cq_action VALUES (9600157,9600158,0000,0102,0,"Good~here~is~DragonB all 9600160"); INSERT INTO cq_action VALUES (9600158,9600159,0000,0102,0,"Great~here~is~Dragon BallSroll 9600164"); # INSERT INTO cq_task VALUES (9600160,9600160,0000,"","",0,0,0,0,1000,0000,0000 ,0,-1,0); INSERT INTO cq_task VALUES (9600164,9600164,0000,"","",0,0,0,0,1000,0000,0000 ,0,-1,0); # INSERT INTO cq_action VALUES (9600160,9600161,9600168,0502,1088000,""); INSERT INTO cq_action VALUES (9600161,9600162,0000,1001,0,"e_money += 215"); INSERT INTO cq_action VALUES (9600162,9600163,0000,1085,0,"gmlog/emoney_buy %user_id %user_name %account_id ?? ?? 0 Sold.DB"); INSERT INTO cq_action VALUES (9600163,0000,0000,1010,2005,"You have sold DragonBall for 215 CPs."); # INSERT INTO cq_action VALUES (9600168,9600169,0000,0101,0,"You~don't~have~it!~~ Get~out~you~little~scammer."); INSERT INTO cq_action VALUES (9600169,610183,0000,0102,0,"Sorry. 0"); # INSERT INTO cq_action VALUES (9600164,9600165,9600168,502,720028,""); INSERT INTO cq_action VALUES (9600165,9600166,0000,1001,0,"e_money += 2150"); INSERT INTO cq_action VALUES (9600166,9600167,0000,1085,0,"gmlog/emoney_buy %user_id %user_name %account_id ?? ?? 0 Sold.DBScroll"); INSERT INTO cq_action VALUES (9600167,0000,0000,1010,2005,"You have sold DragonBallScroll for 2150 CPs.");

Here a pic..!

[Only registered and activated users can see links. Click Here To Register...]

Its no from me, its from galdik, [Only registered and activated users can see links. Click Here To Register...]

why dont u answer his second question properly ??
oh wait u dont have change2.CPAdmin... ??

Srry galdik, i got edit my first post and give credit to you...

I was more like joking. didnt said anything against u posting it. but yes if u posted just the link it would save u time and maybe him too (as long as he could find more stuff in there)

"lol-lol" , please stop it! You made atleast 20 threads about TQ binaries, keep your questions in the binary thread. God!

its bug don't works

This code of CPADMIN has bug.
i need mysql code to make CP CHANGER
how i make this code?

Quote:

Originally Posted by skyduh This code of CPADMIN has bug. i need mysql code to make CP CHANGER how i make this code?

learn to do it yourself ? :rolleyes:

i try do it,
but..
can you help me?

Quote:

Can you explain to us what you tried? And im not talking about Copy + Pasting that in the Query Window..

i know make this..
but the code has bug, dont work.!
i need help to make npc = change cp for gold

i Am Trying this

UPDATE cq_npc SET name="CPAdmin" WHERE id=431 AND name="StoreKeeper";
UPDATE cq_npc SET lookface=3337 WHERE id=431;
UPDATE cq_action SET id_next=9600151 WHERE id_next=9600154 AND id=9600150;
INSERT INTO cq_action VALUES (9600151,9600152,0000,0101,0,"CPS?!?!");
INSERT INTO cq_action VALUES (9600152,9600153,0000,0101,0,"~");
INSERT INTO cq_action VALUES (9600153,9600154,0000,0101,0,"~");
#
UPDATE cq_action SET id=9600159 WHERE id_next=610183 AND id=9600157;
INSERT INTO cq_action VALUES (9600157,9600158,0000,0102,0,"2kk for 500cps 9600160");
INSERT INTO cq_action VALUES (9600158,9600159,0000,0102,0,"500cps for 2kk 9600164");
#
INSERT INTO cq_task VALUES (9600160,9600160,0000,"","",0,0,0,0,1000,0000,0000 ,0,-1,0);
INSERT INTO cq_task VALUES (9600164,9600164,0000,"","",0,0,0,0,1000,0000,0000 ,0,-1,0);
#
INSERT INTO cq_action VALUES (9600160,9600161,9600168,0502,1088000,"");
INSERT INTO cq_action VALUES (9600161,9600162,0000,1001,0,"e_money += 500");
INSERT INTO cq_action VALUES (9600162,9600163,0000,1085,0,"money -= 2000000");
INSERT INTO cq_action VALUES (9600163,0000,0000,1010,2005,"Thanks.");
#
INSERT INTO cq_action VALUES (9600168,9600169,0000,0101,0,"You~don't~have~it!~~ Get~out~you~little~scammer.");
INSERT INTO cq_action VALUES (9600169,610183,0000,0102,0,"Sorry. 0");
#
INSERT INTO cq_action VALUES (9600164,9600165,9600168,502,720028,"");
INSERT INTO cq_action VALUES (9600165,9600166,0000,1001,0,"money += 2000000");
INSERT INTO cq_action VALUES (9600166,9600167,0000,1085,0,"e_money -= 500");
INSERT INTO cq_action VALUES (9600167,0000,0000,1010,2005,"Thanks");





where have error?

Lol use Cpadmin2 for making galdik this is working.. ;)

Hey balta can u help me? I wanna add some new npc`s!

Quote:

Originally Posted by skyduh i know make this.. but the code has bug, dont work.! i need help to make npc = change cp for gold i Am Trying this UPDATE cq_npc SET name="CPAdmin" WHERE id=431 AND name="StoreKeeper"; UPDATE cq_npc SET lookface=3337 WHERE id=431; UPDATE cq_action SET id_next=9600151 WHERE id_next=9600154 AND id=9600150; INSERT INTO cq_action VALUES (9600151,9600152,0000,0101,0,"CPS?!?!"); INSERT INTO cq_action VALUES (9600152,9600153,0000,0101,0,"~"); INSERT INTO cq_action VALUES (9600153,9600154,0000,0101,0,"~"); # UPDATE cq_action SET id=9600159 WHERE id_next=610183 AND id=9600157; INSERT INTO cq_action VALUES (9600157,9600158,0000,0102,0,"2kk for 500cps 9600160"); INSERT INTO cq_action VALUES (9600158,9600159,0000,0102,0,"500cps for 2kk 9600164"); # INSERT INTO cq_task VALUES (9600160,9600160,0000,"","",0,0,0,0,1000,0000,0000 ,0,-1,0); INSERT INTO cq_task VALUES (9600164,9600164,0000,"","",0,0,0,0,1000,0000,0000 ,0,-1,0); # INSERT INTO cq_action VALUES (9600160,9600161,9600168,0502,1088000,""); INSERT INTO cq_action VALUES (9600161,9600162,0000,1001,0,"e_money += 500"); INSERT INTO cq_action VALUES (9600162,9600163,0000,1085,0,"money -= 2000000"); INSERT INTO cq_action VALUES (9600163,0000,0000,1010,2005,"Thanks."); # INSERT INTO cq_action VALUES (9600168,9600169,0000,0101,0,"You~don't~have~it!~~ Get~out~you~little~scammer."); INSERT INTO cq_action VALUES (9600169,610183,0000,0102,0,"Sorry. 0"); # INSERT INTO cq_action VALUES (9600164,9600165,9600168,502,720028,""); INSERT INTO cq_action VALUES (9600165,9600166,0000,1001,0,"money += 2000000"); INSERT INTO cq_action VALUES (9600166,9600167,0000,1085,0,"e_money -= 500"); INSERT INTO cq_action VALUES (9600167,0000,0000,1010,2005,"Thanks"); where have error?

INSERT INTO cq_action VALUES (9600160,9600161,9600168,0502,1088000,""); <-- it checks here if you have a dragon ball (1088000 is item id for DB), as long as you have that check in there, you need a dragonball in your inventory for it to work.

Does anyone know the code to check if somebody is a PM? say i want to create an npc that only works for PM's, what check would i have to do?

ahh which file i have to open?:confused: