Guide/Release: Conquer Server (CoFuture) Using MySql!

03/18/2008 11:21 elragal_30#571
so how i can add skills andspells and profecincy
i can't use any of weabons ,just the Blade L 5

and SKILL , SPELL commands not work

is it need i enter it at DataBase First ???
03/18/2008 16:38 tigercek#572
Error
SQL query:

-- phpMyAdmin SQL Dump
-- version 2.9.2
-- [Only registered and activated users can see links. Click Here To Register...]
--
-- Host: localhost
-- Generation Time: Dec 01, 2007 at 03:53 PM
-- Server version: 5.0.27
-- PHP Version: 5.2.1
--
-- Database: `conquer_server`
--
CREATE DATABASE `conquer_server` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;



MySQL said:

#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 'DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci' at line 1


i get this error when i want to put in database in the sql... the backup wich u posted and thats the error i get
03/18/2008 17:40 Mehk#573
leavemealone or korvac...
I was wondering, why was this source to private server released instead of being further developed?

Is it possible to further develop this idea for us, or did you guys ran into trouble that couldn't be fixed and thus the reason this source was released?

- I haven't looked into the actual data yet, was just wondering before having a go at it myself. :) -

Thanks in advance
03/18/2008 20:38 instrance#574
Does anyone know why when i try to load arrows nothing happens?
Did anyone get the spells to work?

You guys are awesome.
03/18/2008 21:07 instrance#575
Hey trying to get mobs to work i found this but keep on getting an error when i try to build

Error 1 The type or namespace name 'serverpackets' does not exist in the namespace 'CO_Full_Server' (are you missing an assembly reference?) C:\Documents and Settings\blank\Desktop\Server\Mobs.cs 4 22 CoFuture


Error 2 The type or namespace name 'Instances' does not exist in the namespace 'CO_Full_Server' (are you missing an assembly reference?) C:\Documents and Settings\blankDesktop\Server\Mobs.cs 5 22 CoFuture


using System;
using System.Collections.Generic;
using System.Text;
using CO_Full_Server.serverpackets.SpawnEffect;
using CO_Full_Server.Instances;

