Chaos Project

RPG Maker => RPG Maker Scripts => Script Troubleshooting => Topic started by: edwardthefma on December 03, 2009, 07:56:08 pm

Title: help with sql with rmx-os(given up)
Post by: edwardthefma on December 03, 2009, 07:56:08 pm
ok i have bean working on making a irc bot that will display the top ten best players in the game
so i added a new colum names user lv to the user table
then i lernd the command i need to query the sql with to +1 to the table

UPDATE `users` SET user_lv = user_lv + 1 WHERE `username`='USERNAME'

now the only thing i have left to do is the script inside the game client
now from reading the chat commands in  the rmxos script
 
def command_sql_script(script)
     self.send("ASQ#{script}")
   end
this is the command to queary somthing to the sql but i cant figure out how i need to put it in
could some 1 help me or tell me if im going down the right path
or have i lost my way
Title: Re: help with sql with rmx-os(given up)
Post by: Blizzard on December 06, 2009, 05:24:15 am
You need to do this during saving. Find RMXOS::Network#save and add it there. But it won't work in later versions because I am going to add a server side check of the permissions. :/
Title: Re: help with sql with rmx-os(given up)
Post by: edwardthefma on December 09, 2009, 10:50:11 am
 :(