Helping Center

cyberghoser1 · 11/30/2008, 21:08

Quote:

Originally Posted by dani-filth0

how can i make the NPC 100 work and sell stuff

ok first delete this anoying npc by going into your database and search in cq_npc for npc cyrus.

once that done you might use one of those 2 npc's released by commandcom long time ago and edit them as you like, meaning insert other items, prices, location etc...

Special Expball's seller npc

Code:

delete from cq_action where id >= 50000000 and id <= 50000012;
delete from cq_npc where id = 1550 ;
delete from cq_task where id = 50000000;
delete from cq_task where id = 50000003;
delete from cq_task where id = 50000005;

INSERT INTO `cq_npc` VALUES ('1550', '0', '0', 'MagePeppy', '0002', '15500', '0', '0', '-1', '1000', '0304', '0450', '50000000', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', '?T', '0000', '00', '00', '0000', '01', '0000', '0000', '0000', '0000', '0000');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000000, 50000001, 0000, 0101, 0, 'My~name~is~MagePeppy.~Would~you~buy~some~Special~Expball~Packs?');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000001, 50000002, 0000, 0102, 0, 'I~would~like~few~Special~Expballs~for~20k~EPs. 50000003');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000002, 4000033, 0000, 0102, 0, 'Sorry~i~want~to~think~first. 0');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000003, 50000005, 50000004, 0508, 0, '1 0 50');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000004, 0000, 0000, 0126, 0, 'You~do~not~have~one~space~in~your~package!');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000005, 50000006, 50000008, 1001, 0, 'e_money < 20000');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000006, 50000007, 0000, 0101, 0, 'You~do~not~have~enough~EP~to~buy~a~Special~Expballs.~Come~back~when~you~do.');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000007, 4000033, 0000, 0102, 0, 'Sorry,~I~go~and~hunt~some. 0');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000008, 50000009, 0000, 0501, 724041, '');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000009, 50000010, 0000, 1085, 0, 'gmlog/action_log 330,%user_name[%user_id],0,1059,724041,0,0,0,50000000,0');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000010, 50000011, 0000, 1001, 0, 'e_money += -20000');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000011, 50000012, 0000, 0101, 0, 'Thank~You~for~buying~an~Special~Expball.~Hope~to~see~you~again.');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000012, 4000033, 0000, 0102, 0, 'Thanks 0');




INSERT INTO `cq_task` VALUES ('50000005', '50000005', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('50000000', '50000000', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('50000003', '50000003', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');

Treble Exp Potion seller npc

Code:

delete from cq_action where id >= 50000100 and id <= 50000112;
delete from cq_npc where id = 1551 ;
delete from cq_task where id = 50000100;
delete from cq_task where id = 50000103;
delete from cq_task where id = 50000105;

INSERT INTO `cq_npc` VALUES ('1551', '0', '0', 'MagePeppy', '0002', '15500', '0', '0', '-1', '1000', '0304', '0472', '50000100', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', '?T', '0000', '00', '00', '0000', '01', '0000', '0000', '0000', '0000', '0000');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000100, 50000101, 0000, 0101, 0, 'My~name~is~MagePeppy.~Would~you~buy~some~3x~Exp~Potions?');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000101, 50000102, 0000, 0102, 0, 'I~would~like~one~3x~Exp~Potion~for~10k~EPs. 50000103');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000102, 4000033, 0000, 0102, 0, 'Sorry~i~want~to~think~first. 0');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000103, 50000105, 50000104, 0508, 0, '1 0 50');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000104, 0000, 0000, 0126, 0, 'You~do~not~have~one~space~in~your~package!');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000105, 50000106, 50000108, 1001, 0, 'e_money < 10000');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000106, 50000107, 0000, 0101, 0, 'You~do~not~have~enough~EP~to~buy~a~3x~Exp~Potion.~Come~back~when~you~do.');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000107, 4000033, 0000, 0102, 0, 'Sorry,~I~go~and~hunt~some. 0');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000108, 50000109, 0000, 0501, 810009, '');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000109, 50000110, 0000, 1085, 0, 'gmlog/action_log 330,%user_name[%user_id],0,1059,724041,0,0,0,50000100,0');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000110, 50000111, 0000, 1001, 0, 'e_money += -10000');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000111, 50000112, 0000, 0101, 0, 'Thank~You~for~buying~an~3x~Exp~Potion.~Hope~to~see~you~again.');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (50000112, 4000033, 0000, 0102, 0, 'Thanks 0');




INSERT INTO `cq_task` VALUES ('50000105', '50000105', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('50000100', '50000100', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('50000103', '50000103', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');

Edit them as you like but pay attention to what cq_action you delete before apply them. Cheers

nicolexo · 11/30/2008, 21:38

Could someone help me!? I'm trying to set up a server and when i run AccountServer.exe it works and says its up but when i run MsgServer & NpcServer they just say "connect to account server again when its already connected!! Please help me!

dani-filth0 · 11/30/2008, 23:39

i mean cant i edit the price from navicat ?
and btw i cant find cyrus so i cant remove it , if i cant remove it i wanna remove mage peppy and use the 100 to sell special exps and unis XO

dani-filth0 · 11/30/2008, 23:51

sry for double post , but i have a question , how do i know what is the max lvl for players ??
i've done a query allow me to be lvl 255 , but what about other players ?
another question , how can i make the mobs in icy maze as they where , not like now only in 1 place, and why elephant hell have no mobs ?

cyberghoser1 · 12/01/2008, 03:33

search for cyrus in cq_npc its there i deleted it without any problem.as for magepepy if you want it to looks like the 100 npc just change its lookface

dani-filth0 · 12/01/2008, 09:27

no i mean i wanna edit the 100 not make the pey look like it , i wanna make the 100 work to remove the peppy.

crouch187 · 12/02/2008, 17:09

can u guys help me?? when i start playing my new DB and game.. i stop at "verifying account" and then is closes?? whats wrong with that?? i already try to use client v1091 and v1130 and followed the guide posted by "thegamer".. but nothing works.. on acct.serv, npc.serv, and msg.serv are no problem.. only when i start playing it stops at verifying account and then the client closes!! pls help!! need a quick reply!!

Deftron · 12/03/2008, 06:57

Did u edit any of ur DB?

Like max lvl, max eudemon star?

if u did, u have to get server tools that support to those lvl and star.

And also login tool.

joey123321 · 12/03/2008, 07:17

DOES ANY1 HAVE SCRIPT OR SOMETHING TO CHANGE THE CQ_LEVELEXP SO MY PLAYERS CAN LVL FASTER IF SO PLZ POST OR EMAIL IT TO ME TY

Deftron · 12/03/2008, 07:31

Code:

update cq_levexp set UsrUPLevExp=UsrUPLevExp*[B]x[/B];

Before u change ur cq_levexp, make a backup of ur because it may mess up ur db.

change x to ur liking.

crouch187 · 12/03/2008, 14:16

Quote:

Originally Posted by Deftron

Did u edit any of ur DB?

Like max lvl, max eudemon star?

if u did, u have to get server tools that support to those lvl and star.

And also login tool.

can u pls give me the server tools and login tools?
and how do i i set my reborntimes to 9999?

marcel_bocao · 12/06/2008, 03:08

well,

first of all i want to say my english is poor...but undestandable !
-----------------------------------------------------------------------------

Ok, today i was playing a EO Pserver normaly,so i loged it off to take a rest.
when i'd back something wrong just keep happening.

i'll show step-by-step what happens

1. When i click in the play.exe it show a warning menssage (it always happened and i could log in sucesfully).

2. After i click the OK buttom(as i always do without problems), it shows the welcome EO screen(i tryed to print but didnt work for some reason).Then comes a new menssage talking about my screen config.(i normaly did it but i dont know why that menssage, and i never got trouble because that)

3.This is the real trouble, it never happened before.Normaly afetr i click this ok above, the game just open....But now it shows only the name in the bar and the cursor of EO(the cursors doesnt appear on print screen sorry)

4.So i can do nothing on my screen (except move the cursor).Then i press
but anywhere i click doesnt work, so i just corfirm the Process Ending.

So please somebody help cuz it happens with every server i try, i've tryed everything i could.I cant live without EO

If someone help me i'll be happy forever

DarKLyme · 12/06/2008, 03:13

help anyone? the first time i installed mysql i set user: root pass:test but now i need to reset them to something different. how do i do that?

SirFailzAlot · 12/06/2008, 03:24

i have a question how do i go about translating Npc's etc kinda new at translating and im lost lol

DarKLyme u should be able to go to connection right click settings set admin pass/root or delete connectoion and make a new one

DarKLyme · 12/06/2008, 04:28

i need to reset master pass for mysql not navicat.