http – Which special characters are safe and unreserved to use in the complete URL?

After reading these answers and some Googling I couldn’t find a precise answer. RFC states that these characters are unreserved

"-" | "_" | "." | "!" | "~" | "*" | "'" | "(" | ")"

How can . be unreserved? Isn’t that the base of a domain? eg.

Further, it is mentioned in the same RFC that these characters are unwise as some services might use them as delimiters. I’ve never seen these being used in such s way. Have I just not been paying attention?

"{" | "}" | "|" | "" | "^" | "(" | ")" | "`"

My intention is to build a redirect service which would anonymize resources. say I want to generate these 10 char random strings without causing misinterpretations on the receiving side, which could really be anything. I close to understanding until I read the period is unreserved.

I hope someone can shed some light on these as I am thoroughly confused as what’s safe and what’s not

Special Offer-75 Backlinks 50 PR9 + 25 EDU/GOV 80+DA manually Do Safe SEO Increase Google ranking for $5

Special Offer-75 Backlinks 50 PR9 + 25 EDU/GOV 80+DA manually Do Safe SEO Increase Google ranking

Do you want to hit the jackpot in your SEO efforts? this online marketing offer is for you. I offer you the most advance and safe link building method thrive to your site top SERPS and traffic to your Website or Video.

What You Will get with this service-

I will create manual with white hat SEO techniques 50 Pr(9~7) DA (100~80) profile backlinks and 25 .edu & .gov backlinks.

✓Juice all links with 70 trusted High Authority Backlinks.

✓ TOP QUALITY Google Friendly Domains.

✓100% Safe from hummingbirds google penguin 3.0 &Panda 4.1 Algorithm Update


✓ permanent backlinks

✓Provide full report with login details.

>Granted Over delivery.

You Can Use This Service For Your Money,Blog Or video Channel.

Authority Backlinks are still one of the most crucial website ranking factors in 2018. therefore, it is vital that you have a diverse range of quality backlinks that lead to your site. Do not confuse what I offer with other low cost links from poor quality, Low DANo-FOLLOW sources that get removed quickly. Unlike others I offer quality links on site with typical domain authority (DA) between (80~98) Do-follow links. Quality rather than quantity is the most important factor with link building.

On The Worlds Biggest TOP QUALITY Page Rank Friendly Domains:

80+ DA (Pr9~7) Backlinks –






.edu & .gov Backlinks from-


I work with White Hat manual methods, 100% Google Panda 3.0, Penguin 4.1& Hummingbird Safe, based on the latest Google updates. With natural High PR Backlinks and SEO Technic, your site start ranking for sure which is loved by Google algorithm !

For Better Result Add My Extra Service


Q. How Safe Your Backlinks ?

Ans: Using our service is 100% safe for your websites! Yes, you heard it right!

Q. How index Quality Your Backlinks ?

Ans: All links are top class DA site.So links will be index quickly.Google need their specific Time if you use Premium indexer or Not.

Q. Do you accept non-English Sites?

Yes, we can accept non-English websites, but we will use English content with the non-English anchor.

Q. Do you use all unique domains?

Ans: Yes, we use all authority unique domains to create those backlinks.

Q. Do you create only dofollow links?

Ans: Most of the links will be dofollow (90%) and only few nofollow. Mix of dofollow and nofollow is always good for link profile.

Q. Will you replace if any links get deleted?

Ans: If any links get deleted within 30 days after report delivery, we will replace them anytime without charging you.

Q. My old site has less visitor and not reach search to top rank, ?

Ans: It helps to increase Your search visibility & obviously increase your rank.

Q. My video site has less visitor, Can I get subscriber or YouTube or other search engine rank

Ans: Yes! This backlinks Package Increase your Google,YouTub & Other search engine rank. So you can get more visitor.

If you are unsure about anything at all, please message me before ordering and I will do my very best to answer your questions.

T & C :

Positive feed back are always motivate. I do not expect Negative feedback or bad Comment .If you’re not 100% satisfied with my service, I don’t expect you to pay. Just inform me I will refund your money. That’s our promise and your guarantee.


