· 9 years ago · Oct 31, 2016, 05:02 PM
1function joinWork(usernick)
2 local connect = dbConnect("sqlite", ":maincore/logins.db")
3 if connect then
4 outputChatBox("connect")
5 local userDataID = dbQuery(connect, "SELECT id FROM `users` WHERE playerNick='"..usernick.."'")
6 local result = dbPoll(userDataID, -1)
7 if result then
8 local query = dbQuery(connect, "CREATE TABLE IF NOT EXISTS jobs(jobId NUMERIC, user NUMERIC, level NUMERIC, alga NUMERIC, contract NUMERIC)")
9 local result1 = dbPoll(query, -1)
10 if result1 then
11 local startWorking = dbQuery (connect, "INSERT INTO jobs(jobId, user, level, alga, contract) VALUES(?????)",tonumber(1),userDataID, tonumber(1), tonumber(200), tonumber(7))
12 local result2 = dbPoll(startWorking, -1)
13 if result2 then
14 outputChatBox("started")
15 end
16 end
17 end
18 end
19end
20addEvent("joinWork", true)
21addEventHandler("joinWork", getRootElement(), joinWork)