Jump to content

ToiletMaster

Members
  • Content Count

    146
  • Joined

  • Last visited

  • Days Won

    1

Reputation Activity

  1. Upvote
    ToiletMaster reacted to Xgear in Linux Commands for MySQL   
    It is NEVER a good practice to use root for anything (Or Administrator for windows), as a faulty piece of code/script or whatever else could end up screwing your entire OS installation. 
     
    You can always "sudo" something if you have the need to.
     
    I've never used workbench for anything, so no idea there.
    To empty a table as jaBote mentioned before, you can use truncate as an sql command
    To insert data simply do INSERT into `table` (`col1`, `col2`, `col3`) VALUES('string1', int1, 'string2');
     
    For storage for example, you can do this
     
    INSERT INTO `storage` (`id` ,`account_id` ,`nameid` ,`amount` ,`equip` ,`identify` ,`refine` ,`attribute` ,`card0` ,`card1` ,`card2` ,`card3` ,`expire_time` ,`unique_id`)VALUES (NULL , 2000000, 500, 5, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0); That'd insert into Account 200000 5 (amount) Red Potions (nameid 500). 
  2. Upvote
    ToiletMaster reacted to jaBote in Linux Commands for MySQL   
    For this you should have a lot of care. If you want to wipe all your server data and ONLY leave accounts alive (which is what I think you want), I'd truncate (TRUNCATE TABLE `table_name`) all tables except `login` and (optionally) `mapreg`. Truncating a table means emptying all of its content and setting the auto_increment values to 1. Making backup is highly advised before doing this. 
     
    Can't tell you right now, I'd better use PHP for this and insert it with 2 queries: one for getting all the account ids and another for inserting a value on the storage table for them. 
    For the warning, it means you're running it as a root superuser in your Linux system and you're advised not to do that ecause consequences may be fatal if someone manages to take over your system via the game, because they're allowed to do anything as root. That's not MySQL related.
  3. Upvote
    ToiletMaster reacted to mleo1 in Linux Commands for MySQL   
    GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, EXECUTE ON ROdatabase.* TO 'user'@'host';  
  4. Upvote
    ToiletMaster reacted to Xgear in Linux Commands for MySQL   
    The emulator is never going to attempt to create/drop/alter a table. I'd leave those off.
  5. Upvote
    ToiletMaster reacted to Xgear in Unable to apply updates SQL   
    Did you compile it with Visual C++? If you did I'd suggest running the server in debug mode to figure out the issue and post here with whatever problems you may have if you can't solve them
  6. Upvote
    ToiletMaster got a reaction from jaBote in Sealed MVP Cards   
    File Name: Sealed MVP Cards
    File Submitter: ToiletMaster
    File Submitted: 24 May 2013
    File Category: Other Graphics
     
    Hi guys!
     
    Seeing that rAthena is down and the time I uploaded the file it got deleted,
     
    Here's the cards that I have currently for the Sealed MVP Cards!
     
    More power to Hercules!
     
    If you have more pictures to be added in, do let me know and I'll add them in!
     
    Right now these are what I have only.
     
    Anyways the names are the same as the item_db so it should be working fine!
     
    I have 22 cards here. It's not fully done yet though! Pictures such as Sealed Valkyrie aren't in yet and I can't get them through our grf files.
     
    So if someone does have the files, do let me know!
     
    -It seems that Hercules does not supports RAR files therefore I can't place all the files together. Sorry guys)
     
    Click here to download this file
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.