Tonka

Re: Free 2 - Gym find where friends list and blacklist are and just add it there

Re: Owner Panel V.2 they look almost identical except for your use "cellspacing='1' class='table'" and mine doesn't and mine links have been moved around Mine; Houndbites; and here's proof that iv'e had it since before you released this code notice the dates of date of backup and date modified

Re: Activation code and cron V.2 there is a table called confirm which we need the code for aswell as the bit to alter the users table. here's the bit for the users table, ALTER TABLE `users` ADD `confirm` INT( 11 ) NOT NULL ; also this is for v1, and where is the register function to insert the data into confirm?

Re: [V2] Ignore User Mail [V2] thanks for the v1 boggl

Re: Owner Panel V.2 then why are the codes exactly the same? here's mine   <?php include "sglobals.php"; if($ir['user_level'] != 2) { die("You are not alowed here"); } if($_POST['submit']) $tresder=(int) rand(100,999); print "[b]WELCOLME ".$ir['username'].".[/b] <table width=75% border='2'><tr height=100><td valign=top> [b]<u>Quick links</u>[/b] [url='staff.php']Staff Panel[/url] [url='bugreport.php']Bug Reports[/url] [url='staff_users.php?action=reportsview']Player Reports[/url] <td valign=top> [b]<u>General</u>[/b] [url='staff.php?action=appview']Staff Apps[/url] [url='staff.php?action=basicset']Basic Settings[/url] [url='staff.php?action=announce']Add an Announcement[/url] </td> <td valign=top> [b]<u>Users</u>[/b] [url='staff_users.php?action=newuser']Create New User[/url] [url='staff_users.php?action=edituser']Edit User[/url] [url='staff_users.php?action=deluser']Delete User[/url] [url='staff_users.php?action=invbeg']View User Inventory[/url] [url='staff_users.php?action=creditform']Credit User[/url] [url='staff_users.php?action=masscredit']Mass Payment[/url] [url='staff_users.php?action=forcelogout']Force User Logout[/url]</td> <td valign=top> [b]<u>Items</u>[/b] [url='staff_items.php?action=newitem']Create New Item[/url] [url='staff_items.php?action=giveitem']Give User a Item[/url] [url='staff_items.php?action=massitemgive']Mass Give Items[/url] [url='staff_items.php?action=edititem']Edit Item[/url] [url='staff_items.php?action=killitem']Delete An Item[/url] [url='staff_items.php?action=newitemtype']Add Item Type[/url]</td></tr> <tr height=100><td valign=top> [b]<u>Logs</u>[/b] [url='staff_logs.php?action=maillogs']Mail Logs[/url] [url='staff_logs.php?action=atklogs']Attack Logs[/url] [url='staff_logs.php?action=itmlogs']Item Xfer Logs[/url] [url='staff_logs.php?action=cashlogs']Cash Xfer Logs[/url] [url='staff_logs.php?action=cryslogs']Crystal Xfer Logs[/url] [url='staff_logs.php?action=banklogs']Bank Xfer Logs[/url] [url='staff_ganglogs.php']Advanced Gang Logs[/url] [url='staff_logs.php?action=stafflogs']Staff Logs[/url]</td> <td valign=top> [b]<u>Donator Logs</u>[/b] [url='staff_donators.php?action=dplogs']Donator Pack Logs[/url] [url='staff_donators.php?action=splogs']Supporter Pack Logs[/url] [url='staff_donators.php?action=wplogs']Will Potion Logs[/url] [url='staff_donators.php?action=bglogs']Bodyguard Logs[/url] [url='staff_donators.php?action=jklogs']Jail Key Logs[/url] [url='staff_donators.php?action=bplogs']Brave Potions Logs[/url] [url='staff_donators.php?action=pplogs']Party Pack Logs[/url]</td> <td valign=top> [b]<u>Gangs</u>[/b] [url='staff_gangs.php?action=grecord']Gang Record[/url] [url='staff_gangs.php?action=gcredit']Credit Gang[/url] [url='staff_gangs.php?action=gwar']Manage Gang Wars[/url] [url='staff_gangs.php?action=gedit']Edit Gang[/url] [url='staff_gangs.php?action=gedel']Delete Gang[/url] [url='staff_gangs.php?action=createoc']Create Organised Crime[/url]</td> <td valign=top> [b]<u>Shops</u>[/b] [url='staff_shops.php?action=newshop']Create a New Shop[/url] [url='staff_shops.php?action=newstock']Add Item To Shop[/url] [url='staff_shops.php?action=delshopl']Delete shop[/url] <tr height=100><td valign=top> [b]<u>Jobs</u>[/b] [url='staff_jobs.php?action=newjob']Make a new Job[/url] [url='staff_jobs.php?action=jobedit']Edit a Job[/url] [url='staff_jobs.php?action=jobdele']Delete a Job[/url] [url='staff_jobs.php?action=newjobrank']Make a new Job Rank[/url] [url='staff_jobs.php?action=jobrankedit']Edit a Job Rank[/url] [url='staff_jobs.php?action=jobrankdele']Delete a Job Rank[/url]</td> <td valign=top> [b]<u>Houses</u>[/b] [url='staff_houses.php?action=addhouse']Make A new House[/url] [url='staff_houses.php?action=edithouse']Edit House[/url] [url='staff_houses.php?action=delhouse']Remove House[/url] <hr /> [b]<u>Cities</u>[/b] [url='staff_cities.php?action=addcity']Add A New City[/url] [url='staff_cities.php?action=editcity']Edit City[/url] [url='staff_cities.php?action=delcity']Remove City[/url]</td> <td valign=top> [b]<u>Courses</u>[/b] [url='staff_courses.php?action=addcourse']Create a New Course[/url] [url='staff_courses.php?action=editcourse']Edit Course[/url] [url='staff_courses.php?action=delcourse']Delete Course[/url]</td> <td valign=top> [b]<u>Crimes</u>[/b] [url='staff_crimes.php?action=newcrime']Make a New Crime[/url] [url='staff_crimes.php?action=editcrime']Edit a Crime[/url] [url='staff_crimes.php?action=delcrime']Delete a Crime[/url] [url='staff_crimes.php?action=newcrimegroup']Make a new Crime Group[/url] [url='staff_crimes.php?action=editcrimegroup']Edit a Crime Group[/url] [url='staff_crimes.php?action=delcrimegroup']Delete a Crime Group[/url] [url='staff_crimes.php?action=reorder']Reorder Crime Groups[/url] </td></tr> <tr height=100><td valign=top> [b]<u>Battle Tent</u>[/b] [url='staff_battletent.php?action=addbot']Add Challenge Bot[/url] [url='staff_battletent.php?action=editbot']Edit Challenge Bot[/url] [url='staff_battletent.php?action=delbot']Remove Challenge Bot[/url]</td> <td valign=top> [b]<u>Punishments</u>[/b] [url='staff_punit.php?action=mailform']Mail Ban User[/url] [url='staff_punit.php?action=unmailform']Un-Mailban User[/url] [url='staff_punit.php?action=fedform']Fedjail User[/url] [url='staff_punit.php?action=fedeform']Edit Fedjail Sentence[/url] [url='staff_punit.php?action=unfedform']Unjail User[/url] [url='staff_punit.php?action=ipform']IP Search[/url] <td valign=top> [b]<u>Special</u>[/b] [url='staff_special.php?action=editnews']Edit Newspaper[/url] [url='staff_special.php?action=massmailer']Mass mailer[/url] [url='staff_special.php?action=stafflist']Staff List[/url] [url='staff_special.php?action=userlevelform']Adjust User Level[/url] [url='staff_special.php?action=givedpform']Give User Donator Pack[/url] </td> <td valign=top> [b]<u>Cpanel</u>[/b] [url='http://{$domain}:2082']cPanel Mainmenu[/url] [url='http://{$domain}:2082/frontend/x3/backup/index.html']Backup Game[/url] [url='http://{$domain}:2082/3rdparty/phpMyAdmin/index.php']phpMyAdmin[/url] [url='http://{$domain}:2082/frontend/x3/stats/errlog.html']Error Logs[/url] [url='http://{$domain}:2082/frontend/x3/cron/index.html']Edit crons[/url] ";*/ $h->endpage(); ?>

