rpgmaker's Profile User Rating: -----

Reputation: 2 Apprentice
Active Members
Active Posts:
224 (0.17 per day)
02-October 11
Profile Views:
Last Active:
User is offline Apr 05 2014 05:02 PM

Previous Fields

Dream Kudos:
Icon   rpgmaker has not set their status

Posts I've Made

  1. In Topic: Programming a Pokedex pt. 2

    Posted 5 Mar 2014

    View PostKruSuPhy, on 03 March 2014 - 08:57 PM, said:

    View PostiLiTH, on 03 March 2014 - 09:10 AM, said:

    Hmm. To me it would seem smarter to migrate the database your using and modify it to have all types in the type field, explode the type field and print them all. On the other hand, to prevent that much work... I'm not yet experienced enough with PHP (or programming in general) to offer a better idea, but here's one option I can think of.

    class displayModule() {
       private $currentPokemon;
       private $previousPokemon;
       public function displayPokemon() {
          foreach(getPokemon() as $pokemon) {
             $this->currentPokemon = $pokemon;
             if($currentPokemon['name'] == $previousPokemon['name']) {
                echo $currentPokemon['type'];
             } else {
                echo $currentPokemon['type'] . $previousPokemon['type'];
             $this->previousPokemon = $pokemon;

    The database we're using is veekun's, which is an available pokemon database online. It's a pretty massive database, and doing that much could take hours/days from the way he's got it set up. Thank you, and the others who posted as well, for the suggestions, though. I'm going to try doing it using the JOINs, but if that doesn't work, I'll definitely just try doing it in PHP.

    I own a pokemon online game. I could send you my pokemon table. It has all the pokemon names types etc in.... 660 od rows. Its a mysql database so ull need to import it.
  2. In Topic: storing earnings inside php my admin

    Posted 1 Jun 2013

    I have fixed this by using 8,5
  3. In Topic: storing earnings inside php my admin

    Posted 1 Jun 2013

    Ok so i am storing users earnings that they have made in side my database i have the column set has decimal(5,5) It seems has soon has the vale hits 0.99999 it will not go any higher example over to 1.00000 i am doing a simple update

      $fdfsdfdsfsdf = mysql_query("UPDATE users SET available_earning=available_earning+0.00002 WHERE id  = '".$owner2."'")
    or die(mysql_error());

    The update works in till the earnings get up to 0.99999 then stops. Any idea's what i can do ?
  4. In Topic: Editing 300 rows at once

    Posted 25 May 2013

    View Postandrewsw, on 25 May 2013 - 12:07 PM, said:

    It might be something like

    UPDATE `user_pokemon` 
    SET `name` = REPLACE(`name`, 'shiny', '') 
    WHERE `name` LIKE CONVERT( _utf8 '%shiny%'
    USING latin1 )
    COLLATE latin1_general_ci

    but you'll need to account for different casing (the COLLATE takes care of this in terms of the search), the word being embedded in another word, extra spaces being left behind.

    If 'shiny' only occurs at the beginning then you should use 'shiny%' rather than '%shiny%'. 'shiny %' may also be preferable.

    Thank you that worked like a charm.

My Information

Member Title:
D.I.C Head
Age Unknown
Birthday Unknown

Contact Information




rpgmaker has no profile comments yet. Why not say hello?