Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
vCharset Converter 1.0.0 BETA 2 Details »»
vCharset Converter 1.0.0 BETA 2
Mod Version: Beta 2, by Milad (Coder) Milad is offline
Developer Last Online: Mar 2016 I like it Show Printable Version Email this Page

This thread is in the Modification Graveyard.
vB Version: 3.5.5 Rating: (1 vote - 5.00 average) Installs: 30
Released: 11 Jun 2006 Last Update: Never Downloads: 19
Not Supported DB Changes Uses Plugins Additional Files Is in Beta Stage  

THE 3.5 BRANCHE IS CLOSED, A NEW VERSION FOR 3.6 HAD BEEN RELEASED.

To use this modification, please update to 3.6.x and use this.

Description: This script converts the database of vBulletin forums (from and to) any of the charsets that are supported by iconv. also it has the ability to convert the tables of the hacks you had installed them.

Caution: This is BETA PRODUCT, provided "As Is" without warranties, Test it using a copy of your vBulletin database not using your live vBulletin, Since this is a BETA PRODUCT use it for testing only.

Why this product?
My forums encoding is windows-1256, so I can't get full advantages of AJAX functions like the quick reply and the quick edit without some encoding problems.
I decided to convert my encoding and build this script. and I'll convert to utf-8 (Done).
This product was tested on a copy of real live vBulletin and it seems to be good.

Requirements:
  • vBulletin 3.5.4+
  • iconv php extension is installed on your system, or your PHP version is PHP5

Supported Encodings:
See http://www.gnu.org/software/libiconv/#introduction

Installation:
  1. Upload files to their respective locations.
  2. Import the file product product-charset_converter.xml (Choose Yes when Upgrade)
  3. Refresh your admincp, go to vCharset Converter->Settings and set (the Source Charset Encoding & the Destination Charset Encoding).
  4. Go to vBulletin Options -> Censorship Options -> Blank Character Stripper, empty its value and click save.

How to use?
  1. Close your forum.
  2. Backup your database.
  3. Add a new language and call it English for example, its charset is your Destination Charset Encoding.
  4. Set your options (profile.php?do=editoptions) to use it as a default language.
  5. Change the charset of your old langauge into Destination Charset Encoding.
  6. Go to vCharset Converter -> Manage tables. I'll leave this to you to explore it. But edit the userfield table and the custom fields to it.
  7. Go to vCharset Converter -> vCharset Converter. if you see a message like:
    The iconv PHP module is not presented, please contact your system administrator to enable/install it.
    this means you need to install iconv.
  8. You will see a drop-down menu. select the table you want to convert, set the number of items to convert per cycle (default 1000) and press submit.
  9. You have to do this with each table in the drop-down menu.
  10. Test your forum search for Non-English letters, if you don't get the expected results, read the "Search Problems".
  11. Open your forum.
  12. After finishing tell me what are your impression, idea and faced problems.

Search Problems
What is the problem? After converting you may get no (well-expected) results when doing search, I had faced this problem after converting to UTF-8.
What is my circumstances? Mysql 4.1.x, Full-Text search and I converted to utf-8.
What is the reason? Full-Text search has Restrictions that say: "all columns in a FULLTEXT index must use the same character set and collation.".
So if you use fulltext search with MySQL 4.1.x and convert to utf-8 perform these queries: (after converting post and thread tables)

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Dont forget to add your table prefix if you have

- If you use vBulletin built-in search engine (with any MySQL version), then consider to Rebuild Search Index (Maintenance -> Update Counters -> Rebuild Search Index)
You may read this thread http://www.vbulletin.com/forum/showthread.php?t=191315

Email Problems
After the conversion, my users had reported that they couldn't read the notification emails. the emails are sent with utf-8 encoding.
Not all the users do know how to change the encoding of a page. you may learn them, this is the only solution.
Problem had been faced with Hotmail (confirmed by me) and Yahoo (unconfirmed).
No problem with Gmail (confirmed by me).

Known issues:
  1. Users titles had gone away after converting. (Still exists in beta 2)

Versions
  • 1.0.0 BETA 1 (initial release). (11. Jun 2006)
  • 1.0.0 BETA 2 new features: (4. Aug 2006)
    1. Manage Tables: Now you can add or edit your tables, this will make converting of additional tables very easy.
    2. New built-in images to mark the tables:
    3. Now you can see all the tables in your database, with their statues and you have the ability to change this status to "no need" or you can add the fields and the primaryid field, or you can edit the information of any table before you go on converting it.

Forums had been Converted using this tool: (PM me to list your forum)
Support is given for who clicked "install" only.

Click to recieve updates.

Nominate it for Mod o.t. Month if you love it.

Download Now

Only licensed members can download files, Click Here for more information.

Screenshots

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Comments
  #2  
Old 11 Jun 2006, 14:40
Milad's Avatar
Milad Milad is offline
 
Join Date: May 2005
Real name: Milad
Post reserved.

Last edited by Milad; 11 Jun 2006 at 15:01.
Reply With Quote
  #3  
Old 12 Jun 2006, 01:17
Barakat's Avatar
Barakat Barakat is offline
 
Join Date: Nov 2004
Real name: Barakat
thanks Milad i will test it soon
Reply With Quote
  #4  
Old 13 Jun 2006, 20:02
Panagioths Panagioths is offline
 
Join Date: Feb 2004
Your script is extremely good. During the last 4 days I am trying to convert the database of my forum from greek ISO to utf8, I tried hundrend ways without the desired output and when I installed the vCharset all conversions made automagically and without any problems as fas as I can see now.

