Custergrant

Hey guys! I've been conducting some research over the last couple of years and have come to a phase that I need to put up an online instructory course. It's hardly a website, but it'll consist of a text box where users are to write a sentence provided to them and while they type, as the keys are pressed, corresponding .wav files will play. Much like a keyboarding class, a set of sentences and sounds have already been pre-made to specifications...I've been told that I need to do this in Flash, but I don't know any whatsoever. It's a very simple project with all of the raw material made, I just need someone who can put these together, a simple key-action command. Would anyone be willing to do this? I'd gladly put you in the research.

Well, if you know where to look, you can get any of those for either free or a very low cost. I've pondered free energy all of my life and have always been really into it. I really don't have a favorite for an alternative, like most people you talk to do ("yah, fuel cells will never happen"..."solar is way too inefficient"..etc..,etc..). I'm more into the inventive spirit of it.It's really just a matter of doing it. I know I'm currently working on a research prototype that I'm building using laminated solar cells put onto a parabolic dish (like the old satellite dishes). These PV (photovoltaic) cells turn light and UV light into electricity. The reflected light and infrared (heat) get focused onto a focal point where a hybrid Stirling engine and thermal fuel cell sit, which in short, is like your car engine, but just one piston in a closed cycle where the hot air is by itself. This little contraption alone gets like 74% efficiency, which is the highest of the solars. There's energy all around us, but the problem that we have is that we must direct it in some form in order to gain from it, such as in the case of heat (easier to understand). I live just a few minutes from a huge dam and it works well too. Just a matter of how you use it.EDIT: Someone mentioned using energy from our minds....actually, in terms of joules and other units, our minds really don't generate that much energy...it's more small and many type of arrangement. Not taking the resistance of the skin into matter, humans generate a very small charge, and another way to think of it is in calories. If you were to eat someone's brain (I know, I know), you might get a max of 1000 kilocalories out of it, while a lot, that's all it has grown since its creation (like a tree). A tree might generate a lot of sugar from photosynthesis per day, but when you look in retrospect, it takes a long time for that sugar to be put into the cell growth and grow a tree (takes trees a long time to grow). If that made any sense, then I'll be surprised.

I thought that would work too, but I had already tried it and nothing. I still get the extra rows. It is completely boggling my mind as to why this is happening. I've printed both arrays and they're handling just fine, but I can't understand where these 1's are coming from.

Sorry for the double post. I got the problem above fixed, finally, and it's working just smashingly. I used the join below to fix it: $sql = ("SELECT * FROM user_resources JOIN resources ON user_resources.resource_id = resources.ID WHERE user_resources.user_id = $userid ");$result = mysql_query($sql) or die(mysql_error()); And then simply fetched an assoc array on it and printed the corresponding data that I wanted. Now that was for my resources table, but I've moved onto a couple more tables, and I'm having a problem with my buildings. I coded it perfectly I thought, and when I load the page, it says the data it should, but it has even more now. I'm creating a table with the building name and the amount of that type of building. And right now, in my test account, I just have one building. So it should be just "1 Papermill", which I get, but then I get additional columns with just ones in it... And I don't understand. I just now put an additional condition for the selection for where the building name cannot be null, but I'm not sure why it is doing this. //Begin Buildings Table$ubuildings = ("SELECT * FROM user_buildings WHERE user_id = $userid AND building_id != NULL ");$resultb = mysql_query( $ubuildings ) or die(mysql_error());$infob = mysql_fetch_assoc( $resultb );$buildingid = $infob['building_id'];$buildings = ("SELECT * FROM buildings WHERE building_id = $buildingid ");$resultc = mysql_query( $buildings ) or die(mysql_error());echo ("<center><h1 style='font-size:150%'>Buildings</h1><table></center>"); while($infoc = mysql_fetch_assoc( $resultc )){ echo "<tr>"; echo "<td>".$infob['amount'] . " ".$infoc['name'] . " </td> "; } echo "</font>";echo "</table>";

