Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > ibProArcade Archive
Charset and MySQLi Details »»
Charset and MySQLi
Version: , by Talaturen Talaturen is offline
Developer Last Online: Nov 2012 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 06-18-2008 Last Update: Never Installs: 0
 
No support by the author.

Hello.

I wonder if anyone has tried the MySQLi code, I doubt anyone has got it to work without modifications because it looks completely wrong. I guess the author of this modification only replaced 'mysql' with 'mysqli' when adding mysqli support and if you try the code you'll end up with a bunch of errors. It would be cool if this could be fixed, shouldn't be too hard. I could probably fix it myself but then I'll have to re-patch my fixes every update which I don't think I will have the time to.

The other issue I'm having is charset related, I'm using charset latin1 and this arcade modificaiton is ignoring that which is messing up some usernames and perhaps comments too (not checked but I guess it's using same database methods..). Now that I'm using MySQL because I don't have the time to fix all the errors in the MySQLi file I fixed this by adding: mysql_set_charset("latin1"); in the connection part. Of course that line may cause trouble for others but some method like the vBulletin core could be used:
PHP Code:
        if (!empty($charset))
        {
                if (
function_exists('mysql_set_charset'))
                        
mysql_set_charset($charset);
                else
                        
$this->query("SET NAMES $charset");
        } 
Thanks,
Talaturen.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 06-24-2008, 01:46 PM
Talaturen Talaturen is offline
 
Join Date: Dec 2007
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

-- bump --
Reply With Quote
  #3  
Old 06-30-2008, 04:44 PM
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Location: Munich, Germany
Posts: 3,012
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

as stated in the release-history, mysqli-implementation is very basic and still unstable/buggy

As I don't have/use mySQLi it is somehow hard to develop

so if you do all adaptions to the dbclass_mysqli I would integrate it of course
Reply With Quote
  #4  
Old 07-01-2008, 03:22 PM
Talaturen Talaturen is offline
 
Join Date: Dec 2007
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I've been quite busy lately but I'll see if I can get some free time to rewrite the MySQLi database class. What about the charset issue, has it been fixed for the next release?
Reply With Quote
  #5  
Old 07-01-2008, 06:41 PM
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Location: Munich, Germany
Posts: 3,012
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

no, nothing done about charset.

I would be thankful for your fixes
Reply With Quote
Reply

Thread Tools

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


All times are GMT. The time now is 10:27 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.07333 seconds
  • Memory Usage 2,228KB
  • Queries Executed 18 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (4)postbit
  • (5)postbit_onlinestatus
  • (5)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete