ProjectX V3.2 Source

[alismeckeru]

Why is not working any NPC in this source?
And how can I activate Fan and Tower?

[cloudwind360]

Wat are the features in this source? Umm is this pvp or lvling"?

[Ahmed~zero]

Thankes Good Sourse

[turk55]

Originally Posted by cloudwind360

Wat are the features in this source? Umm is this pvp or lvling"?

Making it PVP or leveling is up to you, most of the base functionalities are working like jumping, talking etc. There are a few extras like duel bots and guild + wars that are inside or released.

[FinishHim]

When i open Sql Server Management studio what is my Name server and .. ? i am blocked here

[EOS 60D]

Originally Posted by cloudwind360

Wat are the features in this source? Umm is this pvp or lvling"?

Look around and explore..

[Yupmoh]

The most important thing about this source is that it's very organized and it would make an excellent reference.

[MusicGod]

Originally Posted by Super Aids

This is not the total up to date source, but a minor older version, but it's very close to the original project. There is some features stripped and removed.
I'm not going to help with any issues that you got if you do not want to put any effort into it yourself.

This is a much newer version than the previous released version of ProjectX V3.

It uses MSSQL for almost everything, however this version does not use mssql for the items/equips, it was before I made that. The tables for it have been added in the database so you could go ahead and do it yourself.

I hope this project will be useful to some.

A lot of credits goes to pro4never and the Albetros source.

Client patch: 5515+ (Was developed at 5517)

Download: (Contains the source + database)


FAQ

 Spoiler

What is ProjectX?
It was a server that me, Psychodelic and Sedat was working on, but eventually has quit as of now. I might release a few things for the source, but do not expect anything, but the released source. The released source is not the full version or the up to date, but an older backup that I fixed up a bit before releasing.

What patch does the source work at?
5515+ (Was developed at 5517 and might work at patches like 5500+ and up to like 5550?)

How do I install the server?
Look the installation guide.

How can I get a client?
Look here:


Some features are not working, how can I get them to work?
You would need to code them. This is not a plug n' play server.

How can I remove/edit the AI Bots sitting around the server?
Open the game database and then DB_BotInfo. Delete all the entries.

How can I edit the gear AI bots sitting around the server uses?
Open the game database and then DB_Bots.

How can I add/edit npcs?
Go to CODB\game\NPCScripts. There is already examples added.

Some items does not work, how can I add them?
Go to CODB\game\ItemScripts. The concept is the same as npc scripts.

How can I make myself GM?
Open DB_Players and edit the PlayerPermission column.
Permissions are:
PM
GM
Mod
Normal
Banned

How can I edit NPC spawns or names?
Open DB_NPCInfo in the game database.

How can I load NPC's dynamic so I won't need to compile all the times?
You could either make some thread check whether the files has changed or you can make a command to load them. All you have to do is call this method:

Core.Kernel.ScriptEngine.Check_Updates();

My client crashes on login, what can I do?
Make sure you're not connecting using a local IP. It has to be an external IP or hamachi IP.

Fixes / Optimizations

 Spoiler

Fix attack experiences

 Spoiler

This is quite some work, but it's necessary to make Sobs work at least! So if you plan on using Sobs (Ex. GuildPole, LeftGate, RightGate etc.) then you need to do it.

Under ProjectX_V3_Game\Packets\Interaction\Battle you have to change something in these files:

ProjectX_V3_Game\Packets\Interaction\Battle\Skills\ArcherSkills.cs
ProjectX_V3_Game\Packets\Interaction\Battle\Skills\CircleSkills.cs
ProjectX_V3_Game\Packets\Interaction\Battle\Skills\LineSkills.cs
ProjectX_V3_Game\Packets\Interaction\Battle\Skills\NinjaSkills.cs
ProjectX_V3_Game\Packets\Interaction\Battle\Skills\ScatterSkills.cs
ProjectX_V3_Game\Packets\Interaction\Battle\Skills\SectorSkills.cs
ProjectX_V3_Game\Packets\Interaction\Battle\Skills\Single.cs
ProjectX_V3_Game\Packets\Interaction\Battle\Physical.cs
ProjectX_V3_Game\Packets\Interaction\Battle\Ranged.cs

You have to find a line similar to this:

if (!(targetentity is Entities.GameClient))

Which wraps around some exp. It's named target and targetentity depending on the file.
Make sure you only change it where it wraps around exp code like the one below.

You have to change that one line to:

if ((targetentity is Entities.Monster))

>> Repeat that process for all the files until only monsters add experience.

Fix NPC scripts

 Spoiler

After stripping some things away from the source then NPC scripts has broken.
To fix this follow these steps.

1. Open CODB\NPCScripts\DuelMaster.cs

2. Find:

bot.LoadBot(ProjectX_V3_Game.Enums.BotType.DuelBot, client.Server, 0,
				            new MapPoint(client.Map.MapID, client.X, client.Y),
				            client);

3. Change it to:

bot.LoadBot(ProjectX_V3_Game.Enums.BotType.DuelBot, 0,
				            new MapPoint(client.Map.MapID, client.X, client.Y),
				            client);

Optimized Script Engine (Uses FileSystemWatcher for updating.)

 Spoiler

1. Replace ScriptEngine.cs in ProjectX_V3_Lib with this:

//Project by BaussHacker aka. L33TS

using System;
using System.Text;
using System.Linq;
using Microsoft.CSharp;
using System.Reflection;
using System.CodeDom.Compiler;
using Microsoft.VisualBasic;
using System.Collections.Generic;
using System.IO;
using System.Security.Permissions;

namespace ProjectX_V3_Lib.ScriptEngine
{
	/// <summary>
	/// Description of ScriptEngine.
	/// </summary>
	public class ScriptEngine
	{
		/// <summary>
		/// The settings associated with the script engine.
		/// </summary>
		private ScriptSettings Settings;
		
		/// <summary>
		/// The interval between each script update.
		/// </summary>
		private int checkInterval;
		
		/// <summary>
		/// Creates a new instance of ScriptEngine.
		/// </summary>
		/// <param name="Settings">The settings associated to the script engine.</param>
		/// <param name="scriptcheckinterval">The interval between each script update.</param>
		public ScriptEngine(ScriptSettings Settings, int scriptcheckinterval)
		{
			this.checkInterval = scriptcheckinterval;
			this.Settings = Settings;
			scriptCollection = new ScriptCollection(Settings);
		}
		
		public static void SetNamespaces(ScriptSettings settings)
		{
			Content = Content.Replace("__namespace__", getns(settings));
			Content2 = Content2.Replace("__namespace__", getns2(settings));
		}
		
		[PermissionSet(SecurityAction.Demand, Name="FullTrust")]
		public void Run()
		{
			UpdateScripts();
			
			FileSystemWatcher watcher = new FileSystemWatcher();
			watcher.Path = this.Settings.ScriptLocation;
			watcher.Filter = "*.cs";
			watcher.NotifyFilter = NotifyFilters.LastAccess | NotifyFilters.LastWrite
           | NotifyFilters.FileName;
			
			watcher.Changed += new FileSystemEventHandler(OnChanged);
			watcher.Created += new FileSystemEventHandler(OnChanged);
			watcher.Deleted += new FileSystemEventHandler(OnChanged);
			watcher.Renamed += new RenamedEventHandler(OnRenamed);
			
			watcher.EnableRaisingEvents = true;
		}
		
		private void OnChanged(object source, FileSystemEventArgs e)
		{
			UpdateScripts();
		}

		private void OnRenamed(object source, RenamedEventArgs e)
		{
			UpdateScripts();
		}
		
		/// <summary>
		/// The c# code content.
		/// </summary>
		private static string Content = @"__namespace__

namespace scriptnamespace
{
	class scriptclass
	{
		__method__
	}
}";
		
		/// <summary>
		/// The vb code content.
		/// </summary>
		private static string Content2 = @"__namespace__

Namespace scriptnamespace
	Class scriptclass
	
		__method__
		
	End Class
End Namespace";
		
		/// <summary>
		/// Gets the namespace code for c#.
		/// </summary>
		/// <returns>Returns the namespace code.</returns>
		private static string getns(ScriptSettings Settings)
		{
			StringBuilder namespaceBuilder = new StringBuilder();
			foreach (string _namespace in Settings._namespaces.Values)
			{
				namespaceBuilder.Append("using ").Append(_namespace).Append(";").Append(Environment.NewLine);
			}
			return namespaceBuilder.ToString();
		}
		
		/// <summary>
		/// Gets the namespace code for vb.
		/// </summary>
		/// <returns>Returns the namespace code.</returns>
		private static string getns2(ScriptSettings Settings)
		{
			StringBuilder namespaceBuilder = new StringBuilder();
			foreach (string _namespace in Settings._namespaces.Values)
			{
				namespaceBuilder.Append("Imports ").Append(_namespace).Append(Environment.NewLine);
			}
			return namespaceBuilder.ToString();
		}
		
		private string currentcompilefile;
		
		/// <summary>
		/// Checks for updates.
		/// </summary>
		private void UpdateScripts()
		{
			try
			{
				foreach (string file in System.IO.Directory.GetFiles(Settings.ScriptLocation + "\\cmpl"))
				{
					try
					{
						System.IO.File.Delete(file);
					}
					catch { } // no permission
				}
				
				DateTime now = DateTime.Now;
				currentcompilefile = "\\cmpl\\cmpl_" + now.Month + "-" + now.Day + "-" + now.Hour + "-" + now.Minute + "-" + now.Second;
				
				switch (Settings.Language)
				{
					case ScriptLanguage.CSharp:
						{
							StringBuilder scriptBuilder = new StringBuilder();
							foreach (string file in System.IO.Directory.GetFiles(Settings.ScriptLocation))
							{
								if (file.EndsWith(".cs"))
								{
									scriptBuilder.Append(System.IO.File.ReadAllText(file));
									scriptBuilder.Append(Environment.NewLine);
								}
							}
							System.IO.File.WriteAllText(Settings.ScriptLocation + currentcompilefile + ".cs", Content.Replace("__method__", scriptBuilder.ToString()));
							CompileCSScripts();
							break;
						}
					case ScriptLanguage.VisualBasic:
						{
							StringBuilder scriptBuilder = new StringBuilder();
							foreach (string file in System.IO.Directory.GetFiles(Settings.ScriptLocation))
							{
								if (file.EndsWith(".vb"))
								{
									scriptBuilder.Append(System.IO.File.ReadAllText(file));
									scriptBuilder.Append(Environment.NewLine);
								}
							}
							System.IO.File.WriteAllText(Settings.ScriptLocation + currentcompilefile + ".vb", Content2.Replace("__method__", scriptBuilder.ToString()));
							CompileCSScripts();
							break;
						}
				}
			}
			catch (Exception e)
			{
				Console.WriteLine("Script loading failed... Exception: {0}{1}", Environment.NewLine, e.ToString());
			}
		}
		
		/// <summary>
		/// Compiles all the c# scripts.
		/// </summary>
		private void CompileCSScripts()
		{
			Dictionary<string, string> dictionary = new Dictionary<string, string>();
			dictionary.Add("CompilerVersion", Settings.Framework);
			CompilerParameters compilerParameters = new CompilerParameters
			{
				GenerateInMemory = true
			};
			
			Assembly[] assemblies = AppDomain.CurrentDomain.GetAssemblies();
			for (int i = 0; i < assemblies.Length; i++)
			{
				Assembly assembly = assemblies[i];
				compilerParameters.ReferencedAssemblies.Add(assembly.Location);
			}
			foreach (string refs in System.IO.Directory.GetFiles(Settings.ScriptLocation + "\\references"))
				compilerParameters.ReferencedAssemblies.Add(refs);
			foreach (Type type in Settings.types.Values)
				compilerParameters.ReferencedAssemblies.Add(Assembly.GetAssembly(type).Location);
			CSharpCodeProvider cSharpCodeProvider = new CSharpCodeProvider();
			CompilerResults compilerResults = cSharpCodeProvider.CompileAssemblyFromFile(compilerParameters, Settings.ScriptLocation + currentcompilefile + ".cs");
			if (compilerResults.Errors.Count != 0)
			{
				foreach (CompilerError err in compilerResults.Errors)
					Console.WriteLine(err.ToString());
			}
			else
			{
				foreach (Type type in compilerResults.CompiledAssembly.GetTypes())
				{
					if (type.Namespace == "scriptnamespace" && type.IsClass && type.Name == "scriptclass")
					{
						foreach (MethodInfo method in type.GetMethods())
						{
							if (method.IsStatic)
							{
								if (method.Name.StartsWith("script_"))
									scriptCollection.AddOrUpdate(uint.Parse(method.Name.Split('_')[1]), method);
							}
						}
					}
				}
			}
		}
		
		/// <summary>
		/// Compiles all the vb scripts.
		/// </summary>
		private void CompileVBScripts()
		{
			Dictionary<string, string> dictionary = new Dictionary<string, string>();
			dictionary.Add("CompilerVersion", Settings.Framework);
			CompilerParameters compilerParameters = new CompilerParameters
			{
				GenerateInMemory = true
			};
			
			Assembly[] assemblies = AppDomain.CurrentDomain.GetAssemblies();
			for (int i = 0; i < assemblies.Length; i++)
			{
				Assembly assembly = assemblies[i];
				compilerParameters.ReferencedAssemblies.Add(assembly.Location);
			}
			foreach (string refs in System.IO.Directory.GetFiles(Settings.ScriptLocation + "\\references"))
				compilerParameters.ReferencedAssemblies.Add(refs);
			foreach (Type type in Settings.types.Values)
				compilerParameters.ReferencedAssemblies.Add(Assembly.GetAssembly(type).Location);
			VBCodeProvider vbCodeProvider = new VBCodeProvider();
			CompilerResults compilerResults = vbCodeProvider.CompileAssemblyFromFile(compilerParameters, Settings.ScriptLocation + currentcompilefile + ".vb");
			if (compilerResults.Errors.Count != 0)
			{
				foreach (CompilerError err in compilerResults.Errors)
					Console.WriteLine(err.ToString());
			}
			else
			{
				foreach (Type type in compilerResults.CompiledAssembly.GetTypes())
				{
					if (type.Namespace == "scriptnamespace" && type.IsClass && type.Name == "scriptclass")
					{
						foreach (MethodInfo method in type.GetMethods())
						{
							if (method.IsStatic)
							{
								if (method.Name.StartsWith("script_"))
									scriptCollection.AddOrUpdate(uint.Parse(method.Name.Split('_')[1]), method);
							}
						}
					}
				}
			}
		}
		
		/// <summary>
		/// The collection of the scripts.
		/// </summary>
		private ScriptCollection scriptCollection;
		
		/// <summary>
		/// Invokes a script.
		/// </summary>
		/// <param name="key">The script key.</param>
		/// <param name="paramters">Parameters associated with the script. [null, if no parameters]</param>
		/// <returns>Returns true if the script exist.</returns>
		public bool Invoke(uint key, object[] paramters)
		{
			return scriptCollection.Invoke(key, paramters);
		}
	}
}

Replace ScriptDatabase.cs in ProjectX_V3_Game with this:

//Project by BaussHacker aka. L33TS

using System;
using ProjectX_V3_Lib.ScriptEngine;
using ProjectX_V3_Lib.Extensions;
using System.Linq;
using System.Reflection;

namespace ProjectX_V3_Game.Database
{
	/// <summary>
	/// Description of ScriptDatabase.
	/// </summary>
	public class ScriptDatabase
	{
		private static Type[] GetTypesInNamespace(Assembly assembly, string nameSpace)
		{
			return assembly.GetTypes().Where(t => String.Equals(t.Namespace, nameSpace, StringComparison.Ordinal)).ToArray();
		}
		
		public static ScriptSettings cssettings;
		
		/// <summary>
		/// Loads the global script settings.
		/// </summary>
		public static void LoadSettings()
		{
			Console.ForegroundColor = ConsoleColor.Yellow;
			Console.WriteLine("\tLoading Script Settings...");
			
			cssettings = new ScriptSettings();
			cssettings.AddNamespace("System");
			cssettings.AddNamespace("ProjectX_V3_Game.Entities");
			cssettings.AddNamespace("ProjectX_V3_Game.Core");
			cssettings.AddNamespace("ProjectX_V3_Game.Data");
			cssettings.AddNamespace("ProjectX_V3_Game.Calculations");
			cssettings.AddNamespace("ProjectX_V3_Game.Packets.Message");
			cssettings.AddNamespace("ProjectX_V3_Game.Packets");
			cssettings.AddNamespace("ProjectX_V3_Game.Maps");
			cssettings.AddNamespace("ProjectX_V3_Game.Tournaments");
			cssettings.AddNamespace("ProjectX_V3_Game.Packets.NPC"); // will add some functions to this later, not entirely npc restricted, but mostly hence why it's also used by ItemScripts!
			ScriptEngine.SetNamespaces(cssettings);
			
			cssettings.Framework = "v4.0";
			cssettings.Language = ScriptLanguage.CSharp;
			
			Console.ForegroundColor = ConsoleColor.Green;
			Console.WriteLine("\tLoaded Script Settings...");
		}
		
		/// <summary>
		/// Loads all the npc scripts.
		/// </summary>
		public static void LoadNPCScripts()
		{
			Console.ForegroundColor = ConsoleColor.Yellow;
			Console.WriteLine("\tLoading NPC Scripts...");
			
			ScriptSettings x = ScriptDatabase.cssettings.DeepClone();
			
			x.ScriptLocation = ServerDatabase.DatabaseLocation + "\\NPCScripts";
			x.AddScriptType(typeof(Packets.MessagePacket));
			x.AddScriptType(typeof(Packets.Message.MessageCore));
			x.AddScriptType(typeof(Packets.NPC.NPCHandler));
			x.AddScriptType(typeof(Data.ItemInfo));
			x.AddScriptType(typeof(Data.Equipments));
			x.AddScriptType(typeof(Data.SpellInfo));
			x.AddScriptType(typeof(Data.Spell));
			x.AddScriptType(typeof(Data.SpellData));
			x.AddScriptType(typeof(Data.Team));
			x.AddScriptType(typeof(Data.NobilityBoard));
			x.AddScriptType(typeof(Data.NobilityDonation));
			x.AddScriptType(typeof(Maps.Map));
			x.AddScriptType(typeof(Maps.MapPoint));
			x.AddScriptType(typeof(Maps.MapTools));
			x.AddScriptType(typeof(Core.Kernel));
			x.AddScriptType(typeof(Data.Guild));
			x.AddScriptType(typeof(Data.GuildMember));
			x.AddScriptType(typeof(Database.CharacterDatabase));
			x.AddScriptType(typeof(Calculations.BasicCalculations));

			Type[] typelist = GetTypesInNamespace(System.Reflection.Assembly.GetExecutingAssembly(), "ProjectX_V3_Game.Enums");
			foreach (Type type in typelist)
				x.AddScriptType(type);
			
			Type[] typelist2 = GetTypesInNamespace(System.Reflection.Assembly.GetExecutingAssembly(), "ProjectX_V3_Game.Tournaments");
			foreach (Type type in typelist2)
				x.AddScriptType(type);
			
			Type[] typelist3 = GetTypesInNamespace(System.Reflection.Assembly.GetExecutingAssembly(), "ProjectX_V3_Game.Entities");
			foreach (Type type in typelist3)
				x.AddScriptType(type);
			
			Core.Kernel.ScriptEngine = new ScriptEngine(x, Core.TimeIntervals.ScriptUpdate); // scripts updates every 10 sec.
			Core.Kernel.ScriptEngine.Run();
			
			Console.ForegroundColor = ConsoleColor.Green;
			Console.WriteLine("\tLoaded NPC Scripts...");
		}
		
