I’m a big fan of Stack Overflow and I tend to contribute regularly (am currently in the top 0.X%). In this category (stackoverflow) of posts I will will be posting my top rated questions and answers. This, btw, is allowed as explained in the meta thread here.

My quesiton was:

I have two connected sortable lists. My code works fine for when I drag one element from the list on the left side to the one on the right side, but can you tell me what event should I be looking for if I want to know the order of items in the left list when an item gets dragged and dropped in the same list (basically reorder the items in the same list, not dragging and dropping to the other list but to the same).

Here is the link to the code: http://jsfiddle.net/Hitman666/WEa3g/1/

So, as you will see I have an alert when items are dragged and dropped in oposite lists, but I need an event also for when the list (for example the green one) gets reordered. Then I would need to alert the order, for example: 4,3,2,1

HTML:

<ul id="sortable1" class="connectedSortable">
    <li>Item 1</li>
    <li>Item 2</li>
    <li>Item 3</li>
    <li>Item 4</li>
</ul>

<ul id="sortable2" class="connectedSortable">
    <li>Item 5</li>    
    <li>Item 6</li>
    <li>Item 7</li>
    <li>Item 8</li>    
</ul>

CSS:

#sortable1, #sortable2 { list-style-type: none; margin: 0; padding: 0; float: left; margin-right: 10px; }#sortable1 li, #sortable2 li { margin: 0 5px 5px 5px; padding: 5px; font-size: 1.2em; width: 120px; }#sortable1 li{background: green;}#sortable2 li{background: yellow;}

JavaScript:

$(function() {
    $("#sortable1, #sortable2").sortable({
        connectWith: ".connectedSortable",
        receive: myFunc
    }).disableSelection();

    function myFunc(event, ui) {
        alert(ui.item.html());
    }
});

The answer, by user yoelp was:

You need to use the update event. Here is my example (notice that I made 2 extra function calls to sort since you needed the evt only on the left list):

$(function(){
    $( "#sortable1" ).sortable({
        connectWith: ".connectedSortable",
        update: myFunc
    }).disableSelection();

    $( "#sortable2" ).sortable({
        connectWith: ".connectedSortable",  // deactivate:myFunc
    }).disableSelection();

    function myFunc(event, ui){
        var b = $("#sortable1 li"); // array of sorted elems
        for (var i = 0, a = ""; i < b.length; i++)
        {
            var j=i+1; // an increasing num.
            a = a + j + ") " + $(b[i]).html() + '\n ' //putting together the items in order
        }
        alert(a)                 
    }
});

I’m a big fan of Stack Overflow and I tend to contribute regularly (am currently in the top 0.X%). In this category (stackoverflow) of posts I will will be posting my top rated questions and answers. This, btw, is allowed as explained in the meta thread here.

My quesiton was:

I recently ran into memory allocation problems, so I started experimenting with the ini_set('memory_limit', value); directive where I tried to enter values incrementaly. Now, searching through the web (and SO) I found out that I can put -1 as the value. So, I did and now the script runs fully to the end without breaking (before I used to get the memory allocation error).

What I don’t understand, however, is that given these two lines at the end of the script’s file:

$mem = memory_get_peak_usage(true);         
echo "Peak mem. usage: <b>". round($mem /1024/10124,2)."</b> MB";

produce around 10.8MB and when I look into the /var/log/messages I can see this line:

Nov2113:52:26 mail suhosin[1153]: ALERT-SIMULATION - script tried to increase  
memory_limit to 4294967295 bytes which is above the allowed value (attacker  
'xx.xxx.xxx.xxx', file '/var/www/html/file.php', line 5)

which means the script tried to alocate 4096MB!

How can this be? And also, what interest me the most is why didn’t the script execution stop in this case? Is it because of the ini_set('memory_limit', '-1');? I mean, I did read that putting -1 as the valueis not recomended and I know where the problem lies in the script (reading too big amount of data at once in the memory), and I will go and fix it with sequential reading, but I’m just baffled about these data differences, so I would be gratefull if someone can shed some light on it.

The answer, by user Sverri M. Olsen was:

It is because the suhosin patch uses its own “hard” maximum memory limit, suhosin.memory_limit.

From the configuration reference:

Suhosin […] disallows setting the memory_limit to a value greater than the one the script started with, when this option is left at 0.

In other words, if you change the memory_limit so that it is bigger than suhosin’s upper limit then it will simply assume that you are an “attacker” trying to do something suspicious

A simple example of how to make a custom YES/NO dialog with DialogResult in WPF. Freely (as in beer) available code is on Github: https://github.com/Hitman666/CustomYesNoDialogWPF. The breakdown is that you make a new window (MsgBoxYesNo) and assign DialogResult on the button clicks. You call this window as a dialog from a MainWindow and expect a bool in return upon which you act as you wish… MsgBoxYesNo.xaml:

<Window x:Class="CustomYesNoDialogWPF.MsgBoxYesNo"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        Title="MsgBoxYesNo" Height="300" Width="300"
        WindowStyle="None" ResizeMode="NoResize"
        WindowStartupLocation="CenterScreen"
        AllowsTransparency="True" Background="Transparent">

    <Border BorderThickness="5" BorderBrush="Black" CornerRadius="20" Background="SkyBlue">
        <Grid>
            <Grid.RowDefinitions>
                <RowDefinition Height="3*"></RowDefinition>
                <RowDefinition Height="1*"></RowDefinition>
            </Grid.RowDefinitions>

            <Grid.ColumnDefinitions>
                <ColumnDefinition></ColumnDefinition>
            </Grid.ColumnDefinitions>

            <Viewbox>
                <TextBlock x:Name="txtMessage" Width="420" FontSize="50" TextWrapping="Wrap" HorizontalAlignment="Center" VerticalAlignment="Center" TextAlignment="Center" Text="Are you sure you're awesome?"/>
            </Viewbox>

            <Viewbox Grid.Row="1">
                <StackPanel Orientation="Horizontal">
                    <Button Content="Yes" x:Name="Yes" Margin="1" HorizontalAlignment="Left" VerticalAlignment="Top" Width="55" Click="Yes_Click"/>
                    <Button Content="No" x:Name="No" Margin="1" HorizontalAlignment="Left" VerticalAlignment="Top" Width="55" Click="No_Click" IsCancel="True"/>
                </StackPanel>
            </Viewbox>
        </Grid>
    </Border>
</Window>

MsgBoxYesNo.cs:

public partial class MsgBoxYesNo : Window
{
    public MsgBoxYesNo(string message)
    {
        InitializeComponent();

        txtMessage.Text = message;
    }

    private void Yes_Click(object sender, RoutedEventArgs e)
    {
        DialogResult = true;
        this.Close();
    }

    private void No_Click(object sender, RoutedEventArgs e)
    {
        DialogResult = false;
        this.Close();
    }
}

MainWindow.cs:

private void Button_Click(object sender, RoutedEventArgs e)
{
    MsgBoxYesNo msgbox = new MsgBoxYesNo("Are you sure you're awesome?");
    if ((bool)msgbox.ShowDialog())
    {
        MessageBox.Show("Yes, you're awesome!");
    }
    else
    {
        MessageBox.Show("You're kidding, of course you're awesome!");
    }
}

My favourite quotes from the book Law of success by Napoleon Hill:

Make yourself a habit of doing more than you are paid for.

We need not seek opportunity in the distance, that we may find it right where we stand.

There is nothing impossible with time. You can do it if you believe you can.

Sometimes you bye because of the seller’s personality, not just his merchandise.

Every failure is a blessing in disguise’s, providing it teaches some needed lesson one could not have learned it would doubt it.

Render more service that for which you are paid for and you will soon be paid for more than you render.

You kind of become a power in your community nor achieve in during success in any word the undertaking until you become big enough to blame yourself for your own mistakes.

The man who can intelligently use knowledge possessed by another is as much or more a man of education as the person who merely has the knowledge but doesn’t know what to do with it.

If you can to do great things yourself, remembered that you can do small things in the great way.

I winner never quits and the quitter never wins.

Ignorance and fear are twins sisters. They’re generally found together.

The man who is powerful fears nothing, not even God. He loves God but fears him not.

You can do it if you believe you can.

Success is the development of power with which to get what everyone wants in life without interfering with the rights of others.

Keep together and no one will defeat you.

Anyone can start but only few will finish.

When the merchants said no, the young man did not hear it, but kept right on coming. On the last day of month, after having told this persistent young man no for 30 times, the merchant said “Look young man, you wasted the whole month trying to sell me. Now, what I would like to know is why have you wasted your time?” Wasted my time nothing – I have been coming to school and you have been my teacher. Now I know all the arguments that the merchant can you bring up for not buying, and besides that I have been drilling myself in self-confidence. You have been my teacher also – teaching me the value of persistence. I will buy what you sell.

I have to work hard when I was young but I shall see to it that my children have an easy time. Poor foolish creatures. An easy time usually turns out to be greater handicap than the average man or woman can survive.

I believe in myself. I believe in others that work with me. I believe in my employer. I believe in my friends. I believe in my family. I believe that God will lend me everything I need with which to succeed if I do my best to earn it through fateful and honest service.I believe in prayer and I will never close my eyes and sleep without praying for divine guidance to do and that I will be patient with other people and tolerant with those that do not believe as I do. I believe that success is the result of indulgent effort in that it does not depend on lock or sharp practices or doublecrossing friends, fellow men or my employer. I believe that I will get from life exactly that I put into it. Therefore I will be conducting myself toward others as I would want them to act toward me. I will not slender does that I do not like. I will not slide my work no matter what I see others doing. I will render the best service which I am capable of doing, because I have pleasured myself to succeed in life and I know success is the result of conscience and efficient effort. Finally, I will forgive those who offend me, because I realize that I should sometimes offend others and I will need their forgiveness.

If you think you’re beaten, you are. If you think you dare not, you don’t. If you like to win, but do you think you can it is almost certain you won’t. If you think you’ll lose, you’ve lost. Success begins with the fellows mind. It’s all in the state of the mind. If you think you’re outclassed, you are. You’ve got to think high to rise. You’ve got to be sure of yourself before you can ever win the prize. Life’s battles don’t always go to the stronger or faster man, but soon or late the man who wins is the man who thinks he can.

For no one who lacks faith in him self is really educated in the proper sense of the term.

Here is the dungeon of the mind in which runs and hides and seeks seclusion. It brings superstition and it is a dagger way to beach soul is assassinated.

They by day in every way I’m getting more successful.

Believe in yourself. But, don’t tell the world what you can do – show it!

The only lasting favor  a parent can confer upon a Child is that of helping the child to help itself.

We are victims of a habit. The habit of saving money requires more force of character than most people have developed for the reason that saving mean self denial and sacrifice and amusements and pleasures of scores of different ways. That’s who learns the habit of saving also requires additional needs habits which help toward success: self-control, self-confidence, courage, balance, freedom.

Saving account – 20%
Living, clothes food and shelter – 50%
Education – 10%
Recreation – 10%
Life insurance – 10%

Get rid of the procrastination! Do every day one thing that brings you closer to your definite chief aim. The one thing that no one told you you have to do and tell everyone how to get rid of the procrastination.

Man learns best that which he endeavors teach others.

The book will stimulate fault, which is the greatest service any book can render.

The man always takes never gives is not a leader – he’s a parasite.

No one has ever given you an opportunity? Has it ever occurred to you to create opportunity for yourself!?

You will never have a definite purpose in life, you will never have self-confidence, initiative and leadership unless you create these qualities in your imagination.

Most people will not grant favors just to please others. If I ask you to render service that would benefit me, without bringing you some corresponding advantage you will not show much enthusiasm and grant that favor, you may refuse altogether. But if I ask you to render service that will benefit the third person, even though the service must be rendered through me, and if that service is of such nature that it is likely to reflect the credit on you, the chances are that you will rendered this service willingly.

I cannot try to deceive myself, to do so would destroy the power of my pen and render my words as ineffective. It is only when I write with the fire enthusiasm burning in my heart that my writing impresses others favorably and it is only when I speak from the heart that is bursting with belief in my message that I can move my audience to except that message.

One of the greatest powers for good on this world is faith.

For truly I say to you, if you have faith the size of the mustard seed, you will say to this mountain ‘move from here to there’, and it will move; and nothing will be impossible to you.

I wonder where she is and what she’s doing when I’m away. When these questions begin to rise in your mind do not call in the detective, instead go to the psychiatric hospital and have yourself examined because more than likely are suffering from a mild form of insanity. Get your foot on jealousy first before it puts its clutches on your throat.

Today if a boy wants the wagon he cries for it, and he gets it?! Lack of self-control is being developed in the oncoming generations by their parents who have become victims of the spending habit.

By making it easy for you child you may be depriving the world of a genius. Bear in mind the fact that most of the progress that man has made came from bitter biting necessity.

Don’t say I can’t afford it, ask how can you afford it.

No matter how well you may be when you start for work in the morning if everyone you meet should say to you how you look and that you should see a doctor, it will not be long before you feel ill.

Write your definite chief aim in place it somewhere where you can see it daily many times.

Out of the night that covers me, black as the pit from pole to pole, I thank whatever gods may be for my unconquerable soul.
In the fell clutch of circumstance I have not winced nor cried aloud. Under the bludgeoning of chance my head is bloody, but unbowed.
Beyond this place of wrath and tears, looms but the horror of the shade, and yet the menace of the years, finds, and shall find, me unafraid.
It matters not how strait the gate, how charged with punishments the scroll, I am the master of my faith, I am the captain of my soul.

It is not the blows your deal, but the blows you take on the good old earth that show if you stuff is real.

Burn your bridges behind you and observe how well you work when you know you have no retreat.

Do not fear a person who says “I’m not paid to do this, I will not do it”. But watch out for the fellow who remains at his work until he is finished, and performs a little more that it is expected of him, for he may challenge you at the post and pass at the grandstand.

Until you learn to be tolerant with those who do not always agree with you, until you have cultivate the habit of saying some kind word of those whom you do not admire, until you have formed the habit of looking forward to good instead of the bad there is in others you will be neater successful nor happy.

Make a habit of doing each day the most distasteful task first.

Tomorrow I will do everything that should be done, when it should be done and as it should be done. I will perform the most difficult tasks first because this will destroy the habit of procrastination and develop the habits of action in its place.

Do not tell them what you can do show them.

Definite chief aim
Self-confidence
Habit of saving
Imagination
Initiative and leadership
Enthusiasm
Self-control
Doing more than paid for
Pleasing personality
Accurate thought
Concentration
Corporation
Failure
Tolerance
Golden rule

Power comes from organized effort.

Prayer without faith is nothing but an empty collection of words.

Yesterday is but a dream. Tomorrow is by division, but today well lived makes every yesterday a dream of happiness and every tomorrow a vision of hope. Look well to this day then.

…and this too will pass…

Kindness is more powerful than compulsion.

There is no better way of influencing the parent than that of capturing the child.

Book value lies not in the printed pages, but then the possible action they might arouse the reader.

No man can attain success in its highest form without the earnest prayer.

There can never be success without happiness and no man can be happy without dispensing happiness to others.

No active kindness is without its rewards even though it may never be directly paid. I will do my best to assist others where and when department to arises.

They do me wrong who say I come no more when once I knock and failed to find you in. For every day I stand outside your door and bid you wake, and rise to fight and win. Weep not for chances past away! Each night I burn the records of the day at sunrise every soul is born again! Then threw in from the bloated archives of the best and find the futures pages white as snow.
Art thou a mourner? Rouse thee from thy spell. Art thou a sinner? Sins may be forgiven. Each morning gives thee wings to flee from hell, each night to start to guide thy  feet to heavens. Laugh like a boy it’s blenders that have sped, to vanish to join you should be blind and deaf and dumb. My judgments sealed the debt best with that, but never find a moment yet to come. Though  deep in mire, wring not your hand and weep and Linda my hand to all who say “I CAN”. No shame – face outcast ever sank so deep. But yet might rise and be again a man.

I’m a big fan of Stack Overflow and I tend to contribute regularly (am currently in the top 0.X%). In this category (stackoverflow) of posts I will will be posting my top rated questions and answers. This, btw, is allowed as explained in the meta thread here.

This question is one of very few that still hasn’t got an answer, so if you do, please help:

Is there a gallery of existing premade themes ready for download for jQuery Mobile just as they are for jQuery UI? I did look around jQuery Mobile Themeroller but couldn’t find it (I know you can drag&drop the colors from Adobe kuler swatches but I’m not keen on that too much).

My favourite quotes from the book The Game by Anders de la Motte:

If you don’t change, then what’s the point of anything happening to you?

Fear is a powerful weapon, my brother, very powerful. If you play this well, you can keep people under control, make them to focus on stupid things and divert their attention from the really important things like human rights and personal freedoms. This functions in both ways.

The greatest trick the devil ever pulled was convincing the world he didn’t exist.

If you’re aware of your illness, it doesn’t mean your healthy.

I’m a big fan of Stack Overflow and I tend to contribute regularly (am currently in the top 0.X%). In this category (stackoverflow) of posts I will will be posting my top rated questions and answers. This, btw, is allowed as explained in the meta thread here.

So, my question was as follows:

I know I can do something like this:

CREATETABLE new_table AS(SELECT field1, field2, field3
    FROM my_table
)

I’m wondering how do I add more columns to this create table SQL, that are not from my_table, but instead ones that I would write my self and which would be unique to this new_table only.

I know I could just make the table with the above SQL and then additionaly (after the command is completed) add the necessary columns, but am wondering if this all could be done in one command, maybe something like this (tried it like that, but didn’t work):

CREATETABLE new_table AS((SELECT field1, field2, field3
    FROM my_table),
    additional_field1 INTEGER NOTNULLDEFAULT1,
    additional_field2 VARCHAR(20)NOTNULLDEFAULT1)

The answer, by user Omesh, was this:

You can also explicitly specify the data type for a generated column:

See Create Table Select Manual

CREATETABLE new_table
(
 additional_field1 INTEGER NOTNULLDEFAULT1,
 additional_field2 VARCHAR(20)NOTNULLDEFAULT1)AS(SELECT id, val,1AS additional_field1,1AS additional_field2
 FROM my_table
);

Example: SQLFiddle

My favourite quotes from the book Rich dad, poor dad by Robert T. Kiyosaki:

The love of money is the root of all evil versus the lack of money is the root of all evil.

Sadly, money is not taught in school.

One said “I can’t afford it”, the other “how can I afford it?“. One is a statement, the other question which forces you to think! If you say I can’t afford it – your brain stops, if however you say/ask “how can I afford it” you force your brain to think.

Proper physical exercise increases your chances for health and proper mental exercises increase your chances of wealth.

Taxes punish those who produce!, versus the statement that the rich should give the poor and pay more taxes.

Study hard so you could find a good company to work for versus study hard to find a company you could buy.

The reason why I’m not rich is why I have you kids versus the reason why I must be rich is because I have you kids.

Learn to manage risk.

Money is power.

There is a difference between being poor and being broke – being broke is temporary, being poor is forever.

Study to be rich, understand how money works and learn to have it work for me.

Money comes and goes, but if you have the education on how the money works you’ll gain power over it and you can begin building wealth.

The poor and the middle class work for money, rich people have money work for them.

Hurt is good – it inspires you to make money.

Most people only talk and dream about getting rich, You tried to do something!

Some just let life push them around, others get angry and push back. But they push back against their boss or their job, or their husband and wife, they do not know that it’s life who’s pushing. If you do not fight back you will spend your life blaming your job, boss, little pay for your problems. You live your life hoping for that big break that will solve all your money problems. If you have no guts you’ll just give up every time life pushes you – you will live your life safe – you die a boring old man. So, fight and go for it motherfucker.

Rat race – get up, go to work, pay bills – get and increased salary, spend more.

Once a person stop searching for information and self moment ignorance sets in.

It’s not how much money you make it’s how much money you keep.

Buy assets, not liabilities. Asset is something that puts money in your pocket and liability something that takes it out.

Financial literacy, investing, understanding markets, the law.

