Sorry for quate myself. but i really wish some one would answer my questions. i really appreciate it. thanks...

Thanks so much for the help Codiddle, but it only half helped solve my problem. Now I can get the MXI login box to display the first line of yellow text, from what its saying I have to have my PXI box turned on so I double click PXI and it come's up with the exact same writing as before ?

So thank you for your help and if anyone could let me know how to get past this current problem I'd be very grateful.


*EDIT* Okay im also a little confused on what to do with MySQL and SQLyog I added the pxidb to the list on the left............then what. As no guide I've read actually explains what I do with it, leave SQLyog open or do I push on it somewhere to start it or is it suppose to be done when I click on that little box in SQLyog ?

*EDIT EDIT* Alright solved the server problem its up and running fine now thanks Codiddle.

Unfortunatly I still have one minor issue, I can get onto the server to play but no one else can anyone know a way round this ?

First off you need to check out your firewall and make sure you have the right ports open for the project, that could be an easy way people are unable to connect. Another thing you need to do is make sure people trying to log into your server are using your external IP address not the internal one or the local 127..etc etc. When they get your external address they have to change the Client.ini in their FFXI folder to your IP, that way when they start meteorXI it connect directly to your server.


Now I have one big problem with this thread and its the misinformation about MXI.
Now pay attention to this.......when logging into your private server, or any server....YOU DO NOT NEED TO CLICK, LOG ON OR PUT DATA OF ANY KIND INTO PLAY ONLINE OR THE LAUNCHER.
You only need the PoL launcher to update your client for one step you don't need to do anything with it after that other than transfer the data folder over into your FFXI folder for meteor.

The only thing that SQYLog does is configure and set up the "Service" for your database. You can close it, as long as your Mysql service is running "and you can check this under your task manager and services list" as long as thats running you're fine. If you want to have an easier time at configuring your database and creating characters or accounts Navcat has a much easier system.

Lets put this whole scenario into a Graph sorta.


MeteorXI----->PXI------>YourServer------->FFXI

FFXI--------->PXI-------->YourServer-------->MeteorXI

Noting in any of these connections links you to SE or anywhere else other than your server. I hope that made things....a bit more clear.:bandit:

99% of the food effects were working as of the final SVN. If they're not working with the last SVN and the current FFXI update it's reasonable to believe the mechanism (in the source or the database) was broken due to an FFXI update.

Error
 

First off it's not the black screen error

I am having a "notifying lobby of current selections" problem
it spits out FFXI-3113 after a few minutes

This error comes up after creating a character,
any help greatly appreciated!
Thanks in advance


Update: NVM bad db file the pxi client had no problem with it but the mxi client crashes

NVM for answering my question. I figure it out. :rolleyes: this actually need an ID to play it. I downloaded the files here and read up the guide. will this really is a bad information for me. There is actually not a real Emulating game for FFXI but just a model or a private server thing.

I was actually thinking that there is a actual solo plays off line with out POL playing FFXI like other final fantasy games I played. I guess you have to pay to play. will thanks for nothing. :mad:

anyone still working on this?

yes... mostly?
 

you do not have to pay to play!!!
everything minus a working db file is here:
[Only registered and activated users can see links. Click Here To Register...]
it has the update file and multiple versions of mxi + pxi


I'm still "working on it for myself" but I may leak a few here and there


Updated files:
Made them a lot better, Many of my changes are included
I made a guide for people having issues with mxi 0.9.0Rc1
added effects to the 0.6.4 server folder but not to the db, looking for a more time effective method to add it all

