طريقة التحويل من منتديات "أحلى منتدى" إلى منتدى phpBB3

[m-designer-2009]

?? ??? ??????? ????? ????? ??????? ?? ????? ?? ???? ???? ????? ??? ????? phpBB3

????? ?????? ????? ???? ?? ??????? ???? ??????
??????? ??? ????? ?? ?? ??????? ?? ???? ???? ????? ????? ?? ??? ???? ???? ????? ???? ??? ?? ?????? ????? ?????? ??? ????? ???????? ?????? ???????.????? ???? ??? ?? ????? ?????? ?????? ??? ????? ?????? ????? ??? ??? ????? ???? ????? ????????.

- ?? ????? ????? ???????? ????
?? ????? ???????? ???? ??????? ??? ?????? ??????? ?? ?? ??? ???? ???? ?????? ????? ????? ????????? ??? ???????? ?????????? ?????????? ???????? ?? ??? ??????? ???? ?? ????? ????????.

-?? ????? ????? ??? ????? ?????????
????? ???? ????? ???????? ??? ?? ??? ?? ????? ????? ???? ?????? ??? ????? ???? ????? ??????? ??? ????????? ???????? ??????? ???????? ?????????? ??????? ??????? ??? Domain Name
??? ??? ??? ?????? ??????? ?? ???? ???? ????? ???? ????? ??? ?????? ????? ???? ??????? ?????? ????? ???? ?????
???:
XXXXXX.ahlamontada.com
??
XXXXXX.yoo7.com
?? ??? ??? ??????? ????????
??? ??? ?????? ????????? ???????? ???? ?? ???? ??? ??????
????
http://www.example.com
???? ???? ??????? ?? ??? ?????? ??? ?? ??????? ?? ?????? ??? ??? ??? ????? ???????? ??????? ?? ??????? ???????
???? ?? ??? ??? ???????? ??? ??????? ?????? ???? ??? ???? ?? ??? ????? ?? ?????? ???? ???? ??? ???? ????? ?? ????? ???? ?? ????? ?????? ????? ?? ????????? ??? ??? ???? ?????? ????? ?????? ??? ????? ??????? ??? ???

?? ??????? ???? ?? ?? ???? ?????? ????? ??????? ????? ???????

????? ?????? ??? ??? ??????? ??? ???? ??? ????? ?? 30 ?????
??? ????
?????? ??? ??? ????? ??? ?? ???? ?????? ???.
???? ???? ????? ??????? ???????? ???.
????? ???? ????? ????? ??????? ??????? ??????? ?? ????????? ??? ????? ????????.

??? ???????? ??????? ?? ???????? ?????? ????? ?? Python
??? ???? ???? ?????? ??????? ?? ???? ???????? ?????????? ???????? ??? ????? ???? ?? ??? phpBB3 ???? ?? ??? ??????? ?????.
???????? ??? ?????? ?? ??? ?????? ???????? ????? ????? ?? ???? phpBB.com ?????? ???? ?????? ????? ???? ?????? ?? ????? ???? ???? ?????? ???? ??????.

?? ??? ?????? ??????? ?????? ???????? ????? ????? ?? ??? Word

Convert.zip

(25.74 KiB) حُمِّل 4033 مرةً

????? ?? ?????? ??? ???????? ??? ?? ????? ?? ??? ?? ???????? ???? ?????? ??????? ?? ?????? ???? ????? ??? ????? ????? ??? ??????? ??.

[m-designer-2009]

??? ?? ???? ?? ???? ??????? ?? ?????? ??????? Profile

???? ?? : ?? ?? ??? ???? ?????????? ?? ???? ????? ???????

?? ???? ?????? ?? ?????????? ???? ????? ?????????? ? ???? ???? ??????? ??????? "2008-03-29, 19:46"

??????? ?? ??? ???????:
1- ???? ?? ????? ?????? MySQL
2- ????? ???? ??? ??????
3 - ????? Python ????? ????? ?????? ?? ???? python.org

???? ?? ?????? ??? ????????? ?? settings.py (?? ?????? ?????) ?????? ???? ????????? ?? ?? notepad ++

????? : table_prefix

?? ?? ??? prefix ?

