تبلیغات در اینترنت

تبلیغات در اینترنتگیفت کارت گوگل پلی
نمایش نتایج: از 1 به 2 از 2

موضوع: درخواست مقاله از vbulletin

  1. Top | #1
    کاربر سایت

    تاریخ عضویت
    Jan 2012
    ورژن ویبولتین
    4.1.14
    نوشته ها
    68
    مورد پسند
    5 بار
    اطلاعات
    Windows 7/Server 2008 R2 Firefox 30.0
    میزان امتیاز
    11

    پیش فرض درخواست مقاله از vbulletin

    من این مقاله رو می خواهم
    How to convert vbulletin to UTF8 charset - vBulletin.org Forum
    خیلی لازم دارم




  2. گیفت کارت آیتونز

  3. Top | #2
    مدیر بازنشته

    تاریخ عضویت
    May 2013
    ورژن ویبولتین
    4.2.0
    نوشته ها
    5,973
    مورد پسند
    5,728 بار
    نوشته های وبلاگ
    7
    اطلاعات
    Windows 7/Server 2008 R2 Firefox 30.0
    میزان امتیاز
    720

    پیش فرض

    We've just successfully migrated a 6m post VB forum cross server and charset and as I spent a fair amount of time working this out I thought I'd share. There are apparently third party tools to do this but I've read mixed reviews about them.

    I found a good step by step on the charset changeover here (http://megaz.arbuz.com/2009/04/09/co...letin-to-utf-8) though there are some errors in what he's done.

    To manually make the transition on a linux box, you'll need shell access and here's what needs to be done...

    1. Shut-off forums in admin panel.
    2. Shell into your box and dump all the mysql data minus binary image data
      Code:

      کد:
      #    mysqldump -u DBUSERNAME -p --opt --skip-set-charset --ignore-table=VBULLETINDBNAME.customavatar --ignore-table=VBULLETINDBNAME.customprofilepic --ignore-table=VBULLETINDBNAME.picture --ignore-table=VBULLETINDBNAME.socialgroupicon --ignore-table=VBULLETINDBNAME.socialgrouppicture VBULLETINDBNAME > VBULLETINDBNAME.sql
    3. Dump the image data
      Code:

      کد:
       #mysqldump -u DBUSERNAME -p --opt --default-character-set=latin1  VBULLETINDBNAME customavatar customprofilepic picture sigpic  socialgroupicon socialgrouppicture > VBULLETINDBNAME_images.sql
    4. Convert all the characters in the data dump to UTF8 via iconv
      Code:

      کد:
       #iconv -c -f windows-1251 -t utf-8 VBULLETINDBNAME.sql > VBULLETINDBNAME_utf8.sql
    5. Change the import script to make sure it imports as UTF8
      Code:

      کد:
       #sed –i 's/latin1/utf8/g' VBULLETINDBNAME_utf8.sql #sed –i 's/latin1/utf8/g' vogue_forums_untouchable_images.sql
    6. Create your new database on the second server *Obviously make sure your new database is setup with UTF8 as the default collation*
    7. Import your converted dump into the db you just created.
      Code:

      کد:
       #mysql -u NEWDBUSER -p –default-character-set=utf8 NEWVBDATABASENAME  < VBULLETINDBNAME_utf8.sql #mysql -u NEWDBUSER -p  –default-character-set=utf8 NEWVBDATABASENAME <  VBULLETINDBNAME_images.sql
    8. Now if you've changed domains you'll need to update the settings tables... you can get away with the following - there's two db values you need to change first one is pretty simple:
      Code:

      کد:
       mysql> UPDATE setting set value = 'http://YOURNEWDOMAIN' where varname = 'bburl'
    9. The second update is stored as a serilaized value in the datastore table so you need to do a bit of work to get the right return value:
      First grab the data you need to change from the old DB
      Code:


      کد:
       mysql>select data from VBULLETINDBNAME.datastore where title = 'options'
      Grab the returning value and throw it in the following php (once you've changed the your new domain bits) script.. then grab the output:
      PHP Code:
      کد:
      #MYSQL: select data from VBULLETINDBNAME.datastore where title = 'options' 
      $the_object = 'PUT RESULT OF ABOVE MYSQL QUERY'; 
      $the_object = unserialize($the_object); 
      $the_object['homeurl'] = 'http://YOUR NEW DOMAIN'; 
      $the_object['bburl'] = 'http://YOURNEWDOMAIN'; 
      $the_object['cookie_domain'] = 'YOURNEWDOMAIN'; 
      echo serialize($the_object);  
       
    10. Update the datastore table with the output from the above script
      Code:

      کد:
       mylsql> UPDATE datastore set data = 'OUTPUT FROM ABOVE - ESCAPE THE SINGLE QUOTES ETC' where title = 'options';
    11. Load up a clean vbulletin latest release in a new vhost on second server
    12. change the /includes/config.php on the new install to reflect the new environment
    13. run through the vbulletin upgrade process at newserver.xxx/install/upgrade.php (disregard warning about wrong version)
    14. Update thread counters (admin -> maintenance -> update counters -> thread then post)
    15. Go to admin panel -> address all issues. (if any hang, log out and in again and they will be shown again for you to run)
    16. If you can't login: Upload the DO_NOT_UPLOAD folder and reset the cookie_domain using the newserver.xxx/DO_NOT_UPLOAD/tools.php script
    17. If forum not displaying use the tools (and you've updated thread counts etc in admin/maintenance) reset the caches using the tools.php page
    18. update the default character set (Admin CP -> Languages & Phrases -> Language Manager -> [Edit Settings] -> HTML Character Set) change ISO-8991 to UTF8
    19. delete the DO_NOT_UPLOAD folder from your server
    20. delete the install directory from server


    Now you're be right to go with a UTF8 forum! YAY. don't you feel good.

    کاربر مقابل از MR.Shadow بابت این پست مفید تشکر کرده است:


اطلاعات موضوع

کاربرانی که در حال مشاهده این موضوع هستند

در حال حاضر 1 کاربر در حال مشاهده این موضوع است. (0 کاربران و 1 مهمان ها)

موضوعات مشابه

  1. تفاوت vbulletin.css با vbulletin-chrome.css چیه؟؟؟؟؟؟؟
    توسط تازه کار در انجمن پرسش و پاسخ
    پاسخ: 3
    آخرين نوشته: 2014/01/14, 09:39 AM
  2. پاسخ: 3
    آخرين نوشته: 2013/12/18, 12:31 PM

علاقه مندی ها (Bookmarks)

علاقه مندی ها (Bookmarks)

مجوز های ارسال و ویرایش

  • شما نمیتوانید موضوع جدیدی ارسال کنید
  • شما امکان ارسال پاسخ را ندارید
  • شما نمیتوانید فایل پیوست کنید.
  • شما نمیتوانید پست های خود را ویرایش کنید
  •