Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server > SRO PServer Guides & Releases
You last visited: Today at 02:39

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



[Release] Vehalla Online Databases from 13.06.06

Discussion on [Release] Vehalla Online Databases from 13.06.06 within the SRO PServer Guides & Releases forum part of the SRO Private Server category.

Reply
 
Old 09/12/2013, 16:19   #151
 
elite*gold: 0
Join Date: Feb 2008
Posts: 212
Received Thanks: 21
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.



yangc10 is offline  
Old 09/12/2013, 16:40   #152
 
elite*gold: 200
Join Date: Nov 2008
Posts: 1,261
Received Thanks: 676
Quote:
Originally Posted by yangc10 View Post
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.


flozz is offline  
Thanks
1 User
Old 09/12/2013, 16:46   #153
 
elite*gold: 0
Join Date: Oct 2011
Posts: 138
Received Thanks: 21
Quote:
Originally Posted by flozz View Post
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
isozy is offline  
Old 09/12/2013, 17:23   #154
 
elite*gold: 0
Join Date: Oct 2011
Posts: 38
Received Thanks: 2
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???


huntercodex is offline  
Old 09/12/2013, 17:28   #155
 
elite*gold: 0
Join Date: Feb 2008
Posts: 212
Received Thanks: 21
Quote:
Originally Posted by isozy View Post
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.
yangc10 is offline  
Old 09/12/2013, 17:57   #156
 
elite*gold: 0
Join Date: Oct 2011
Posts: 138
Received Thanks: 21
Quote:
Originally Posted by huntercodex View Post
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.
isozy is offline  
Old 09/12/2013, 20:16   #157
 
elite*gold: 200
Join Date: Nov 2008
Posts: 1,261
Received Thanks: 676
Quote:
Originally Posted by isozy View Post
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 View Post
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.
flozz is offline  
Thanks
1 User
Old 09/12/2013, 21:20   #158
 
elite*gold: 0
Join Date: Oct 2011
Posts: 138
Received Thanks: 21
Quote:
Originally Posted by flozz View Post
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
isozy is offline  
Old 09/12/2013, 22:08   #159
 
elite*gold: 0
Join Date: Oct 2011
Posts: 38
Received Thanks: 2
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
huntercodex is offline  
Old 09/13/2013, 09:36   #160
 
elite*gold: 0
Join Date: Mar 2012
Posts: 657
Received Thanks: 24
i add media , sql , and lua and dont ?

ILowe is offline  
Old 09/13/2013, 23:23   #161
 
elite*gold: 0
Join Date: Feb 2008
Posts: 212
Received Thanks: 21
Quote:
Originally Posted by huntercodex View Post
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
yangc10 is offline  
Old 09/14/2013, 04:19   #162
 
elite*gold: 0
Join Date: Oct 2011
Posts: 138
Received Thanks: 21
Quote:
Originally Posted by yangc10 View Post
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.
isozy is offline  
Old 09/14/2013, 07:13   #163
 
elite*gold: 0
Join Date: Feb 2008
Posts: 212
Received Thanks: 21
Quote:
Originally Posted by isozy View Post
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.
yangc10 is offline  
Old 09/14/2013, 14:14   #164
 
elite*gold: 0
Join Date: Oct 2011
Posts: 138
Received Thanks: 21
Quote:
Originally Posted by yangc10 View Post
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...
isozy is offline  
Old 09/14/2013, 15:18   #165
 
elite*gold: 0
Join Date: Feb 2008
Posts: 212
Received Thanks: 21
Quote:
Originally Posted by isozy View Post
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.


yangc10 is offline  
Reply



« [Release] tsword Weapon D24 | [Free Release] Electus Cap 110 HWID limit Bypass »

Similar Threads
[Release]Most of Vsro Databases available here
11/01/2014 - SRO PServer Guides & Releases - 15 Replies
Hello Guys these databases working 100% Without any error with SR_GameServer here you have the links 1st one D12 Without buggs Copied Working with Mssql2005 . shard.UploadedByFlowushy.zip 2nd Working with only mssql 2008 R2 * Level: 120 Skill: 120 * Fix FGW and Dimension Hole to 101-120! * Added Jaguar, Fenix, Dog * Added News Avatars * Weapon Rare D13 Added Fgw Quest! * Added Itens Rare D12 In Magic Pop!
[Release]Blackrogue SQL 2005 Databases!
01/09/2013 - SRO PServer Guides & Releases - 36 Replies
Hello again.Now those databases are clean.Now try again i think they are working fully :) New download link: http://www.mediafire.com/?6mbkrrnmvg1sb99 Open new database and click new query than execute all databases. They are clean database you must edit this databases manual. I can help you if you need help!
[Release] Twi's Improved Databases
01/03/2013 - Flyff PServer Guides & Releases - 17 Replies
Sodale, da hier immernoch Fragen wegen irgendwelcher Datenbanken auftauchen und die AiO-Database aus meiner Sicht nicht wirklich etwas taugt, dachte ich, ich haue eine überarbeitete Version der Datenbanken raus, die im Umlauf sind. Dieser Release beinhaltet folgende Datenbanken, welche in den Ordnern (beide bitte erstellen!) C:\DBData C:\DBLogData
[RELEASE] SWSRO Databases D12
02/29/2012 - SRO Private Server - 19 Replies
today i completed Swsro DataBase D12 http://store2.up-00.com/Jan12/8YQ76084.jpg Download:sro_china_cs.rar Password:King$ Create by me no others http://store2.up-00.com/Jan12/a9j76084.gif if u found a bug post here ^.^ ;)
Release : Vsro Databases in Query
09/16/2011 - SRO Private Server - 13 Replies
deleted



All times are GMT +1. The time now is 02:39.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

BTC: 33E6kMtxYa7dApCFzrS3Jb7U3NrVvo8nsK
ETH: 0xc6ec801B7563A4376751F33b0573308aDa611E05

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2019 elitepvpers All Rights Reserved.