		/// <summary>
		/// Loads all the item scripts.
		/// </summary>
		public static void LoadItemScripts()
		{
			Console.ForegroundColor = ConsoleColor.Yellow;
			Console.WriteLine("\tLoading Item Scripts...");
			
			ScriptSettings x = ScriptDatabase.cssettings.DeepClone();
			x.ScriptLocation = ServerDatabase.DatabaseLocation + "\\ItemScripts";
			x.AddScriptType(typeof(Packets.MessagePacket));
			x.AddScriptType(typeof(Packets.Message.MessageCore));
			x.AddScriptType(typeof(Packets.NPC.NPCHandler));
			x.AddScriptType(typeof(Data.ItemInfo));
			x.AddScriptType(typeof(Data.Equipments));
			x.AddScriptType(typeof(Data.SpellInfo));
			x.AddScriptType(typeof(Data.Spell));
			x.AddScriptType(typeof(Data.SpellData));
			x.AddScriptType(typeof(Data.Team));
			x.AddScriptType(typeof(Data.NobilityBoard));
			x.AddScriptType(typeof(Data.NobilityDonation));
			x.AddScriptType(typeof(Maps.Map));
			x.AddScriptType(typeof(Maps.MapPoint));
			x.AddScriptType(typeof(Maps.MapTools));
			x.AddScriptType(typeof(Core.Kernel));
			x.AddScriptType(typeof(Data.Guild));
			x.AddScriptType(typeof(Data.GuildMember));
			x.AddScriptType(typeof(Database.CharacterDatabase));
			x.AddScriptType(typeof(Calculations.BasicCalculations));
			
			Type[] typelist = GetTypesInNamespace(System.Reflection.Assembly.GetExecutingAssembly(), "ProjectX_V3_Game.Enums");
			foreach (Type type in typelist)
				x.AddScriptType(type);
			
			Type[] typelist2 = GetTypesInNamespace(System.Reflection.Assembly.GetExecutingAssembly(), "ProjectX_V3_Game.Tournaments");
			foreach (Type type in typelist2)
				x.AddScriptType(type);
			
			Type[] typelist3 = GetTypesInNamespace(System.Reflection.Assembly.GetExecutingAssembly(), "ProjectX_V3_Game.Entities");
			foreach (Type type in typelist3)
				x.AddScriptType(type);
			
			Core.Kernel.ItemScriptEngine = new ScriptEngine(x, Core.TimeIntervals.ScriptUpdate); // scripts updates every 10 sec.
			Core.Kernel.ItemScriptEngine.Run();
			
			Console.ForegroundColor = ConsoleColor.Green;
			Console.WriteLine("\tLoaded Item Scripts...");
		}
	}
}

Fixing ArtisanWind

 Spoiler

Replace all the code in ProjectX_V3_Game.Packets.Item.Improve.cs with this:

//Project by BaussHacker aka. L33TS

using System;

