Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 09 May 2004, 17:29
hubba hubba is offline
 
Join Date: Dec 2003
Error, why?

Just tring to get the chat "whos online" to work. Gives an error 1064 in VB3

--------------------

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

-------------------

it comes

Ungueltige SQL-Abfrage: UPDATE user SET lastchatactivity= WHERE userid='1'
mysql error: You have an error in your SQL syntax.

Any idea perhaps?

Last edited by Xenon; 09 May 2004 at 20:17.
Reply With Quote
  #2  
Old 09 May 2004, 18:01
assassingod's Avatar
assassingod assassingod is offline
 
Join Date: Jul 2002
Try using

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

for the second query. The query is saying that there isn't a value for $lastvisit so that's maybe why youre getting the error. Make sure $lastvisit has a value too.
Reply With Quote
  #3  
Old 12 May 2004, 16:39
hubba hubba is offline
 
Join Date: Dec 2003
Ah thx a lot, that worked. But there is also something wrong, the script was for VB 2, perhaps you can telle me what to change for VB3?

----------------

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Last edited by Xenon; 12 May 2004 at 17:48.
Reply With Quote
  #4  
Old 12 May 2004, 19:30
Velocd's Avatar
Velocd Velocd is offline
 
Join Date: Mar 2002
Real name: Mike
Replace:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

With:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

I'm not sure what kind of chat you have, but if it's IRC I suggest taking a look at the vB3 mIRC & Eggdrop hacks I have for displaying who is online from your chat (see my sig).
Reply With Quote
  #5  
Old 12 May 2004, 19:36
hubba hubba is offline
 
Join Date: Dec 2003
Thanks, Velocd, I try it. Its an IRC chat, but my provider does not allow eggdrops. I also tried the Mirc Script but I am not online day and night. So I try to get this to work:

http://www.vbulletin.org/forum/showt...168#post508168
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 06:25.

Layout Options | Width: Wide Color: