bullfrog3459 Posted May 31, 2010 Share Posted May 31, 2010 I re-worked a couple of scripts to get what i wanted in the system_tools.aspx page of my tcadmin. It writes out a list of the IP's:Port:Query Port for the game servers. Just two notes for this, if it breaks, im not responsible, i have only tested this on my tcadmin and use it regularly and so far no issues. The other is: <% Dim sConString As String = "DRIVER={MySQL ODBC <Choose 5.1 or 3.51> Driver}; SERVER=<database_location>; " _ & "DATABASE=<database>; UID=<username>; PASSWORD=<database_password>; OPTION=3" %> This needs setup in the system_tools.aspx page, you can use your favorite editor for this. An example would be: <% Dim sConString As String = "DRIVER={MySQL ODBC 5.1 Driver}; SERVER=localhost; " _ & "DATABASE=tcadmin; UID=root; PASSWORD=password; OPTION=3" %> Enjoy! Jeremiah Shinkle P.S. Thanks to the developer of a portion of this script! http://clientforums.tcadmin.com/showpost.php?p=10481&postcount=22 Link to comment Share on other sites More sharing options...
bullfrog3459 Posted May 31, 2010 Author Share Posted May 31, 2010 Here is the system_tools.aspx file i forgot to attach =]system_tools.zip Link to comment Share on other sites More sharing options...
adamnp Posted May 31, 2010 Share Posted May 31, 2010 Very cool :} useful! Thanks! Link to comment Share on other sites More sharing options...
Goran Posted May 31, 2010 Share Posted May 31, 2010 Getting a runtime error? Link to comment Share on other sites More sharing options...
bullfrog3459 Posted May 31, 2010 Author Share Posted May 31, 2010 Getting a runtime error? Did you enter your MySQL information and have the ODBC driver? Thats when i first had problerms with runtime errors before i figured out what i did wrong. Link to comment Share on other sites More sharing options...
Goran Posted May 31, 2010 Share Posted May 31, 2010 Did you enter your MySQL information and have the ODBC driver? Thats when i first had problerms with runtime errors before i figured out what i did wrong. yep entered and have odbc drivers Link to comment Share on other sites More sharing options...
bullfrog3459 Posted May 31, 2010 Author Share Posted May 31, 2010 yep entered and have odbc drivers Hmmmm, couple of things, may be on the silly side, but what OS, and MySQL Version and ODBC Driver are you using? And something stupid, but want to make sure, you didn't leave any of the < or > in the mysql line did you? And its only when selecting the HLSW MultiServer Output correct? Link to comment Share on other sites More sharing options...
Goran Posted May 31, 2010 Share Posted May 31, 2010 Hmmmm, couple of things, may be on the silly side, but what OS, and MySQL Version and ODBC Driver are you using? And something stupid, but want to make sure, you didn't leave any of the < or > in the mysql line did you? And its only when selecting the HLSW MultiServer Output correct? Windows 2008 Web x64 ODBC driver -> 6.0.6002.18005 Mysql 5.1.30-community Thanks for replys. EDIT : solved! Forgot to mention localhost thanks Link to comment Share on other sites More sharing options...
Goran Posted May 31, 2010 Share Posted May 31, 2010 Hm edit again, still not working heres my code: <% Dim sConString As String = "DRIVER={MySQL ODBC 5.1 Driver}; SERVER=localhost; " _ & "DATABASE=tcadmin; UID=root; PASSWORD=xxxxxx; OPTION=3" %> edit : worked with 3.51 driver. thanks Link to comment Share on other sites More sharing options...
bullfrog3459 Posted May 31, 2010 Author Share Posted May 31, 2010 No Problem Goran! Glad it works. Is it something that is useful? Link to comment Share on other sites More sharing options...
Goran Posted May 31, 2010 Share Posted May 31, 2010 No Problem Goran! Glad it works. Is it something that is useful? Very much, maybe an idea: Export server list by dedicated server? So I can create separate lists for every server in HLSW and multi-import them? Link to comment Share on other sites More sharing options...
bullfrog3459 Posted May 31, 2010 Author Share Posted May 31, 2010 I am horrible with ASP.NET and VB (im a php and perl kinda programmer) so i will have to toy around with it and see what i can do =] Link to comment Share on other sites More sharing options...
Goran Posted May 31, 2010 Share Posted May 31, 2010 I am horrible with ASP.NET and VB (im a php and perl kinda programmer) so i will have to toy around with it and see what i can do =] Hehe, I can also write it in PHP, asp.net isn't my field. Link to comment Share on other sites More sharing options...
trancemode Posted May 31, 2010 Share Posted May 31, 2010 Getting runtime error. Did a debug and it shows: ERROR [iM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Anyone seen this before? looks like DSN? Link to comment Share on other sites More sharing options...
bullfrog3459 Posted June 1, 2010 Author Share Posted June 1, 2010 Just by going what it spit out, either A. It cannot find the database you are trying to attach to, or B. it cannot find the version of ODBC you are trying to use. Remember to only choose 3.51 or 5.1. I run mine on 5.1 but i have had this working on 3.51 before we had to update. Let me know if you need any more help. Jeremiah Shinkle Link to comment Share on other sites More sharing options...
bullfrog3459 Posted June 4, 2010 Author Share Posted June 4, 2010 Just a quick update, Luis is so far helping me out some here, im not expecting him to completely write it for me (just give pointers and help me out along the way), but we will see what Luis can do for me =] Link to comment Share on other sites More sharing options...
strikeR- Posted June 4, 2010 Share Posted June 4, 2010 This works with remote db ? Link to comment Share on other sites More sharing options...
Goran Posted June 5, 2010 Share Posted June 5, 2010 This works with remote db ? Yes, instead the "localhost" write the ip. Link to comment Share on other sites More sharing options...
bullfrog3459 Posted June 6, 2010 Author Share Posted June 6, 2010 This works with remote db ? As long as the master server is allowed to connect to the mysql server, then yes it will work. Link to comment Share on other sites More sharing options...
bullfrog3459 Posted June 6, 2010 Author Share Posted June 6, 2010 Goran, I have a little present for you and everyone else! Luis did wonders for my script and actually came up with one that uses the system odbc instead of having to input information to the sql query and it also outputs to all and then you have all of the options for all of your dedicated servers for a breakdown. =]] use away, just remember i am not responsible for if this breaks, but i seriously doubt it will though, since Luis has done wonders to this! change the file name from system_tools_revised.txt to system_tools.aspx when you have a backup of your current file and are ready to upload the new one. Thanks, Jeremiah Shinklesystem_tools_revised.txt Link to comment Share on other sites More sharing options...
dimitrifrom31 Posted June 6, 2010 Share Posted June 6, 2010 nice and useful, was adding them 1by1 but when im away with laptop i can then import them all in 1 clic Link to comment Share on other sites More sharing options...
bullfrog3459 Posted June 6, 2010 Author Share Posted June 6, 2010 nice and useful, was adding them 1by1 but when im away with laptop i can then import them all in 1 clic =) that was my problem, i have 2 laptops with me everywhere i go. Glad you found it useful Dimitri. Link to comment Share on other sites More sharing options...
Goran Posted June 7, 2010 Share Posted June 7, 2010 I think that with last update the system_tools.aspx has been modified , so now I don't have the HLSW multi import. What I would like to know , did the file system_tools.aspx changed in relation to the one you posted? Link to comment Share on other sites More sharing options...
bullfrog3459 Posted June 7, 2010 Author Share Posted June 7, 2010 I think that with last update the system_tools.aspx has been modified , so now I don't have the HLSW multi import. What I would like to know , did the file system_tools.aspx changed in relation to the one you posted? yes to the one that i posted was the original but only modified enough to make hlsw msi to work, with the new one and Luis's coding he rewrote several parts of it to make it do what it does now. Its still all the same basic stuff, the only thing was added was a few more if/then/else's and a little rewrite of how the system_tools.aspx displays out in the drop down menu, and the mysql query changed just a little bit as it has 2 now, but depends on which the if/else calls it passes, but no harm is being done with this, as it uses the ODBC connection instead of having to import the connection settings. Let me know if you need more detail, you can hit me up via email or msn messenger. Link to comment Share on other sites More sharing options...
dimitrifrom31 Posted June 7, 2010 Share Posted June 7, 2010 tell luis to include in next update thats gona be easier Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.