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!

Pokemon Vortex Source Code

Junior Spellweaver
Joined
Apr 25, 2011
Messages
153
Reaction score
37
I 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:
yLPVsiG - Pokemon Vortex Source Code - RaGEZONE Forums

d96c6Rw - Pokemon Vortex Source Code - RaGEZONE Forums

9LwINMV - Pokemon Vortex Source Code - RaGEZONE Forums

oPCRg3i - Pokemon Vortex Source Code - RaGEZONE Forums

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
 

Attachments

You must be registered for see attachments list
Initiate Mage
Joined
May 30, 2017
Messages
3
Reaction score
0
I 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:
yLPVsiG - Pokemon Vortex Source Code - RaGEZONE Forums

d96c6Rw - Pokemon Vortex Source Code - RaGEZONE Forums

9LwINMV - Pokemon Vortex Source Code - RaGEZONE Forums

oPCRg3i - Pokemon Vortex Source Code - RaGEZONE Forums

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
 

Attachments

You must be registered for see attachments list
Junior Spellweaver
Joined
Apr 25, 2011
Messages
153
Reaction score
37
Still no database?

Not yet. The official one isn't getting released, and the one I'm working on is about 60%. Still have some tables and bugs to fix. Plus atm I don't have access to my Desktop which has all the updated material for the next 3-4days.

I'm just going to release the database once it's done. The whole website itself is going to take a lot longer.


 
ThuGie.NL - Webmaster
Joined
Apr 16, 2006
Messages
607
Reaction score
55
Wow the code is a mess..
So making a database for this would be a pain and useless..

Code:
-- 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 */;

I started but did not finish to much pain..
Also not properly made was first thinking of getting it working then optimizing giving it a proper db.. but yeah dont even do it.



Also reported this to the owner of pokemon-vortex but refuses to fix it, saying its fixed in v4. no clue or info about when that comes out so abuse at own risk.

Code:
<!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>

So yeah if you check the source-code items.php you will see,
All the money is calculated together so if we do masterball -1 and then 50* hyperpotion we end at 0 for money and the code allows that,
After that it checks if the item is higher then 0 for masterball it does not so it does not update aka do -1 but for hyperpotion its 50 so it adds 50 hyperpotions.

you do not need to have the item that you are pretend selling.

This works for all items in the shop btw,
Till the max of 255 per item, make sure you calculate it correctly so it gets to 0 so it wont cost anything
going into minus with the value wont work. and if its like 1k higher you lose money.
i just bought 255 masterballs get every pokemon instant with 1 throw.. and finish game :p
 
Junior Spellweaver
Joined
Apr 25, 2011
Messages
153
Reaction score
37
I think this file is not full.
Do you have sql file the latest updates?

If you're talking about the source when you download it for the first time, then no it does not have an SQL; hence why if you check the comments they're asking for one.

If you're talking about the SQL above, no that one is incomplete. The one I possess is about 70%. It's just missing the tables in regard to the maps and the tabs on the left side of the website. Other than that it's just little small bugs left to fix here and there and it'll be complete. Since I made the database as I fixed the website, some values are incorrect; like a int being a varchar in the table for example, but that nothing that doesn't take more than a couple of minutes to fix.




Edit: I just got my Desktop back and will start working on the DB again tomorrow after work, I hope to be done with it by the end of the weekend.
 
Last edited:
Junior Spellweaver
Joined
Apr 25, 2011
Messages
153
Reaction score
37
Just to give y'all something to work with if you are interested, you can download the DB . Just know it's still only about 70 - 75 percent complete.

What you can do with this DB:
  • Sign up for account.
  • View your pokemon team
  • View all your pokemon
  • view your profile
  • Use the pokedex (incomplete I think since the website itself has a lot of errors so it's hard to tell)
  • Gives your pokemon (starters only) moves.
  • There's more, but I've been working on this on such an interval that I completely forgot.

This is only for development purposes and the complete one will still have to wait a little bit.
There are still some incomplete tables that I do eventually complete as I fix the website that's why you see it the way it is.

One thing you do need to know. When I release the database, it's only going to be 90%. Why? Because if you look at the tables Abilities and pguide, you will realize that you have to manually input all the pokemons (yes all 5,394 of them) moves (up to four), types (up to two) and abilities (up to three) and I'm not about to do that for you, I do not want to nor do I have the time. The only way to make it easier to create a program that takes the information from either the official pokemon pokedex or from some other website; I'm not gonna do that either. This one has the starters types input and only two with moves, I'm not doing more than that.

Aside from that, make sure to change the tables accounts and account_options to members and member_options. I changed those on my end since they made no sense..

In conclusion, give me a bit more time and it'll more Functionally complete, but again I am not gonna input 10788 entries into the database.

EDIT: So I decided to make a program that extracts the information you need for the pguide and ability table. I won't be releasing it unfortunately, just know it WORKS. It's just something I wiped up real quick in order to do what needs to be done. Btw it's only for the normal type pokemon, not for the Shiny, Mystic, or whatever this source has in it. Those you'll have to do on your own.

EDIT 2:
These Pokemon are not in the SQL, why? because they each have a weird error when being extracted, you can manually add them yourself though..two of them only have one attack and one type so yeah.

Exception List:
  • "Cosmoem"
  • "Cosmog"
  • "Tapu Fini"
  • "Tapu Bulu"
  • "Tapu Lele"
  • "Tapu Koko"
  • "Type: Null"
  • "Ditto"
  • "Flabébé"
  • "Mime Jr."
  • "Mr. Mime"
  • "Farfetch'd"
  • "Nidoran♀"
  • "Nidoran♂"

EDIT 3:
Here's all the pokemons (Normal/Dark/Metallic/Mystic/Shadow):
View attachment All pokemon (normal, mystic, etc).zip

EDIT 4:
I didn't want to bump the thread, so I'm just going to edit. So, pretty much what's left in the DB is to get the map working correctly (you can move around, but it basically kicks you out of your session for some reason), and battles which for some reason make you automatically beat them and all I did was create the tables...so it's pretty weird..hopefully it won't be much longer, and yes I added a lot of thing since the DB I release earlier.

What works:
- Pokedex
- your_profile
- messages (sending and receiving)
- Changing user/pass
- Signup is 100% now
- members tab ( to see who's online)
- Options tab is kind of buggy, but I didn't touch anything website wise so it might just be the table having an incorrect type.

What's left?:
- Battles (100%)
- Trading
- Evolve
- Change Attacks (I think)
- Buying Items' (50%)
- Clans? Not sure I have all the tables but haven't tested it out

Battle (50%) (Gym 50%):
zYlA38w - Pokemon Vortex Source Code - RaGEZONE Forums

Regarding the battles...there another annoying table that needs to be made...it has the the attacks pokemon can use along with their name, type, power, accuracy, and catagory (which idk what this is, but that's nothing that skimming through the code won't change)
 

Attachments

You must be registered for see attachments list
Last edited:
Junior Spellweaver
Joined
Apr 25, 2011
Messages
153
Reaction score
37
As of today, I temporarily have to discontinue working on the database due to work and educational reasons.
I will not leave y'all hang so I'll release what I have, and who ever wants to complete it can do as they please. This database is honestly not missing much to be completely operational.

What's missing:
- Items:
In the items table there are a items still missing from that, to add them in honestly not that difficult;
Just look at items.php and scroll down and you'll see an $_POST with a name inside it. Just take that name and add it into the items table as a column, pretty simple.​
- Attacks:
In the attacks table there are no attacks what so ever, this is because you need to obtain that information and input it in there for about 100+ attacks, I was, possibly will later on, creating a extract for that too, but for now you'll have to obtain that information yourself. My extractor is only about 50%
complete since it's missing the category and accuracy, which the only one proving difficult to extract is the category.​
- Gyms:
Okay. The Gyms DO work, but in order to actually battle them you have to go into the gym table and manually add the gym leaders pokemon using the id in the pguide table. I only did brocks to test it and it does work, but since battling is not 100% due to the attacks table being empty, you cannot actually beat the gym.​
- Clans:
The tables are made but I haven't bothered to actually test them, so you can do that.​
- Maps:
This one is a little confusing on my end since I updated everything to MYSQLI and it broke a couple of things, you are capable of moving about through the maps, but it doesn't allow you to capture pokemon.
This may just be on my end, but you can try and see if you can fix it. the tables are made correctly though so it might just be me.​
- Trade:
I haven't really bothered with this one, so there only one table made which I doubt it's complete.​

If there's anything else, I'll update this post.

Download Here:
 
Joined
Dec 27, 2007
Messages
22
Reaction score
0
Pokémon id on pguide has different id, this is noted in Maps

Pokemon id fixed, evolutions working and i can caught pokemon on maps e,e
 
Last edited by a moderator:
Back
Top