Re: FaceBook correction spudinski, it's 13 not 3

Re: Google Chrome i find that chrome has a lot of cool feature and much better memory management and another cool feature is that if one tab crashes or experiences problem,s your entire browser doesn't crash and get closed, just the one tab

Re: [V2] Ignore User Mail [V2] thanks paddy richard, it's a given that people will have to edit it to go with the flow of their game, but as long as credit is in, i'm fine with it i have also secured all the queries to the database

Re: Owner Panel V.2   it's not my work, i found it on ce in january/february and added it to my game, and have since mad changes to it

Re: [V2] Ignore User Mail [V2] i left credit in the post but removed it from the script

Re: Owner Panel V.2 here's mine, i've made a few design changes since i got it and i removed the cpanel links, but other than that they are exactly the same

Re: [MOD] This mod lets your Users Ignore Other Users Emails you can view the working mod here, http://criminalexistence.com/ceforums/index.php?topic=24954.0

hey guys i took illusions mod, http://criminalexistence.com/ceforums/index.php?topic=24887.0 and got it to work properly Updates - Username will now go to viewuser.php - Non-existent users can't be ignored - Users can't ignore staff - All print statements changed to echo create db table CREATE TABLE `ignore` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `userid` INT( 11 ) NOT NULL , `blocked` INT( 11 ) NOT NULL ) ENGINE = MYISAM ;   create ignore.php <?php /*----------------------------------------------------- -- Ignore User For MC Code V2 -- Free Mod -- [url]http://www.squangle.org[/url] -- By Tonka -- ignore.php -----------------------------------------------------*/ include "globals.php"; switch($_GET['action']) { case 'ignoreform': ignore_form(); break; case 'ignoresub': ignore_submit(); break; case 'unignore': unignore(); break; default; index(); break; } function index() { global $db,$userid; echo '<h3>Ignoring a user</h3> [url="'.$_SERVER['PHP_SELF'].'?action=ignoreform"]Add User To Be Ignored[/url] <table width="85%" cellspacing="1" class="table"> <th>User ID</th> <th>Username</th> <th>Remove?</th> <th>Status</th>'; $sql = sprintf(("SELECT `id`, `blocked` FROM `ignore` WHERE userid = %u"), $userid); $q = $db->query($sql); while($r=$db->fetch_row($q)) { $select = sprintf(("SELECT `username`, `laston` FROM `users` WHERE userid = %u"), $r['blocked']); $u2 = $db->query($select); $u=$db->fetch_row($u2); $username = $u['username']; $id = $r['id']; if($u['laston'] >= time()-15*60) { $on='<font color=green>[b]Online[/b]</font>'; } else { $on='<font color=red>[b]Offline[/b]</font>'; } echo '<tr><td>'; echo sprintf("%u", $r['blocked']); echo '</td><td>'; echo '<a href="viewuser.php?u='; echo sprintf("%u", $r['blocked']); echo '">'; echo $username; echo '</a>'; echo '</td><td>'; echo '<a href="'.$_SERVER['PHP_SELF'].'?action=unignore&id='; echo $id; echo '">Remove</a>'; echo '</td><td>'; echo $on; echo '</td></tr>'; } echo "</table>"; } function ignore_form() { echo '<h3>Ignore Mail From A Specified User</h3> The user will not be able to send you ingame mail. <form action="'.$_SERVER['PHP_SELF'].'?action=ignoresub" method="post"> ID of person to ignore: <input type="text" name="blid" /> <input type="submit" value="Ignore Future Mail" /></form>'; } function ignore_submit() { global $db,$userid; $blid = mysql_real_escape_string($_POST['blid']); $select = sprintf(("SELECT `userid`, `user_level` FROM `users` WHERE userid = %u"), $blid); $ul2 = $db->query($select); $ul=$db->fetch_row($ul2); if(empty($blid) or $blid == 0) { echo 'You did not enter a userid. [url="'.$_SERVER['PHP_SELF'].'?action=ignoreform"]Back[/url]'; } else if($ul['userid'] != $blid) { echo 'You can\'t ignore a non-existant user. [url="'.$_SERVER['PHP_SELF'].'?action=ignoreform"]Back[/url]'; } else if($ul['user_level'] != 1) { echo 'You can\'t ignore staff. [url="'.$_SERVER['PHP_SELF'].'?action=ignoreform"]Back[/url]'; } else if($blid == $userid) { echo 'You can\'t ignore yourself. [url="'.$_SERVER['PHP_SELF'].'?action=ignoreform"]Back[/url]'; } else { $insert = sprintf("INSERT INTO `ignore` (`id`, `userid`, `blocked`) VALUES ('NULL', '%u', '%u')", $userid, $blid); $db->query($insert); echo 'Users Mail will be Ignored. [url='.$_SERVER[']Return to ignore[/url]'; } } function unignore() { global $db,$userid; $delete = sprintf(("DELETE FROM `ignore` WHERE id=%u AND userid=%u"), mysql_real_escape_string($_GET['id']), $userid); $db->query($delete); echo 'User un-ignored. [url='.$_SERVER[']Return to ignore[/url]'; } $h->endpage(); ?>   open mailbox.php find <th>[url='contactlist.php']My Contacts[/url]</th></tr>   replace with <td>[url='contactlist.php']My Contacts[/url]</td> <td>[url='ignore.php']Ignore List[/url]</td></tr>   find function mail_compose() { global $db,$ir,$c,$userid,$h;   add under $select = sprintf(("SELECT `blocked` FROM `ignore` WHERE userid = %u AND blocked = %u"), $userid, $_GET['ID']); $q = $db->query($select); $r=$db->fetch_row($q); if($r['blocked']) { echo "This person has choosen to ignore mails from you. [url='mailbox.php']> Back[/url]"; $h->endpage(); exit; }

