AleksCore

Members
  • Content count

    83
  • Joined

  • Last visited

Community Reputation

1 Neutral

1 Follower

About AleksCore

  • Rank
    Transformer
  • Birthday 29/12/92

Details

  • Gang
    Core Guys
  • Location
    Belarus, Minsk

Recent Profile Visitors

343 profile views
  1. Multi Theft Auto: San Andreas 1.5.3 released!

    I changed only fps, which isn't a big job *lol* Thanks to the devs and to the contributors! Cheers 1.5.3
  2. [Question] GUI Testing

    Is there any way to set unsupported (higher) resolution in MTA (windowed mode)? So I'll be able to test GUI on 4K resolution with my FullHD monitor. Would be nice to had such option for devs
  3. MySQL Tips (need help)

    Thank you, @NegativeIQ. I guess I can use dbExec and don't need to free db in this case
  4. MySQL Tips (need help)

    Oh, it actually works. Thank you! I like this way. @NegativeIQ oh, wait. But what to do if data different for all players? Same columns but different data
  5. MySQL Tips (need help)

    Thanks for the reply, but I'll try to use multi statements and see how it works. Need to enable it in dbConnect and use dbPrepareString
  6. MySQL Tips (need help)

    I've been searching for a MySQL tips and noticed there is no such topics on this forum. So let's fix this little problem. I want to know more about optimising MySQL queries and how to interract with MySQL correctly, I am newbie in that. I learned that putting queries in the loop it's too performance-expensive, wrong, and very big chance it'll freeze your server for uncertain time. So if I want to get information from DB for a many players, better to make it using only 1 query. Example: "SELECT * FROM race_stats WHERE playerID IN(??)" Where "??" = table with logged in players. But, what if I want to update information for a many players at the same time? How such query should look like? For 1 player it looks like this: "UPDATE race_stats SET id1 = id1 + ?, id2 = id2 + ?, id3 = id3 + ?, id4 = id4 + ?, id5 = id5 + ? WHERE playerID = ?" But how to make the same for all players? Put query in the loop will be too performance-expensive I guess and will create laggs. P.S. Maybe for such thing as player stats better to learn MySQL procuderes and create procedure for this, I am newbie, just asking. Don't even know what is procedures exactly, just heard about it.
  7. How to sort a table by value

    function getSortedTable( tableToSort ) --this function will sort our unsorted table and return sorted table local sortedTable = {} for player, money in ipairs(tableToSort) do local playerName = getPlayerName(player) table.insert( sortedTable,{ ['name'] = playerName, ['value'] = money } ) end table.sort(sortedTable, function(a, b) return a.value > b.value end ) return sortedTable end function show10RichestPlayers() local sortedPlayers = getSortedTable(notSortedTable) --notSortedTable is our table with player element as a key and money number as value for i=1, 10 do outputChatBox(sortedPlayers[i].name.." - $"..sortedPlayers[i].value, root, 0, 255, 0) end end addCommandHandler('show10', show10RichestPlayers) This is how I did it. Here could be mistakes, I didn't tested this code. Maybe for somebody this info will be useful
  8. How to sort a table by value

    That's not exactly what I asked for. I want the key as a player and value as money amount Anyways thanks, seems like I'll get how to do it myself.
  9. MTA Forum is back online and with a new look!

    Not a big deal however some users may have problems with it. click
  10. Change color of vehicleupgrades

    Oh yeah, He use shader to change paintjob. Guess he need to replace "vehiclegrunge256" texture name using engineApplyShaderToWorldTexture Something like this I guess (for elegy) engineApplyShaderToWorldTexture(shader, "vehiclegrunge256", 562) He is finally registered @Stroth
  11. How to sort a table by value

    How to sort a table where key is a player(userdata) and value is money(number). How to sort by value? Thanks!
  12. MTA Forum is back online and with a new look!

    @darkdreamingdan I got this: Sorry, there is a problem You are not permitted to register a user account with this site. Error code: 2S129/1 @darkdreamingdan I think we are both banned on the every forum with IPB engine. Just a guess, can't be sure of course. Update: friend said he registered. And I have an account so I won't try Thank you! Oh wait, he said he used mobile internet.
  13. Change color of vehicleupgrades

    Hi, community! A friend of mine can't register on the forum, he asked me to post following:
  14. MTA Forum is back online and with a new look!

    Please check registration. It's broken. Friend said he can't register. I tryed and I also can't
  15. need help with triggerServerEvent and addEvent

    Yes, I know. Thanks anyways! Mystery was in my mistake. Event was triggering 'onClientColShapeHit' and I totally forgot to make sure hitElement == localPlayer.