Jump to content

[HELP]SQL Help


thelaser

Recommended Posts

Hello Community,

I need your help :x

I've got some scripts and a sql database and i need to put some Quarry's in but i have no idea how to call them. a friend of me helped me with one. but i don't know the others. For carshop this one

local queryString = "INSERT INTO `personalvehicles`(`model`, `health`, `fuel`, `r1`, `g1`, `b1`, `r2`, `g2`, `b2`, `mod0`, `mod1`, `mod2`, `mod3`, `mod4`, `mod5`, `mod6`, `mod7`, `mod8`, `mod9`, `mod10`, `mod11`, `mod12`, `mod13`, `mod14`, `mod15`, `mod16`, `stored`) VALUES (".. vehicleID .. ",100,100,255,255,255,255,255,255,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1)" 

This one is for housing interiors

local result = executeSQLQuery("SELECT * FROM housingInteriorSQL WHERE interior = '"..int.."' AND dimension = '"..dim.."'"  ) 
            if result and #result > 0 then 
                local houseid = result[1].houseid  

and the last one for businesses

  
local sky = executeSQLQuery("SELECT amount FROM businessaccounts WHERE name='skyint'") 
                                executeSQLQuery("UPDATE businessaccounts SET amount=? WHERE name='skyint'", sky[1].amount + price) 
  

can someone please help me :)

Kind Regards Thelaser

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...