Tonka

Re: some clever person help me your most likely problem is that your using localhost, and your hosting company requires something different, pm or msn me and i'll give you a hand, [email protected]

Re: Display Gangs Name??? here is what i use and it works fine $q=$db->query("SELECT u.*,g.* FROM users u LEFT JOIN gangs g ON g.gangID=u.gang WHERE u.userid=$userid"); $g=$db->fetch_row($q);   [b]Gang:[/b] "; if($g['gang']) { echo "[url='gangs.php?action=view&ID={$g[']{$g['gangNAME']}[/url] "; } else { echo "N/A "; }

Re: Need help limiting energy refills instead of if($ir['energyfill'] > 3) { print "You have already filled your energy 3 times today."; } this will allow users to refill 4 times use this if($ir['energyfill'] >= 3) { print "You have already filled your energy 3 times today."; }

Re: Time Stamp. 86400 is for one day just multiply this by 4

Re: Whole Game Template very nice template chase

Re: Preferences edit thanks for this zero, i was having trouble making this myself

Re: Different User Profile & View User Page if they're supposed to be different pages, in the screen shots why are they both viewuser.php

Re: Different User Profile & View User Page i don't see any difference

Re: online/offline/total users it works fine, i use it on my game

Re: Simple Funtions if you want this to work with v2's $db-> properly you need to replace global $ir,$c,$userid,$h;   with global $db,$ir,$c,$userid,$h;   notice the $db added to the second one

Re: I know it was posted before, but there was no resolution did you add any extra columns to the cities table? also posting the error your getting would help

Re: Screening Mod and Research Facility Centre Mod [FREE][V2] looks very nice War_Hero, good job for your first mod

Re: Auto delete old mail not a problem, it was posted on CE in a cleanup cron

Re: Auto delete old mail here is a better way that will decrease the load on your server, just add this to your day cron and your done   $db->query("DELETE FROM mail WHERE mail_time < (unix_timestamp() -2592000)",$c);   this will delete all mails older than 30 days

Re: I need HELP and Willing to Pay   this won't fix it, i think he forgot to run the installer, cause i tried the fix that i had posted yesterday and i got the exact same errors as he did

Re: I need HELP and Willing to Pay you config.php file is messed up open up config.php and find 'driver' => and put either try first 'driver' => 'mysql', if that doesn't work try 'driver' => 'mysqli',

Re: Register [Free] very nice

Re: Mood Mod change it to case 'moodchange': mood_change(); break;

Re: Mood Mod here, SQL that works   ALTER TABLE `users` ADD `mood` VARCHAR( 255 ) NOT NULL default 'Unknown' ;

Re: credit.php here you go, fixed and working properly   <?php include "globals.php"; /* Coded By [email][email protected][/email] if you wont the v1 just change $db->query to mysql_query QUERYS you need.. ALTER TABLE users ADD `dc` INT( 11 ) NOT NULL DEFAULT '0'; ALTER TABLE users ADD `credit` INT( 11 ) NOT NULL DEFAULT '0'; */ if ($ir['donatordays'] > 0 AND $ir['level'] > 3 AND $ir ['dc'] > 0) // You can change the 2 to any number of level { echo "Sorry you either have donator days or your level 4+"; // put whatever you want here in the "" $h->endpage(); exit; } else { $db->query("UPDATE users SET donatordays=donatordays+3,dc=dc+1 WHERE userid=$userid");// change the 3 to any number echo "You have been credited your donator days " ; } if ($ir['credit'] > 0) { echo "You have already been credited.."; $h->endpage(); exit; } else { $db->query("UPDATE users SET money=money+1000,crystals=crystals+10,bankmoney=bankmoney+100,credit=credit+1 WHERE userid=$userid");//change the 1000 to any number you wont.. echo "You have been creded \$1,000 cash 10 crystals \$100 cash in bank";// change the message here also } ?>

Re: Login [Free] very nice design zero

Re: Event Add -- stumped replace your event add with this, i'm not sure if this will work but it should   $db->query("INSERT INTO announcements VALUES('{$user['userid']} won the weekly lottery. Well done!', unix_timestamp())"); $db->query("UPDATE users SET new_announcements=new_announcements+1");

Re: User Shops here's the link to his profile, just pm him http://criminalexistence.com/ceforums/index.php?action=profile;u=394

Re: Free Starter Pack INSERT INTO `inventory` (`inv_id`, `inv_itemid`, `inv_userid`, `inv_qty`) VALUES Open your register.php Find $db->query("INSERT INTO userstats VALUES($i, 10, 10, 10, 10, 10)");   Add below mysql_query("INSERT INTO inventory VALUES ('', 22, $i, 1)"); here is how the values work (`inv_id`, `inv_itemid`, `inv_userid`, `inv_qty`) don't remove the $i

Re: User Shops Talk to arson, he made them fo v1 a while ago