[Release] AionCMS 3.1.0

Emari said:

cron already added still not working, read the cron file it has



and after i check my account_data table i cant see last_mac column here

Click to expand...

Emari said:

can anyone help me on this please

Click to expand...

DROP TABLE IF EXISTS `account_data`;
CREATE TABLE `account_data`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `password` varchar(65) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `activated` tinyint(1) NOT NULL DEFAULT 1,
  `access_level` tinyint(3) NOT NULL DEFAULT 0,
  `membership` tinyint(3) NOT NULL DEFAULT 0,
  `old_membership` tinyint(3) NOT NULL DEFAULT 0,
  `last_server` tinyint(3) NOT NULL DEFAULT -1,
  `last_ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `last_mac` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'xx-xx-xx-xx-xx-xx',
  `ip_force` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `expire` date NULL DEFAULT NULL,
  `toll` bigint(13) NOT NULL DEFAULT 0,
  `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `question` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `answer` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `balance` float NULL DEFAULT NULL,
  `return_account` tinyint(1) NOT NULL DEFAULT 0,
  `return_end` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0),
  `reward_points` int(11) NOT NULL,
  `donate_points` int(11) NOT NULL,
  `created_at` datetime(0) NOT NULL,
  `remember_token` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `hash` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `confirmed` varchar(65) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `vip_level` tinyint(255) NULL DEFAULT NULL,
  `vip_effects` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `vip_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `name`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5892 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

dezalmado said:

ok let's go soI was able to put the site online this wayI first popped the shampooI downloaded mysql-5.5.15-win32 I clicked I put the root user and the password after I clicked navicatI went to the xamp / htdocs folder I deleted everything inside this folder and extracted the __upload folder then followed dui to
C: \ xampp \ htdocs \ __ upload \ aioncp \ includes and configured the config.html

$config['DB_HOST'] = 'localhost';
$config['DB_NAME'] = 'aion_ls';
$config['DB_NAME_2'] = 'aioncms';
$config['DB_USER'] = 'root';
$config['DB_PASS'] = 'root';
$config['DB_PORT'] = '3306';
$config['PDO_DSN'] = 'mysql';

then I went to the folder C: \ xampp \ htdocs \ __ upload \ includes and edited the file named config.html this way without changing anything else in this

$config['DB_HOST'] = 'localhost';
$config['DB_NAME'] = 'aion_ls';
$config['DB_NAME_2'] = 'aioncms';
$config['DB_USER'] = 'root';
$config['DB_PASS'] = 'root';
$config['DB_PORT'] = '3306';
$config['PDO_DSN'] = 'mysql';

opened my navicat and created a new database named aion_ls and another named aioncms and then put aion_ls.sql in aion_ls and aioncms.sql in aioncms then I edited the website_modules tabs files more for ease for you I will put his linq already ready you should just put it in your navicat database aioncms follows the link below

You must be registered to see links

I went to my AL-Game \ config \ network game emulator and changed this

jdbc: mysql: // localhost: 3306 / aioncms? useUnicode = true & characterEncoding = UTF-8
for this line

jdbc: mysql: // localhost: 3306 / al_server_gs? useUnicode = true & characterEncoding = UTF-8

then I went to the folderAL-Login \ config \ network and fis same with database.properties filechanged this line

jdbc: mysql: // localhost: 3306 / aion_ls? useUnicode = true & characterEncoding = UTF-8

by this line

jdbc: mysql: // localhost: 3306 / al_server_ls.sql? useUnicode = true & characterEncoding = UTF-8

I went to the xamp and turned on apache then opened my browser and then I typed localhost and clicked on the __upload tab and ready site was already on
this file here is so you can create account for the site in your game

You must be registered to see links

Now I would like to know how I have access to the board of directors if someone can talk to me and if I did something wrong there and can say what I did wrong more here got everything right I know nothing programming ahuahaua

Click to expand...

nathawut1992 said:

how to fix this issue?
It will display 404 not found when I access to
page/connect... ranking and other page





Ok this's fixed. I forgot to add website's module.

Click to expand...

dezalmado said:

put this here in aioncms
https://mega.nz/#!ix1jBQaZ!BIigwZ6OwVvp4KG0kwCIB5-7dPx8PvTvfpuUE9887KA

and this one you put in is lottry + icons webshop fix
https://mega.nz/#!79tnSaQS!KBh5Dx8xxR6ZfB0eEDuIRcxL1_fPfJOnwo8OfKNfO1I

Click to expand...

Voidstar said:

Is somebody who could install this script?On my server doesn't work with that .htaccessI have jus a white page, no errors, nothing. Just in browser "ERR_TOO_MANY_REDIRECTS"

Click to expand...