Jump to content

need help with sqlite


Sparrow

Recommended Posts

I'm working in house systel with SQLite, and I got problem.

can't find a way to create houses from data base when resource start.

SQLite table:

executeSQLCreateTable("Houses", "houseID STRING, houseOwner STRING, housePrice STRING, houseX STRING, houseY STRING, houseZ STRING") 

I try this, but wont work:

function createHousesOnStart() 
    local result = executeSQLQuery("SELECT houseID,houseOwner,housePrice,houseX,houseY,houseZ FROM Houses WHERE houseID=?") 
    if (result) and (houseOwner == "None") then 
        house = createPickup(houseX, houseY, houseZ, 3, 1273, 0) 
    else 
        house = createPickup(houseX, houseY, houseZ, 3, 1272, 0) 
    end 
end 
addEventHandler("onResourceStart", getResourceRootElement(getThisResource()), createHousesOnStart) 

sorry because I don't speak arabic, I havn't arabic keys on my laptop :(

Link to comment
local result = executeSQLQuery("SELECT houseID,houseOwner,housePrice,houseX,houseY,houseZ FROM Houses WHERE houseID=?") 

IDوضعت علامة الاستفهام و لم تحدد ال

من الكود انا اعتقد انك تريد كل المعلومات

function createHousesOnStart() 
    local result = executeSQLQuery("SELECT * FROM Houses") 
    if (#result == 0) then return end 
    for index, row in pairs(result) do 
    local house 
    if (row.houseOwner == "None") then 
        house = createPickup(row.houseX, row.houseY, row.houseZ, 3, 1273, 0) 
    else 
        house = createPickup(row.houseX, row.houseY, row.houseZ, 3, 1272, 0) 
    end 
end 
addEventHandler("onResourceStart", getResourceRootElement(getThisResource()), createHousesOnStart) 

Link to comment

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...