I have a question: I removed a part of data of my database by accident and now in product list (in admincp) vCharset is not shown anymore (in order to uninstall it since the convert is done). Also menu "vCharset" in admincp is not shown anymore. But I've got a table "charset_convert" in my database so I assume there are some parts of vCharset installtion still in forum.

Is there a sql command that I can run in order to remove any part of vCharset in my forum?
Reply With Quote
  #5  
Old 13 Jun 2006, 22:10
Milad's Avatar
Milad Milad is offline
 
Join Date: May 2005
Real name: Milad
Thanks for your feedback

I assume you ran the script on a test board not on live one.

vCharset converter must remain in your database after finishing, it doesn't uninstal itself, you can uninstall it manually. yes you can uninstall the product, drop the table charset_convert and delete the product files.

Because you delete something in your database, you don't see the product, I think you deleted or epmtied product table.

I advise you to return to your backup, and test my script many times before you make decision to go ahead with it.

Remember I am still considering this product as a BETA product.

Thanks for your feedback again.
Reply With Quote
  #6  
Old 13 Jun 2006, 22:12
Milad's Avatar
Milad Milad is offline
 
Join Date: May 2005
Real name: Milad
Also if you have some hacks, extensions or plugins that collect some text information in the database, you have to convert them too, this will be explained after the gold is released.
Reply With Quote
  #7  
Old 14 Jun 2006, 00:02
Omranic's Avatar
Omranic Omranic is offline
 
Join Date: Jan 2005
Location: Egypt
Real name: Abdelrahman Omran
thanks alot Milad
thats extremely good

Go on developing this
we need to see a strong stable version as soon as posible


__________________
Me & My Productions: Omranic | vBulletin.org | Github | Premium PHP & vBulletin Solutions!
» ---------------------------------------------------------------------------- «
Keep Moving Forward!
Reply With Quote
  #8  
Old 14 Jun 2006, 11:15
Milad's Avatar
Milad Milad is offline
 
Join Date: May 2005
Real name: Milad
Thanks

Please to keep yourselves updated press install.
Reply With Quote
  #9  
Old 17 Jun 2006, 23:17
blacklude blacklude is offline
 
Join Date: Jun 2006
Originally Posted by Milad
Thanks for your feedback

I assume you ran the script on a test board not on live one.

vCharset converter must remain in your database after finishing, it doesn't uninstal itself, you can uninstall it manually. yes you can uninstall the product, drop the table charset_convert and delete the product files.

Because you delete something in your database, you don't see the product, I think you deleted or epmtied product table.

I advise you to return to your backup, and test my script many times before you make decision to go ahead with it.

Remember I am still considering this product as a BETA product.

Thanks for your feedback again.
is there any reason that the convertor must stay after finishing the convertion?
thanks!
Reply With Quote
  #10  
Old 18 Jun 2006, 12:33
Milad's Avatar
Milad Milad is offline
 
Join Date: May 2005
Real name: Milad
Originally Posted by blacklude
is there any reason that the convertor must stay after finishing the convertion?
Never

But i want you to know that the product doesn't uninstall itself after the converting, you should uninstall it yourself.

Regards
Reply With Quote
  #11  
Old 25 Jun 2006, 02:29
Milad's Avatar
Milad Milad is offline
 
Join Date: May 2005
Real name: Milad
Any ideas? suggestions? or bugs?
Reply With Quote
  #12  
Old 25 Jun 2006, 03:38
e7lew e7lew is offline
 
Join Date: Jun 2004
ميلاد جربته لكن طلع خطا في اكثر من جدول والتجربة كانت على 3.6.0
وبعدين لما اعرض السورس من المصدر تطلعلي جمل غريبة
ط§ظ„ظ…ظˆط§ط¶ظٹط¹: 1, ط§ظ„ظ…ط´ط§ط±ظƒط§طھ: 5, ط§ظ„ط£ط¹ط¶ط§ط،: 1<
وبعدين الرد السريع ما يرسل اضغط عليه يرجع مكانه لما اسوي رفرش يطلع الرد بالموضوع
وهذه صورة بالمرفق للجداول الي ما صارت او ما تحولت
اعتقد يمكن من اصدارة النسخة البيتا الجديدة
عندي منتدى ضخم بجرب عليه اصداره 3.4.5
وبردلك خبر

thanks :banana:
Attached Images
File Type: jpg untitled.JPG (21.0 KB, 63 views)
Reply With Quote
  #13  
Old 25 Jun 2006, 04:57
Milad's Avatar
Milad Milad is offline
 
Join Date: May 2005
Real name: Milad
This is for vB3.5.x only, for the source code it's normal to see it like ': 5, ط§ظ„ط£ط¹ط¶ط'

also do you change the charset html for the languages into utf-8? I think you didn't.

Please don't use it on live boards, and only for 3.5.x

Thanks for your feedback, and I'm waiting for more
Reply With Quote
  #14  
Old 28 Jun 2006, 08:50
Almotmaiz.Net's Avatar
Almotmaiz.Net Almotmaiz.Net is offline
 
Join Date: Jan 2005
Real name: Alzaabi
Great work mr. Milad i'll test it in forums ..


be right back .. ..
__________________
For who use's my products. (All of it), I always support latest version of vBulletin only. So, if you use my products you'll find a working version of it for your current version. but I CANT SUPPORT IT unless you are using the latest version of vBulletin.
Reply With Quote
  #15  
Old 01 Jul 2006, 10:47
Lizard King's Avatar
Lizard King Lizard King is offline
 
Join Date: Jan 2005
Real name: Mert
I hope you'll release the gold version soon.
__________________
Mert Gökçeimam / Crawlability Inc.

DepKaç | vBSEO 3.3.0 - vBulletin Search Engine Optimisation
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 13:00.

Layout Options | Width: Wide Color: