public bool createUser(string userid, string nick, string race)
{
gamesdbDataContext db = new gamesdbDataContext();
//сортировать по id и взять максимальное
var res = db.ExecuteQuery<userdb>("Select * from userdb");
int maxId = 0;
//создаем пользователя
foreach (userdb t in res)
{
if (Convert.ToInt32(t.Idsbase) > maxId)
maxId = Convert.ToInt32(t.Idsbase);
if (Convert.ToInt32(t.Idsbase) == Convert.ToInt32(userid))
return false;
}
maxId += 1;
DateTime nowD = DateTime.Now;
db.ExecuteCommand("insert into userdb (Id, Nickname, Idsbase, Timecreate) VALUES ({0}, {1}, {2}, {3})",
Convert.ToInt32(userid), nick, maxId, nowD);
//создаём для пользователя расу
int raceNum = 3;
if(race == "Orc")
raceNum = 2;
else if (race == "Elf")
raceNum = 1;
db.ExecuteCommand("insert into racedb (Id, type) VALUES ({0}, {1})",
Convert.ToInt32(userid), raceNum);
//аус кей (доделать потом)
db.ExecuteCommand("insert into authkeydb (Id, authkey, datetime) VALUES ({0}, {1}, {2})",
Convert.ToInt32(userid), "1234567890", nowD);
//энергия
db.ExecuteCommand("insert into energydb (Id, energylimit, energycount, datetime) VALUES ({0}, {1}, {2}, {3})",
Convert.ToInt32(userid), 100, 100, nowD);
//опыт/лвл
db.ExecuteCommand("insert into expdb (Id, expcount) VALUES ({0}, {1})",
Convert.ToInt32(userid), 0);
//инвентарь
string inventory = "";
for (int i = 0; i < 40; i++)
{
inventory += userid.ToString() + "_"+i.ToString()+";";
}
db.ExecuteCommand("insert into inventorydb (Id, idmassyacheek) VALUES ({0}, {1})",
Convert.ToInt32(userid), inventory);
for (int i = 0; i < 12; i++)
{
string idYach = userid.ToString() + "_" + i.ToString();
db.ExecuteCommand("insert into yacheykadb (Id, type, item_id) VALUES ({0}, {1}, {2})",
idYach, 1, 0);
}
for (int i = 12; i < 40; i++)
{
string idYach = userid.ToString() + "_" + i.ToString();
db.ExecuteCommand("insert into yacheykadb (Id, type, item_id) VALUES ({0}, {1}, {2})",
idYach, 2, 0);
}
//деньги
db.ExecuteCommand("insert into moneydb (Id, gold, oensh) VALUES ({0}, {1}, {2})",
Convert.ToInt32(userid), 25, 100);
//настройки
db.ExecuteCommand("insert into settingsdb (Id, music, sound, volume) VALUES ({0}, {1}, {2}, {3})",
Convert.ToInt32(userid), 1, 1, 100);
//корабль (создать БД с кораблями)
db.ExecuteCommand("insert into shipdb (Id, shiptype) VALUES ({0}, {1})",
Convert.ToInt32(userid), 1);
//уровень
db.ExecuteCommand("insert into stagedb (Id, lastplanetwin) VALUES ({0}, {1})",
Convert.ToInt32(userid), 0);
return true;
}
public IEnumerable<userInfo> getUser(string userid)
{
gamesdbDataContext db = new gamesdbDataContext();
var outI = new List<userInfo>();
var nnOut = new userInfo();
var nn = new userdb();
foreach (userdb t in db.userdb)
{
if (t.Id.ToString() == userid)
{
nn.Id = t.Id;
nn.Nickname = t.Nickname;
nn.Idsbase = t.Idsbase;
nn.Timecreate = t.Timecreate;
}
}
nnOut.userdb = nn;
var nn1 = new authkeydb();
foreach (authkeydb t in db.authkeydb)
{
if (t.Id.ToString() == userid)
{
nn1.Id = t.Id;
nn1.authkey = t.authkey;
nn1.datetime = t.datetime;
}
}
nnOut.authkeydb = nn1;
var nn2 = new energydb();
foreach (energydb t in db.energydb)
{
if (t.Id.ToString() == userid)
{
nn2.Id = t.Id;
nn2.energylimit = t.energylimit;
nn2.energycount = t.energycount;
nn2.datetime = t.datetime;
}
}
nnOut.energydb = nn2;
var nn3 = new expdb();
foreach (expdb t in db.expdb)
{
if (t.Id.ToString() == userid)
{
nn3.Id = t.Id;
nn3.expcount = t.expcount;
}
}
nnOut.expdb = nn3;
var nn4 = new inventorydb();
foreach (inventorydb t in db.inventorydb)
{
if (t.Id.ToString() == userid)
{
nn4.Id = t.Id;
nn4.idmassyacheek = t.idmassyacheek;
}
}
nnOut.inventorydb = nn4;
var nn5 = new moneydb();
foreach (moneydb t in db.moneydb)
{
if (t.Id.ToString() == userid)
{
nn5.Id = t.Id;
nn5.gold = t.gold;
nn5.oensh = t.oensh;
}
}
nnOut.moneydb = nn5;
var nn6 = new settingsdb();
foreach (settingsdb t in db.settingsdb)
{
if (t.Id.ToString() == userid)
{
nn6.Id = t.Id;
nn6.music = t.music;
nn6.sound = t.sound;
nn6.volume = t.volume;
}
}
nnOut.settingsdb = nn6;
var nn7 = new racedb();
foreach (racedb t in db.racedb)
{
if (t.Id.ToString() == userid)
{
nn7.Id = t.Id;
nn7.type = t.type;
}
}
nnOut.racedb = nn7;
var nn8 = new shipdb();
foreach (shipdb t in db.shipdb)
{
if (t.Id.ToString() == userid)
{
nn8.Id = t.Id;
nn8.shiptype = t.shiptype;
}
}
nnOut.shipdb = nn8;
var nn9 = new stagedb();
foreach (stagedb t in db.stagedb)
{
if (t.Id.ToString() == userid)
{
nn9.Id = t.Id;
nn9.lastplanetwin = t.lastplanetwin;
}
}
nnOut.stagedb = nn9;
outI.Add(nnOut);
return outI;
}