namespace ProjectX_V3_Game.Packets.Item
{
	/// <summary>
	/// Description of Uplev.
	/// </summary>
	public class Uplev
	{
		public static void Handle(Entities.GameClient client, ItemPacket packet)
		{
			if (client.Booth != null)
				return;
			if (!client.Alive)
				return;
			
			if (!client.Inventory.ContainsByUID(packet.UID) && client.Inventory.ContainsByUID(packet.Data1))
			{
				using (var msg = Packets.Message.MessageCore.CreateSystem(client.Name, Core.MessageConst.ITEM_NOT_FOUND))
					client.Send(msg);
				return;
			}
			
			Data.ItemInfo ToUpgrade = client.Inventory.GetItemByUID(packet.UID);
			if (ToUpgrade.CurrentDura < ToUpgrade.MaxDura)
				return;
			
			Data.ItemInfo Meteor = client.Inventory.GetItemByUID(packet.Data1);
			if (Meteor == null || ToUpgrade == null)
			{
				using (var msg = Packets.Message.MessageCore.CreateSystem(client.Name, Core.MessageConst.ITEM_NOT_FOUND))
					client.Send(msg);
				return;
			}
			if (ToUpgrade.IsGarment() || ToUpgrade.IsArrow() || ToUpgrade.IsBottle() ||
			    ToUpgrade.IsSteed() || ToUpgrade.IsMisc())
			{
				using (var msg = Packets.Message.MessageCore.CreateSystem(client.Name, Core.MessageConst.ITEM_INVALID_UPGRADE))
					client.Send(msg);
				return;
			}
			if (ToUpgrade.RequiredLevel >= 120)
			{
				using (var msg = Packets.Message.MessageCore.CreateSystem(client.Name, Core.MessageConst.ITEM_MAX_LEVEL))
					client.Send(msg);
				return; // max level
			}
			if (Meteor.ItemID != 1088001 && Meteor.ItemID != 1088002)
			{
				using (var msg = Packets.Message.MessageCore.CreateSystem(
					client.Name,
					string.Format(Core.MessageConst.ITEM_AMOUNT_FAIL, "Meteor- or Meteortear's")))
					client.Send(msg);
				return;
			}

			uint NewID = ToUpgrade.ItemID + 10;
			int loop = 4;
			while (!Core.Kernel.ItemInfos.Contains(NewID))
			{
				NewID += 10;
				loop--;
				if (loop <= 0)
					break;
			}
			
			if (Core.Kernel.ItemInfos.Contains(NewID))
			{
				Data.ItemInfo newItem;
				if (Core.Kernel.ItemInfos.TrySelect(NewID, out newItem))
				{
					if (newItem.RequiredLevel > ToUpgrade.RequiredLevel && newItem.TypeName == ToUpgrade.TypeName)
					{
						client.Inventory.RemoveItemByUID(Meteor.UID);
						
						if (Calculations.BasicCalculations.ChanceSuccess(Core.NumericConst.LevelUpgradeChance))
						{
							Data.ItemInfo NewUpgradedItem = newItem.Copy();
							NewUpgradedItem.SetStats(ToUpgrade);
							
							client.Inventory.RemoveItemByUID(ToUpgrade.UID);
							
							if (Calculations.BasicCalculations.ChanceSuccess(Core.NumericConst.FirstSocketChance) &&
							    NewUpgradedItem.Gem1 == Enums.SocketGem.NoSocket)
							{
								NewUpgradedItem.Gem1 = Enums.SocketGem.EmptySocket;
							}
							else if (Calculations.BasicCalculations.ChanceSuccess(Core.NumericConst.SecondSocketChance) &&
							         NewUpgradedItem.Gem2 == Enums.SocketGem.NoSocket)
							{
								if (NewUpgradedItem.Gem1 == Enums.SocketGem.EmptySocket)
									NewUpgradedItem.Gem2 = Enums.SocketGem.EmptySocket;
							}
							
							client.Inventory.AddItem(NewUpgradedItem);
						}
					}
				}
			}
		}
	}
}

And replace all the code in ProjectX_V3_Game.Packets.Item.Uplev.cs with this:

//Project by BaussHacker aka. L33TS

using System;

namespace ProjectX_V3_Game.Packets.Item
{
	/// <summary>
	/// Description of Uplev.
	/// </summary>
	public class Uplev
	{
		public static void Handle(Entities.GameClient client, ItemPacket packet)
		{
			if (client.Booth != null)
				return;
			if (!client.Alive)
				return;
			
			if (!client.Inventory.ContainsByUID(packet.UID) && client.Inventory.ContainsByUID(packet.Data1))
			{
				using (var msg = Packets.Message.MessageCore.CreateSystem(client.Name, Core.MessageConst.ITEM_NOT_FOUND))
					client.Send(msg);
				return;
			}
			
			Data.ItemInfo ToUpgrade = client.Inventory.GetItemByUID(packet.UID);
			if (ToUpgrade.CurrentDura < ToUpgrade.MaxDura)
				return;
			
			Data.ItemInfo Meteor = client.Inventory.GetItemByUID(packet.Data1);
			if (Meteor == null || ToUpgrade == null)
			{
				using (var msg = Packets.Message.MessageCore.CreateSystem(client.Name, Core.MessageConst.ITEM_NOT_FOUND))
					client.Send(msg);
				return;
			}
			if (ToUpgrade.IsGarment() || ToUpgrade.IsArrow() || ToUpgrade.IsBottle() ||
			    ToUpgrade.IsSteed() || ToUpgrade.IsMisc())
			{
				using (var msg = Packets.Message.MessageCore.CreateSystem(client.Name, Core.MessageConst.ITEM_INVALID_UPGRADE))
					client.Send(msg);
				return;
			}
			if (ToUpgrade.RequiredLevel >= 120)
			{
				using (var msg = Packets.Message.MessageCore.CreateSystem(client.Name, Core.MessageConst.ITEM_MAX_LEVEL))
					client.Send(msg);
				return; // max level
			}
			if (Meteor.ItemID != 1088001 && Meteor.ItemID != 1088002)
			{
				using (var msg = Packets.Message.MessageCore.CreateSystem(
					client.Name,
					string.Format(Core.MessageConst.ITEM_AMOUNT_FAIL, "Meteor- or Meteortear's")))
					client.Send(msg);
				return;
			}

			uint NewID = ToUpgrade.ItemID + 10;
			int loop = 4;
			while (!Core.Kernel.ItemInfos.Contains(NewID))
			{
				NewID += 10;
				loop--;
				if (loop <= 0)
					break;
			}
			
			if (Core.Kernel.ItemInfos.Contains(NewID))
			{
				Data.ItemInfo newItem;
				if (Core.Kernel.ItemInfos.TrySelect(NewID, out newItem))
				{
					if (newItem.RequiredLevel > ToUpgrade.RequiredLevel && newItem.TypeName == ToUpgrade.TypeName)
					{
						client.Inventory.RemoveItemByUID(Meteor.UID);
						
						if (Calculations.BasicCalculations.ChanceSuccess(Core.NumericConst.LevelUpgradeChance))
						{
							Data.ItemInfo NewUpgradedItem = newItem.Copy();
							NewUpgradedItem.SetStats(ToUpgrade);
							
							client.Inventory.RemoveItemByUID(ToUpgrade.UID);
							
							if (Calculations.BasicCalculations.ChanceSuccess(Core.NumericConst.FirstSocketChance) &&
							    NewUpgradedItem.Gem1 == Enums.SocketGem.NoSocket)
							{
								NewUpgradedItem.Gem1 = Enums.SocketGem.EmptySocket;
							}
							else if (Calculations.BasicCalculations.ChanceSuccess(Core.NumericConst.SecondSocketChance) &&
							         NewUpgradedItem.Gem2 == Enums.SocketGem.NoSocket)
							{
								if (NewUpgradedItem.Gem1 == Enums.SocketGem.EmptySocket)
									NewUpgradedItem.Gem2 = Enums.SocketGem.EmptySocket;
							}
							
							client.Inventory.AddItem(NewUpgradedItem);
						}
					}
				}
			}
		}
	}
}

