Bug Reimport IPA not working ?

[E.T.]

Hi,

I've just try to reimport the IPA games, but there is a database error:

Database error in vBulletin 4.1.5:

Invalid SQL:
UPDATE games_list SET game_type = 1 WHERE gname IN (AConMahv32Th, AnimalMahjongv32Sparky, Checkers_v32, DragonMahjongDR, EveronesHeroMJSte, MahjonggAlchemy_v32, MarchZuma_v32, MrPacmanv32Sparky, SuperMarioMahjongv32Th, ageofjapanGC, antipacmanDR, armageddonv32, asteroids_revenge_v32, babypacmanv32TH, backgammonv32MICRO, bongobabes, bongoballsDR, bubbleshooterv32MICRO, crimepuzzleSte, deluxespinpoker, elitemahjongFullTh, festivalpinballv32, fruitslotmachinev32, gdkenov32, halloweenslots_v32, homerunmania_v32, ikeaswing, jakepinball, jawbreakerv32colbe, lawinensurferTh, mahjonggSJS, mahjonggg2JS, mahjongtowerNM, marioluigipipepanic, meteorjazzDR, ntpinballv32MICRO, pacman, powerballin, ratpinballGC, spaceshootrace, turbomahjonggkkv32Sparky, video-poker-deuces-wildv32, video-poker-jokers-wildv32);

MySQL Error   : Unknown column 'AConMahv32Th' in 'where clause'
Error Number  : 1054
Request Date  : Thursday, August 18th 2011 @ 10:48:42 PM
Error Date    : Thursday, August 18th 2011 @ 10:48:42 PM
Script        : http://www.dbf4all.eu/forum/admincp/arcade_admin.php?do=preview
Referrer      : http://www.dbf4all.eu/forum/admincp/arcade_admin.php?do=import
IP Address    : 83.161.254.66
Username      : E.T.
Classname     : vB_Database
MySQL Version : 5.1.41-community

Have I done something wrong ?

cheers,
Marcel

 

[Darkwaltz4]

Darn, edit (forum)/dbtech/vbarcade/systems/ipa.php find

implode(', ', $games)

replace with

implode(', ', $v32games)

sorry, i know youve been dying to get something to submit some scores

 

[E.T.]

hehe, I like to submit scores

Changed the settings in ipa.php and now import seems to work....., however, once the import is finished the ACP shows already imported, but the games are not visible in vbArcade... ?

 

[Darkwaltz4]

Reselect them and reimport them imports merge in new information if the game appears to already be installed.

 

[E.T.]

Sorry it is really not working, did reselect the first page and click on Import Selected Games and within a few second the page shows already imported, but none of them are in vbA....

 

[E.T.]

Hold on, after the third time it was working...

Solved.

Thanks a lot