BOI files (released)

Quote:

Originally Posted by LeRaz0r I don't think the logsrv is a DB file. I think it's supposed to be an exectueable much like the GameServer one only has to be run in Linux. This is just a hypothesis, however. Basically, I have everything running except the Database and the LogSrv, which currently allows me to see the server on the list, just like you. BUT, when I attempt to connect to the server it just says "Unable to connect to server - Check your connection (Error code: -1)" Which leads me to two possible explanations: - HAS to Connect through an old client (Like the one you use, I currently don't have one) - LogSrv is an executeable I am searching the net for an old version of BOI client as we speak, and when I get one, I will investigate this. If I manage to connect to the server, then I will start working on the database instead. Will post here later tonight.

Quote:

#!/bin/bash MYSQL=/usr/local/mysql/bin/mysql DBUSER=$1 DBPASSWD=$2 DBNAME=$3 echo -n "Create tables begin, please wait" echo -n "." $MYSQL -u$DBUSER -p$DBPASSWD $DBNAME -B -s -e " CREATE TABLE IF NOT EXISTS basetab_sg ( RoleID integer unsigned NOT NULL, AccountID integer unsigned NOT NULL, SlotID TINYINT NOT NULL, Name char(15) NOT NULL, Profession tinyint NOT NULL, Sex tinyint NOT NULL, HairModel integer NOT NULL, HairColor integer NOT NULL, HeadPic integer NOT NULL, Face integer NOT NULL, Money integer unsigned NOT NULL, ReserveMoney integer unsigned NOT NULL, StorageMoney integer unsigned NOT NULL, Exp bigint NOT NULL, Level integer NOT NULL, Give integer unsigned NOT NULL, Point integer unsigned NOT NULL, LastGetGiveTime datetime NOT NULL, Strength smallint NOT NULL, Constitution smallint NOT NULL, Agility smallint NOT NULL, Intelligence smallint NOT NULL, Energy smallint NOT NULL, LeftAttrPoint integer NOT NULL, Spawn integer NOT NULL, ExplorerLevel tinyint NOT NULL, ExplorerExp integer unsigned NOT NULL, Rank integer unsigned NOT NULL, HP integer unsigned NOT NULL, MP integer unsigned NOT NULL, XP integer unsigned NOT NULL, SciencePoint integer NOT NULL, ScienceLevel tinyint NOT NULL, SciencePoolLevel tinyint NOT NULL, ScienceGrowthLevel tinyint NOT NULL, TireLevel tinyint NOT NULL, TireValue integer NOT NULL, ExpIncPerDay bigint NOT NULL, MoneyIncPerDay integer unsigned NOT NULL, PerfectRelive integer unsigned NOT NULL, DiaVIPDate datetime NOT NULL, BattleMoney integer NOT NULL, BattleGold integer NOT NULL, BattleWin integer unsigned NOT NULL, BattleLost integer unsigned NOT NULL, NobleHighLvl smallint NOT NULL, NobleDeduction integer unsigned NOT NULL, LastNobleExp integer unsigned NOT NULL, PersonHonorPerDay tinyint NOT NULL, SpreadID integer unsigned NOT NULL, SpreadGold integer unsigned NOT NULL DEFAULT 0, SpreadBonus integer unsigned NOT NULL DEFAULT 0, GodLevel tinyint NOT NULL, GodPunish tinyint NOT NULL, GodValue integer unsigned NOT NULL, VeteranLevel tinyint NOT NULL, VeteranExp integer unsigned NOT NULL, DivineGrace integer unsigned NOT NULL, DivineGained integer unsigned NOT NULL, GuildTask smallint NOT NULL, TotalOffer integer unsigned NOT NULL, Spirit char(30) NOT NULL, Personality char(33) NOT NULL, Job char(11) NOT NULL, City char(11) NOT NULL, Favorite char(17) NOT NULL, Attention integer unsigned NOT NULL, Flower integer unsigned NOT NULL, QQ bigint NOT NULL, Province tinyint NOT NULL, Old tinyint NOT NULL, RealSex tinyint NOT NULL, BattleScore integer unsigned NOT NULL, BattleExp integer unsigned NOT NULL, MarryLevel smallint NOT NULL, MarryExp integer unsigned NOT NULL, LoveLevel smallint NOT NULL, LoveExp integer unsigned NOT NULL, Happiness integer unsigned NOT NULL, MarryTime datetime NOT NULL, MarryQuestID integer unsigned NOT NULL, ProfessionRank integer unsigned NOT NULL, PetStorageMax smallint NOT NULL, PetExtraMax smallint NOT NULL, GuildOffer integer unsigned NOT NULL, WeekLiveness integer unsigned NOT NULL, SkillRank integer unsigned NOT NULL, TreasureRank integer unsigned NOT NULL, ExploreValue integer unsigned NOT NULL, Appraisal integer unsigned NOT NULL, RegisterTime datetime NOT NULL, LeaveGuildTime datetime NOT NULL, LastLoginTime datetime NOT NULL, LastLogoutTime datetime NOT NULL, LastIP integer unsigned NOT NULL, MapID integer NOT NULL, PosX float NOT NULL, PosY float NOT NULL, Liveness integer unsigned NOT NULL, Literary integer unsigned NOT NULL, Teacher integer unsigned NOT NULL, Body integer unsigned NOT NULL, Hardwork integer unsigned NOT NULL, Military integer unsigned NOT NULL, PKWins integer NOT NULL, PKTotals integer NOT NULL, KMValues integer NOT NULL, Birthday integer unsigned NOT NULL, Animal tinyint NOT NULL, Blood tinyint NOT NULL, IsDel tinyint NOT NULL, DelTime datetime NOT NULL, CreditInfo blob, TitleInfo blob, SkillInfo blob, BufferInfo blob, RelationInfo blob, TrumpInfo blob, RiderInfo blob, ShortCutInfo blob, EquipInfo blob, TaskInfo blob, FirstOperInfo blob, ProduceSkillInfo blob, ScienceUpdateInfo blob, ColdDownInfo blob, PreNameInfo blob, EmoteInfo blob, LimitInfo blob, AwardInfo blob, TreasureInfo blob, AskAnswerInfo blob, ResetFlag tinyint NOT NULL, Reserve1 integer NOT NULL, Reserve2 integer NOT NULL, PRIMARY KEY(RoleID) )TYPE = InnoDB;" $MYSQL -u$DBUSER -p$DBPASSWD $DBNAME -B -s -e "CREATE INDEX AccountID on basetab_sg (AccountID);" $MYSQL -u$DBUSER -p$DBPASSWD $DBNAME -B -s -e "CREATE INDEX Name on basetab_sg (Name);" $MYSQL -u$DBUSER -p$DBPASSWD $DBNAME -B -s -e "CREATE INDEX SpreadID on basetab_sg (SpreadID);" echo -n "." $MYSQL -u$DBUSER -p$DBPASSWD $DBNAME -B -s -e "\ CREATE TABLE IF NOT EXISTS itemtab_sg ( \ RoleID integer unsigned NOT NULL, \ ItemInfo blob, \ PRIMARY KEY(RoleID) \ )TYPE = InnoDB;" echo -n "." $MYSQL -u$DBUSER -p$DBPASSWD $DBNAME -B -s -e "\ CREATE TABLE IF NOT EXISTS goldtab_sg ( \ AccountID integer unsigned NOT NULL, \ Gold integer NOT NULL, \ TotalAdd integer NOT NULL, \ TotalUse integer NOT NULL, \ TotalSell integer NOT NULL, \ TotalBuy integer NOT NULL, \ ReserveTime datetime, ReserveInt1 integer, ReserveInt2 integer, GoldInfo blob, PRIMARY KEY(AccountID) \ )TYPE = InnoDB;" echo -n "." $MYSQL -u$DBUSER -p$DBPASSWD $DBNAME -B -s -e "\ CREATE TABLE IF NOT EXISTS safetab_sg ( \ AccountID integer unsigned NOT NULL, \ SafePasswd char(33) NOT NULL, ProtectInfo blob, PRIMARY KEY(AccountID) \ )TYPE = InnoDB;" echo -n "." $MYSQL -u$DBUSER -p$DBPASSWD $DBNAME -B -s -e "\ CREATE TABLE IF NOT EXISTS guildtab_sg ( \ GuildID integer unsigned NOT NULL, \ GuildName char(15) NOT NULL, \ Level TINYINT NOT NULL, \ Prosperity integer unsigned NOT NULL, \ Unite integer unsigned NOT NULL, \ Belief integer unsigned NOT NULL, \ WarRecord integer unsigned NOT NULL, \ Money integer unsigned NOT NULL, \ FightPoint integer unsigned NOT NULL, \ Solid integer unsigned NOT NULL, \ TaskerID integer unsigned NOT NULL, \ Version integer unsigned NOT NULL, \ Morale integer unsigned NOT NULL, \ Rank smallint NOT NULL, \ CreativityLevel integer unsigned NOT NULL, \ FightPointLevel integer unsigned NOT NULL, \ SolidLevel integer unsigned NOT NULL, \ Creativity integer unsigned NOT NULL, \ Power integer unsigned NOT NULL, \ UnionID integer unsigned NOT NULL, \ PicID tinyint NOT NULL, \ Popularity integer unsigned NOT NULL, CustomPic tinyint NOT NULL, FrozenFortWin integer unsigned NOT NULL, City smallint NOT NULL, BidMoney integer unsigned NOT NULL, Notice blob, \ MemberInfo blob, \ Pic blob, \ RelationData blob, \ SkillData blob, \ VarData blob, CreateTime datetime NOT NULL, \ IsDel TINYINT NOT NULL, \ DelTime datetime NOT NULL, \ PRIMARY KEY(GuildID) \ )TYPE = InnoDB;" $MYSQL -u$DBUSER -p$DBPASSWD $DBNAME -B -s -e "CREATE INDEX GuildName on guildtab_sg (GuildName);" echo -n "." $MYSQL -u$DBUSER -p$DBPASSWD $DBNAME -B -s -e "\ CREATE TABLE IF NOT EXISTS mailtab_sg ( \ MailID integer unsigned NOT NULL AUTO_INCREMENT, \ SenderID integer unsigned NOT NULL, \ TargerID integer unsigned NOT NULL, \ MailInfo blob, \ CreateTime datetime NOT NULL, \ PRIMARY KEY(MailID) \ )TYPE = InnoDB;" $MYSQL -u$DBUSER -p$DBPASSWD $DBNAME -B -s -e "CREATE INDEX TargerID ON mailtab_sg (TargerID);" echo -n "." $MYSQL -u$DBUSER -p$DBPASSWD $DBNAME -B -s -e "\ CREATE TABLE IF NOT EXISTS pettab_sg ( \ PetID bigint NOT NULL, \ RoleID integer unsigned NOT NULL, \ PetInfo blob, \ PRIMARY KEY(PetID) \ )TYPE = InnoDB;" $MYSQL -u$DBUSER -p$DBPASSWD $DBNAME -B -s -e "CREATE INDEX RoleID ON pettab_sg (RoleID);" echo -n "." $MYSQL -u$DBUSER -p$DBPASSWD $DBNAME -B -s -e "\ CREATE TABLE IF NOT EXISTS msgtab_sg ( \ MessageID integer unsigned NOT NULL AUTO_INCREMENT, \ SenderID integer unsigned NOT NULL, \ TargerID integer unsigned NOT NULL, \ Type tinyint NOT NULL, \ MessageInfo blob, \ PRIMARY KEY(MessageID) \ )TYPE = InnoDB;" $MYSQL -u$DBUSER -p$DBPASSWD $DBNAME -B -s -e "CREATE INDEX TargerID ON msgtab_sg (TargerID);" echo -n "." $MYSQL -u$DBUSER -p$DBPASSWD $DBNAME -B -s -e "\ CREATE TABLE IF NOT EXISTS ranklisttab_sg ( \ Type integer unsigned NOT NULL, \ RankList blob, \ PRIMARY KEY(Type) \ )TYPE = InnoDB;" echo -n "." $MYSQL -u$DBUSER -p$DBPASSWD $DBNAME -B -s -e "\ CREATE TABLE IF NOT EXISTS consigntab_sg ( \ ID integer unsigned NOT NULL, \ Type tinyint NOT NULL, \ StartTime datetime NOT NULL, \ Price integer NOT NULL, \ HandNum integer NOT NULL, \ LeftTime integer NOT NULL, \ RoleID integer unsigned NOT NULL, \ PRIMARY KEY(ID) \ )TYPE = InnoDB;" echo -n "." $MYSQL -u$DBUSER -p$DBPASSWD $DBNAME -B -s -e "\ CREATE TABLE IF NOT EXISTS idpooltab_sg ( \ Type integer unsigned NOT NULL, \ DataID bigint NOT NULL, \ PRIMARY KEY(Type) \ )TYPE = InnoDB;" echo -n "." $MYSQL -u$DBUSER -p$DBPASSWD $DBNAME -B -s -e "\ CREATE TABLE IF NOT EXISTS sysvartab_sg ( \ LineID tinyint NOT NULL, \ SysVarInfo blob, \ PRIMARY KEY(LineID) \ )TYPE = InnoDB;" echo -n "." $MYSQL -u$DBUSER -p$DBPASSWD $DBNAME -B -s -e "\ CREATE TABLE IF NOT EXISTS cardtab_sg ( \ SerialID integer unsigned NOT NULL AUTO_INCREMENT, \ Type integer unsigned NOT NULL, \ CardNumber char(33) binary NOT NULL, IsUsed tinyint NOT NULL, PRIMARY KEY(SerialID) \ )TYPE = InnoDB;" $MYSQL -u$DBUSER -p$DBPASSWD $DBNAME -B -s -e "CREATE INDEX CardNumber ON cardtab_sg (CardNumber);" echo -n "." $MYSQL -u$DBUSER -p$DBPASSWD $DBNAME -B -s -e " CREATE TABLE IF NOT EXISTS forbidtab_sg ( ID integer unsigned NOT NULL, Type tinyint NOT NULL, Name char(33), StartTime datetime NOT NULL, LastTime integer NOT NULL, Reason char(65), PRIMARY KEY(ID, Type) )TYPE = InnoDB;" echo -n "." $MYSQL -u$DBUSER -p$DBPASSWD $DBNAME -B -s -e "\ CREATE TABLE IF NOT EXISTS vartab_sg ( \ LineID tinyint NOT NULL, \ Type integer unsigned NOT NULL, \ VarInfo blob, \ PRIMARY KEY(LineID, Type) \ )TYPE = InnoDB;" echo -n "." $MYSQL -u$DBUSER -p$DBPASSWD $DBNAME -B -s -e "\ CREATE TABLE IF NOT EXISTS shoplogtab_sg ( \ BillID integer unsigned NOT NULL AUTO_INCREMENT,\ Time datetime NOT NULL default '0000-00-00 00:00:00', \ AccountID integer unsigned NOT NULL, \ RoleID integer unsigned NOT NULL, \ ItemID integer unsigned NOT NULL, \ ItemGUID bigint NOT NULL, \ Num tinyint NOT NULL, \ BuyType tinyint NOT NULL, \ RealNeed integer unsigned NOT NULL, Point integer unsigned NOT NULL, LeftNum integer NOT NULL, PRIMARY KEY(BillID) )TYPE = InnoDB;" echo -n "." $MYSQL -u$DBUSER -p$DBPASSWD $DBNAME -B -s -e "\ CREATE TABLE IF NOT EXISTS goldaddtab_sg ( \ AccountID integer unsigned NOT NULL, \ TotalAdd integer NOT NULL, \ UsedNum integer NOT NULL, \ TotalAddS integer NOT NULL, UsedNumS integer NOT NULL, SuperFlag tinyint NOT NULL, \ Reserve1 integer unsigned NOT NULL, \ PRIMARY KEY(AccountID) )TYPE = InnoDB;" echo -n "." $MYSQL -u$DBUSER -p$DBPASSWD $DBNAME -B -s -e "\ CREATE TABLE IF NOT EXISTS mailitemtab_sg ( RoleID blob, OnlyID bigint NOT NULL, ItemID blob, ItemCount blob, MailTime blob, UserIP blob )TYPE = InnoDB;" echo -n "." $MYSQL -u$DBUSER -p$DBPASSWD $DBNAME -B -s -e "\ CREATE TABLE IF NOT EXISTS battletab_sg ( \ BattleID integer unsigned NOT NULL, \ BattleName char(15) NOT NULL, \ Type tinyint NOT NULL, \ Level smallint NOT NULL, \ LeaderID integer unsigned NOT NULL, \ BattleTimes integer unsigned NOT NULL, \ Win integer unsigned NOT NULL, \ Lost integer unsigned NOT NULL, \ Score integer unsigned NOT NULL, \ PicID smallint NOT NULL, \ Color integer unsigned NOT NULL, \ ChampionTimes integer unsigned NOT NULL, \ Version smallint NOT NULL, \ MemberInfo blob, \ CreateTime datetime NOT NULL, \ PRIMARY KEY(BattleID) \ )TYPE = InnoDB;" $MYSQL -u$DBUSER -p$DBPASSWD $DBNAME -B -s -e "CREATE INDEX BattleName on battletab_sg (BattleName);" echo "Create tables end"

Quote:

Originally Posted by shijiegames I'm the one that released the files, and my server will be fully free. [Only registered and activated users can see links. Click Here To Register...] As for the LogSRV is not in any way connected to the database besides logging anything, the only thing that touch the MySQL database are Name Server, Card Server, Database Server, Authd(MSSQL) It generally run's on 3-4 machines but you should be able to run it in a sandbox (vm) in windows. Use RHEL or any flavour of the same base. IE CENTOS, FEDORA etc.