[ABD] Arcade Room 0.6.9c

Any abandoned MODs will be moved to this forum.

WARNING: MODs in this forum are not currently being supported or maintained by the original MOD author. Proceed at your own risk.
Forum rules
IMPORTANT: MOD Development Forum rules

WARNING: MODs in this forum are not currently being supported nor updated by the original MOD author. Proceed at your own risk.
Locked
RichieCut
Registered User
Posts: 23
Joined: Sun Sep 30, 2007 11:17 pm

Re: [Beta] Arcade Room 0.6.9

Post by RichieCut »

Nice to see your site back up and running patrikstar :)

Whats left to do to the next release of the arcade room ?
Play To Win - Be The Best - Win Cash - http://www.the-tournament.com - League System for most First Person Shooting Games - TF2 - CSS - DOD - CS 1.6 - Insurgency. High score arcade with ability to win cash.
User avatar
kateland
Registered User
Posts: 198
Joined: Wed Nov 22, 2006 7:08 pm
Location: Philadelphia, PA
Contact:

Re: [Beta] Arcade Room 0.6.9

Post by kateland »

oglach and AngelMike:

There is no reason for you to change the table names in your SQL. As mentioned before, when you get the error "AR_CATEGORIES_TABLE doesn't exist" it means that the php code is using a nickname for phpbb_ar_categories but the variables for the nickname don't exist.

This nickname is defined by you when you make the Arcade Room modification changes:

from install.xml

Code: Select all


Open: includes/constants.php

Find

?>

Add before

define('AR_CATEGORIES_TABLE',		$table_prefix . 'ar_categories');
define('AR_GAMES_TABLE',			$table_prefix . 'ar_games');
define('AR_RATINGS_TABLE',			$table_prefix . 'ar_ratings');
define('AR_SETTINGS_TABLE',			$table_prefix . 'ar_settings');
define('AR_COMMENTS_TABLE',			$table_prefix . 'ar_comments');
define('AR_FAVORITES_TABLE',		$table_prefix . 'ar_favorites');
define('AR_HOTLINKS_TABLE',			$table_prefix . 'ar_hotlinks');
define('AR_HIGHSCORES_TABLE',		$table_prefix . 'ar_highscores');
define('AR_VIEWING_TABLE',			$table_prefix . 'ar_viewing');
define('AR_PLAYED_TABLE',			$table_prefix . 'ar_played');
Make certain you have made these changes.

If you have, then please fill out the Support Request Template so we can get an idea of your database/template/engine versions.
here's your love letter
you bloodletter
you disappointed every time
oglach
Registered User
Posts: 498
Joined: Sun Apr 22, 2007 5:58 pm

Re: [Beta] Arcade Room 0.6.9

Post by oglach »

So will i leave swl as i had in orevious post and macke them changes you have there?

Or will i run sql original code?
User avatar
kateland
Registered User
Posts: 198
Joined: Wed Nov 22, 2006 7:08 pm
Location: Philadelphia, PA
Contact:

Re: [Beta] Arcade Room 0.6.9

Post by kateland »

If you want this fixed, then let's do this one more time from the start.

1. Drop all arcade tables
2. Undo all code changes

Follow install.xml and then give us any errors and a link to your board.
here's your love letter
you bloodletter
you disappointed every time
AngelMike
Registered User
Posts: 150
Joined: Fri Jan 27, 2006 9:28 pm
Location: The Netherlands, Holland
Contact:

Re: [Beta] Arcade Room 0.6.9

Post by AngelMike »

kateland wrote:oglach and AngelMike:

There is no reason for you to change the table names in your SQL. As mentioned before, when you get the error "AR_CATEGORIES_TABLE doesn't exist" it means that the php code is using a nickname for phpbb_ar_categories but the variables for the nickname don't exist.

This nickname is defined by you when you make the Arcade Room modification changes:

from install.xml

Code: Select all


Open: includes/constants.php

Find

?>

Add before