I need help on a join, I think I have it mostly done, but I know my syntax isn't right. First off, to give you an idea, I have two tables, plus my session variables. I'm first selecting from the table: user_resources where the user_id = that of the $_SESSION's, and in user_resources, there are three fields, user_id, resource_id, and amount, and I wish to print all of this. But the hitch to it is, resource_id is an integer. In another table called resources, are the fields id and name. The resource_id = resources.id, and I want to print the name associated with that id... So this is the current code that I have now (I've tried thousands of combinations it seems like): //Begin Resources Table$query = mysql_query("SELECT * FROM user_resources, resources WHERE ". $_SESSION['userid'] ." = user_resources.user_id user_resources JOIN resources ON user_resources.id = resources.id") or die(mysql_error()); echo("<br><br><br><center><b>Resources</b><table border='1' bordercolor='black'>");while($info = mysql_fetch_assoc( $query )) { echo "<tr>"; echo "<th>Name:</th> <td>".$info['amount'] . "</td> "; echo "<th>Amount:</th> <td>".$info['name'] . " </td>"; } echo "</font>";echo "</table>"; As you can see, all I wish to show is the amount of resources by its name. But I'm not sure how to get all of that in one query. As a review on the tables: user_resource.user_id = $_SESSION['userid'] user_resource.resource_id = resource.id And then I want the name and amount from user_resources. I know, not hte best list in the world, but it gives a good idea of what I need. If anyone could help me out on this code snippet, it would be very much appreciated. I've spent over 3 hours on this so far and about to lose it if I can't figure this out.

Okay, I've modified the session.php that you've sent to fit my site, and I can successfully login to my members page. But, I came across another issue and I'm not exactly sure how to approach it, I have a good idea, but thought it would be good to check with you guys (still a hair confused with sessions ). I had a couple friends of mine login using my test account to make sure that the page was displaying properly in different browsers and one of my friends just copied and pasted the url to the members page and was able to view the page just fine, but had a warning about the session.php and it's function. Anyways, what I could make out of it, was that as long as you had the session started on your computer, you could just get right in, and that the same account could be logged in by multiple computers (there were 3 of us at the same time under the same account). So I need to write a piece of code to limit the number of users able to login to one account to 1 and then, if they should exit the page, it logs them out... Here is the session.php that I modified: <?PHP//include in all files to check session and loginsession_start();require("configure.php");//check session statusif($_SESSION['logged'] != "1"){//bad session, kill itsession_destroy();} else { // SESSION GATE//check login details against table$user = $_SESSION['username'];$pass = $_SESSION['password'];//connect $link = mysql_connect($dbhost, $dbuser, $dbpass) or die('Could not connect: ' . mysql_error($link));//select databasemysql_select_db($dbname, $link) or die(mysql_error($link));//check details in the DB$result = mysql_query("SELECT * FROM users WHERE username='$user' AND password='$pass'",$link) or die (mysql_error());$row = mysql_fetch_array($result,MYSQL_ASSOC);//check details from session and DBif($user == $row['name'] && $pass == $row['pass'] && $row['userlevel'] == 1){ //if user is correct then login must be true $_SESSION['logged'] = "1";}else{ //if user is not correct send error message to main page $_SESSION['error'] = "1"; $_SESSION['message'] = "Sorry there was an error with your login details, please <a href=login.php>try again</a>";};}; // SESSION GATE ELSE//if we get this far then they are logged in and can see the page below! Yay!?> And all that I've been putting on my members page at the very top is require <?php ('session.php'); ?>

Hey guys, I'm currently trying to count a number of rows in a table and then echo it out as the number of players in my game. I've checked the SQL sites and I'm following proper syntax and everything. But when I view the page, I get 'Resource id #11', and not 3 like it should be... Below is the code: <?php//connectionrequire ("../session.php");require ("../configure.php");mysql_connect ("$dbhost", "$dbuser", "$dbpass")or die("Could not connect: ".mysql_error());mysql_select_db("$dbname") or die(mysql_error());$query = mysql_query("SELECT COUNT(userid) FROM users") or die(mysql_error()); echo("<center><h1>Welcome ".$_SESSION['username']."</h1></center><br><table><tr><td>Number of Players</td><td><td>$query</td></tr><tr><td>Game Hour</td></tr></table>");?> Maybe I should fetch an array, but the $query code should be executing, and I believe it is, because I'm getting the resource id, but it's not in the format it should be. Any of you have suggestions?

Os,I just started learning PHP and SQL to make my online game, but I would suggest using SQL, just because it's actually a rather simple language in my opinion and is great for storing information. But it really depends on what you're using it for I guess.

Okay, I completely forgot about the session.php you sent me and was spending half a day trying to come up with my own gate. Great, I think this form will work, although, why do you have the $link in so many times? You've already connected to the database it appears, but I guess it'll work. But you're saying I need to define the $_SESSION['logged'] = "1";$_SESSION['username'] = $username;$_SESSION['password'] = $password; in my login.php? So then in the future members pages, it can call of those variables?

Okay, well, I'm using a subdomain here, so can I still use that account on the link below you gave me?Otherwise, I can just transfer everything to my hotmail account, which isn't too bad, I suppose.

Hey guys,I love how I have sendmail and my own email account here, but I don't know how to access them. When I created my account, I put in my home email address because that's supposed to be there. But instead of having my users email me at my home email account in my contact form, I would like to have them email me here at Xisto. I went into my Email Management and saw Add/Remove Email and created one called Custergrant@custopoly.trap17.com...and it created correctly and all. But if I have users email at this, how do I read it? Do I click Read Webmail? And how do we get accounts at this SquirrelMail and Horde? I'm very confused about this, so if anyonce can help, it'd be greatly appreciated.

Sorry for the double post.. Chris, I just redid my buildings table and I'm going to try to explain the 'useless' ID field that I was talking about on MSN. First, I agreed that I just need one table for buildings, so I just kept the buildings table with the fields of id, building_id, name, cost_type, cost_restype, and cost_amount. I thought about just making a field for cost type, cost amount, input type, input amount, and so on, but it would really cause some duplication problems, and the cost_type system really makes it easier, because you can simply give it a number (0, 1, or 2) and that defines cost, input, or output. So my create table code looked like this: CREATE TABLE buildings( id INT AUTO_INCREMENT PRIMARY KEY, building_id INT, name VARCHAR(255) cost_type INT(1), cost_restype INT, cost_amount INT); Notice the first field of id, it's auto_inc and also the primary key, and it's also a completely useless field in terms of data, but it's the key to making these types of tables fit together. Anyways, I'll explain its role after I explain the actual data insertion: -- Iron Mine, Cost, 500 Lumber 1000 Stone 200 Coin, Produces 25 IronINSERT INTO buildings (building_id, name, cost_type, cost_restype, cost_amount) VALUES ('7', 'Iron Mine', '0', '8', '500');INSERT INTO buildings (building_id, cost_type, cost_restype, cost_amount) VALUES ('7', '0', '24', '200');INSERT INTO buildings (building_id, cost_type, cost_restype, cost_amount) VALUES ('7', '0', '2', '1000');INSERT INTO buildings (building_id, cost_type, cost_restype, cost_amount) VALUES ('7', '2', '7', '25'); That's a typical insertion command for one of my buildings. I have the comment with the name and statistics just for quick reference on my part. So on the first line, I'm inserting the building_id, name, and so forth. The building_id for this building is '7', which is consistent throughout this. I inserted the name, and a 0 for the cost, and an 8 for a resource type (Lumber) and an amount, 500. Now I can move onto the 1000 Stone, and instead of having to add extra fields or face duplication error, I just make another row, and it won't duplicate because the field 'id' is the primary key and it's on auto_inc, so I can simply put in the building_id to match it back up to it's proper building and keep on inserting the data for that table. And I've actually used this 'useless id' field in A LOT of my tables, because there is usually more than one line of data for the stuff I'm putting data in for, and instead of making these huge complex tables, just make some extra rows and it's all there. All you have to do is select the data where the 'real' id = whatever. I'm not sure if most people do this when they make MySQL tables, but I was pretty well new to it and this really made a lot of sense to me and makes it much easier to store data. But Chris, is this a better layout for the buildings?

