مرجع پارسی MyBB

صفحه‌ها: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
این ارورمیاد

http://aryapatogh.ir/admin/index.php?mod...f670cd7adc
دوستان ارور 1064 نیست و داخل متن ارور های رایج هم قرار نداره کسی هم پاسخ نداده و هیچ جا جوابی نداده شده که چرا اینطوری میشه ...
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci' at line 23
Query:
CREATE TABLE `mybb_games` ( `gid` INT(10) NOT NULL AUTO_INCREMENT, `cid` INT(5) NOT NULL, `title` VARCHAR(50) NOT NULL, `name` VARCHAR(50) NOT NULL, `description` TEXT NOT NULL, `what` TEXT NOT NULL, `use_keys` TEXT NOT NULL, `played` INT(15) DEFAULT '0' NOT NULL, `lastplayed` BIGINT(30) NOT NULL, `lastplayedby` INT(10) DEFAULT '0' NOT NULL, `bgcolor` VARCHAR(6) DEFAULT '000000' NOT NULL, `width` VARCHAR(4) DEFAULT '500' NOT NULL, `height` VARCHAR(4) DEFAULT '500' NOT NULL, `dateline` BIGINT(30) NOT NULL, `score_type` VARCHAR(5) DEFAULT 'DESC' NOT NULL, `rating` FLOAT NOT NULL, `numratings` INT(5) NOT NULL, `active` INT(1) DEFAULT '1' NOT NULL, PRIMARY KEY (`gid`), KEY `cid` (`cid`), KEY `active` (`active`) ) TYPE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;
Up Thread
یکی این موضوع لعنتی رو بررسی کنه بابا هر دقیقه ما باید به یکی التماس کنیم ...

یکی هم فقط میاد پاسخ مارو پاک میکنه ...

200 بار سرچ کردم 20000 تا پیام خصوصی دادم بابا یکی بیاد ببینه دیه ...

این ارور 1064 لعنتی برا چی میاد وقتی پلاگین رو نصب میکنم ؟؟
این نرم افزار روی دیتابیس من ((Table)) هاش رو ایجاد نمیکرد ...

حالا خودم ایجاد کردم و بخش بازی درست شد اما وقتی میرم تو صفحه ی بازی My این مشکل هست :

The Game Section Settings doesn't exist.

پلاگین رو غیر فعال و فعال هم میکنم اما درست نمیشه ...

میدونم مشکل از تنظیماتشه ولی نمیدونم کُدوم تنظیمات !!!

این کُد های پلاگینه :
کد php: 
<?php
/***************************************************************************
 *
 *   Game Section for MyBB
 *   Copyright: © 2006-2010 The Game Section Development Group
 *   
 *   Website: http://www.gamesection.org
 *   
 *   Last modified: 18/02/2010 by Paretje
 *
 ***************************************************************************/

/***************************************************************************
 *
 *   This program is free software: you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation, either version 3 of the License, or
 *   (at your option) any later version.
 *
 *   This program is distributed in the hope that it will be useful,
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *   GNU General Public License for more details.
 *
 *   You should have received a copy of the GNU General Public License
 *   along with this program.  If not, see <http://www.gnu.org/licenses/>.
 *
 ***************************************************************************/

// Disallow direct access to this file for security reasons
if(!defined("IN_MYBB"))
{
    die("Direct initialization of this file is not allowed.<br /><br />Please make sure IN_MYBB is defined.");
}

//Pluins
$plugins->add_hook("global_start", "games_global");
$plugins->add_hook("index_start", "games_index");
$plugins->add_hook("xmlhttp", "games_xmlhttp");
$plugins->add_hook("member_do_login_end", "games_member_login");
$plugins->add_hook("member_logout_end", "games_member_logout");
$plugins->add_hook("fetch_wol_activity_end", "games_online_activity");
$plugins->add_hook("build_friendly_wol_location_end", "games_online_location");
$plugins->add_hook("admin_tools_get_admin_log_action", "games_admin_log");
$plugins->add_hook("datahandler_user_update", "games_users_edit");
$plugins->add_hook("admin_user_users_merge_commit", "games_users_merge");
$plugins->add_hook("admin_user_users_delete_commit", "games_users_delete");
$plugins->add_hook("admin_user_groups_edit_graph_tabs", "games_groups_graph_tabs");
$plugins->add_hook("admin_user_groups_edit_graph", "games_groups_graph");
$plugins->add_hook("admin_user_groups_edit_commit", "games_groups_commit");

function games_info()
{
    return array(
        "name"        => "بخش بازي 1.2 RC5.1 Final",
        "description"    => "یک سیستم قدرتمند برای بازی کردن بر روی انجمن شما ایجاد می کند.",
        "website"    => "http://www.gamesection.org",
        "author"    => "Paretje | فارسی سازی توسط: MyBBIran.com - Cancer9003",
        "authorsite"    => "http://www.gamesection.org",
        "version"    => "1.2",
        "guid"        => "db37073977904e9458f54937ceb13a9f",
        "compatibility" => "14*,16*"
    );
}

