adding commands in SQLyog

[WFW-PREDATOR]

Finaly I mannaged to create my own private party server for offline Lan partys.
And I must say I am verry proud of my self, it took only about 2 hours with the crapy download speed of the files and configure of the server, before I got it running.
but....

How do I add commands in the SQLyog program?

under: root@localhost -> mangos -> commands
there isnt that mutch commands with power in them

Is there a file wih ALL of the commands for GM online and ready to use and just to import them?
and where can I find this file

[MentaL]

[teacher4]

erm...erm...
Well, to add commands you need to go to the core. That means decompile the exe and dll and do some c++ programming.

Good luck!

[WFW-PREDATOR]

oki, I droped that program, and use the SQLyog program.
works for me.

but how can other people connect to my server?
this is online.
I made a account for a person I know, but he just gets to the realm select list, and he can see the name of my server
but as he select that server the same window pops up
yes he has the same version as me, and I can connect to the server.

what ports on the router and what more config on the program?
DI-624+

[teacher4]

Go to your realm db realmlist (realmd / realmlist)
Make sure you put your domain / external ip and the proper port (8085 is default)
Now go in your router and access the port forwarding section.
Forward 3724 and 8085 to your local ip.
Also, you need to change the localhost setting.
Open Windows\system32\drivers\etc\hosts
instead of 127.0.0.1 localhost
put 192.168.1.x (your mangos localip) localhost

Pm me if you can't make it

Good luck!
p.s. Do me a favour. My reamd.exe after hours of server running perfectly, suddenly makes the CPU usage go to a 100%...if this happens to you too please let me know.

[WFW-PREDATOR]

yeah, I mannaged it now

but now for a realy good question
is there a full working mangos pack wit ALL the files I need
there are so many "repacks" out there, but no one is that really good.

What Im looking for is a FULL pack of a working mangos, with ALL the nesesary files IN ONE RAR FILE, so no extra download, uncept the SQL database program and mysql program.
some of the repacks dondt have instance in them, and other stuff

some repacks has corupt files and when running the server it says for example :
the file is incorrect
map is missing
and other errors.
I cand remeber the rest of the errors

So all I what to do is:
install MySQL 5.*, and config it
install mangos,and config it
install a SQL database program, and configure it
run the server
and play

I realy DONT care how big the file is, as long as it works 100%, uncept some buggs ingame, well it would be nice to have the game bugg free to, but...

the reason why is I tryed to update the server to a newer state, and i gett to much errors when trying to run the server