That's it.

Autoload NPC spawns from DB.

 Spoiler

By adding this you will no longer have to restart the server when adding new NPC's in the database.

1. Create a new class in ProjectX_V3_Game.Threads called NPCDBThread.cs

2. Replace everything with this:

//Project by BaussHacker aka. L33TS

using System;

namespace ProjectX_V3_Game.Threads
{
	/// <summary>
	/// Handling the npc database thread.
	/// </summary>
	public class NPCDBThread
	{
		public static void Handle()
		{
			bool NewCount;
			int NPCCount = Database.NPCDatabase.GetNPCCount(out NewCount);
			if (NewCount)
			{
				foreach (Entities.NPC npc in Core.Kernel.NPCs.Values)
				{
					npc.Map.LeaveMap(npc);
				}
				Core.Kernel.NPCs.Clear();
				int failed;
				Core.Kernel.Clients.TryForeachAction((uid, client) => { client.Screen.FullUpdate(); }, out failed);
				Database.NPCDatabase.LoadNPCInfo(false);
			}
		}
	}
}

3. Open ProjectX_V3_Game.Database.NPCDatabase.cs and replace LoadNPCInfo() with this:

		/// <summary>
		/// Loads all the npc informations and spawns.
		/// </summary>
		/// <returns>Returns true if the the infos/spawns were loaded.</returns>
		public static bool LoadNPCInfo(bool display = true)
		{
			Console.ForegroundColor = ConsoleColor.Yellow;
			if (display)
				Console.WriteLine("\tLoading NPCs...");
			using (var sql = new SqlHandler(Program.Config.ReadString("GameConnectionString")))
			{
				using (var cmd = new SqlCommandBuilder(sql, SqlCommandType.SELECT, false))
				{
					cmd.Finish("DB_NPCInfo");
				}
				while (sql.Read())
				{
					Entities.NPC npc = new ProjectX_V3_Game.Entities.NPC();
					npc.EntityUID = sql.ReadUInt32("NPCID");

					ushort mapid = sql.ReadUInt16("MapID");
					npc.X = sql.ReadUInt16("X");
					npc.Y = sql.ReadUInt16("Y");
					if (mapid == 0)
					{
						Console.ForegroundColor = ConsoleColor.Red;
						Console.WriteLine("Failed to load npcs. [MAPID]");
						Console.ResetColor();
						return false;
					}
					
					Maps.Map map;
					Core.Kernel.Maps.TrySelect(mapid, out map);
					npc.Map = map;
					if (!npc.Map.EnterMap(npc))
					{
						Console.ForegroundColor = ConsoleColor.Red;
						Console.WriteLine("Failed to load npcs. [MAP]");
						Console.ResetColor();
						return false;
					}
					
					npc.Mesh = sql.ReadUInt16("Mesh");
					npc.Flag = sql.ReadUInt32("Flag");
					npc.Name = sql.ReadString("NPCName");
					npc.NPCType = (Enums.NPCType)Enum.Parse(typeof(Enums.NPCType), sql.ReadString("Type"));
					
					npc.Avatar = sql.ReadByte("Avatar");

					if (!Core.Kernel.NPCs.TryAdd(npc.EntityUID, npc))
					{
						Console.ForegroundColor = ConsoleColor.Red;
						Console.WriteLine("Failed to load npcs. [ADD]");
						Console.ResetColor();
						return false;
					}
				}
			}
			if (display)
			{
				bool nCount;
				int count = GetNPCCount(out nCount);
				Console.ForegroundColor = ConsoleColor.Green;
				Console.WriteLine("\tLoaded {0}/{1} NPCs...", Core.Kernel.NPCs.Count, count);
			}
			return true;
		}

