[MySQL] Laikraščio sistema.

    //Create by Jamaika.

    #include <a_samp>
    #include <sscanf2>
    #include <a_mysql>
    #include <zcmd>

    #if defined FILTERSCRIPT

    public OnFilterScriptInit()
    {
            print("\n--------------------------------------");
            print(" Laikraðèio sistema sëkmingai uþkrauta.");
            print("--------------------------------------\n");
            return 1;
    }

    public OnFilterScriptExit()
    {
            return 1;
    }

    #else

    main()
    {
            print("\n----------------------------------");
            print(" Blank Gamemode by your name here");
            print("----------------------------------\n");
    }

    #endif

    public OnGameModeInit()
    {
            // Don't use these lines if it's a filterscript
            SetGameModeText("Blank Script");
            AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
            return 1;
    }

    public OnGameModeExit()
    {
            return 1;
    }

    public OnPlayerRequestClass(playerid, classid)
    {
            SetPlayerPos(playerid, 1958.3783, 1343.1572, 15.3746);
            SetPlayerCameraPos(playerid, 1958.3783, 1343.1572, 15.3746);
            SetPlayerCameraLookAt(playerid, 1958.3783, 1343.1572, 15.3746);
            return 1;
    }

    public OnPlayerConnect(playerid)
    {
            return 1;
    }

    public OnPlayerDisconnect(playerid, reason)
    {
            return 1;
    }

    public OnPlayerSpawn(playerid)
    {
            return 1;
    }

    public OnPlayerDeath(playerid, killerid, reason)
    {
            return 1;
    }

    public OnVehicleSpawn(vehicleid)
    {
            return 1;
    }

    public OnVehicleDeath(vehicleid, killerid)
    {
            return 1;
    }

    public OnPlayerText(playerid, text[])
    {
            return 1;
    }

    public OnPlayerCommandText(playerid, cmdtext[])
    {
            return 0;
    }

    public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
    {
            return 1;
    }

    public OnPlayerExitVehicle(playerid, vehicleid)
    {
            return 1;
    }

    public OnPlayerStateChange(playerid, newstate, oldstate)
    {
            return 1;
    }

    public OnPlayerEnterCheckpoint(playerid)
    {
            return 1;
    }

    public OnPlayerLeaveCheckpoint(playerid)
    {
            return 1;
    }

    public OnPlayerEnterRaceCheckpoint(playerid)
    {
            return 1;
    }

    public OnPlayerLeaveRaceCheckpoint(playerid)
    {
            return 1;
    }

    public OnRconCommand(cmd[])
    {
            return 1;
    }

    public OnPlayerRequestSpawn(playerid)
    {
            return 1;
    }

    public OnObjectMoved(objectid)
    {
            return 1;
    }

    public OnPlayerObjectMoved(playerid, objectid)
    {
            return 1;
    }

    public OnPlayerPickUpPickup(playerid, pickupid)
    {
            return 1;
    }

    public OnVehicleMod(playerid, vehicleid, componentid)
    {
            return 1;
    }

    public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
    {
            return 1;
    }

    public OnVehicleRespray(playerid, vehicleid, color1, color2)
    {
            return 1;
    }

    public OnPlayerSelectedMenuRow(playerid, row)
    {
            return 1;
    }

    public OnPlayerExitedMenu(playerid)
    {
            return 1;
    }

    public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
    {
            return 1;
    }

    public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
    {
            return 1;
    }

    public OnRconLoginAttempt(ip[], password[], success)
    {
            return 1;
    }

    public OnPlayerUpdate(playerid)
    {
            return 1;
    }

    public OnPlayerStreamIn(playerid, forplayerid)
    {
            return 1;
    }

    public OnPlayerStreamOut(playerid, forplayerid)
    {
            return 1;
    }

    public OnVehicleStreamIn(vehicleid, forplayerid)
    {
            return 1;
    }

    public OnVehicleStreamOut(vehicleid, forplayerid)
    {
            return 1;
    }

    public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
    {
            if(dialogid == 1000)
            {
                if(response)
                {
                    switch(listitem)
                    {
                        case 0:
                        {
                            new msg[128], naujiena[128], nVardas[128];
                            mysql_query("SELECT naujiena, NaujienaParase FROM nustatymai");
                            mysql_store_result();

                            if(mysql_retrieve_row())
                            {
                                mysql_fetch_field_row(naujiena, "naujiena");
                                mysql_fetch_field_row(nVardas, "NaujienaParase");
                                format(msg, sizeof(msg),"Serverio Naujiena:\n%s. Paraðë %s",naujiena, nVardas);
                                ShowPlayerDialog(playerid, 80, DIALOG_STYLE_MSGBOX,"Serverio naujiena",msg,"Aiðku","");
                                            }
                                            else
                                            {
                                                ShowPlayerDialog(playerid, 80, DIALOG_STYLE_MSGBOX,"Serverio naujiena","Serverio naujienu nera","Aiðku","");
                                            }
                                            mysql_free_result();
                                    }
                                    case 1:
                                    {
                                        new msg[128], atnaujinimas[326];
                                        mysql_query("SELECT atnaujinimas FROM nustatymai");
                                        mysql_store_result();

                                        if(mysql_retrieve_row())
                                        {
                                            mysql_fetch_field_row(atnaujinimas, "atnaujinimas");
                                            format(msg, sizeof(msg),"Serverio atnaujinimas:\n%s.",atnaujinimas);
                                ShowPlayerDialog(playerid, 80, DIALOG_STYLE_MSGBOX,"Serverio atnaujinimas",msg,"Aiðku","");
                                            }
                                            else
                                            {
                                                ShowPlayerDialog(playerid, 80, DIALOG_STYLE_MSGBOX,"Serverio atnaujinimas","Serverio atnaujinimu nera","Aiðku","");
                                            }
                        mysql_free_result();
                                    }
                            }
                    }
                    return true;
            }
            return 1;
    }

    public OnPlayerClickPlayer(playerid, clickedplayerid, source)
    {
            return 1;
    }

    stock PlayerName(playerid)
    {
            new name[MAX_PLAYER_NAME];
            GetPlayerName(playerid, name, sizeof(name));
            return name;
    }

    CMD:laikrastis(playerid)
    {
            ShowPlayerDialog(playerid, 1000, DIALOG_STYLE_LIST,"Laikraðtis","Naujienos\nAtnaujinimai","Rinktis","atðaukti");
            return 1;
    }

    CMD:naujiena(playerid, params[])
    {
            new tekstas[128], query[128];
            if(sscanf(params, "s[128]", tekstas)) return SendClientMessage(playerid, -1, "Naudojimas - /naujiena [tekstas]");
            format(query, sizeof(query),"INSERT INTO nustatymai (naujiena, ParaseNaujiena) VALUES ('%s', '%s')",tekstas, PlayerName(playerid));
            mysql_query(query);
            return 1;
    }

    CMD:atnaujinimas(playerid, params[])
    {
            new tekstas[128], query[128];
            if(sscanf(params, "s[128]", tekstas)) return SendClientMessage(playerid, -1, "Naudojimas - /atnaujinimas [tekstas]");
            format(query, sizeof(query),"INSERT INTO nustatymai (atnaujinimas) VALUES ('%s')",tekstas);
            mysql_query(query);
            return 1;
    }