define('AR_CATEGORIES_TABLE',		$table_prefix . 'ar_categories');
define('AR_GAMES_TABLE',			$table_prefix . 'ar_games');
define('AR_RATINGS_TABLE',			$table_prefix . 'ar_ratings');
define('AR_SETTINGS_TABLE',			$table_prefix . 'ar_settings');
define('AR_COMMENTS_TABLE',			$table_prefix . 'ar_comments');
define('AR_FAVORITES_TABLE',		$table_prefix . 'ar_favorites');
define('AR_HOTLINKS_TABLE',			$table_prefix . 'ar_hotlinks');
define('AR_HIGHSCORES_TABLE',		$table_prefix . 'ar_highscores');
define('AR_VIEWING_TABLE',			$table_prefix . 'ar_viewing');
define('AR_PLAYED_TABLE',			$table_prefix . 'ar_played');
Make certain you have made these changes.

If you have, then please fill out the Support Request Template so we can get an idea of your database/template/engine versions.
Wel at mine it dint say catagory.
But annyways i fixed it myzelf in sql so.
and in that one i had to create the table and works now so.
I kinda know my sql stuff.
oglach
Registered User
Posts: 498
Joined: Sun Apr 22, 2007 5:58 pm

Re: [Beta] Arcade Room 0.6.9

Post by oglach »

I dropped all the table, now im getting this!
No matter where i click on my board??
General Error
SQL ERROR [ mysql4 ]

Table 'andrew_phpb1.AR_HOTLINKS_TABLE' doesn't exist [1146]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
User avatar
kateland
Registered User
Posts: 198
Joined: Wed Nov 22, 2006 7:08 pm
Location: Philadelphia, PA
Contact:

Re: [Beta] Arcade Room 0.6.9

Post by kateland »

Did you undo *all* of your code changes, oglach? It's still referencing arcade code, so I think there are still code changes that haven't been removed.
here's your love letter
you bloodletter
you disappointed every time
oglach
Registered User
Posts: 498
Joined: Sun Apr 22, 2007 5:58 pm

Re: [Beta] Arcade Room 0.6.9

Post by oglach »

Yes there was code in common.php which is now removed

All tables are also dropped!

Il do as you say and get back to you
oglach
Registered User
Posts: 498
Joined: Sun Apr 22, 2007 5:58 pm

Re: [Beta] Arcade Room 0.6.9

Post by oglach »

I ran SQL, went successful

Edited all files as instructed in install.xml

I receive this error on my site

General Error
SQL ERROR [ mysql4 ]

Table 'andrew_phpb1.AR_HOTLINKS_TABLE' doesn't exist [1146]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
User avatar
Peetra
Registered User
Posts: 291
Joined: Mon Jun 04, 2007 1:41 pm
Location: Kokkola, Finland
Contact:

Re: [Beta] Arcade Room 0.6.9

Post by Peetra »

patrikstar wrote: -comes with 8 games ready to play
A great MOD, patrikstar! :D

I downloaded the MOD, but cant find the games. Could anyone perhaps tell me witch ones those 8 games are?

Peetra.
I am so hooked on bubbles, that I made a Bubble Witch Saga WP-site! Most addictive game since Tetris!
Rafterman1
Registered User
Posts: 6
Joined: Tue Apr 17, 2007 7:57 pm
Contact:

Re: [Beta] Arcade Room 0.6.9

Post by Rafterman1 »

Hi Peetra,
Check the signatur of partikstar (for example in his first post), there you can find the download of some games.
User avatar
Peetra
Registered User
Posts: 291
Joined: Mon Jun 04, 2007 1:41 pm
Location: Kokkola, Finland
Contact:

Re: [Beta] Arcade Room 0.6.9

Post by Peetra »

I have downloaded those from his signature and Tetris from http://www.vinabb.com/viewforum.php?f=105 :) I just wondered if there is those eight games in the MOD already. An witch one in case they "pop up" somewhere after installing the MOD. :lol:

My friend thought that they where deleted from the download to cut the size, I haven't actually had the time to read this whole topic, so thats probably right. Thanks Rafterman for a fast answer. :D

Peetra.
I am so hooked on bubbles, that I made a Bubble Witch Saga WP-site! Most addictive game since Tetris!
jimcarrel
Registered User
Posts: 671
Joined: Fri Jul 27, 2007 10:49 pm
Location: Oklahoma City, Oklahoma

