| View previous topic :: View next topic |
| Author |
Message |
T-Xorcist
Halfop
Joined: 14 Nov 2005
Posts: 47
Location: Netherlands
|
 Posted: Tue May 09, 2006 7:21 pm Post subject: [MySQL] Not doing anything with mysqltcl |
 |
|
Hi all!
I just started to work with mysqltcl, but I can't find the error. I have the following code:
| Code: | proc test {nick host hand chan arg} {
package require mysqltcl
set mysql(conn) [mysqlconnect -host localhost -user tbot -db tbot -password xxxxxxx]
[b][u]set query "SELECT id FROM channels WHERE name = 'T-Xorcist'"
set chanid [mysqlsel $mysql(conn) $query -list][/u][/b]
mysqlclose $mysql(conn)
} |
The wanabee bold/underlined lines are the problem! If I remove that line, it works.
What is wrong with this script? I am looking for 3 hours now 
Thanks in advance!
_________________
is-1337.org IRC server! |
|
| Back to top |
|
 |
demond
Revered One
Joined: 12 Jun 2004
Posts: 3073
Location: San Francisco, CA
|
| Posted: Wed May 10, 2006 1:11 am Post subject: Re: [MySQL] Not doing anything with mysqltcl |
|
|
| T-Xorcist wrote: |
What is wrong with this script? I am looking for 3 hours now
|
the 'wanabee bold/underlined lines'?
_________________
connection, sharing, dcc problems? click <here>
before asking for scripting help, read <this>
use [code] tag when posting logs, code |
|
| Back to top |
|
|
T-Xorcist
Halfop
Joined: 14 Nov 2005
Posts: 47
Location: Netherlands
|
| Posted: Wed May 10, 2006 9:23 am Post subject: |
|
|
Hm, my MySQL user / password wasn't correct :S
Which is very strange, because it is there. Oh wel, sorry for bothering you guys
1 more question: how can I remove all the channels at ones? like:
channel remove * ? Is that possible?
_________________
is-1337.org IRC server! |
|
| Back to top |
|
|
De Kus
Revered One
Joined: 15 Dec 2002
Posts: 1361
Location: Germany
|
| Posted: Wed May 10, 2006 8:05 pm Post subject: |
|
|
| T-Xorcist wrote: | 1 more question: how can I remove all the channels at ones? like:
channel remove * ? Is that possible? |
Try it. I am for sure NOT going to try it on my bot  .
_________________
De Kus
StarZ|De_Kus, De_Kus or DeKus on IRC
Copyright © 2005-2009 by De Kus - published under The MIT License
Love hurts, love strengthens... |
|
| Back to top |
|
|
T-Xorcist
Halfop
Joined: 14 Nov 2005
Posts: 47
Location: Netherlands
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Any ideas?