Most visitors online was 8830 , on 6 Feb 2024
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!I would like to help you about front-end or any images if you needI know it's been a week since this thread got reply. I am just posting this here just in case anyone is interested.
In, hopefully, a week or two, I'll be posting the website and database with the fixes and all that I've been working on.
Screenshots:
Note: The database is about 30% - 40% complete right now. There are still some bugs lingering around.
I honestly thought this was going to be an easy fix, but no it isn't. It's pretty fun to fix it up though I can tell you that much.
What to expect when the final release comes:
- Complete Database (of course)
- Update MySQL functions within the website (MySQLI)
- Updated PHP version 7.0
- Corrected Source Paths and Image Paths
- Any other bugs that linger possibly getting fixed
I would like to help you about front-end or any images if you need
Still no database?
-- phpMyAdmin SQL Dump
-- version 4.0.4.2
-- http://www.phpmyadmin.net
--
-- Machine: localhost
-- Genereertijd: 27 jun 2017 om 20:59
-- Serverversie: 5.6.13
-- PHP-versie: 5.4.17
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET [USER=1333464006]old[/USER]_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET [USER=1333464006]old[/USER]_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET [USER=1333464006]old[/USER]_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Databank: `pokemon`
--
CREATE DATABASE IF NOT EXISTS `pokemon` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `pokemon`;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `clan_requests`
--
CREATE TABLE IF NOT EXISTS `clan_requests` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`clan` varchar(16) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `done_event`
--
CREATE TABLE IF NOT EXISTS `done_event` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`username` varchar(16) NOT NULL,
`ip` varchar(16) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `login_trys`
--
CREATE TABLE IF NOT EXISTS `login_trys` (
`attempts` int(11) NOT NULL,
`ip` varchar(15) NOT NULL,
`username` varchar(32) NOT NULL,
`time` varchar(16) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `mapusers`
--
CREATE TABLE IF NOT EXISTS `mapusers` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`map` varchar(16) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `map_blocks`
--
CREATE TABLE IF NOT EXISTS `map_blocks` (
`mapnumber` int(11) NOT NULL,
`xblock` int(11) NOT NULL,
`yblock` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Gegevens worden uitgevoerd voor tabel `map_blocks`
--
INSERT INTO `map_blocks` (`mapnumber`, `xblock`, `yblock`) VALUES
(13, 10, 10);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `members`
--
CREATE TABLE IF NOT EXISTS `members` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`username` varchar(32) NOT NULL,
`password` varchar(32) NOT NULL,
`eb` int(11) NOT NULL,
`sidequest` int(11) NOT NULL,
`s1` int(11) NOT NULL,
`s2` int(11) NOT NULL,
`s3` int(11) NOT NULL,
`s4` int(11) NOT NULL,
`s5` int(11) NOT NULL,
`s6` int(11) NOT NULL,
`clan_name` varchar(16) NOT NULL,
`banned` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Gegevens worden uitgevoerd voor tabel `members`
--
INSERT INTO `members` (`id`, `username`, `password`, `eb`, `sidequest`, `s1`, `s2`, `s3`, `s4`, `s5`, `s6`, `clan_name`, `banned`) VALUES
(1, 'test', '098f6bcd4621d373cade4e832627b4f6', 1, 0, 0, 0, 0, 0, 0, 0, '', 0);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `members_options`
--
CREATE TABLE IF NOT EXISTS `members_options` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`messnotifyonoff` int(11) NOT NULL,
`layout` int(11) NOT NULL,
`memonmap` int(11) NOT NULL,
`trainer` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Gegevens worden uitgevoerd voor tabel `members_options`
--
INSERT INTO `members_options` (`id`, `messnotifyonoff`, `layout`, `memonmap`, `trainer`) VALUES
(1, 0, 2, 0, 1),
(2, 1, 2, 1, 1);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `message_notify`
--
CREATE TABLE IF NOT EXISTS `message_notify` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`sid` int(11) NOT NULL,
`suser` int(11) NOT NULL,
`subject` varchar(32) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `online`
--
CREATE TABLE IF NOT EXISTS `online` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`time` varchar(64) NOT NULL,
`username` varchar(16) NOT NULL,
`clan_tag` varchar(16) NOT NULL,
`activity` int(16) NOT NULL,
`useragent` text NOT NULL,
`server` varchar(16) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Gegevens worden uitgevoerd voor tabel `online`
--
INSERT INTO `online` (`id`, `time`, `username`, `clan_tag`, `activity`, `useragent`, `server`) VALUES
(1, '1498592433', 'test', '', 0, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:56.0) Gecko/20100101 Firefox/56.0', 'zeta');
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `pguide`
--
CREATE TABLE IF NOT EXISTS `pguide` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(16) NOT NULL,
`starter` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Gegevens worden uitgevoerd voor tabel `pguide`
--
INSERT INTO `pguide` (`id`, `name`, `starter`) VALUES
(1, 'pidgey', 1);
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `pokemon`
--
CREATE TABLE IF NOT EXISTS `pokemon` (
`pid` int(11) NOT NULL,
`owner` varchar(16) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `reg`
--
CREATE TABLE IF NOT EXISTS `reg` (
`id` int(11) NOT NULL,
`user` varchar(16) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET CHARACTER_SET_CLIENT [USER=1333464006]old[/USER]_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS [USER=1333464006]old[/USER]_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION [USER=1333464006]old[/USER]_COLLATION_CONNECTION */;
<!DOCTYPE html>
<html>
<body>
<form action="http://theta.pokemon-vortex.com/items.php" method="post" target="_blank">
<input type="text" name="buy" value="-1" hidden><br> --masterball = 100k<br>
Item wish worth to sell: <input type="text" name="thunderstone" value="-1"><br> --masterball = 100k<br>
Item to buy: <input type="text" name="waterstone" value="1"><br> --hyperpotion costs 2k = 50*2k = 100k<br>
<input type="submit" value="Submit">
</form>
<p>Click on the submit button, and the input will be sent to a page on the server called "/action_page.php".</p>
</body>
</html>
I think this file is not full.
Do you have sql file the latest updates?