Data Output

2018-01-29T06:57:52-04:00

Sorry for the late answer. You can achieve this directly from the select with:

Code:

SELECT owner, group_concat(botname) AS bots FROM bots GROUP BY owner

and the result is:

Code:

owner / botsalterego / PREvision,dapreDarkSide / DarkSideMaTr1X / MaTr1XTurQ / AddFeeD,KaNE,PR3,|PR3|,TRiAD

Your code becomes:

Code:

proc dupe:owners {nick uhost hand chan text} {global mysql_ otable_ chan_ db_handle bopen bdiv bclose   if {![mysqlsel $db_handle "SELECT owner, group_concat(botname) AS bots FROM bots GROUP BY owner"]} {putnow "PRIVMSG $chan_(addbot) :No results found\."return}mysqlmap $db_handle {owner bots} {putnow "PRIVMSG $chan :${bopen}\00303OWNERS\003${bclose} \00314$owner owns [join [split $bots ","] ", "]\003"}     }

Statistics: Posted by caesar — Mon Jan 29, 2018 6:57 am

Data Output

2018-05-17T11:40:31-04:00

Hi guys just scripted a small proc to display bots and owners from a database it outputs like this atm

Code:

[9:48am] <~TurQ> !owners[9:48am] <+ClonE> [OWNERS] *** owns *******[9:48am] <+ClonE> [OWNERS] *** owns ****[9:48am] <+ClonE> [OWNERS] *** owns ****[9:48am] <+ClonE> [OWNERS] **** owns ****[9:48am] <+ClonE> [OWNERS] *** owns ***

if possible i would to output it like this

Code:

[OWNERS] owner1 owns bot1, bot2, bot3 [OWNERS] owner2 owns bot1, bot2

so it would be one owner per line instead of multiple lines
here is my proc so far

Code:

##################################### !owners      ######################################################proc dupe:owners { nick uhost hand chan arg } {global mysql_ otable_ chan_ db_handle bopen bdiv bclose   if {![mysqlsel $db_handle "SELECT `id` , `owner` , `botname` FROM `bots`"]} {putnow "PRIVMSG $chan_(addbot) :No results found\."; return 0}                      mysqlmap $db_handle {id owner botname} {                putnow "PRIVMSG $chan :${bopen}\00303OWNERS\003${bclose} \00314$owner owns $botname\003"    }          }

many thx in advance

Statistics: Posted by COBRa — Fri Dec 29, 2017 6:16 am

egghelp/eggheads community

Data Output

Data Output