how to make database with php5.3

Discuss the Dedicated Server Tools developed by Nadeo Live such as ManiaLive, Trust Circles, Dedicated Manager, Competition Manager and Lobbies

Moderator: NADEO

jouko200
Posts: 54
Joined: 04 Mar 2011, 15:05

Re: how to make database with php5.3

Post by jouko200 »

if i install php to diffrent folder and xaseco stop working what did i wrong
User avatar
Knutselmaaster
Posts: 1206
Joined: 15 Jun 2010, 18:03
Location: Somewhere between Paris and Disney in France.
Contact:

Re: how to make database with php5.3

Post by Knutselmaaster »

Knutselmaaster wrote: What are the errors you get?
And, if you just installed in another folder, why would you need to import your database, you can just move it....
jouko200
Posts: 54
Joined: 04 Mar 2011, 15:05

Re: how to make database with php5.3

Post by jouko200 »

i moved to xseco post and and my second pc with xp and cleaned from old xampp... there is image too
nocturne
Posts: 208
Joined: 23 Jun 2010, 21:31

Re: how to make database with php5.3

Post by nocturne »

PHP doesn't 'manage' the database -- MySQL does; PHP just merely accesses it. And if moving PHP to a different path results in xaseco not running.. well, did you remember to set the path in the batch script you use to start xaseco..?

You're just not getting the picture at all, and by this point you seem completely lost. Again, any one of your questions can be answered with a google search, but you really need to get a grasp on the basics before you go any further.
jouko200
Posts: 54
Joined: 04 Mar 2011, 15:05

Re: how to make database with php5.3

Post by jouko200 »

annswer to my sql problem is this' replace type with engine.Thx to merlin and lille

Old aseoc.sql:

Code:
CREATE TABLE IF NOT EXISTS `challenges` (
`Id` mediumint(9) NOT NULL auto_increment,
`Uid` varchar(27) NOT NULL default '',
`Name` varchar(100) NOT NULL default '',
`Author` varchar(30) NOT NULL default '',
`Environment` varchar(10) NOT NULL default '',
PRIMARY KEY (`Id`),
UNIQUE KEY `Uid` (`Uid`)
) TYPE=MyISAM;


http://www.tm-forum.com/viewtopic.php?f ... 49#p192449


new aseco.sql:

Code:
CREATE TABLE IF NOT EXISTS `challenges` (
`Id` mediumint(9) NOT NULL auto_increment,
`Uid` varchar(27) NOT NULL default '',
`Name` varchar(100) NOT NULL default '',
`Author` varchar(30) NOT NULL default '',
`Environment` varchar(10) NOT NULL default '',
PRIMARY KEY (`Id`),
UNIQUE KEY `Uid` (`Uid`)
) ENGINE=MyISAM;
jouko200
Posts: 54
Joined: 04 Mar 2011, 15:05

Re: how to make database with php5.3

Post by jouko200 »

* Report this post
* Reply with quote

Re: how to make database with php5.3

Postby nocturne » 9 minutes ago
PHP doesn't 'manage' the database -- MySQL does; PHP just merely accesses it. And if moving PHP to a different path results in xaseco not running.. well, did you remember to set the path in the batch script you use to start xaseco..?
yes i did and needed image restore again :lol:
jouko200
Posts: 54
Joined: 04 Mar 2011, 15:05

Re: how to make database with php5.3

Post by jouko200 »

if u read all what i WRITE it is possible to understood how installl xampp with xaseco and mania live :lol:
User avatar
Xymph
Posts: 1399
Joined: 15 Jun 2010, 20:35
Contact:

Re: how to make database with php5.3

Post by Xymph »

jouko200 wrote: thx for people who made good install instructions for xaseco
Maybe, but the list you posted definitely isn't for XAseco. It appears to be for the original version 0.61b of ASECO, but contains several outdated references, such as an ancient version of localdatabase.xml.
jouko200 wrote:I hope this can be useful to somebody!
It's commendable that you try to help, but then at least make sure what you post applies to the current version (v1.12) of the software you're talking about (XAseco), not to something really old that has no relation to the topic of this thread.
That link ends up at the wrong post. :roll: The correct one is: http://www.tm-forum.com/viewtopic.php?p=192149#p192149
Developer of XASECO for TMF/TMN ESWC & XASECO2 for TM²: see XAseco.org
Find your way around the Mania community from the TMN ESWC hub, TMF hub, TM² hub, and SM hub
jouko200
Posts: 54
Joined: 04 Mar 2011, 15:05

install newest version xampp (wit php5.3)and keep recs

Post by jouko200 »

0 save image from ur harddisk (Paragon backup and recovery is good for it).....recommend to do it.
1 save aseco folder from xampp C:\xampp\mysql\data\aseco to different place
2 uninstall old xampp
3 install newest version xampp to c: (not program files)
4 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 import all sql files to database aseco do changes if needed http://www.tm-forum.com/viewtopic.php?p=192149#p192149
6 replace aseco folder with saved one
7 start xaseco 1.11( this version is very important it makes changes to database)
8. now u can use xaseco 1.12 (recs are still there)and php5.3 and databases are ready for mania live.
:D :D :D :D :D :D :D :D :D :D :D :D :D :D :D :D :D :D :D :D :D :D :D :D


that was how i did it ... maybe other ways

i u used ur own brains .... :lol: restore image
TheM
Posts: 1379
Joined: 15 Jun 2010, 14:30
Location: Uden, Noord-Brabant, Netherlands
Contact:

Re: install newest version xampp (wit php5.3)and keep recs

Post by TheM »

jouko200 wrote: 7 start xaseco 1.11( this version is very important it makes changes to database)
8. now u can use xaseco 1.12 (recs are still there)and php5.3 and databases are ready for mania live.
Uhum... XAseco 1.12 does include the database-changes, no need to start 1.11 (which isn't availible anymore) ;)
Global moderator | Dutch moderator | Laddermoderator | ManiaWiki moderator
Server Manager/webmaster of Smurfen.net, join us on Canyon, Valley and Royal!
ESL (Game) Staff Head for TrackMania (Stadium, Canyon and Valley).
Post Reply

Return to “Dedicated Server Tools”

Who is online

Users browsing this forum: No registered users and 1 guest