boots

does anyone have a copy of a working integration file for this ?

Just beening testing your prop mod and found a bug,when renting the uesr can sell the prop back to the agent over and over again i know this is a free mod and know support is given but i have been playing around with it for the last 2 hours to try and fix it but no joy please help

this is what i use <span color={$r['cName']}>{$r['username']}</span> but i try and add to the username part chat_ajax.php it dont work i know it something simple but I'm missing it

I have my colour names in my users db, cname, can you tel me how to add this to the script i have tried but still cant get it work i would also like to add viewuser from the chat box

I have the same prob with this mod, could tell me how you fixed it

Did any one get this to work ? been playing around with it but still loads of probs, does any one have a working copy

Yeah always wanted to have this

Saffron lane m8, now at thurnby

Thankyou kyle :) works great i can see where i went wrong now,

i tried your code and i get this error QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Query was UPDATE users SET lastip_login='188.28.71.24',last_login=unix_timestamp() WHERE userid=

authenticate.php   <?php session_start(); if(get_magic_quotes_gpc() == 0) { foreach($_POST as $k => $v) { $_POST[$k]=addslashes($v); } foreach($_GET as $k => $v) { $_GET[$k]=addslashes($v); } } include "config.php"; include "language.php"; global $_CONFIG; define("MONO_ON", 1); require "class/class_db_{$_CONFIG['driver']}.php"; $db=new database; $db->configure($_CONFIG['hostname'], $_CONFIG['username'], $_CONFIG['password'], $_CONFIG['database'], $_CONFIG['persistent']); $db->connect(); $c=$db->connection_id; $set=array(); $settq=$db->query("SELECT * FROM settings"); while($r=$db->fetch_row($settq)) { $set[$r['conf_name']]=$r['conf_value']; } if ($_POST['username'] == "" || $_POST['password'] == "") { die("<h3>{$set['game_name']} Error</h3> $nofill<br> <a href=login.php>> Back</a>"); } $uq=$db->query("SELECT userid FROM users WHERE login_name='{$_POST['username']}' AND `userpass`=md5('{$_POST['password']}')"); if ($db->num_rows($uq)==0) { die("<h3>{$set['game_name']} Error</h3> $invalid<br> <a href=login.php>> $lerrortry</a>"); } if ($mem['confirmed']=0) { die("Your account is not active, check your email address including junk boxes. <a href=login.php>> Back</a>"); } else { $_SESSION['loggedin']=1; $mem=$db->fetch_row($uq); $_SESSION['userid']=$mem['userid']; $IP = $_SERVER['REMOTE_ADDR']; $IP=addslashes($IP); $IP=mysql_real_escape_string($IP); $IP=strip_tags($IP); $db->query("UPDATE users SET lastip_login='$IP',last_login=unix_timestamp() WHERE userid={$mem['userid']}"); $db->query("UPDATE users SET active=1 WHERE userid={$mem['userid']}"); if($set['validate_period'] == "login" && $set['validate_on']) { $db->query("UPDATE users SET verified=0 WHERE userid={$mem['userid']}"); } header("Location: index.php"); } ?>

No errors just cant login, cant understand it all looks ok, also tried if ($mem['confirmed'] == 0) but same prob, Your account is not active, check your email address

Help! i have a prob with my email Validation, it sends email to user the link works fine, updates the users table form 0 to 1 but still cant login   authenticate.php $uq=$db->query("SELECT userid FROM users WHERE login_name='{$_POST['username']}' AND `userpass`=md5('{$_POST['password']}')"); if ($db->num_rows($uq)==0) { die("<h3>{$set['game_name']} Error</h3> $invalid<br> <a href=login.php>> $lerrortry</a>"); } if($ir['confirmed'] == 0) { die("Your account is not active, check your email address including junk boxes. <a href=login.php>> Back</a>"); } else   activation.php $code=$_GET['code']; $cq=mysql_query("select * from confirm where code=$code",$c); if(mysql_num_rows($cq)== 0) { die("Invalid Validation Code"); } $r=mysql_fetch_array($cq); if($_GET['act'] == 'activate') { mysql_query("UPDATE users SET confirmed='1' WHERE userid={$r[user]}",$c); mysql_query("DELETE FROM confirm WHERE code=$code",$c); print "Account Validated!<br /> <a href='login.php'>Login</a>"; } else if($_GET[act] == 'cancel')   signup.php if($_POST['ref']) { $q=$db->query("SELECT * FROM users WHERE userid={$_POST['ref']}"); $r=$db->fetch_row($q); } $db->query("INSERT INTO users (username, display_pic, login_name, userpass, level, money, crystals, donatordays, user_level, energy, maxenergy, will, maxwill, brave, maxbrave, hp, maxhp, location, gender, signedup, email, bankmoney, lastip, confirmed) VALUES( '{$username}', 'http://{$_SERVER['HTTP_HOST']}/images/avatar.gif', '{$username}', md5('{$_POST['password']}'), 1, $sm, 0, 0, 1, 12, 12, 100, 100, 5, 5, 100, 100, 1, '{$_POST['gender']}', unix_timestamp(), '{$_POST['email']}', -1, '$ip', 0)",$c);

Did you get this working AnonymousUser ? i have the same problem

I would like to add an level restristion to forums to help cut down the spam how can i make it so you must be level 3 to post in the forums ?