CSV & SQL 177 - osRose

If you want to help us or give some corrections / codes, put it here ;)

Moderators: osRose dev team, ospRose dev team, osiRose dev team, Moderators

CSV & SQL 177 - osRose

Postby rl2171 on Tue Aug 26, 2008 6:21 pm

CSV are the updated csv files. Be sure to check to see if you are able to use all the files. some of them will require you to do other things before using them (duplicate entries or the product one has issues unless you modified the code)

SQL are some updated sql files. Check the readme1st.txt before using. Some is just a replacement for rev80+, some maybe for 81 only at this time and some have not been tested or has not been coded yet in osRose.

..... From Lmame...

1°) skills_data.sql:
In ths skill file (skills_data.sql) you got this as first lines:
#WARNING, multiple skillID detected !! 2987
#WARNING, multiple skillID detected !! 321
#WARNING, multiple skillID detected !! 5587
#Don t forget to enter the good values for fields script, value1, gm_aoe

This means there are several skills with the same skillID. It's taken from the STB so what you need to do is to remove some skills that have the same skillID in a way that only one should remain.
Once it's done, delete those lines:
#WARNING, multiple skillID detected !! 2987
#WARNING, multiple skillID detected !! 321
#WARNING, multiple skillID detected !! 5587
#Don t forget to enter the good values for fields script, value1, gm_aoe

And use Navicat (or phpmyadmin or whatever) to execute the .sql file.


2°) extra-skill.sql:
Execute file "extra-skill.sql" AFTER "skills_data.sql".

3*)

Be sure to read this thread in case your server crashes when loading the csv, you'll have perhaps to change a line of code:
viewtopic.php?f=21&t=1727

As you can see, there are two useitem_data files, useitem_data_80.csv and useitem_data_81.csv.
It's pretty obvious still I prefer to tell it, if you use rev80, use the file useitem_data_80.csv and rename it to useitem_data.csv of course.

Edit 2008/08/31:
4°) Here is a sql file that updates your monsters HP too.
That should solve the problem of the "half full" health bar from monsters.
npc_data_sell_hp.rar
(5.34 KiB) Downloaded 811 times



Edit 2008/09/05:
Don't use the list_telegates.sql from the Ver177.zip file, use this one !
list_telegates.rar
(1.93 KiB) Downloaded 775 times
Image
rl2171
Admin
Admin
 
Posts: 1706
Joined: Mon Aug 06, 2007 5:17 pm
Location: Sacramento, CA USA - GMT-8

Re: CSV & SQL 177 - osRose

Postby rl2171 on Tue Aug 26, 2008 6:51 pm

Here are the 177 files as promised
Attachments
Ver177.zip
version 177 csv & sql files
(387 KiB) Downloaded 787 times
Image
rl2171
Admin
Admin
 
Posts: 1706
Joined: Mon Aug 06, 2007 5:17 pm
Location: Sacramento, CA USA - GMT-8

Re: CSV & SQL 177 - osRose

Postby lmame on Tue Aug 26, 2008 7:11 pm

Be sure to check those two threads for bug fixes in case you got those bugs:
[Rev80 Bug Fix] dual scratch disconnects client
[Rev80 Bug Fix] can't learn skill, crash at startup...
The world is full of love and peace ^_^
Image
User avatar
lmame
Admin
Admin
 
Posts: 8997
Joined: Mon Aug 06, 2007 4:42 pm
Location: July City

Re: CSV & SQL 177 - osRose

Postby lmame on Sun Aug 31, 2008 6:47 pm

First post edited to add a new sql file that updates too the monsters HP.
The world is full of love and peace ^_^
Image
User avatar
lmame
Admin
Admin
 
Posts: 8997
Joined: Mon Aug 06, 2007 4:42 pm
Location: July City

Re: CSV & SQL 177 - osRose

Postby zadork on Tue Sep 02, 2008 9:03 pm

Humm world server crash!! :?
zadork
Pomic
Pomic
 
Posts: 90
Joined: Wed Sep 19, 2007 3:40 am

Re: CSV & SQL 177 - osRose

Postby lmame on Tue Sep 02, 2008 9:15 pm

zadork wrote:Humm world server crash!! :?

At startup? Did you read post 3?
The world is full of love and peace ^_^
Image
User avatar
lmame
Admin
Admin
 
Posts: 8997
Joined: Mon Aug 06, 2007 4:42 pm
Location: July City

Re: CSV & SQL 177 - osRose

Postby rl2171 on Tue Sep 02, 2008 9:27 pm

NA178 is very minor updates.

WIll wait to see what next version has to post.
Image
rl2171
Admin
Admin
 
Posts: 1706
Joined: Mon Aug 06, 2007 5:17 pm
Location: Sacramento, CA USA - GMT-8

Re: CSV & SQL 177 - osRose

Postby zadork on Tue Sep 02, 2008 9:42 pm

Im sorry i didnt say anything!! :oops:
zadork
Pomic
Pomic
 
Posts: 90
Joined: Wed Sep 19, 2007 3:40 am

Re: CSV & SQL 177 - osRose

Postby lmame on Tue Sep 02, 2008 9:53 pm

:lol: don't worry ^_^
The world is full of love and peace ^_^
Image
User avatar
lmame
Admin
Admin
 
Posts: 8997
Joined: Mon Aug 06, 2007 4:42 pm
Location: July City

Re: CSV & SQL 177 - osRose

Postby zadork on Wed Sep 03, 2008 1:27 am

Hummm im noob abot sql,there is a topic for how to update the npc_data whit the npc_data_sell_hp?? :?:
zadork
Pomic
Pomic
 
Posts: 90
Joined: Wed Sep 19, 2007 3:40 am

Next

Return to Submit Code

Who is online

Users browsing this forum: No registered users and 1 guest