Anope IRC Services

Please login or register.

Login with username, password and session length
Advanced search  

News:

Pages: [1]   Go Down

Author Topic: Modifying database contents  (Read 5080 times)

0 Members and 1 Guest are viewing this topic.

Craig Fairhurst

  • Anope User
  • Offline Offline
  • Posts: 28
Modifying database contents
« on: December 21, 2014, 09:27:47 PM »

Hi

Here's my db_sql_live config:
http://pastebin.anope.org/index.php?page=viewpaste&id=14c05881ca

Changes made in the database aren't being reflected on IRC, what am I missing?

Kind regards

Craig Fairhurst

  • Anope User
  • Offline Offline
  • Posts: 28
Re: Modifying database contents
« Reply #1 on: December 21, 2014, 09:36:24 PM »

http://forum.anope.org/index.php?topic=469.0;nowap doesn't fill me with confidence. But luckily my data isn't being overwritten so I assume development has been made here?

LEthaLity

  • Team
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 307
    • LEthaLity
Re: Modifying database contents
« Reply #2 on: December 21, 2014, 09:52:28 PM »

I should hope so, that's over 8 years old
Logged

Craig Fairhurst

  • Anope User
  • Offline Offline
  • Posts: 28
Re: Modifying database contents
« Reply #3 on: December 21, 2014, 10:00:59 PM »

OK
Maybe xmlrpc would be better here i don't know.

LEthaLity

  • Team
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 307
    • LEthaLity
Re: Modifying database contents
« Reply #4 on: December 21, 2014, 10:12:47 PM »

Yeah it would be, generally xmlrpc is preferable for putting things/commands into Anope, db_live is better for extracting.
Logged

Craig Fairhurst

  • Anope User
  • Offline Offline
  • Posts: 28
Re: Modifying database contents
« Reply #5 on: December 21, 2014, 10:16:32 PM »

OK, but I would still like to find out if it is possible to use SQL directly rather than me having to get used to xmlrpc.

Kind regards

Craig Fairhurst

  • Anope User
  • Offline Offline
  • Posts: 28
Re: Modifying database contents
« Reply #6 on: December 21, 2014, 10:37:53 PM »

actually, although modifying the SQL would be nice, the xmlrpc command function seems a little less time consuming,

For anybody who is having the same problem(s) as me, xmlrpc is the better option here as far as I can see.

* $anope->DoCommand("ChanServ", "Adam", "REGISTER #adam");

Is perhaps the bit that you need to see. This lets you create a channel with nickname Adam. Perfect for me. See the docs/XMLRPC/xmlrpc.php file to get you started.
Pages: [1]   Go Up