Garbaek

a cool util for linux is http://expect.nist.gov (works great with telnet/bash and such) that's also worth having a look at I think

Yeah, I tied that site, did not work, only with localhost as hostname on server1.. with server2 as hostname, it fails, even tho right's and database names are the same on both servers.. (did that to make it easy on myself) I really do not comprehend what's wrong.

For some reason I cant get this to work.. I have a webserver in germany, called server1 and a game/mysql server in denmark called server2 I have the reggacc website on server1 one, and my databases on server2.. I have a user on server2 called user1 has access to mang_realmd mang_chars and mang_world databases on server2.. but I cant connect from http://server1/reggacc/index.php I get this error Error: Unable to connect to MySQL server. MySQL reported: Lost connection to MySQL server during query. Update your >>> ReggAcc configuration <<< Check configuration file - hosts, usernames and passwords. I have tried everything in the configuration.php $realmName="Realm1"; $rid="1"; $host="ip.ip.ip.ip : port"; and $host="ip.ip.ip.ip"; also $host="hostname.server2"; and $host="hostname.server2 : port"; nothing works.. and I'm sure I got username and password and remote rights 100% correct. When I try to run everything on server1. it works perfectly, so I think your script is not allowing remote connections to the databases, or is it me? Thanks in advance.

How did you solve it? I would have used "Replace into"

You can also add color codes to the messages |cff7777cd = Bluish-purple |cff32cd32 = Green |cff7777aa = Light Blue |cffcd32cd = Pink |cffffcc00 = Yellow |cffff0000 = Red |cff995500 = Orange |cff00ffff = Lightblue |cffffcc00 = Gold |c000000ff = Green |c0000ad00 = Blue |cff000000 = Black |cffffffff = White Ie message1="|cffffcc00 Hello world!"

I do not take credit for this, It was on the old mangos forums waaaaay back, and I just stumpled upon the files on my server. Thought I wanted to share. Note, this only works for linux, cause its using bash scripts. First make sure you have the correct settings in mangos.conf (all the way in the bottom) Ra.Enable = 1 Ra.IP = 127.0.0.1 Ra.Port = 3443 Ra.MinLevel = 3 (what gm levels that are allowed to connect to the telnet realm server Ra.Secure = 1 Then you need to make 3 files messages.sh starttelnet.sh telnet.sh And they should look something like this messages.sh #!/bin/sh /home/user/adscript/telnet.sh | /home/user/adscript/starttelnet.sh echo Done starttelnet.sh #!/bin/sh telnet -e X telnet.sh #!/bin/sh host=127.0.0.1 #server hostname or IP address port=3443 login="USER account" #RA console commands for login user passwd="PASS password" #and the password message1="This is the first message" message2="This is the second message" message3="This is the third message" mess=$[ ( $RANDOM % 3 ) + 1 ] # replace "3" with real number of your messages echo open $host $port sleep 1 echo $login sleep 1 echo $passwd sleep 1 case $mess in 1) echo "announce $message1"; ;; 2) echo "announce $message2"; ;; 3) echo "announce $message3"; ;; # and so on.. esac sleep 1 echo X sleep 1 echo quit Then all you need to do, is add the script to crontab, if you want it to run automaticly every xx minutes type crontab -e to get your crontab, and insert this line in the bottom. */15 * * * * /home/user/adscript/messages.sh > /dev/null 2>&1 and your done.. you can naturally test the script by typing ./home/user/adscript/messages.sh in shell have fun with it..

almost 200 views and no comments if this worked for others or not.. Gief comments!

Thanks for the input! and yeah I knew that what you clone becomes your own branch, I just had problems fiding a good guide on checking out older revisions, like right now, the 7050 rev, is broken, you cant do "make install" in linux without errors, so I needed to grab a older "working" tree, and there was no real help for this.. Hence the reason I made this guide. I hope others will benefit from this.

After searching the forums, I gave up and went to #git and asked the experts and I found out how to pull old revisions of mangos.. First you'll need to do git clone git://github.com/mangos/mangos.git cd mangos git checkout -b yourbranchname 519bc25a215e095b573dafc62eb496e908cdae59 (Because we want http://github.com/mangos/mangos/commit/1d52f36ced501c8e284db7860470c73de85df9bf) Then you can do git show should show something like this splashgame@siara:~/mangos$ git show commit [b]519bc25a215e095b573dafc62eb496e908cdae59[/b] Author: ApoC <[email protected]> Date: Wed Jan 7 04:21:09 2009 +0100 [7042] Forget to add revision number. Signed-off-by: ApoC <[email protected]> diff --git a/src/shared/revision_nr.h b/src/shared/revision_nr.h index 05ad9af..1c80b3c 100644 --- a/src/shared/revision_nr.h +++ b/src/shared/revision_nr.h @@ -1,4 +1,4 @@ #ifndef __REVISION_NR_H__ #define __REVISION_NR_H__ - #define REVISION_NR "7041" + #define REVISION_NR "7042" #endif // __REVISION_NR_H__ Now you can start to apply patches, compile and make your custom branch. Cheers Garbaek

Great tutorial.! Worked perfectly first time! Thanks!