TQ binarys npcs

~~lol-lol~~ · 02/21/2009, 18:03

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 ..

~~BALTA00~~ · 02/22/2009, 02:06

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..!

Its no from me, its from galdik,

galdik · 02/22/2009, 13:22

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

~~BALTA00~~ · 02/22/2009, 16:01

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

galdik · 02/23/2009, 13:17

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)

_Emme_ · 02/23/2009, 13:23

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

~~tolgasaygi~~ · 03/02/2009, 04:53

its bug don't works

skyduh · 03/18/2009, 04:25

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

Tw3ak · 03/18/2009, 11:01

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 ?

skyduh · 03/18/2009, 11:41

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

skyduh · 03/18/2009, 12:07

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?

araXis · 03/19/2009, 11:30

Lol use Cpadmin2 for making galdik this is working..

~~DontFuckWithMe~~ · 03/19/2009, 14:36

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

notforme · 03/20/2009, 15:07

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?

Snikersons · 03/20/2009, 15:59

ahh which file i have to open?