Shivski

Re: [v2]Assassin.php[v2] Cool, just thought i'd see it like I try most of my mods, will try it out in a bit :)

Re: [v2]Assassin.php[v2] Im getting 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 SELECT * FROM users WHERE userid=   Any idea?

Re: [mccode v2] userADS   Anyone else know what index I need to define? I have deleted the query and re-added it a few times to no avail? One last try lol

Re: [mccode v2] Lottery quick bump :)

Re: "if location =" ... query Ooppss, Soryr bout that, thought i did in my last post.   [b]<u>Shops and Market</u>[/b] [url='shops.php']All Shops[/url] "; if($ir['location'] == 2) { print " [url='shops.php?shop=4']Geoff's Gun Shop[/url] "; } print " if($ir['location'] == 2) { print " [url='shops.php?shop=5']Andy's Armour Shop[/url] "; } print " [url='itemmarket.php']Item Market[/url]

Re: "if location =" ... query I need more then 1 location query next to eachother so it would look like a normal list of links, but everytime I try and add one straight after the , print ", it makes my explore blank again.

Re: "if location =" ... query That worked for that 1, thanks :) But... I encore the same problem when putting 2 next to each other though. Is there anycode I need to put between them? Iv tired variations with "; to no avail. Sorry for my n00bish. And cheers for your patience.

Re: "if location =" ... query I apologise if it came across that way, btu i didnt mean it too. All im wanting is to add this query underneath other links. But the explore becomes blank and I for the life of me can not see why. I don't have echos on my original code.   if($ir['location'] == 2) { print " [url='shops.php?shop=4']Geoff's Gun Shop[/url] "; } print "

Re: "if location =" ... query Right, so your attitude is not really helping. All I asked was how to correct my code. Im new to this (as u can no doubt tell) Can you amend my code with the correct echos and prints so I can see where I have gone wrong and so I can learn for future reference?

Re: "if location =" ... query   SO how would that sit if my part of my code is this? [url='shops.php']All Shops[/url] $q=$db->query("SELECT * FROM shops WHERE shopLOCATION={$ir['location']}"); while($r=$db->fetch_row($q)) { print "[url='shops.php?shop={$r[']{$r['shopNAME']}[/url] "; } echo" [url='itemmarket.php']Item Market[/url]

Re: "if location =" ... query But I take out the query and it comes back fine, so its the query? Im back to my normal shops (the click to view them) and everything is working fine.

Re: "if location =" ... query I've copied and pasted it and still the explore.php is blank. This is how it sits in my code. [url='shops.php']All Shops[/url] $q=$db->query("SELECT * FROM shops WHERE shopLOCATION={$ir['location']}"); while($r=$db->fetch_row($q)) { print "[url='shops.php?shop={$r[']{$r['shopNAME']}[/url] "; } echo" [url='itemmarket.php']Item Market[/url]

Re: [mccode V2] Search Islands This is working fine now, sorted my day cron out. Although 100 turns does seem extreme, i think i'll edit it down hehe.

Re: "if location =" ... query It shouldnt matter. Ive been in location 1 and 2, but the explore doesn't show, its blank. Which is my limited experience means the code is wrong or theres some sort of bracket wrong. Iv attached more of the code to see where it sits within the page [b]<u>Shops and Market</u>[/b] [url='shops.php']All Shops[/url] if($ir['location'] == 2) { print " [url='shops.php?shop=4']Geoff's Gun Shop[/url] "; } print " [url='itemmarket.php']Item Market[/url]

Hey Ii trying to set my shops into the explore.php file so that they show the actual shops in the file instead of having to click 'Shops'. I have the query if($ir['location'] == 2) { print " [url='shops.php?shop=4']Geoff's Gun Shop[/url] "; } print "   But on entering it, it shows the explore as blank. Is there an error in the coding that anyone can see?

Re: [mccode V2] Search Islands It's on there, but say's i've already visited today. Think there's an issue with my daily cron as other features seem to be not functioning due to it.

Re: [mccode v2] userADS   Anyone else know what index I need to define? I have deleted the query and re-added it a few times to no avail?

Re: [mccode v2] Attack :) added the mod, 100% better then the standard one, i got really confused trying to attack with that lol

Re: [mccode v2] Lottery With this, do add the cron to my cron_weekly which exists already? And if so, where abouts in there? Or do I create a brand new cron? Also, which settings do I change to do a daily lotto? Or is it a case of just changing the cron run time?

Re: Updated Mailbox [v1]   Nice mode mate. Much nicer to look at :D

Re: [mccode v2] userADS Hey, managed to sort the .php, just having an issue with it showing up now. The page is blank. I ran the query on SQL, which ran successfully. Is there something else I need to be doing? n clicking the query, it shows up as "No index defined!" in red under the tables?

Re: [mccode v2] Revamped RentaSpy Wicked little mod, all works fine my end 8-)

Re: explorer.php is blank? lol, I feel such a fool haha. God knows how the "prints" got there. All working now, many thanks for that.

Hey all So i made an amendment in my explorer.php file, moving certain links under diff headers. But now its showing my explore as totally blank when I go to it? Im thinking its a coding issue, btu can't, for the life of me,, find any issue. If someone can point it out to a blind bat, then please do :lol: <?php include "globals.php"; $tresder=(int) rand(100,999); if($ir['jail'] or $ir['hospital']) { die("This page cannot be accessed while in jail or hospital."); } print "[b]You arrive in town and go for a wonder.[/b] <table width=75%><tr height=100><td valign=top> [b]<u>Shops and Market</u>[/b] [url='shops.php']Shops[/url] [url='itemmarket.php']Item Market[/url] [url='cmarket.php']Dub Market[/url] [url='crystaltemple.php']The Record Shop[/url] </td> <td valign=top> [b]<u>Town Centre</u>[/b] [url='monorail.php']Train Station[/url] [url='estate.php']Estate Agent[/url] [url='fedjail.php']Prison[/url] [url='job.php']Job Centre[/url] [b]<u>Banking</u>[/b] [url='bank.php']The Bank[/url]"; if($ir['location'] == 5) { print " [url='cyberbank.php']Cyber Bank[/url] "; } print "</td> <td valign=top> [b]<u>Gang Info</u>[/b] [url='gangcentral.php']Gangs[/url] [url='gangwars.php']Gang Wars[/url] [b]<u>The back alleys</u>[/b] [url='slotsmachine.php?tresde=$tresder']Slots Machine[/url] [url='roulette.php?tresde=$tresder']Roulette[/url] [url='search_the_bins.php']Search the bins[/url] [url='stripper.php']Strip Club[/url] [url='lucky.php']Lucky Boxes[/url]"; if($ir['location'] == 5) { print " [url='slotsmachine3.php']Super Slots[/url] "; } print "</td></tr><tr height=100> <td valign=top> [b]<u>Stats</u>[/b] [url='userlist.php']User List[/url] [url='stafflist.php']{$set['game_name']} Staff[/url] [url='halloffame.php']Hall of Fame[/url] [url='stats.php']Game Stats[/url] [url='usersonline.php']Users Online[/url]</td> <td valign=top> [b]<u>Unknown</u>[/b] print "[url='battletent.php']Dub War[/url] "; print "</td></tr></table> This is your referal link: http://{$domain}/register.php?REF=$userid Every signup from this link earns you two dubplates!"; $h->endpage(); ?>   Big help if you can :D Shiv

Re: [mccode v2] Advanced Crystal Temple. Added the mod and it looks good. Wil get checking it now :)