Page 1 of 1

Database from Xaseco to eXpansion

Posted: 12 Aug 2014, 21:29
by hackie
Hi

I found this in the tools directory :

// STEP 1

Create a Webservices account for Maniaplanet.
Go to http://player.manaiplanet.com and log in with your credentials.
Go to Advanced->Web Services
Click on Create API user
Fill in a identifier: for example migration (This will create a API username LOGIN|Identifier, for example in my case weerwolf|migration)
Click on validate
Set a password and click on validate
Your maniaplanet webservices account is created

// STEP 2
Edit the required data in xaseco_migration.ini

// STEP 3
Excecute the xaseco_migration script by opening a shell and type: php xaseco_migration.php

U will get some notigication and warning; u are asked to proceed DO IT and hitting enter.

The process will start migrating teh data to the eXpansion database. Please do not interrupt this process. If the process is interrupted, clean the new database, and start over.

// STEP 4

Excecute the nations update script by opening a shell and type: php update_players_nations.php
The webservices account allows u to query date from Nadeo at max 600 times every hour.
This script will process 500 logins at one run.
If the data base is bigger then 500 players, u will need to run it, wait until the next hour and run again.
Repeat this until all logins in the database are processed.


I made it to step 3 , cause there was a windows batch file to run xaseco_migration.bat

But step 4 there is no windows batch file so how to run update_players_nations.php ?

So with a database of 5100 players I have to run it 11 times ( 11 hours in total ) ?

Re: Database from Xaseco to eXpansion

Posted: 12 Aug 2014, 22:31
by oliverde8
hey,

well you can copy the xaseco_migration.bat and replace xaseco_migration.php in it by update_players_nations.php

The last step isn't necessary, it works without it as well but you won't have all the country statistics working properly. Actually even that might work. That script updates totally the players database from the MP api.

Re: Database from Xaseco to eXpansion

Posted: 16 Aug 2014, 10:16
by hackie
Ok , once again I failed big.

The script starts and does his thiongs but the database is somehow not right.

uhm , I'm thinking about a wrong configuration.

from .ini file :

; Databaseserver
host = "127.0.0.1"
port = "3306"

; Enter Xaseco databasename and password
login = ""
password = ""

; Enter eXpansion databasename and password
xaseco_db = ""
exp_db = ""

; Enter the login of your gameserver
transaction_toLogin = ""

; Enter the username and password of your Webservices account
webservices_account = ""
webservices_password = ""


Under section "Enter Xaseco database name .... "
Here I put my login for Xampp to get connected to database.

Under section "Enter eXpansion ... "

Wrong title ? Database and pasword ?

I put there name of xaseco databse and name of expansion database.

I made a screen shot , running script :


Image


What do I do wrong ?

Re: Database from Xaseco to eXpansion

Posted: 17 Aug 2014, 08:50
by oliverde8
Hi, you must migrate your xaseco database into an empty expansion database. If you only have a few of those errors it shouldn't affect expansion to much

Re: Database from Xaseco to eXpansion

Posted: 17 Aug 2014, 10:35
by hackie
Thanks for responce.

No succes , I gave up.

I go from 20mb database to 5 mb database.

Only some times are getting transported futher nothing.

I tried , I failed . Thanks anyway.