View Single Post
  #9  
Old 06-08-2013, 07:55 AM
TiKu's Avatar
TiKu TiKu is offline
 
Join Date: Sep 2006
Posts: 97
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ah, now I can see the field in the foruminfo array. Many thanks.

I've noticed an interesting detail: The foruminfo array contains 'ivwcode' as well as 'ivw_code'. In the database I can see only 'ivw_code', but I remember that in the beginning I had named the field 'ivwcode', without underscore, in my installer code. So it seems like the installer code somehow worked, but it did not actually create the field in the database?!

/Edit: Okay, I've added code to drop the 'ivwcode' field on uninstall and then uninstalled and reinstalled the add-on. Now the 'ivwcode' field is gone, and foruminfo contains only the 'ivw_code' field. But it does not get inserted to the database, I have to do this manually.

--------------- Added [DATE]1370685483[/DATE] at [TIME]1370685483[/TIME] ---------------

ARGH! Never mind, I'm doing all this on a test installation and my colleague has moved this test installation to a new database server without telling me. He has left the old database on the old server, so I have been looking at the wrong database all the time.

--------------- Added [DATE]1370729379[/DATE] at [TIME]1370729379[/TIME] ---------------

I have an issue with unwanted data type conversion. My custom SQL field is of type varchar(25). When it contains the string '12E03611', it will be stored as a float in the $foruminfo array. How can I force VB4 forum cache to store this as a string?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00984 seconds
  • Memory Usage 1,764KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete