v3arcade Manually Add Game via Admin CP

[Oblivion Knight]

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] (https://vborg.vbsupport.ru/showpost.php?p=906818&postcount=27) -- [1.0.1 -> 1.0.2] (https://vborg.vbsupport.ru/showpost.php?p=962566&postcount=46)

Compatability: 1.0.6

[evenmonkeys]

w00000000000t! THANK YOU!

[GoTTi]

congrats on the release Oblivion...im still stuck in 3.0.x world though so i cant enjoy this yet...:disappointed:

[cooltechie]

help me understand why this is needed. isn't games managed through the download system?

[sitka]

is this similiar to the way that nukearcade works? input the graphic name, the swf name, game score name, etc

[Oblivion Knight]

help me understand why this is needed. isn't games managed through the download system?Old v3arcade games, and ibProArcade games are compatible with the new version of v3arcade.

So if you don't have the accompanying .game.php file, or .tar archive, you can use this to install those games by entering the details manually. As mentioned, it's intended use is for developers and more knowledgable of vBulletin and v3arcade users.


is this similiar to the way that nukearcade works? input the graphic name, the swf name, game score name, etcUmm.. Pretty much I guess.

It's basically all the options from the "Edit Game" page, plus the shortname, the swf name and the 2 image names. It's probably more options than you'll ever need, but it saves future upgrades just to add an option here or there.

[Corriewf]

Old v3arcade games, and ibProArcade games are compatible with the new version of v3arcade.

So if you don't have the accompanying .game.php file, or .tar archive, you can use this to install those games by entering the details manually. As mentioned, it's intended use is for developers and more knowledgable of vBulletin and v3arcade users.


Umm.. Pretty much I guess.

It's basically all the options from the "Edit Game" page, plus the shortname, the swf name and the 2 image names. It's probably more options than you'll ever need, but it saves future upgrades just to add an option here or there.

Wow! I would love to see this integrated in the next version. Very good work!

[Diggazz]

This is what I have been looking for but It installs the game ok except when i go to play the game I get a white screen

any help would be appreciated

[Oblivion Knight]

Make sure that you've definately entered the correct information..

The Flash File field needs to include the ".swf" extension at the end of the name.

[Diggazz]

OK thanks the.swf extension I didnot include

thankyou

[jawinn]

Installed

As I understand it, this script will allow me to import iBPro games into my new install of v3arcade. Is that correct?

[Oblivion Knight]

Installed

As I understand it, this script will allow me to import iBPro games into my new install of v3arcade. Is that correct?Theoretically, yes.

Although in future versions of v3arcade, installing ibProArcade games with this addon may cause some problems. I guess I should add a "system" setting to this which would take care of it..

[Snake]

Whoa this is hot!

Thanks! :)

[jawinn]

Theoretically, yes.




Awesome, how would I do that? I don't see how I run the script once it's installed. Thanks in advance.

J

[Citizen]

I got this error:
Database error in vBulletin 3.5.0:

Invalid SQL:
INSERT INTO arcade_games (shortname, title, description, file, width, height, miniimage, stdimage, gamepermissions, categoryid, dateadded, minpoststotal, minpostsperday, minpoststhisday, minreglength, minrep, isreverse) VALUES
('Pacman', 'Pacman', 'Pacman was one of the most successful retro games of its time.', 'pacman.swf', '360', '420', 'pacman2.gif', 'pacman1.gif', '5', '3', '1136838282', '0', '0', '0', '0', '0', '0');

MySQL Error : Unknown column 'minpoststhisday' in 'field list'
Error Number : 1054
Date : Monday, January 9th 2006 @ 02:24:42 PM
Script : http://www.xxx.com/forums/admincp/arcadeadmin.php
Referrer : http://www.xxx.com/forums/admincp/arcadeadmin.php
IP Address : xxx
Username : xxx
Classname : vb_database

[Oblivion Knight]

I got this error:Make sure you're using 1.0.2 of v3arcade.

[lanc3lot]

It seems that when i visit vb.org, i wish to have this and that, and then i found it in threads!!!!!!

Well done Oblivion, i needed that :)

[Citizen]

Make sure you're using 1.0.2 of v3arcade.
It is 1.0.2

