Beskriuwing
Dizze plugin is sluten fan 7 maart, 2024 ôf en is net beskikber foar ynlaad. Dizze sluting is tydlik, yn ôfwachting fan in folsleine resinsje.
Resinsjes
27 april, 2017
1 reakce
In database query inside a plugin file is not as per the standard WordPress queries.
In file "\eg-attachments\inc\eg-attachments-public.inc.php" there is a function "record_click". In this function author is using below query:
$sql = $wpdb->prepare('SELECT click_id,clicks_number FROM wp_eg_attachments_clicks WHERE click_date=CURRENT_DATE() AND attach_id=%d AND post_id=%d',
$attach_id, $parent_id);
Just look at the query, author is using “wp_eg_attachments_clicks” for a table. Here table prefix for that table is “wp_” which is not dynamic. Author should use something like below:
$sql = $wpdb->prepare('SELECT click_id,clicks_number FROM '.$wpdb->prefix.'eg_attachments_clicks WHERE click_date=CURRENT_DATE() AND attach_id=%d AND post_id=%d',
$attach_id, $parent_id);
In place of "wp_" we should always use "$wpdb->prefix" in our queries so that our query will not break even change of table prefix by the user from wp-config.php file.
Request to author, please update it in your next release.
Thanks,
Sunil Chaudhary
Meiwurkers & amp; Untwikkelders
"EG-Attachments" is iepen boarne software. De folgjende minsken hawwe bydroegen oan dizze plugin.
MeiwurkersOersette "EG-Attachments" yn jo taal.
Ynteressearre yn ûntwikkeling?
Blêdzje troch de koade , besjoch de SVN-repository , of abonnearje op it ûntwikkelingslogboek troch RSS .