View Single Post
  #1  
Old 05-23-2006, 06:43 PM
Mark.B Mark.B is offline
Senior Member
 
Join Date: Feb 2004
Posts: 1,354
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default v3Arcade Score Pruning php code question

I am trying to see if it is possible to adapt some code that used to be in v3Arcade's cron file, this code used to run hourly and remove any scores in the database that were over a certain age.

I know the database tables have changed, I can alter that ok, but I am unsure what part of the current code needs to be changed syntax-wise to make it work, or even whether this is remotely possible. I know bits of this code need to be amended to work in vB 3.5 but I don't know which bits or what to.

The old code is like this:
Code:
	$serializedsettings = $DB_site->query_first("SELECT * FROM " . TABLE_PREFIX . "datastore WHERE title='scoresettings'");
	$scoresettings = unserialize($serializedsettings['data']);
	$maxage = mktime()-($scoresettings['maxscoreage']*24*60*60);
	$newusers = $DB_site->query("UPDATE " . TABLE_PREFIX . "gamesessions SET valid=0 WHERE finish<$maxage");
	$newusers = $DB_site->query("DELETE FROM " . TABLE_PREFIX . "gamechallenges WHERE datestamp<$maxage");
First off, what needs to be changed in this code to kmake it vB-3.5 compatible in a general way, and then beyond that will the same general principal actually work?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01462 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)bbcode_code
  • (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