?? ????? ??????? ???? ????????? ?? ??? ??? ?? ???? ?? ????? ????? ????????
prefix ????????? ?? phpBB ??

كود: تحديد الكل

phpbb_

?????? : COOKIEDATA

????? ???? ??????? /

???? ?????? ?? ???? ????? ? ?? ???? ????? ?????? /

كود: تحديد الكل

javascript:document.cookie

?? ?????? ? ????? ???? ???? ??? ???? ?? ?????? ????? ???? ?????? ??????? ' '


?????? : ????? URL
???? ?????? ?? ????? ?? ???? ?????
???: http://myboard.forumotion.com/



?????? : ???????? ???????

??? ???? ?? ??? ????? ??????? ??????? ?? ?????? ??? ?????? ?? ??????? ????? viewtopic.php?f=32&t=34
??? ??????? ?? 34 ????? ??? ?? ??? ????? ? ????? ?????? ,
????? ??? ?? ???? ????

كود: تحديد الكل

sticky=[1,2,3,4,5]

?????? : ???? ???? ????? ???? ?? ?????? ??????? ????? ?????? ????? ?????? ???? ?????

?????? : ??????? ???????
????? ???? ???? ??????? ? ??? ???? ???????? ???? ?????? ?? ??? ???? ??? ? ?? ???? ???? ?????? ???? ??? ?? ??? ????? ???????



?????? ??????? NUMUSERS
??? ??????? ID ????? ???? ??? ? ????? ????? ??? ?? ID ??? ??? ???? ????

memberlist.php?mode=viewprofile&u=50

ID ??? ??? ???? ?? 50

???? ?? ?????? ?????? Python ???? ???? members_topics_posts.py ??
???????? Windows: ???? ???? ??? ?????? ?????? "python members_topics_posts.py" ????)

?? ?? ?????? ?????? ????? ?? SQL ???? ???? members.sql ?topics_posts.sql ?categories_forums.sql ?? ????? ?????? ???????

? ?????? ??????? ?????? ?????? (???? ?? ??????? ????????) ?? ?????? ??? ??pm_passwords.py (?? ?????? settings.py ????? ?????? ?????????).

?? ??? in settings.py
????? ??????? msgtitle
????? ??????? ??????? ???? ???? ???????

????? ??????? msgbody
???? ???? ????? ?? ?????? ??????? ???????

?????? ?????? /

كود: تحديد الكل

%%0A

?? ???? ??? ???? ??? ??????? ???????? ??? ????

كود: تحديد الكل

%s

?? ???? ??? ??? ???? ???? ?????? (?? ?????????? ??? ?????)

?? ??? ????? ????? ?????? ??? ???

??????? /

??????? phpBB3 ?? ?????? ?????? ?????????? ? ??? ????????? ???? ????????
(???? ??? ?? ?????? ???????? ????? ???? ?????? )
?? ??????? ??? ???? ??????? ?? ???? ?? ?? ??????? ??? ???? ????? ?? ?? ?????? ???? ??????? ????? ?????
(??? ??? ?? ??? ???? ????? ????? ?? ???? ?? ?????? ???? ?????)

?? ???? ?????? ?? ??? ? ?? ??????? resync_bbcode.php

كود: تحديد الكل

<?php
/**
* The file must be named resync_bbcode.php
*/

define('IN_PHPBB', true);
$phpbb_root_path = ((isset($phpbb_root_path)) ? $phpbb_root_path : './');
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);

// Start session management
$user->session_begin();
$auth->acl($user->data);
$user->setup('posting');

$start = intval(request_var('start', 0));
$limit = 200;

include($phpbb_root_path . 'includes/message_parser.' . $phpEx);

$bbcode_status    = ($config['allow_bbcode']) ? true : false;
$img_status        = ($bbcode_status) ? true : false;
$flash_status    = ($bbcode_status && $config['allow_post_flash']) ? true : false;

$sql = 'SELECT * FROM ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . ' t
    WHERE t.topic_id = p.topic_id
        ORDER BY p.post_id ASC
            LIMIT ' . $start . ', ' . $limit;
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
    decode_message($row['post_text'], $row['bbcode_uid']);

    $message_parser = new parse_message();
    $message_parser->message = str_replace('"', '&quot;', html_entity_decode($row['post_text']));
    $message_parser->parse((($bbcode_status) ? $row['enable_bbcode'] : false), (($config['allow_post_links']) ? $row['enable_magic_url'] : false), $row['enable_smilies'], $img_status, $flash_status, true, $config['allow_post_links']);

    if ($row['poll_title'] && $row['post_id'] == $row['topic_first_post_id'])
    {
        $row['poll_option_text'] = '';
        $sql = 'SELECT * FROM ' . POLL_OPTIONS_TABLE . ' WHERE topic_id = ' . $row['topic_id'];
        $result2 = $db->sql_query($sql);
        while ($row2 = $db->sql_fetchrow($result2))
        {
            $row['poll_option_text'] .= $row2['poll_option_text'] . "\n";
        }
        $db->sql_freeresult($result2);

        $poll = array(
            'poll_title'        => $row['poll_title'],
            'poll_length'        => $row['poll_length'],
            'poll_max_options'    => $row['poll_max_options'],
            'poll_option_text'    => $row['poll_option_text'],
            'poll_start'        => $row['poll_start'],
            'poll_last_vote'    => $row['poll_last_vote'],
            'poll_vote_change'    => $row['poll_vote_change'],
            'enable_bbcode'        => $row['enable_bbcode'],
            'enable_urls'        => $row['enable_magic_url'],
            'enable_smilies'    => $row['enable_smilies'],
            'img_status'        => $img_status
        );

        $message_parser->parse_poll($poll);
    }

    $sql_data = array(
        'post_text'            => $message_parser->message,
        'post_checksum'        => md5($message_parser->message),
        'bbcode_bitfield'    => $message_parser->bbcode_bitfield,
        'bbcode_uid'        => $message_parser->bbcode_uid,
    );

    $sql = 'UPDATE ' . POSTS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_data) . '
        WHERE post_id = ' . $row['post_id'];
    $db->sql_query($sql);

    if ($row['poll_title'] && $row['post_id'] == $row['topic_first_post_id'])
    {
        $sql_data = array(
            'poll_title'        => str_replace($row['bbcode_uid'], $message_parser->bbcode_uid, $poll['poll_title']),
        );

        $sql = 'UPDATE ' . TOPICS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_data) . '
            WHERE topic_id = ' . $row['topic_id'];
        $db->sql_query($sql);

        $sql = 'SELECT * FROM ' . POLL_OPTIONS_TABLE . ' WHERE topic_id = ' . $row['topic_id'];
        $result2 = $db->sql_query($sql);
        while ($row2 = $db->sql_fetchrow($result2))
        {
            $sql_data = array(
                'poll_option_text'        => str_replace($row['bbcode_uid'], $message_parser->bbcode_uid, $row2['poll_option_text']),
            );

            $sql = 'UPDATE ' . POLL_OPTIONS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_data) . '
                WHERE topic_id = ' . $row['topic_id'] . '
                AND poll_option_id = ' . $row2['poll_option_id'];
            $db->sql_query($sql);
        }
    }
}

$sql = 'SELECT count(post_id) as post_cnt FROM ' . POSTS_TABLE;
$result = $db->sql_query($sql);
$cnt = $db->sql_fetchrow($result);

if ($cnt['post_cnt'] > ($start + $limit))
{
    meta_refresh(1, './resync_bbcode.' . $phpEx . '?start=' . ($start + $limit));
    trigger_error('The script is not finished yet, please wait.  Part ' . (($start + $limit) / $limit) . ' of ' . intval($cnt['post_cnt'] / $limit) . ' is finished.');
}
else
{
    trigger_error('Finished!');
}

?>

??? ???????? ???? ?????? ?????? ????????? ??????? ???? ???? ??? ?????? ??? ???? ??? ???????.

????? ?? ?????? add_phpbb3_bots.py ?? ?? ??? ??? ???????? ??????? ?? ????? bots_phpBB3.sql ??? ????? ?????? ?????? phpmyadmin

???? ?????

1 / ?? ??????? ?? ??????? ??????? ????? ????? ???? ????.
2 / ?? ?????? ?? ????? ?? ??????? ?? ?? ??????? ????.

?? ???? ???????? ?? ??? ????? ???? ?? ???????? ? ????????? ?? ????????? ??? ?? ?????? ?? ???? ?????? ?? ?????