vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB5 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=262)
-   -   In need of a vB 5 cron file for updating node.votes from reputation table (https://vborg.vbsupport.ru/showthread.php?t=329446)

Aristide 12-22-2022 06:45 PM

In need of a vB 5 cron file for updating node.votes from reputation table
 
Hi,

I have upgraded my site from vB 3.8.x to vB 5.7.1 and have the (thanks) likes all set to "0" (Zero). However, the data is available in the reputation table of the database.

Anyone proficient enough with the programming concepts of vB5 to provide a simple working cron file in vB5, to update the node.votes through for the following actions?

For every nodeid from the "node" table, do the following:
Read the number of reputation rows associated with the current nodeid. (Read reputation where nodeid = `nodeid`)
Assign that number of reputation rows to the votes variable associated with the nodeid (node[nodeid].votes = number of reputation rows)
End loop.

Thanks in advance to anyone who can help.

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

Solved! I wrote a simple and crude php file, using procedural php.


All times are GMT. The time now is 01:35 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.00912 seconds
  • Memory Usage 1,701KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (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_navbar_search
  • (1)printthread
  • (1)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete