how to make database with php5.3

[Knutselmaaster]

Install 2 versions, point the path for xaseco to one and manialive to the other one.

[jouko200]

Install 2 versions, point the path for xaseco to one and manialive to the other one.

sounds good... only think what i have not tried ( 5 times image restore)

is it possible use commands localhost:3306 for xaseco and localhost 307 for manialive or can they use same
database

Paragon backup and recovery is my friend

[nocturne]

MySQL is MySQL.. v5 is pretty much the standard, and there's no possible excuse to need to install multiple versions of it. Again, your confusion over that necessitates me requesting that you look over a few basic webserver guides before proceeding further. A quick basic explanation of Apache, MySQL, and PHP and what they are used for can be found on the wikipedia page for LAMP: http://en.wikipedia.org/wiki/LAMP_(software_bundle)

You should never have any problems importing a properly formatted SQL file into a MySQL install, though it pretty much depends on your level of experience. If using PHPMyAdmin (bleh.. despise it myself), you shouldn't have any issues importing the standard SQL file distributed with Xaseco, though if you are trying to transfer a backed up DB you'll only run into problems if it's larger than a few megabytes. In that case it's best to log into the mysql backend and load the SQL file directly -- I'd explain it, but a simple google search would suffice. If that proves too much of a daunting task, you could try a GUI implementation of mysqladmin such as Navicat or HeidiSQL -- though the setup of those programs is in no way easier than running a few commands from the command prompt. If your problem is using multiple DB's (no idea why -- only ML plugin that uses MySQL that I can think of is MLEPP, which would negate the need for Xaseco), you'd do well to read up on MySQL a bit.

Your confusion about MySQL aside, I could swear that your issue resides with PHP v5.2 vs v5.3 compatibility -- though by several accounts I could have sworn that xaseco is v5.3 compatible (besides a deprecated function or two). Though if necessary to have two different installs of PHP, it can't be easier in windows -- just keep them in different directories, and specify the desired PHP path in your start script. Here's a zip of v5.3 to get you started: http://www.multiupload.com/YFUMXLVD68

[Knutselmaaster]

Xaseco is php 5.3 compatible indeed.
I ran it on several servers without any problem.

[jouko200]

many people have xaseco with old version with xampp.I think we need good install insructions for that situation.

[TheM]

many people have xaseco with old version with xampp.I think we need good install insructions for that situation.

Because? XAMPP is still working the same... PHP is just a new version, same goes for MySQL.

[jouko200]

Your confusion about MySQL aside, I could swear that your issue resides with PHP v5.2 vs v5.3 compatibility -- though by several accounts I could have sworn that xaseco is v5.3 compatible (besides a deprecated function or two). Though if necessary to have two different installs of PHP, it can't be easier in windows -- just keep them in different directories, and specify the desired PHP path in your start script. Here's a zip of v5.3 to get you started: http://www.multiupload.com/YFUMXLVD68

that was first think what i did... xaseco stopped working

[jouko200]

You should never have any problems importing a properly formatted SQL file into a MySQL install, though it pretty much depends on your level of experience. If using PHPMyAdmin (bleh.. despise it myself), you shouldn't have any issues importing the standard SQL file distributed with Xaseco, though if you are trying to transfer a backed up DB you'll only run into problems if it's larger than a few megabytes. In that case it's best to log into the mysql backend and load the SQL file directly -- I'd explain it, but a simple google search would suffice. If that proves too much of a daunting task, you could try a GUI implementation of mysqladmin such as Navicat or HeidiSQL -- though the setup of those programs is in no way easier than running a few commands from the command prompt. If your problem is using multiple DB's (no idea why -- only ML plugin that uses MySQL that I can think of is MLEPP, which would negate the need for Xaseco), you'd do well to read up on MySQL a bit.

do u think i lie when i say there are errors when importing normal xaseco sql files. ofcourse they are possible to solve but i think it is xaseco problem

[jouko200]

MySQL is MySQL.. v5 is pretty much the standard, and there's no possible excuse to need to install multiple versions of it. Again, your confusion over that necessitates me requesting that you look over a few basic webserver guides before proceeding further. A quick basic explanation of Apache, MySQL, and PHP and what they are used for can be found on the wikipedia page for LAMP: http://en.wikipedia.org/wiki/LAMP_(software_bundle)