[Oblivion Knight]

It is 1.0.2Then this column should exist in your arcade_games table; "minpoststhisday".

According to your error, it doesn't.

[Citizen]

Then this column should exist in your arcade_games table; "minpoststhisday".

According to your error, it doesn't.
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.

[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]

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?


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.phpIt 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.


ok, i think i need 1.02..............mmmmmmmmmmmmmPossibly.. Have you solved this issue now? Sorry for the late reply.


When add a new games, can u make it appear at News & Events?
ThanksI'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

[dakar]

Can anyone explain in any detail what needs to be modified to fix the score submission?

[Oblivion Knight]

The games that you add must already be modified for use with v3arcade in order for them to submit the score to your database (sorry, I took it for granted everyone would know)..

[Injektilo]

will u release on that works on the new version?

[Oblivion Knight]

Yes, when I get the chance.. :)

[Injektilo]

i've tried it and it works with the new version...do ya think there will be a problem?

[Freesteyelz]

Works fantastic in 3.5.3. Thanks Oblivion Knight. :) *Clicked Install*

[Oblivion Knight]

i've tried it and it works with the new version...do ya think there will be a problem?Not if it works alright; I haven't had the time to compare the latest v3arcade code.. :)

[AKapadia]

Does this hack work with this hack or not ?

https://vborg.vbsupport.ru/showthread.php?t=101554

[Injektilo]

Does this hack work with this hack or not ?

https://vborg.vbsupport.ru/showthread.php?t=101554

i believe there is a build in function in ibProArcade for manually add game

[AKapadia]

o yeah my bad bro thanx :)

[vchase]

thanks! installed

[WoodiE]

Oblivion Knight thanks so much for this add-on. After many failed attempts at trying to get John to fix a problem adding games, I was able to install this add-on and manually add them myself and it works - to bad the auto system doesn't.

Thanks again!

-Michael

[Oblivion Knight]

You're most welcome, WoodiE.. :)

[Cajun]

I am using v3arcade 1.0.5. I installed this mod and I can add games but can not edit them after installing. I have to reinstall the un-edited arcadeamin.php file to edit any on my games.

I see this mod is for v3arcade 1.0.2 only. Is that causing this problem and if so will you update to work with v3arcade 1.0.5 and 1.0.6?

[Oblivion Knight]

It states 1.0.2, however other users have tested it with newer versions and haven't reported any such problems. I'll try and find some time to look into it though..

In the meantime I suggest double checking your file edits of admincp/arcadeadmin.php

[Oblivion Knight]

1.0.2 is now available..
Just a small update to integrate the vbBux addon that was added to v3arcade.


Upgrade Instructions:
Open up admincp/arcadeadmin.php and find:
print_input_row($vbphrase['flash_file'], 'file', $game['file']);
print_input_row($vbphrase['standard_image'], 'stdimage', $game['stdimage']);
print_input_row($vbphrase['mini_image'], 'miniimage', $game['miniimage']);

print_yes_no_row($vbphrase['is_active'] . $vbphrase['is_active_dfn'], 'gamepermissions[isactive]', $game['permissions']['isactive']);
print_yes_no_row($vbphrase['show_award'], 'gamepermissions[showaward]', $game['permissions']['showaward']);
print_yes_no_row($vbphrase['enable_challenges'], 'gamepermissions[enablechallenges]', $game['permissions']['enablechallenges']);
print_yes_no_row($vbphrase['use_reverse'], 'isreverse', $game['isreverse']);Below it, add:
// vbBux Integration
if ($vbulletin->options['vbbux_pointsfield'])
{
print_input_row($vbphrase['game_cost'], 'cost', $game['cost']);
}

Find:
'categoryid' => TYPE_UINT
));

// Get that bitfield value calculated.
require_once(DIR . '/includes/functions_misc.php');
$vbulletin->GPC['gamepermissions'] = convert_array_to_bits($vbulletin->GPC['gamepermissions'], $vbulletin->bf_misc_gamepermissions);

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'] . "')");
}Replace it with:
'categoryid' => TYPE_UINT,
'cost' => TYPE_NUM
));

// Get that bitfield value calculated.
require_once(DIR . '/includes/functions_misc.php');
$vbulletin->GPC['gamepermissions'] = convert_array_to_bits($vbulletin->GPC['gamepermissions'], $vbulletin->bf_misc_gamepermissions);

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, cost) 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'] . "', '" . $vbulletin->GPC['cost'] . "')");
} 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, cost) 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'] . "', '" . $vbulletin->GPC['cost'] . "')");
}Done.

[S@NL - BlackBik]

Thanks a lot OK.
Since I updated the Arcade, mass import doesn't work anymore.
This way I'm still able to add games.

[a43079]

i get this error after installing and tried to do a v3 Arcade - Mass Game Import after i hit start it cave me this error

Fatal error: Call to a member function read() on a non-object in C:\Program Files\Apache Group\Apache2\htdocs\home\forum\admincp\arcadeadmi n.php on line 719


line 791 shows

while (($filename = $d->read()) AND ($counter<$vbulletin->GPC['gamesperpage'])) {

[HS2005]

This Works Really Great, Your a Great Coder to come up with this handy Coding for vb 3.5.4 arcade help.

EDIT: I watched the .php codes for activating the submit code.
You Said That it must have been already imported for vb arcade to work.
but i looked up the php codes but i see no changes of one who is activated with v3 arcade and can submist and a game who can't submit.

Have any idea if it's even a .php file or does it lie different

[a43079]

i get this error after installing and tried to do a v3 Arcade - Mass Game Import after i hit start it cave me this error

Fatal error: Call to a member function read() on a non-object in C:\Program Files\Apache Group\Apache2\htdocs\home\forum\admincp\arcadeadmi n.php on line 719


line 791 shows

while (($filename = $d->read()) AND ($counter<$vbulletin->GPC['gamesperpage'])) {


could i get someone to help me with this please..

[Oblivion Knight]

could i get someone to help me with this please..I'll take a look, although that line isn't touched by this modification IIRC..

You should try fixing this typo though..
while (($filename = $d->read()) AND ($counter<$vbulletin->GPC['gamesperpage'])) {Should read:
while (($filename = $db->read()) AND ($counter<$vbulletin->GPC['gamesperpage'])) {

[a43079]

thank you i fixed the typo any help you can give me would be great thank you..

[analog-x]

I installed this MOD, but than I was unable to edit my other games details.

I followed the installation instructions very carefully. Once I removed this MOD i was able to edit my Game Details again.

[a43079]

well thank you for the help after playing with it for a week i figured it out its working fine now thank you..

[bayard88]

installed
thanks ;)

[Oblivion Knight]

well thank you for the help after playing with it for a week i figured it out its working fine now thank you..Fixing that typo should have fixed it I think.. Was there anything else you needed to do?

[foulplay]

This hack would have been perfect if you could submit scores.

[SupremeWeapon]

Parse error: syntax error, unexpected T_STRING, expecting ']' in /var/www/forums/admincp/arcadeadmin.php on line 1114

Get this when trying to go tot he game import area. made file modifications to a T also.

[Q139]

Great mod....installed!!!

[mljask]

does this mod works for vbulletin 3.6???

[Oblivion Knight]

does this mod works for vbulletin 3.6???I see no reason why it shouldn't, but I cannot confirm this.

[Chicago_VLNU_4s]

i don't have the file

admincp/arcadeadmin.php

where can i get this?

[andy1074]

i installed this hack succesfully
thank you very very mach
when i installed a new game by this hack it works but dose not submit record
what should i do
please help me ...

[F34R]

Using this mod, after I've set the game up, they work fine. However, the Time Played stat for the game shows ZERO on all games I install with this mod. How do I get it to show the time played like it does for all the script installed games ?

[litfoo]

I have installed this mod, but really cannot see where I can actually manually add a game

help appreciated

litfoo

[ZBJsmom]

I too have successfully installed this hack but can't actually see where I manually add a game in the AdminCP.

Can anyone help us, please?

UPDATE! It appeared after I logged out of admin CP. thanks!

[Ekshi]

Nice add ons ;)

[Lovemonk]

Downloaded, installed, and I love it. Cheers!:o

[m411b]

Wish I could submit scores! Is there a fix?