ToiletMaster
-
Content Count
146 -
Joined
-
Last visited
-
Days Won
1
Reputation Activity
-
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).
-
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.
-
ToiletMaster reacted to mleo1 in Linux Commands for MySQL
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, EXECUTE ON ROdatabase.* TO 'user'@'host';
-
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.
-
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
-
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