Re: [Beta] Arcade Room 0.6.9

Post by jimcarrel »

Peetra, there never has been games included in the download.
I believe that in the last 4-6 pages of posts there is a pictorial guide on how to install games.
Grace--Getting what I don't deserve
Mercy--Not getting what I do deserve
User avatar
kateland
Registered User
Posts: 198
Joined: Wed Nov 22, 2006 7:08 pm
Location: Philadelphia, PA
Contact:

Re: [Beta] Arcade Room 0.6.9

Post by kateland »

oglach wrote:I ran SQL, went successful

Edited all files as instructed in install.xml

I receive this error on my site

General Error
SQL ERROR [ mysql4 ]

Table 'andrew_phpb1.AR_HOTLINKS_TABLE' doesn't exist [1146]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
Please paste the contents of root/includes/constants.php.
here's your love letter
you bloodletter
you disappointed every time
oglach
Registered User
Posts: 498
Joined: Sun Apr 22, 2007 5:58 pm

Re: [Beta] Arcade Room 0.6.9

Post by oglach »

when i paste it here there is huge gaps between each line for some reason, here it is

Code: Select all

<?php






/**






*






* @package phpBB3






* @version $Id: constants.php,v 1.83 2007/10/05 14:30:08 acydburn Exp $






* @copyright (c) 2005 phpBB Group






* @license http://opensource.org/licenses/gpl-license.php GNU Public License






*






*/













/**






* @ignore






*/






if (!defined('IN_PHPBB'))






{






	exit;






}













/**






* valid external constants:






* PHPBB_MSG_HANDLER






* PHPBB_ROOT_PATH






* PHPBB_ADMIN_PATH






*/













// User related






define('ANONYMOUS', 1);













define('USER_ACTIVATION_NONE', 0);






define('USER_ACTIVATION_SELF', 1);






define('USER_ACTIVATION_ADMIN', 2);






define('USER_ACTIVATION_DISABLE', 3);













define('AVATAR_UPLOAD', 1);






define('AVATAR_REMOTE', 2);






define('AVATAR_GALLERY', 3);













define('USER_NORMAL', 0);






define('USER_INACTIVE', 1);






define('USER_IGNORE', 2);






define('USER_FOUNDER', 3);













define('INACTIVE_REGISTER', 1);






define('INACTIVE_PROFILE', 2);






define('INACTIVE_MANUAL', 3);






define('INACTIVE_REMIND', 4);













// ACL






define('ACL_NEVER', 0);






define('ACL_YES', 1);






define('ACL_NO', -1);













// Login error codes






define('LOGIN_CONTINUE', 1);






define('LOGIN_BREAK', 2);






define('LOGIN_SUCCESS', 3);






define('LOGIN_SUCCESS_CREATE_PROFILE', 20);






define('LOGIN_ERROR_USERNAME', 10);






define('LOGIN_ERROR_PASSWORD', 11);






define('LOGIN_ERROR_ACTIVE', 12);






define('LOGIN_ERROR_ATTEMPTS', 13);






define('LOGIN_ERROR_EXTERNAL_AUTH', 14);






define('LOGIN_ERROR_PASSWORD_CONVERT', 15);













// Group settings






define('GROUP_OPEN', 0);






define('GROUP_CLOSED', 1);






define('GROUP_HIDDEN', 2);






define('GROUP_SPECIAL', 3);






define('GROUP_FREE', 4);













// Forum/Topic states






define('FORUM_CAT', 0);






define('FORUM_POST', 1);






define('FORUM_LINK', 2);






define('ITEM_UNLOCKED', 0);






define('ITEM_LOCKED', 1);






define('ITEM_MOVED', 2);













// Forum Flags






define('FORUM_FLAG_LINK_TRACK', 1);






define('FORUM_FLAG_PRUNE_POLL', 2);






define('FORUM_FLAG_PRUNE_ANNOUNCE', 4);






define('FORUM_FLAG_PRUNE_STICKY', 8);






define('FORUM_FLAG_ACTIVE_TOPICS', 16);






define('FORUM_FLAG_POST_REVIEW', 32);













// Optional text flags






