[NeroX98]

Hi Guys...

I have Mysql based server with phpmyadmin... So when i've had +30 players mysql database messed up and don't load and save properly so i've closed my server... After a long time trying to fix it, i saw that the problem was mysql plugin which couldn't handle with 30+ players...

I've checked that by this code:

pawn Код:

forward ZacuvajBiznisi();
public ZacuvajBiznisi()
{
    print("AsdAsd");
    for(new BiznisID = 0; BiznisID <  sizeof(BizzInfo); BiznisID++)
    {
        mysql_format(1, querybiznis, sizeof(querybiznis), "UPDATE Biznisi SET bOwned = '%d', bOwner = '%s', bMessage = '%s', bDiscription = '%s', bEntranceCost = '%d', bTill = '%d', bLocked = '%d' WHERE BiznisID = '%d'",
        BizzInfo[BiznisID][bOwned],
        BizzInfo[BiznisID][bOwner],
        BizzInfo[BiznisID][bMessage],
        BizzInfo[BiznisID][bDiscription],
        BizzInfo[BiznisID][bEntranceCost],
        BizzInfo[BiznisID][bTill],
        BizzInfo[BiznisID][bLocked],
        BiznisID);

        mysql_function_query(1, querybiznis, false, "", "");
        print("AsdAsd1");
    }
    return 1;
}

My Bizzinfo size is 50 and in my server.log ZacuvajBiznisi is called 22 times...

Код:

[21:39:47] AsdAsd
[21:39:47] AsdAsd1
[21:39:47] AsdAsd1
[21:39:47] AsdAsd1
[21:39:47] AsdAsd1
[21:39:47] AsdAsd1
[21:39:47] AsdAsd1
[21:39:47] AsdAsd1
[21:39:47] AsdAsd1
[21:39:47] AsdAsd1
[21:39:47] AsdAsd1
[21:39:47] AsdAsd1
[21:39:47] AsdAsd1
[21:39:47] AsdAsd1
[21:39:47] AsdAsd1
[21:39:47] AsdAsd1
[21:39:47] AsdAsd1
[21:39:47] AsdAsd1
[21:39:47] AsdAsd1
[21:39:47] AsdAsd1
[21:39:47] AsdAsd1
[21:39:47] AsdAsd1

AND SERVER CRASHES... SO IF THERE WERE 22+ Players server would CRASH !!!

What's the problem with the fcking mysql ?

I use BlueG Mysql plugin R7