namespace CO_Full_Server
{
class Mobs
{
public static void MobCheck()
{
try
{
int GenerateUID = 0;
MobDB_add Mobs_Data = null;
foreach (string[] spawns in BackendDB.MobSpawns)
{
if (spawns != null)
{
if (BackendDB.MobDetails.ContainsKey(Convert.ToInt32( spawns[0])))
{
Mobs_Data = (MobDB_add)BackendDB.MobDetails[Convert.ToInt32(spawns[0])];
}

}

if (Mobs_Data != null)
{
int SpawnNumber = Convert.ToInt32(spawns[6]);
if (SpawnNumber != 0)
{
int a = 0;
while (a < SpawnNumber)
{

new World.FindNULLMob(1);
int x_start = Convert.ToInt32(spawns[1]);
int x_stop = Convert.ToInt32(spawns[3]);
int y_start = Convert.ToInt32(spawns[2]);
int y_stop = Convert.ToInt32(spawns[4]);
string[] x = new string[1] { Convert.ToString(World.RND.Next(x_start, x_stop)) };
string[] y = new string[1] { Convert.ToString(World.RND.Next(y_start, y_stop)) };


GenerateUID = 400000 + World.RND.Next(1, 99999);
//byte[] Packet = PacketBuilder.SpawnMob(GenerateUID, Convert.ToInt32(save_item[2]), Convert.ToInt32(x[0]), Convert.ToInt32(y[0]), save_item[1], Convert.ToInt32(save_item[4]), Convert.ToInt32(save_item[3]), 0);
//new World.SpawnMob(Packet, Convert.ToString(spawns[5]), Convert.ToInt32(x[0]), Convert.ToInt32(y[0]));




//Client.SendData(PacketBuilder.SpawnMob(GenerateUID , Convert.ToInt32(save_item[2]), Convert.ToInt32(Splitter[2]), Convert.ToInt32(Splitter[3]), save_item[1], Convert.ToInt32(save_item[4])));
//BackendDB.MonsterDatabase[World.Save] = new string[7] { Convert.ToString(GenerateUID), Convert.ToString(save_item[0]), Convert.ToString(save_item[4]), Convert.ToString(x[0]), Convert.ToString(y[0]), Convert.ToString(spawns[5]), "0" };

MobDB_single SingleMobAdd = new MobDB_single();
SingleMobAdd.CurrentD_UID = GenerateUID;
SingleMobAdd.CurrentD_ID = Mobs_Data.id;
SingleMobAdd.CurrentD_HP = Mobs_Data.hp;
SingleMobAdd.Spawn_x = Convert.ToInt32(x[0]);
SingleMobAdd.Spawn_y = Convert.ToInt32(y[0]);
SingleMobAdd.Spawn_map = spawns[5];
SingleMobAdd.CurrentP_x = Convert.ToInt32(x[0]);
SingleMobAdd.CurrentP_y = Convert.ToInt32(y[0]);
SingleMobAdd.CurrentP_map = spawns[5];
SingleMobAdd.CurrentP_Pos = World.RND.Next(0, 9);

if (!BackendDB.SingleMobDB.ContainsKey(SingleMobAdd.C urrentD_UID))
BackendDB.SingleMobDB.Add(SingleMobAdd.CurrentD_UI D, SingleMobAdd);



//SpawnEffect Pac = new SpawnEffect(Convert.ToUInt32(GenerateUID), Convert.ToInt32(x[0]), Convert.ToInt32(y[0]), 0);
//World.SendLocalv2(Convert.ToInt32(x[0]), Convert.ToInt32(y[0]), Convert.ToString(spawns[5]), Pac.writeImpl());
// Old code, used to gen only one!
/*byte[] Packet = PacketBuilder.SpawnMob(GenerateUID, Convert.ToInt32(save_item[2]), Convert.ToInt32(spawns[1]), Convert.ToInt32(spawns[2]), save_item[1], Convert.ToInt32(save_item[4]), Convert.ToInt32(save_item[3]), 0);
new World.SpawnMob(Packet, Convert.ToString(spawns[3]), Convert.ToInt32(spawns[1]), Convert.ToInt32(spawns[2]));
//Client.SendData(PacketBuilder.SpawnMob(GenerateUID , Convert.ToInt32(save_item[2]), Convert.ToInt32(Splitter[2]), Convert.ToInt32(Splitter[3]), save_item[1], Convert.ToInt32(save_item[4])));
BackendDB.MonsterDatabase[World.Save] = new string[7] { Convert.ToString(GenerateUID), Convert.ToString(save_item[0]), Convert.ToString(save_item[4]), Convert.ToString(spawns[1]), Convert.ToString(spawns[2]), Convert.ToString(spawns[3]), "0" };
SpawnEffect Pac = new SpawnEffect(Convert.ToUInt32(GenerateUID), Convert.ToInt32(spawns[1]), Convert.ToInt32(spawns[2]), 0);
World.SendLocalv2(Convert.ToInt32(spawns[1]), Convert.ToInt32(spawns[2]), Convert.ToString(spawns[3]), Pac.writeImpl());*/
a++;
}
}
}
World.savespawntime = DateTime.Now.AddMilliseconds(500);
}
}catch (Exception e)
{
Console.WriteLine(e.ToString());
}
}

}
}
03/18/2008 21:49 elragal_30#576
Quote:
Originally Posted by instrance View Post
Hey trying to get mobs to work i found this but keep on getting an error when i try to build

Error 1 The type or namespace name 'serverpackets' does not exist in the namespace 'CO_Full_Server' (are you missing an assembly reference?) C:Documents and SettingsblankDesktopServerMobs.cs 4 22 CoFuture


Error 2 The type or namespace name 'Instances' does not exist in the namespace 'CO_Full_Server' (are you missing an assembly reference?) C:Documents and SettingsblankDesktopServerMobs.cs 5 22 CoFuture


