Monkey644

Still getting: 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 'xvsdfg','dfgsg','','',0,0,100,1,1,5,0,0,'','','')', '/creategang.php', unix_time' at line 2   This is starting to annoy me now... :)

[mysql]-- phpMyAdmin SQL Dump-- version 3.2.4-- http://www.phpmyadmin.net---- Host: localhost-- Generation Time: Jul 13, 2010 at 04:42 PM-- Server version: 5.0.90-- PHP Version: 5.2.9 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8 */; ---- Database: `deadlyc1_Users`-- -- -------------------------------------------------------- ---- Table structure for table `gangs`-- CREATE TABLE IF NOT EXISTS `gangs` ( `gangID` int(11) NOT NULL auto_increment, `gangNAME` varchar(255) NOT NULL default '', `gangDESC` text NOT NULL, `gangPREF` varchar(12) NOT NULL default '', `gangSUFF` varchar(12) NOT NULL default '', `gangMONEY` bigint(65) NOT NULL default '0', `gangCRYSTALS` bigint(65) NOT NULL default '0', `gangRESPECT` int(11) NOT NULL default '0', `gangPRESIDENT` int(11) NOT NULL default '0', `gangVICEPRES` int(11) NOT NULL default '0', `gangCAPACITY` int(11) NOT NULL default '0', `gangCRIME` int(11) NOT NULL default '0', `gangCHOURS` int(11) NOT NULL default '0', `gangAMENT` longtext NOT NULL, `gangSIG` varchar(255) NOT NULL, `gangSIG2` varchar(255) NOT NULL, `gangSTATUS` text NOT NULL, PRIMARY KEY (`gangID`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;[/mysql] As requested. :)

Your a saint if im honest. Thank you :)

