help with sql with rmx-os(given up)

Started by edwardthefma, December 03, 2009, 07:56:08 pm

Previous topic - Next topic

edwardthefma

December 03, 2009, 07:56:08 pm Last Edit: December 05, 2009, 12:14:37 pm by edwardthefma
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
i am the lead dev for the shellium mmorpg project
http://wiki.shellium.org/w/Mmorpg
shellium.org :) free linux shells pm me and i will gladly
help you get 1

Blizzard

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. :/
Check out our game brands:

Daygames
Game Night Games
Chugnar Games

Quote from: winkioI do not speak to bricks, either as individuals or in wall form.

Quote from: Barney StinsonWhen I get sad, I stop being sad and be awesome instead. True story.

edwardthefma

i am the lead dev for the shellium mmorpg project
http://wiki.shellium.org/w/Mmorpg
shellium.org :) free linux shells pm me and i will gladly
help you get 1