Well this is my createcharacter class for 5165 and i Type its Name Choose Body Size Wen I click Enter It Gives me The Error Try again i just cant find wats the problem
## EDIT this is it writing the line...
[Only registered and activated users can see links. Click Here To Register...]
Code:
using System;
using Source_Project.GameSystem;
using Source_Project.Structures;
using MySql.Data.MySqlClient;
namespace Source_Project
{
public partial class Database
{
public static string CreateCharacter(string Account, string Name, ushort Body, byte Job)
{
MySqlConnection Conn = GetConnection(); Conn.Open();
try
{
MySqlCommand Cmd = null;
string ret = "";
bool exist = false;
try
{
lock (Conn)
{
Cmd = new MySqlCommand("SELECT * FROM `cq_users` WHERE `Name` = '" + Name + "'", Conn);
MySqlDataReader DR = Cmd.ExecuteReader();
while (DR.Read())
{
ret = "Name in use.";
exist = true;
}
DR.Close();
}
Conn.Close();
if (exist)
return ret;
}
catch { }
byte avatar = 1;
if (Body != 1003 || Body != 1004)
avatar = 201;
ushort Str = 0, Agi = 0, Vit = 0, Spi = 0;
GetInitialStats(Job, ref Str, ref Agi, ref Vit, ref Spi);
ushort HP = (ushort)(Vit * 24 + Str * 3 + Agi * 3 + Spi * 3);
string Inventory = "";
string Skills = "";
Conn = GetConnection();
lock (Conn)
{
Cmd = new MySqlCommand("INSERT INTO `cq_users` (Account,Name,Avatar,Body,Hair,Job,Str,Agi,Vit,Spi,CurHP,Inventory,Skills) VALUES ('" + Account + "','" + Name + "'," + avatar + "," + Body + "," + (410 + (Program.Rnd.Next(5) * 100)) + "," + Job + "," + Str + "," + Agi + "," + Vit + "," + Spi + "," + HP + ",'" + Inventory + "','" + Skills + "')", Conn);
Cmd.ExecuteNonQuery();
Cmd = new MySqlCommand("UPDATE `cq_accounts` set `Character` = '" + Name + "' WHERE `AccountID` = '" + Account + "'", Conn);
Cmd.ExecuteNonQuery();
}
Conn.Close();
}
catch { return "Error! Try again."; }
return "ANSWER_OK";
}
}
}
[Only registered and activated users can see links. Click Here To Register...]