Service for Stats and Mysql Info (User/Channel/..)

Number · Post by **Number** » Thu Mar 03, 2005 6:57 pm

Hello Everybody ..
i'm a belgium guy and i'm 19 years old..
i sudy info at school .

I'm a newbie In irc and i have to many questions ...
Yesterday I succeeded to install UnrealIrcd3.2 And Anope 1.7 on Win32 ...

The irc server run sucessfuly ...
And now i would like to have someone Like Irc Stats (Number of user / day .. Hours of conenction.. ....)

And i would like also a services to have Myql info . (Like Nbr of user. Info about a user, Name of channel and nÂ° of user in the channel, ...)

But i work on win and i see Thales but i don't fin anithing for win32..

And for the laste i would like to know how i can Link two Unrealircd and if i need also to install service on the other unrealirc ??

(Sorry for my english but i leaver french ... )

I hope that it is comprehensible ..

Trystan · Post by **Trystan** » Fri Mar 04, 2005 1:58 am

NeoStats has a v3.0 which is alpha it has a windows build.
Believe also that SolarStats has a windows port

w00t · Post by **w00t** » Fri Mar 04, 2005 4:46 am

It wouldn't be hard to say, create a PHP/insert language here thingy that connects and dumps the information to a db/textfile/whatever.

In fact, I did just this. Sure, it's static, but if you schedule it... or just change it a bit to make it run automatically, whatever....

If i'm feeling nice over the next few weeks, I'll post up what I've got.
(But I'd appreciate some expressions of interest to show just how many people want this)

Number · Post by **Number** » Fri Mar 04, 2005 6:46 am

Trystan wrote:NeoStats has a v3.0 which is alpha it has a windows build.
Believe also that SolarStats has a windows port

It's for Stats ??
Thanks you !! i have find the Noestats V3 for Win ..
And for Mysql output (Like all user/Room/Where he was, ...

I think GNU Thales is goob but i never find a win 32 port ..

W00t I'm realy interestinf in all php script or services for mysql..
To crÃ©ate a website for my server .. (Like epiknet.org , coolsmile.net, ...)

Number · Post by **Number** » Fri Mar 04, 2005 8:23 pm

Thanks .. I think i'm go to install this server on linux ...

But i have also some question :

1) How can i link two server betwen ?? (Two Unrealircd )
2) If i link 2 server i should install service whit this server ???

Like this :

Principal Server and Anope
|
|
Secondary server .. (I nedd to install Anope ??)

3) If y want to register an user since a web page (php) what can i use ?
(I use anope whit a mysql databse but anope discourage to registr nick directly in a db..)

it's all for today ...

And thanks a lot for the help
(A french guy who whas lose in irc )

Trystan · Post by **Trystan** » Sat Mar 05, 2005 1:45 am

It is not that we discourage it, it DOES NOT WORK, Anope does not read what is done in SQL. If you add data to SQL while services are running we will update the SQL from the IRC and the data you put in SQL will be gone.

The only way to remote register nicks is to use a bot, to connect and register it.

T.S. Lee
Anope Developer

Number · Post by **Number** » Sat Mar 05, 2005 10:19 am

Thanks .....
But Some Site like (http://www.epiknet.com , http://www.coolsmile.net, http://www.pingchat.com, ...)
Use a web page to register a nick ...

Who he do that ??

Number · Post by **Number** » Sat Mar 05, 2005 2:09 pm

Number wrote: 1) How can i link two server betwen ?? (Two Unrealircd )

It's Ok ...

Number wrote: 2) If i link 2 server i should install service whit this server ???

I think i don't need to install the services.
Because i have two unrealircd linked and if i'm connect to the 2 server and i write /nick Number i say : "the nick is registered"...

Number wrote: 3) If y want to register an user since a web page (php) what can i use ?

Someone can respond to this question ??
In php we have socket..
We have the ircg..
And mysql data base ...

What is the best ? (can i have a exemple?)

Matridom · Post by **Matridom** » Sat Mar 05, 2005 3:07 pm

Number wrote:
3) If y want to register an user since a web page (php) what can i use ?
Someone can respond to this question ??
In php we have socket..
We have the ircg..
And mysql data base ...

What is the best ? (can i have a exemple?)

Trystan wrote:The only way to remote register nicks is to use a bot, to connect and register it.

T.S. Lee
Anope Developer

The answer was already given...

Write a php script to logon to the server and register the nick with the services. I wrote a similar one to remove bans (glines/klines) through my homepage.

Ron2K · Post by **Ron2K** » Sat Mar 05, 2005 7:03 pm

Trystan wrote:NeoStats has a v3.0 which is alpha it has a windows build.

Does someone mind pointing me to the section on the NeoStats website where I can find it? Last time I went there (around a month ago), I tried to look for it but couldn't find it. Although I suspect that I was probably looking in the wrong place

EDIT: Someday, I will also learn how to spell properly

Trystan · Post by **Trystan** » Sat Mar 05, 2005 9:56 pm

The have the 3.0 alpha builds in

http://www.neostats.net/dev/

DeadNotBuried · Post by **DeadNotBuried** » Sat Mar 05, 2005 11:10 pm

they actually have the links working on the downloads section, the main prebuilt windows is currently just the NeoStats Core with the standard modules that come with the Core.

for the *nix versions the source code is there for the modules everyone knows about that have been converted to the 3 API. there are some new modules that will only be available on NeoStats 3 which haven't been announced yet that aren't up there yet.

the alpha was only put up on 23 feb

Ron2K · Post by **Ron2K** » Sun Mar 06, 2005 8:35 am

DeadNotBuried wrote:the alpha was only put up on 23 feb

That's why I didn't find it earlier then

Number · Post by **Number** » Mon Mar 07, 2005 7:02 am

Thanks for the response...

For the script in php someone have a example?
(I purpose that run whit socket ... i'm right ?? )

Number · Post by **Number** » Tue Mar 08, 2005 3:58 pm

I see (On download page)
A services (Thales) Who add on mysql some info (Like channel, user on this channel, ect ..)

But i thing it's only for Linux ??
They don't have any services Like thales for Win ???

Thanks a lot ..
And sory for all my question ..
I 'hope you understand me ...

A french who come in a english world isn't easy ...