v3arcade Manually Add Game via Admin CP

This modification provides you with an additional Game Tool to manually add a game without the use of a script or import tool.. Boofo pointed out to me that before today, this was not possible and I believe it to be a rather useful tool for the more knowledgable of vBulletin and v3arcade users.

Please note that games added to the database with this modification must have already been "converted" for use with v3arcade/ibProArcade for them to work..


Upgrade Notes: [1.0.0 -> 1.0.1] -- [1.0.1 -> 1.0.2]

Compatability: 1.0.6

[Michael_Tree]

Hey, thanks to this I can install games to the arcade, unlike before. But now people cant submit their score!!! lol Can anyone help? Link: www.habbodialogue.com/arcade.php

[plateau]

It seems that in my system , there is no this phrase:

$vbphrase['use_reverse']

thus I dont know what is the : print_yes_no_row($vbphrase['use_reverse'], 'isreverse', $game['isreverse']); for? therefore dont know how to do the setting for that option.

Thanks for help!

[plateau]

ok, i think i need 1.02..............mmmmmmmmmmmmm

[LeonHartHVA]

When add a new games, can u make it appear at News & Events?
Thanks

[forumsoup.com]

I put this on my site, love it, and clicked installed. Thanks!

[Oblivion Knight]

Originally Posted by Citizen

Do you have the code to manually add the column?

I've had to manually add most of database given that there wasnt much support for people that had the 3.0.x version of v3arcade intstalled and then upgraded.

Chances are, you could be missing more than just that one column.
Could you possibly take screenshots of your arcade_games table structure for me?

Originally Posted by Michael_Tree

Hey, thanks to this I can install games to the arcade, unlike before. But now people cant submit their score!!! lol Can anyone help? Link: www.habbodialogue.com/arcade.php

It depends on the game(s) you're trying to install.

It should be noted that the games still require to be modified to work with v3arcade in order for them to submit the score to your database.. I got a 404 when trying to visit the URL you supplied.

Originally Posted by plateau

ok, i think i need 1.02..............mmmmmmmmmmmmm

Possibly.. Have you solved this issue now? Sorry for the late reply.

Originally Posted by LeonHartHVA

When add a new games, can u make it appear at News & Events?
Thanks

I'll try and release an update tonight for you..

[Oblivion Knight]

1.0.1 is now available!
As suggested, there is now an additional option in the Admin CP for making newly added games post an event on the "News & Events" block. This is enabled by default.


Upgrade Instructions:
1.) Open up admincp/arcadeadmin.php and find:

	if ($vbulletin->GPC['author'] == '' AND $vbulletin->GPC['instructions'] == '')
	{
		$db->query_write("INSERT INTO " . TABLE_PREFIX . "arcade_games (shortname, title, description, file, width, height, miniimage, stdimage, gamepermissions, categoryid, dateadded, minpoststotal, minpostsperday, minpoststhisday, minreglength, minrep, isreverse) VALUES
		('" . addslashes($vbulletin->GPC['shortname']) . "', '" . addslashes($vbulletin->GPC['title']) . "', '" . addslashes($vbulletin->GPC['description']) . "', '" . addslashes($vbulletin->GPC['file']) . "', '" . $vbulletin->GPC['width'] . "', '" . $vbulletin->GPC['height'] . "', '" . addslashes($vbulletin->GPC['miniimage']) . "', '" . addslashes($vbulletin->GPC['stdimage']) . "', '" . $vbulletin->GPC['gamepermissions'] . "', '" . $vbulletin->GPC['categoryid'] . "', '" . TIMENOW . "', '" . $vbulletin->GPC['minpoststotal'] . "', '" . $vbulletin->GPC['minpostsperday'] . "', '" . $vbulletin->GPC['minpoststhisday'] . "', '" . $vbulletin->GPC['minreglength'] . "', '" . $vbulletin->GPC['minrep'] . "', '" . $vbulletin->GPC['isreverse'] . "')");
	} else {
		$db->query_write("INSERT INTO " . TABLE_PREFIX . "arcade_games (shortname, title, author, description, instructions, file, width, height, miniimage, stdimage, gamepermissions, categoryid, dateadded, minpoststotal, minpostsperday, minpoststhisday, minreglength, minrep, isreverse) VALUES
		('" . addslashes($vbulletin->GPC['shortname']) . "', '" . addslashes($vbulletin->GPC['title']) . "', '" . addslashes($vbulletin->GPC['author']) . "', '" . addslashes($vbulletin->GPC['description']) . "', '" . addslashes($vbulletin->GPC['instructions']) . "', '" . addslashes($vbulletin->GPC['file']) . "', '" . $vbulletin->GPC['width'] . "', '" . $vbulletin->GPC['height'] . "', '" . addslashes($vbulletin->GPC['miniimage']) . "', '" . addslashes($vbulletin->GPC['stdimage']) . "', '" . $vbulletin->GPC['gamepermissions'] . "', '" . $vbulletin->GPC['categoryid'] . "', '" . TIMENOW . "', '" . $vbulletin->GPC['minpoststotal'] . "', '" . $vbulletin->GPC['minpostsperday'] . "', '" . $vbulletin->GPC['minpoststhisday'] . "', '" . $vbulletin->GPC['minreglength'] . "', '" . $vbulletin->GPC['minrep'] . "', '" . $vbulletin->GPC['isreverse'] . "')");
	}

Below it, add:

	if ($vbulletin->options['neweventonmanaddgame'] == 1)
	{
		$db->query_write("INSERT INTO " . TABLE_PREFIX . "arcade_news (newstext, newstype, datestamp) VALUES ('" . addslashes(construct_phrase($vbphrase['x_has_been_added'], $vbulletin->GPC['title'])) . "', 'auto', " . TIMENOW . ")");
	}

2.) Import the updated product file, with the "Overwrite" checkbox enabled.

[LeonHartHVA]

Good job Oblivion Knight, thank you very much :nervous:

[rewardhits]

can any one help me installing as many varcade games on vbulletin 3.5 version? I really need help. will pay $20, if interested please email me at "teknorhino@yahoo.com"

thank you,
Frank

[ZacUSNYR]

Sweet i'm getting sick of using phpmyadmin to do it heh