vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   vB Chatbox 1.2.4 (https://vborg.vbsupport.ru/showthread.php?t=42725)

kevin_r1 04-19-2003 09:32 PM

Below is a database error message received when one of my user's attempts to minimize the chatbox:

Quote:

Database error in vBulletin 2.3.0:

Invalid SQL: UPDATE user SET chatbox=0 WHERE username='User's Name' mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's Name'' at line 1

mysql error number: 1064
Let's say the user's name is User's Name. The error invokes because there is an apostrophe in the name itself. How do I account for this? Wouldn it be better to reference the user ID # as opposed to the actual name? If so, how do I do this.

Erwin 04-20-2003 04:30 AM

kevin - the solution is just a few posts above yours. :)

kevin_r1 04-20-2003 03:38 PM

Quote:

Today at 05:30 AM Erwin said this in Post #313
kevin - the solution is just a few posts above yours. :)
:o Indeed it is. My bad. Thanks.

kevin_r1 04-21-2003 02:36 AM

I'm at a loss. Even after implementing the suggested code fix, I still get the same error. Is there an error in my syntax?
$result = $DB_site->query("SELECT user FROM chatbox_ban WHERE user = '" .addslashes($bbuserinfo[username])."'");

Sadie Frost 04-26-2003 03:01 AM

Quote:

04-14-03 at 11:52 AM Coyii said this in Post #311
I have been trying to modify the chatbox so that it is in a popup instead of on the main page. I tried using the code on pg 4 but I just keep getting "error on page" I did modify the code from shoutbox.php to chatbox.php and removed the space between "java script" and changed 'shout' to 'chat', cant seem to figure out what I am doing wrong.

I looked through all 21 pages of this thread and cant seem to find updated instructions on how to do this.

Has anyone done this?
Can anyone Help?

There's another extra space in there - just go through and take out any extra spaces and it should work :)

Sadie Frost 04-26-2003 11:42 PM

This is a bit of a weird thing. When users submit their comment, when the page refreshes, the input box is gone so they have to reopen the chat to post another comment.

I'm sure I must jsut have missed some code, but I can't find it. If anyone would be so kind to take a look, I'd appreciate it :)

http://www.lotr-boards.com

username: test
password: test

Edit: Okay, here's the problem. I have it so that it shows minimized on my main page, and then when you click on the link it opens the chatbox in a new window.

For some people the chat is maximized on the main page and works fine. But if you close it, then click on the link again it opens the new window and that's where the problem is.

If that made any sense...

Edit Again:

The plot thickens. I believe I have something wrong in my popup code, because if you just type in domain/chatbox.php in the browser window it works fine.

This is what I have for the link to the popup:

<a href="javascript:"; onclick="window.open('chatbox.php','chat','status= 0,directories=0,toolbar=0,location=0,menuBar=0,scr ollbars=0,resizable=0,width=650,height=130,left=10 0,top=100');">

noelmd2001 04-27-2003 06:06 AM

i did a complete search on thir threa but did not seem to find any solution...

my shoutbox is workign great... right layout of the 'go' and icon buttons, members can post messages, right timestamp, smileys showing up in the pop-up box when the smiley icon is clicked...

however, only one problem ..

the smileys do not appear in the shoutbox box itself... but only their short cut words (eg. : ) , : ( , etc)?

i ahve checked everything and seemed to have everything right... but those smiling smileys don't appear where they should be smiling .. in the shoutbox itself...

btw... i put the shoutbox.php in an iframe to a frontpage that i am putting up.. so please excuse the page .. it is just a testing site for the frontpage to be set up...

http://www.ustexchange.com/index2.php

anyway, i hope anybody can help me.. thanks..

:surprised: :cool: :classic: :eek:

Sadie Frost 04-28-2003 05:32 PM

(I got mine to work - thanks to everyone who tried to help! :))

barriedale 04-29-2003 09:10 AM

1)Got the same question as Dennis - How do I make the chatbox appear in reduced mode evertime someone is logging in?

2) is there a way to make the frame of the chatbox dynamic or will that screw things up?

Thanks a lot for this hack - a lot better than Java stuff that wouldn't quite work on Macs! Is anyone working on an update of this one?

Cheers
Michael

magnus 05-01-2003 02:33 AM

Got this error:

Quote:

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT user FROM chatbox_ban WHERE user = 'SSmokin' Joe'
mysql error: You have an error in your SQL syntax near 'Joe'' at line 1

mysql error number: 1064
Tried the fix on the previous page, didn't fix it. Help? :)


Also, I'm trying to get the Chat into a Popup.. I tried the code on previous pages, and it doesn't work either. Has anyone tested these "fixes" in 2.3.0 (which I am using). Thanks.

Otherwise, the hack is working excellent.. the users love it. :)


All times are GMT. The time now is 03:56 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.01921 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
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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