Printable View
Hi.
Im running my mangos server with latest sdb. Using sqlyog for db
Everything works just fine, but if I wanted to say add a tiger mount, I can't figure out how to search for it using sqlyou.
I don't know enough about sql to know how todo a query, and thats how you seem to search using sqlyog.
If someone could explain how to search for an item or monster using a query, id be really greatful.
Use MDH is simple and better
I tried mdh, but after inseerting the info it needed, it crashed saying something was wrong with a certain db table.Quote:
Originally Posted by raul.roland
But when I run the emu it's all good, not a single error at all, and yes I had mdh updated to the newest.
Besideds, it would be handy to know how to search via query.
But if you know why mdh would be giving me an error like that, but all tables in the db report fine then I would start using mdh.
Just type in game .lookupitem/.look and .. that's it
ex : .look sword
o.O there is a command for that ingame, im very surprised.Quote:
Originally Posted by cstk
Im off to try that out, thnx and post result soon:)
Works like a charm.
I just do .lookupitem $itemname and hey presto a list of items under that name, not sure if it works with cretures yet, but thnx alot!
I may be wrong, but I think there is also a command to lookup creatures in MangOS. Just type .commands while ingame. Also, you can use phpmyadmin to search for a creature name, then get the ID from the search results.
Yamachi, I don't have phpadmin.Quote:
Originally Posted by Yamachi
I use: mysql5/sqlyog and run things that way, I don't have any phpadmin or www folder
I would have to install other stuff for that, and I don't need it for now "only 4 players max"
But thanks for the info.