Okay, thanks! I'll try this out and modify it to fit my site. But I notice the 'logged'...where do I define that at in my login.php?

Okay, I just got all my site stuff transferred over to Xisto, so I'm ready to resume coding. I'm currently working on my members' pages, and wish to use the PHP Session tags and include it in a function so that on every page, I just include the function to check and see if that user is still logged in and is allowed to view that page.Somebody told me I need to use the isset( blah blah blah and check to see if they were logged in from the login page (not sure how to do that), then query the $_SESSION['username] so I can check the 'userlevel' to check if that person is permitted to be there, but I'm not sure how to do that all inside of a function...

Hey, thanks for the reply, I'm probably going to contact you here in a minute. For the sake of making this post more readable, I capitalized all of my fields and tables, they're all lower-case and plural at the moment. :DI hear you completely on the buildings and cost tables. The big problem is, it would cause duplicate entries, because one building may cost 100 Stone, 100 Lumber, and 100 Coin, unless I make an extra ID field with auto inc and then just make sure every row that includes those cost links up to its proper building_id...Okay, so you think I should keep user_resources and user_buildings seperated and not make just one table for every user...and I hear you on the modification part, but I really can't see any modifications at the moment, else, it would have to update the building's input and output...which would require even more work.

Yah, I used to play Travian. I would need an update system close to that. Do you have MSN?

Okay, I posted a brief description of this in the PHP section, but I'll summarize myself again.I'm creating a PHP based game that is an economy game, where you start out with so many resources and a building, and you expand your business empire by building more buildings, which puts out more resources, and you can buy and sell on the market and whatnot. In the end, you try and become the wealthiest player in the game.Now I already have most of my database in MySQL set-up. But I've been told several different things on my structure and wanted your guys' opinions. First, the main tables that I'm questioning are my users' tables. I have a table for resources, that holds ID, Name, Market Buy Price, and Market Sell Price, and that's no problem. Then I have a Buildings table that holds ID and Building Name. Then I have a Cost table, which is an addition to the Buildings table, and has Building ID, Cost_Type (defines whether the row information is a cost, input, or output), Resource_Type (ID of resource) and Resource_Amount (Amount of that type of Resource).Then, I have a Users table that holds ID, Username, Password, Email, and Userlevel. Now comes the part that I need help with. I have a Users_Buildings table and it just holds the user's ID from the users table, building_id, and the amount of that building. So when I call up in a script how many sawmills a particular user has, I would call up his User_ID and select all of the rows which has that ID in Users_Buildings and the Building_ID = the sawmill's ID. The same format goes for my User_Resources table, which holds a User_ID, Resource_ID, and Amount.Now a lot of people have told me I should just create a new table everytime a user registers called that user's ID and store all their building and resource information in that one table...I'm really confused as to what I should do and as I'm about to move over to this free host, I probably should change the format now if I am going to. So do any of you have any advice?

Hey guys,I'm currently making my own online PHP game, and I'm smack into the middle of the coding. The game is an industry/economy type game where you start out with some initial resources and a building and you expand your business empire by building more buildings that produce more buildings, which can be bought and sold on the live market. Basically, you try and become the wealthiest player in the game by the time the round ends.My problem is, I need my game to update hourly and not hourly. Meaning, I have codes that update my MySQL database when a user buys or sells and makes transactions in my game. But, every hour, I would like my game to update the users resources with the output that their buildings are creating. If that's a little confusing, it's like a user has a Sawmill that uses 50 logs/hour and puts out 25 Lumber/hour.I already have a table in my database that has the inputs and outputs/hour for the different buildings, but I need a way to update that into the users' resources. How would I go about doing that? Someone mentioned a cron job, but I'm not too sure.

Hey, great tutorial! I'm attempting to convert a forum game into a PHP game, and thanks to this guide, I'm not quite as scared about it as I was!