(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