Re: Owner Panel V.2 than why is the code exactly the same, as well as the design?

Re: Owner Panel V.2 this wasn't from scratch, i've had this exact panel on my game since january or february

Re: PIjrc Chat V2 Jameos Way ! this is set to go to CE irc server

Re: [V2] PJIRC Chat Mod [V2] it's not really any better than the original if that's what your asking zero, the i only thing i did was make it connect to ce's irc server, made it so that the screen name used is whatever a users display name is from the variable {$ir['username']} and made it very easy to install. here are new link's, i also updated them in the first post http://www.squangle.org/mods/PJIRC.rar http://www.squangle.org/mods/PJIRC.zip

Re: Big gang problem, Cannot create if you added an extra column to you gang table that would be your problem, this should fix it INSERT INTO gangs VALUES('','test','test','','',0,0,100,3,3,5,0,0,'','')

Re: Big gang problem, Cannot create you had to have changed either creategang or the db, have you added any gang mods?

Hey guys, I figured I would make my own MD5 Generator for when I needed to hash stuff and also to practice securing mySQL queries to a DB. There are 3 versions, a standalone, one for mccode v1 and one for mccode v2. Here is the code for the standalone, the links to download the others are at the end. DB Table Query CREATE TABLE `gen` ( `id` int(11) NOT NULL auto_increment, `string` varchar(255) character set latin1 NOT NULL, `hash` varchar(32) character set latin1 NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; Create mysql.php <?php $c=mysql_connect('localhost','DB_User','DB_Password') or die(mysql_error()); mysql_select_db('DB_Name',$c); ?> Create md5.php <?php /*----------------------------------------------------- -- MD5 Generator -- Free Mod -- [url]http://www.squangle.org[/url] -- By Tonka -- md5.php -----------------------------------------------------*/ include "mysql.php"; print <<<EOF <html> <head> <title>MD5 Generator</title> </head> <body> EOF; switch($_GET['action']) { case "genmd5": genmd5(); break; case "select": select(); break; default: index(); break; } function index() { global $c; if (isset($_POST['submit']) && !empty($_POST['string'])) { $string1 = $_POST['string']; $string2 = md5($_POST['string']); echo sprintf("md5 ("%s") = "%s"", htmlentities( strip_tags($string1) ), $string2); htmlentities( strip_tags($string1) ), $string2); print <<<EOF <form action='md5.php' method='post'> <table border='0' width='50%'> <tr valign='bottom'> <td align='right'>Type the string: </td> <td align='left'><font size='-1'>(max. 255 chars)</font> <input type='text' name='string' size='50' maxlenth='255' /> </td> </tr> <tr><td colspan='2' align='center'><input type='submit' name='submit' value='Calculate MD5' /></form></td></tr> <tr><td colspan='2'>See already hashed word's [url='md5.php?action=select']Click Here[/url]</td></tr> </table> EOF; $astring1 = mysql_real_escape_string($string1); $insert = sprintf("INSERT INTO `gen` (`id`, `string`, `hash`) VALUES ('', '%s', '%s')",$astring1, $string2, $c); mysql_query($insert); //Used For Debugging //print " $insert"; } else { print "<form action='md5.php' method='post'> <table border='0' width='50%'> <tr valign='bottom'> <td align='right'>Type the string: </td> <td align='left'><font size='-1'>(max. 255 chars)</font> <input type='text' name='string' size='50' maxlenth='255' /> </td> </tr> <tr><td colspan='2' align='center'><input type='submit' name='submit' value='Calculate MD5' /></form></td></tr> <tr><td colspan='2'>See already hashed word's [url='md5.php?action=select']Click Here[/url]</td></tr> </table>"; } } function select() { global $c; $sql = sprintf("SELECT id, string, hash FROM gen"); $q = mysql_query($sql); print "<table border='1' width='80%'> <tr><td width='5%'>ID</td><td width='30%'>String</td><td width='65%'>Hash</td></tr>"; while($r=mysql_fetch_array($q)) { echo "<tr><td>"; echo sprintf("%u", $r['id']); echo "</td><td>"; echo sprintf("%s", $r['string']); echo "</td><td>"; echo sprintf("%s", $r['hash']); echo "</td></tr>"; } print "</table> [url='md5.php']Back to MD5 generator[/url]"; } print <<<EOF </body> </html> EOF; ?> Standalone - http://www.squangle.org/mods/md5.rar mccode v1 - http://www.squangle.org/mods/md5_v1.rar mccode v2 - http://www.squangle.org/mods/md5_v2.rar

Re: Bank Interest Thx Floydian, it worked perfectly

Re: Bank Interest anyone know how?

Re: Battletent [V2] I had the same problem here is the fix that i used, this is from Super-_-Mario FIND: $q2=$db->query("SELECT count(*) FROM challengesbeaten WHERE npcid=$v"); $times=$db->fetch_single($q2);   REPLACE: $q2=$db->query("SELECT count(*) FROM challengesbeaten WHERE npcid=$userid"); $times=$db->fetch_single($q2);   That Should work

i was wondering if any has had success with not giving bank interest to anyone that has been offline for a certain number of days, i have tried a few times but it didn't work here's what i have $db->query("UPDATE users SET bankmoney=bankmoney+(bankmoney/50) where bankmoney > 0 AND laston < (unix_timestamp() - 259200)") or die(mysql_error()); $db->query("UPDATE users SET cybermoney=cybermoney+(cybermoney/100*4) where cybermoney > 0 AND laston < (unix_timestamp() - 259200)") or die(mysql_error()); i'm not getting any error output at all and no one is getting any interest at all

Re: some clever person help me glad i could be of some assistance