(split) IPB pro arcade development

[micheal332001]

Originally Posted by ggiersdorf

we need a thread for problems Zero.. Im getting this when going into the Admin CP

and clicking on usergroups or pathing to the arcade manually



mySQL query error: SELECT m.userid, m.username, m.posts, m.arcade_ban, m.times_played, m.is_arcade_mod AS is_mod,
m.fav_games AS favs, m.user_sort, m.user_order, m.user_g_pp,
m.user_s_pp, m.def_g_cat, m.game_skin, m.arcade_mod_privs, m.arcade_pmactive, g.adminpermissions AS is_admin,
g.arcade_access, g.p_require, g.max_play, g.ppd_require, g.ibpa_cats AS allowed_categories
FROM user AS m
LEFT JOIN usergroup AS g
ON (m.usergroupid = g.usergroupid)
WHERE userid=1 LIMIT 0, 1

mySQL error: Unknown column 'g.ibpa_cats' in 'field list'
mySQL error code:
Date: Sunday 06th of November 2005 07:42:54 AM


Version 3.5.0 fresh install. Anyone else had this and have the fix?!

Hi there you need to run this in your phpmyadmin

PHP Code:

 ALTER TABLE `usergroup` ADD `arcade_pmactive` tinyint(1) NOT NULL default '1';
 
ALTER TABLE `usergroup` ADD `ibpa_cats` MEDIUMTEXT ; 


Remember to put your prefix in

[Boofo]

Ok, Zero, where's my beta copy at?

[MissKalunji]

Originally Posted by micheal332001

Hi there you need to run this in your phpmyadmin

PHP Code:

 ALTER TABLE `usergroup` ADD `arcade_pmactive` tinyint(1) NOT NULL default '1';
 
ALTER TABLE `usergroup` ADD `ibpa_cats` MEDIUMTEXT ; 


Remember to put your prefix in

it doesnt work.....

Thats what i get and its on an upgrade

mySQL query error: SELECT m.userid, m.username, m.posts, m.arcade_ban, m.times_played, m.is_arcade_mod AS is_mod,
m.fav_games AS favs, m.user_sort, m.user_order, m.user_g_pp,
m.user_s_pp, m.def_g_cat, m.game_skin, m.arcade_mod_privs, m.arcade_pmactive, g.adminpermissions AS is_admin,
g.arcade_access, g.p_require, g.max_play, g.ppd_require, g.ibpa_cats AS allowed_categories
FROM user AS m
LEFT JOIN usergroup AS g
ON (m.usergroupid = g.usergroupid)
WHERE userid=1315 LIMIT 0, 1

mySQL error: Unknown column 'm.arcade_pmactive' in 'field list'
mySQL error code:
Date: Sunday 06th of November 2005 10:25:24 AM

found the bug :


it didnt execute this : $vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD arcade_pmactive tinyint(1) DEFAULT '1' NOT NULL");
$

[4number8]

I would be more than greatful to test it out also...can't wait for the final finished version.

[Huijting]

Aaarghh,

Got it working , i think

I changed the code :

ALTER TABLE `usergroup` ADD `arcade_pmactive` tinyint(1) NOT NULL default '1';

ALTER TABLE `usergroup` ADD `ibpa_cats` MEDIUMTEXT ;

to :

ALTER TABLE `user` ADD `arcade_pmactive` tinyint(1) NOT NULL default '1';

ALTER TABLE `usergroup` ADD `ibpa_cats` MEDIUMTEXT ;

For now it works for me

[Wordplay]

is there no challange system in ipb arcade?

[Huijting]

To get my arcade announcement working again i also added :

ALTER TABLE `games_settings` ADD `announcement_parsed` text NOT NULL ;

Rob

[nitro]

Originally Posted by Huijting

Aaarghh,

Got it working , i think

I changed the code :

ALTER TABLE `usergroup` ADD `arcade_pmactive` tinyint(1) NOT NULL default '1';

ALTER TABLE `usergroup` ADD `ibpa_cats` MEDIUMTEXT ;

to :

ALTER TABLE `user` ADD `arcade_pmactive` tinyint(1) NOT NULL default '1';

ALTER TABLE `usergroup` ADD `ibpa_cats` MEDIUMTEXT ;

For now it works for me

This would appear to be correct to me as its what I did a while ago having suffered the same issue. not sure on the Annoucements bit they are not showing in the arcade but they are elsewhere on my own mods ? Only just noticed this after reading the post.

[tcs]

Can I download RC4?

[MissKalunji]

Originally Posted by Wordplay

is there no challange system in ipb arcade?

theres a tournement it hink it sthe same

[MrZeropage]

Sorry for that trouble with the Database-Tables, will provide a fixed XML soon.

Yes, Tournaments with 2 Players are somewhat the "challenge" from v3arcade, by now this can be initiated by any Arcade-Mod or an Administrator.

Maybe a simple "challenge another player" will come as an AddOn later

[MrZeropage]

I apologize for the errors in RC4-Installer, so I will spread a fixed RC4.5 within the next 30 minutes...

[Snake]

OK that's cool but when is the final version to be released? I'm sick of those RC versions man.

[ggiersdorf]

Mr.Zero, Could you make a small adjustment to the Postbitlegacy or POstbit section.

Right now it allows standard (which Piles them up/down on postbit)
Horizontal and vertical scrolling.

Could you please make or help me make a better solution for many of us.

Have them line up left to right 1 or 2 spaces apart with no text but just the aracde icon (clickable to the game) and when you hover over it it says Pacman champ score: 1000

this allows multiple awards on the postbit without scrolling etc, and makes it look MUCH nicer in my view.

Hope you understand this request if not I can make a drawing..

Otherwise its sweet as HELL..

[Huijting]

Originally Posted by MrZeropage

I apologize for the errors in RC4-Installer, so I will spread a fixed RC4.5 within the next 30 minutes...

Are the changes I posted the only errors ??? or am i missing something else ??

Thnx

Rob

[kylek]

Originally Posted by MrZeropage

I apologize for the errors in RC4-Installer, so I will spread a fixed RC4.5 within the next 30 minutes...

Will RC4.5 be out soon, just trying to plan the rest of my day.
Thanks.

[MrZeropage]

Gimme 5 Minutes ... Preparing PM

[Snake]

Hey me too, Zero. I would like to install and beta test it.

[ggiersdorf]

FIles are fixed now looking good, anyone who can tell me about the above request 4 posts up let me know please!?

[MrZeropage]

I know what you mean, I will check this out and maybe implement in the next version (which hopefully means to be the final release)