Hey all,   My main menu is showing two jails and no "Your Gang". My code is as follows:   <?php global $db,$c,$ir, $set; $hc=$set['hospital_count']; $jc=$set['jail_count']; $ec=$ir['new_events']; $mc=$ir['new_mail']; $course=$ir['minus_clicks']; print "<font color='blue'>[b][url='donator.php']Donate to DC Today[/url][/b]</font> "; if($ir['hospital']) { print "<table width=145 class=menu><th>Main</th><tr><td> [url='hospital.php']Hospital ($hc)[/url]</td></tr> <tr><td>[url='inventory.php']Inventory[/url]</td></tr> <tr><td>[url='emergencysurgery.php']Emergency Surgery[/url]</td></tr>"; } elseif($ir['jail']) { print "<table width=145 class=menu><th>Main</th><tr><td> [url='jail.php']Jail ($jc)[/url]</td></tr> <tr><td>[url='inventory.php']Inventory[/url]</td></tr>"; } else { print "<table width=145 class=menu><th>Personal Area</th><tr><td> [url='index.php']Home[/url]</td></tr> <tr><td>[url='inventory.php']Inventory[/url]</td></tr>"; } if($ec > 0) { print "<tr><td>[url='events.php']<font color='red'>Events ($ec)</font>[/url]</td></tr>"; } else { print "<tr><td>[url='events.php']Events (0)[/url]</td></tr>"; } if($mc > 0) { print "<tr><td>[url='mailbox.php']<font color=green>[b]New messages![/b] ($mc)</font>[/url]</td></tr> "; } else { print "<tr><td>[url='mailbox.php']Messages (0)[/url]</td></tr> "; } print "<th>Main</th>"; if($ir['jail'] and !$ir['hospital']) { print "<tr><td>[url='gym.php']Jail Gym[/url]</td></tr> <tr><td>[url='hospital.php']Hospital ($hc)[/url]</td></tr>"; } else if (!$ir['hospital']) { print "<tr><td>[url='explore.php']Explore[/url]</td></tr> <tr><td>[url='gym.php']Gym[/url]</td></tr> <tr><td>[url='criminal.php']Crimes[/url]</td></tr> <tr><td>[url='hospital.php']Hospital ($hc)[/url]</td></tr> <tr><td>[url='jail.php']Jail ($jc)[/url]</td></tr>"; } if(!$ir['gang'] && $ir['jail']) { print "<tr><td>[url='yourgang.php']Your Gang[/url]</td></tr>"; } else { print "<tr><td>[url='jail.php']Jail ($jc)[/url]</td></tr>"; } print "<th>Community</th> <tr><td>[url='job.php']Your Job[/url]</td></tr> <tr><td>[url='forums.php']Forums[/url]</td></tr>"; if($ir['new_announcements']) { print "<tr><td>[url='announcements.php']Announcements ({$ir['new_announcements']})[/url]</td></tr>"; } else { print "<tr><td>[url='announcements.php']Announcements (0)[/url]</td></tr>"; } if($course['minus_clicks'] > 1) { print "<tr><td>[url='education.php'][b]Continue Learning[/b][/url]</td></tr> "; } elseif ($course['minus_clicks'] = 0) { print "<tr><td>[url='education.php']Back To School[/b][/url]</td></tr> "; } print " <tr><td>[url='newspaper.php']Newspaper[/url]</td></tr> <tr><td>[url='shoutbox.php']DC Chat[/url]</td></tr> <tr><td>[url='Auction.php']Auction[/url]</td></tr> <tr><td>[url='search.php']Search[/url]</td></tr> <tr><td>[url='usersonline.php']Users Online[/url]</td></tr>"; if($ir['user_level'] > 1) { print "<th>[b]Staff Only:[/b]</th> <tr><td>[url='staff.php']Staff Panel[/url]</td></tr>"; } if($ir['donatordays']) { print "<th>[b]Donators Only[/b]</th> <tr><td>[url='home.php']Your Home[/url]</td></tr> <tr><td>[url='donatorgym.php']Donator Gym[/url]</td></tr> <tr><td>[url='ddreward.php']Daily Donator Reward[/url]</td></tr> <tr><td>[url='friendslist.php']Friends List[/url]</td></tr> <tr><td>[url='blacklist.php']Black List[/url]</td></tr>"; } print "<th>[b]Account[/b]</th> <tr><td>[url='preferences.php']Preferences[/url]</td></tr> <tr><td>[url='preport.php']Player Report[/url]</td></tr> <tr><td>[url='bugtracker.php']Bug Report[/url]</td></tr> <tr><td>[url='suggestions.php']Game Suggestions[/url]</td></tr> <tr><td>[url='help.php']Help Tutorial[/url]</td></tr> <tr><td>[url='gamerules.php']Game Rules[/url]</td></tr> <tr><td>[url='viewuser.php?u={$ir[']My Profile[/url]</td></tr> <tr><td>[url='logout.php']Logout[/url]</td></tr> </table>"; { Print "Time is: "; echo date('g:i:s a'); } ?>

Coming up with a syntex error now.   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 'a','sfgsgf','','',0,0,100,1,1,5,0,0,'')', '/creategang.php', unix_timestamp())' at line 2

Yes i have run it with the code, but thats the errors that i keep getting.

Now im getting: Notice: Undefined variable: userid in /home/********/public_html/cron_hour.php on line 66 Fatal error: Call to undefined function event_add() in /home/********/public_html/class/class_db_mysql.php on line 91

Hey everyone, got wonderful query for you all. 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 'apples','mangos','','',0,0,100,1,1,5,0,0,'','','')', '/creategang.php', unix_tim' at line 2   My lovely bit of codes thats in creategang.php:   <?phpinclude "globals.php";if($ir['money'] < 500000){die("You don't have enough money. You need \$500,000.");}if($ir['gang']){die ("You're already in a gang!");}if($_POST['submit']){$name=htmlspecialchars($_POST['name']);$desc=htmlspecialchars($_POST['desc']);$db->query("INSERT INTO gangs VALUES('','$name','$desc','','',0,0,100,$userid,$userid,5,0,0,'','','')");$i=$db->insert_id();$db->query("UPDATE users SET gang=$i,money=money-500000 where userid=$userid");print "Gang created!";}else{print "<h3> Create A Gang </h3><form action='creategang.php' method='post'><input type='hidden' name='submit' value='1' />Name:<input type='text' name='name' /> Description: <textarea name='desc' cols='40' rows='7'></textarea> <input type='submit' value='Create Gang for \$500,000' /></form>";}$h->endpage();?>     Just the bog standard mccodes coding, can anyone help me on this fine evening?

