SilvaTungDevil

Thanks for the review Alex

WHERE `user_level` != 2 That would work if your asking for what I think your asking.. You want everyone except admins showing right? If so put that at the end of your query before ASC/DESC

I see a massive flaw.   $db->query("SELECT m.*,u.*,g.* FROM gang_mail m LEFT JOIN users u ON u.userid='".$ir['userid']."' LEFT JOIN gangs g ON g.gangID=u.gang WHERE m.gangid=g.gangID ORDER BY time DESC LIMIT $page,10");   Do you really need to select every column from the users table? Really every column? Like wise do you need every column from the gang table? I doubt it very much, try optimising your queries a bit ;)

In all honesty I would look for double that before launch. For launch I hit it hardest as that is when you want new players. It depends how many and where you want your adverts. You can spend that $500 in an hour or less or you can make it last a week or more.

Do you have any error messages come up when you add that piece of code? Just so you know it should look like this:   Crystals: {$r['crystals']} Property: {$r['hNAME']} Referals: "; $rr=$db->query("SELECT * FROM referals WHERE refREFER={$r['userid']}"); print $db->num_rows($rr); print " Marital Status: "; if ($r['marriage']) { $part=$db->query("SELECT * FROM users WHERE userid={$r['marriage']}"); $pr=$db->fetch_row($part); print "Married to [url='viewuser.php?u={$pr[']{$pr['username']}[/url]"; } else { print "Single"; } print " ";   In regards to your second question, Have you included globals.php twice? Post up your marriage.php code here for us to see please

I love all the information you present with your sales pitch. Link to site? Can we even see a preview? Are you selling us the domain name or just the site and the DB. How long is left on the domain name? (in terms of it being registered) Seems as there is no link, how big is the user base on it? Does it come with a complete DB (including current users) or wiped fresh How many hits a day do you get? have you made any income from it.. Etc Come on its not that hard to give us some extra information

Uzuk your going to need to more than just post your code.. Give us something to work with such as an error or something.

I never even knew about torncity until after I had been here at least a year or two (have been here 4 odd years). But still it doesn't appeal to me & I have no account :thumbsup:

how do you mean dissapear? As in the files are gone? or you took them out of your cron jobs? If its the first you can download: 1 Minute Cron [ Updates Jail and Hospital Time ] 5 Minute Cron [ Updates User Statistics ] Hourly Cron [ Updates Hourly Cron ] Daily Cron [ Updates Daily Cron ] Them crons again from mccodes.com just enter in your customer information.. The other two I would guess you need to use the search bar in the top right If its setting them up you need help with again look in your config.php file for the cURL code.

Its got potential I think. you need to make your area entitled "header" as wide as your top two boxes and change the colors about a bit in my opinion. It is a good solid base to work from and expand with

In on thread to find out :D

I want my new start sign DJK. Dont ruin it for me!

The uk's equivalent of A_b's network :p Is from august though, when schools were of the network (or very limited number using it)

In your css find your class called table. And within it put: background: gray;   However why you needed to ask us this i'm not entirely sure, a simple bit of googling would have come up with thousands of search results al saying the same thing.

I think what he means is he wants an image of say an ak47 ... then he wants another image exactly the same (size, etc) but shaded so its darker

line 3 needs to be : $hgain=($_GET['bet']*1.5)-($_GET['bet']); On a side note did you remember to secure the $_GET['bet'] ?

For neatness you probably want:   if ($ir['level'] < 5) { echo 'Level 5+ please.'; $h->endpage(); exit; }   But that may just be me ( :)

if($ir['level'] < 5) { prevent them from accessing }

In theory you should be taken to :   header("Location: logged_in.php");   Do you have a "Logged_in.php" file?

There will be a meta refresh tag somewhere. Further than that we cant help you unless you post your login code.

Post up line 109 and 110 :)

Looks like you have a big job on your hands going through all the files then :huh: What level do you feel your at with PHP? if your not at a high enough level perhaps its time to bring someone new in to help you secure the files.

<textarea rows='10' cols='80' name='newnote'></textarea> 10 and 80 are two sizes i specified. Cols make it wider and rows make it taller. IIRC

Line 3 and line 9. You are fetching EVERYTHING from the users and gang tables, only having briefly scanned your function I suspect you dont need every column. My suggestions, optimize it a bit and only grab the columns that you need: So maybe [mysql]SELECT `userid`, `username`, `user_level`, `donatordays`, `gang` FROM `users` WHERE `username` = $username[/mysql] And also [mysql]SELECT `gangID`, `gangPREF` FROM `gangs` WHERE `gangID` = {$FETCH['gang']} [/mysql]

Ouch! Can i ask how many more SQL's you are asking users to add on to the already over stretched (IMO) user table, Would it be possible for you to create a separate table for all the pets stats to be held in, I feel that allows for the mod to be expanded on a bit more by others without having to put yet more strain on the user table.