Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 12-01-2009, 05:15 PM
slcricket slcricket is offline
 
Join Date: Nov 2009
Posts: 2
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default looking for a Mysql query beacause cleaner.php is not working

Hi guys,

here is my story. I recently migrated my forum from SMF to Vbulletin but my forum has lots of malicious code and I can't run cleaner.php

I tried several times and even this tech guy tried to run cleaner.php but it's not working.

These are the things I need to get done, can someone help me clean up the mess by writing up a mysql query to run?

For quotes I don't mind if it's just [*quote] the comment [/*quote]after the sql query run.


Here is the mess:

01. [size=12pt]test[/size]

02. [quote author=exampleuser link=topic=25158.msg388289#msg388289 date=1258984987]
Test Post
[/quote]

03.




Can you please write me a mysql query to clean up the mess? Thank you

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

Help me please?

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

Help me please?

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

can someone help me please?
Reply With Quote
  #2  
Old 12-01-2009, 09:56 PM
gmerin gmerin is offline
 
Join Date: Dec 2008
Posts: 78
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

can you be a little more specific as to what you want to do?
Reply With Quote
  #3  
Old 12-01-2009, 11:09 PM
slcricket slcricket is offline
 
Join Date: Nov 2009
Posts: 2
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by gmerin View Post
can you be a little more specific as to what you want to do?
I have a forum which I converted from SMF to Vbulletin. After the conversion it left me with a mess on the forum with broken size, quotes and img tags.

These are exams of those broken tags:

01. [size=12pt]test[/size]

02. [quote author=exampleuser link=topic=25158.msg388289#msg388289 date=1258984987]
Test Post
[/quote]

03. [img width=576 height=94] http://Test Image URL [/img]


I tried to run the cleaner.php that came with impex but it's not letting me run the cleaner.php and I get like a bunch of errors.

I was wondering If anyone can provide me with a sql query to get rid of the mess indicated above.

Thank you.

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

Any help?
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 06:07 PM.


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.03805 seconds
  • Memory Usage 2,176KB
  • 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
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)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