im now getting these errors Notice: Undefined index: code in /home/*********/public_html/cron_hour.php on line 5 Buzz off! Notice: Undefined variable: h in /home/*********/public_html/cron_hour.php on line 7 Fatal error: Call to a member function endpage() on a non-object in /home/*********/public_html/cron_hour.php on line 7

hey guys, i keep getting this error, and have had a few more...   Notice: Undefined index: code in /home/********/public_html/cron_hour.php on line 5     <?php error_reporting(E_ALL); include "config.php"; global $_CONFIG; if($_GET['code'] != $_CONFIG['code']) { die(""); } 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']; } $db->query("UPDATE gangs SET gangCHOURS=gangCHOURS-1 WHERE gangCRIME>0"); $q=$db->query("SELECT g.*,oc.* FROM gangs g LEFT JOIN orgcrimes oc ON g.gangCRIME=oc.ocID WHERE g.gangCRIME > 0 AND g.gangCHOURS = 0"); while($r=$db->fetch_row($q)) { $suc=rand(0,1); if($suc) { $log=$r['ocSTARTTEXT'].$r['ocSUCCTEXT']; $muny=(int) (rand($r['ocMINMONEY'],$r['ocMAXMONEY'])); $log=str_replace(array("{muny}","'"),array($muny,"''"),$log); $db->query("UPDATE gangs SET gangMONEY=gangMONEY+$muny,gangCRIME=0 WHERE gangID={$r['gangID']}"); $db->query("INSERT INTO oclogs VALUES ('',{$r['ocID']},{$r['gangID']}, '$log', 'success', $muny, '{$r['ocNAME']}', unix_timestamp())"); $i=$db->insert_id(); $qm=$db->query("SELECT * FROM users WHERE gang={$r['gangID']}"); while($rm=$db->fetch_row($qm)) { event_add($rm['userid'],"Your Gang's Organised Crime Succeeded. Go [url='oclog.php?ID=$i']here[/url] to view the details.",$c); } } else { $log=$r['ocSTARTTEXT'].$r['ocFAILTEXT']; $muny=0; $log=str_replace(array("{muny}","'"),array($muny,"''"),$log); $db->query("UPDATE gangs SET gangCRIME=0 WHERE gangID={$r['gangID']}"); $db->query("INSERT INTO oclogs VALUES ('',{$r['ocID']},{$r['gangID']}, '$log', 'failure', $muny, '{$r['ocNAME']}', unix_timestamp())"); $i=$db->insert_id(); $qm=$db->query("SELECT * FROM users WHERE gang={$r['gangID']}"); while($rm=$db->fetch_row($qm)) { event_add($rm['userid'],"Your Gang's Organised Crime Failed. Go [url='oclog.php?ID=$i']here[/url] to view the details.",$c); } } } if(date('G')==17) { $db->query("UPDATE users u LEFT JOIN userstats us ON u.userid=us.userid LEFT JOIN jobs j ON j.jID=u.job LEFT JOIN jobranks jr ON u.jobrank=jr.jrID SET u.money=u.money+jr.jrPAY, u.jobpoints=u.jobpoints+jr.jrPOINTS, u.exp=u.exp+(jr.jrPAY/20) WHERE u.job > 0 AND u.jobrank > 0 AND laston>unix_timestamp()-172800"); $db->query("UPDATE users u LEFT JOIN userstats us ON u.userid=us.userid LEFT JOIN jobs j ON j.jID=u.job LEFT JOIN jobranks jr ON u.jobrank=jr.jrID SET u.money=u.money+jr.jrPAY WHERE u.job > 0 AND u.jobrank > 0 AND laston>unix_timestamp()-172800"); } if($set['validate_period'] == 60 && $set['validate_on']) { $db->query("UPDATE users SET verified=0"); } $db->query("UPDATE users SET minus_clicks=0 WHERE userid=$userid"); $db->query("UPDATE users SET clickend=0 WHERE userid=$userid"); { $db->query(sprintf("UPDATE users SET view_tv = %u, sleep_sofa = %u",0,0)); } ?>

Do you know what, if no one is going to offer any help and aint going help me get my money back, then i just wont bother posting my problems about users.

  Firstly, if your going to say my name, spell it right. Secondly, i have gone through all means and have contacted him directly, with no success, The Admins of MWG told me to post about this. Finally, please do not post if you do not have any helpful advice and/or information about ishmell.

I just want my money back. I would love for the template to be given to me, but if all else fails, i just want to settle it and have my money back.

Well i aint settling until i get my layout or my money back, as i will take legal action against him, and he knows i will, as he has received numerous emails from myself stating what my lawyer has told me to do. So its simple for him, money back or template made.

Although, you still have not completed my game layout and i am still awaiting a message from you. You havnt even told me whats happening with the game template any more. You've been paid and have had over 3 months and you still havnt got back to me... Put your customers first or give me my money back.

Fully agree lmao

Ok, can we be bit nicer to each other please :) Its ment to a friendly community? Well i thought it was anyway... Anyone got any comments on my little mod?

Hey everyone, I am looking to pay/buy a secure and working voting script. All the ones i've ever used have gone wappy on me and have buggered up a good'n. So i would like to pay someone or buy a secure one from someone. If someone can help me, please PM me with the price you want, and we can come to some arrangement. Also, i have a few more mods i want creating in the near future. So, if the price is right and you create the script for me, i'll give you that work too. Possibly come up with some form of payment, monthly or per mod. Depends how much i want doing in the near future. But if someone can help me it would be very appreciated. Cheers, Monkey

Danny696 Has sorted it. He's a star :D

Can't wait for this one :D

Hey, can someone PM me and have alook at my explore. Its not showing anything, and i don't what to do. It shows a white screen :S

print and echo has no speed different, what ive heard is that apperently echo can be used with more with functions and its more of a PHP 6 thing. but also i think what you have done Monkey644 will work but it help if it wasnt all on 1 line so its easier to see/copy. My bad, i dont have a clue how to make it as paragraphs :S And thanks For feedback :)

I Made the donator one :D Got bored earlier, shows how easy it, if i've done it :)   [mccode v2.x] Donator days editing through Staff panel.

Hey guys, This my first little attempt at something like this. It's only small and basic, but can be very helpful. It give admins the chance to edit users donator days accordingly in the "Edit Users" area. So, give it a whirle and let me know what you think. :) Firstly, Open staff_users.php Find:   print "<h3>Editing User</h3><form action='staff_users.php?action=editusersub' method='post'><input type='hidden' name='userid' value='{$_POST['user']}' />Username: <input type='text' name='username' value='{$itemi['username']}' /> Login Name: <input type='text' name='login_name' value='{$itemi['login_name']}' /> Duties: <input type='text' name='duties' value='{$itemi['duties']}' /> Staff Notes: <input type='text' name='staffnotes' value='{$itemi['staffnotes']}' /> Level: <input type='text' name='level' value='{$itemi['level']}' /> Money: \$<input type='text' name='money' value='{$itemi['money']}' /> Bank: \$<input type='text' name='bankmoney' value='{$itemi['bankmoney']}' /> Cyber Bank: \$<input type='text' name='cybermoney' value='{$itemi['cybermoney']}' /> Crystals: <input type='text' name='crystals' value='{$itemi['crystals']}' /> Mail Ban: <input type='text' name='mailban' value='{$itemi['mailban']}' /> Mail Ban Reason: <input type='text' name='mb_reason' value='{$itemi['mb_reason']}' /> Forum Ban: <input type='text' name='forumban' value='{$itemi['forumban']}' /> Forum Ban Reason: <input type='text' name='fb_reason' value='{$itemi['fb_reason']}' /> Hospital time: <input type='text' name='hospital' value='{$itemi['hospital']}' /> Hospital reason: <input type='text' name='hospreason' value='{$itemi['hospreason']}' /> Jail time: <input type='text' name='jail' value='{$itemi['jail']}' /> Jail reason: <input type='text' name='jail_reason' value='{$itemi['jail_reason']}' /> House: ".house2_dropdown($c, "maxwill", $itemi['maxwill'])." <h4>Stats</h4>Strength: <input type='text' name='strength' value='{$itemi['strength']}' /> Agility: <input type='text' name='agility' value='{$itemi['agility']}' /> Guard: <input type='text' name='guard' value='{$itemi['guard']}' /> Labour: <input type='text' name='labour' value='{$itemi['labour']}' /> IQ: <input type='text' name='IQ' value='{$itemi['IQ']}' /> <input type='submit' value='Edit User' /></form>";   Replace with:   print "<h3>Editing User</h3><form action='staff_users.php?action=editusersub' method='post'><input type='hidden' name='userid' value='{$_POST['user']}' />Username: <input type='text' name='username' value='{$itemi['username']}' /> Login Name: <input type='text' name='login_name' value='{$itemi['login_name']}' /> Duties: <input type='text' name='duties' value='{$itemi['duties']}' /> Staff Notes: <input type='text' name='staffnotes' value='{$itemi['staffnotes']}' /> Level: <input type='text' name='level' value='{$itemi['level']}' /> Money: \$<input type='text' name='money' value='{$itemi['money']}' /> Bank: \$<input type='text' name='bankmoney' value='{$itemi['bankmoney']}' /> Cyber Bank: \$<input type='text' name='cybermoney' value='{$itemi['cybermoney']}' /> Crystals: <input type='text' name='crystals' value='{$itemi['crystals']}' /> Donator Days: <input type='text' name='donatordays' value='{$itemi['donatordays']}' /> Mail Ban: <input type='text' name='mailban' value='{$itemi['mailban']}' /> Mail Ban Reason: <input type='text' name='mb_reason' value='{$itemi['mb_reason']}' /> Forum Ban: <input type='text' name='forumban' value='{$itemi['forumban']}' /> Forum Ban Reason: <input type='text' name='fb_reason' value='{$itemi['fb_reason']}' /> Hospital time: <input type='text' name='hospital' value='{$itemi['hospital']}' /> Hospital reason: <input type='text' name='hospreason' value='{$itemi['hospreason']}' /> Jail time: <input type='text' name='jail' value='{$itemi['jail']}' /> Jail reason: <input type='text' name='jail_reason' value='{$itemi['jail_reason']}' /> House: ".house2_dropdown($c, "maxwill", $itemi['maxwill'])." <h4>Stats</h4>Strength: <input type='text' name='strength' value='{$itemi['strength']}' /> Agility: <input type='text' name='agility' value='{$itemi['agility']}' /> Guard: <input type='text' name='guard' value='{$itemi['guard']}' /> Labour: <input type='text' name='labour' value='{$itemi['labour']}' /> IQ: <input type='text' name='IQ' value='{$itemi['IQ']}' /> <input type='submit' value='Edit User' /></form>";   And then, still in staff_users.php, find:   print "You did not fully fill out the form.";$_POST['user']=$_POST['userid'];edit_user_form();}else{$_POST['level']=(int) $_POST['level'];$_POST['strength']=abs((float) $_POST['strength']);$_POST['agility']=abs((float) $_POST['agility']);$_POST['guard']=abs((float) $_POST['guard']);$_POST['labour']=abs((float) $_POST['labour']);$_POST['IQ']=abs((float) $_POST['IQ']);$_POST['money']=(float) $_POST['money'];$_POST['bankmoney']=(float) $_POST['bankmoney'];$_POST['cybermoney']=(float) $_POST['cybermoney'];$_POST['crystals']=(float) $_POST['crystals'];$_POST['mailban']=(int) $_POST['mailban'];$_POST['forumban']=(int) $_POST['forumban'];$maxwill=abs((int) $_POST['maxwill']);   And Replace with:   print "You did not fully fill out the form.";$_POST['user']=$_POST['userid'];edit_user_form();}else{$_POST['level']=(int) $_POST['level'];$_POST['strength']=abs((float) $_POST['strength']);$_POST['agility']=abs((float) $_POST['agility']);$_POST['guard']=abs((float) $_POST['guard']);$_POST['labour']=abs((float) $_POST['labour']);$_POST['IQ']=abs((float) $_POST['IQ']);$_POST['money']=(float) $_POST['money'];$_POST['bankmoney']=(float) $_POST['bankmoney'];$_POST['cybermoney']=(float) $_POST['cybermoney'];$_POST['crystals']=(float) $_POST['crystals'];$_POST['donatordays']=abs((int) $_POST['donatordays']);$_POST['mailban']=(int) $_POST['mailban'];$_POST['forumban']=(int) $_POST['forumban'];$maxwill=abs((int) $_POST['maxwill']);   Then, still in the same file :), find:   exit;}$oq=$db->query("SELECT * FROM users WHERE userid={$_POST['userid']}");$rm=$db->fetch_row($oq);$will=($rm['will'] > $maxwill) ? $maxwill: $rm['will'];$energy=10+$_POST['level']*2;$nerve=3+$_POST['level']*2;$hp=50+$_POST['level']*50;$db->query("UPDATE users SET username='{$_POST['username']}', level={$_POST['level']}, money={$_POST['money']}, crystals={$_POST['crystals']}, energy=$energy, brave=$nerve, maxbrave=$nerve, maxenergy=$energy, hp=$hp, maxhp=$hp, hospital={$_POST['hospital']}, jail={$_POST['jail']}, duties='{$_POST['duties']}', staffnotes='{$_POST['staffnotes']}', mailban={$_POST['mailban']}, mb_reason='{$_POST['mb_reason']}', forumban={$_POST['forumban']}, fb_reason='{$_POST['fb_reason']}', hospreason='{$_POST['hospreason']}', jail_reason='{$_POST['jail_reason']}', login_name='{$_POST['login_name']}', will=$will, maxwill=$maxwill WHERE userid={$_POST['userid']}");$db->query("UPDATE userstats SET strength={$_POST['strength']}, agility={$_POST['agility']}, guard={$_POST['guard']}, labour={$_POST['labour']}, IQ={$_POST['IQ']} WHERE userid={$_POST['userid']}");stafflog_add("Edited user {$_POST['username']} [{$_POST['userid']}]");print "User edited....";   And Replace with:   exit;}$oq=$db->query("SELECT * FROM users WHERE userid={$_POST['userid']}");$rm=$db->fetch_row($oq);$will=($rm['will'] > $maxwill) ? $maxwill: $rm['will'];$energy=10+$_POST['level']*2;$nerve=3+$_POST['level']*2;$hp=50+$_POST['level']*50;$db->query("UPDATE users SET username='{$_POST['username']}', level={$_POST['level']}, money={$_POST['money']}, crystals={$_POST['crystals']}, donatordays={$_POST['donatordays']}, energy=$energy, brave=$nerve, maxbrave=$nerve, maxenergy=$energy, hp=$hp, maxhp=$hp, hospital={$_POST['hospital']}, jail={$_POST['jail']}, duties='{$_POST['duties']}', staffnotes='{$_POST['staffnotes']}', mailban={$_POST['mailban']}, mb_reason='{$_POST['mb_reason']}', forumban={$_POST['forumban']}, fb_reason='{$_POST['fb_reason']}', hospreason='{$_POST['hospreason']}', jail_reason='{$_POST['jail_reason']}', login_name='{$_POST['login_name']}', will=$will, maxwill=$maxwill WHERE userid={$_POST['userid']}");$db->query("UPDATE userstats SET strength={$_POST['strength']}, agility={$_POST['agility']}, guard={$_POST['guard']}, labour={$_POST['labour']}, IQ={$_POST['IQ']} WHERE userid={$_POST['userid']}");stafflog_add("Edited user {$_POST['username']} [{$_POST['userid']}]");print "User edited....";   And your done :). Easy little mod, but can help alot :) Thanks, Monkey644

Looks good, but im happy with my player report :) First post also :D