ok everyone this is coinside with the FIRST Post <a href='
http://unadvised.net/forum/index.php?showtopic=4745' target='_blank'>ClickMe</a> and iam sorry for it being longer then normal .....but here we Gooooooooo...
8. Makeing a new connection ...
9 Ok lets get started on the New connection first u need to make a account in your new Sql Dbases u have made open up SQL Server Enterprise Manager and then click on Mircosoft Sql Servers / SQL Server Group / (Local)(Windows NT) / Databases ..Once u have this open click on mainlogin then Tables, soon as u click on table it will open up the window to the right and show u all the tables now left click on the ACCOUNT_T then right click it goto OPEN Tables / return all rows.. a window will open and this is where u need to add in your account info which ill give example below - the password..
Account[cAccountID] XXXXX[cPasswd] 1001[iAccountID] <NULL>[cLoginIpAddress] <NULL>[IsGMAccount] <NULL>[CreatDate] <NULL>[LoginDate] <NULL>[LogoutDate] <NULL>[BlockDate] CDWriter[cRealName] <NULL>[SSN]
me@home.com[cEmail] <NULL>[cCharRecord] <NULL>[cQuiz] <NULL>[cAnswer] <SetDateValidatesAccount>[ValidDate] <SetTimeValidatesAccountByTime>[iValidTime] <KEYCODE-?>[cKEYCODE]
I also got it to connect with just cAccountID(Name) , cPasswd(XXXXX), iAccountID(start with 1001-UP) and u need <ValidDate>12/2/3254 Or <iValidTime>1-10000 eather one but u must have 1 of them set..... There is no such thing as a GM account so make sure u change the IsGMAccount and all other accounts u create will be 0 always. Siementech HB changed to this when they made it all SQL so they could give 1 GM char to others with out haveing them make new GM charactors.. now close this and log on to the Server with your 3.51 client ...As soon as u get to your charactor menu create a Charactor like you would normaly, log on and walk around for a few secs, then log off ....Your done and u can make new chars to play ... But hey wait what about a GM account ok lets do this again after u have logged out go back to your SQL Manager now this time open the dbases called ws1 then click on tables right click on CHARACTOR_T table then goto OPEN Tables / return all rows.. a window will open and this is where u will see your new charactor u made and walked around, move it over till u see sAdminLevel change this to a 5 <-- Full GM access a sAdminLevel of 1 will give them access to TP and watch others but this is all ... got GM commands u need to open the HGserver in a hex editor and search for the word "PC CHAT". u will find something like this ..
If u change anything in the hex editor make sure u have a back up so if u make a mistake u still have Orginals...
PC Chat(%s):"%s" to GM(%s) ¿ù ¿ì ¿ö /beginheldenianfight /endheldenian /beginheldenian /endapocalypse /beginapocalypse /getticket /setobservermode (!) GAME SERVER SHUTDOWN PROCESS BEGIN(by Admin-Command)!!! /shutdownthisserverrightnow /deleteparty /getpartyinfo /dismissparty /joinparty /createparty GM Order(%s): endcrusadetotalwar /endcrusadetotalwar GM Order(%s): begincrusadetotalwar /begincrusadetotalwar GM Order(%s): energysphere /energysphere /MonsterCount /enableadmincommand 4415 /enableadmincreateitem 4415 /createitem /disconnectall /summon /setforcerecalltime /setattackmode /gns /setinvi /polymorph /checkip /unsummonboss /unsummonall /summonplayer /summondemon /goto /tp /teleport /createfish /attack /dissmiss /reservefightzone /°Åð /ban /closeconn /ÀÚÀ¯ /free /°ø°Ý /tgt /¸ØÃã /hold /³ª»ÛÆò°¡ /rep- /ÁÁÀºÆò°¡ /rep+ /shutup /ÇÁ·ÎÇʺ¸±â /pf /ÇÁ·ÎÇʼ³Á¤ /setpf /±Ó¼Ó¸» /to /Á¢¼ÓÈ®ÀÎ /fi /who GM Chat
These are your GM commands if u notice in your hex editor some of them have a single space after the command and here is a run down on a few of them ...
Next Post