egghelp/eggheads community

Get a list of a mysql select

2007-04-30T21:25:08-04:00

I got it now thanks for the script, works fine.

The problem was that the updater said I got the newest version, but that was not correct.

I deinstalled the current version and installed a new fresh 3.02 now. Strange with this update thing but it works now

Statistics: Posted by Psyfire — Mon Apr 30, 2007 9:25 pm

Get a list of a mysql select

2007-04-27T21:18:38-04:00

Well, that error you reported above, does indicate that your module is either broken, or you've failed to load it properly.
You could always check your other scripts, that you say are working, for hints on what you'd have to change to make it work..

Statistics: Posted by nml375 — Fri Apr 27, 2007 9:18 pm

Get a list of a mysql select

2007-04-27T19:21:36-04:00

I am running definitly 3.02.

The module is loaded of course, otherwise my other mysql scripts wont work and they work 100%.

Statistics: Posted by Psyfire — Fri Apr 27, 2007 7:21 pm

Get a list of a mysql select

2007-04-27T10:24:03-04:00

Simply... if you've got mysqltcl v3.0, the ::mysql::query command should be available (obviously assuming you've loaded the module properly...)
If you're using any other version, it would be mysqlquery.
Since you failed to mention which version of mysqltcl you're using, I can't tell which syntax would be proper for you...

Statistics: Posted by nml375 — Fri Apr 27, 2007 10:24 am

Get a list of a mysql select

2007-04-27T08:33:08-04:00

Building Dependency Tree... Done
mysqltcl is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 16 not upgraded.

And now? I got the last version...

Statistics: Posted by Psyfire — Fri Apr 27, 2007 8:33 am

Get a list of a mysql select

2007-04-25T15:45:39-04:00

Then you're using an older version of mysqltcl. The main difference is older version uses command-names such as mysqlquery while the newer uses namespaces, ie ::mysql::query.

In any case, the docs on their webpage should be enough to atleast get you started...
A good place to start would be the mysqlsel command...

Statistics: Posted by nml375 — Wed Apr 25, 2007 3:45 pm

Get a list of a mysql select

2007-04-25T12:54:33-04:00

Tcl error [srh_top]: invalid command name "::mysql::query"

Statistics: Posted by Psyfire — Wed Apr 25, 2007 12:54 pm

Get a list of a mysql select

2007-04-25T16:17:56-04:00

Code:

## CONF ### trigger to search top10set srch(top10) "!top10"# SQL infoset sql(host) "IP"set sql(user) "USER"set sql(pass) "PASS-BLA"set sql(db) "DATABASE-NAME"set sql(port) "PORT"## END CONF ##package require mysqltclbind pub - $srch(top10) srh_topproc srh_top {nick host hand chan arg} {global sqlset sql(handle) [mysqlconnect -host $sql(host) -user $sql(user) -password $sql(pass) -db $sql(db) -port $sql(port)]set query [::mysql::query $sql(handle) "SELECT ps_plr.plrid, ps_plr.uniqueid, ps_plr.rank, ps_plr.skill, ps_plr_profile.name FROM ps_plr, ps_plr_profile WHERE allowrank =1 AND ps_plr.uniqueid = ps_plr_profile.uniqueid ORDER BY skill DESC LIMIT 10"]while {[set row [::mysql::fetch $query]] != ""} {set plrid [lindex $row 0]set id [lindex $row 1]set rank [lindex $row 2]set skill [lindex $row 3]set name [lindex $row 4]putquick "PRIVMSG $chan :\00314\002\[\017\002#$rank\00314\]\002\00314 ~ \002\00307Player\017: $name \00314~\017 \002\00307Skill\017: $skill \00314~\002\00307 iD\017: $id \00314~\002\00307 PLRiD\017: $plrid "}::mysql::endquery $querymysqlclose $sql(handle)}putlog "Top10.tcl loaded"

didn't tested , but think its ok

Statistics: Posted by w00f — Wed Apr 25, 2007 11:33 am

Get a list of a mysql select

2007-04-24T12:51:19-04:00

I use mysqltcl in my script but I dont know how to create a list that ouputs that data.

Statistics: Posted by Psyfire — Tue Apr 24, 2007 12:51 pm

Get a list of a mysql select

2007-04-24T08:31:59-04:00

You'll probably have to use the mysqltcl interface, or something similar. If you use mysqltcl, the documentation is available on their homepage.

Statistics: Posted by nml375 — Tue Apr 24, 2007 8:31 am

Get a list of a mysql select

2007-04-23T20:33:34-04:00

Hello,

if I type this in phpmyadmin console:

Code:

SELECT ps_plr.plrid, ps_plr.uniqueid, ps_plr.rank, ps_plr.skill, ps_plr_profile.nameFROM ps_plr, ps_plr_profileWHERE allowrank =1AND ps_plr.uniqueid = ps_plr_profile.uniqueidORDER BY skill DESCLIMIT 10

I get this list:

Code:

710  STEAM_0:1:1889849  1  1963.16  ()()7803 STEAM_0:1:12916169 2 1945.60 brasil_fr.953 STEAM_0:1:859266 3 1881.20 SriQst iZ qL50 STEAM_0:1:11381583 4 1848.65 Uncle902 STEAM_0:0:14033485 5 1842.98 The Prophet976 STEAM_0:1:14352136 6 1834.15 w0ll4k800 STEAM_0:0:3850505 7 1815.94 EmBri0.Iceman 1001 STEAM_0:1:72535 8 1815.44 busheteeeeeeeeeeeee944 STEAM_0:1:12625835 9 1781.13 yohan736 STEAM_0:1:10075317 10 1757.44 JaNoVsKi

Thats my output of the select. Now I want to implement this list via a /top10 command in a tcl script.

The problem is, that I dont know how to get this list with this all variables. Can somebody help me?

Statistics: Posted by Psyfire — Mon Apr 23, 2007 8:33 pm