· 10 years ago · Sep 10, 2016, 01:50 AM
1ddEventHandler('onResourceStart',resourceRoot,
2 function ( )
3 CreateTable = executeSQLQuery ('CREATE TABLE IF NOT EXISTS `Save LeveL System` (Account,Data1,Data2) ')
4 end
5)
6exports.scoreboard:addScoreboardColumn('KillS')
7exports.scoreboard:addScoreboardColumn('LeVeL')
8Tabel = {}
9addEventHandler ( "onPlayerJoin", root,
10function()
11setElementData(source, "KillS", 0)
12setElementData(source, "LeVeL", 0)
13end
14)
15addEventHandler( 'onPlayerWasted', root,
16function(_,Kill)
17 if Kill ~= source and getElementType(Kill) == 'player' then
18 local Killer = getPlayerAccount(Kill)
19 if (Killer) then
20 setElementData(Kill, "KillS", (getElementData(Kill, "KillS") or 0) + 1)
21 if (getElementData(Kill, "KillS") == 25 ) then
22 setElementData(Kill, "LeVeL", (getElementData(Kill, "LeVeL") or 0) + 1)
23 end
24 end
25 end
26 end
27)
28addEventHandler('onPlayerQuit',root,
29 function ( )
30
31
32 local _LeveL = executeSQLQuery("SELECT * FROM `Save LeveL System` WHERE Account=?",getPlayerAccount(source) )
33 if ( type ( _LeveL) == "table" and #_LeveL == 0 or not _LeveL ) then
34 executeSQLQuery ( "INSERT INTO `Save Position System` ( Account,Data1,Data2 ) VALUES(?,?,?)",getPlayerAccount(source),getElementData(Kill, "KillS") or 0,getElementData(Kill, "LeVeL") or 0 )
35 else
36 executeSQLQuery('UPDATE `Save LeveL System` SET Data1 =?, Data2 =? WHERE Account =?',(getElementData(Kill, "KillS") or 0),(getElementData(Kill, "LeVeL") or 0),getPlayerAccount(source) )
37 end
38end
39)
40addEventHandler('onPlayerLogin',root,
41 function ( )
42 local _LeveL = executeSQLQuery("SELECT * FROM `Save LeveL System` WHERE Account=?",getPlayerAccount(source) )
43 if ( type ( _LeveL ) == "table" and #_LeveL == 0 or not _LeveL ) then return end
44
45 setElementData(source, "KillS", Data1 or 0)
46 setElementData(source, "LeVeL", Data2 or 0)
47 end
48)