look at this first photo appear with Level 1 sub class
and in this second picture off me and went back inside and I have no sub class need help please
this is my database of subclass what i need?
PHP Code:
using System;
using Conquer_Online_Server.Game;
namespace Conquer_Online_Server.Database
{
public class SubClassTable
{
public static void Load(Entity Entity)
{
MySqlCommand Command = new MySqlCommand(MySqlCommandType.SELECT);
Command.Select("subclasses").Where("id", Entity.UID);
MySqlReader Reader = new MySqlReader(Command);
while (Reader.Read())
{
Statement.SubClass Sub = new Statement.SubClass();
Sub.ID = Reader.ReadByte("uid");
Sub.Level = Reader.ReadByte("level");
Sub.Phase = Reader.ReadByte("phase");
Entity.SubClasses.Class(Sub.ID, Sub);
}
}
public static bool Contains(Entity Entity, byte id)
{
bool Return = false;
MySqlCommand Command = new MySqlCommand(MySqlCommandType.SELECT);
Command.Select("subclasses").Where("id", Entity.UID).And("uid", id);
MySqlReader Reader = new MySqlReader(Command);
if (Reader.Read())
{
if (Reader.ReadByte("uid") == id)
if (Reader.ReadByte("level") == id)
if (Reader.ReadByte("phase") == id)
Return = true;
}
return Return;
}
public static void Insert(Entity Entity, byte id)
{
MySqlCommand Command = new MySqlCommand(MySqlCommandType.INSERT);
Command.Insert("subclasses")
.Insert("uid", id)
.Insert("id", Entity.UID)
.Execute();
}
public static void Update(Entity Entity, Statement.SubClass SubClass)
{
MySqlCommand Command = new MySqlCommand(MySqlCommandType.UPDATE);
Command.Update("subclasses")
.Set("phase", SubClass.Phase)
.Set("level", SubClass.Level)
.Where("id", Entity.UID)
.And("uid", SubClass.ID)
.Execute();
}
public static void Update(Entity Entity)
{
MySqlCommand Command = new MySqlCommand(MySqlCommandType.UPDATE);
Command.Update("entities")
.Set("StudyPoints", Entity.SubClasses.StudyPoints)
.Where("UID", Entity.UID)
.Execute();
}
}
}
