Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Nexus-]

Hello all,
the mysql base of Anope is in Read Only. I would like to add user, modify settings of channels ...etc. with a Web page writen in PHP. But if I add any data to the mysql base, nothing will be in consideration because the mysql base is in Read Only.
I think to write a script who modify .db files directly.
Do you think this a good idea ?
Do you have an other idea ?

Thank you very much and sorry for my poor english but I am not english.

[deiks]

You must have option in your CP where you setting mysql. Permissions Read, Read/Write, Write

[Nexus-]

It's no problem of permission. The problem is that changes in the mysql database of anope are no effect.

[zEkE]

MySQL in Anope is a well documented feature.

As of 1.8.0-rc1:
MySQL can write TO the database at regular intervals. However, it updates everything at once, so if there are a large number of nickname or channel registrations it can take 2 or 3 minutes (or more) of services lag as it is all in the same thread.

MySQL can READ FROM the database AT START TIME.

Anope IRC Services CANNOT at this time perform the task you desire using the SQL feature, though it is planned for 1.9.

You may be interested in helping Rob with his XML-RPC module, which could probably be expanded to perform these functions while waiting for the 1.9 SQL Read/Write support.