vb.org Archive - [AJAX] vBShout v2.0

get this when i try to uninstall

Database error in vBulletin 3.5.3:

Invalid SQL:
drop table `shout`;

MySQL Error : Unknown table 'shout'
Error Number : 1051
Date : Thursday, April 20th 2006 @ 06:32:25 PM
Script : http://www.meogee.com/admincp/plugin.php
Referrer : http://www.meogee.com/admincp/plugin...id=_vbshout&s=
IP Address :
Username : Mikecp421
Classname : vb_database

tried to overwrite the shout by installing this one over it and now I get an error in the forum

anybody??

Mikecp421

04-21-2006 01:16 PM

also get this in the shoutbox itself

Database error in vBulletin 3.5.3:

Invalid SQL:

select s.*, u.username, u.usergroupid from shout s
left join user u on (u.userid = s.s_by)
order by s.sid desc limit 20;

MySQL Error : Table 'meogeec_forumnew.shout' doesn't exist
Error Number : 1146
Date : Friday, April 21st 2006 @ 09:16:09 AM
Script : http://www.meogee.com/vbshout.php
Referrer :
IP Address :
Username : Mikecp421
Classname : vb_database

Zachery

04-21-2006 01:18 PM

Quote:

Originally Posted by thisgeek

Why are you using htmlspecialchars() as the 'fix' function? That only causes special chars to get converted... why not use strip_tags() ?

I've replaced the two calls to htmlspecialchars with strip_tags and everything is working as it is supposed to. - html code is stripped out, while leaving special chars alone.

Anyway, thanks for doing it in the first place! :D

Thats what happens in a normal post :p

Mike, you just uploaded the new file and it is causing the problem?

Mikecp421

04-21-2006 02:11 PM

actually the first error message is the error I got when I tried to uninstall via the Product manager in the ACP the second (which shows in the shoutbox itself) is what I got when I manually replaced both files. I uploaded the xml and then imported it via the product manager allowing an overwrite and I replaced the php file int he ftp.

Zachery

04-21-2006 02:47 PM

All you needed was to upload the new file, nothing else.

The error was from after you uninstalled the hack.

blacklancer

04-21-2006 03:14 PM

just installed the new file....is there a way to allow certain characters???

i tried to type 3" k&n filter and it came out 3" k&n filter.....

DJ XtAzY

04-21-2006 03:16 PM

Quote:

Originally Posted by hassi

If you want to have a timestamp in the shoutbox which is different to the rest of the forum i.e. just the time and not the date then open your vbshout.php and delete the following:

Code:

        $Time  = vbdate($vbulletin->options['dateformat'], $time, $vbulletin->options['yestoday']);

    $Time .= ' ';

Hope someone might find it useful. You'll find an example how it looks after modification in the attachement. It also works in vbadvanced if you have it installed in there.

Hassi

does anyone know how to remove the brackets when it shows the time. I want to remove the time and the bracket from the shoutbox

Mikecp421

04-21-2006 03:40 PM

Quote:

Originally Posted by Zachery

All you needed was to upload the new file, nothing else.

The error was from after you uninstalled the hack.

The original error was from trying to uninstall the hack as the upgrade instructions instructed me to do. So what do I do now?

Mikecp421

04-21-2006 04:06 PM

this is the upgrade instructions;

Quote:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~
Step 1:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~
Upload 'vbshout.php' to your 'FORUMS ROOT DIRECTORY' (ie: forums/ or forum/)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~
Step 2:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~
Go to your ACP, then:
Plugin System -> Manage Products -> vBShout -> Uninstall
Plugin System -> Manage Products -> [Add/Import Product]
Make sure "Allow Overwrite" is set to 'Yes'!
Select 'vbshout.xml' from your computer and then press 'Import'

Upgrade is now complete, enjoy.

note the bolded field, thats where it all went wrong

Gizmo5h1t3

04-21-2006 04:15 PM

this still isnt working...followed the instructions to the letter, and im getting this :

Quote:

[1 Minute Ago 18:13] Gizmo: testing quote marks "bollox"

All times are GMT. The time now is 10:25 PM.

Page 157 of 334

157

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03846 seconds Memory Usage 1,746KB 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)bbcode_code_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (6)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: