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)
-   -   YAPIH (Yet Another PHPMyChat Integration Hack) 1.0 (https://vborg.vbsupport.ru/showthread.php?t=37209)

BigJohnson 06-13-2002 08:38 AM

This hack look amazing i am just having some trouble with one thing though. When i go to register and i register and click send info i get this data base error.

Database error: Invalid SQL: INSERT INTO user VALUES ('Nem1386', '1', '62fbd3c41f33c0b62996c15429cf55fa', 'Kyle', 'Walker', '', '', 'Nem@aol.com', 0, 'user', '',1023960753, '24.186.207.37', '')
MySQL error: 1136 (Column count doesn't match value count at row 1)
Session halted.

Does anyone no what i can do?

version 06-13-2002 11:26 AM

Quote:

Originally posted by solent
well i try it and i found it great although i have a couple of problems.

First my username and password is not directly passed when i click on the chat rooms although i did exactly as you said.

Second the chat room dose not open in a new window in the specified resolution that i passed to it.

Any ideas please

wherever you are calling the chat url from (whether in a vbb page or in a seperate page) you must make sure that $chatname and $chatpass are declared (i showed how i did it in the phpinclude template), and further that is it correctly passed to the actual chat script. this is totally up to you how you want to do this. i do it via an intermediary script (menu_chat.php), which then interprets $chatname as $username and $chatpass as $password. think about the sequence of how things are layed out and then decide how it must be done for your site, because there is no one-size-fits-all answer.

regarding the chatroom window, you must use a javascript popUp script if you want to specify resolutions.

BigJohnson 06-13-2002 06:13 PM

What about my prb up two posts. ;)

ixian 06-13-2002 06:58 PM

Quote:

Originally posted by version
ixian,

ah, i understand what you mean now. what i can suggest is that you build a front page in PHP, since that can be coded in such a way as to work like SSI (ala include(), exec(), virtual(), etc.), then you can include the global.php and have the phpinclude parsed even for your front page.

what exactly are you trying to display on your front page? give me an example, and maybe i can help out with an alternative.

I'm not gonna rebuild my entire site design for a hack, no matter how good:) Converting to php would totally jack about 900 different things I built.

Here's all I want, maybe I am making this too difficult:

Have a link on my front page to the chat room that auto-logs someone in with their vb name and password, or redirects them to the registration page if not.

What I'm thinking is, I should create a seperate page for chat. Maybe even a vb template. Then, all the link on the front page does is take them to that page, where they can then log in, etc, etc.

Anyone have a quick vb template and a way to call it withen a php page?

solent 06-14-2002 06:32 AM

well version i don't use dhtml menus.

again i passed the exact code as you did in my phpinclude but yet username and password are not passed through.

any other ideas.

by the way great site you have m8. aswome i have to admit that is the best board site i have ever since.

can i contact you to give me a couple of tips??

version 06-14-2002 02:35 PM

sure

ixian 07-01-2002 09:52 PM

Gave up on the front page integration, just created a template for it in vb, and I link to it. Works pretty well now, so off to click the "install" button I go.

Couple quick questions Version:

[Edit - NM, found the answers. I'll post them for others]

Where do you set the page <TITLE> at? Dunno if you know this, but it's set to "ETM Chat" which probably works for you but doesn't apply to me:)

Answer - in the chat/lib/index.lib.php3 file, NOT chat/index.php3. You can change a lot of variables in the former file.

Which CSS file/variables do ya edit for changing the chat color settings (background, etc).

start_page.css.php3. There are many variables - to change the main window background, for example, it's the 'background-color' attribute of the class 'ChatBody'. Play around and enjoy.

Last (guess this is 3 questions:) )

Where do you change the default text users see when they first enter a room?

Still haven't got the answer to this one....yet

Thanks!

solent 07-02-2002 03:51 AM

i still have a problem parseing my variables to the chat javascript window.

everything else works fine.

although i included everything that version said in my phpinclude template.

rstark 07-20-2002 08:21 AM

Quote:

Originally posted by version
(2) Execute the SQL commands in the file 'chat.sql'. This will create the tables needed for PHPMyChat as well as modify your user table. Altering your user table is dangerous, so be sure to have backups handy.

Okay, I'm a dummy. How do you do this? :dead:

solent 07-22-2002 04:07 AM

i am using linux and i do it through webmin. Very easy to execute and backup and administrate any my-sql database.

another solution for you is to do it with phpMyAdmin. it is very cool web based my-sql clinet tool


All times are GMT. The time now is 06:59 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.01127 seconds
  • Memory Usage 1,740KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (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