[Release] Vehalla Online Databases from 13.06.06

yangc10 · 09/12/2013, 16:19

cool. I think I found my problem:

Code:

92	473538898	5621	0	0	7372	-1	-1	-1
93	430636533	7087	0	0	7593	-1	-1	-1
94	688586209	8373	0	0	7821	-1	-1	-1
95	686078166	8693	0	0	8055	-1	-1	-1
96	630281734	9013	0	0	8297	-1	-1	-1
97	843249355	9333	0	0	8546	-1	-1	-1
98	963955058	10811	0	0	8802	-1	-1	-1
99	1322659532	12765	0	0	9066	-1	-1	-1
100	99999999999999	13715	0	0	9619	-1	-1	-1

Can't test it now (at work), but if I change the lvl100 to something like 1456453211 then it should work accordingly.

~~flozz~~ · 09/12/2013, 16:40

Quote:
Originally Posted by yangc10
cool. I think I found my problem:
Code:
92	473538898	5621	0	0	7372	-1	-1	-1
93	430636533	7087	0	0	7593	-1	-1	-1
94	688586209	8373	0	0	7821	-1	-1	-1
95	686078166	8693	0	0	8055	-1	-1	-1
96	630281734	9013	0	0	8297	-1	-1	-1
97	843249355	9333	0	0	8546	-1	-1	-1
98	963955058	10811	0	0	8802	-1	-1	-1
99	1322659532	12765	0	0	9066	-1	-1	-1
100	99999999999999	13715	0	0	9619	-1	-1	-1
Can't test it now (at work), but if I change the lvl100 to something like 1456453211 then it should work accordingly.

Yes.

isozy · 09/12/2013, 16:46

Quote:

Originally Posted by flozz

Yes.

Flozz can you refer to the previous posts regarding magic pop? Let me resume:
I dumped the whole refnest from a random DB into vehalla DB and I can see the magic pop, but will it affect anything vehalla related ingame by using other refnest? e.g.; uniques, npc's, etc

huntercodex · 09/12/2013, 17:23

good friend Flozz need your help I have another problem
after some time online not getting exp, drop and gold and not why, relogging pence that could fix but still the same ...

I can do help me???

yangc10 · 09/12/2013, 17:28

Quote:

Originally Posted by isozy

Flozz can you refer to the previous posts regarding magic pop? Let me resume:
I dumped the whole refnest from a random DB into vehalla DB and I can see the magic pop, but will it affect anything vehalla related ingame by using other refnest? e.g.; uniques, npc's, etc

yeah; i second that. The problem that we might face is whatever mob, npc, etc... that you pull from vsro refnest to vehalla; I'm sure it'll affect. If there's a way we can copy(insert) whatever is in vsro refnest to vehalla database, but do not copy duplicates then it won't affect. I'm just not good at scripting so will wait for flozz respond.

isozy · 09/12/2013, 17:57

Quote:

Originally Posted by huntercodex

good friend Flozz need your help I have another problem
after some time online not getting exp, drop and gold and not why, relogging pence that could fix but still the same ...

I can do help me???

that's greenbook, nothing to do with the database, just search on the forum theres hundreds of options regarding greenbook.

~~flozz~~ · 09/12/2013, 20:16

Quote:

Originally Posted by isozy

Flozz can you refer to the previous posts regarding magic pop? Let me resume:
I dumped the whole refnest from a random DB into vehalla DB and I can see the magic pop, but will it affect anything vehalla related ingame by using other refnest? e.g.; uniques, npc's, etc

Here's the lines which you need:
(Magic pop npc)

Code:

11112	2	1118	25000	1612.97	0	1193	32767	0	0	0	0	0	1	0	1	0
26441	12	1118	26959	444.24	80.32	225.94	16565	0	0	0	0	0	1	0	1	0
26458	301	1118	27244	913.69	180	1828.76	16565	0	0	0	0	0	1	0	1	0
26461	5	1118	26265	543.91	-106.74	1533.36	16565	0	0	0	0	0	1	0	1	0
26508	6	1118	23687	1652.38	243.82	776.57	-26215	0	0	0	0	0	1	0	1	0
29291	554	1118	23088	1364.37	863.36	1130.77	23665	0	0	0	0	0	1	0	1	0

(Magic pop gori npc) P.S Hotan coin seller almost at the same spot as this npc.

Code:

11111	2	1119	25000	977.28	-32.62	727.63	-16203	0	0	0	0	0	1	0	1	0
26446	12	1119	26959	979.04	83.74	888.54	0	0	0	0	0	0	1	0	1	0
26456	6	1119	23687	1002.84	243.98	489.59	32767	0	0	0	0	0	1	0	1	0
26459	301	1119	27244	586.65	180	1414.74	-32587	0	0	0	0	0	1	0	1	0
26462	5	1119	26265	1162.7	-106.7	1385.81	-32587	0	0	0	0	0	1	0	1	0
29617	554	1119	23088	786.2	863.36	1262.53	7827	0	0	0	0	0	1	0	1	0

Quote:

Originally Posted by huntercodex

good friend Flozz need your help I have another problem
after some time online not getting exp, drop and gold and not why, relogging pence that could fix but still the same ...

I can do help me???

As isozy mentioned, it's green book fault, try to search for some guides in google how to disable it.

