Need Some Help!

10/02/2008 08:12 DiobloSlayeR#1
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.
10/02/2008 08:40 funhacker#2
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
10/02/2008 09:37 DiobloSlayeR#3
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 ..
10/02/2008 16:06 Spy520#4
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 :p
10/03/2008 04:18 funhacker#5
Quote:
Originally Posted by DiobloSlayeR View Post
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 View Post
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 :p
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
10/03/2008 05:13 DiobloSlayeR#6
I am using chinese cq_action translated and when I run the script ... it gives me the error duplicate entry.
10/03/2008 09:21 funhacker#7
Quote:
Originally Posted by DiobloSlayeR View Post
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?
10/03/2008 10:35 lightnin86#8
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.
10/03/2008 10:51 DiobloSlayeR#9
Quote:
Originally Posted by lightnin86 View Post
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
10/03/2008 11:40 funhacker#10
Quote:
Originally Posted by lightnin86 View Post
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 View Post
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
10/03/2008 16:04 DiobloSlayeR#11
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?
10/03/2008 21:57 Spy520#12
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 :confused:

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 :confused:
10/03/2008 23:13 Just_Me99999#13
Quote:
Originally Posted by Spy520 View Post
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 :confused:

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 :confused:
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
10/03/2008 23:27 Spy520#14
Quote:
Originally Posted by Just_Me99999 View Post
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 :confused:
10/04/2008 01:50 funhacker#15
Quote:
Originally Posted by DiobloSlayeR View Post
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 View Post
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 :confused:

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)