Php photo gallery TWG | JFUploader | TWG Flash upload | WFU | Forum https://www.tinywebgallery.com/forum/ |
|
SQL query after file deletion https://www.tinywebgallery.com/forum/viewtopic.php?f=13&t=3032 |
Page 1 of 1 |
Author: | tcarr170 [ 16. Jun 2011, 01:18 ] |
Post subject: | SQL query after file deletion |
Hi Michael, I created a plugin that inserts information to my MySQL table after a user uploads a file. However, I would like that information to be deleted if the user decides to delete the uploaded file. Where is the best place to do this MySQL delete query? I'd like to include it in the tfu_delete_files function in the tfu_helper, because that seems the most logical place, but I think I would need to bring in the database connection info there also, and I didn't know if that was a safe place to do that? I know there is a javascript call back for deleting, but I need to run SQL not Javascript. I thought you might have a helpful idea Thank you very much, Tracy Joomla 1.6.3 JFU 2.14 Server: localhost / development site |
Author: | TinyWebGallery [ 16. Jun 2011, 07:46 ] |
Post subject: | Re: SQL query after file deletion |
write a plugin as well. You have to use the _after_process_file function then see: http://www.tinywebgallery.com/en/tfu/web_plugin.php# - Michael |
Author: | tcarr170 [ 16. Jun 2011, 15:59 ] |
Post subject: | Re: SQL query after file deletion |
Perfect! Thanks Michael! |
Author: | tcarr170 [ 16. Jun 2011, 16:27 ] |
Post subject: | Re: SQL query after file deletion |
Hi, ok I need help again! I wrote the plugin and a test query, but I can't seem to access the filename, and I thought that variable was available. Here is my test function below. What am I doing wrong so that I can get just the filename? function tc_delete_plugin_after_process_file($action, $fullpath, $folder, $filename ) { if ( $action == "delete" || $action == "xdelete" ) { $test = $filename; $query = "INSERT INTO ". $db_table4. " ( `testing` ) "; $query .= " VALUES ( '".$test."' )"; mysql_query($query,$db_connection) or tfu_debug("Cound not insert data: " . $query); } } Thanks! Tracy |
Author: | TinyWebGallery [ 16. Jun 2011, 17:27 ] |
Post subject: | Re: SQL query after file deletion |
what is the output of your debug? in $filename it the filename. - Michael |
Author: | tcarr170 [ 16. Jun 2011, 17:41 ] |
Post subject: | Re: SQL query after file deletion |
Hi, here is the debug output: 06.16.2011 15:39:30 - ERROR 2 in \com_jfuploader\tfu\tc_delete_plugin.php, line 21: Missing argument 4 for tc_delete_plugin_after_process_file() 06.16.2011 15:39:31 - ERROR 8 in \com_jfuploader\tfu\tc_delete_plugin.php, line 76: Undefined variable: filename Line 21 is: function tc_delete_plugin_after_process_file($action, $fullpath, $folder, $filename ) { Line 76 is: $test = $filename; |
Author: | TinyWebGallery [ 16. Jun 2011, 17:50 ] |
Post subject: | Re: SQL query after file deletion |
you should not use parameters that do not exists: _after_process_file($action, $fullpath, $folder) { is written in the documention . - Michael |
Author: | tcarr170 [ 16. Jun 2011, 17:53 ] |
Post subject: | Re: SQL query after file deletion |
Also, I'm able to get the full path and folder variables, and it deletes the file, so I know everything else is working. And In my other plugin (that runs after a file is uploaded), it gets the filename variable. But not in this plugin. Any of that help? |
Author: | tcarr170 [ 16. Jun 2011, 17:54 ] |
Post subject: | Re: SQL query after file deletion |
Ah, ok. I was confused because also in the documentation it says: Just check the existing plugins as examples. This function is called by tfu_upload.php after the upload or by tfu_file.php. The available parameters are: $folder - relative folder the file is uploaded too. $fullpath - the full path to the file - use this to copy the file somewhere. $filename - the name of the file. $action - the performed action - e.g. delete. See tfu_file.php for available actions. So, I will try to use the fullpath variable as the identifier in my MySQL query. Thanks! |
Author: | TinyWebGallery [ 16. Jun 2011, 18:00 ] |
Post subject: | Re: SQL query after file deletion |
But the methods have defined parameters you cannot extend by simply adding one. - Michael |
Author: | tcarr170 [ 16. Jun 2011, 18:26 ] |
Post subject: | Re: SQL query after file deletion |
Understood, got it working with $fullpath. Thanks! |
Page 1 of 1 | All times are UTC + 1 hour [ DST ] |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |