Major Additions - [AJAX] EWT Chat 3.0.1 Lite

This is a php/mySQL powered chat system.

EWT Chat 3.0.0 Lite Changes
-Complete Recode
-Enhanced ajax which performs much faster and should allow for an additional load of 500% compared to the last release of 2.9.x
-Many changes to everything
-Remove private message system for now
-Remove /cmds besides /me for now

EWT Chat 3.0.01 Lite Changes
-Redid layout and javascript for planned changes to the pro side and to make things look cleaner.
-fixed various little things.

Whats the difference between pro and lite?
Lite:
The lite version supports only one chat room with no ability to create custom rooms.
It doesnt have any user preferences anymore either.
Basic yet functional chatroom without advanced features

Pro: (Still being developed)
Ability to create custom and private rooms
Plus many more things soon to come.

I think this release fixes every reported bug that I have read about.




Version 2.9.x to 3.0.0 Upgrade Steps:
Upload all the files
Upload the product file
Delete any old files from the previous versions
Disable the minichat addon if you have it for now as it wont work with v3 just yet until I release an updated version.
Open up the fresh install readme and follow the steps for editing ajax_chat.php (just a few settings I didnt feel we needed to use a query for)


2.9.1 to 2.9.2 Upgrade Steps:
Open up template navbar find:

<script type="text/javascript">
<!--

function OpenvBChat(){
vBChat = window.open('vBChat.php?$session[sessionurl]','vBChat','directories=no,height='+window.screen.height+',width='+window.screen.width+',location=no,menubar=no,scrollbars=yes,status=no,toolbar=no')

return false;
}

-->
</script>
<td class="vbmenu_control"><a href="vBChat.php?$session[sessionurl]" onclick="return OpenvBChat();">vBChat</a></td>

Replace with:

<script type="text/javascript">
<!--

function OpenvBChat(){
vBChat = window.open('chat.php?$session[sessionurl]','vBChat','directories=no,height='+window.screen.height+',width='+window.screen.width+',location=no,menubar=no,scrollbars=yes,status=no,toolbar=no')

return false;
}

-->
</script>
<td class="vbmenu_control"><a href="chat.php?$session[sessionurl]" onclick="return OpenvBChat();">vBChat</a></td>

Demo:
http://www.extremewebtech.com/forums/chat.php
User/Password: test2323 / test2323


Please if you use this hack click install and feel free to donate to help support the future development of this system.


V3 is a highlight release for this product as it runs and performs much faster then ever before and can now handle a considerable amt of load.

This chat script should technically be able to support 1k+ users on a good high end server.


Pro Version Information Can Be Found Here: http://www.extremewebtech.com/forums...305-ewt-vbchat

[eXtremeTim]

Theres a column on the user table as well vbchat_prefs.

[baddude]

Ummm I didn't see that one.. Can u tell me where to find that, I looked all over the database tables and that isnt there.. Thanks

[maroceve]

ExtremeTim, i think you should look closely at this problem because i do not recall installing your addon before ?

And i am looking for this vbchat_prefs that i cannot find.

thanks

[Ryloth]

it doesn't have to be his product that you installed before. it could have been an old install of flashchat or vbchat etc. i am a double ms certified dba. his queries are sound. if you have these tables and columns already existing and you try to re-create the same table, mysql will throw the error u r seeing plain and simple. go into your database, delete the two vbchat tables and the 3 vbchat columns in the user table and re-install.

he could easily drop those tables/columns programatically but then people would complain about losing data. he could also run if exists in sysobjects (sql sorry) then alter instead of create object.

[Ryloth]

hey tim, here is where the fun starts. i removed all database entries, overwrote all files on my server w/ the files in your download, uploaded a new product using your xml.... and i only see these options in my admin cp:

Banned Users
EWT vBChat Room Control
EWT vBChat Prune Options

and when u click on banned users, just gray screen. nothing.

[mktrilogy]

Originally Posted by Ryloth

hey tim, here is where the fun starts. i removed all database entries, overwrote all files on my server w/ the files in your download, uploaded a new product using your xml.... and i only see these options in my admin cp:


Banned Users
EWT vBChat Room Control
EWT vBChat Prune Options


and when u click on banned users, just gray screen. nothing.

Same here

[Ryloth]

it looks like his admincp file is an old version/wrong file that he zipped up.

[maroceve]

great !

[Chadi]

No screen shots and live demo doesn't work.

[Chadi]

Originally Posted by chadi

I keep getting this error when attempting to upload the plugin xml file:

 Database error in vBulletin xxx:
   
  Invalid SQL:
  alter table user
  add vbchat_pref_font_face varchar(255) not null default '', add vbchat_pref_font_color varchar(255) not null default '', add vbchat_pref_user_ignore text not null default '';;
   
  MySQL Error  : Duplicate column name 'vbchat_pref_font_face'
  Error Number : 1060
  Date         : Sunday, April 22nd 2007 @ 01:43:47 PM
  Script       : http://www.talkjesus.com/admincp/plugin.php?do=productimport
  Referrer     : http://www.talkjesus.com/admincp/plugin.php?do=productadd
  IP Address   : xxx
  Username     : Chad
  Classname    : vb_database

Problem is I do not see that in the database at all. I do want to clarify that I've installed the old vbchat 2.3x a long time ago, but never uninstalled.

I still get the same error on 2.6