Isomerizer

Re: How to.... Use mysql_fetch_object/array.   $SQL = sprintf("SELECT `username` FROM `users` WHERE `userid` = %u", $ID); /* users = users table, userid = primary key of users table, $ID = variable containing users id. */ $query = mysql_query($SQL); $user = mysql_fetch_object($query); echo $user->username;   This is very basic PHP / MySQL, if you want to create your own engine, your gonna have to know a lot more complex stuff then simple fetching.

Re: learning mysql_real_escape_string just need to verify.   Rofl, of course you need to know basic security to create a game, other wise, it will jsut be exploited / abused to hell.

Re: [REVIEW] Star Fleetz [www.starfleetz.com] Very nice amount of users and online users. I also like the theme / template. Though you still have a long way to go before your game is "unique" to other mccode games.

Re: learning mysql_real_escape_string just need to verify.   You use it if your escaping a string, not int. So i'll use an example...   $SQL = sprintf("SELECT `ID` FROM `users` WHERE `username` = '%s'", mysql_real_escape_string($_POST['username'])); $db->query($SQL);   For more info: http://uk2.php.net/mysql_real_escape_string

Re: Simple MySQL optimization Thanks, never knew it made a difference, even if it is a small one.

Re: Instant Messenger for Your Game!   I'm thinking this too, though i do not have evidence, my reason...   Reference: http://criminalexistence.com/ceforums/i ... ic=23429.0 Poldar, in the topic linked above, you claimed you could not do this sort of thing? As in fixing what seemed to be a pretty simple php error? You managed to create this pretty complex IM mod using PHP / C++. But... Could not fix a simple error? I'm sure you came across much more complex errors in the process of creating this mod.   Reference: http://criminalexistence.com/ceforums/i ... ic=23520.0 Why would you need a php programmer? Also, I've messaged you with something else that could back up this point, I haven't said here for security reasons. Apologizes in advance if I'm wrong, but this is just how i see it...

Re: How would i......   if (eregi('www.', $string)) { // Code here }

Re: cod4 online Agreed, i loved the fact that it involved modern day weapons & technology. I'd rather learn about war today, not the passed.

Re: Query help please itmid column does not exist in inventory. No need to encase numbers. Try.. SELECT * FROM `inventory` WHERE `inv_itmid` = 95 AND `userid` = 2

Re: cod4 online I'm starting to get bored of it, used to be pretty hooked. Think I'm gonna wait for cod5 WaW to be released now, shouldn't be too long. I play cod4 online via ps3, I'm on prestidge 3, Rank 46.

Re: Modified Cron Job help   mysql_query( sprintf("UPDATE `users` SET `jail` = 0 WHERE `jail` < 5") );

Re: [Free] [v1] BB Gun / Shoot Someone in Back! $it=mysql_query("SELECT inv_id FROM `inventory` WHERE `inv_itemid`=110 AND `inv_userid`=$userid",$c); Change the 110 to the correct itemid. Should be located in the `items` table..

Re: credit.php The code tags come in handy. [ code] [/ code]

Re: Houndbite steals mods I don't see this is enough evidence. The conversation, it seems he saying "Like you told me...", "I steal mods". Basically hes repeating what you've said about him. Then it seems Matt is asking you? Where "he" stole them from? Surely he would of said "you" if it was directed at this HoundBite guy? Hope this makes sense...

Re: Can Somone Help? Im A Bit Of A Newb. Whats the line before line 18?

Re: [Free] MySQL Control Panel I enjoyed coding this mod, and have decided to code onto it slowly. The newest version is available here: http://isomerizer.com/index.php?page=sqladmin If anyone has any ideas for improvements, feel free to tell me.

Re: ispy ( not a rip-off of apple ) Tabs

Re: Counting (nr game)   1910 :mrgreen: just to carry it on properly :P Oh and btw im the topic starter This was started on May 06, 2006 2 years on and this is the first time for me coming back :-D W000t Snoopy, a fellow oldie from CE first days. 1913 :P

Re: 3 Word Game gunky unknown liquid

Re: ispy ( not a rip-off of apple ) Toolbar

Re: [Mccodes] Quote Mod This query will surely error? mysql_query("UPDATE `users` SET `quote` = '$q' WHERE `userid` = " . $ir['userid']); Should be.. mysql_query("UPDATE `users` SET `quote` = '$q' WHERE `userid` = " . $ir['userid'] ." ");

Re: Religions Mod Lol, wtf... jaye1 that one obviously won't work either. Your both messing up the preferences function. Try this: In preferences add:   function religion_change() { global $ir,$c,$userid,$h; print "<h3><u>Religious Change</u></h3><form action='preferences.php?action=religionsubmit' method='post'>Current Religion: <select name='rel' type='dropdown'> <option value='0'>Non Believer</option> <option value='1'>Sikh</option> <option value='2'>Hindu</option> <option value='3'>Muslim</option> <option value='4'>Christian</option> <option value='5'>Other</option> <option value='6'>Hidden</option> </select> <input type='submit' value='Change Religion' /></form>"; } function religion_submit() { global $db,$ir,$c,$userid,$h; $db->query( sprintf("UPDATE `users` SET `religion`= '%s' WHERE `userid` = %u", mysql_real_escape_string($_POST['rel']), $userid) ); print "Your Religion has been changed. Do you want to go [url='preferences.php']Back to preferences?[/url] [url='index.php']Or back home?[/url] "; }

Re: Battle Arena [$20]   Sounds like your v1 header is incorrect. Make sure its:   session_start(); require "global_func.php"; if($_SESSION['loggedin']==0) { header("Location: login.php");exit; } $userid=$_SESSION['userid']; require "header.php"; $h = new headers; $h->startheaders(); include "mysql.php"; global $c; $is=mysql_query("SELECT u.*,us.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid WHERE u.userid=$userid",$c) or die(mysql_error()); $ir=mysql_fetch_array($is); check_level(); $fm=money_formatter($ir['money']); $cm=money_formatter($ir['crystals'],''); $lv=date('F j, Y, g:i a',$ir['laston']); $h->userdata($ir,$lv,$fm,$cm); $h->menuarea();

Re: a pointer or two Ah ok, maybe $ir['exp_needed'] is defined in another script, try looking in header or global funcs.

Re: in need of a coder I'll do it, I'm pretty good with mccodes. Contact me via pm.