judge script

[MatXpl]

how can i make script to judge maps ? ;D

How to save this ? (best method)

[Castillo]

What do you mean by "judge"? like/dislike?

[MatXpl]

1-10 vote

[Castillo]

You could use SQLite, would be the best way.

[MatXpl]

ok, im going to write this

  
function vote(p,command,vote) 
local nick = getPlayerNametagText(p) 
executeSQLQuery("CREATE TABLE IF NOT EXISTS votes (nick TEXT, vote TEXT)") 
  
end 
addCommandHandler("vote",vote) 
  

it should looks like that ?

[Castillo]

You can make one table, then store the nick, map name, vote in a row.

[MatXpl]

can you give me a simple example ?

[Castillo]

addEventHandler ( "onResourceStart", resourceRoot, 
    function ( ) 
        executeSQLQuery ( "CREATE TABLE IF NOT EXISTS votes (nick TEXT, map TEXT, vote TEXT)" ) 
    end 
) 
  
function vote ( p, command, vote ) 
    local nick = getPlayerNametagText ( p ) 
    local mapName = getResourceName ( exports [ "mapmanager" ]:getRunningGamemodeMap ( ) ) 
    local check = executeSQLSelect ( "votes", "*", "nick = '".. tostring ( nick ) .."' AND map = '".. mapName .."'" ) 
    if ( type ( check ) == "table" and #check == 0 ) or not check then 
        executeSQLQuery ( "INSERT INTO votes VALUES (?,?,?)", nick, mapName, vote ) 
    end 
end 
addCommandHandler ( "vote", vote ) 

Try that.

[MatXpl]

thanks!

is working that it not allows the player to vote for the same map twice ?

(check)

[Castillo]

It should only insert once for each map and nick.

[MatXpl]

ohhh, ok

and how to connect with my sql server?

[Castillo]

Well, that's different, you must use the MySQL functions for that.

[MatXpl]

https://wiki.multitheftauto.com/wiki/DbConnect

https://wiki.multitheftauto.com/wiki/Mod ... ql_connect

this when resource start ?

[Castillo]

Yes, that's used to connect both to a own SQLite file or a MySQL server.