Need Some Help!

DiobloSlayeR · 10/02/2008, 08:12

Hey guyz.. I am having problems with database and if any one is willing to help me, plz join my hamachi network ToXiC-Online , pass: 123 .. I know how to set up server and I know all those, but I just have problems with database.

Hope some 1 will help me

PS: You'll be rewarded with PM in my server if you helped me =P
I would also like to include that I'm recruiting a team to help me out with server as I am busy and can't handle the server myself as I need to fix much bugs.

funhacker · 10/02/2008, 08:40

really you shouldnt be giving out PM as a "reward" it kind of justifys them cheating later on, as for your problems post them you might get the help your after

DiobloSlayeR · 10/02/2008, 09:37

Well, the problem is I use necron collection and when I add drops .. the monsters don't drop alot and when I add dye system the shopping mall and warehouse don't talk anymore, and the Thunder Juice don't work and few others ..

~~Spy520~~ · 10/02/2008, 16:06

Thunder juice :
Open cq_itemtype then add emoney to it
then Open cq_goods and add it dont forget make the owner 1207
Dye system: cuz u have cq_action that cant work with it i tried it more than 1 time but it failed :s so make ur own cq_action better

funhacker · 10/03/2008, 04:18

Quote:

Originally Posted by DiobloSlayeR

Well, the problem is I use necron collection and when I add drops .. the monsters don't drop alot and when I add dye system the shopping mall and warehouse don't talk anymore, and the Thunder Juice don't work and few others ..

I will only point you in the right direction this way you might actually learn
@drops look in the cq_monstertype you will know it when you see it
@dye system - Your adding it wrong read my instructions a little closer
@shopitems - Make sure they have a cost + in your cq_goods

Quote:

Originally Posted by Spy520

Thunder juice :
Open cq_itemtype then add emoney to it
then Open cq_goods and add it dont forget make the owner 1207
Dye system: cuz u have cq_action that cant work with it i tried it more than 1 time but it failed :s so make ur own cq_action better

dye system only screws up if people dont add it right its cq_action ids are well out of the current cq_action ids and TQ wont be using those ids any time soon

DiobloSlayeR · 10/03/2008, 05:13

I am using chinese cq_action translated and when I run the script ... it gives me the error duplicate entry.

funhacker · 10/03/2008, 09:21

Quote:

Originally Posted by DiobloSlayeR

I am using chinese cq_action translated and when I run the script ... it gives me the error duplicate entry.

did you check to see if the dye system is already in there?

lightnin86 · 10/03/2008, 10:35

The dye system is already in the db. We are able to buy the dyes at the shopping mall. When you right click on the dye it has instructions on what casual you want to dye, it works well but when you choose what dyed casual you want it doesn't give you one.

Should we look at cq_goods for this problem or at cq_itemtype?
Thanks for the help.

DiobloSlayeR · 10/03/2008, 10:51

Quote:

Originally Posted by lightnin86

The dye system is already in the db. We are able to buy the dyes at the shopping mall. When you right click on the dye it has instructions on what casual you want to dye, it works well but when you choose what dyed casual you want it doesn't give you one.

Should we look at cq_goods for this problem or at cq_itemtype?
Thanks for the help.

I don't think the dye system is already their in the database, it's because the chinese cq_action does not support dye system? Hmm, funhacker, your help would be appreciated :P

funhacker · 10/03/2008, 11:40

Quote:

Originally Posted by lightnin86

The dye system is already in the db. We are able to buy the dyes at the shopping mall. When you right click on the dye it has instructions on what casual you want to dye, it works well but when you choose what dyed casual you want it doesn't give you one.

Should we look at cq_goods for this problem or at cq_itemtype?
Thanks for the help.

niether of those would be the problem (unless you stupidly forgot to add the items to the cq_itemtype)
does your itemtype.dat have my dyed casuals in it?

Quote:

Originally Posted by DiobloSlayeR

I don't think the dye system is already their in the database, it's because the chinese cq_action does not support dye system? Hmm, funhacker, your help would be appreciated :P

look it doesnt matter what cq_Action you use all of them WILL support it you want my help learn to listen
I will only say it 1 more time
dye system will NOT conflict with ANY existing IDs even in the NEWEST database UNLESS YOU made NEW cq_action ids that are the SAME as the DYE SYSTEM
there is only 2 possible reasons for your errors
1. it already has the dye system in it
2. you DID NOT read my instructions on my thread with the dye system

DiobloSlayeR · 10/03/2008, 16:04

Well, the dye system exists but I am not able to buy them, So you think I have to remove those IDs and then run SQL query again?

~~Spy520~~ · 10/03/2008, 21:57

Funhacker plz can u help me i have a small proplem with tq baby
1st i was talking and working 10% but i didn't change any professtion
then i tried to add new id to it ---> Result : Its silent now and cant talk

So can you tell me what can i do to fix it?

2nd If you have free time help me with this ( In NecreoNCollection when i entred the old marcket which is nammed by NPC CAMP (Map id: 100) i found npc that give 5 silver cards and 1 ocean card when i talk to it and she give me those cards it dissapear forever idk why

Just_Me99999 · 10/03/2008, 23:13

Quote:

Originally Posted by Spy520

Funhacker plz can u help me i have a small proplem with tq baby
1st i was talking and working 10% but i didn't change any professtion
then i tried to add new id to it ---> Result : Its silent now and cant talk

So can you tell me what can i do to fix it?

2nd If you have free time help me with this ( In NecreoNCollection when i entred the old marcket which is nammed by NPC CAMP (Map id: 100) i found npc that give 5 silver cards and 1 ocean card when i talk to it and she give me those cards it dissapear forever idk why

1st: I don't remember how I fix it.
2nd question: 100=NPC Camp is similar than real old market id:200
Don't touch id 100

~~Spy520~~ · 10/03/2008, 23:27

Quote:

Originally Posted by Just_Me99999

1st: I don't remember how I fix it.
2nd question: 100=NPC Camp is similar than real old market id:200
Don't touch id 100

I know but i took one npc from it and i tested it but it dissapear

funhacker · 10/04/2008, 01:50

Quote:

Originally Posted by DiobloSlayeR

Well, the dye system exists but I am not able to buy them, So you think I have to remove those IDs and then run SQL query again?

if you cant buy them check their cost in cq_itemtype and make sure they have been added to ownerid 1207.

Quote:

Originally Posted by Spy520

Funhacker plz can u help me i have a small proplem with tq baby
1st i was talking and working 10% but i didn't change any professtion
then i tried to add new id to it ---> Result : Its silent now and cant talk

So can you tell me what can i do to fix it?

you have stoped it from waiting for choice and loading an npc face I cant remember the id you should put after the final npc choice for TQ baby off the top of my head, but you could just try a random number like 4000009 put that as your id_next in your last choice for the npc this will load an npc face and then wait for a choice (I think that face is the family war guys not sure)