vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Mysql i want to delete user id's @ 0 my attempt (https://vborg.vbsupport.ru/showthread.php?t=57073)

Almax1 09-14-2003 10:47 AM

Mysql i want to delete user id's @ 0 my attempt
 
In Mysql i want to delete user id's @ 0 and there posts but i am unsure how to run the query

user id's @ 0 (removed members) are still being called up from some hacks

In a recent board move some members were not transferred to the new place there user ids are now 0 i want to delete them from the mysql database as they are still being called up with some hacks installed

help needed please anyone ?

DELETE FROM table_post
WHERE userid = '0'
ORDER BY timestamp
LIMIT 1

does this sound right ?

Issvar 09-14-2003 11:25 AM

LIMIT 1 means only one post with userid 0 will be removed. Remove that if you want to remove all posts which have userid 0. You may also want to make sure you have the correct name for the posts table, it is not called table_post on VB


All times are GMT. The time now is 01:54 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.01047 seconds
  • Memory Usage 1,699KB
  • 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
  • (2)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