localization – How do you handle localisation with special tags for long languages

I think the option you have taken is already the correct one.

Your design should always accommodate for larger text (in both font size and length) because you should also be considering accessibility of you design. For example, if this is a web application, then the user might have the browser set to display large fonts or have the zoom set to a higher value than the default 100%.

With regards to it “looking odd”, it’s hard to comment without seeing the rest of your design and where these tags would fit into that. However, I would recommend that you expect tags to sometimes span multiple lines and try to find a design that accommodates that situation just as well as it does for single-line tags.

Special Price Not Applying in Magento2 Cart

I am creating simple products through API call. Product is created finely and showing all attributes finely in admin part but when ever i am seeing product in frontend it is not showing any special price. It is directly displaying price.

I am using magento 2.2.4 version. Here is the API code.

   $name = $prod_data('name');
            $price = $prod_data('price');
            $category_id = 229;
            $qty = $prod_data('qty');
                    'use_config_manage_stock' => 0,
                    'manage_stock' => 1,
                    'is_in_stock' => 1,
                    'qty' => $qty

            if ($product->save()) {
            /** add saved file to the $product gallery */
            $categoryLinkRepository = $objectManager->get('MagentoCatalogApiCategoryLinkManagementInterface');
            $categoryIds = array('229');
            $categoryLinkRepository->assignProductToCategories($sku, $categoryIds);
            $succ = 1;
            $msg = "Product created successfully";
            $logger->info("SKU Not Existed, So Creating new SKU for ". $prod_data('sku'));
                $succ = 0;
                $msg = "Unable to create product";
                 $logger->info("SKU Not Existed, But there is problem in creating sku ". $prod_data('sku'));


For updating special price i used the following code. In admin it is updating finely but final_price in index table is not changing.

if($prod_data('special_price') > 0){
                       $product2 = $objectManager->get('MagentoCatalogModelProduct')->load($pid);
                      $productResource = $objectManager->create('MagentoCatalogModelResourceModelProduct');
                      $productResource->saveAttribute($product2 , 'special_price');

I tried indexer:reindex but no use of it. Cleared cache, verified store id and everything is correct.

But still special price not showing in product detail page as well as cart page. How can i debug it.

Apply Special Price to SKUs with a Coupon Code?

We’re using Magento 2.34. We want to set up a shopping cart coupon where customers get a special price for a set of SKUs with different price levels if they enter the correct coupon code at checkout.


  • Customer receives an advertisement offering Widget 1 and Widget 2, with a coupon code listed for special pricing.
  • Widget 1 is normally $42.95. Coupon should lower the price to $14.95 per unit at checkout.
  • Widget 2 is normally $19.95. Coupon should lower the price to $4.95 per unit at checkout.

Three questions:

  • Is this possible without an extension?
  • If an extension is needed, which one is required/recommended?
  • Can this be accomplished with programming?

Thanks in advance for any help you can provide.

hands free – Voice activated / HF inputs: how can you escape special function phrases?

For example, say I have a sentence that I want to end with a period then have returned to a new line, but the contents of that sentence itself include period and new line as literals. Is it possible to use voice-only commands to write such a message?

concurrency – What is “special” about PostgreSQL update vs delete+insert

My understanding is that an update locks a tuple, marks it as deleted, and then adds a new tuple.

Essentially, a delete + insert.

But that’s not true. There seems something fundamentally different in the MVCC about update than delete + insert.


CREATE TABLE example (a int PRIMARY KEY, b int);
INSERT INTO example VALUES (1, 1);

Update (two concurrent sessions):

BEGIN; -- session A
UPDATE example SET b = 2 WHERE a = 1; -- session A
DELETE FROM example WHERE a = 1; -- session B (blocks)
COMMIT; -- session A
-- 0 rows in table example (1 row was deleted by session B)

Delete and insert (two concurrent sessions):

BEGIN ;-- session A
DELETE FROM example WHERE a = 1; -- session A
INSERT INTO example VALUES (1, 2); -- session A
DELETE FROM example WHERE a = 1; -- session B (blocks)
COMMIT; -- session A
-- 1 row in table example (nothing was deleted by B)


UPDATE example SET b = 2 WHERE a = 1;

is different than

DELETE FROM example WHERE a = 1; -- session A
INSERT INTO example VALUES (1, 2); -- session A

How am I to understand the MVCC nature of update? Does the tuple has some sort of MVCC “identity” that is preserved during the update? What is it?

Product Sum of Special Arrays


Can someone please explain why this is correct:

function productSum(array,depth=1) {
    let sum=0;      
    for(let i=0;i<array.length;i++){
            sum+= productSum(array(i),depth+1)
            sum+= array(i);
    return (depth)*sum;

But, following is wrong:

function productSum(array,depth=1) {
    let sum=0;      
    for(let i=0;i<array.length;i++){
            sum+=(depth)* productSum(array(i),depth+1)
            sum+= array(i);
    return sum;

I haven’t been able wrap my head around it. Why is does it give wrong answer if I multiply the sum with depth before the for loop on an array ends?

It is clear from the sample output that if there are multiple array items at a depth, we are supposed to multiply the sum with the depth as many times.
Eg. depth 2 is multiplied by the sum twice in the example.

Could someone please break it down for me?

magento2.3 – Checking if child products of a configurable product have a special price?

The following code has been added to the list.phtml but is working only for simple products. When they have an special price with a date range, a sale label is attached to the product image on the category pages. This is also displaying a new label on products that are set as NEW with a date range (the new label is working for all products).

$specialprice = $_product->getSpecialPrice();
$specialPriceFromDate = $_product->getSpecialFromDate();
$specialPriceToDate = $_product->getSpecialToDate();
$now = date("Y-m-d");
$newsFrom = substr($_product->getNewsFromDate(), 0, 10);
$newsTo = substr($_product->getNewsToDate(), 0, 10);
$today = time();
$class_has_new = "";
if ($newsTo != '' || $newsFrom != '') {
    if (($newsTo != '' && $newsFrom != '' && $now >= $newsFrom && $now <= $newsTo) || ($newsTo == '' && $now >= $newsFrom) || ($newsFrom == '' && $now <= $newsTo)) {
        $class_has_new = " has-new";
if ($specialprice) {
    if ($today >= strtotime($specialPriceFromDate) && $today <= strtotime($specialPriceToDate) || $today >= strtotime($specialPriceFromDate) && is_null($specialPriceToDate)) { ?>
        <div class="label-product label-sale<?php echo $class_has_new; ?>">
            <span class="sale-product-icon">
                <?php echo __('Sale'); ?>
<?php }
if ($newsTo != '' || $newsFrom != '') {
    if (($newsTo != '' && $newsFrom != '' && $now >= $newsFrom && $now <= $newsTo) || ($newsTo == '' && $now >= $newsFrom) || ($newsFrom == '' && $now <= $newsTo)) { ?>
        <div class="label-product label-new">
            <span class="new-product-icon"><?php echo __('New'); ?></span>
    <?php }
} ?>

I am trying to find a way to combine a special price check that works for simple products and for configurable products in the case that all child products of a configurable product have an special price.

Banning special characters in search form input

Apologies if this is a duplicate posting, I’ve searched extensively and cannot find either this question or a solution, or even to know if this is really a problem.

I find a LOT of search queries performed on my site where the person or bot is searching for terms like “index/thinkapp/invokefunction” and other similar terms. There are obviously no results shown, but the quantity of these searches are overwhelming my search logs, which I use to help me improve my site’s content and SEO.

I would ideally like to just ban all special characters (such as / ? () et al) from the search form input field.

So my questions are:

  • is this a potentially security-related problem I should be concerned
  • can I ban such characters in the search form?
  • if so, how?

I am not a classically-trained coder but I am very good at following instructions!

Any advice would be appreciated, thanks!