Quick Help

[dean8880]

Sorry guys i had this set up last year cant remember how to redo it. Anyways i got uo gateway, etc, etc, all the steps i downloaded runuo and unzipped it to my c drive, but when i launch it i just get this error, i dont remember much but it is to have my user name and stuff, where and how do i put this in so runuo will work??

[-Nox-]

Post the script. It is looking for a file in the Data folder that doesn't exist.

[dean8880]

Do you think it did not unzipp runuo properly??
How do i post the script??

[-Nox-]

Open the script in a text editer, the hit Ctrl + A, then Ctrl + C, then, in the post message box, hit Ctrl + V. Then highlight everything, and press the Pound button at the top of the advanced poster.

-Nox

[TMSTKSBK]

it's saying that it can't locate the ODBC database type in the .NET Framework's Data namespace...

[dean8880]

Originally Posted by TMSTKSBK

it's saying that it can't locate the ODBC database type in the .NET Framework's Data namespace...

Ah so what that means is maybe redownload the .net framework??

[dean8880]

Originally Posted by -Nox-

Open the script in a text editer, the hit Ctrl + A, then Ctrl + C, then, in the post message box, hit Ctrl + V. Then highlight everything, and press the Pound button at the top of the advanced poster.

-Nox

You must excuse my misunderstanding, i do very much appricate the help. Ok when you say open the script, do you mean the script in the dos menu or the script from the file located in the runuo folder. sorry for my lack of understanding on that.

[TMSTKSBK]

in the runuo folder.

[dean8880]

PHP Code:

[quote=TMSTKSBK]in the runuo folder.[/quote]


using System;
using System.Threading;
using System.Collections;
using System.Data;
using System.Data.Odbc;

namespace Server.Engines.MyRunUO
{
    public class DatabaseCommandQueue
    {
        private Queue m_Queue;
        private ManualResetEvent m_Sync;
        private Thread m_Thread;

        private bool m_HasCompleted;

        private string m_CompletionString;
        private string m_ConnectionString;

        public bool HasCompleted
        {
            get{ return m_HasCompleted; }
        }

        public void Enqueue( object obj )
        {
            lock ( m_Queue.SyncRoot )
            {
                m_Queue.Enqueue( obj );
                try{ m_Sync.Set(); }
                catch{}
            }
        }

        public DatabaseCommandQueue( string completionString, string threadName ) : this( Config.CompileConnectionString(), completionString, threadName )
        {
        }

        public DatabaseCommandQueue( string connectionString, string completionString, string threadName )
        {
            m_CompletionString = completionString;
            m_ConnectionString = connectionString;

            m_Queue = Queue.Synchronized( new Queue() );

            m_Queue.Enqueue( null ); // signal connect

            /*m_Queue.Enqueue( "DELETE FROM myrunuo_characters" );
            m_Queue.Enqueue( "DELETE FROM myrunuo_characters_layers" );
            m_Queue.Enqueue( "DELETE FROM myrunuo_characters_skills" );
            m_Queue.Enqueue( "DELETE FROM myrunuo_guilds" );
            m_Queue.Enqueue( "DELETE FROM myrunuo_guilds_wars" );*/

            m_Sync = new ManualResetEvent( true );

            m_Thread = new Thread( new ThreadStart( Thread_Start ) );
            m_Thread.Name = threadName;//"MyRunUO Database Command Queue";
            m_Thread.Priority = Config.DatabaseThreadPriority;
            m_Thread.Start();
        }

        private void Thread_Start()
        {
            bool connected = false;

            OdbcConnection connection = null;
            OdbcCommand command = null;
            OdbcTransaction transact = null;

            DateTime start = DateTime.Now;

            bool shouldWriteException = true;

            while ( true )
            {
                m_Sync.WaitOne();

                while ( m_Queue.Count > 0 )
                {
                    try
                    {
                        object obj = m_Queue.Dequeue();

                        if ( obj == null )
                        {
                            if ( connected )
                            {
                                if ( transact != null )
                                {
                                    try{ transact.Commit(); }
                                    catch ( Exception commitException )
                                    {
                                        Console.WriteLine( "MyRunUO: Exception caught when committing transaction" );
                                        Console.WriteLine( commitException );

                                        try
                                        {
                                            transact.Rollback();
                                            Console.WriteLine( "MyRunUO: Transaction has been rolled back" );
                                        }
                                        catch ( Exception rollbackException )
                                        {
                                            Console.WriteLine( "MyRunUO: Exception caught when rolling back transaction" );
                                            Console.WriteLine( rollbackException );
                                        }
                                    }
                                }

                                try{ connection.Close(); }
                                catch{}

                                try{ connection.Dispose(); }
                                catch{}

                                try{ command.Dispose(); }
                                catch{}

                                try{ m_Sync.Close(); }
                                catch{}

                                Console.WriteLine( m_CompletionString, (DateTime.Now - start).TotalSeconds );
                                m_HasCompleted = true;

                                return;
                            }
                            else
                            {
                                try
                                {
                                    connected = true;
                                    connection = new OdbcConnection( m_ConnectionString );
                                    connection.Open();
                                    command = connection.CreateCommand();

                                    if ( Config.UseTransactions )
                                    {
                                        transact = connection.BeginTransaction();
                                        command.Transaction = transact;
                                    }
                                }
                                catch ( Exception e )
                                {
                                    try{ if ( transact != null ) transact.Rollback(); }
                                    catch{}

                                    try{ if ( connection != null ) connection.Close(); }
                                    catch{}

                                    try{ if ( connection != null ) connection.Dispose(); }
                                    catch{}

                                    try{ if ( command != null ) command.Dispose(); }
                                    catch{}

                                    try{ m_Sync.Close(); }
                                    catch{}

                                    Console.WriteLine( "MyRunUO: Unable to connect to the database" );
                                    Console.WriteLine( e );
                                    m_HasCompleted = true;
                                    return;
                                }
                            }
                        }
                        else if ( obj is string )
                        {
                            command.CommandText = (string)obj;
                            command.ExecuteNonQuery();
                        }
                        else
                        {
                            string[] parms = (string[])obj;

                            command.CommandText = parms[0];

                            if ( command.ExecuteScalar() == null )
                            {
                                command.CommandText = parms[1];
                                command.ExecuteNonQuery();
                            }
                        }
                    }
                    catch ( Exception e )
                    {
                        if ( shouldWriteException )
                        {
                            Console.WriteLine( "MyRunUO: Exception caught in database thread" );
                            Console.WriteLine( e );
                            shouldWriteException = false;
                        }
                    }
                }

                lock ( m_Queue.SyncRoot )
                {
                    if ( m_Queue.Count == 0 )
                        m_Sync.Reset();
                }
            }
        }
    }
} 


[dean8880]

Guess ill reinstall runuo and the .net framework. I cant think of anything else

[slithers]

check your other thread but basically the problem appears to be that you only dled and installed the .net sdk and not the framework. the sdk is the software developer's kit and basically expands upon the framework in areas for programming and such, but doesn't itself provide the full basic functionality of the framework ( in lamens terms ). you can leave the sdk installed and add in the framework or remove it and just install the framework if hd space is an issue. if you cant find the 1.1 framework redistributable, it used to appear in the windows update page.