isozy · 09/12/2013, 21:20

Quote:

Originally Posted by flozz

Here's the lines which you need:
(Magic pop npc)

Code:

11112	2	1118	25000	1612.97	0	1193	32767	0	0	0	0	0	1	0	1	0
26441	12	1118	26959	444.24	80.32	225.94	16565	0	0	0	0	0	1	0	1	0
26458	301	1118	27244	913.69	180	1828.76	16565	0	0	0	0	0	1	0	1	0
26461	5	1118	26265	543.91	-106.74	1533.36	16565	0	0	0	0	0	1	0	1	0
26508	6	1118	23687	1652.38	243.82	776.57	-26215	0	0	0	0	0	1	0	1	0
29291	554	1118	23088	1364.37	863.36	1130.77	23665	0	0	0	0	0	1	0	1	0

(Magic pop gori npc) P.S Hotan coin seller almost at the same spot as this npc.

Code:

11111	2	1119	25000	977.28	-32.62	727.63	-16203	0	0	0	0	0	1	0	1	0
26446	12	1119	26959	979.04	83.74	888.54	0	0	0	0	0	0	1	0	1	0
26456	6	1119	23687	1002.84	243.98	489.59	32767	0	0	0	0	0	1	0	1	0
26459	301	1119	27244	586.65	180	1414.74	-32587	0	0	0	0	0	1	0	1	0
26462	5	1119	26265	1162.7	-106.7	1385.81	-32587	0	0	0	0	0	1	0	1	0
29617	554	1119	23088	786.2	863.36	1262.53	7827	0	0	0	0	0	1	0	1	0

As isozy mentioned, it's green book fault, try to search for some guides in google how to disable it.

That's great flozz thank you.
Actually I had another idea for magic pop, not sure how much more reliable would it be.
I saw your events file and I thought of making So-Ok accept Magic Pop Cards and give them rewards, that's because I think the magic pop itself is too complicated, too much trouble, like selecting the item you want, put the card in the slot, wait, get coupon, give the coupon to Gori, it's too much steps and its boring.

So if I was to create another event by copying your Jewel Box one and changing the items/rewards what do I need to add in the database for the event to be functional?
1. Add dialogs to media for event ID x
--

thanks

huntercodex · 09/12/2013, 22:08

you can tell me or help to make the limit will be 110?

or help me to change the lvl requirement of weapons weapons ie D11, D12 or D13 can use them to lvl 100 like D10

can you help me with this problem ??? :S

ILowe · 09/13/2013, 09:36

i add media , sql , and lua and dont ?

yangc10 · 09/13/2013, 23:23

Quote:

Originally Posted by huntercodex

you can tell me or help to make the limit will be 110?

or help me to change the lvl requirement of weapons weapons ie D11, D12 or D13 can use them to lvl 100 like D10

can you help me with this problem ??? :S

you got the answer already... extract reflevel.txt from media.pk2. Modify to your needs. See my previous post for more info.

for everybody; since the magic pop guy is close to the other guy in hotan; I put him about acouple of feet away

Code:

38159	6	1119	23687	1014	244.286652	409	32767	0	0	0	0	0	1	0	1	0

isozy · 09/14/2013, 04:19

Quote:
Originally Posted by yangc10
you got the answer already... extract reflevel.txt from media.pk2. Modify to your needs. See my previous post for more info.

for everybody; since the magic pop guy is close to the other guy in hotan; I put him about acouple of feet away
Code:
38159	6	1119	23687	1014	244.286652	409	32767	0	0	0	0	0	1	0	1	0

What you think of my idea instead? copy the current jewel box event and change it accordigly to accept magic pop cards, just because I think the magic pop system itself is frustrating.

yangc10 · 09/14/2013, 07:13

Quote:

Originally Posted by isozy

What you think of my idea instead? copy the current jewel box event and change it accordigly to accept magic pop cards, just because I think the magic pop system itself is frustrating.

make sense, but i'll leave it as default.

hey flozz, thanks for the magicpop; works great. I'll get off your hair for a little bit. I'm writting down all the neccessary bug that I find. This database has become much more of stable than any other database I played with.

If anybody knows how to fix the freesilkhour, let me know.

isozy · 09/14/2013, 14:14

Quote:

Originally Posted by yangc10

make sense, but i'll leave it as default.

hey flozz, thanks for the magicpop; works great. I'll get off your hair for a little bit. I'm writting down all the neccessary bug that I find. This database has become much more of stable than any other database I played with.

If anybody knows how to fix the freesilkhour, let me know.

Right now the only issue I have is that the gameserver cant stand more than 24 hours without crashing with around 200 players online... But I don't know if thats DB related or not... CLAMP() errors left and right

Fixed one of the clamp errors by changing the lv100 exp to default in reflevel...

yangc10 · 09/14/2013, 15:18

Quote:

Originally Posted by isozy

Right now the only issue I have is that the gameserver cant stand more than 24 hours without crashing with around 200 players online... But I don't know if thats DB related or not... CLAMP() errors left and right

Fixed one of the clamp errors by changing the lv100 exp to default in reflevel...

mine crashes alot too, but that only happen if I do any database editing. If I do any editing; I have to restart my pc then startup server. By doing that, my server is alive for more than 24hrs. 4 days straight no crash last time I tried.