Mysql profiles and watched status

  Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
armss001 Offline
Junior Member
Posts: 4
Joined: May 2015
Reputation: 1
Post: #76
Okay problem solved, after digging about, I needed to add delimiter.

Code is as follows when ran from the phpmyadmin page.

Code:
delimiter //
CREATE TRIGGER insert_new_watched AFTER INSERT ON myvideos90.files
    FOR EACH ROW BEGIN
        INSERT INTO kodi_ben90.watched_history(idFile) VALUES (NEW.idFile);
        INSERT INTO kodi_dan90.watched_history(idFile) VALUES (NEW.idFile);
        INSERT INTO kodi_dem90.watched_history(idFile) VALUES (NEW.idFile);
        INSERT INTO kodi_nath90.watched_history(idFile) VALUES (NEW.idFile);
        INSERT INTO kodi_hannah90.watched_history(idFile) VALUES (NEW.idFile);
     END; //
delimiter ;
find quote
Walhalla Offline
Junior Member
Posts: 46
Joined: Apr 2009
Reputation: 1
Post: #77
Good to know. Thanks for posting the solution.
find quote
dr-oopie Offline
Junior Member
Posts: 23
Joined: Feb 2015
Reputation: 0
Post: #78
i have a mysql installed on linux but it has multiple databases. how can i point it to the kodi database so its not in the root? i think by default it goes to MyVideos but i want it inside of kodi

thought id edit it, instead of making a MyVideos and those automatically created, i rather then be created inside a Kodi database with the same structure within. so not just to rename MyVideos to Kodi but put MyVideos itself into Kodi database.
(This post was last modified: 2015-07-08 03:18 by dr-oopie.)
find quote
unaszplodrmann Offline
Junior Member
Posts: 2
Joined: Jul 2015
Reputation: 0
Post: #79
Just had a look at the new video db schema from Isengard... lots of structural changes. Has anyone updated the linked multi-user setup yet? I'll do it, if not.
find quote
Walhalla Offline
Junior Member
Posts: 46
Joined: Apr 2009
Reputation: 1
Post: #80
I had no time to have a look into it. If you have some spare time it would be really cool ;-)
find quote
unaszplodrmann Offline
Junior Member
Posts: 2
Joined: Jul 2015
Reputation: 0
Post: #81
Been years since I messed about with SQL queries, but I'm working on it. I think have the existing modifications ported over, but I'd like per-user video settings and resume points, so gonna fiddle some more tomorrow before testing it all.
find quote
Post Reply