4. Add this to the NPCDatabase class as well.

private static int LastCount = 0;
		public static int GetNPCCount(out bool NewCount)
		{
			int count = 0;
			NewCount = false;
			
			using (var sql = new System.Data.SqlClient.SqlConnection(Program.Config.ReadString("GameConnectionString")))
			{
				sql.Open();
				using (var cmd = new System.Data.SqlClient.SqlCommand("SELECT COUNT(*) FROM DB_NPCInfo", sql))
				{
					count = (int)cmd.ExecuteScalar();
				}
			}
			if (LastCount != count)
				NewCount = true;
			LastCount = count;
			return count;
		}

5. Add this to GlobalThreads.Start().

new BaseThread(NPCDBThread.Handle, 5000, "NPCDBThread").Start();

6. Done. You can now add/remove npcs when the server is already online.

Installation:


Full Guide:

 Spoiler

1. Install MSSQL


Note:
You have to download "Microsoft® SQL Server® 2012 Express" and "Microsoft® SQL Server® 2008 Management Studio Express"

2. Move CODB to your root folder, ex. C:\


3. Open CODB\auth\Config.xml and edit the IP for both auth and game.


4. Edit the password (It has to match the password used at the game server.)


5. Edit the ConnectionString's Server (Make sure to remember it from installing, usually it is USERNAME\VERSION.)


6. Do the same in CODB\game\Config.xml

7. Open SQL Management Studio

8. Open "Databases"


9. Right click "Databases" and click "New Database..." - Name it "ProjectX_Auth_Database"

10. Right click "Databases" and click "New Database..." - Name it "ProjectX_Game_Database"

11. Drag "authdb.sql" into SQL Management Studio OR choose to open it with it.

12. Execute the script.


13. Do the same with" gamedb.sql"

14. Open ProjectX_Auth_Database and then the table "DB_Accounts"

15. Make a new account by filling out the data.


16. Open the source by the solution file. "ProjectX_V3.sln"

17. Rebuild it all and run both the auth and game server.


Note: There is currently set a permission for only PM's, but it can be edited in Core\Kernel.cs

public static bool GotPermission(Enums.PlayerPermission Permission)
		{
			const byte disallow = 1;
			return ((byte)Permission) <= disallow;
		}

Change disallow to 3. You can get the permissions in Enums.PlayerPermission.
You can edit the permission of a character in the database "DB_Players"

18. Now edit the IP in the client ex. LoaderSet.ini if you use Conquerloader V5.

19. Login (You have to disconnect after character creation.)
Note: Use Lucky7 to login with.


Congratulations you've set it up correct.

Anyways good luck to whoever uses this.

i cant import these sql files on my navicat pro...
INSERT [dbo].[DB_SystemVariables] ([SystemVariableID], [SystemVariableName], [SystemVariableValue]) VALUES (
[Msg] Finished - Unsuccessfully
------------------------------------------

etc any ideas why. ??? mysql is fully updated....

[nushizu]

it uses microsoft sql server, it needs to be set up that way

[MusicGod]

Originally Posted by nushizu

it uses microsoft sql server, it needs to be set up that way

What about when u go to compile.the source it asks for a dedicated exe to be part of it. An the backups are on a drive d. In other words there isn't a full source in that case...???

[patcac-patcac]

9. Right click "Databases" and click "New Database..." - Name it "ProjectX_Auth_Database"

guys i have searched for 3 days to find a solution for this before posting here but no luck

this is what happenes when i try to create the new database



any ideas relly need to get this working

[turk55]

Originally Posted by patcac-patcac

9. Right click "Databases" and click "New Database..." - Name it "ProjectX_Auth_Database"

guys i have searched for 3 days to find a solution for this before posting here but no luck

this is what happenes when i try to create the new database



any ideas relly need to get this working

You are running on a very old MSSQL server, upgrade it and you should be fine.

[Super Aids]

I would suggest getting the latest version of MSSQL

[Y u k i]

Originally Posted by turk55

You are running on a very old MSSQL server, upgrade it and you should be fine.

Very very old. Its from 1998. Im shocked it runs on Win8

[turk55]

Originally Posted by Y u k i

Very very old. Its from 1998. Im shocked it runs on Win8

*COUGH*1999*COUGH*