Rule #1 - Be Patient - Rule #2 - Don't ask when, if you don't contribute - Rule #3 - You have coding skills - LinuxMCE's small brother is available: http://www.agocontrol.com
Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
I'll check these lines for proper syntax. As I've indicated, I haven't done an install test on the package yet.
J.
mysql -e "GRANT SELECT, INSERT, UPDATE, DELETE ON transmission_links.* TO 'test'@'localhost' IDENTIFIED BY '';"
mysql -e "GRANT SELECT, INSERT, UPDATE, DELETE ON transmission_links.* TO 'test'@'127.0.0.1' IDENTIFIED BY '';"
mysql -e "GRANT SELECT, INSERT, UPDATE, DELETE ON transmission_links.* TO 'test'@'192.168.80.*' IDENTIFIED BY '';"Thank you so much for doing the initial leg work!
mysql -e "GRANT SELECT, INSERT, UPDATE, DELETE ON transmission_links.* TO 'transmission'@'localhost' IDENTIFIED BY '';"mysql -e "GRANT SELECT, INSERT, UPDATE, DELETE ON transmission_links.* TO 'transmission'@'localhost' IDENTIFIED BY '';"
mysql -e "GRANT SELECT, INSERT, UPDATE, DELETE ON transmission_links.* TO 'transmission'@'127.0.0.1' IDENTIFIED BY '';"
mysql -e "GRANT SELECT, INSERT, UPDATE, DELETE ON transmission_links.* TO 'transmission'@'192.168.80.*' IDENTIFIED BY '';"
case 'transmission-daemon':
$output = new Template($dbADO);
$output->setTemplateFileType('large');
include_once('operations/others/transmissionDaemon.php');
transmissionDaemon($output,$dbADO,$transmissionADO);
break;
a2enmod proxy
a2enmod proxy_httptransmissionSettings="/etc/transmission-daemon/settings.json"
changeSetting()
{
#create a back-up of the current settings file
backup="_"`date '+%Y%m%d%k%M%S'`".bak"
oldSetting=$(grep "\"$1\":" $transmissionSettings|awk -F\: '{print $2}'|sed -e 's|\,||g' -e 's|^ *||g' -e 's| *$||g')
if [ `echo ${oldSetting:0:1}`=='"' ]
then
sed -i$backup 's|"'$1'": '$oldSetting',|"'$1'": "'$2'",|' $transmissionSettings
else
sed -i$backup 's|"'$1'": '$oldSetting',|"'$1'": '$2',|' $transmissionSettings
fi
echo $transmissionSettings$backup
}changeSetting "script-torrent-done-filename" "/usr/pluto/bin/transmission-settings.sh torrentComplete \$TR_TORRENT_NAME"
Would you mind sharing your scripts? I'd really appreciate it. Feel free to add them to the ticket.No problem, I added the following lines to the transmission-daemon settings.json, however, I use version 1.93, which does not support on complete scripts (I found this out later!) but reading the LinuxMCE Wiki, I believe it should work!!
"script-torrent-done-enabled": true,
"script-torrent-done-filename": "/usr/pluto/bin/MessageSend dcerouter -r 0 20 1 809 9 \"Transmission Torrent Download completed\n$TR_TORRENT_NAME\" 70 \"alert\" 182 \"30\" 251 \"??\"",
What is your level of transmission integration into lmce?1.93 (The torrent site I use is quite strict on this, I had to roll it back from the updated one, apparently, they reckon higher versions give false stats?! Not entirely sure myself, but it's a good site, and I don't want to be kicked off!!)
If you can fix up an install script that includes the edit to the config file then we can put a package together.OK, I'll get to work on it now, I had posted a few comments on the ticket, but I guess here's better for chatting, the ticket is for updates and facts I guess!!
DBName='transmission_links'
#Set up the database
mysql -e "CREATE DATABASE $DBName;"
mysql -e "CREATE TABLE Torrent_Links (Link_ID int NOT NULL AUTO_INCREMENT, Torrent_Location TEXT NOT NULL, Rar_File VARCHAR(250) NULL, Link_Location TEXT NOT NULL, Link_Name VARCHAR(100), Link_Type VARCHAR(10) NOT NULL, Link_Status VARCHAR(10) NULL, PRIMARY KEY (Link_ID));" $DBName
#Adding the user
mysql -e "CREATE USER 'transmission'@'localhost';"
mysql -e "CREATE USER 'transmission'@'127.0.0.1';"
mysql -e "GRANT SELECT, INSERT, UPDATE, DELETE ON transmission_links.* TO 'transmission'@'localhost';"
mysql -e "GRANT SELECT, INSERT, UPDATE, DELETE ON transmission_links.* TO 'transmission'@'127.0.0.1';"
mysql -e "FLUSH PRIVILEGES;"
#Add the new Menu Option
ParentID=`mysql -e "SELECT PK_PageSetup FROM PageSetup WHERE Description='Configuration';" pluto_main |tail -1`
if [ $ParentID -eq 0 ]
then
ParentID=174
fi
OrderNum=`mysql -e "SELECT MAX(OrderNum) + 10 FROM PageSetup WHERE FK_PageSetup_Parent=$ParentID;" pluto_main |tail -1`
#For Safety in case is doesn't correctly identify the outputs
if [ $OrderNum -eq 0 ]
then
OrderNum=999
fi
mysql -e "INSERT INTO PageSetup (FK_PageSetup_Parent, Website, OrderNum, Description, pageURL, showInTopMenu) VALUES ("$ParentID",1,"$OrderNum",'Transmission Daemon','index.php?section=transmission-daemon',1);"
At revision 27777? lmce-admin/operations/others/transmissionEditLinks.php
? lmce-admin/operations/others/transmissionValidatelinks.php
? lmce-admin/operations/others/transmissionLink.php
? lmce-admin/operations/others/transmissionDaemon.php
? lmce-admin/operations/others/transmissionCreatelinks.php
? lmce-admin/operations/others/transmissionCheckfilename.php
M lmce-admin/include/config/database.inc.php
M lmce-admin/include/config/globalconfig.inc.php
M lmce-admin/index.php
? lmce-admin/languages/en/transmissiondaemon.lang.phpIndex: lmce-admin/include/config/database.inc.php
===================================================================
--- lmce-admin/include/config/database.inc.php (revision 27777)
+++ lmce-admin/include/config/database.inc.php (working copy)
@@ -26,6 +26,10 @@
$securityADO = &ADONewConnection($dbPlutoSecurityType);
$securityADO->NConnect($dbPlutoSecurityServer,urlencode($dbPlutoSecurityUser),urlencode($dbPlutoSecurityPass),urlencode($dbPlutoSecurityDatabase));
+ // TransmissionADO connection
+ $transmissionADO = &ADONewConnection($dbTransmissionType);
+ $transmissionADO->NConnect($dbTransmissionServer,urlencode($dbTransmissionUser),urlencode($dbTransmissionPass),urlencode($dbTransmissionDatabase));
+
//for sqlite
//$db = &ADONewConnection('sqlite');
//$db->NConnect($GLOBALS['appRoot'].'sqlite.db'); # sqlite will create if does not exist
Index: lmce-admin/include/config/globalconfig.inc.php
===================================================================
--- lmce-admin/include/config/globalconfig.inc.php (revision 27777)
+++ lmce-admin/include/config/globalconfig.inc.php (working copy)
@@ -32,6 +32,13 @@
$dbPlutoSecurityServer = $DB_HOST;
$dbPlutoSecurityDatabase = "pluto_security";
+ // Transmission
+ $dbTransmissionType = "mysql";
+ $dbTransmissionUser = "transmission";
+ $dbTransmissionPass = "";
+ $dbTransmissionServer = $DB_HOST;
+ $dbTransmissionDatabase = "transmission_links";
+
function LoadConfig($configFile,$configKey) {
//LoadConfig()
//Looks for the assigned value of $configKey within $configFile,
Index: lmce-admin/index.php
===================================================================
--- lmce-admin/index.php (revision 27777)
+++ lmce-admin/index.php (working copy)
@@ -1801,6 +1801,20 @@
include_once('operations/deviceTemplate/commMethod.php');
commMethod($output,$dbADO);
break;
+ case 'transmission-daemon':
+ $output = new Template($dbADO);
+ $output->setTemplateFileType('large');
+ include_once('operations/others/transmissionDaemon.php');
+ transmissionDaemon($output,$dbADO,$transmissionADO);
+ //transmissionDaemon($output,$dbADO,"");
+ break;
+ case 'transmissionLink':
+ $output = new Template($dbADO);
+ $output->setTemplateFileType('small');
+ include_once('operations/others/transmissionLink.php');
+ transmissionLink($output,$dbADO,$transmissionADO);
+ //transmissionLink($output,$dbADO,"");
+ break;
case 'upnpServer':
$output = new Template($dbADO);
$output->setTemplateFileType('large');