Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 03-31-2008, 06:39 PM
SCuN SCuN is offline
 
Join Date: Mar 2008
Location: BE
Posts: 31
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Auto execute query

Do I greet someone could write script which he made these query to cron of every hour ?

UPDATE search SET ipaddress = 0
UPDATE user SET ipaddress = 0
UPDATE post SET ipaddress = 0

thanks
Reply With Quote
  #2  
Old 04-01-2008, 04:49 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Cron as in vBulletin Scheduled Task? Or proper crontab cron?
Reply With Quote
  #3  
Old 04-01-2008, 10:04 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What you are probably looking for is:

AdminCP -> vBulletin Options -> Message Posting and Editing Options ->
Log IP Addresses: Do not log IP
Reply With Quote
  #4  
Old 04-01-2008, 04:38 PM
SCuN SCuN is offline
 
Join Date: Mar 2008
Location: BE
Posts: 31
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Cron as in vBulletin Scheduled Task? Or proper crontab cron?
vBulletin Scheduled Task...

Quote:
AdminCP -> vBulletin Options -> Message Posting and Editing Options ->
Log IP Addresses: Do not log IP
so marked have so but when someone registers his ip he is written down farther ... why I do not know...
Reply With Quote
  #5  
Old 04-02-2008, 05:12 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This is basically the whole script:
PHP Code:
$vbulletin->db->query_write("UPDATE search SET ipaddress = 0");
$vbulletin->db->query_write("UPDATE user SET ipaddress = 0");
$vbulletin->db->query_write("UPDATE post SET ipaddress = 0"); 
Reply With Quote
  #6  
Old 04-03-2008, 06:06 AM
SCuN SCuN is offline
 
Join Date: Mar 2008
Location: BE
Posts: 31
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

He Thanks very much

That is I have to create the file php with content

PHP Code:
$vbulletin->db->query_write("UPDATE search SET ipaddress = 0");
$vbulletin->db->query_write("UPDATE user SET ipaddress = 0");
$vbulletin->db->query_write("UPDATE post SET ipaddress = 0"); 
and to send him to /forum/includes/cron/ and I use from Scheduled Task
Apologize then that I give so stupid questions but I have vbulletin from 3 weeks
Reply With Quote
  #7  
Old 04-03-2008, 06:18 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

No, I believe you will need to add some standard cron PHP around it. Look in the files vBulletin comes with, and you will know what to add.
Reply With Quote
  #8  
Old 04-03-2008, 06:34 AM
SCuN SCuN is offline
 
Join Date: Mar 2008
Location: BE
Posts: 31
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

ok thanks
I already know
PHP Code:
<?php
error_reporting
(E_ALL & ~E_NOTICE);
if (!
is_object($vbulletin->db))
{
    exit;
}

$vbulletin->db->query_write("UPDATE search SET ipaddress = 0");
$vbulletin->db->query_write("UPDATE user SET ipaddress = 0");
$vbulletin->db->query_write("UPDATE post SET ipaddress = 0");

?>
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:37 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04212 seconds
  • Memory Usage 2,230KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (3)bbcode_php
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete