Support Resolved Price number

[ducnd]

1.How can change a price range value for more number

I input price by thí number 1156012345 program prompt "Mysqli statement execute error : Out of range value for column 'xfa_fss_price' at row 1 "

2. Price number display
in curent version ( 1.3) if I input price:315000 thread and mesage will display 315000.00

How can I change to input price 3150000 thread and mesage will display 3.150.000 or 3,150,000 ( this easy to see)

Thank you

 

[Clement]

1. You would need to change the fields from the different tables, they are currently DECIMAL(10,2). You would have to change the following columns :

• Table xfa_fss_transaction: price and donation fields
• Table xf_node : xfa_fss_percentage field
• Table xf_thread xfa_fss_percentage and xfa_fss_price fields

I could extend that in a later release. You really need such high prices ? Or perhaps your currency has big numbers contrary to € or $.

2. The 2 decimals are automatic due to the decimal type used in mysql. It would need some change to the php code.

Clément

 

[ducnd]

Thank you .. I just change to DECIMA (15,2).. it's work

In next version I hope you add some field for sellers must fill when they post new thread
- Location
- Address
- Phone contact

Other funtion surgest: filter by location, filter by price, filter by time of post, search box in forum sales, rating..

The decima automatic I got from other for your reff

    public static function currencyFormat($number = 0)
    {
        $currency = array(
            'symbol_left' =>    '',
            'symbol_right' =>    ' USD',
            'value' =>    1,
            'decimal_place' =>    0,
        );
        $negative = false;
        $formated = '';
        if (is_numeric($number)) {
            if ($number < 0)
            {
                $negative = true;
                $number *= -1;
            }
            $number *= $currency['value'];
            $number = XenForo_Locale::numberFormat($number,$currency['decimal_place']);
        }else{
            $number = XenForo_Locale::numberFormat(0,$currency['decimal_place']);
        }
        $formated = $negative?' - ':'';
       
        if (($currency['symbol_left'])) {
              $formated .= $currency['symbol_left'];
        }
        $formated .= $number;
        if (($currency['symbol_right'])) {
              $formated .= $currency['symbol_right'];
        }
        return $formated;
    }
   
}

 

[Clement]

They have to fill it on paypal side already.
I am not going to add filters to the thread list.

Clément

 

[Clement]

They have to fill it on paypal side already.
I am not going to add filters to the thread list.

Clément

 

[ducnd]

1. You would need to change the fields from the different tables, they are currently DECIMAL(10,2). You would have to change the following columns :

• Table xfa_fss_transaction: price and donation fields
• Table xf_node : xfa_fss_percentage field
• Table xf_thread xfa_fss_percentage and xfa_fss_price fields

I could extend that in a later release. You really need such high prices ? Or perhaps your currency has big numbers contrary to € or $.

2. The 2 decimals are automatic due to the decimal type used in mysql. It would need some change to the php code.

Clément

How I can do it with RM Marketplace, which table need to edit
Thank

 

[Clement]

All decimal(10,2) tables that you can find in the install code.