using System;
using System.Collections.Generic;
using System.Text;
using CO_Full_Server.serverpackets.SpawnEffect;
using CO_Full_Server.Instances;

namespace CO_Full_Server
{
class Mobs
{
public static void MobCheck()
{
try
{
int GenerateUID = 0;
MobDB_add Mobs_Data = null;
foreach (string[] spawns in BackendDB.MobSpawns)
{
if (spawns != null)
{
if (BackendDB.MobDetails.ContainsKey(Convert.ToInt32( spawns[0])))
{
Mobs_Data = (MobDB_add)BackendDB.MobDetails[Convert.ToInt32(spawns[0])];
}

}

if (Mobs_Data != null)
{
int SpawnNumber = Convert.ToInt32(spawns[6]);
if (SpawnNumber != 0)
{
int a = 0;
while (a < SpawnNumber)
{

new World.FindNULLMob(1);
int x_start = Convert.ToInt32(spawns[1]);
int x_stop = Convert.ToInt32(spawns[3]);
int y_start = Convert.ToInt32(spawns[2]);
int y_stop = Convert.ToInt32(spawns[4]);
string[] x = new string[1] { Convert.ToString(World.RND.Next(x_start, x_stop)) };
string[] y = new string[1] { Convert.ToString(World.RND.Next(y_start, y_stop)) };


GenerateUID = 400000 + World.RND.Next(1, 99999);
//byte[] Packet = PacketBuilder.SpawnMob(GenerateUID, Convert.ToInt32(save_item[2]), Convert.ToInt32(x[0]), Convert.ToInt32(y[0]), save_item[1], Convert.ToInt32(save_item[4]), Convert.ToInt32(save_item[3]), 0);
//new World.SpawnMob(Packet, Convert.ToString(spawns[5]), Convert.ToInt32(x[0]), Convert.ToInt32(y[0]));




//Client.SendData(PacketBuilder.SpawnMob(GenerateUID , Convert.ToInt32(save_item[2]), Convert.ToInt32(Splitter[2]), Convert.ToInt32(Splitter[3]), save_item[1], Convert.ToInt32(save_item[4])));
//BackendDB.MonsterDatabase[World.Save] = new string[7] { Convert.ToString(GenerateUID), Convert.ToString(save_item[0]), Convert.ToString(save_item[4]), Convert.ToString(x[0]), Convert.ToString(y[0]), Convert.ToString(spawns[5]), "0" };

MobDB_single SingleMobAdd = new MobDB_single();
SingleMobAdd.CurrentD_UID = GenerateUID;
SingleMobAdd.CurrentD_ID = Mobs_Data.id;
SingleMobAdd.CurrentD_HP = Mobs_Data.hp;
SingleMobAdd.Spawn_x = Convert.ToInt32(x[0]);
SingleMobAdd.Spawn_y = Convert.ToInt32(y[0]);
SingleMobAdd.Spawn_map = spawns[5];
SingleMobAdd.CurrentP_x = Convert.ToInt32(x[0]);
SingleMobAdd.CurrentP_y = Convert.ToInt32(y[0]);
SingleMobAdd.CurrentP_map = spawns[5];
SingleMobAdd.CurrentP_Pos = World.RND.Next(0, 9);

if (!BackendDB.SingleMobDB.ContainsKey(SingleMobAdd.C urrentD_UID))
BackendDB.SingleMobDB.Add(SingleMobAdd.CurrentD_UI D, SingleMobAdd);



//SpawnEffect Pac = new SpawnEffect(Convert.ToUInt32(GenerateUID), Convert.ToInt32(x[0]), Convert.ToInt32(y[0]), 0);
//World.SendLocalv2(Convert.ToInt32(x[0]), Convert.ToInt32(y[0]), Convert.ToString(spawns[5]), Pac.writeImpl());
// Old code, used to gen only one!
/*byte[] Packet = PacketBuilder.SpawnMob(GenerateUID, Convert.ToInt32(save_item[2]), Convert.ToInt32(spawns[1]), Convert.ToInt32(spawns[2]), save_item[1], Convert.ToInt32(save_item[4]), Convert.ToInt32(save_item[3]), 0);
new World.SpawnMob(Packet, Convert.ToString(spawns[3]), Convert.ToInt32(spawns[1]), Convert.ToInt32(spawns[2]));
//Client.SendData(PacketBuilder.SpawnMob(GenerateUID , Convert.ToInt32(save_item[2]), Convert.ToInt32(Splitter[2]), Convert.ToInt32(Splitter[3]), save_item[1], Convert.ToInt32(save_item[4])));
BackendDB.MonsterDatabase[World.Save] = new string[7] { Convert.ToString(GenerateUID), Convert.ToString(save_item[0]), Convert.ToString(save_item[4]), Convert.ToString(spawns[1]), Convert.ToString(spawns[2]), Convert.ToString(spawns[3]), "0" };
SpawnEffect Pac = new SpawnEffect(Convert.ToUInt32(GenerateUID), Convert.ToInt32(spawns[1]), Convert.ToInt32(spawns[2]), 0);
World.SendLocalv2(Convert.ToInt32(spawns[1]), Convert.ToInt32(spawns[2]), Convert.ToString(spawns[3]), Pac.writeImpl());*/
a++;
}
}
}
World.savespawntime = DateTime.Now.AddMilliseconds(500);
}
}catch (Exception e)
{
Console.WriteLine(e.ToString());
}
}

}
}
hiii
how u can ad monsters??
i idn't find any about them
and nothing at database
03/18/2008 22:44 tigercek#577
Quote:
Originally Posted by tigercek View Post
Error
SQL query:

-- phpMyAdmin SQL Dump
-- version 2.9.2
-- [Only registered and activated users can see links. Click Here To Register...]
--
-- Host: localhost
-- Generation Time: Dec 01, 2007 at 03:53 PM
-- Server version: 5.0.27
-- PHP Version: 5.2.1
--
-- Database: `conquer_server`
--
CREATE DATABASE `conquer_server` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;



MySQL said:

#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 'DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci' at line 1


i get this error when i want to put in database in the sql... the backup wich u posted and thats the error i get
anyone can help me with this error???
03/19/2008 02:35 walmartboi#578
Lottery...............
03/19/2008 02:38 walmartboi#579
Mobs..... currently just pheasants!
03/19/2008 04:55 elragal_30#580
Quote:
Originally Posted by walmartboi View Post
Mobs..... currently just pheasants!
hii
tahnxs
i'll test and feed back tomorrow
and please if u can post Skills prof, spells
03/19/2008 11:17 Kiyono#581
did you just put co 2.1 files in the cofuture server...if thats everything even i could do it...
[edit] i just noticed how rude i sounded
and they don't work either
03/19/2008 16:08 instrance#582
Still getting Error 1 The type or namespace name 'serverpackets' does not exist in the namespace 'CO_Full_Server' (are you missing an assembly reference?) C:\Documents and Settings\ \Desktop\COFUTURE\CoFuture_Release\Server\Mobs.cs 4 22 CoFuture
03/19/2008 16:19 xxnikexx#583
Quote:
Originally Posted by instrance View Post
Still getting Error 1 The type or namespace name 'serverpackets' does not exist in the namespace 'CO_Full_Server' (are you missing an assembly reference?) C:Documents and Settings DesktopCOFUTURECoFuture_ReleaseServerMobs.cs 4 22 CoFuture
If u use the CoFuture source then u need change the CO_Full_Server to COServer!
03/19/2008 16:40 instrance#584
Same error. :-(
03/19/2008 16:43 xxnikexx#585
Quote:
Originally Posted by instrance View Post
Same error. :-(
Ohh ups...CoFuture source dosent contains serverpacets!

This Mobs.cs is not for CoFuture soururce its for other source!