thx for people who made good install instructions for xaseco

example
1) Download ASECO, and install/unzip it to a folder of your choice (preferably in a new folder within your Trackmania directory)

2) Download Xampp and install it to the default folder (Program Files, unless you know what you're doing). Install all options (Apache, Mysql are the most important ones). Once the installation is finished, the Xampp Control Box should open, but close it for now.

3) Now we have to configure Aseco.
Go to your ASECO folder, and right-click on Aseco.bat, then click on Edit. The file should open in wordpad or notepad.
Where it says set INSTPHP=C:\Programme\Apache2\Php5 change the location to C:/Program Files/xampp/php (Unless you didn't install Xampp in the default directory). Now save and exit.

Now right-click on the file config.xml, and Edit. There's a lot of things you can change and customize here, but I'll only explain the ones necessary to get your aseco server running (for further information check the ReadMe.pdf file).
Find the <tmserver> part and set your login and password to the ones in your dedicated server's config. Also make sure your IP and port (usually 5000) are correct (Normally, you don't need to change this). Remember that 127.0.0.1 is the same as localhost (The dedicated server is hosted on your pc).
After you're happy with your config, save and exit.

Again, right-click and Edit the file plugins.xml. Right before the final line (</aseco_plugins>) enter a space and add the following line: <plugin>plugin.localdatabase.php</plugin>
Save and exit.

One last file to edit, open localdatabase.xml. Set your mysql login and password (We haven't really created our mysql "account" yet, but we will soon when we configure it). set your databasename (<mysql_database>) to aseco. Then change <display> from false to true.
The file should look like this
<?xml version="1.0" encoding="utf-8" ?>
<settings>
<!-- MySQL Server Settings -->
<mysql_server>localhost</mysql_server>
<mysql_login>MyCrazyLogin</mysql_login>
<mysql_password>MyCrazyPassword</mysql_password>
<mysql_database>aseco</mysql_database>
<!-- Do you want Aseco to display the records? -->
<display>true</display>
</settings>
(Remember that 127.0.0.1 = localhost)
Now save and exit.

4) And now the "complicated" part. Let's configure our local database.
First go to the following folder in your hard drive: C:/Program Files/Xampp/mysql/bin (Unless you installed Xampp in a different directory) and open winmysqladmin.exe. Set your login and password to the ones you selected when configuring localdatabase.xml (MyCrazyLogin, in the example).
Then once you created your mysql "account" you can just close the program.

Now open your Xampp Control Pannel to make sure all the necessary database applets are running (You can run it from your start menu).
Open a browser window (Internet Explorer, firefox, etc) and enter the address: http://localhost (Or just click here!)
You will have entered your Xampp control board. In the navigation menu on your left, click on the PHPmyadmin link.
When the page loads, notice there's a space below "Create new Database". Type aseco and click on Create.
Now find the button that says import (It's in the upper menu bar), then click on Browse.... There's a file in the /Aseco/localdb directory, called aseco.sql, select it. Ignore all the options you're given, and click on Continue.
If everything worked well, you should see a long paragraph of code, and a message confirming that the data was added successfully. If that doesn't happen and a line saying that there was an error, just go back and try again (Trying again worked for me, can't explain why exactly).


5) Now it's time to run aseco. First start your dedicated server (You can also use ServerMania if you want). Once it's ready, go to your ASECO directory and run Aseco.bat. Aseco should be able to find your server and "attach", unless you inserted the wrong IP or ports (I use 5225 instead of the default 5000, for example). If aseco can find your server, then you should see the line (ASECO) Connection established successfully!. Then aseco will try to connect to your local database (The one you created with Xampp). If everything goes well, aseco will be running on your server.

I hope this can be useful to somebody!

[Knutselmaaster]

Well, if you have a problem with xaseco, what are you doing here in the manialive forums?
Go to the xaseco forums.
Still, the problem is not Xaseco, nor php 5.3, it is something that you do wrong....
What are the errors you get?