define('OPTION_FLAG_BBCODE', 1);






define('OPTION_FLAG_SMILIES', 2);






define('OPTION_FLAG_LINKS', 4);













// Topic types






define('POST_NORMAL', 0);






define('POST_STICKY', 1);






define('POST_ANNOUNCE', 2);






define('POST_GLOBAL', 3);













// Lastread types






define('TRACK_NORMAL', 0);






define('TRACK_POSTED', 1);













// Notify methods






define('NOTIFY_EMAIL', 0);






define('NOTIFY_IM', 1);






define('NOTIFY_BOTH', 2);













// Email Priority Settings






define('MAIL_LOW_PRIORITY', 4);






define('MAIL_NORMAL_PRIORITY', 3);






define('MAIL_HIGH_PRIORITY', 2);













// Log types






define('LOG_ADMIN', 0);






define('LOG_MOD', 1);






define('LOG_CRITICAL', 2);






define('LOG_USERS', 3);













// Private messaging - Do NOT change these values






define('PRIVMSGS_HOLD_BOX', -4);






define('PRIVMSGS_NO_BOX', -3);






define('PRIVMSGS_OUTBOX', -2);






define('PRIVMSGS_SENTBOX', -1);






define('PRIVMSGS_INBOX', 0);













// Full Folder Actions






define('FULL_FOLDER_NONE', -3);






define('FULL_FOLDER_DELETE', -2);






define('FULL_FOLDER_HOLD', -1);













// Download Modes - Attachments






define('INLINE_LINK', 1);






// This mode is only used internally to allow modders extending the attachment functionality






define('PHYSICAL_LINK', 2);













// Confirm types






define('CONFIRM_REG', 1);






define('CONFIRM_LOGIN', 2);






define('CONFIRM_POST', 3);













// Categories - Attachments






define('ATTACHMENT_CATEGORY_NONE', 0);






define('ATTACHMENT_CATEGORY_IMAGE', 1); // Inline Images






define('ATTACHMENT_CATEGORY_WM', 2); // Windows Media Files - Streaming






define('ATTACHMENT_CATEGORY_RM', 3); // Real Media Files - Streaming






define('ATTACHMENT_CATEGORY_THUMB', 4); // Not used within the database, only while displaying posts






define('ATTACHMENT_CATEGORY_FLASH', 5); // Flash/SWF files






define('ATTACHMENT_CATEGORY_QUICKTIME', 6); // Quicktime/Mov files













// BBCode UID length






define('BBCODE_UID_LEN', 8);













// Number of core BBCodes






define('NUM_CORE_BBCODES', 12);













// Magic url types






define('MAGIC_URL_EMAIL', 1);






define('MAGIC_URL_FULL', 2);






define('MAGIC_URL_LOCAL', 3);






define('MAGIC_URL_WWW', 4);













// Profile Field Types






define('FIELD_INT', 1);






define('FIELD_STRING', 2);






define('FIELD_TEXT', 3);






define('FIELD_BOOL', 4);






define('FIELD_DROPDOWN', 5);






define('FIELD_DATE', 6);




















// Additional constants








define('HIDE_BBCODE_ID', 20);











// Table names






define('ACL_GROUPS_TABLE',			$table_prefix . 'acl_groups');






define('ACL_OPTIONS_TABLE',			$table_prefix . 'acl_options');






define('ACL_ROLES_DATA_TABLE',		$table_prefix . 'acl_roles_data');






define('ACL_ROLES_TABLE',			$table_prefix . 'acl_roles');






define('ACL_USERS_TABLE',			$table_prefix . 'acl_users');






define('ATTACHMENTS_TABLE',			$table_prefix . 'attachments');






define('BANLIST_TABLE',				$table_prefix . 'banlist');






define('BBCODES_TABLE',				$table_prefix . 'bbcodes');






define('BOOKMARKS_TABLE',			$table_prefix . 'bookmarks');






define('BOTS_TABLE',				$table_prefix . 'bots');






define('CONFIG_TABLE',				$table_prefix . 'config');






define('CONFIRM_TABLE',				$table_prefix . 'confirm');






define('DISALLOW_TABLE',			$table_prefix . 'disallow');






