Jump to content
xisto Community

vujsa

Members
  • Content Count

    1,008
  • Joined

  • Last visited

Everything posted by vujsa

  1. Well, my first suggestion is for you to visit the radio manufacturer's website and try to get a wiring diagram. You also may be able to find a wiring diagram for your vehicle online as well but it is more likely that you'll need an auto repair manual for your model. Do an online search of your public library, they may have such a manual at one of the branches near you. As for what you actually have on the radio: The two jacks are either for output to an amplifier or input from a cd-changer. 8 wires for speakers: (Possibly green/green and green/white etc...) (+) and (-) for Right Rear (+) and (-) for Left Rear (+) and (-) for Right Front (+) and (-) for Left Front ACC may be your positive power lead from your accessory switch on the key switch or could be power out to an accessory like a cd-changer. Mute is probably for a cell phone option which mutes the radio if the phone rings. B Remote is difficult to say what it does but it could be for power antaneas And Backup may be for the clock which is a "HOT ALWAYS" connection to the electrical system. I guess maybe this has given you more questions than answers. vujsa
  2. vujsa

    Generate?

    Well, assuming your drop down menu is named "age" and the input name is "city", the PHP required to generate the text would look something like this if you used the "POST" method for your form: <?phpecho "Your age is $_POST['age'] and you live in $_POST['city']!";?>That would produce this:Your age is 5 and you live in Seattle! Hope this helps, vujsa
  3. vujsa

    Generate?

    What in the World are you asking about. I was half tempted to just delete this topic due to its short incoherent nature. If you want help with something, you have to explain yourself. For example, what might you have in this drop down menu and what might the user type in the input box? Given the selections and data from the user, what kind of text might be generated? For example, if you had a DAY, MONTH, and YEAR drop down menu and asked the user to input his FIRST NAME and LAST NAME; are you expecting the text generator to produce something like this: "Hello John Doe, you are 25 years old!" See how it is difficult to understand what you want? vujsa
  4. The related topics lists has your post about PHP Designer 2006 in it. Kind of wish I had done a search now. http://forums.xisto.com/topic/88099-topic/?findpost=1064334051 Are you using the personal or professional version of 2007? I think maybe I'll give it a go and see for myself. I hope that the file system and FTP features are more user friendly now. Thanks for the reply. mshmsh2010, I'm guessing that English isn't your native language. While a website can be written entirely with JavaScript, I do not recommend it! It is about 100 times harder that way and not a standard method of web design. JavaScript should only be used to add a dynamic touch to your website and make it easier for your visitors to use. Use HTML or XHTML to create your website! PHP is a powerful scripting language that can be used to generate the required HTML to create a website. It is not an easy undertaking learning and using PHP to develop an entire website but if you are motivated, it is possible. As for doing a summary and evaluation for each language, I don't know most of them well enough to do such a post and I also don't have the time to tackle such a large endeavor! I can barely keep up with all of the changes with HTML, PHP, MySQL, JavaScript, AJAX, CSS, and XML that I have to work with to maintain my website and develop new scripts. My suggestion to you, determine which language is the most common and try to learn that. You will always have to know HTML so start with that. vujsa
  5. I've started using PHP Designer 2005 recently but am having trouble getting used to it. Until then, I just used CuteHTML which wasn't very powerful but was easy to use. Since it was designed to edit HTML, it always wanted to save or open files as HTML. Got a little frustrating always having to select the "All Files" option on the file browser window. However, I really like the program and have gotten used to using it's features. What I really wanted was a program that will colorize syntax based on the type of language I am using, built in FTP, and a more powerful search and replace function. While all I really need is a program that shows me line numbers and a basic search and replace feature, I want to make programing a lot easier for my self. I downloaded PHP Designer 2005 when it was new. I ran it that day of course but quickly realized that I preferred CuteHTML. At the time it didn't make much sense to me why some of the features were included. For example, why would you use the "function" insert feature. All it does is input the following: function{}Seems to me that it would make sense for it to request the function's name and any parameter you wish to include. But there are a few handy items built into the program like the ability to organize your project files. However, it doesn't make sense that you have to manually add folders if your file structure is already in place. It seems like you should be able to import an entire file structure and that you should be able to save the entire project and all of the files would be saved in their correct folders etc... Another issue I have with this program is the FTP feature. I don't understand why it is so hard to upload. There isn't a drag and drop feature and again, you can't manipulate entire folders! You have to have the folders already on the server or create them before you can upload to them. My regular FTP client you can upload an entire website by just dragging the top level folder over to the server. Seems like a file sync feature is what this program really needs but they didn't ask me. I am getting used to using the program and that there are a lot of useful features like a built in PHP help system, a debugger, and an output display. However, you have to install PHP, PHP Help File, MySQL, and probably Apache for this to be used. Any other web services you wish to use in your project will also need to be installed for debugging and output display. It is really nice having your parenthesis, brackets, and curly brackets highlighted together. That way you can always see which if any bracket belongs to the one you selected. Makes finding a missing end bracket simple. The ability to quickly switch between open files is very good and shares that attribute with my other HTML editor. There are a number of features that I am sure I just haven't found yet but I am becoming more familiar every day. Perhaps when I learn how to fully utilize this software, I'll be as happy with it as I am with CuteHTML. I did go to the website today to check on updates and found that they have two versions now. The professional version promises to be all you'll ever need and more while the personal version is the same with a number of features removed. So my question is, has anyone used either PHP Designer 2007 Professional or PHP Designer 2007 Personal and are they any good. Is it worth buying the professional version or is the free personal version good enough. The reason I ask is because I am finding that I spend much more time writing PHP code than I used to and the number of requests I am getting for more scripts is increasing all of the time. I think right now, I have 12 or more pending or in development projects. I need software that will help me develop new script more quickly. Of course, the other question I have is, should I just stick with PHP Designer 2005? Thanks for your input, vujsa
  6. Yeah, I got a lot of complaints for the previous template set. I wish I had time to develop more of those free scripts! I have about 4 requests pending right now for free Joomla SearchBots. I just haven't had the time to develop them yet. They aren't hard for me to write but it takes a lot of time to write the database queries since that is the main part of the script. They used to be a lot easier for me to write before I added a bunch of features to them which requires a variable query string. I also need time to find and list resources for all webmasters. I offer a number of tutorials, functions, scripts but I still need to offer a decent link index and articles that help webmasters beyond the realm of PHP. Another section that I need to develop better is the "unasked" question system. I had started analyzing each of the search engine queries for my website trying to find new topics to discuss. I get the search engine hits that don't actually match any content on my website but is obviously related enough to get Google to send the user to me! I had hoped that I could try and figure out that the user was looking for and write an article that would have answered their question. Other than that, I know that I have a few dead links that I need to fix after my last big upgrade. Not only did I upgrade Joomla, I upgraded to a different but based on the same forum system. As a result, some of the links to articles in the forum no longer work since the forum component is different now. If anyone else as any input let me know. vujsa
  7. I just wanted to invite everyone to stop by again and give any fresh opinions. It has been a year since someone last reviewed the website and I hoped that now that I have made template and layout changes, I might get some feedback as to what I should work on next. http://forums.xisto.com/no_longer_exists/ Thanks, vujsa
  8. Thanks for the information. I'll check it out and see if I can clean it up enough for a general purpose MySQL class.The best part about using such a class is even if I find a better one later, I should be able to replace the one I'm using now with little trouble. I mean, since I only want the class to return an array, TRUE, or FALSE with an error; the method by which the class gets it's out put isn't as important.So while I investigate better class options, I think I'll begin work on the project that will use the class I am looking for. Since the project is meant to only be a demo and I'll have to make a pitch to "sell" it, I don't want to get too wrapped up with one little class that could be replaced later.The project is a data manipulation system for maintaining a number of records on a daily basis. Due to a number of factors, it will mostly be proprietary but the database class can be very general as long as it works exceptionally well!So, I'll look into the MediaWiKi database class. I guess that there are a number of really good open source projects out there that would use such a class but It'll take time to find the most suitable one.vujsa
  9. Well, I started modifying one of the scripts I found to do the job. The first thing I did was strip out all of the excess code. Much of the code seemed to be for features that would only be used if you wanted to create an system like phpMyAdmin! I didn't see any reason to leave the code to do SHOW, DESCRIBE, and EXPLAIN. Also, I didn't need a database create option nor a database select option. I removed about 50 lines of code and added error checking for DELETE, INSERT, and UPDATE. It isn't the best possible class I could come up with I'm sure but it looks like it will work for now. I thought about doing the class for PHP 5 using the mysqli functions but it seems that support for that is somewhat limited and I can't say for sure what MySQL and PHP versions the script may end up on. The mysqli extensions seem to be a lot easier to manage but that'll have to wait until I get more time. I guess it would be best if I wrote both then had the master script choose the best class for the server settings like Joomla does. Incidentally, I got the base code from here: http://www.jemts.com/?pl=scripts&pg=dbclass Note the following statement: Here is what it looks like now: <?php///////////////////////////////////////////////////////////////////////////////////////* DBClass v1.3 written by Matthew Manela Script orginally written for http://www.jemts.com/ Copyright (C) 2003 Matthew Manela. All rights reserved. See readme file for instructions on implementing and using this class. If you have any question about this script please email me at jemts@jemts.com. Updates to this class will come regularly. */////////////////////////////////////////////////////////////////////////////////////////Start of classclass Database{ var $DBname, $DBuser, $DBpass, $DBhost; var $DBlink, $Result; var $Connection; ########################################### # Function: Database - constructor # Parameters: database name, database username, database password, database host # Return Type: boolean # Description: connect to database, and select database, if database doesn't exist create it and selects it ########################################### function Database($name, $user, $pass, $host){ $this->DBname=$name; $this->DBuser=$user; $this->DBpass=$pass; $this->DBhost=$host; if(!($this->DBlink = mysql_connect($this->DBhost, $this->DBuser, $this->DBpass))){ echo mysql_errno() . ": " . mysql_error() . "\n"; trigger_error ("Cannot connect to database", E_USER_ERROR); return FALSE; }else{ if(!mysql_select_db($this->DBname,$this->DBlink)){ echo mysql_errno() . ": " . mysql_error() . "\n"; trigger_error ("Cannot connect to database", E_USER_ERROR); return FALSE; }else{ return TRUE; } return TRUE; } }#end of database constructor ////////////////////////////////////////////////////////////////////////////////////// ########################################### # Function: Disconnect # Parameters: none # Return Type: boolean # Description: disconnects from database ########################################### function Disconnect(){ if(mysql_close($this->DBlink)){ return TRUE; }else{ echo mysql_errno() . ": " . mysql_error() . "\n"; trigger_error ("Cannot close the database", E_USER_ERROR); return FALSE; } }#end of disconnect ////////////////////////////////////////////////////////////////////////////////////// ########################################### # Function: Query # Parameters: sqlstring , type # Return Type: Either boolean or array depending on type of query # If it is a delete query returns number of rows affected # Description: executes any SQL Query statement ########################################### function Query($Query){ $Query = trim($Query); if(eregi("^((SELECT))",$Query)){ if($this->Result = mysql_query($Query,$this->DBlink)) { while ($row = mysql_fetch_array($this->Result)) { $data[] = $row; } mysql_free_result($this->Result);//probably not needed return $data; }else{ //no entry exists in database return FALSE; } }else{ $result = mysql_query($Query,$this->DBlink); if(!isset($result) || is_null($result)){ echo mysql_errno() . ": " . mysql_error() . "\n"; trigger_error ("Query did not succeed", E_USER_ERROR); return FALSE; } elseif(eregi("^((DELETE)|(INSERT)|(UPDATE))",$Query)){ if(@mysql_affected_rows() < 1){ echo mysql_errno() . ": " . mysql_error() . "\n"; trigger_error ("Query did not succeed", E_USER_ERROR); return FALSE; }else{ return @mysql_affected_rows(); } }else{ return true; } } }#end of query function}#End of class?><?php$database= new Database("DatabaseName","DatabaseUser","DatabasePass","DatabaseHost");//$rows = $database->Query("INSERT INTO jos_jstats_iptocountry (IP_FROM,IP_TO,COUNTRY_CODE2,COUNTRY_NAME) VALUES ('321321','321321','RR','Whatever')");//$rows = $database->Query("DELETE FROM jos_jstats_iptocountry WHERE IP_FROM = '321321'");$rows = $database->Query("SELECT * FROM jos_jstats_iptocountry");echo "<pre>";print_r($rows);echo "</pre>";$database->Disconnect(); ?> Actually, there is a large number of classes written for this subject but I don't have the time to download, review, test, and play around with each one. For the quick list: http://forums.xisto.com/no_longer_exists/ Do you have any suggestions? Thanks for the reply. vujsa
  10. Generally speaking, when I write a script, it either utilizes the MySQL class of the parent system (like Mambo or Joomla) or I use basic functions and snippets to perform the database queries I need. I really like the Joomla database class as it allows you to simply pass a regular query string to it and the data is returned without the need for extra work! The Invision Power Board (IPB) database class which is what is used for this forum is kind of a pain to use since it wants the query string in a non-MySQL standard format. Nonetheless, it does work and I could use it if I needed but it isn't open source and I don't like to barrow in this manner since I don't like for people to barrow some of my stuff in that way. The SMF (Simple Machines Forum) database function is a joke for the older version I checked. Maybe I should check a newer version but I get the feeling that I won't be much happier. I have found a few open source classes written but they tend to require more than the database query to be sent. For example: $sql = "SELECT * FROM `users`"$result = $db -> Select($sql); -OR- $sql = "INSERT INTO players (`f_name`, `l_name`,`position`) VALUES ('Peyton','Manning','Quarterback')"$result = $db -> Insert($sql); See how each MySQL query type has it's own function in the class.Another script I found uses a slightly different method to specify the query type: $result = $database->query('SELECT',$sql); What I really want is just this: $sql = "SELECT * FROM `users`"$result = $database->query($sql); -OR- $sql = "INSERT INTO players (`f_name`, `l_name`,`position`) VALUES ('Peyton','Manning','Quarterback')"$result = $database->query($sql); I don't mind if there are optional arguments in the function call but I want to be able to use a single function call for all of my queries like in Joomla. I considered, since it is open source, using the core of the Joomla database class but it has so much specific Joomla code in it and a large chunk of the code is not related to anything I need. I think the biggest plus to using the Joomla database class is that it is relatively secure and has ALL of the error checking built in which is something I tend to get too lazy to do. So, if anyone has a really good open source MySQL class that they use that would work for me, let me know. Otherwise I'll have to go ahead and write one this weekend. I'm pretty sure I can hammer something out pretty quickly but like I said, I'm lazy and would rather use something already made. Thanks, vujsa
  11. Well, there are a couple of ways to do this.The first is to write a script that reads the file, puts the contents in an array (seperated by line) then do a duplicate value check on the array. Then rewrite the file from the cleaned array.The second is to copy the conents of your file and paste in a spreadsheet. Sort the spreadsheet and then evaluate the data after it is sorted. You can manually check to see if there are duplicates as the copy would be right below it. You could automate the search by using a spreadsheet formula to make a copy of the entry in the next column over only if the entry above it is not the same. Then your new column of data would be free of duplicates but might have a hole or two where the duplicate entry wasn't copied over. I use this method frequently for various lists.Also, instead of copying the entry to the next column if there isn't a match, you could print a message if there is a match in the row above then just delete the duplicate line.Hope this helps.vujsa
  12. vujsa

    Signature

    I'm sorry, I have no idea what it is that you need help with. Please try and clarify your request. It almost seems like you want help locating the link to edit your forum signature but I don't know what this program is that you are talking about.Maybe if you tell us what your "idea" is, we will be able to help you. You don't have to be specific if you are afraid someone will "steal" your idea but a general description would be nice.vujsa
  13. It depends on how the system works!I got a free domain and it worked great. Actually, what I got was an $8.00 voucher for a domain registrar service. All I had to do was earn enough credits to trade in for the voucher. The voucher worked fine and the domain was mine do do with as I pleased. I had full control over the domain name and was able to transfer it to my current registrar with little difficulty. I just figured that GoDaddy was better than Optinom and I have 3 other domains with GoDaddy so it seemed like the reasonable thing to do. I nearly have enough points to get another voucher so I might do another transfer or maybe get another domain name. There is more information about creating a website with no money on my website: http://forums.xisto.com/no_longer_exists/ vujsa
  14. Yeah, most anti-viruses can't remove this virus. I ended up having to do a search on Google to find the answer. Long story short, this is what I ended up using: http://forums.xisto.com/no_longer_exists/ You may want to research it further since there is a manual method of doing this if you aren't confident about using yet another mystery program. It cleared things up for me right away. vujsa
  15. I'm not sure if you ever got the answer that you needed. It is possible to simply escape the problematic quote like so: $var = "That's the \"BEST\" option I have ever seen!";echo $var;Outputs:Thats' the "BEST" option I have ever seen! --OR-- $var = 'That\'s the "BEST" option I have ever seen!';echo $var;Outputs:Thats' the "BEST" option I have ever seen! --OR-- You can of course do it the easy way which is to use the heredoc method: $var = <<<EODThats' the "BEST" option I have ever seen!EOD;echo $var;Outputs:Thats' the "BEST" option I have ever seen! For more information, here is a link to the PHP.net syntax for this option: http://forums.xisto.com/no_longer_exists/ I hope that this helps you out. vujsa
  16. Well, I don't know which type you need but this company should have what you need. http://www.outwater.com/home/index.cfm The catalog is quite large so I think you should start here: http://forums.xisto.com/no_longer_exists/ Probably easier to order a printed catalog from them and then flip through it. This place sells a lot of different items so try not to buy too much. vujsa
  17. Well, there is no way to determine what you problem is with the data provided. To begin with, your explanation of the problem was difficult to understand and the code you posted is a mess and incomplete. Did you ever consider that the problem may be in one of the included files? It seems that you have some type of infinite loop problem. To be honest, I'm having a really hard time just following the code you posted. For example, you could eliminate a lot of lines of code by using a switch instead of all of the if else statements. You have 3 while statements that are nearly identical and the only differences are easy to predict, you should try and combine them. It seems that you have made your code much more complicated than it needs to be but with out the code from the included files, I can't really see what is going on. I understand that you have a lot of matching and replacing going on but I can't really envision why so personally, I can't debug the script. Kind of a down fall for me, if I don't completely understand the entire script, I can't really fix any problems. You might want to better utilized tabs and comments as they will provide insight as to what you planed for that bit of code to do. One big thing I see, if you don't provide some kind of data to the script like "name" the script isn't designed to do anything. I mean, the script is meant to build an image based on the name provided so, when you try to access index.php, you are searching for nothing in the database and as a result, the server never finds a match. So, the first thing you need is to check that $_GET['name'] has a value associated to it. Next, you need to check to see if that name exists in the database. If no name is provided or the name isn't in the database, you either need a default image to show or an error message. One other thing, try to limit your use of double quotes. Double and single quotes do different things and if not needed, double quotes slow your script unnecessarily. Also, a variable can be placed in a double quoted string without the need to use concatenation character. Like so: $noun = 'kid';$my_var = "This is a happy $noun!"; You should read this: http://forums.xisto.com/topic/83220-topic/?findpost=1064298755 Hope this helps, vujsa
  18. Basically, < and > become < and > You can use html_entity_decode() to revert back to actual HTML tags. It is something to consider doing I think. But, if you are expecting HTML in one of the input fields, then you could skip the htmlentities() function and just insert the data. But, you should investigate some security protocols for this as well. What hackers tend to do is use the eval() function along with a long string which is actually an include(), require, or file_get_contents() command to load script from their server to manipulate your database or file system. This usually results in an upload to your website where they can show their hacker friends what they did but they could run a database query to add an Admin account for their username, add a file system program to you system which allows them to browse and manipulate your files which could result in total deletion or replacement. they usually look something like this: eval(char(118)char(117)char(106)char(115)char(97))In this case, it just says vujsa but it could have been malicious. vujsa
  19. Well, just like you can't access my account from your account, a hacker can't attack you account from his account.The server is very well protected but from time to time, users unknowingly open security holes in their account with older scripts or self written scripts. Usually, it is older versions of popular scripts that get hacked into. Since these are generally open source, attackers can study the code and look for holes. Usually by the time a security exploit gets to the hacker mainstream, a new version that protects against the security issue is released. It is of course the job of the website owner or administrator to upgrade the script prior to being hacked.Self written scripts have to be pretty bad for a hacker to get in through since they probably can't view the source code of the script. They can however use common security holes to probe your website for exploits so be sure to add a little security to your scripts.vujsa
  20. That is an excellent idea Brian. Not only does this give you more time to develop other aspects of your website, it also guarantees that the BBC will be the same on the entire website. Not to mention, if your forum or blog has developed it already, it probably doesn't have any bugs in it. Come to think of it, I have a section on my website I might try this with. I don't particularly like the BBC used on my forum but at least it would add consitancy to the website if I used it in the other section. Of course, at some point in time, I have to "customize" the BBC in my forum. vujsa
  21. Yeah, these are difficult query strings to get working. Anytime your values are from an array (in this case, the $_POST superglobal) and you use a non-numeric key, you'll have trouble since you'll have so many quotes that'll be impossible to escaped. Here is how I usually get it to work: mysql_query ("INSERT INTO mxp (" . "\n 'date'," . "\n 'user'," . "\n 'victim'," . "\n 'turns'," . "\n 'side'," . "\n 'gold'," . "\n 'lost'," . "\n 'killed'," . "\n 'mxp'," . "\n 'points_b'," . "\n 'points_a'," . "\n 'type'," . "\n 'power'," . "\n 'ip'," . "\n ) VALUES (" . "\n '". $_POST['date'] . "'," . "\n '". $_POST['user'] . "'," . "\n '". $_POST['victim'] . "'," . "\n '". $_POST['turns'] . "'," . "\n '". $_POST['side'] . "'," . "\n '". $_POST['gold'] . "'," . "\n '". $_POST['lost'] . "'," . "\n '". $_POST['killed'] . "'," . "\n '". $_POST['mxp'] . "'," . "\n '". $_POST['points_b'] . "'," . "\n '". $_POST['points_a'] . "'," . "\n '". $_POST['battle'] . "'," . "\n '". $_POST['power'] . "'," . "\n '$ip'" . "\n ) ");That is how I usually write such queries but I guess you could do it linear like this: mysql_query ("INSERT INTO mxp ( 'date', 'user', 'victim', 'turns', 'side', 'gold', 'lost', 'killed', 'mxp', 'points_b', 'points_a', 'type', 'power', 'ip', ) VALUES ( '". $_POST['date'] . "', '". $_POST['user'] . "', '". $_POST['victim'] . "', '". $_POST['turns'] . "', '". $_POST['side'] . "', '". $_POST['gold'] . "', '". $_POST['lost'] . "', '". $_POST['killed'] . "', '". $_POST['mxp'] . "', '". $_POST['points_b'] . "', '". $_POST['points_a'] . "', '". $_POST['battle'] . "', '". $_POST['power'] . "', '$ip' ) "); I prefer the column form since it is easier to see everything at once. Notice how I used the concatenation character "period" to put string and non-string values together. There is also a concatenation function in MySQL that you can use. Remember, there are three quotes you can use in queries: (`)(')(") The slanted single quote is good inside of MySQL queries but don't affect PHP so you could, I believe, also do it like this: mysql_query ( "INSERT INTO mxp (" . "\n `date`," . "\n `user`," . "\n `victim`," . "\n `turns`," . "\n `side`," . "\n `gold`," . "\n `lost`," . "\n `killed`," . "\n `mxp`," . "\n `points_b`," . "\n `points_a`," . "\n `type`," . "\n `power`," . "\n `ip`," . "\n ) VALUES (" . "\n `$_POST['date']`," . "\n `$_POST['user']`," . "\n `$_POST['victim']`," . "\n `$_POST['turns']`," . "\n `$_POST['side']`," . "\n `$_POST['gold']`," . "\n `$_POST['lost']`," . "\n `$_POST['killed']`," . "\n `$_POST['mxp']`," . "\n `$_POST['points_b']`," . "\n `$_POST['points_a']`," . "\n `$_POST['battle']`," . "\n `$_POST['power']`," . "\n `$ip`" . "\n )"); Or in linear form: mysql_query ( "INSERT INTO mxp ( `date`, `user`, `victim`, `turns`, `side`, `gold`, `lost`, `killed`, `mxp`, `points_b`, `points_a`, `type`, `power`, `ip`, ) VALUES ( `$_POST['date']`, `$_POST['user']`, `$_POST['victim']`, `$_POST['turns']`, `$_POST['side']`, `$_POST['gold']`, `$_POST['lost']`, `$_POST['killed']`, `$_POST['mxp']`, `$_POST['points_b']`, `$_POST['points_a']`, `$_POST['battle']`, `$_POST['power']`, `$ip`)" ); Just remember, you should use the single quotes around your array key name if it isn't a numeric value. You can't escape the single quotes that you use for the array key either. You can, I suppose, escape the single quote used in the query since PHP would as a result ignore it but it would then be available for MySQL to see. like so: mysql_query ( "INSERT INTO mxp ( \'date\', \'user\', \'victim\', \'turns\', \'side\', \'gold\', \'lost\', \'killed\', \'mxp\', \'points_b\', \'points_a\', \'type\', \'power\', \'ip`, ) VALUES ( \'$_POST['date']\', \'$_POST['user']\', \'$_POST['victim']\', \'$_POST['turns']\', \'$_POST['side']\', \'$_POST['gold']\', \'$_POST['lost']\', \'$_POST['killed']\', \'$_POST['mxp']\', \'$_POST['points_b']\', \'$_POST['points_a']\', \'$_POST['battle']\', \'$_POST['power']\', \'$ip\')" ); The only method I am sure will work, is the first one I showed you. You might give the others a try sometime. I don't feel like writing a whole script just to test each option. However, I do have another concern with your script! Your script is attempting to directly input any data from your form to your database. This is not a very good method. If the user has a malicious intent, they could inject code into your database creating a serious security risk to your website. Prior to insertion into the database, you really should screen the data. For example, you could convert HTML Entities into something a little less problematic if it contains malicious code: $date = htmlentities($_POST['date']);$user = htmlentities($_POST['user']);$victim = htmlentities($_POST['victim']);$turns = htmlentities($_POST['turns']);$side = htmlentities($_POST['side']);$gold = htmlentities($_POST['gold']);$lost = htmlentities($_POST['lost']);$killed = htmlentities($_POST['killed']);$mxp = htmlentities($_POST['mxp']);$points_b = htmlentities($_POST['points_b']);$points_a = htmlentities($_POST['points_a']);$battle = htmlentities($_POST['battle']);$power = htmlentities($_POST['power']); In your case, this suggestion actually makes your query a lot easier to write. Hope this helps, vujsa
  22. Yeah, the site is really slow to load but it works okay most of the time. I use Firefox there without problem. Hackers and spammers love inactive website since they can have their way with them for a long time before anyone stops them. Some spammers are even nice enough to leave a removal link in their spam posts on inactive forums so that once you get around to working on your website again, they will stop spamming your site. Just remember, most of them don't care too much is Joe Average clicks on the link, they want the searchbots to see the link! The directory and file uploaded to the site is the hackers calling card. This is how they prove that they hacked your site. Then other hackers can check to see if the calling card is there. For most of them, it is just a game and the leave the calling card without damaging the website. Even the ones that do get a little out of hand usually just rename important files or folders so that the website won't work but the data is still there. Usually, just uploading the correct backup files then upgrading the program you are using is the solution to the security problem. Rarely do they get into your database and delete or edit data unless they don't like you for some reason. vujsa
  23. First, you were definitely hacked! Second, your hosting account has problems!Third, you need to contact support.Your site, for whatever reason, was, it looks like, suspended. Your member profile shows you as a HOSTED member but your profile is missing important hosting data!When an account sites around for awhile without activity, hacker take the site over and use it for their purposes!Now, between your suspension and member profile errors, when you earned enough credits to unsuspend your account, either the hacker had changed the password or more probable, the error in your member profile prevented you from logging into your account.So, now that you seem to have some access to the website, you can see the file changes that were made on your account. More than likely, a script like SMF or Mambo allowed a hacker to upload files to your account or even have full control over you public_html folder. It is unlikely that he was able to crack your password.So, once you get your account issues fixed, then you need to either remove the exploited web script or upgrade it to a more secure version!These little issues you have, are rather common. Even I have had a similar issue with random files or folders being uploaded to my file system. It was a result of little or no activity on the website along with an exploit in one of the scripts I had installed.Check this website to see what else they have done to your account:old.zone-h.org/en/defacements/filter/filter_domain=YOUR_DOMAIN_HERE.COMvujsa
  24. You need a Windows XP installation disk. Run that on the new system with the USB drive connected then when you are asked if you want to install or repair, choose repair.Follow the instructions.Do not allow the drive to be "formated"! Just repair windows.This will tell windows how to use the new systems components.Let me know how it works out.vujsa
  25. Just a note, I am still deleting junk here! I recently deleted a number of copied or useless tutorial submissions. This means that if your submission is not visable, then I deleted it and you lost whatever credits you earned for it.I revived this topic since apparently nobody understands that they will lose credits if I delete a junk topic that you reply to!I'm sorry, I have no choice in this matter since there is an overwhelming number of unacceptable posts. What in an unacceptable post?See below:One to two line posts.Posts with fewer than 20 words.Posts copied from somewhere else.Posts that promote a product or include a referral link.Posts typed with "text message" or abbreviated words. (how r u?, thks, ic!, etc...)Posts that are poorly formated. (All CAPS, all bold, too much color, anything hard or harsh to read!)Any other posts which a member complains about or a staff members deems unacceptable!Thank you,vujsa
×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.