Jump to content

  • Log In with Google      Sign In   
  • Create Account

JinixVomitorium

Member Since 30 Dec 2012
Offline Last Active Jan 14 2013 06:14 PM

Topics I've Started

Quest systems for database?

12 January 2013 - 07:44 PM

I am in the last stage of my database development and need to create a quest system for an MMO-RPG, which is the one thing i have never done before... 

 

So far the only way i can think of to do this is to have a table with every quest conversation/achievement which is linked through to the next part in the quest. along with a link to my npc table of which npc the quest is selected from. 

How would one go about keeping track of what quests the character has completed? would it require a quest sheet (bool variables for each quest) for each character?

 

ex:

 

npc----

-map_id //which map the character is on

-quest_id //linked to npc when talked to , displayes message

//other stuff for npc

 

quest---

-quest_id 

-quest_message

-quest_rewards

-quest_next //linked to npc which holds the next quest part

 

completion_sheet

-(lists all quest ids and holds 1 or 0)

 

so, when i talk to npc it checks to see if completion sheet for the quest id is already done, then if it is, nothing happens, else, it calls the quest message and displays it, then you find the next guy and get the reward... Does it make sense? How would I keep up with say... killing a specific number of monsters or collecting something?


[solved]Errors: a little bit of php/sql?

11 January 2013 - 06:47 PM

$sql=mysql_query("SELECT * FROM player WHERE player_name=".$POST['char_name']."");
if( mysql_num_rows($sql) == 0 ) {
$sql=mysql_query("INSERT INTO player(account_id, player_name) VALUES(".$_SESSION['id'].", ".$_POST['char_name']." ) " ) or die (mysql_error() );
exit();
} else { 
echo 'Character Name is taken, please try another...';
}
 
 
Im getting these errors:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in/www/zymichost.com/g/a/l/galaxy-star-games/htdocs/play.php on line 9
Unknown column 'vortex' in 'field list'
 
Im not too sure the sql query is correct, i get confused when combining the string and such with different quotations. Unknown column i believe is referring to the insert of $_POST['player_name'] but not sure.
 
if anyone can shed some light on these errors, i would be appreciated!

Java images?

05 January 2013 - 12:49 AM

What is wrong with this?

 

   public void paint(Graphics g) {
      
        guiLayout = getImage(getCodeBase(), "gui.png");
        
        //Object .paints
        g.drawImage(guiLayout, 500, 300, this);
        
    }

 

As far as I can tell the code is correct, there are no errors and the applet runs, but it doesnt display the image...

I've tried several methods to display the image, its weird that none are working now when they worked yesterday with a different image.  -____-


Introduction

30 December 2012 - 12:19 PM

Hey guys, Im Dan, 22.

I've been coding for 9 years, vritten a few basic games and loads of other programs, and am looking to meet some new associates to complete projects with. If ya want to work with me, add me on skype or post here.

skype: daniel.lamonds

 

Languages and other stuff:

C++

Visual Basic

Fortran

SQL

HTML/5

CSS

PHP

Java Script

Adobe Flash

Photoshop/gimp

various game engines

various operating systems

very good technical skills / trouble shooting / problem solver

 

I am currently planning a text based MMO style browser game.


PARTNERS