Dave

Re: Item Market Bug Help Please Change case "remove": item_remove(); break; To case "remove": itemm_remove(); break;

Re: Help Please Jail Bug Change $r=$db->query("SELECT * FROM users WHERE userid={$_GET['ID']}")); Into $r=$db->query("SELECT * FROM users WHERE userid={$_GET['ID']}"); Just incase you dont understand wolfe above.

Re: [Any] Login - Fireworks MX 2004 What do you want us to say xD. Nice work but a bit to plain :P

Re: [mccodes V2] Delete item from shop mod $10 Ill trade ya my mum? I didn't make it but yano i own it :)

Re: [mccode] RSS Feed for Announcements Works fine for me http://deadlyghetto.com/rss.rss i got bored and added .rss xD

Re: Crime-Network Now Released! In game is not nice, Its messy not clean.

Re: [mccode] RSS Feed for Announcements Well i noticed a few bugs with my version. So heres an update! <?php /* rssfeed.php made by Cronwerks.com and Criminalexistence.com Support for this modification and info can be found at the above 2 forums */ header("Content-type: text/xml"); echo '<?xml version="1.0" encoding="ISO-8859-1"?> <rss version="2.0">'; //Edit this $email = "[email protected]"; //Your email //No need to edit anything else include "config.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']; } $now = date("D, d M Y H:i:s T"); print"<channel> <title>".$set['game_name']." Updates Feed</title> <description>All of the recent updates for the text rpg game ".$set['game_name']."!</description> <link>http://".$_SERVER['HTTP_HOST']."</link> <language>en-us</language> <pubDate>$now</pubDate> <lastBuildDate>$now</lastBuildDate> <docs>http://cyber.law.harvard.edu/rss/rss.html</docs> <managingEditor>".$email."</managingEditor> <webMaster>".$email."</webMaster> "; $count=0; $h=mysql_query("SELECT * FROM announcements ORDER BY a_time DESC LIMIT 5 ",$c) or die(mysql_error()); while($a=mysql_fetch_array($h)) { $now = date("D, d M Y H:i:s T", $a['a_time']); $count++; print" <item> <pubDate>{$now}</pubDate> <title>".$set['game_name']." Update {$count}</title> <description>".htmlentities(trim($a['a_text']))."</description> <link>http://".$_SERVER['HTTP_HOST']."/login.php?{$count}</link> </item> "; } print"</channel></rss>"; ?> This also changes the link just changes from login.php?1 to login.php?2 and so on...

Re: MySQL Version My server is running 5.0.51a-community and has been for a while.

Re: Mccodes v2 Theme (want to buy) If you want something decent $30 is incrediably low.

Re: [V2 Attack Bug I think this error is because there is something wrong with the code in the header.

Re: Help with Custom Mod V2 Thats gonna add a few hundred bucks to the price for you.

Re: Userlist.php Its something to do with the bit at the end of the query... im to tired to check atm ill check tommorow.

Re: Userlist.php $q=$db->query("SELECT u.*,g.*,us.* FROM users u LEFT JOIN gangs g ON u.gang=g.gangID LEFT JOIN userstats us ON us.userid=u.userid ORDER BY $by $ord LIMIT $st,100"); Not tested but should work

Re: [mccode] RSS Feed for Announcements Also remembered that some people dont use the default forums, Some people have removed them and so on.... So i modified it to work with announcements, Currently it says GAME NAME Update 1.. then the next is 2 then 3 and so on this is because the announcements system dosen't actually have any kinda title/subject! <?php /* rssfeed.php made by Cronwerks.com and Criminalexistence.com Support for this modification and info can be found at the above 2 forums Conversion and port to announcements by iamwicked! */ header("Content-type: text/xml"); echo '<?xml version="1.0" encoding="ISO-8859-1"?> <rss version="2.0">'; //Edit this $email = "[email protected]"; //Your email //No need to edit anything else include "config.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']; } $now = date("D, d M Y H:i:s T"); print"<channel> <title>".$set['game_name']." Updates Feed</title> <description>All of the recent updates for the text rpg game ".$set['game_name']."!</description> <link>http://".$_SERVER['HTTP_HOST']."</link> <language>en-us</language> <pubDate>$now</pubDate> <lastBuildDate>$now</lastBuildDate> <docs>[url="http://cyber.law.harvard.edu/rss/rss.html"]http://cyber.law.harvard.edu/rss/rss.html[/url]</docs> <managingEditor>".$email."</managingEditor> <webMaster>".$email."</webMaster> "; $count=0; $h=mysql_query("SELECT * FROM announcements LIMIT 5",$c) or die(mysql_error()); while($a=mysql_fetch_array($h)) { $now = date("D, d M Y H:i:s T", $a['a_time']); $count++; print" <item> <pubDate>{$now}</pubDate> <title>".$set['game_name']." Update {$count}</title> <description>{$a['a_text']}</description> <link>http://".$_SERVER['HTTP_HOST']."/</link> </item> "; } print"</channel></rss>"; ?>

Re: [mccode] RSS Feed for Announcements Noticed this was V1, So i decided to convert it and make it so you dont have to modify so much information. <?php /* rssfeed.php made by Cronwerks.com and Criminalexistence.com Support for this modification and info can be found at the above 2 forums Conversion by iamwicked */ header("Content-type: text/xml"); echo '<?xml version="1.0" encoding="ISO-8859-1"?> <rss version="2.0">'; //Edit this $email = "[email protected]"; //Your email //No need to edit anything else include "config.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']; } $now = date("D, d M Y H:i:s T"); print"<channel> <title>".$set['game_name']." Updates Feed</title> <description>All of the recent updates for the text rpg game ".$set['game_name']."!</description> <link>http://".$_SERVER['HTTP_HOST']."</link> <language>en-us</language> <pubDate>$now</pubDate> <lastBuildDate>$now</lastBuildDate> <docs>http://cyber.law.harvard.edu/rss/rss.html</docs> <managingEditor>".$email."</managingEditor> <webMaster>".$email."</webMaster> "; $h=mysql_query("SELECT * FROM forum_topics WHERE ft_forum_id=1 ORDER BY ft_id DESC LIMIT 5",$c) or die(mysql_error()); while($topic=mysql_fetch_array($h)) { $i=mysql_query("SELECT * FROM forum_posts WHERE fp_topic_id={$topic['ft_id']} ORDER BY fp_id ASC LIMIT 1",$c) or die(mysql_error()); $post=mysql_fetch_array($i); $top=mysql_real_escape_string($topic['ft_name']); $bottom=mysql_real_escape_string($post['fp_text']); $vowels = array("", "", "", "", "", "\n", "\r"); $bottom = str_replace($vowels, " ", "$bottom"); $vowels = array("\"); $bottom = str_replace($vowels, "", "$bottom"); $now = date("D, d M Y H:i:s T", $post['fp_time']); print" <item> <pubDate>$now</pubDate> <title>$top</title> <description>$bottom</description> <link>http://".$_SERVER['HTTP_HOST']."/</link> </item> "; } print"</channel></rss>"; ?> All you need to edit is the $email = ""; bit.

Re: [mccodes V2] Delete item from shop mod $10 If i 'own' so if i didn't create it thats fine with you? I'm 100% certain that would be against 99% of all the coders on here and how they sell mods.... (Maybe read the posts most give you use on 1 game, I certainly do)

Re: [mccodes V2] Delete item from shop mod $10 Sounds dodgy.

Re: Yahoo! YUI Board? *Reloads shotgun* I vote for :)

Re: [Help] itemmarket (v2) Just change the query from 'money' to 'bankmoney'

Re: Main Menu Image Back Ground I know! Everyone uses div's these days :P

Re: [mccodes v2]street gangs [100$] just one copy While your asking him why not ask www.mafiacorruption.com Cause there not selling there template... i simply asked so the other people who are interested in purchasing get all of the facts...

Re: [MCV2]SHOUTBOX[MCV2] Remember kids... this mod needs protection from injections :)

Re: [mccode v2] User Comments Thats HTML.

Re: SQL Injections Surely it wouldn't because when you use ioncube it gets 'decoded' on the server then the file is ran... im not certain on this but im preety sure that ioncubing a file would not help against mysql injections

Re: MySQL Configuration Interesting, I ran it on my server and it returned that there were a few optimizations which needed doing, I'll do these later and then report back wether it did improve the mysql servers speed or anything.