Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

GodsWar Online Server Files Sourcecode + Database

The Best DDoS Protected Servers
S

shekspro

Newbie Spellweaver
Joined
Feb 21, 2014
Messages
11
Reaction score
3
please send me link new database this link not working :((((
 
P

penthos48

Initiate Mage
Joined
Jun 3, 2014
Messages
2
Reaction score
0
all link is crashed.. pelease update all links... because i need them...
 
I

incognito07

Initiate Mage
Joined
Jun 9, 2014
Messages
1
Reaction score
0
where's the Link of Server Files Sourcecode + Database?
link the true link
 
B

Buden

Initiate Mage
Joined
Feb 10, 2016
Messages
2
Reaction score
0
I have found some files and keep on working on it. They connect to each other as you can see on the pics. The only problem is that i cant login on the game. Maybe because its database file on accounts.sql has errors. Help please! ANd when i try accounts that does not exist in the database it works. Ill give the current accounts.sql that im using on the attachements.

Code: 
ERROR: Database ExecuteSQL(Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=') occur mysql error(CALL SP_SELECT_ACCOUNTS_INFO('updays','updays','127.0.0.1');). -- Sun Apr 10 13:27:16 2016


Code: 
/*
Navicat MySQL Data Transfer

Source Server         : 127.0.0.1
Source Server Version : 50136
Source Host           : localhost:3306
Source Database       : accounts

Target Server Type    : MYSQL
Target Server Version : 50136
File Encoding         : 65001

Date: 2009-10-20 19:22:10
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `accounts_ban`
-- ----------------------------
DROP TABLE IF EXISTS `accounts_ban`;
CREATE TABLE `accounts_ban` (
  `id` int(4) unsigned zerofill NOT NULL COMMENT '账号ID',
  `bandate` datetime NOT NULL COMMENT '禁止日期',
  `unbandate` datetime NOT NULL COMMENT '解禁日期',
  `bannedby` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT 'GM账号',
  `banreason` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '禁止原因',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of accounts_ban
-- ----------------------------

-- ----------------------------
-- Table structure for `accounts_info`
-- ----------------------------
DROP TABLE IF EXISTS `accounts_info`;
CREATE TABLE `accounts_info` (
  `id` int(4) unsigned NOT NULL AUTO_INCREMENT COMMENT '玩家编号',
  `accounts` varchar(32) COLLATE utf8_unicode_ci NOT NULL COMMENT '玩家帐号',
  `password` char(32) COLLATE utf8_unicode_ci NOT NULL COMMENT '密码',
  `login_status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '登陆状态',
  `last_login_time` datetime NOT NULL COMMENT '上次登陆时间',
  `last_logout_time` datetime NOT NULL COMMENT '次上离线时间',
  `last_login_IP` char(20) CHARACTER SET gb2312 NOT NULL COMMENT '上次登陆IP',
  `last_login_mac` varchar(50) CHARACTER SET gb2312 NOT NULL COMMENT '上次登录MAC地址',
  `total_online_time` bigint(8) unsigned NOT NULL COMMENT '总在线时长',
  `accounts_status` tinyint(1) unsigned NOT NULL COMMENT '帐号状态',
  PRIMARY KEY (`id`),
  UNIQUE KEY `index` (`accounts`)
) ENGINE=InnoDB AUTO_INCREMENT=132 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of accounts_info
-- ----------------------------
INSERT INTO `accounts_info` VALUES ('125', 'updays', 'updays', '0', '2009-10-19 22:42:16', '2009-10-19 22:42:21', '127.0.0.1', 'updays', '44', '11');
INSERT INTO `accounts_info` VALUES ('126', '1110', '1110', '1', '2007-07-31 11:23:15', '2007-07-31 11:23:19', '192.168.1.101', '23565', '2545', '1');
INSERT INTO `accounts_info` VALUES ('127', '1111', '1111', '1', '2007-07-31 11:23:15', '2007-07-31 11:23:19', '192.168.1.101', '23565', '2545', '1');
INSERT INTO `accounts_info` VALUES ('128', '1112', '1112', '1', '2007-07-31 11:23:15', '2007-07-31 11:23:19', '192.168.1.101', '23565', '2545', '1');
INSERT INTO `accounts_info` VALUES ('129', '1113', '1113', '1', '2007-07-31 11:23:15', '2007-07-31 11:23:19', '192.168.1.101', '23565', '2545', '1');
INSERT INTO `accounts_info` VALUES ('130', '1114', '1114', '1', '2007-07-31 11:23:15', '2007-07-31 11:23:19', '192.168.1.101', '23565', '2545', '1');
INSERT INTO `accounts_info` VALUES ('131', '1115', '1115', '1', '2007-07-31 11:23:15', '2007-07-31 11:23:19', '192.168.1.101', '23565', '2545', '1');

-- ----------------------------
-- Table structure for `accounts_register`
-- ----------------------------
DROP TABLE IF EXISTS `accounts_register`;
CREATE TABLE `accounts_register` (
  `AccID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `PassName` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PassPwd` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `IdentityID` varchar(255) CHARACTER SET gb2312 DEFAULT NULL,
  `RealName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Email` varchar(255) CHARACTER SET gb2312 DEFAULT NULL,
  `Question` varchar(255) CHARACTER SET gb2312 DEFAULT NULL,
  `Answer` varchar(255) CHARACTER SET gb2312 DEFAULT NULL,
  `RegeditTime` datetime DEFAULT NULL,
  `AreaID` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ActiveNumber` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `IsActive` tinyint(1) DEFAULT NULL,
  `IsDel` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`AccID`)
) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of accounts_register
-- ----------------------------
INSERT INTO `accounts_register` VALUES ('125', 'updays', 'updays', '1', 'updays', 'updays', 'updays', 'updays', '2009-10-19 22:43:16', '222', '12', null, null);

-- ----------------------------
-- Table structure for `gamearea_info`
-- ----------------------------
DROP TABLE IF EXISTS `gamearea_info`;
CREATE TABLE `gamearea_info` (
  `GID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `GameArea` int(11) unsigned NOT NULL,
  `AccID` int(11) unsigned NOT NULL,
  `PassName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `PassPwd` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `Balance` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `IsDel` tinyint(1) NOT NULL DEFAULT '0',
  `IsDraw` tinyint(1) DEFAULT '0' COMMENT '是否领取奖励',
  PRIMARY KEY (`GID`),
  UNIQUE KEY `index` (`PassName`)
) ENGINE=InnoDB AUTO_INCREMENT=8233 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of gamearea_info
-- ----------------------------
INSERT INTO `gamearea_info` VALUES ('8226', '1', '125', 'updays', 'updays', null, '0', '0');
INSERT INTO `gamearea_info` VALUES ('8227', '1', '0', '1110', '1110', null, '0', '0');
INSERT INTO `gamearea_info` VALUES ('8228', '1', '0', '1111', '1111', null, '0', '0');
INSERT INTO `gamearea_info` VALUES ('8229', '1', '0', '1112', '1112', null, '0', '0');
INSERT INTO `gamearea_info` VALUES ('8230', '1', '0', '1113', '1113', null, '0', '0');
INSERT INTO `gamearea_info` VALUES ('8231', '1', '0', '1114', '1114', null, '0', '0');
INSERT INTO `gamearea_info` VALUES ('8232', '1', '0', '1115', '1115', null, '0', '0');

-- ----------------------------
-- Table structure for `ip_ban`
-- ----------------------------
DROP TABLE IF EXISTS `ip_ban`;
CREATE TABLE `ip_ban` (
  `ip` varchar(32) COLLATE utf8_unicode_ci NOT NULL COMMENT '被禁IP',
  `bandate` datetime NOT NULL COMMENT '被禁时间',
  `unbandate` datetime NOT NULL COMMENT '解禁时间',
  `bannedby` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT 'GM账号',
  `banreason` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '禁止原因',
  PRIMARY KEY (`ip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of ip_ban
-- ----------------------------

-- ----------------------------
-- View structure for `view_web_select_lv`
-- ----------------------------
DROP VIEW IF EXISTS `view_web_select_lv`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_web_select_lv` AS select distinct `accounts`.`accounts_info`.`accounts` AS `accounts`,`godswar`.`character_base`.`name` AS `RoleName`,`godswar`.`character_base`.`fighter_job_lv` AS `F_LV`,`godswar`.`character_base`.`scholar_job_lv` AS `S_LV` from (`accounts`.`accounts_info` join `godswar`.`character_base`) where ((`accounts`.`accounts_info`.`accounts` = `godswar`.`character_base`.`accounts`) and (_utf8'' = _utf8''));

-- ----------------------------
-- Procedure structure for `SP_CREATE_ACCOUNTS`
-- ----------------------------
DROP PROCEDURE IF EXISTS `SP_CREATE_ACCOUNTS`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `SP_CREATE_ACCOUNTS`(IN Str CHAR(32), IN TheStrat INT, IN TheEnd INT)
BEGIN
     DECLARE  Num    int  DEFAULT 0;
     DECLARE acc CHAR(32) default "";
    SET  Num=TheStrat;
myloop: LOOP
      IF  Num>TheEnd  THEN
           LEAVE myloop;
      END IF;
     SET  acc = CAST( Num AS CHAR(32) );
     SET  acc=CONCAT(Str, acc );
      INSERT INTO accounts_info VALUES (NULL, acc, acc, '1', '2007-07-31 11:23:15', '2007-07-31 11:23:19', '192.168.1.101', '23565', '2545', '1');
      INSERT INTO gamearea_info  VALUES (NULL, 1, 0, acc, acc, null, 0,0);
      SET Num = Num + 1;
END  LOOP  myloop;
END;;
DELIMITER ;

-- ----------------------------
-- Procedure structure for `SP_SELECT_ACCOUNTS_INFO`
-- ----------------------------
DROP PROCEDURE IF EXISTS `SP_SELECT_ACCOUNTS_INFO`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `SP_SELECT_ACCOUNTS_INFO`(IN  Name CHAR(32) , IN cPassword  CHAR(32),IN cIP  CHAR(32))
BEGIN
     DECLARE  num  TINYINT DEFAULT 0;
     DECLARE  ban_account  TINYINT DEFAULT 0;
     DECLARE  ban_ip  TINYINT DEFAULT 0;

     SELECT count(*)
     FROM    gamearea_info
     WHERE   PassName = Name  COLLATE utf8_unicode_ci AND  PassPwd = cPassword COLLATE utf8_unicode_ci
     INTO     num;

     IF num = 1 THEN
          SELECT COUNT(*)
          FROM   accounts_ban
          WHERE  id = ( SELECT GID  FROM  gamearea_info WHERE PassName = Name  ) AND NOW()<unbandate
          INTO  ban_account;

          SELECT COUNT(*)
          FROM   ip_ban
          WHERE ip = cIP AND NOW()<unbandate
          INTO  ban_ip;
     END IF;
   -- SELECT 1,0,0;
     SELECT num,ban_account,ban_ip;
END;;
DELIMITER ;

-- ----------------------------
-- Procedure structure for `SP_WEB_SELECT_LV`
-- ----------------------------
DROP PROCEDURE IF EXISTS `SP_WEB_SELECT_LV`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `SP_WEB_SELECT_LV`(IN F_LV INT, IN S_LV INT)
BEGIN
    SELECT accounts,name,fighter_job_lv,scholar_job_lv
    FROM   godswar.character_base
    WHERE fighter_job_lv >= F_LV
    AND      scholar_job_lv >= S_LV
    ORDER BY accounts;
END;;
DELIMITER ;
 

Attachments

You must be registered for see attachments list
Last edited:
P

PIXEL3D

Experienced Elementalist
Joined
Jun 17, 2012
Messages
269
Reaction score
1
Sir can you rework on this game? :( i would like to set up a private server of this im willing to pay for the hosting
 
G

gchz123

Initiate Mage
Joined
Apr 9, 2020
Messages
3
Reaction score
0
Hello good night I have always liked godswar and I want to ask you please if you could give me the links of the game files to be able to remember what I lived years ago I will be very grateful
 
You must log in or register to reply here.

About Us

RaGEZONE® is a website dedicated to the development of massively multiplayer online role-playing games (MMORPGs).

Online statistics

Members online
189
Guests online
10,770
Total visitors
10,959
Totals may include hidden visitors.

Forum statistics

Threads
429,135
Messages
4,590,557
Members
280,884
Latest member
mudarck
Most visitors online was 11705 , on 26 Apr 2024

RaGEZONE Sponsor

    HyperFilter
Back
Top