{help} sql query

[gigastar]

Hey everyone, It has been some time sense I have been in the OT community. I was just wondering if someone could tell me how to set up a function to execute a SQL query

I know it is something like this...

function setDatabaseStorage(cid, storage, value)
query = INSERT INTO `accounts` SET `storage` = value WHERE `id` = getPlayerAccountid(cid)

 

[gigastar]

bump

 

[Ninja]

function setDatabaseStorage(cid, value)
   db.executeQuery("UPDATE `accounts` SET `storage` = " .. value .. " WHERE `id` = " .. getPlayerAccountid(cid))
end

 

[gigastar]

Also what is the query to add a new column into a table in mysql.

ty ninja

 

[Ninja]

Just an example, you could use other types as well instead of INT

ALTER TABLE `tablename` ADD `newcolumn` INT(11) NOT NULL DEFAULT 0;

 

[gigastar]

<3 rep+