spikereloaded

Hey people I've had a look in the forums but couldn't find what I'm looking for. I want a mod that will only allow users to post in the forums 3 times in 5 minutes as I'm having a problem with people spamming now and again! Any ideas?? Cheers

thanks for the help Nickson. i looked in the user stats table and he didnt have any stats?!? not sure why, so just created a new row and its sorted. cheers for the help!

ah ok i see what you mean, how come it's only effecting one user though??

hey guys one of my users is getting 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 'AND us.userid != 135 AND u.user_level != 0' at line 1 Query was SELECT count(*) FROM userstats us LEFT JOIN users u ON us.userid=u.userid WHERE us.strength > AND us.userid != 135 AND u.user_level != 0 i cant seem to work out why. no one else seems to be having this problem. he says this appears when he clicks on the gym. thanks

not ssure what u mean silva but ive sorted this now! thanks for the help anyway

sorted thanks!

thanks for the reply OCtarine I've only got 3 queries i want to put on my login and their all pretty simple, non of them requiring masses of information to be grabbed, its more the security element im worried about. all the original security for the login page is still present so am i right in thinking this should stop any attempts to access the database?

hey people just a quick question, im making a new login page and want to display some stats on it, is it safe to use queries to grab info like players online and recent announcements etc. or is there extra security i need to put on??

hey Octarine thanks but i know that bit, it's where to put it that im struggling with. Do i put it in the header within the <td> tags that make up the main content area, or do i just put each separate page in a div?

Hey guys I'm trying to et my main content into a scrollable div rather than users having to scroll the whole page. I've seen it on quite a few sites but can't seem to wrk out how it's done?! Anyone give me a hand?? Thanks very much

no thats not my exact query, and the query i want to use works fine in phpmyadmin but when i put it in game it doesn't return any characters. could it have anything to do with <br /> being in some of the text im trying to get?!

hey guys Im trying to select a certain number of characters from a column in my tables but having trouble doing so. im using ("SELECT LEFT('ann_TEXT', 20)   but it doesnt return any characters at all? Any ideas what im doing wrong?! cheers people! :D

venom, will i be able to get a copy of the updated version...as i only brought i a couple of weeks ago?!

hey guys Ive made a popup that displays a load of user stats, and im currently trying to display the latest forum post in it aswell. I've managed to get the text of the post and the username of the person who posted it, but can't get the topic nmae to display. I know it's a case of matching the fp_topic_id with the ft_id but struggling to work it out!? can anyone help out??! Thanks

ahh right thank bluegman Sorry to have wasted your time with such a simple problem, but now i spose i know for the future aswell. cheers everyone for the help!

hey bluegman so i think ive found the problem, it seems to be this bit of code where i deleted the image url but left the code in?!?! any reason why that would happen ??   .lgrad { background-image:url(); background-repeat:repeat-y; width:19px; }

thanks bluegman ive changed all the $db queries in my crimes page but their still running twice. im pretty sure it's being experienced by everyone. I've also changed most of the $db queires in my header and mainmenu pages as well but no change. As far as i can tell it is happening on all pages as shown in the screenshot i've attached. thats from my log user page, and most of the pages show as being visited twice if not more within a second of eachother. [ATTACH=CONFIG]218[/ATTACH] thanks again!

i appreciate you have told me a number of ways to solve it but im sure you can understand that this is not my full time job. I am a beginner to php and am trying to learn as much as possible so please dont think im just being lazy. As i've already stated, i'm not sure where i should be looking? if it is happening on all pages does that mean it is likely to be within the header.php? Octarine, whats the best way to log my queries to gauge their results? again, im new to php so please excuse my ignorance!

so im still having this problem. Would anybody be willing to take a look at my forum code and seeing if they can spot any problems. Wiling to pay a small amount for the help!!

i changed that section to method='post' but could not see any $_GET['sddfg']'s in my criminal page. and if i just leave the bit i changed, it comes up saying invalid crime when someone tries to do a crime??

so could this be part of the problem??   print " <form action='docrime.php' method='get'>

[ATTACH=CONFIG]206[/ATTACH] I've attached a log of one of my staff to show what is happeninig, i'm still a little confused to be honest as i don't even know which page to start looking for the problem. Sorry if i'm being blind!

Well as the problem is occurring on a few different pages I thought that the problem may be n globals or header, but can't see any duplicated queries there. It also doesn't happen on all pages eg. It makes the user do crimes more than once and post forum posts, but it doesn't make the user send mail twice or send money more than once.

Hey guys. I'm currently finding that when my users do crimes it is actually making them doing it more than once without them knowing. Eg. They are doing a crime for 2 brave and they are losing 4 brave because it is running twice. This is also happening in the forums resulting in multiple blank forum posts as well as blank topic posts. I've looked at all the changes Ive made but cnt find anything immediately obvious to me. Anybody got any ideas or tips that could help explain this?? Thanks very much

hey is this still available?? im interested in buying!