CSV & SQL 177 - osRose
Posted: Tue Aug 26, 2008 6:21 pmCSV 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.
Edit 2008/09/05:
Don't use the list_telegates.sql from the Ver177.zip file, use this one !
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 820 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 781 times
don't worry ^_^