Spawn Editor by PurpleYouko

Tools for osRose and osiRose will be placed in here, as well as Rose file formats.

Please PM rl2171 or lmame to get them added to the list.

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

How could you rate this program?

Very Good
9
82%
Good
1
9%
Buggy
0
No votes
Impossible to use
1
9%
 
Total votes : 11

Re: Spawn Editor by PurpleYouko

Postby PurpleYouko on Thu Apr 10, 2008 5:47 pm

Rescudo wrote:Excel 07 did the trick; PY's Excel editors now work Excellently (sorry, I need to make bad puns once in a while). They don't show Korean / Japanese characters though :(

Do you want them to?

I do have a way to display the unicode characters in Korean (or potentially any other language) but it's a pain in the butt to code it.
Besides, the only korean stuff is in the names column and the way I designed it is that we can overwrite all that stuff with the English equivalent just by importing the names from the STL then saving the STB again.
Need to lookup information on NARose items, skills, quests?
Now featuring a newly completed skill tree for all classes
Formatting fixed for different resolutions
Image

"A Gazelle is nothing but a giraffe plotted logarithmicaly"
User avatar
PurpleYouko
Rose Guru
Rose Guru
 
Posts: 4733
Joined: Fri Aug 10, 2007 2:05 pm

Re: Spawn Editor by PurpleYouko

Postby Rescudo on Fri Apr 11, 2008 7:14 am

I'll continue this discussion in the appropriate thread; this doesn't really relate to the Spawn Editor. :)
SEARCH - it's there for a reason!
User avatar
Rescudo
El Verloon Marshall
El Verloon Marshall
 
Posts: 872
Joined: Tue Mar 11, 2008 7:20 am

Re: Spawn Editor by PurpleYouko

Postby buzbee on Fri Jun 06, 2008 9:57 pm

does this work with osirose

if so how do i save my sql file?
buzbee
Pomic
Pomic
 
Posts: 96
Joined: Fri Jun 06, 2008 3:32 am

Re: Spawn Editor by PurpleYouko

Postby PurpleYouko on Fri Jun 06, 2008 10:01 pm

yes it will work with osirose, unless you are using the IFO system that drakia developed for osProse.

You need to copy the list of spawns from the relevant tab into a fresh spreadsheet and save it as a CSV. From there you can import it into SQL
Need to lookup information on NARose items, skills, quests?
Now featuring a newly completed skill tree for all classes
Formatting fixed for different resolutions
Image

"A Gazelle is nothing but a giraffe plotted logarithmicaly"
User avatar
PurpleYouko
Rose Guru
Rose Guru
 
Posts: 4733
Joined: Fri Aug 10, 2007 2:05 pm

Re: Spawn Editor by PurpleYouko

Postby buzbee on Fri Jun 06, 2008 10:13 pm

thank purple i appreciate the tool
buzbee
Pomic
Pomic
 
Posts: 96
Joined: Fri Jun 06, 2008 3:32 am

Re: Spawn Editor by PurpleYouko

Postby xchiemmatorx on Wed Aug 20, 2008 2:24 pm

darn, i still dont get how to use it..... i cant put it in mysql? =(
xchiemmatorx
Little soul
Little soul
 
Posts: 1
Joined: Wed Aug 13, 2008 8:20 am

Re: Spawn Editor by PurpleYouko

Postby PurpleYouko on Wed Aug 20, 2008 2:32 pm

xchiemmatorx wrote:darn, i still dont get how to use it..... i cant put it in mysql? =(


1) Copy the output page into a new workbook.
2) Save it as a CSV file
3) Open your database management program. I recomend phpmyadmin but if you really feel you have to run navicat or mysqlyog, feel free.
4) Import the CSV into your database. You might need to empty the existing data first though.

It's pretty easy once you have done it a couple of times.
I actually wrote a version that writes directly to the database but nobody but me seemed to be able to set it up correctly on their own PCs so i didn't release it.

PS I'm also working on a stand alone editor for IFO type spawns that reads and writes directly to/from your database. I wonder if that will be any easier for people to use. Hope so. :D
Need to lookup information on NARose items, skills, quests?
Now featuring a newly completed skill tree for all classes
Formatting fixed for different resolutions
Image

"A Gazelle is nothing but a giraffe plotted logarithmicaly"
User avatar
PurpleYouko
Rose Guru
Rose Guru
 
Posts: 4733
Joined: Fri Aug 10, 2007 2:05 pm

Re: Spawn Editor by PurpleYouko

Postby zeroranger on Tue May 05, 2009 3:16 am

i used this tools for osRose dev rev 336 but nothing happened after i add them (list of custom spawn mobs) to list_spawnareas table in my database, mobs didnt spawn.

something wrong?
"The world is full of fascinating problems waiting to be solved" - ESR
User avatar
zeroranger
Smoulie
Smoulie
 
Posts: 58
Joined: Sun Apr 19, 2009 5:02 am

Re: Spawn Editor by PurpleYouko

Postby PurpleYouko on Tue May 05, 2009 2:13 pm

This tool is only compatible with rev 80 type spawns.
the dev rev uses a completely different system and draws from a completely different database table.
Need to lookup information on NARose items, skills, quests?
Now featuring a newly completed skill tree for all classes
Formatting fixed for different resolutions
Image

"A Gazelle is nothing but a giraffe plotted logarithmicaly"
User avatar
PurpleYouko
Rose Guru
Rose Guru
 
Posts: 4733
Joined: Fri Aug 10, 2007 2:05 pm

Re: Spawn Editor by PurpleYouko

Postby krimera on Fri Jul 30, 2010 2:21 pm

I got error 76 "path not found" when i select a map.
krimera
Smoulie
Smoulie
 
Posts: 37
Joined: Tue Nov 13, 2007 12:18 am

PreviousNext

Return to Tools and File Format

Who is online

Users browsing this forum: No registered users and 8 guests

cron