Pbwolf wrote:You have to edit the database. There is a character table, with a column for GM. Change it to 1 for your character.
MH6 wrote:Dwolf wrote:Is there any command to show the server ip?
listAllServers(); maybe? Or just select the server in the server browser and it should show the address in the bottom right.
MH6 wrote:If you are interested, I wrote a plugin to maintain a unique DB table that contains all the active players. I'm doing this for my live web map viewer, which shows all the current players and structures on the map in your web browser. I don't get login times (I am polling data every so often at the moment) but I'd imagine it can be done via callbacks.
I'm also writing a plugin to automatically sync character and skill data between server instances.
It'd be nice if we could get access to a few of the source server .cs files
TgTemplar wrote:/alignment set # - Sets alignment on user. Only seems to work up to 0.
/heal - As the name suggests. (Only brings a user to 100 flat.)
/Reagents - Gives you a LOT of alchemical goods. A LOT.
Revv wrote:Do we have to know how to use mysql to do this or is there an easier way I have no idea on how to use mysql.
Revv wrote:Are you guys using something like MySQL to edit the database files or is there another program to edit the tables?
Kobiwaldi wrote:/weather # --Change the weather
/delobj -- Target with mouse over construction to delete it
/addobj --Found the Command but dont know how to use it
/setmyskill skillname # --Set's the Skill level of the selected skill
/stuck --get unstuck
/suicide --get instant kill
Something more but did not test it (maybe they dont work at all)
/WC
/GROW
/STABLE
/KO
/TESTCRIM
/MIXER
/ADDOBJ
/SETMYSTAT
/EFFECTADD
/EFFECT
/ANIMAL
/ARROW
Nazgul111 wrote:would be usefull to know the exact filename of the database file we need to edit, the only sql file i could find in blackbox files is new.sql
TgTemplar wrote:Kobiwaldi wrote:/weather # --Change the weather
/delobj -- Target with mouse over construction to delete it
/addobj --Found the Command but dont know how to use it
/setmyskill skillname # --Set's the Skill level of the selected skill
/stuck --get unstuck
/suicide --get instant kill
Something more but did not test it (maybe they dont work at all)
/WC
/GROW
/STABLE
/KO
/TESTCRIM
/MIXER
/ADDOBJ
/SETMYSTAT
/EFFECTADD
/EFFECT
/ANIMAL
/ARROW
TorZar wrote:Nazgul111 wrote:would be usefull to know the exact filename of the database file we need to edit, the only sql file i could find in blackbox files is new.sql
well, for specifically what you asked.. if you're running dedicated server as instructed by readme.. you'll most likely have the "database files" in (C:\Program Files\MariaDB 5.5\data\lif_1)
BUT
I'm assuming this isn't what you're really wanting as that's not how to go about editing these things..
It's running as a service and server on you're local machine (assuming again, it's been followed) and will need to log into the server with SQL management software..
BLACKBOX - I couldn't answer.. haven't touched it.. just throwing out there that it wont be a single "file" you'll be editing
Nazgul111 wrote:TorZar wrote:Nazgul111 wrote:would be usefull to know the exact filename of the database file we need to edit, the only sql file i could find in blackbox files is new.sql
well, for specifically what you asked.. if you're running dedicated server as instructed by readme.. you'll most likely have the "database files" in (C:\Program Files\MariaDB 5.5\data\lif_1)
BUT
I'm assuming this isn't what you're really wanting as that's not how to go about editing these things..
It's running as a service and server on you're local machine (assuming again, it's been followed) and will need to log into the server with SQL management software..
BLACKBOX - I couldn't answer.. haven't touched it.. just throwing out there that it wont be a single "file" you'll be editing
Blackbox = Server Provider, i am not hosting the server on my local machine but rather on blackbox servers as such i have ftp access to the server files
TorZar wrote:ya, you'll have to see and hunt down if they give you access and info to log into your servers database (which, compared to other game server hosters.. doubtful but not impossible)
TgTemplar wrote:I've got a minor 'project' for you guys, the Loading screen prompts can be found in a file called.. something-something messages.(Will edit this when I get home. Watching students take tests atm.)
Can we find a way to get these to read personal messages or are the loading screen messages hosted locally instead of pulled from a server? Also! Altering the system welcoming prompt, has anyone found a way to modify this yet? (I've yet to sit down and comb all the files for this stuff.)
Sherwood23 wrote:What program are you guys modifying the Database with?
My server is hosted by Blackbox, I have FTP access.. but I don't think that I would use filezilla to do so..
Would the database be located in thesefiles?
http://prntscr.com/4ppvbc
I kinda think what I need is some program that would connect to the server via IP.. then it would display the tables.. am I right?
hah thanks for your patience guys..
Nazgul111 wrote:Sherwood23 wrote:What program are you guys modifying the Database with?
My server is hosted by Blackbox, I have FTP access.. but I don't think that I would use filezilla to do so..
Would the database be located in thesefiles?
http://prntscr.com/4ppvbc
I kinda think what I need is some program that would connect to the server via IP.. then it would display the tables.. am I right?
hah thanks for your patience guys..
http://www.heidisql.com/download.php
This one seems to be able to do it via ftp, however i have no clue if blackbox allows it, wrote a ticket so will see in a bit.