Rasp missing ?

This forum is dedicated to the Aseco/Rasp 2 server records and control script by Flo and Assembler Maniac. Announcements and issues can be discussed in this forum.

Moderators: Flo, f*ckfish, Assembler Maniac, TM-Patrol

Post Reply
skyi
pedestrian
pedestrian
Posts: 10
Joined: 16 Dec 2009 11:10
Owned TM-games: tms,tmnf,tmuf

Rasp missing ?

Post by skyi » 01 Feb 2010 16:29

Hey all :)

Im not shure but i think rasp is missing
in my aseco files
in xaseco you got a rasp.sql file (in localdb folder)
but i can't find that one in the localdb folder of aseco ?
is that the reason why i'cant save records
(the recs disapear if he track comes back)

Hope you guys can help me :)

Sky-i

jamie_macdonald
TM-Patrol
TM-Patrol
Posts: 1612
Joined: 10 Jul 2008 19:48
Owned TM-games: TMUF, TMNF, TMS
Manialink(s): ET
Location: London, UK
Contact:

Re: Rasp missing ?

Post by jamie_macdonald » 01 Feb 2010 16:31

all i can suggest is to re-download the latest version of your aseco/xaseco and check the archives from a fresh copy.

Maybe an error in extraction/download that spammed the checksum on the file in the archive or something.

Hope it helps.

nocturne
solid chaser
solid chaser
Posts: 1390
Joined: 08 Jun 2007 18:48
Owned TM-games: all
Contact:

Re: Rasp missing ?

Post by nocturne » 01 Feb 2010 18:48

It's not that it's missing... just that it's not really needed. The main RASP plugin creates the necessary tables upon it's first run, granted the mysql login you are using has 'CREATE' rights on the database you are using. I had the same problem recently setting up a new server -- screwed up the user privileges... :oops:

In any case, here's an SQL of the entire structure of the Aseco db, including rasp and the matchsave tables...

Code: Select all

-- CREATE DATABASE `aseco`;
-- USE `aseco`;

CREATE TABLE `challenges` (
  `Id` int(11) NOT NULL auto_increment,
  `Uid` varchar(27) collate utf8_unicode_ci NOT NULL,
  `Name` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Author` varchar(30) collate utf8_unicode_ci NOT NULL,
  `Environment` varchar(15) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`Id`),
  UNIQUE KEY `Uid` (`Uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

CREATE TABLE `players` (
  `Id` int(11) NOT NULL auto_increment,
  `Login` varchar(100) collate utf8_unicode_ci NOT NULL,
  `Game` varchar(3) collate utf8_unicode_ci NOT NULL,
  `NickName` varchar(100) collate utf8_unicode_ci NOT NULL,
  `Nation` varchar(3) collate utf8_unicode_ci NOT NULL,
  `UpdatedAt` datetime NOT NULL default '0000-00-00 00:00:00',
  `Wins` mediumint(9) NOT NULL default '0',
  `TimePlayed` mediumint(9) NOT NULL default '0',
  `TeamName` char(60) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`Id`),
  UNIQUE KEY `Login` (`Login`),
  KEY `Game` (`Game`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

CREATE TABLE `records` (
  `Id` int(11) NOT NULL auto_increment,
  `ChallengeId` int(11) NOT NULL default '0',
  `PlayerId` int(11) NOT NULL default '0',
  `Score` mediumint(9) NOT NULL default '0',
  `Date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`Id`),
  UNIQUE KEY `ChallengeId` (`ChallengeId`,`PlayerId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

CREATE TABLE `votes` (
  `Id` int(11) NOT NULL auto_increment,
  `Score` smallint(6) NOT NULL default '0',
  `PlayerId` int(11) NOT NULL default '0',
  `ChallengeId` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Id`),
  UNIQUE KEY `PlayerId` (`PlayerId`,`ChallengeId`),
  KEY `ChallengeId` (`ChallengeId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `rs_karma` (
  `Id` int(11) NOT NULL auto_increment,
  `Score` smallint(6) NOT NULL default 0,
  `PlayerId` int(11) NOT NULL default 0,
  `ChallengeId` int(11) NOT NULL default 0,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `PlayerId` (`PlayerId`,`ChallengeId`),
  KEY `ChallengeId` (`ChallengeId`)
) TYPE=MyISAM;

CREATE TABLE IF NOT EXISTS `rs_times` (
  `ID` int(11) NOT NULL auto_increment,
  `playerID` int(11) NOT NULL default 0,
  `trackID` int(11) NOT NULL default 0,
  `score` mediumint(9) NOT NULL default 0,
  `date` int(10) unsigned NOT NULL default 0,
  PRIMARY KEY	(`ID`)
) TYPE=MyISAM Default Character Set UTF8

CREATE TABLE IF NOT EXISTS `rs_rank` (
  `playerID` int(11) NOT NULL default 0,
  `avg` float NOT NULL default 0,
  KEY `playerID` (`playerID`)
) TYPE=MyISAM Default Character Set UTF8

CREATE TABLE `match_details` (
  `MatchID` int(11) unsigned NOT NULL,
  `PlayerID` int(11) unsigned NOT NULL,
  `teamname` varchar(40) default NULL,
  `points` tinyint(4) default '0',
  `score` mediumint(9) default NULL,
  PRIMARY KEY  (`MatchID`,`PlayerID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

CREATE TABLE `match_main` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `TrackID` int(11) unsigned NOT NULL,
  `dttmrun` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
(first two lines are commented out... uncomment and configure if needed)

The only real difference between the Xaseco and Aseco's DBs is the the rs_times table structure, and the integers' lengths have been changed to 11.

skyi
pedestrian
pedestrian
Posts: 10
Joined: 16 Dec 2009 11:10
Owned TM-games: tms,tmnf,tmuf

Re: Rasp missing ?

Post by skyi » 03 Feb 2010 11:41

thanks fot the help :thumbsup:

Post Reply