Updated: 08/29/2010
Ok all the transports should now work; boats, airships, barges
Spells should work
Effects have been added (Although may not actually work unless run on 0.6.5
Traits have been added (also probably a 0.6.5 thing)

Server can now be run portably
updated sqlyog

Mxi 0.9.0 changed slightly


Please upload your edits, I'd die for any solutions to any of the problems.... especially to 0.6.5 and the db

Thank you everyone for your hard work

did you add stuff yourself Tom? if so, may i ask what? good work btw!

I would suggest you go back to page one read everything all over again, try the 6.4 version as well as the database and rethink that comment.

I think the problem is actually within the coding of the 6.5 version itself, and the damn mob tables got screwy somehow.
A friend of mine who showed me the 6.5 effects etc has all spells working and mobs appear on the map. The only trouble im having is with the zone settings table for 6.5 and merging it with my current database without having to literally input the entire damn thing.
I dunno maybe I should try recompiling the damn thing and seeing if something glitched....no idea.
But I have a 6.4 server with mobs and spells but no active spell icons like buffs etc and alot of spells dont work.
And the 6.5 has all fully working spells but no npcs and no mobs<--------gotta be a problem with the database I'm still working out the kinks, but once I can get that npc and mob problem fixed I'll have a more general pallet to work with as far as testing and making new scripts.

Wow, sounds like your keeping this alive! You should make your server semi-public or something! :P

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 may take some programming classes in the future and perhaps take a gander at this when I understand it more.

I still don't understand why there's so little interest in regards to server emulation for this game.

Anyways for people having MeteorXI issues download the file I uploaded in a post two or three pages back. It has nearly all MXI versions.

Also, Good luck Regicide. I'm glad to see people still interested in the project.

I tried version 6.2 pxi and it works but couldn't get pass the part after selected nation and was sending information to the server. Also version 6.4 pxi couldn't get connect to MYSQL. So I couldn't use that version.

Reply
 

Drakong, or whatever your name was, I'm reading your posts and I don't understand what the problem you're having is. It sounds like your FFXI isn't updated though. There is a small "Update.bat" file you can find in a zip file somewhere on this site. It'll break 1 file in POL and FFXI so you're able to update the game without purchasing a content ID. You simple enter 12345678 as the account name and 12345678 as the ID. Then you click "Check Files" When that's done, you "Fix Files." If you're running 0.6.4 you have to have the game updated as much as possible. I doubt this is what the problem is though, because you mentioned you recently turned your account back, and if you logged into FFXI at all, it would've made you update it.

Either that or your MySQL isn't configured correctly. Maybe you haven't loaded the database into MySQL?

Actually, if you have 0.6.2 running, then you CANNOT use the same database that came with that version to run 0.6.4. It's COMPLETELY different and to get that to work, you'd have to create an addition database using a database editor, e.g. SQLyog or HeidiSQL, and name it "pxidb2" or something similar that is not the same name of the database you're using for 0.6.2, then change the pxi.ini files to pull the information from the new database. What I did to make sure it went into the correct database was edit the "pxidb.sql" and at the top where it says "pxidb" I changed it to "pxidb2." Make sure you load pxidb.sql to the database, because that's where all of the table information is stored. Regicide did a good thing by mapping it out, because that was my first problem was understanding how it all worked, when I first started trying to run this stuff. I hope this solves your problem.

Another reason MySQL could not be working is that you do not have the file called "pxi.ini" in the file directory. If you do not, then check in all of the other folders. It can also be called "pxi.ini.sample." All you have to do is copy it, then paste it to the folder that pxi-server0.6.4.exe is in, then change the information inside the file to match your database. If it is named "pxi.ini.sample" you'll have to rename it so that it reads "pxi.ini".

Also, I was wondering about some things in the database. On the newer version I'm running, where buffs (e.g. Haste, Refresh...) work, the mobs don't entirely... but they do aggro, they just don't roam. It's kind of nice because they don't walk through the walls when you run up to fight them. Another thing I noticed you can't change the stats on armor or weapons like you could on a different version I compiled. Is there any other way I can do that? I wonder if adding columns to "Stats_Armor" would work? I wouldn't think so. That's really all I'm curious about right now. I also have the long string of numbers that goes into "chars" tables, under the "spells" column that adds all of the spells.
0xFEF7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF FFFFFFFFFFFF3F000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000
First you have to create the character. Exit the game, then edit the database.

I hope youre using POL utilities to find your hex values as well as your item id's. I believe most of the stuff used for the GM commands can also be pulled by translating the decimal value in the pol ids to a hex value. Which will help out with what you're trying to do immensely. For ex.

FFXI data browser--->String Tables---->English--->Key Items---->
Decimal value for Chocobo License is 01389 convert it to hex for @addkeyitem command and you get 56D
@addkeyitem 56D and you get a nice chocobo licence in your inventory.

POL utils should be like your bible and used vigorously.
Another thing that pol utils helps out with is adding quests to npc scripts. It would be kinda hard to write quests from scratch but you could easily direct a multitude of quests at one npc if you wanted.
The quest system in FFXI is not complicated at all, and most of it is a series of Take away key item from player give key item to player Give new quest to player (insert Hex or decimal value) etc etc. Not hard at all once you understand what the scripts are doing.

On another note....anybody wanna continue this project with whats left on a mibbit or something? I dunno if zero still has his up but last i checked the official mibbit was dead lol.

Thanks Reg, I did not know that. I'll definitely look into it. For some reason, I always hated running that tool, but I thought it was "just" a model viewer. lol. I'll check it out right now.

*I went back and look up a newer version of the files that was recently uploaded in here and downloaded. I think I must cross version to not make it to work. Now MYSQL version 6 and PXI 6.4 and MXI 7 works together. I finally got it to work. Thanks for the info. I had to mess with it for like couple hours to get it to work. Sweet!!! kind of glichy though...

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

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.

Database tweaks
 

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).

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.

