• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

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
228
Guests online
10,276
Total visitors
10,504
Totals may include hidden visitors.

Forum statistics

Threads
429,198
Messages
4,590,913
Members
281,305
Latest member
ismodev
Most visitors online was 12720 , on 2 May 2024

RaGEZONE Sponsor

    HyperFilter
Back
Top