define('DRAFTS_TABLE',				$table_prefix . 'drafts');






define('EXTENSIONS_TABLE',			$table_prefix . 'extensions');






define('EXTENSION_GROUPS_TABLE',	$table_prefix . 'extension_groups');






define('FORUMS_TABLE',				$table_prefix . 'forums');






define('FORUMS_ACCESS_TABLE',		$table_prefix . 'forums_access');






define('FORUMS_TRACK_TABLE',		$table_prefix . 'forums_track');






define('FORUMS_WATCH_TABLE',		$table_prefix . 'forums_watch');






define('GROUPS_TABLE',				$table_prefix . 'groups');






define('ICONS_TABLE',				$table_prefix . 'icons');






define('LANG_TABLE',				$table_prefix . 'lang');






define('LOG_TABLE',					$table_prefix . 'log');






define('MODERATOR_CACHE_TABLE',		$table_prefix . 'moderator_cache');






define('MODULES_TABLE',				$table_prefix . 'modules');






define('POLL_OPTIONS_TABLE',		$table_prefix . 'poll_options');






define('POLL_VOTES_TABLE',			$table_prefix . 'poll_votes');






define('POSTS_TABLE',				$table_prefix . 'posts');






define('PRIVMSGS_TABLE',			$table_prefix . 'privmsgs');






define('PRIVMSGS_FOLDER_TABLE',		$table_prefix . 'privmsgs_folder');






define('PRIVMSGS_RULES_TABLE',		$table_prefix . 'privmsgs_rules');






define('PRIVMSGS_TO_TABLE',			$table_prefix . 'privmsgs_to');






define('PROFILE_FIELDS_TABLE',		$table_prefix . 'profile_fields');






define('PROFILE_FIELDS_DATA_TABLE',	$table_prefix . 'profile_fields_data');






define('PROFILE_FIELDS_LANG_TABLE',	$table_prefix . 'profile_fields_lang');






define('PROFILE_LANG_TABLE',		$table_prefix . 'profile_lang');






define('RANKS_TABLE',				$table_prefix . 'ranks');






define('REPORTS_TABLE',				$table_prefix . 'reports');






define('REPORTS_REASONS_TABLE',		$table_prefix . 'reports_reasons');






define('SEARCH_RESULTS_TABLE',		$table_prefix . 'search_results');






define('SEARCH_WORDLIST_TABLE',		$table_prefix . 'search_wordlist');






define('SEARCH_WORDMATCH_TABLE',	$table_prefix . 'search_wordmatch');






define('SESSIONS_TABLE',			$table_prefix . 'sessions');






define('SESSIONS_KEYS_TABLE',		$table_prefix . 'sessions_keys');






define('SITELIST_TABLE',			$table_prefix . 'sitelist');






define('SMILIES_TABLE',				$table_prefix . 'smilies');






define('STYLES_TABLE',				$table_prefix . 'styles');






define('STYLES_TEMPLATE_TABLE',		$table_prefix . 'styles_template');






define('STYLES_TEMPLATE_DATA_TABLE',$table_prefix . 'styles_template_data');






define('STYLES_THEME_TABLE',		$table_prefix . 'styles_theme');






define('STYLES_IMAGESET_TABLE',		$table_prefix . 'styles_imageset');






define('STYLES_IMAGESET_DATA_TABLE',$table_prefix . 'styles_imageset_data');






define('TOPICS_TABLE',				$table_prefix . 'topics');






define('TOPICS_POSTED_TABLE',		$table_prefix . 'topics_posted');






define('TOPICS_TRACK_TABLE',		$table_prefix . 'topics_track');






define('TOPICS_WATCH_TABLE',		$table_prefix . 'topics_watch');






define('USER_GROUP_TABLE',			$table_prefix . 'user_group');






define('USERS_TABLE',				$table_prefix . 'users');






define('WARNINGS_TABLE',			$table_prefix . 'warnings');






define('WORDS_TABLE',				$table_prefix . 'words');






define('ZEBRA_TABLE',				$table_prefix . 'zebra');













// Additional tables




















?>
Locked

Return to “[3.0.x] Abandoned MODs”