Newbie Spellweaver
- Joined
- Nov 12, 2008
- Messages
- 36
- Reaction score
- 19
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!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
can anyone help me on this please
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;
Can you share again the sql file so I can create account?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
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.
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
Write to Lautaro's discord, he's very kind for helpIs 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"