function games_install()
{
    global $db, $cache;

//Create tables for the Game Section
$db->write_query("CREATE TABLE `".TABLE_PREFIX."games` (
`gid` INT(10) NOT NULL AUTO_INCREMENT,
`cid` INT(5) NOT NULL,
`title` VARCHAR(50) NOT NULL,
`name` VARCHAR(50) NOT NULL,
`description` TEXT NOT NULL,
`what` TEXT NOT NULL,
`use_keys` TEXT NOT NULL,
`played` INT(15) DEFAULT '0' NOT NULL,
`lastplayed` BIGINT(30) NOT NULL,
`lastplayedby` INT(10) DEFAULT '0' NOT NULL,
`bgcolor` VARCHAR(6) DEFAULT '000000' NOT NULL,
`width` VARCHAR(4) DEFAULT '500' NOT NULL,
`height` VARCHAR(4) DEFAULT '500' NOT NULL,
`dateline` BIGINT(30) NOT NULL,
`score_type` VARCHAR(5) DEFAULT 'DESC' NOT NULL,
`rating` FLOAT NOT NULL,
`numratings` INT(5) NOT NULL,
`active` INT(1) DEFAULT '1' NOT NULL,
PRIMARY KEY (`gid`),
KEY `cid` (`cid`),
KEY `active` (`active`)
) TYPE=MyISAM".$db->build_create_table_collation().";");

$db->write_query("CREATE TABLE `".TABLE_PREFIX."games_categories` (
`cid` INT(5) NOT NULL AUTO_INCREMENT,
`title` VARCHAR(40) NOT NULL,
`image` VARCHAR(255) NOT NULL,
`active` INT(1) DEFAULT '1' NOT NULL,
PRIMARY KEY (`cid`),
KEY `active` (`active`)
) TYPE=MyISAM".$db->build_create_table_collation().";");

$db->write_query("CREATE TABLE `".TABLE_PREFIX."games_champions` (
`gid` INT(10) NOT NULL,
`title` VARCHAR(50) NOT NULL,
`uid` INT(10) NOT NULL,
`username` VARCHAR(120) NOT NULL,
`score` FLOAT NOT NULL,
`dateline` BIGINT(30) NOT NULL,
PRIMARY KEY (`gid`)
) TYPE=MyISAM".$db->build_create_table_collation().";");

$db->write_query("CREATE TABLE `".TABLE_PREFIX."games_favourites` (
`fid` INT(15) NOT NULL AUTO_INCREMENT,
`gid` INT(10) NOT NULL,
`uid` INT(10) NOT NULL,
PRIMARY KEY (`fid`),
KEY `gid` (`gid`),
KEY `uid` (`uid`)
) TYPE=MyISAM".$db->build_create_table_collation().";");

$db->write_query("CREATE TABLE `".TABLE_PREFIX."games_rating` (
`rid` INT(15) NOT NULL AUTO_INCREMENT,
`gid` INT(10) NOT NULL,
`uid` INT(10) NOT NULL,
`username` VARCHAR(120) NOT NULL,
`rating` INT(1) NOT NULL,
`dateline` BIGINT(30) NOT NULL,
`ip` VARCHAR(30) NOT NULL,
PRIMARY KEY (`rid`),
KEY `gid` (`gid`),
KEY `uid` (`uid`)
) TYPE=MyISAM".$db->build_create_table_collation().";");

$db->write_query("CREATE TABLE `".TABLE_PREFIX."games_scores` (
`sid` INT(15) NOT NULL AUTO_INCREMENT,
`gid` INT(10) NOT NULL,
`uid` INT(10) NOT NULL,
`username` VARCHAR(120) NOT NULL,
`score` FLOAT NOT NULL,
`comment` VARCHAR(120) NOT NULL,
`dateline` BIGINT(30) NOT NULL,
`ip` VARCHAR(30) NOT NULL,
PRIMARY KEY (`sid`),
KEY `gid` (`gid`),
KEY `uid` (`uid`)
) TYPE=MyISAM".$db->build_create_table_collation().";");

$db->write_query("CREATE TABLE `".TABLE_PREFIX."games_sessions` (
`uid` INT(10) NOT NULL AUTO_INCREMENT,
`sessiondata` TEXT NOT NULL,
`lastchange` BIGINT(30) NOT NULL,
PRIMARY KEY (`uid`)
) TYPE=MyISAM".$db->build_create_table_collation().";");

$db->write_query("CREATE TABLE `".TABLE_PREFIX."games_settings` (
`sid` INT(5) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(120) NOT NULL,
`title` VARCHAR(120) NOT NULL,
`description` TEXT NOT NULL,
`optionscode` TEXT NOT NULL,
`value` TEXT NOT NULL,
`displayorder` INT(5) NOT NULL,
`gid` INT(5) NOT NULL,
PRIMARY KEY (`sid`),
KEY `gid` (`gid`)
) TYPE=MyISAM".$db->build_create_table_collation().";");

$db->write_query("CREATE TABLE `".TABLE_PREFIX."games_settings_groups` (
`gid` INT(5) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(120) NOT NULL,
`title` VARCHAR(200) NOT NULL,
`description` TEXT NOT NULL,
`displayorder` INT(5) NOT NULL,
PRIMARY KEY (`gid`)
) TYPE=MyISAM".$db->build_create_table_collation().";");

$db->write_query("CREATE TABLE `".TABLE_PREFIX."games_templates` (
`tid` INT(25) NOT NULL AUTO_INCREMENT,
`theme` INT(10) NOT NULL,
`title` VARCHAR(120) NOT NULL,
`template` TEXT NOT NULL,
PRIMARY KEY (`tid`)
) TYPE=MyISAM".$db->build_create_table_collation().";");

$db->write_query("CREATE TABLE `".TABLE_PREFIX."games_themes` (
`tid` INT(25) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(120) NOT NULL,
`directory` VARCHAR(120) NOT NULL DEFAULT 'images',
`catsperline` INT(2) NOT NULL DEFAULT '5',
`active` INT(1) NOT NULL DEFAULT '1',
`CSS` TEXT NOT NULL,
PRIMARY KEY (`tid`)
) TYPE=MyISAM".$db->build_create_table_collation().";");

$db->write_query("CREATE TABLE `".TABLE_PREFIX."games_tournaments` (
`tid` INT(10) NOT NULL AUTO_INCREMENT,
`gid` INT(10) NOT NULL,
`dateline` BIGINT(30) NOT NULL,
`rounds` INT(1) NOT NULL,
`roundtime` INT(1) NOT NULL,
`maxtries` INT(2) NOT NULL,
`joinedplayers` INT(3) NOT NULL DEFAULT '1',
`status` VARCHAR(10) NOT NULL DEFAULT 'open',
`round` INT(1) NOT NULL DEFAULT '0',
`champion` INT(10) NOT NULL,
`roundinformation` TEXT NOT NULL,
PRIMARY KEY (`tid`),
KEY `gid` (`gid`)
) TYPE=MyISAM".$db->build_create_table_collation().";");

$db->write_query("CREATE TABLE `".TABLE_PREFIX."games_tournaments_players` (
`pid` INT(15) NOT NULL AUTO_INCREMENT,
`tid` INT(10) NOT NULL,
`rid` INT(1) NOT NULL,
`uid` INT(10) NOT NULL,
`username` VARCHAR(120) NOT NULL,
`score` FLOAT NOT NULL,
`score_try` INT(2) NOT NULL,
`tries` INT(2) NOT NULL,
`dateline` BIGINT(30) NOT NULL,
PRIMARY KEY (`pid`),
KEY `tid` (`tid`),
KEY `rid` (`rid`),
KEY `uid` (`uid`)
) TYPE=MyISAM".$db->build_create_table_collation().";");

//Update MyBB tables for the Game Section
$db->write_query("ALTER TABLE `".TABLE_PREFIX."usergroups` ADD `canviewgames` INT(1) NOT NULL DEFAULT '1',
ADD `canplaygames` INT(1) NOT NULL DEFAULT '1',
ADD `canplaytournaments` INT(1) NOT NULL DEFAULT '1',
ADD `canaddtournaments` INT(1) NOT NULL DEFAULT '1';");

$db->write_query("ALTER TABLE `".TABLE_PREFIX."users`
ADD `games_maxgames` INT(2) NOT NULL DEFAULT '0',
ADD `games_maxscores` INT(2) NOT NULL DEFAULT '0',
ADD `games_sortby` VARCHAR(10) NOT NULL DEFAULT '0',
ADD `games_order` VARCHAR(4) NOT NULL DEFAULT '0',
ADD `games_theme` INT(10) NOT NULL DEFAULT '0',
ADD `games_tournamentnotify` INT(1) NOT NULL DEFAULT '1';");

$db->write_query("UPDATE ".TABLE_PREFIX."usergroups SET canviewgames='1', canplaygames='0', canplaytournaments='0', canaddtournaments='0' WHERE gid='1'");
$db->write_query("UPDATE ".TABLE_PREFIX."usergroups SET canviewgames='1', canplaygames='0', canplaytournaments='0', canaddtournaments='0' WHERE gid='5'");
$db->write_query("UPDATE ".TABLE_PREFIX."usergroups SET canviewgames='0', canplaygames='0', canplaytournaments='0', canaddtournaments='0' WHERE gid='7'");

//Update usergroupschache
$cache->update_usergroups();

//Update adminpermissions
change_admin_permission("games", false, 1);
change_admin_permission("games", "games", 1);
change_admin_permission("games", "gamedata", 1);
change_admin_permission("games", "categories", 1);
change_admin_permission("games", "settings", 1);
change_admin_permission("games", "themes", 1);
change_admin_permission("games", "templates", 1);
change_admin_permission("games", "tools", 1);
change_admin_permission("games", "version", 1);

//Insert tasks
require_once MYBB_ROOT."inc/functions_task.php";

$gamescleanup_insert = array(
    'title'        => addslashes("Game Section Cleanup"),
    'description'    => addslashes("Cleans old Game Section sessions"),
    'file'        => addslashes("gamescleanup"),
    'minute'    => addslashes("0"),
    'hour'        => addslashes("*"),
    'day'        => addslashes("*"),
    'month'        => addslashes("*"),
    'weekday'    => addslashes("*"),
    'enabled'    => intval("1"),
    'logging'    => intval("1")
);
$gamescleanup_insert['nextrun'] = fetch_next_run($gamescleanup_insert);

$tournamentstatus_insert = array(
    'title'        => addslashes("Game Section Tournament Status"),
    'description'    => addslashes("Automaticaly changes the status of a Game Section Tournament"),
    'file'        => addslashes("tournamentstatus"),
    'minute'    => addslashes("0"),
    'hour'        => addslashes("*"),
    'day'        => addslashes("*"),
    'month'        => addslashes("*"),
    'weekday'    => addslashes("*"),
    'enabled'    => intval("1"),
    'logging'    => intval("1")
);
$tournamentstatus_insert['nextrun'] = fetch_next_run($tournamentstatus_insert);

$db->insert_query("tasks", $gamescleanup_insert);
$db->insert_query("tasks", $tournamentstatus_insert);

//Insert the default game of the Game Section
$game_insert = array(
    'cid'        => intval("0"),
    'title'        => addslashes("Pacman"),
    'name'        => addslashes("pacman"),
    'description'    => addslashes("Eat all the little dots without letting the ghosts get you!"),
    'what'        => addslashes("Eat all of the dots."),
    'use_keys'    => addslashes("Arrow keys to move."),
    'bgcolor'    => addslashes("000000"),
    'active'    => intval("1"),
    'width'        => addslashes("360"),
    'height'    => addslashes("420"),
    'dateline'    => TIME_NOW,
    'score_type'    => addslashes("DESC")
);

$db->insert_query("games", $game_insert);

//Load settings and settinggroups
require_once MYBB_ROOT."games/settings.php";

//Insert setting groups
foreach($settings_groups as $key => $group)
{
    $group_insert = array(
        'gid'        => $group['gid'],
        'name'        => $group['name'],
        'title'        => $group['title'],
        'description'    => $group['description'],
        'displayorder'    => $group['displayorder']
    );
    
    $db->insert_query("games_settings_groups", $group_insert);
}

//Insert settings
foreach($new_settings as $key => $setting)
{
    $setting_insert = array(
        'name'        => $setting['name'],
        'title'        => $setting['title'],
        'description'    => $setting['description'],
        'optionscode'    => $setting['optionscode'],
        'value'        => $setting['value'],
        'displayorder'    => $setting['displayorder'],
        'gid'        => $setting['gid']
    );
    
    $db->insert_query("games_settings", $setting_insert);
}

//Load theme and templates
require_once MYBB_ROOT."games/templates.php";

//Insert Game Section theme
$new_theme = array(
    'name'        => addslashes($theme['name']),
    'directory'    => addslashes($theme['directory']),
    'catsperline'    => addslashes($theme['catsperline']),
    'active'    => intval("1"),
    'CSS'        => addslashes($theme['css'])
);

$db->insert_query("games_themes", $new_theme);

// Insert Game Section templates
foreach($theme_templates as $title => $template)
{
    $template_insert = array(
        "theme"        => "1",
        "title"        => $title,
        "template"    => $template
    );
    
    $db->insert_query("games_templates", $template_insert);
}
}

function games_uninstall()
{
    global $db, $cache;

//Delete Game Section tables
$db->write_query("DROP TABLE `".TABLE_PREFIX."games`,
`".TABLE_PREFIX."games_categories`,
`".TABLE_PREFIX."games_champions`,
`".TABLE_PREFIX."games_favourites`,
`".TABLE_PREFIX."games_rating`,
`".TABLE_PREFIX."games_scores`,
`".TABLE_PREFIX."games_sessions`,
`".TABLE_PREFIX."games_settings`,
`".TABLE_PREFIX."games_settings_groups`,
`".TABLE_PREFIX."games_templates`,
`".TABLE_PREFIX."games_themes`,
`".TABLE_PREFIX."games_tournaments`,
`".TABLE_PREFIX."games_tournaments_players`;");

//Delete Game Section updates of the MyBB tables
$db->write_query("ALTER TABLE `".TABLE_PREFIX."usergroups` DROP `canviewgames`,
DROP `canplaygames`,
DROP `canplaytournaments`,
DROP `canaddtournaments`;");

$db->write_query("ALTER TABLE `".TABLE_PREFIX."users`
DROP `games_maxgames`,
DROP `games_maxscores`,
DROP `games_sortby`,
DROP `games_order`,
DROP `games_theme`,
DROP `games_tournamentnotify`;");

//Update usergroupschache
$cache->update_usergroups();

//Update adminpermissions
change_admin_permission("games", false, -1);
change_admin_permission("games", "games", -1);
change_admin_permission("games", "gamedata", -1);
change_admin_permission("games", "categories", -1);
change_admin_permission("games", "settings", -1);
change_admin_permission("games", "themes", -1);
change_admin_permission("games", "templates", -1);
change_admin_permission("games", "tools", -1);
change_admin_permission("games", "version", -1);

//Delete tasks
$db->delete_query("tasks", "file='gamescleanup'");
$db->delete_query("tasks", "file='tournamentstatus'");
}

function games_activate()
{
    global $db;

//Update MyBB templates
require_once MYBB_ROOT.'inc/adminfunctions_templates.php';

find_replace_templatesets('header', '#'.preg_quote('{$lang->toplinks_help}</a></li>').'#', "{\$lang->toplinks_help}</a></li>
                    <li><a href=\"{\$mybb->settings['bburl']}/games.php\"><img src=\"{\$mybb->settings['bburl']}/games/images/games.png\" alt=\"\" />{\$lang->gamesection}</a></li>");

find_replace_templatesets('usercp_nav', '#'.preg_quote('{$usercpmenu}').'#', "{\$usercpmenu}
<tr>
    <td class=\"tcat\">
        <div class=\"expcolimage\"><img src=\"{\$theme['imgdir']}/collapse{\$collapsedimg['usercpgames']}.gif\" id=\"usercpgames_img\" class=\"expander\" alt=\"[-]\" title=\"[-]\" /></div>
        <div><span class=\"smalltext\"><strong>{\$lang->gamesection}</strong></span></div>
    </td>
</tr>
<tbody style=\"{\$collapsed['usercpgames_e']}\" id=\"usercpgames_e\">
    <tr><td class=\"trow1 smalltext\"><a href=\"games.php?action=settings\" class=\"usercp_nav_item usercp_nav_options\">{\$lang->your_settings}</a></td></tr>
</tbody>");
}

function games_deactivate()
{
    global $db, $cache;

//Delete Game Section updates of the MyBB templates
require_once MYBB_ROOT."inc/adminfunctions_templates.php";

find_replace_templatesets("header", '#'.preg_quote('
                    <li><a href="{$mybb->settings[\'bburl\']}/games.php"><img src="{$mybb->settings[\'bburl\']}/games/images/games.png" alt="" />{$lang->gamesection}</a></li>').'#', '', 0);

find_replace_templatesets("usercp_nav", '#'.preg_quote('
<tr>
    <td class="tcat">
        <div class="expcolimage"><img src="{$theme[\'imgdir\']}/collapse{$collapsedimg[\'usercpgames\']}.gif" id="usercpgames_img" class="expander" alt="[-]" title="[-]" /></div>
        <div><span class="smalltext"><strong>{$lang->gamesection}</strong></span></div>
    </td>
</tr>
<tbody style="{$collapsed[\'usercpgames_e\']}" id="usercpgames_e">
    <tr><td class="trow1 smalltext"><a href="games.php?action=settings" class="usercp_nav_item usercp_nav_options">{$lang->your_settings}</a></td></tr>
</tbody>').'#', '', 0);
}

function games_is_installed()
{
    global $db;
    
    if($db->table_exists("games"))
    {
        return true;
    }
    
    return false;
}

function games_global()
{
    global $lang;
    
    //Loading language file
    $lang->load("games");
}

function games_index()
{
    global $mybb, $db, $lang, $plugins;
    
    //Headers to prevent that the browser holds this page in his cache
    header("Expires: Sat, 1 Jan 2000 01:00:00 GMT");
    header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
    header("Cache-Control: no-cache, must-revalidate");
    header("Pragma: no-cache");
    
    //IBProArcade v2 insert of a score
    switch($mybb->input['act'])
    {
        case 'Arcade':
            switch($mybb->input['do'])
            {
                case 'newscore':
                    require_once MYBB_ROOT."games/submit.php";
                break;
            }
        break;
    }
    
    //IBProArcade v32 insert of a score
    switch($mybb->input['autocom'])
    {
        case 'arcade':
            switch($mybb->input['do'])
            {
                case 'verifyscore':
                    $randchar1 = rand(1, 200);
                    $randchar2 = rand(1, 200);
                    
                    require_once MYBB_ROOT."inc/class_games.php";
                    $games_core = new games;
                    
                    $games_core->session_start();
                    $games_core->session['randchar1'] = $randchar1;
                    $games_core->session['randchar2'] = $randchar2;
                    $games_core->session_update();
                    
                    echo("&randchar=".$randchar1."&randchar2=".$randchar2."&savescore=1&blah=OK");
                    exit;
                break;
                case 'savescore':
                    require_once MYBB_ROOT."games/submit.php";
                break;
                case 'newscore':
                    require_once MYBB_ROOT."games/submit.php";
                break;
            }
        break;
    }
}

function games_xmlhttp()
{
    global $mybb, $lang, $groupscache, $db, $charset, $theme_games, $plugins;
    
    //Game Section core settings, themes, ...
    if($mybb->input['action'] == "games_randomgames" || $mybb->input['action'] == "games_search")
    {
        //Games language
        $lang->load("games");
        
        //Requires
        require_once MYBB_ROOT."inc/class_games.php";
        $games_core = new games;
        
        //Settings of the Game Section
        $games_core->run_settings();
        
        //Game Section closed
        if($games_core->settings['closed'] == 1 && $mybb->user['usergroup'] != 4)
        {
            xmlhttp_error($lang->closed);
        }
        
        //Theme setting
        if($mybb->user['uid'] != 0 && $mybb->user['games_theme'] != "0")
        {
            $theme_games_tid = $mybb->user['games_theme'];
        }
        else
        {
            $theme_games_tid = $games_core->settings['theme'];
        }
        
        //Game Section Theme
        $query = $db->query("SELECT * FROM ".TABLE_PREFIX."games_themes WHERE tid='".$theme_games_tid."'");
        $theme_games = $db->fetch_array($query);
        $theme_games_test = $db->num_rows($query);
        
        if($theme_games_test == 0)
        {
            //The user selected theme doesn't exist, load the default theme
            $query = $db->query("SELECT * FROM ".TABLE_PREFIX."games_themes WHERE tid='".$games_core->settings['theme']."'");
            $theme_games = $db->fetch_array($query);
            $theme_games_test2 = $db->num_rows($query);
        }
        else
        {
            $theme_games_test2 = 1;
        }
        
        if($theme_games_test2 == 0)
        {
            //The standard theme doesn't exist, load the default Game Section theme
            $query = $db->query("SELECT * FROM ".TABLE_PREFIX."games_themes WHERE tid='1'");
            $theme_games = $db->fetch_array($query);
            $theme_games_test3 = $db->num_rows($query);
        }
        else
        {
            $theme_games_test3 = 1;
        }
        
        //No theme available
        if($theme_games_test3 == 0)
        {
            xmlhttp_error("The users selected theme, the default theme and the Game Section Default theme doesn't exist.");
        }
    }
    
    //Functions
    if($mybb->input['action'] == "games_randomgames")
    {
        //Category settings
        if(intval($mybb->input['cid']) != 0 && $games_core->settings['stats_cats'] == 1)
        {
            $where_cat = " AND cid='".$mybb->input['cid']."'";
        }
        
        //Put games in array
        $query = $db->query("SELECT gid, name, title FROM ".TABLE_PREFIX."games WHERE active='1'".$where_cat." ORDER BY dateline");
        while($game = $db->fetch_array($query))
        {
            $games[] = $game;
        }
        
        //Load x random games
        for($i = 1; $i <= $games_core->settings['stats_randomgames_max']; $i++)
        {
            $id = mt_rand(0, count($games)-1);
            eval("\$randomgames_bit .= \"".$games_core->template("games_stats_randomgames_bit")."\";");
        }
        
        //Output
        header("Content-type: text/plain; charset=".$charset);
        echo $randomgames_bit;
    }
    elseif($mybb->input['action'] == "games_search")
    {
        $title = $mybb->input['title'];
        
        // If the string is less than 3 characters, quit.
        if(my_strlen($mybb->input['title']) < 3)
        {
            exit;
        }
        
        //Load games
        $query = $db->query("SELECT * FROM ".TABLE_PREFIX."games WHERE title LIKE '%".$title."%' AND active='1' ORDER BY title ASC");
        $games_test = $db->num_rows($query);
        
        if($games_test != 0)
        {
            while($games = $db->fetch_array($query))
            {
                eval("\$games_bit .= \"".$games_core->template("games_tournaments_add_game_search_bit")."\";");
            }
            
            //Output
            header("Content-type: text/plain; charset=".$charset);
            eval("\$results = \"".$games_core->template("games_tournaments_add_game_search")."\";");
            echo $results;
        }
    }
}

function games_member_login()
{
    global $user, $db;
    
    //Delete Game Section session of user
    $db->write_query("DELETE FROM ".TABLE_PREFIX."games_sessions WHERE uid='".$user['uid']."'");
}

function games_member_logout()
{
    global $mybb, $db;
    
    //Delete Game Section session of user
    $db->write_query("DELETE FROM ".TABLE_PREFIX."games_sessions WHERE uid='".$mybb->user['uid']."'");
}

function games_online_activity($user_activity)
{
    //Get the filename
    $split_loc = explode(".php", $user_activity['location']);
    $filename = my_substr($split_loc[0], -my_strpos(strrev($split_loc[0]), "/"));
    
    if($user_activity['activity'] == "unknown" && $filename == "games")
    {
        $user_activity['activity'] = "games";
        
        return $user_activity;
    }
}

function games_online_location($plugin_array)
{
    global $lang;
    
    if($plugin_array['user_activity']['activity'] == "games")
    {
        $plugin_array['location_name'] = $lang->sprintf($lang->viewing_gamesection, str_replace("&amp;", "&", $plugin_array['user_activity']['location']));
        
        return $plugin_array;
    }
}

function games_admin_log($plugin_array)
{
    if($plugin_array['lang_string'] == "admin_log_games_gamedata_delete")
    {
        if($plugin_array['logitem']['data'][0] == "file")
        {
            $plugin_array['lang_string'] .= "_file";
        }
        elseif($plugin_array['logitem']['data'][0] == "dir")
        {
            $plugin_array['lang_string'] .= "_dir";
        }
        
        return $plugin_array;
    }
}

function games_users_edit($user)
{
    global $old_user, $db;
    if($user->user_update_data['username'] != $old_user['username'] && $user->user_update_data['username'] != '')
    {
        $username_update = array(
            "username" => $user->user_update_data['username']
        );
        
        //Update all champions and scores
        $db->update_query("games_champions", $username_update, "uid='".$user->uid."'");
        $db->update_query("games_scores", $username_update, "uid='".$user->uid."'");
    }
    
    return $user;
}

function games_users_merge()
{
    global $source_user, $destination_user, $db;
    
    $user_update = array(
        "uid"        => $destination_user['uid'],
        "username"    => $destination_user['username']
    );
    
    $uid_update['uid'] = $destuser['uid'];
    
    //Update all champions and scores
    $db->update_query("games_champions", $user_update, "uid='".$source_user['uid']."'");
    $db->update_query("games_favourites", $uid_update, "uid='".$source_user['uid']."'");
    $db->update_query("games_rating", $user_update, "uid='".$source_user['uid']."'");
    $db->update_query("games_scores", $user_update, "uid='".$source_user['uid']."'");
    
    //Delete session of source user
    $db->write_query("DELETE FROM ".TABLE_PREFIX."games_sessions WHERE uid='".$source_user['uid']."'");
    
    //Delete all duplicated favourites
    $query = $db->query("SELECT * FROM ".TABLE_PREFIX."games_favourites WHERE uid='".$destination_user['uid']."'");
    while($favourites = $db->fetch_array($query))
    {
        if(!isset($favourite[$favourites['gid']]))
        {
            $favourite[$favourites['gid']] = "OK";
        }
        else
        {
            $db->delete_query("games_favourites", "fid='".$favourites['fid']."'");
        }
    }
    
    //Delete all duplicated ratings
    $query = $db->query("SELECT * FROM ".TABLE_PREFIX."games_rating ORDER BY rating DESC");
    while($rating = $db->fetch_array($query))
    {
        //Control double ratings
        if(!isset($ratings[$rating['gid']][$rating['uid']]))
        {
            $ratings[$rating['gid']][$rating['uid']] = "OK";
        }
        else
        {
            $db->delete_query("games_rating", "rid='".$rating['rid']."'");
        }
        
        //Rate count_chars
        $ratings[$rating['gid']]['rating'] += $rating['rating'];
        
        //Count ratings
        $ratings[$rating['gid']]['rate_count']++;
    }
    
    //Recount rating
    $query2 = $db->query("SELECT * FROM ".TABLE_PREFIX."games");
    while($games = $db->fetch_array($query2))
    {
        if($ratings[$games['gid']]['rate_count'] != 0)
        {
            $rating = $ratings[$games['gid']]['rating'] / $ratings[$games['gid']]['rate_count'];
            $rating = ceil($rating);
            
            $db->write_query("UPDATE ".TABLE_PREFIX."games SET rating='".$rating."' WHERE gid='".$games['gid']."'");
        }
    }
    
    //Delete all duplicated scores (DESC)
    $query = $db->query("SELECT *
    FROM ".TABLE_PREFIX."games_scores s
    LEFT JOIN ".TABLE_PREFIX."games g ON (s.gid=g.gid)
    WHERE g.score_type='DESC' AND s.uid='".$destination_user['uid']."'
    ORDER BY s.score DESC");
    while($scores = $db->fetch_array($query))
    {
        if(!isset($score[$scores['gid']]))
        {
            $score[$scores['gid']] = "OK";
        }
        else
        {
            $db->delete_query("games_scores", "sid='".$scores['sid']."'");
        }
    }
    
    //Delete all duplicated scores (ASC)
    $query = $db->query("SELECT *
    FROM ".TABLE_PREFIX."games_scores s
    LEFT JOIN ".TABLE_PREFIX."games g ON (s.gid=g.gid)
    WHERE g.score_type='ASC' AND s.uid='".$destination_user['uid']."'
    ORDER BY s.score ASC");
    while($scores = $db->fetch_array($query))
    {
        if(!isset($score[$scores['gid']]))
        {
            $score[$scores['gid']] = "OK";
        }
        else
        {
            $db->delete_query("games_scores", "sid='".$scores['sid']."'");
        }
    }
}

function games_users_delete()
{
    global $user, $db;
    
    //Delete all favourites, ratings and scores
    $db->write_query("DELETE FROM ".TABLE_PREFIX."games_favourites WHERE uid='".$user['uid']."'");
    $db->write_query("DELETE FROM ".TABLE_PREFIX."games_rating WHERE uid='".$user['uid']."'");
    $db->write_query("DELETE FROM ".TABLE_PREFIX."games_scores WHERE uid='".$user['uid']."'");
    $db->write_query("DELETE FROM ".TABLE_PREFIX."games_sessions WHERE uid='".$user['uid']."'");
    
    //Update champions
    //Loading the games and scores
    $query = $db->query("SELECT DISTINCT g.gid, g.score_type, g.title, s.uid, s.username, s.score, s.dateline, c.score AS champscore
    FROM ".TABLE_PREFIX."games g
    LEFT JOIN ".TABLE_PREFIX."games_scores s ON (g.gid=s.gid)
    LEFT JOIN ".TABLE_PREFIX."games_champions c ON (g.gid=c.gid)
    WHERE c.uid='".$user['uid']."'");
    while($scores = $db->fetch_array($query))
    {
        if(($champ[$scores['gid']]['score'] < $scores['score'] && $scores['score_type'] == DESC) || ($champ[$scores['gid']]['score'] > $scores['score'] && $score['score_type'] == ASC))
        {
            $champ[$scores['gid']]['gid'] = $scores['gid'];
            $champ[$scores['gid']]['title'] = $scores['title'];
            $champ[$scores['gid']]['uid'] = $scores['uid'];
            $champ[$scores['gid']]['username'] = $scores['username'];
            $champ[$scores['gid']]['score'] = $scores['score'];
            $champ[$scores['gid']]['dateline'] = $scores['dateline'];
        }
    }
    
    //Read the array
    if(is_array($champ))
    {
        foreach($champ as $gid => $array)
        {
            $champs_array = array(
                'gid'            => intval($champ[$gid]['gid']),
                'title'            => addslashes($champ[$gid]['title']),
                'uid'            => intval($champ[$gid]['uid']),
                'username'        => addslashes($champ[$gid]['username']),
                'score'            => addslashes($champ[$gid]['score']),
                'dateline'        => addslashes($champ[$gid]['dateline']),
            );
            
            $db->update_query("games_champions", $champs_array, "gid='".$champ[$gid]['gid']."'");
        }
    }
    
    //Delete champions without a second score
    $db->delete_query("games_champions", "uid='".$user['uid']."'");
}

function games_groups_graph_tabs($tabs)
{
    global $lang;
    
    $tabs['games'] = $lang->gamesection;
    
    return $tabs;
}

function games_groups_graph()
{
    global $lang, $form, $mybb, $plugins;
    
    //The Game Section Permissions
    echo "<div id=\"tab_games\">";    
    $form_container = new FormContainer($lang->gamesection);
    
    $general_options = array(
        $form->generate_check_box("canviewgames", 1, $lang->can_view_games, array("checked" => $mybb->input['canviewgames'])),
        $form->generate_check_box("canplaygames", 1, $lang->can_play_games, array("checked" => $mybb->input['canplaygames']))
    );
    $form_container->output_row($lang->gamesection, "", "<div class=\"group_settings_bit\">".implode("</div><div class=\"group_settings_bit\">", $general_options)."</div>");
    
    $tournaments_options = array(
        $form->generate_check_box("canplaytournaments", 1, $lang->can_play_tournaments, array("checked" => $mybb->input['canplaytournaments'])),
        $form->generate_check_box("canaddtournaments", 1, $lang->can_add_tournaments, array("checked" => $mybb->input['canaddtournaments']))
    );
    $form_container->output_row($lang->tournaments, "", "<div class=\"group_settings_bit\">".implode("</div><div class=\"group_settings_bit\">", $tournaments_options)."</div>");
    
    //Plugin
    $plugins->run_hooks_by_ref("admin_user_groups_edit_games", $form_container);
    
    $form_container->end();
    echo "</div>";
}

function games_groups_commit()
{
    global $updated_group, $mybb;
    
    $updated_group['canviewgames'] = $mybb->input['canviewgames'];
    $updated_group['canplaygames'] = $mybb->input['canplaygames'];
    $updated_group['canplaytournaments'] = $mybb->input['canplaytournaments'];
    $updated_group['canaddtournaments'] = $mybb->input['canaddtournaments'];
}
?>
حوصلم سر رفت ولی خب واسه بچه های مای بی بی ایرانه دیگه چه کنیم

چند تا بازی براتون آمآده کردم Heart
http://uploadtak.com/images/9558_jojok.zip

من میدونم و تو اگه لایک ندی Big Grin
شوخی کردم
خیلی خوبه. مرسی
نقل‌قول: یکی این موضوع لعنتی رو بررسی کنه بابا هر دقیقه ما باید به یکی التماس کنیم ...

یکی هم فقط میاد پاسخ مارو پاک میکنه ...

200 بار سرچ کردم 20000 تا پیام خصوصی دادم بابا یکی بیاد ببینه دیه ...

این ارور 1064 لعنتی برا چی میاد وقتی پلاگین رو نصب میکنم ؟؟

[تصویر: 1459452134.png]
دوست عزیزبه فایل پلاگین مراجعه کن و TYPE=MyISAM
روحذف کن
سلام
پلاگینو نصب کردم بخش بازی به انجمن اضافه شده منتها وقتی روی بخش بازی توی انجمن کلیک میکنم این ارور میاد :
[تصویر: 94119538783871251861.jpg]
اگه بازی روش نصب کنم درست میشه؟!
و یه مشکل دیگه این که اون سایتی که باید ازش بازی دانلود کنیم باید اول توش عضو بشیم و موقع عضویتم ارور میده
چه باید کرد؟!!! Huh
تنظیمات اعمال کن
صفحه‌ها: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
rozgar

barbod_cigari

barbod_cigari

barbod_cigari

barbod_cigari

moghaddam

poyagh

jan123

mgt1234

jan123
