vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Chat Modifications - Cyb - ChatBox (https://vborg.vbsupport.ru/showthread.php?t=177552)

ComputerVitals 06-07-2008 08:06 PM

I'm getting a database error.

I'm not sure where it coming from but it is reproduceable.

Here's the error

Code:

Database error in vBulletin 3.7.1:

Invalid SQL:
SELECT * FROM vb_chatbox ORDER BY dateline ASC LIMIT 0,;

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 '' at line 1
Error Number  : 1064
Request Date  : Saturday, June 7th 2008 @ 03:38:41 PM
Error Date    : Saturday, June 7th 2008 @ 03:38:41 PM
Script        : http://www.computervitals.com/forum/chatbox.php?nofocus=1
Referrer      :
IP Address    : 88.131.106.13
Username      : Unregistered
Classname    : vB_Database
MySQL Version :

Any ideas?

Valter 06-07-2008 09:12 PM

"vb_chatbox" table is not part of this hack.

dodgechargerfan 06-07-2008 09:14 PM

Quote:

Originally Posted by dodgechargerfan (Post 1542715)
Installed and working fine but I have my host set up to send me e-mails of any database errors. With the chatbox enabled, I get this error over and over again:

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/BOARDNAME/public_html/forums/includes/class_core.php on line 311

The script that is being called is always different and the user IP address is always different.

The e-mails stop as soon as I disable the product in ACP.

Any ideas?

Not sure what it was, but I went through and worked on all of the errors in my error log and this problem is now gone... :confused:

ComputerVitals 06-07-2008 09:28 PM

Quote:

Originally Posted by Cybernetec (Post 1543521)
"vb_chatbox" table is not part of this hack.


Interesting...

Must have been Dreams chatbox.... I know I had that install long long time ago..
Now I'm thinking it could be a bot looking at old urls?

H o p e Z 06-10-2008 06:31 AM

just to let you know works with 3.7.1 perfect nice mod

Animecraving 06-10-2008 11:27 PM

it would be nice if you can add a submit button for this one
cuz since some of my friend suggested it that they're using like phone/psp to get online

Darkfire122333 06-11-2008 03:30 AM

I changed the XML to meet my needs... (screenshot of what this does attached) THIS INCLUDES a submit button...

Changed this:

PHP Code:

                <tbody id="collapseobj_cybcb_boxswitch" style="<if condition="$vboptions[cybchatbox_collapsed_always]"><if condition="(THIS_SCRIPT!='misc')">display:none</if><else />$vbcollapse[collapseobj_cybcb_boxswitch]</if>">
                    <
tr valign="top">
                        <
td class="alt2" width="1%">
                            <
div style="white-space:nowrap;width:100%;height:25px;display:block;">
                                <
input id="ccb_m_bold" type="button" class="button" style="width:30px;font-weight:bold;" value="B" onclick='Ccb_updateSButton(this, "fontWeight")' <if condition="$cybcb_cantpost">disabled="disabled"</if> />
                                <
input id="ccb_m_italic" type="button" class="button" style="width:30px;font-style:italic;" value="I" onclick='Ccb_updateSButton(this, "fontStyle")' <if condition="$cybcb_cantpost">disabled="disabled"</if> />
                                <
input id="ccb_m_underline" type="button" class="button" style="width:30px;text-decoration:underline;" value="U" onclick='Ccb_updateSButton(this, "textDecoration")' <if condition="$cybcb_cantpost">disabled="disabled"</if> />
                                <
select id="ccb_m_color" name="ccb_m_color" style="width:50px;background-color:black;" onchange='Ccb_updateColor(this, "color");Ccb_Init();' <if condition="$cybcb_cantpost">disabled="disabled"</if>>
                                    <
option style="background-color:$stylevar[alt1_fgcolor];color:$stylevar[alt1_fgcolor];" value="$stylevar[alt1_fgcolor]selected="selected">&nbsp;</option>
                                    
$cybcb_colors
                                
</select>
                                <if 
condition="(($vboptions[cybchatbox_smiliestotal]!=0) AND !$cybcb_cantpost AND $cybcb_smilies_init)">
                                    <
span id="cybchatmenusmilies">$vbphrase[smilies] <script language="Javascript" type="text/javascript"vbmenu_register("cybchatmenusmilies"); </script></span>
                                    <
span class="vbmenu_popup" id="cybchatmenusmilies_menu" style="display:none;">
                                        <
table cellpadding="0" cellspacing="0" border="0">
                                            <
tr>
                                                <
td class="thead">$vbphrase[smilies]</td>
                                            </
tr>
                                            <
tr>
                                                <
td class="alt2">
                                                    <
div id="cybcb_smiliesarea" style="max-height:200px;overflow:auto;background-color:$stylevar[alt1_bgcolor];border-top:0px;border-bottom:1px;border-left:0px;border-right:0px;border-color:$stylevar[time_fgcolor];border-style:dashed;">
                                                        <
div id="cybcb_smiliesarea_init" style="overflow:auto;background-color:$stylevar[alt1_bgcolor];border-top:0px;border-bottom:1px;border-left:0px;border-right:0px;border-color:$stylevar[time_fgcolor];border-style:dashed;">
                                                            
$cybcb_smilies_init
                                                        
</div>
                                                        <
div id="cybcb_smiliesarea_full" style="background-color:$stylevar[alt1_bgcolor];margin:1px;">
                                                            <
span id="cybcb_smilies_more" class="smallfont" style="display:inline;">
                                                                <
a href="javascript:void(0);" onclick="Ccb_getSmilies();" style="text-decoration:none;">$vbphrase[more]</a>
                                                            </
span>
                                                            <
span id="cybcb_smilies_loading" class="smallfont" style="display:none;">
                                                                
$vbphrase[cybcb_loading]
                                                            </
span>
                                                        </
div>
                                                    </
div>
                                                    <
div align="center" style="margin:4px;">
                                                        <
img id="cybcb_smiliepreview" src="$cybcb_smilie_firstborder="0" alt="" />
                                                    </
div>
                                                </
td>
                                            </
tr>
                                        </
table>
                                    </
span>
                                </if>
                            </
div>
                            <
textarea name="ccb_entermessage" id="ccb_entermessage" class="smallfont" style="width:99%;height:$cybcb_height_input;overflow:auto;color:$stylevar[alt1_fgcolor];background-color:$stylevar[alt1_bgcolor];border:0px;" onkeydown="if (event.keyCode == 13) {return Ccb_postMessage(cybcb_post_form);}"  onfocus="if(!this._haschanged){this.value=''};this._haschanged=true;" <if condition="$cybcb_cantpost">disabled="disabled"</if> rows="1" cols="1">$vbphrase[message]...</textarea>
                        </
td>
                        <
td class="alt2">
                            <
div id="cybcb_messagearea" style="overflow:auto;height:$cybcb_height_messarea;width:100%;border:0px;background-color:$stylevar[alt2_bgcolor]">
                                
$vbphrase[cybcb_loading]
                            </
div>
                        </
td>
                    </
tr>
                    <if 
condition="$vboptions[cybchatbox_belownote]">
                    <
tr>
                        <
td class="alt2" align="$stylevar[left]colspan="3">
                            <
div class="smallfont" style="float:$stylevar[right];">$vbphrase[cybcb_chatbox_note]</div>
                        </
td>
                    </
tr>
                    </if>
                </
tbody

To this:


PHP Code:

                <tbody id="collapseobj_cybcb_boxswitch" style="<if condition="$vboptions[cybchatbox_collapsed_always]"><if condition="(THIS_SCRIPT!='misc')">display:none</if><else />$vbcollapse[collapseobj_cybcb_boxswitch]</if>">
                    <
tr valign="top">
                        <
td class="alt2">
                            <
textarea name="ccb_entermessage" id="ccb_entermessage" class="smallfont" style="width:92%;height:15px;overflow:auto;color:$stylevar[alt1_fgcolor];background-color:$stylevar[alt1_bgcolor];border:0px;" onkeydown="if (event.keyCode == 13) {return Ccb_postMessage(cybcb_post_form);}"  onfocus="if(!this._haschanged){this.value=''};this._haschanged=true;" <if condition="$cybcb_cantpost">disabled="disabled"</if> rows="1" cols="1">$vbphrase[message]...</textarea>&nbsp;<input type="submit" value="Submit" id="submit" />
                        </
td>
                    </
tr>
                    <
tr valign="top">
                        <
td class="alt2">
                            <
div id="cybcb_messagearea" style="overflow:auto;height:$cybcb_height_messarea;width:100%;border:0px;background-color:$stylevar[alt2_bgcolor]">
                                
$vbphrase[cybcb_loading]
                            </
div>
                        </
td>
                    </
tr>
                    <if 
condition="$vboptions[cybchatbox_belownote]">
                    <
tr>
                        <
td class="alt2" align="$stylevar[left]colspan="3">
                            <
div class="smallfont" style="float:$stylevar[right];">$vbphrase[cybcb_chatbox_note]</div>
                        </
td>
                    </
tr>
                    </if>
                </
tbody

Edit: added new screenshot, old one did not have submit button

Animecraving 06-11-2008 05:05 AM

oh i see all you need is put the <input type="submit" value="Submit" id="submit" /> in

Darkfire122333 06-11-2008 05:29 AM

Yes, but make sure it stays inside the <form> </form> tags.

PHP Code:

        <form name="cybcb_post_form" action="misc.php?$session[sessionurl]&securitytoken=$cybcb_sectokmethod="post" onsubmit="return Ccb_postMessage(this)">
            <
input type="hidden" name="do" value="cb_postnew" />
            <
input type="hidden" name="color" />
            <
input type="hidden" name="fontWeight" />
            <
input type="hidden" name="fontStyle" />
            <
input type="hidden" name="textDecoration" />

            <
table class="tborder" cellpadding="$stylevar[cellpadding]cellspacing="$stylevar[cellspacing]border="0" width="100%" align="center">
                <
thead>
                    <
tr>
                        <
td class="<if condition="($vboptions[cybchatbox_box_style]==1)">tcat<else />thead</if>" colspan="3">
                            <
a style="float:$stylevar[right]href="#top" onclick="return toggle_collapse('cybcb_boxswitch')"><img id="collapseimg_cybcb_boxswitch" src="$stylevar[imgdir_button]/collapse_<if condition="($vboptions[cybchatbox_box_style]==1)">tcat<else />thead</if>$vbcollapse[collapseimg_cybcb_boxswitch].gif" alt="" border="0" /></a>
                            <
span id="cybchatmenuccbox"><if condition="($_REQUEST['do']!='cchatbox')">$vbphrase[cybcb_chatbox]<else />$vbphrase[cybcb_chatbox_full]</if> <script language="Javascript" type="text/javascript"vbmenu_register("cybchatmenuccbox"); </script></span> <span class="smallfont" id="cybcb_newinfoarea" style="display:inline;">($cybcb_newstat)</span>
                        </
td>
                    </
tr>
                </
thead>
                <
tbody id="collapseobj_cybcb_boxswitch" style="<if condition="$vboptions[cybchatbox_collapsed_always]"><if condition="(THIS_SCRIPT!='misc')">display:none</if><else />$vbcollapse[collapseobj_cybcb_boxswitch]</if>">
                    <
tr valign="top">
                        <
td class="alt2">
                            <
textarea name="ccb_entermessage" id="ccb_entermessage" class="smallfont" style="width:92%;height:15px;overflow:auto;color:$stylevar[alt1_fgcolor];background-color:$stylevar[alt1_bgcolor];border:0px;" onkeydown="if (event.keyCode == 13) {return Ccb_postMessage(cybcb_post_form);}"  onfocus="if(!this._haschanged){this.value=''};this._haschanged=true;" <if condition="$cybcb_cantpost">disabled="disabled"</if> rows="1" cols="1">$vbphrase[message]...</textarea>&nbsp;<input type="submit" value="Submit" id="submit" />
                        </
td>
                    </
tr>
                    <
tr valign="top">
                        <
td class="alt2">
                            <
div id="cybcb_messagearea" style="overflow:auto;height:$cybcb_height_messarea;width:100%;border:0px;background-color:$stylevar[alt2_bgcolor]">
                                
$vbphrase[cybcb_loading]
                            </
div>
                        </
td>
                    </
tr>
                    <if 
condition="$vboptions[cybchatbox_belownote]">
                    <
tr>
                        <
td class="alt2" align="$stylevar[left]colspan="3">
                            <
div class="smallfont" style="float:$stylevar[right];">$vbphrase[cybcb_chatbox_note]</div>
                        </
td>
                    </
tr>
                    </if>
                </
tbody>
            </
table>
        </
form

that is mine, all i edited was the part that you see above.. the form tag is there from the cyb chatbox. just want you to understand completely :)

by the way.. don't forget to re-install the xml after the edits :D

Animecraving 06-11-2008 06:09 AM

well but i added it in different way i added this
Code:

<input type="submit" class="button" value="&#x21B5;" style="height:19px;" id="submit" />
before all the other bb code buttons


All times are GMT. The time now is 11:44 AM.

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.01990 seconds
  • Memory Usage 1,909KB
  • 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
  • (2)bbcode_code_printable
  • (3)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)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