Newbie
 

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.

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.

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...

Re: Re: Really?
 

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.

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.

updates soon
 

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?

Sweet, good to hear it. Another thing I'm curious of, is whether or not mobs move around. It's not a big deal if they do not, but either way, I'll thank ye for it.

I made a zip file including
-pXI_scripts_r2177
-pXI_server_r1430
-meteorXI-0.9.0RC1 modified to function properly.
-ffxiupdate.bat (2 versions, modified to work on 64bit and x86)
-Tom Neverwinter's Update folder, which I have not tested.
also there's a few text files with some crappy instructions.
I also forgot the hex/decimal/binary converter I said I included hah. oh well.
[Only registered and activated users can see links. Click Here To Register...]

yay! :D

EDIT: I have a problem, i do everything right but then when i login to MXI, i get "MXI has stopped responding and must close" window. what am i doing wrong?

Skip ahead a little, I uploaded a mXIv0.9.0RC1 that doesn't crash, even with scripts loaded.

I just uploaded my current build, (I forgot what I compiled to spit out this version, I was trying many different things).
Please do not separate Mysql.bat from the other files, or rename the folder. This will cause it not to work. An alternative would be making a shortcut to it.
This zip also has an executable mysql.bat which already has a working database on it.
If you want to try it on your build, the username is root, the password is ascent. Plug that information into your pxi.ini file.
Yes, this was taken from a wow emulator, I just modified it a little.
But I figured it would be the easiest way for someone to setup a database, just load it, then load Spira.exe, and when it's done, execute my modified mXI0.9.0RC1 and bickety bam! I hope this works. I spent like an hour on it!
Also, remember that 2 instances of MySQL cannot run at the same time. If you setup an instance, I don't remember if that runs constantly or not. If the MySQL.bat file in here doesn't work, then there's probably another one running. Open mysql_stop.bat, then try MySQL.bat.

Oh yeah, link is [Only registered and activated users can see links. Click Here To Register...]

I just erased all of my info, then unzipped it all and it ran just fine. I did notice when I logged in for the first time in San d'Oria, there were no NPC's. But I zoned out to Western Ronfaure and they were all there. I also had to set mXI to run as Administrator in Properties -> Compatibility Tab.

I freakin love you guys. :P Keep up the good work. :D