djharbi2

Members
  • Content Count

    77
  • Joined

  • Last visited

Community Reputation

3 Neutral

About djharbi2

  • Rank
    Transformer

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. thanks bro, problem solved
  2. If you recreate the above code, I would be glad, you can do it
  3. yes that's exactly the problem
  4. want to pull the vehicleHP value of the matching person For example: djharbi, 520, infernus, 100, good,1000 (This is a sample data) The data I want > 1000 (vehicleHP)
  5. Hi, I want to print the matching value but I can't Can you help, thank you ... server.Lua local vehDB = dbConnect( 'sqlite', 'vehicle.db' ) dbExec(vehDB,' CREATE TABLE IF NOT EXISTS `vehicle_base` (pAcc, vehicleID, vehicleName, vehiclePrice, vehicleStatus, vehicleHP)') function dategetV() local results = dbPoll(dbQuery(vehDB, "SELECT * FROM `vehicle_base` WHERE vehicleID=? AND pAcc=?",520,getAccountName(getPlayerAccount(source))), -1) if results then for k,v in ipairs ( results ) do outputDebugString(tostring(v['vehicleHP'])) end end end addEvent("dategetV", true) addEventHandler("dategetV", getRootElement(getThisResource()), dategetV)
  6. Hi, dxCreateTexture How do I round an image created with myImage = dxCreateTexture( "moonpig.png" ) dxDrawImage( 100, 350, 300, 350, myImage )
  7. hello what were the best mtaserver.conf file settings ie I want a mtaserver.conf file with settings made in the best settings Thank you from now
  8. Does anyone know the problem?
  9. I didn't write it here, it normally exists
  10. Hi, saving datebase. But does not record the question properly entered: your favorite writer? saved: your favorite writer' (? instead ' is happening) database charset: utf-8 how can I solve this problem? local username = "root" local password = "123456" local b_data = dbConnect("mysql","dbname=mtaserver;host=localhost;charset=utf8;port=3311", username, password, "autoreconnect=1"), local b_username = "admin" local b_pass = "1234" local b_ques = "your favorite writer?" local b_answ = "T. Well" local b_money = "0" local bank = dbExec(b_data, "INSERT INTO bank (bank_username,bank_pass,bank_ques,bank_answ,bank_money) VALUES('"..b_username.."','"..b_pass.."','"..b_ques.."','"..b_answ.."','"..b_money.."')")
  11. Hi, mysql connection falls after some time databasen = setting.mysql function chac1() local acc = getPlayerAccount (client) local username = getAccountName ( acc ) local slot = getAccountData (acc,"characterslot") or "no" local veriable2s = mysql_query(databasen, "SELECT * FROM skinshop WHERE skinshop_username='"..username.."'") if veriable2s then local okey2 = mysql_fetch_assoc(veriable2s) for okey,row in mysql_rows(veriable2s) do c1 = row[3] c2 = row[4] end end mysql_free_result(veriable2s) end the first time it works, there is no problem, but then disconnects the database How can I solve