Problem with MySQL

[ertlflorian1]

Hi the Script with the MYSQL part dont work please help me!!

function oncolehit (thePlayer) 
    pname = getPlayerName (thePlayer) 
        if getElementType ( thePlayer ) == "player" then 
        veh = getPedOccupiedVehicle (thePlayer) 
        seat = getPedOccupiedVehicleSeat (thePlayer) 
            if veh and (seat == 0) then 
                local qh = dbQuery( handler2, "SELECT * FROM accounts WHERE Name = '"..pname.."'" ) 
                local result, num_affected_rows, errmsg = dbPoll ( qh, -1 ) 
                for result, row in pairs(result) do 
            if row then   
            if (row["Wert"] == "1") then 
    outputChatBox ("Danke das du das Parkhaus besuchst!", thePlayer, 0,255,0) 
    eschrankefunc () 
    end 
else 
    if getElementType ( thePlayer ) == "player" then 
        if veh and (seat == 0) then 
            triggerClientEvent (thePlayer, "openGUI", thePlayer, veh, pname) 
                        end 
                    end 
                end 
            end 
        end 
    end 
end 
addEventHandler ("onColShapeHit", cole, oncolehit) 

[Castillo]

Why it doesn't work? any errors?

[ertlflorian1]

No error in debugscript 3

[Castillo]

Try this:

function oncolehit ( thePlayer ) 
    if ( getElementType ( thePlayer ) == "player" ) then 
        local pname = getPlayerName ( thePlayer ) 
        local veh = getPedOccupiedVehicle ( thePlayer ) 
        local seat = getPedOccupiedVehicleSeat ( thePlayer ) 
        if ( veh ) and ( seat == 0 ) then 
            local qh = dbQuery ( handler2, "SELECT * FROM accounts WHERE Name = '".. pname .."'" ) 
            local result, num_affected_rows, errmsg = dbPoll ( qh, -1 ) 
            if ( result and type ( result ) == "table" and result [ 1 ] ) then 
                if ( result [ 1 ] [ "Wert" ] == "1" ) then 
                    outputChatBox ( "Danke das du das Parkhaus besuchst!", thePlayer, 0, 255, 0 ) 
                    eschrankefunc ( ) 
                else 
                    triggerClientEvent ( thePlayer, "openGUI", thePlayer, veh, pname ) 
                end 
            end 
        end 
    end 
end 
addEventHandler ( "onColShapeHit", cole, oncolehit ) 

[ertlflorian1]

Error:

[21:00:24] ERROR: Parkhaus\scripts\server2.lua:46: attempt to index field '?' (a

nil value)

[Castillo]

Which line is that? because that script only has 20 lines.

[ertlflorian1]

This line

if ( result [ 1 ] [ "Wert" ] == "1" ) then 

[Castillo]

Try copying it again.

[ertlflorian1]

I have tried it the it works at triggerClientEvent but not on the outputChatBox and eschrankefunc?

[Castillo]

Is "Wert" data set to "1"? also, seems like "result" is not returning what it should.

[ertlflorian1]

So looks it in Navicat!!

[Castillo]

Try this and see what it outputs to chat:

function oncolehit ( thePlayer ) 
    if ( getElementType ( thePlayer ) == "player" ) then 
        local pname = getPlayerName ( thePlayer ) 
        local veh = getPedOccupiedVehicle ( thePlayer ) 
        local seat = getPedOccupiedVehicleSeat ( thePlayer ) 
        if ( veh ) and ( seat == 0 ) then 
            local qh = dbQuery ( handler2, "SELECT * FROM accounts WHERE Name = '".. pname .."'" ) 
            local result, num_affected_rows, errmsg = dbPoll ( qh, -1 ) 
            outputChatBox ( "Rows: ".. tostring ( num_affected_rows ) ) 
            if ( result and type ( result ) == "table" and result [ 1 ] ) then 
                if ( result [ 1 ] [ "Wert" ] == "1" ) then 
                    outputChatBox ( "Danke das du das Parkhaus besuchst!", thePlayer, 0, 255, 0 ) 
                    eschrankefunc ( ) 
                else 
                    triggerClientEvent ( thePlayer, "openGUI", thePlayer, veh, pname ) 
                end 
            end 
        end 
    end 
end 
addEventHandler ( "onColShapeHit", cole, oncolehit ) 

[ertlflorian1]

If "Wert" == "1" triggerClientEvent conducted and it output Rows : 1

If no entery then it only output Rows : 0

[ertlflorian1]

Please help me sorry for double post

[ertlflorian1]

Please

[MR.S3D]

Please

what????