v3arcade Game ImpEx System

Game ImpEx System
For v3arcade 1.0.6


Description
A tool to quickly and easily import new games, update previous games with new information or export games.

I stated in my original release of Addon Pack 1 (now merged with this) that ideally, it needed some kind of ImpEx feature to easily share the updated game information (author, instructions). This does exactly that, and more!! In fact, it provides a darn good replacement for v3arcade's current method of game installation - great news for those who are having problems with it!


Credits
A HUGE thanks to [high]Dream[/high] for allowing me to release this, as the code is largely based on his "Import / Export vBRadio Stations" modification.


Version Notes
[high]1.0.0[/high] -- Initial release.
1.0.1 -- Critical update, fixed game import/update check routine.
1.0.2 -- Fixed missing "filesize" column query problem.


Future Plans
Fully phrased (yeah, I'm feeling lazy).

[Oblivion Knight]

Fixed, cheers.

[SMO]

Ok, perhaps I didnt do this correctly.

I went to imprt export and browsed for the pacman XML and when i was complete, I got this error.

PHP Code:

Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE arcade_games 
            SET 
            shortname='pacman', 
            title='Pacman', 
            author='<strong>Paul Neave</strong><br /><em><a href=\"http://www.neave.com/\" target=\"_blank\">Please help to support the author and visit their homepage!</a></em>', 
            description='The yellow blob returns! Eat the pills and jack up your score in this arcade classic.', 
            instructions='<strong>Left arrow:</strong> Move Pacman left<br />\r\n<strong>Right arrow:</strong> Move Pacman right<br />\r\n<strong>Up arrow:</strong> Move Pacman up<br />\r\n<strong>Down arrow:</strong> Move Pacman down<br /><br />\r\n<strong>P:</strong> Pause/unpause game<br />\r\n<strong>M:</strong> Mute/unmute sound<br />\r\n<strong>L:</strong> Low quality on/off', 
            notes='This game is an unofficial clone of the original Pac-Man? game and is <strong>not</strong> endorsed by the trademark and copyright owners <a href=\"http://www.namco.com/\" target=\"_blank\">Namco Ltd.</a>', 
            file='pacman.swf', 
            filesize='38', 
            width='360', 
            height='420', 


[DrewM]

you have to put the rest of the error it's impossible to tell what the error is.

[Snake]

This is quite good.

Thanks!

[zyad]

hey guys, i'm getting the same error as the dude above, it happens when uploading the .xml file in admincp ... a screen appears with an iframe:

There seems to have been a problem with the MI Career - Interact database.
Please try again by clicking the Refresh button in your web browser.

An E-Mail has been dispatched to our Technical Staff, whom you can also contact if the problem persists.

We apologise for any inconvenience.

Iframe below with the info he provided

How would i go about fixing that?? thanks in advance!

[Ski-Whiz]

This sounds GREAT!!! However, I'm going to wait til after the May 12th release of v3. I'm sure this will have to be changed..

I LOVE this hack, the installer is not v3's strong point.

[Oblivion Knight]

Originally Posted by SMO

Ok, perhaps I didnt do this correctly.

I went to imprt export and browsed for the pacman XML and when i was complete, I got this error.

I can't provide any help without the full error (error code).

Did you already have Pacman installed? If not it seems that the system tried to run the incorrect query..


---[high]EDIT[/high]---
Yep, I just ran a test and although I didn't get an error - no new games appeared in the database.

I'm working all day today, but I'll try and get a fix out tonight. Sorry.!

[Oblivion Knight]

Fixed.

I would have had it posted sooner, but vbulletin.org went down for me this morning before work..

[forte]

Gives me the error

Database error in vBulletin 3.5.4:

Invalid SQL:
INSERT INTO forumarcade_games 
			(shortname, title, author, description, instructions, notes, file, filesize, width, height, miniimage, stdimage, categoryid, dateadded, system, isreverse) 
			VALUES (
			'pacman', 
			'Pacman', 
			'<strong>Paul Neave</strong><br /><em><a href=\"http://www.neave.com/\" target=\"_blank\">Please help to support the author and visit their homepage!</a></em>', 
			'The yellow blob returns! Eat the pills and jack up your score in this arcade classic.', 
			'<strong>Left arrow:</strong> Move Pacman left<br />\r\n<strong>Right arrow:</strong> Move Pacman right<br />\r\n<strong>Up arrow:</strong> Move Pacman up<br />\r\n<strong>Down arrow:</strong> Move Pacman down<br /><br />\r\n<strong>P:</strong> Pause/unpause game<br />\r\n<strong>M:</strong> Mute/unmute sound<br />\r\n<strong>L:</strong> Low quality on/off', 
			'This game is an unofficial clone of the original Pac-Man? game and is <strong>not</strong> endorsed by the trademark and copyright owners <a href=\"http://www.namco.com/\" target=\"_blank\">Namco Ltd.</a>', 
			'pacman.swf', 
			'38', 
			'360', 
			'420', 
			'pacman2.gif', 
			'pacman1.gif', 
			'3', 
			'1146805881', 
			'0', 
			'0');

MySQL Error  : Unknown column 'author' in 'field list'
Error Number : 1054
Date         : Friday, May 5th 2006 @ 01:11:22 AM

[Oblivion Knight]

Did you import the product file?

It should add the column "author" to the arcade_games table..