View Single Post
  #8  
Old 10-13-2002, 04:20 PM
Mystikal Mystikal is offline
 
Join Date: Apr 2002
Posts: 46
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Okay, I'm going to re-work some stuff.. because honestly? It's pretty ghetto-fied right now... for instance...

I have it set so people can upload any size file right now, (only gif files but still), gonna make it so people can limit the file sizes.

Since title is unique, and a person may have a file thats name the same as another, and title is taken by substr($file_name, -4), the title is esentially the filename without the extension.

SO! A better way to do this would be to alter the table around and replace `title` with `userid` and when uploading, check if the user has uploaded a file... obviously if they haven't you'd insert a new one with the `userid` = $bbuserinfo[userid] and then if they do have one, just update the contents of the file.

This way, instead of having to perform 2 queries in icon.php, we can perform one by saying oh lets SELECT `data` FROM `usericons` WHERE `userid`=$bbuserinfo[userid]; The filename now becomes $bbuserinfo[userid]...

The way i had it before is it had to select usericon from user blah blah, then select data from the icons table where title='whatever'.

Now I don't need to alter the user table and can just output a default image file if the user doesn't have a mini-avatar set. Wee!

Whew.. sorry for the long post guys, just explaining the current status. Once those changes are made (in a few hours, max later tonight) It will be released.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01181 seconds
  • Memory Usage 1,761KB
  • 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