Final Fantasy XI (Online) Private Server files

searching throne room script!

Well, I loved FFXI, but it took forever for a few things (like leveling XD I had too much of a life ;p I could never finish the story lines because of it). I'm downloading things now and if I can get it to work that'd be great. =p One question, is it possible to make your own items? Also, while I'm still kinda beginner at it, I can kinda program, so if we want to get something going again, that'd be cool. lol

Quote:

Originally Posted by ge0h0und Yeah I do recall you, if you're the same bababooey, working on the food effects. Then some other people were working on missions and quests.

I am. I also did a handful of quest scripts in Norg and the surrounding areas. I've been following these forums and some others from afar since the project was shutdown in hopes of someone picking it back up.

I was having problems changing the database in char_job from 126 to something that would unlock all jobs before. Today I realized how retarded I really am. All I had to do was put in 1048575, which is used widely throughout the database as the number for all jobs. So I'm still a noob. You gotta start somewhere! Hope this helps someone, but what would be better is if someone could script ALL of the advanced job quests, that would be impressive! :D :D :D

EDIT - There is a job missing when you enter 1048575 into char_jobs -> unlocked. It doesn't show Scholar for some reason >_> ah well, 19 is better than 6!

Oh yah, I was also wondering... when I craft it seems to be broken. I remember getting a lot of breaks in the real game, but it's insane on here. I think it needs to be tweaked a little. The only time the break/make ratio seems right was when I was level 1. The higher you go, the worse it gets. It shouldn't take 30 tries to craft a Vermillion's Cloak. Um, also I noticed I could get skill for level 1 items at level 23. I don't think that's right either. I don't know how to fix these things, or I would. Because it sucks!!! Also, it never shows "Your Clothcraft skill has increased to level 2!" After the initial level 1. Instead, you get skill and it never let's you know, unless you check in the menu. I also tried to craft using a signature with Terra crystal and that does not work either. What's the point of crafting if you can't sign stuff? Heh. I can just pop out a HQ Royal Cloak and be done with it, I just thought it'd be sweet to have it signed.

Also if anyone wants to share some scripts :D :D :D

Mobs don't wander for some reason, I believe I've seen that before...

I can't equip anything but weapons, and the weapons don't have a model.

Pets don't work, I assume that's intentional :p

Yeah, more scripts would be nice, for the remaining spells and other things (like Poison II and beyond, for example).

Quote:

Originally Posted by Crevox Mobs don't wander for some reason, I believe I've seen that before... I can't equip anything but weapons, and the weapons don't have a model. Pets don't work, I assume that's intentional :p Yeah, more scripts would be nice, for the remaining spells and other things (like Poison II and beyond, for example).

You should be able to equip armor too... and wow... sounds like you have issues. I'd make a new database and try to reload the pxidb.sql file again. I read that sometimes when you load a database so large, things can get pretty screwed up, especially with a slower computer. Mobs don't wonder on mine either, and you can't summon either. But you should have weapons and armor that work.

Other than that, it sounds like your version is very similar to mine. I can send you a copy of the SQL I modified slightly. There maybe some stuff changed in it, but feel free to change it back to where it's supposed to be. I had a lot of problems loading the database that came with this version, so once I got it working, I saved it. I'm using HeidiSQL but I don't think that's really relevant. It's just handy to know whether or not you need to change which database it's going to overwrite before you execute it on Heidi.

Hello I have read through the forum and I needed some help. I've been trying to get pxi to work for a few weeks now messing with it here and there. i'm running windows 7, mysql 5.1, sqlyog, various combinations of pxi and mxi. One of the main probs i'm having is i don't understand how to fully load the game. I have followed the instructions to the best of my knowledge. I install mysql, set it up and inport the database using sqlyog. I installed the game and all current expansions up to WOG. i started playonline and and updated the files. i do not currently have a content id nor will i be able to access one for about 6 months so i am trying to set it up so i can play while i cannot connect.

Quote:

Originally Posted by Codiddle You should be able to equip armor too... and wow... sounds like you have issues. I'd make a new database and try to reload the pxidb.sql file again. I read that sometimes when you load a database so large, things can get pretty screwed up, especially with a slower computer. Mobs don't wonder on mine either, and you can't summon either. But you should have weapons and armor that work. Other than that, it sounds like your version is very similar to mine. I can send you a copy of the SQL I modified slightly. There maybe some stuff changed in it, but feel free to change it back to where it's supposed to be. I had a lot of problems loading the database that came with this version, so once I got it working, I saved it. I'm using HeidiSQL but I don't think that's really relevant. It's just handy to know whether or not you need to change which database it's going to overwrite before you execute it on Heidi.

Meh, I can try again. My computer isn't exactly slow (3.4ghz quad) so I don't think that's the issue. There's like 5 different DB files without any clear indication as to what should be run, though. :P I ended up just doing pxidb.sql in the misc folder, then the 3-26-10.sql, then the two update zone settings files (without those two, many errors and NPCs don't work at all). There's another pxidb.sql file in the initial folder I haven't tried, and who knows what else.

If you have a better working DB file, I welcome it.

Quote:

Originally Posted by Codiddle I found a fix for mXI-0.9.0RC I'm pretty sure this time... I was lucky to get it to work before, I don't know what I did, but it broke so it really doesn't matter now. I think this will work 100%. First step, set it to run as administrator. Set up the Client.ini file so that it logs you in automatically. This is important, another thing is that you cannot click outside of the windower while it's up, which really if you think about it defeats the purpose, in most situations. I went into Windower the newest version I think is 3.42. The readme said 3.41 but I think that is the incorrect version. Moving along... I copied the file called init.txt from the scripts folder and pasted it inside of mXI-0.9.0RC's scripts folder and overwrote the old one. Then I opened it with notepad and changed the settings so that plugins do not load, except since then I've found that some plugins work, TParty, ConsoleBG for sure. I was too excited to test out the rest. Just add //load (nameofplugin) Those two slashes will prevent them from loading. Anyhow, next you got back to the Windower directory, and copy the Hook.dll file and paste it into the mXI-0.9.0RC directory and overwrite the one that's there. That's it. Have fun with your scripts. I'm working on scripting zones so that all you have to type is the zone name. I did this before pXI's site shutdown, but since then I've lost those files. Heh.

I've been using meteorXI 0.9.0RC without any issues from the beginning... there was an issue with using it?

Anyway, I tried using the other DB file and I can equip stuff now... however, the DB file is half the size and some things don't work. An example of this is Claustrum. I can equip weapons with both DB files, and with the bigger one it allows use of Tartarus Gate. With the smaller one that allows me to equip everything, Tartarus Gate does not exist.

I am at a loss...

Also, is there a way to just give yourself all spells besides just using @addspell for every number? How about weapon skills?

EDIT: The bigger file can't equip stuff probably because the column structure is different. :p It has a lot more added on (stats and stuff) and is more updated...

Quote:

Originally Posted by crashoverride17 Hello I have read through the forum and I needed some help. I've been trying to get pxi to work for a few weeks now messing with it here and there. i'm running windows 7, mysql 5.1, sqlyog, various combinations of pxi and mxi. One of the main probs i'm having is i don't understand how to fully load the game. I have followed the instructions to the best of my knowledge. I install mysql, set it up and inport the database using sqlyog. I installed the game and all current expansions up to WOG. i started playonline and and updated the files. i do not currently have a content id nor will i be able to access one for about 6 months so i am trying to set it up so i can play while i cannot connect.

Ok, this is probably a simple problem.
First of all, I want to say that I uploaded a zip file on page 20 that has files you can copy to your PlayOnline directory. Also, there is a little tool there that will break some FFXI files so it will be updatable.
You sound like you're doing it all right. Make sure MXI runs as administrator since you're running Windows 7. If you've updated it with discs, you still have to update it online. What I did was copy over some updated files from like 2008 or something I found on this website. Then I opened POL and used Check files. It finally was able to detect FFXI as "unknown version" so I updated but that still didn't work. Next I found this nifty tool called "update.bat" which has been proven to be a little difficult to find. It will break your one of your FFXI files so that they're actually updatable. BUT if you're running a 64 bit operating system, you have to right click the .bat file and change the directory so that it's directed toward (x86), instead of just plain old "Program Files." I'm unsure which file it breaks. Then when you reopen POL and select Check Files, it should list FFXI I think as unknown still. But check it, it'll find the broken file and then you have to "Fix Files." After that, it'll connect and recheck the files online, then it should update, which could take 30 min to 6+ hours. That just depends on how new the files you dumped in the Square Enix folder initially. I saved all of mine to a seperate drive from an update so it doesn't take mine so long anymore. Also, there was something else. Make sure you run pxi7.1 to start off, because it seems to work more often than 9.0. Although I think I fixed it fo realz this time. Oh right, you probably read this already, but when you install POL select that you have an existing account or whatever I think it says "For Members." Add a member named 12345678 and make the ID 12345678. I just used my original POL account info, I don't think it really matters either way. Hope this helps.

Quote:

I've been using meteorXI 0.9.0RC without any issues from the beginning... there was an issue with using it? Anyway, I tried using the other DB file and I can equip stuff now... however, the DB file is half the size and some things don't work. An example of this is Claustrum. I can equip weapons with both DB files, and with the bigger one it allows use of Tartarus Gate. With the smaller one that allows me to equip everything, Tartarus Gate does not exist. I am at a loss... Also, is there a way to just give yourself all spells besides just using @addspell for every number? How about weapon skills?

Well, if you want to load windower scripts, you have to run it under "Windower Mode" which did not work for me. I could mXI9.0RC as "No Windower" or "Windower Lite" which doesn't run scripted macros.
Which brings me to the last question you asked.
There are 2 ways. You can use the Windower inside 9.0RC to script them all into 1 text file. Or, there is a code you can plugin to the database. I posted in about 2 pages back, it's a very long number and hard to miss, lots of 0's.
Um, weapons skills, you'll have to @addskill on those, scripting them in a scripted macro is ideal. It'd be easier than editing something in the database for it.
Sounds like you have a beast computer. The only database files I have for the latest PXI SVN are pxidb.sql, pxiah.sql, update_zone_settings012110.txt, and update_zone_settings020210.sql. I dunno why the 012110 was a txt. I'm curious as to whether it's the march addition that's messing stuff up. I mean, I had errors too, but after trying a few things, it all seemed to come together. My computer is just 2.0Ghz dual AMD Turion hp laptop. So I'm blaming my errors on that haha.

Oh yah my DB is 7.5 MB. But when I export it, it's 7.5 too... and stuff is missing when I reload it. It's weird because the original pxidb.sql is 13MB or so. I'll try to export it again tomorrow.

The pxidb.sql that I have is 27mb... can't remember where I found it, but it's dated 10/9/2009 with TONS of stuff... I can't use equipment because of the updated column structures.

I'm going to upload my newest sqldb file soon it has the best of both the newer 0.6.5 and the old 0.6.4 material

boats should work (and barges)
new equipment
updated zones
more spells work (from 0.6.5 db)
npcs should exsist

Quote:

Originally Posted by Tom_Neverwinter I'm going to upload my newest sqldb file soon it has the best of both the newer 0.6.5 and the old 0.6.4 material boats should work (and barges) new equipment updated zones more spells work (from 0.6.5 db) npcs should exsist

Oh, nice. Does this mean equipment will work as well?