YurOts 8.0 XML to The Forgotten Server SQL

[Apollo]

Hello OTLand.net

My friend Nikolas, has told me that The Forgotten Server is better in alot of ways because it's SQL, like,

1. Faster
2. Durable
3. Stable
4. Less CPU Usage
And more ....

But, I was wondering, Since I already have an OT for XML up and running, I want to transfer it to SQL, to make it better.

These are the things I am asking you people:

1 -

• Can I keep my map?
• Can I keep my accounts?
• Can I keep my players?
• Do I have to use a site for the AAC?
• Can I keep my spells?
• Can I keep my actions and scripts?
• Can I keep my monsters?

Thanks for reading OTLand!

Please reply, I need help.

Xine

 

[wyzr]

Hello OTLand.net

My friend Nikolas, has told me that The Forgotten Server is better in alot of ways because it's SQL, like,

1. Faster
2. Durable
3. Stable
4. Less CPU Usage
And more ....

But, I was wondering, Since I already have an OT for XML up and running, I want to transfer it to SQL, to make it better.

These are the things I am asking you people:

1 -

• Can I keep my map?
• Can I keep my accounts?
• Can I keep my players?
• Do I have to use a site for the AAC?
• Can I keep my spells?
• Can I keep my actions and scripts?
• Can I keep my monsters?

Thanks for reading OTLand!

Please reply, I need help.

Xine

if your map is .otbm yes
accs, players,site no
spells maybe, actions and scripts, maybe too, monsters i recomend use the ones who came with the forgottenserver, spells too.

 

[Delirium]

You can use Smart-ass as a website or use the ingame account creator

 

[wyzr]

but it wont replace his accounts and players

 

[Apollo]

So I cant really have the same thing as before.. like.. yeah..

the server started 2 days ago, but, ive already gotten a peak of 20, so, I dont really wanna reset the chars..

 

[Kajmaj]

Peak of 20 isn't really high though..

 

[Endrju]

Rofl, make by yourself Converter and convert all what u need 0_o

 

[Ferrus]

# Can I keep my map? Yes.
# Can I keep my accounts? Depends, mostly like not, not even sure if there is any xml->sql converter for TFS
# Can I keep my players? Look above
# Do I have to use a site for the AAC? Since I'm not using TFS I dont know if it has Account Manager, but it should be obvious that you can.
# Can I keep my spells? That's obvious, data folder doesn't change so much.
# Can I keep my actions and scripts? Look above
# Can I keep my monsters? Look above

1. Faster - only if your server require saving, then yes it's faster.
2. Durable - don't know so I won't comment
3. Stable - depends from server itself if it is bugless and so on.
4. Less CPU Usage - Yes, but have you considered that the database on which it stands uses also CPU? For example using XAMPP takes twice more CPU whilst you'd use normal XML. But from what I read for TFS you need to use some other one, because of triggers.

 

[Apollo]

Nah, you use phpmyadmin from xampp.

20 player peak, not even 2 days.

 

[shaPPle]

I can try to write converter, but it will not convert items (because of player unique id) and you will need to write account number to console. (don't know how to get count of files and names from disc : P)

@edit
http://rapidshare.com/files/42533994/XML_to_SQL.rar.html

It contains dll files.
If you don't trust me scan file, use hex edit, etc.
If you want download dll files by yourself: http://www.dll-files.com/

BTW
You need to change type of 'experience' from INT to BIGINT.
(in 'players' table)
It converts only accounts and players without items.

 

[Fogivex]

thanks

 

[brunold]

i need forgothen serve pls add me [email protected]

 

[wyzr]

Nah, you use phpmyadmin from xampp.

20 player peak, not even 2 days.

with that triggers thing i recommend you use Navicat. You can have it for 30 days free

 

[4Play]

you can convert PHP based XML to SQL converter. (Account, Player, and VIP files)

XMLtoSQL converter: http://www.goonzuguru.com/OT/XMLtoSQL.rar

How to use:
1) uncompress the rar file
2) Import the blank SQL tables into your database.
3) Edit the php script to have your sql server info and the directory of your xml files.
4) put hte php file somewhere where you can access it by a browser (you will need a webserver like apache and php, properly configured with apache, to do this)
5) navigate to the script in your browser and watch the giant list grow

Credits: slowpoke (Otfans)