vb.org Archive
Page 4 of 28 « First 23 4 5614 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Chat Modifications - [AJAX] cChatBox (https://vborg.vbsupport.ru/showthread.php?t=169725)

christrato 02-12-2008 01:28 PM
Quote:
Originally Posted by trance nation (Post 1441309)
It made some of my forum text red >.< - sorted

When i enable the online suer list i get a mysql error

Database error in vBulletin 3.7.0 Beta 4:

Invalid SQL:

(SELECT DISTINCT user.username AS username,user.userid,session.userid,user.options AS options,cchatbox.username AS cchatusername
FROM vb_cchatbox_message AS cchatbox
LEFT JOIN vb_user AS user USING (userid)
LEFT JOIN vb_session AS session USING (userid)
WHERE session.lastactivity > 1202809562 AND cchatbox.userid = user.userid AND cchatbox.time > 1202810462 - (0*3600)
ORDER BY cchatusername ASC)
UNION DISTINCT
(SELECT DISTINCT user.username AS username,user.userid,session.userid,user.options AS options,cchatbox.username AS cchatusername
FROM vb_session AS session
LEFT JOIN vb_user AS user USING (userid)
LEFT JOIN cchatbox_message AS cchatbox USING (userid)
WHERE session.lastactivity > 1202809562 AND user.userid = session.userid
ORDER BY username ASC);;

MySQL Error : Table 'servermax5.cchatbox_message' doesn't exist
Error Number : 1146
Date : Tuesday, February 12th 2008 @ 10:01:02 AM
Script : http://www.xevolution.co.uk/cchatbox.php?do=userlist
Referrer : http://www.xevolution.co.uk/index.php
IP Address :******
Username : *****
Classname : vB_Database
MySQL Version : 5.0.22

I did put my prefixes as vb_ maybe thats why?

I correct this problem, but it seems to me wrong.

Go to line: 284 and substitute this code into file "functions_cchatbox.php":

PHP Code:
            LEFT JOIN cchatbox_message AS cchatbox USING (userid) 
with:

PHP Code:
            LEFT JOIN " . TABLE_PREFIX . "cchatbox_message AS cchatbox USING (userid) 
bye and excuse me :(

trance nation 02-12-2008 02:10 PM
What file am i looking at?

Namaless 02-12-2008 02:15 PM
Another fix (I have fixed in old version, but with new version you have recreate bug).

For fetch_musername require all user informations. THis is fixed function:
PHP Code:
    function tagusername($userid, $username)
     {
        global $db, $vbulletin;
        
         $tagusername = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "user WHERE userid = $userid;");
        
         if ($tagusername['username'] == $username) {
            
             return fetch_musername($tagusername);
            
             } else {
            
            return $username;
            
             } 
        
        } 
Get this :)

Bye !

trance nation 02-12-2008 02:17 PM
I hate being new, How do i add that :p

christrato 02-12-2008 04:54 PM
Quote:
Originally Posted by Namaless (Post 1441476)
Another fix (I have fixed in old version, but with new version you have recreate bug).

For fetch_musername require all user informations. THis is fixed function:
PHP Code:
    function tagusername($userid, $username)
     {
        global $db, $vbulletin;
        
         $tagusername = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "user WHERE userid = $userid;");
        
         if ($tagusername['username'] == $username) {
            
             return fetch_musername($tagusername);
            
             } else {
            
            return $username;
            
             } 
        
        } 
Get this :)

Bye !

are you sure that this function require all informations???

works with only usegroupid and username.

if you see the functions inside the file functions.php you can see that this functions require only "username" and "usergroupid".

bye

trance nation 02-13-2008 08:17 AM
Password on the rar, Help?

christrato 02-13-2008 08:28 AM
opssssssssssssss! excuse me! i have zipped file with password for error :( now have reupload the file with no password. excuse me :(

trance nation 02-13-2008 08:31 AM
Thanks, Amazing work!

Fearlessninja 02-13-2008 06:38 PM
I suggest a way to give bots custom commands =) with custom answers/responses. That will make this make awesome!

christrato 02-13-2008 07:43 PM
Quote:
Originally Posted by Fearlessninja (Post 1442419)
I suggest a way to give bots custom commands =) with custom answers/responses. That will make this make awesome!
you can custom the answers / response from the admincp -> language & phrases -> search phrases

for the custom commands... i think in future ;)


All times are GMT. The time now is 03:30 AM.
Page 4 of 28 « First 23 4 5614 Last »
Show 40 post(s) from this thread on one page

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.01388 seconds
  • Memory Usage 1,758KB
  • 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_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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