i am in need of help,
i need a script that outputs the result of an mysql qry:
Code: Select all
SELECT g.galaxy,g.system,g.planet,g.moon,a.allyname,p.playername,a.members FROM galaxy g LEFT JOIN players p ON (g.player_id=p.id) LEFT JOIN alliances a ON (p.alliance_id=a.id) LEFT JOIN notices n ON (g.player_id = n.player_id) LEFT JOIN reports r ON (g.galaxy = r.galaxy AND g.system = r.system AND g.planet = r.planet AND r.moon='false') WHERE p.playername LIKE 'ilovecc' AND (g.player_id > 0) ORDER BY galaxy,system,planet ASC LIMIT 0,20
Code: Select all
galaxy system planet moon allyname playername members
1 353 8 true FN ILoveCC 25
2 474 11 true FN ILoveCC 25
3 111 4 true FN ILoveCC 25
4 474 4 true FN ILoveCC 25
5 200 4 true FN ILoveCC 25
6 279 4 true FN ILoveCC 25
7 234 4 true FN ILoveCC 25
8 234 4 true FN ILoveCC 25
9 377 7 false FN ILoveCC 25
Coords of Player: ILoveCC - Ally: FN (25) : 1:353:8 [M] | 2:474:11 [M] | 3:111:4 [M]... and so on ..
"!pcoords IloveCC" should be the way one can request this ..from the channel
i hope someone is willing & capable to help me out with this cause i got no clue how to format that mysql output and bring it to irc ...
if you need additional infos ...pls ask ..
also pls excuse my bad written english
thx...
Cidem