Ahmed Araby Posted April 9, 2017 Share Posted April 9, 2017 انا عامل ماركر تقدر تدخله و اذا كتبت كوماند ما تقدر تدخله طبعا من الداتا لو ترو او فولس لكن لما اعمل ريستارت ما يحفظ محاولاتي انا اول مره اتعامل مع السكل طبعا بعد وقت معين تحطه يرجع انا عاوز لو عملت ريستارت يجيب الوقت و لما المود يبدا التايمر يكمل , اذا الداتا ترو تقدر تخش اذا فولس متقدرش executeSQLQuery ( 'CREATE TABLE IF NOT EXISTS aTable ( aTimer , aData )' ) addEventHandler( 'onResourceStop' , root , function ( ) local aData_ = getElementData ( marker , 'Enter' ) t,v, z = getTimerDetails(Timer) aTimer_ = t1 local aSQL_ = executeSQLQuery( 'SELECT * FROM aTable WHERE aTimer = ?' , aTimer_ ) return ( ( ( #aSQL_ == 0 ) and executeSQLQuery( 'INSERT INTO aTable VALUES ( ? , ? )' , aTimer_ , aData_ ) ) or executeSQLQuery( 'UPDATE aTable SET Enter = ? WHERE aTimer = ?' , aData_ , aTimer_ ) ) end ) addEventHandler( 'onResourceStart' , root , function ( ) local aSQL_ = executeSQLQuery( 'SELECT * FROM aTable WHERE aTimer = ? ' , aTimer ) for Index in ipairs ( aSQL_ ) do setElementData ( marker , 'Enter' , aSQL_ [ Index ] [ 'aData' ] ) Timer = setTimer( function() setElementData(marker,"Enter",true) end, aSQL_ [ Index ] [ 'aTimer_' ], 1) end end ) Link to comment
Abdul KariM Posted April 9, 2017 Share Posted April 9, 2017 مفروض يكون فيه كولمن 3 ويكون اما عن طريق السريال او الاكونت Link to comment
Ahmed Araby Posted April 9, 2017 Author Share Posted April 9, 2017 1 minute ago, Abdul KariM said: مفروض يكون فيه كولمن 3 ويكون اما عن طريق السريال او الاكونت انا بقول انا بحفظ على الماركر مش لاعب 3 minutes ago, Abdul KariM said: مفروض يكون فيه كولمن 3 ويكون اما عن طريق السريال او الاكونت .. Link to comment
Abdul KariM Posted April 9, 2017 Share Posted April 9, 2017 طيب ماهي معرفة t1 سطر 6 عندك Link to comment
Ahmed Araby Posted April 9, 2017 Author Share Posted April 9, 2017 3 minutes ago, Abdul KariM said: طيب ماهي معرفة t1 سطر 6 عندك سوري t مش t1 4 minutes ago, Abdul KariM said: طيب ماهي معرفة t1 سطر 6 عندك بردو فين الخطا ؟ انا كنت مجرب و هي t و ما ظبط يمكن و انا انقل الاكواد في شئ غلط Link to comment
Abdul KariM Posted April 9, 2017 Share Posted April 9, 2017 (edited) addEventHandler( 'onResourceStart' , root , function ( ) local aSQL_ = executeSQLQuery( 'SELECT aTimer FROM aTable' ) setElementData ( marker , 'Enter' , aSQL_ [ 1 ] [ 'aData' ] ) Timer = setTimer ( setElementData , aSQL_ [ 1 ] [ 'aTimer' ] , 1 , marker , "Enter" , true ) end ) #Edit Edited April 9, 2017 by Abdul KariM Link to comment
Ahmed Araby Posted April 10, 2017 Author Share Posted April 10, 2017 (edited) 28 minutes ago, Abdul KariM said: addEventHandler( 'onResourceStart' , root , function ( ) local aSQL_ = executeSQLQuery( 'SELECT * FROM aTable WHERE aTimer = ? ' , aTimer ) setElementData ( marker , 'Enter' , aSQL_ [ 1 ] [ 'aData' ] ) Timer = setTimer ( setElementData , tonumber ( aSQL_ [ 1 ] [ 'aTimer' ] ) , 1 , marker , "Enter" , true ) end ) executeSQLQuery ( 'CREATE TABLE IF NOT EXISTS aTable ( aTimer , aData )' ) addEventHandler( 'onResourceStop' , root , function ( ) local aData_ = getElementData ( marker , 'Enter' ) t,v,z = getTimerDetails(Timer) aTimer_ = t local aSQL_ = executeSQLQuery( 'SELECT * FROM aTable WHERE aTimer = ?' , aTimer_ ) return ( ( ( #aSQL_ == 0 ) and executeSQLQuery( 'INSERT INTO aTable VALUES ( ? , ? )' , aTimer_ , aData_ ) ) or executeSQLQuery( 'UPDATE aTable SET aData = ? WHERE aTimer = ?' , aData_ , aTimer_ ) ) end ) addEventHandler( 'onResourceStart' , root , function ( ) local aSQL_ = executeSQLQuery( 'SELECT * FROM aTable WHERE aTimer = ? ' , aTimer_ ) setElementData ( marker , 'Enter' , aSQL_ [ 1 ] [ 'aData' ] ) Timer = setTimer( function() setElementData(marker,"Enter",false) end, tonumber ( aSQL_ [ 1 ] [ 'aTimer' ] ), 1) end ) اهو كدا مش ظابط .. Edited April 10, 2017 by Ahmed Araby Link to comment
Abdul KariM Posted April 10, 2017 Share Posted April 10, 2017 (edited) عدلته انسخه من جديد ولاتغير فيه شي Edited April 10, 2017 by Abdul KariM Link to comment
Ahmed Araby Posted April 10, 2017 Author Share Posted April 10, 2017 4 minutes ago, Abdul KariM said: عدلته انسخه من جديد ولاتغير فيه شي executeSQLQuery ( 'CREATE TABLE IF NOT EXISTS aTable ( aTimer , aData )' ) addEventHandler( 'onResourceStop' , root , function ( ) local aData_ = getElementData ( marker , 'Enter' ) t,v,z = getTimerDetails(Timer) aTimer_ = t local aSQL_ = executeSQLQuery( 'SELECT * FROM aTable WHERE aTimer = ?' , aTimer_ ) return ( ( ( #aSQL_ == 0 ) and executeSQLQuery( 'INSERT INTO aTable VALUES ( ? , ? )' , aTimer_ , aData_ ) ) or executeSQLQuery( 'UPDATE aTable SET aData = ? WHERE aTimer = ?' , aData_ , aTimer_ ) ) end ) addEventHandler( 'onResourceStart' , root , function ( ) local aSQL_ = executeSQLQuery( 'SELECT aTimer FROM aTable' ) setElementData ( marker , 'Enter' , aSQL_ [ 1 ] [ 'aData' ] ) Timer = setTimer ( setElementData , aSQL_ [ 1 ] [ 'aTimer' ] , 1 , marker , "Enter" , true ) end ) كدا و يجي بالدي بق no such column: false no such column: aTimer attempt to index field '?' 15 minutes ago, Abdul KariM said: عدلته انسخه من جديد ولاتغير فيه شي ! Link to comment
Ahmed Araby Posted April 10, 2017 Author Share Posted April 10, 2017 3 minutes ago, #Soking said: كودي دا ؟ ض اها ممكن تصلحه ؟ Link to comment
Ahmed Araby Posted April 10, 2017 Author Share Posted April 10, 2017 2 minutes ago, #Soking said: طيب أنت وش تبي تسوي ض1 في ماركر لو الداتا بتاعته اسمها Enter لو الداتا قيمتها 1 تقدر تدخل و ينقلك لمكان لو الداتا قيمتها 0 ما ينقلك للمكان عاوز لو عملت ريستارت للمود داتا بتاعت الماركر ما تتغير Link to comment
#Soking Posted April 10, 2017 Share Posted April 10, 2017 انت تبي تحفظ الداتا بس صح ؟ Link to comment
Ahmed Araby Posted April 10, 2017 Author Share Posted April 10, 2017 (edited) اه بس الداتا Edited April 10, 2017 by Ahmed Araby Link to comment
#Soking Posted April 10, 2017 Share Posted April 10, 2017 (edited) Edit غلط ض1 Edited April 10, 2017 by #Soking Link to comment
Ahmed Araby Posted April 10, 2017 Author Share Posted April 10, 2017 3 minutes ago, #Soking said: Edit غلط ض1 فين طيب ؟ Link to comment
#Soking Posted April 10, 2017 Share Posted April 10, 2017 executeSQLQuery ( 'CREATE TABLE IF NOT EXISTS aTable ( aValue )' ) addEventHandler( 'onResourceStop' , root , function ( ) local aData_ , aSQL_= getElementData ( marker , 'Enter' ) , executeSQLQuery( 'SELECT * FROM aTable ' ) return ( ( ( #aSQL_ == 0 ) and executeSQLQuery( 'INSERT INTO aTable VALUES ( ? )' , aData_ ) ) or executeSQLQuery( 'UPDATE aTable SET aValue = ? ' , aData_ ) ) end ) addEventHandler( 'onResourceStart' , root , function ( ) local aSQL_ = executeSQLQuery( 'SELECT * FROM aTable' ) setElementData ( marker , 'Enter' , aSQL_ [ 1 ] [ 'aValue' ] ) end ) Link to comment
Ahmed Araby Posted April 10, 2017 Author Share Posted April 10, 2017 (edited) 2 minutes ago, #Soking said: executeSQLQuery ( 'CREATE TABLE IF NOT EXISTS aTable ( aValue )' ) addEventHandler( 'onResourceStop' , root , function ( ) local aData_ , aSQL_= getElementData ( marker , 'Enter' ) , executeSQLQuery( 'SELECT * FROM aTable ' ) return ( ( ( #aSQL_ == 0 ) and executeSQLQuery( 'INSERT INTO aTable VALUES ( ? )' , aData_ ) ) or executeSQLQuery( 'UPDATE aTable SET aValue = ? ' , aData_ ) ) end ) addEventHandler( 'onResourceStart' , root , function ( ) local aSQL_ = executeSQLQuery( 'SELECT * FROM aTable' ) setElementData ( marker , 'Enter' , aSQL_ [ 1 ] [ 'aValue' ] ) end ) مش شغال debug : no such column : aValue Edited April 10, 2017 by Ahmed Araby Link to comment
#Soking Posted April 10, 2017 Share Posted April 10, 2017 executeSQLQuery ( 'CREATE TABLE IF NOT EXISTS aTable_ ( aValue )' ) addEventHandler( 'onResourceStop' , root , function ( ) local aData_ , aSQL_= getElementData ( marker , 'Enter' ) , executeSQLQuery( 'SELECT * FROM aTable_ ' ) return ( ( ( #aSQL_ == 0 ) and executeSQLQuery( 'INSERT INTO aTable_ VALUES ( ? )' , aData_ ) ) or executeSQLQuery( 'UPDATE aTable_ SET aValue = ? ' , aData_ ) ) end ) addEventHandler( 'onResourceStart' , root , function ( ) local aSQL_ = executeSQLQuery( 'SELECT * FROM aTable_' ) setElementData ( marker , 'Enter' , aSQL_ [ 1 ] [ 'aValue' ] ) end ) Link to comment
Ahmed Araby Posted April 10, 2017 Author Share Posted April 10, 2017 3 minutes ago, #Soking said: executeSQLQuery ( 'CREATE TABLE IF NOT EXISTS aTable_ ( aValue )' ) addEventHandler( 'onResourceStop' , root , function ( ) local aData_ , aSQL_= getElementData ( marker , 'Enter' ) , executeSQLQuery( 'SELECT * FROM aTable_ ' ) return ( ( ( #aSQL_ == 0 ) and executeSQLQuery( 'INSERT INTO aTable_ VALUES ( ? )' , aData_ ) ) or executeSQLQuery( 'UPDATE aTable_ SET aValue = ? ' , aData_ ) ) end ) addEventHandler( 'onResourceStart' , root , function ( ) local aSQL_ = executeSQLQuery( 'SELECT * FROM aTable_' ) setElementData ( marker , 'Enter' , aSQL_ [ 1 ] [ 'aValue' ] ) end ) شكرا Link to comment
#STZ Posted April 10, 2017 Share Posted April 10, 2017 طيب سوي يوم يشتغل المود يحط داتا الماركر 1 ض اسهل لك ولا تبي يحفظ داتا الماركر عموما ؟ Link to comment
#Soking Posted April 10, 2017 Share Posted April 10, 2017 7 hours ago, MR.NaiF-MTA said: طيب سوي يوم يشتغل المود يحط داتا الماركر 1 ض اسهل لك ولا تبي يحفظ داتا الماركر عموما ؟ 10 hours ago, Ahmed Araby said: شكرا ؟؟؟؟؟ تمت الافاده -__- Link to comment
#STZ Posted April 10, 2017 Share Posted April 10, 2017 انت دايما معارض وما يعجبك شي شخصية باردة @#Soking Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now