People who avoid failure, also avoid success.

Schools often the reward people who study more and more about less and less. You should know little about a lot.

Workers work hard enough not to get fired, and owners they just enough so that workers won’t quit. That’s a wrong moto.

Life is much like going to the gym. The most painful part is deciding to go.

Give and you shall receive.

I have never really met anyone that likes losing money. And in all my years I have never met a rich person who has never lost money. But, I have met a lot of poor people who have never lost a dime. Investing that is.

Everyone wants to go to heaven but no one wants to die.

Do what you feel in your heart to be right. For you’ll be criticized anyway.

It is not what you know, it is how fast you can learn something new.

For winners – loosing inspires them. For losers – loosing defeats them.

What I find funny is that so many poor or middle class people insist on flipping restaurant help 15 to 20% even for bad service, but complain paying a broker 3 to 7%.

Too often today we focus on borrowing money to get the things we want instead of focusing on creating money.

Insanity – doing the same thing over and over again and expecting a different result. Stop and see what is it that you’re doing that is not working and do something new.

Find someone who has done what do you want to do. Take them to lunch.

Take classes, read and attend seminars.

Make offers, someone may accept.

Profits are made in that buying, nothing in selling – prices go up in the neighborhood and people start buying – wrong!

Don’t play it safe – play it smart.

Risk comes from not knowing what you’re doing.

I’m a big fan of Stack Overflow and I tend to contribute regularly (am currently in the top 0.X%). In this category (stackoverflow) of posts I will will be posting my top rated questions and answers. This, btw, is allowed as explained in the meta thread here.

So, my question was as follows:

I’ve been using jQuery datatables plugin for about two years now and it worked great so far. The problem occured now when I need to load about 45000 records at once (you click the button and wait for the page with the data to load) – the loading time is just too big to wait.

Here are the tests I made using Chrome web browser (the data is from it’s Network tab using ):

datatables plugin turned on:
5476 records:
24 requests ❘ 256.26KB transferred ❘ 19.80s
(onload: 19.80s, DOMContentLoaded: 18.58s)
45071 records:
34 requests ❘ 1.85MB transferred ❘ 11.1min
(onload: 11.1min, DOMContentLoaded: 11.0min)

datatables plugin turned off (the jQuery datatables initialization is comented out):
5476 records:
21 requests ❘ 255.84KB transferred ❘ 6.57s
(onload: 13.26s, DOMContentLoaded: 13.28s)

45071 records:
31 requests ❘ 1.84MB transferred ❘ 2.0min
(onload: 2.0min, DOMContentLoaded: 2.0min)

The increase in load time that datatables make is over 80% for the 45k rows, and almost 40% for the 5k rows.

So I was wondering if you guys know of any similar plugin that handles alot of rows (45000+) faster, or am I just missing the point by trying to load all 45000+ records in “one go”?

Any suggestions are appreciated!

The answer, by user Allan Jardine, was this:

From the DataTables FAQs ( http://datatables.net/faqs#speed ):

• Client-side processing – DOM sourced data: ~5’000 rows. Speed options: bSortClasses
• Client-side processing – Ajax sourced data: ~50’000 rows. Speed options: bDeferRender
• Server-side processing: millions of rows.

If you aren’t using deferred rendering at the moment, with your 45’000 rows, I would most certainly suggest that. Failing that, for DataTables options, you might need to look at server-side processing.

[vcfb id=10203881466450662]

Fala Philip Taylor na nominaciji. Ja nominiram Miljenko Bistrovic, Luka Mesarić i Denis Jelenčić.
Ko nezna za kaj se ide, nek pročita: http://www.vecernji.hr/hrvatska/i-u-hrvatskoj-pocelo-skupljanje-novca-za-oboljele-od-als-a-957366 (tu imate i broj žiro računa). Inače, slažem se i s Seth Godin koji ima ovo za reći po tom pitanju: http://sethgodin.typepad.com/seths_blog/2014/08/slacktivism.html; ali ako drugo niš, podigla se barem svijest o tome… There, my $.2, well actually 100, but who cares as long as it’s for a good cause, right? – I won’t miss it and it just might help someone…