|
|
Post by TinyTerror on Dec 26, 2005 18:04:06 GMT -5
This all sounds cool, but I'm also a little worried about memory and process footprints. Lunar runs inside of FFXI, so anything I bold onto Lunar also runs in ffxi. I'll look at SQL lite. It might be workable.
|
|
|
|
Post by TinyTerror on Dec 27, 2005 15:22:00 GMT -5
Well, SQL lite looks good. My only concern is the number and complexity of the functions that would need to be wrapped for Lua. Other than than, it looks really good.
|
|
|
|
Post by TinyTerror on Dec 27, 2005 15:30:16 GMT -5
Ok, looks like the internet is way ahead of me here. I see several wrapper libs that bind SQL Lite to lua. I'll add it to the long list of stuff I would like to do, but don't really have the time for -_-
|
|
|
|
Post by dragondude on Dec 30, 2005 23:52:57 GMT -5
Hey, i can't get the images to show up... Oh well lol. If you need someone with a little time to scrounge up some info or myabe even try to type in an area or two, gimme a PM, i'm not very good w/ lua yet but i think i could do it using you west ronafure example.
|
|
|
|
Post by dragondude on Dec 31, 2005 0:19:32 GMT -5
Ok well i did some tinkering and i managed to get the colors to show up instead of whit boxes when i load AggroCheck... But as for the actual pics, no luck thus far... But i am going to keep on trying... Well, so far i really havent had any luck getting any pics to load lol, not Lunar, Leviathan or this lol...
|
|
|
|
Post by X-Drop on Dec 31, 2005 13:53:53 GMT -5
Thanks for the offer, Dragondude. I have edited this post and removed the request for help. I have actually given up on compiling FFXI data by hand. Instead, I'm writing up a PHP script to work with MySQL to grab all monster data from Somepage.com's online database. It's a giant leap forward from what I was originally doing. If all goes well, I could configure the PHP script to grab item info or whatever and have that compiled into the MySQL database too. The purpose of this local MySQL database is easy access to FFXI mob/item/area/whatever stats to use in a Lunar script. The possiblities are endless when you have instant access to a database like that. 
Tiny Terror is working on a fix for the images. It's not a script problem or user error... just something about the path which Lunar looks for the images. No big deal. Those colored boxes are a nice substitution for the image problems. That probably wasn't too hard to do either. I bet those colored boxes are more informative than having all white boxes... lol
|
|
|
|
Post by TinyTerror on Dec 31, 2005 14:19:11 GMT -5
I really would like to add sqllite stuff to lunar, but I am literally swamped with other issues. Ahh the joy of being a single programmer project -_-
|
|
|
|
Post by X-Drop on Dec 31, 2005 14:38:06 GMT -5
Don't kill yourself over SQLite. I'm gonna release the FFXI MySQL database when I finally get it all compilied. It would be more of a developer's tool than anything. Giving access to FFXI data in any format needed for the scripts. The data will hopefully be accessible through a user friendly query display I'm trying to put together.
|
|
|
|
Post by dragondude on Dec 31, 2005 18:15:59 GMT -5
Ohhh, ok... "Those colored boxes are a nice substitution for the image problems. That probably wasn't too hard to do either. I bet those colored boxes are more informative than having all white boxes... lol " That was a big step for me  it was easy but i was proud O.O |
|
nebula
Junior Member
fear.
Posts: 59
|
Post by nebula on Dec 31, 2005 18:16:22 GMT -5
you realize to read a mysql (in caps its MySQL btw) you need to have the server installed? and to read it from a php script, they'd need php installed, too?
|
|
|
|
Post by X-Drop on Dec 31, 2005 19:50:50 GMT -5
MySQL... gotcha^^ And yes I have both the Apache server and PHP installed. But like I said, what I'm doing is only useful as a developers tool perhaps. I still like the idea of eventually having Lunar support SQLite. And even if we eventually get SQLite, who is gonna compile all the FFXI data for it? Alls I'm doing is trying to take the first step here. |
|
nebula
Junior Member
fear.
Posts: 59
|
Post by nebula on Jan 1, 2006 1:05:08 GMT -5
what all are you putting into a db?
|
|
|
|
Post by X-Drop on Jan 11, 2006 19:03:57 GMT -5
Just an update, the Aggro Check script is complete. Just gonna wait for the new version of Lunar before I release it. I wanna add in the function to auto-check the area of the player and then I can call it a wrap.
|
|
|
|
Post by ashrian on Jan 31, 2006 15:28:19 GMT -5
I'm a L.A.M.P. engineer, and have worked with Perl for quite some time now.
If you need a script to crawl some databases on Allak or Somepage, let me know. I'll get to it asap. Mind you, scripting reg-ex patterns to parse HTML on a per-page basis is difficult, so it may take some time.
|
|
|
|
Post by X-Drop on Jan 31, 2006 16:00:38 GMT -5
Thanks for the offer, Ashrian. I never messed with Perl but someone pointed me to PHP and MySQL back in December. And I'm really glad they did! I was actually writing this mob database by hand at first. After I wrote the PHP script with regex, I was amazed to see the database come together within a mere 20 seconds. FFXI Mob databaseI have another copy of this database with all the minor errors fixed and some additional fields, but the old one is still posted. I'll post the newer db when I released the Aggro Check script. |
|
it was easy but i was proud O.O
