Data Output

[COBRa]

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

Code: Select all

[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: Select all

[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: Select all

###################################
## !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

[caesar]

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

Code: Select all

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

and the result is:

Code: Select all

owner / bots
alterego / PREvision,dapre
DarkSide / DarkSide
MaTr1X / MaTr1X
TurQ / AddFeeD,KaNE,PR3,|PR3|,TRiAD

Your code becomes:

Code: Select all

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"
	}     
}