View Single Post
  #6  
Old 01-22-2008, 01:13 AM
chuanjer chuanjer is offline
 
Join Date: Nov 2004
Posts: 10
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Marco van Herwaarden View Post
No, deleted members are not logged by default, other then in the Admin log.
The Admin-log records all admin-actions on the users , so it should be possible to read off the adminlog table:
  • checkup if time-stamp was after last-sync
  • check that action="kill" AND script="user.php"
  • check the extra-comments field to obtain " userid " of deleted member

Might have to do some more work on it, but I think this would be an easier solution.With regards to the earlier comment about using mysql triggers.I was tempted to do so, but was urged by my department to seek a vB method, rather than resort to hacks.

Thanks guys :up:

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

Quote:
Originally Posted by Eikinskjaldi View Post
Could you explain why you want to delete users? (I am not aware of vb storing them)

Secondly, were it me and assuming you are using mysql v5 or better I would set it up as a trigger, and avoid any code mods altogether.
Unfortunately ,mysql triggers won't work for me coz I'm using MySQL 4.1.20. by the looks of it, the adminlog doesnt appear to update on userKill.Looks like a vb hook update of my own table would be the way to do so.but so far my chief concern is:
  • Which vb hook suits this role?

Haven't found a relevant hook yet, but I'd appreciate any suggestions regarding one.
Thanks!
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01168 seconds
  • Memory Usage 1,766KB
  • 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
  • (2)bbcode_quote
  • (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