Danny696

Re: MCCodes V2 Installation problem did you delete the applications table? if you did go check if its there or not it may have been added and if it is do the second thing i said. Add me on [email protected]

Re: MCCodes V2 Installation problem sorry i just find it hard to belive that theres like 20 posts on here saying the same thing you need to go to phpmyadmin and delete the table called aplications if youve allready set up all the tables just find in installer $fo=fopen("dbdata.sql","r"); and replace with $fo=fopen("","r");//dbdata.sql - So you know what the file is

Re: MCCodes V2 Installation problem   read it slowly then you may find out

Re: help on fields? explain to me exacly what you mean im not sure what you mean

Re: Good && Evil i can edit the default shops mod for ya now

Re: Quests!! Can i ask why you are adding the functions into gloabls.php and global_func.php they only need to be in global_func.php ;)

Re: help on fields? Very good advice and if you do ask for help make it short, sweet and not too often

Re: Good && Evil Rite ican do the shops for you later as im busy with r/l stuff

Re: Some Questions and Ideas lettme check out the coding by just scrolling down to here i can see this erre > [url='staff_cquests.php?action=editquest']Edit Quest[/url] should be > [url='staff_quests.php?action=editquest']Edit Quest[/url] and in staff_quests.php it says //This contains course stuffs not good ;) For the error add these to global_func.php function quest_dropdown($connection,$ddname="quest",$selected=-1) { global $db; $ret="<select name='$ddname' type='dropdown'>"; $q=$db->query("SELECT * FROM quest ORDER BY questNAME ASC"); if($selected == -1) { $first=0; } else { $first=1; } while($r=$db->fetch_row($q)) { $ret.="\n<option value='{$r['questID']}'"; if ($selected == $r['questID'] || $first == 0) { $ret.=" selected='selected'";$first=1; } $ret.=">{$r['questNAME']}</option>"; } $ret.="\n</select>"; return $ret; } function questgroup_dropdown($connection,$ddname="questgroup",$selected=-1) { global $db; $ret="<select name='$ddname' type='dropdown'>"; $q=$db->query("SELECT * FROM questgroups ORDER BY qgNAME ASC"); if($selected == -1) { $first=0; } else { $first=1; } while($r=$db->fetch_row($q)) { $ret.="\n<option value='{$r['qgID']}'"; if ($selected == $r['qgID'] || $first == 0) { $ret.=" selected='selected'";$first=1; } $ret.=">{$r['qgNAME']}</option>"; } $ret.="\n</select>"; return $ret; } You may need to change some of it to fit your database

This mod was requested and ive made it and posted it here: to choose weather its good or evil: ALTER TABLE `items` ADD `gORe` enum('Good','Evil') NOT NULL default 'Good', then in staff items find Armor Defense: <input type='text' name='armor' value='0' /><hr /> the below add Good or Evil: <name='gORe' type='dropdown' /> <option value='Good'>Good< <option value='Evil'>Evil</option><hr /> then in the same file find $armor=abs((int) $_POST['armor']); and add below $gORe=$db->escape($_POST['gORe']); then find $m=$db->query("INSERT INTO items VALUES('',{$_POST['itmtype']},'$itmname','$itmdesc',{$_POST['itmbuyprice']},{$_POST['itmsellprice']},$itmbuy, '{$_POST['effect1on']}', '$efx1', '{$_POST['effect2on']}', '$efx2', '{$_POST['effect3on']}', '$efx3', $weapon, $armor)"); and replace with $m=$db->query("INSERT INTO items VALUES('',{$_POST['itmtype']},'$itmname','$itmdesc',{$_POST['itmbuyprice']},{$_POST['itmsellprice']},$itmbuy, '{$_POST['effect1on']}', '$efx1', '{$_POST['effect2on']}', '$efx2', '{$_POST['effect3on']}', '$efx3', $weapon, $armor, $gORe)");   Then later in the file find the edit part and find this Armor Defense: <input type='text' name='armor' value='{$itemi['armor']}' /><hr /> and under it add this: Good or Evil: <name='gORe' type='dropdown' value='{$itemi['gORe']}' /> <option value='Good'>Good< <option value='Evil'>Evil</option><hr /> then find $armor=abs((int) $_POST['armor']); and under add $gORe=$db->escape($_POST['gORe']); then find $m=$db->query("INSERT INTO items VALUES('{$_POST['itmid']}',{$_POST['itmtype']},'$itmname','$itmdesc',{$_POST['itmbuyprice']},{$_POST['itmsellprice']},$itmbuy, '{$_POST['effect1on']}', '$efx1', '{$_POST['effect2on']}', '$efx2', '{$_POST['effect3on']}', '$efx3', $weapon, $armor)"); and replace with $m=$db->query("INSERT INTO items VALUES('',{$_POST['itmtype']},'$itmname','$itmdesc',{$_POST['itmbuyprice']},{$_POST['itmsellprice']},$itmbuy, '{$_POST['effect1on']}', '$efx1', '{$_POST['effect2on']}', '$efx2', '{$_POST['effect3on']}', '$efx3', $weapon, $armor, $gORe)"); Find in inventory.php <td class=\"h\">Links</td> and after add <td class=\"h\">Good or Evil</td> then find print "</table>"; and add above print "<tr><td>{$i['gORe']}";   ALTER TABLE `users` ADD `gore` enum('Good','Evil') NOT NULL default 'Good'; then in viewuser.php find Gender: {$r['gender']} and below add Good or Evil: {$r['gore']} open register and find $db->query("INSERT INTO users (username, login_name, userpass, level, money, crystals, donatordays, user_level, energy, maxenergy, will, maxwill, brave, maxbrave, hp, maxhp, location, gender, signedup, email, bankmoney, lastip, lastip_signup) VALUES( '{$username}', '{$username}', md5('{$_POST['password']}'), 1, $sm, 0, 0, 1, 12, 12, 100, 100, 5, 5, 100, 100, 1, '{$_POST['gender']}', unix_timestamp(), '{$_POST['email']}', -1, '$IP', '$IP')"); then repace with $db->query("INSERT INTO users (username, login_name, userpass, level, money, crystals, donatordays, user_level, energy, maxenergy, will, maxwill, brave, maxbrave, hp, maxhp, location, gender, signedup, email, bankmoney, lastip, lastip_signup, gore) VALUES( '{$username}', '{$username}', md5('{$_POST['password']}'), 1, $sm, 0, 0, 1, 12, 12, 100, 100, 5, 5, 100, 100, 1, '{$_POST['gender']}', unix_timestamp(), '{$_POST['email']}', -1, '$IP', '$IP', '{$_POST['gore']}')"); then find <tr> <td>Gender</td> <td colspan='2'><select name='gender' type='dropdown'> <option value='Male'>Male <option value='Female'>Female</select></td> </tr> and user add <tr> <td>Good or Evil</td> <td colspan='2'><select name='gore' type='dropdown'> <option value='Good'>Good <option value='Evil'>Evil</select></td> </tr>   Register coming soon

Re: [v2] Karma Level LMAO nice mod sniko youve posted this twice now haha

Re: Some Questions and Ideas Sniko that doesnt answer his question of good and evil weapons heres what you could try not sure if itll work but im sure you get the idea: to choose weather its good or evil: ALTER TABLE `items` ADD `gORe` enum('Good','Evil') NOT NULL default 'Good', then in staff items find Armor Defense: <input type='text' name='armor' value='0' /><hr /> the below add Good or Evil: <name='gORe' type='dropdown' /> <option value='Good'>Good< <option value='Evil'>Evil</option><hr /> then in the same file find $armor=abs((int) $_POST['armor']); and add below $gORe=$db->escape($_POST['gORe']); then find $m=$db->query("INSERT INTO items VALUES('',{$_POST['itmtype']},'$itmname','$itmdesc',{$_POST['itmbuyprice']},{$_POST['itmsellprice']},$itmbuy, '{$_POST['effect1on']}', '$efx1', '{$_POST['effect2on']}', '$efx2', '{$_POST['effect3on']}', '$efx3', $weapon, $armor)"); and replace with $m=$db->query("INSERT INTO items VALUES('',{$_POST['itmtype']},'$itmname','$itmdesc',{$_POST['itmbuyprice']},{$_POST['itmsellprice']},$itmbuy, '{$_POST['effect1on']}', '$efx1', '{$_POST['effect2on']}', '$efx2', '{$_POST['effect3on']}', '$efx3', $weapon, $armor, $gORe)");   Then later in the file find the edit part and find this Armor Defense: <input type='text' name='armor' value='{$itemi['armor']}' /><hr /> and under it add this: Good or Evil: <name='gORe' type='dropdown' value='{$itemi['gORe']}' /> <option value='Good'>Good< <option value='Evil'>Evil</option><hr /> then find $armor=abs((int) $_POST['armor']); and under add $gORe=$db->escape($_POST['gORe']); then find $m=$db->query("INSERT INTO items VALUES('{$_POST['itmid']}',{$_POST['itmtype']},'$itmname','$itmdesc',{$_POST['itmbuyprice']},{$_POST['itmsellprice']},$itmbuy, '{$_POST['effect1on']}', '$efx1', '{$_POST['effect2on']}', '$efx2', '{$_POST['effect3on']}', '$efx3', $weapon, $armor)"); and replace with $m=$db->query("INSERT INTO items VALUES('',{$_POST['itmtype']},'$itmname','$itmdesc',{$_POST['itmbuyprice']},{$_POST['itmsellprice']},$itmbuy, '{$_POST['effect1on']}', '$efx1', '{$_POST['effect2on']}', '$efx2', '{$_POST['effect3on']}', '$efx3', $weapon, $armor, $gORe)");

Re: [v2] Create a Crystal   i ment to do that why do 3 querys when you can do one and tell me the exact error and then i can fix it

Re: [v2] Create a Crystal   ALTER TABLE users ADD makecrystal INT(11) DEFAULT 0; ALTER TABLE users ADD crystalmake INT(11) DEFAULT 5;

Re: [v2] Create a Crystal rite one minute

Re: [v2] Create a Crystal Rite ive done it ALTER TABLE users ADD makecrystal INT(11) DEFAULT 0; ALTER TABLE users ADD crystalmake INT(11) DEFAULT '5'; change 5 to the number that you want users to make a day Add this to Day cron $db->query("UPDATE users SET crystalmake=5 WHERE crystalmake < 5"); And replace makecrystal.php with this <?php include "globals.php"; if($ir['makecrystal'] == 0) { die("Making a crystal without materials? Good luck!"); } if($ir['crystalmake'] == 0) { die("You have made the maximum of 5 crystals today comeback tommorow and make 5 more."); // change number if you want more/less crystals per day } else { if($ir['makecrystal'] == 1) { //set $win prize winings $win=rand(100,250); $loss=rand(100,300); $make= ($ir['crystalmake']); if(rand(1,30) <= 14) { print "You build a crystal successfully and gain $win exp!"; echo' You can make $make more crystals today.'; $db->query("UPDATE users SET exp=exp+$win, crystals=cryastals+1, crystalmake=crystalmake-1, makecrystal=0 WHERE userid=$userid",$c); } else { if(rand(1,30) <= 15) { print "You build a crystal successfully and gain $win exp!"; $db->query("UPDATE users SET exp=exp+$win, crystals=cryastals+1, crystalmake=crystalmake-1, makecrystal=0 WHERE userid=$userid",$c); } else { if(rand(1,30) <= 5) { print "You build a crystal but it falls apart..."; $db->query("UPDATE users SET crystalmake=crystalmake-1, makecrystal=0 WHERE userid=$userid",$c); } } } } } ?> in makecrystal.php ive make the querys all one instead of 3

Re: Count Down Clock   ive done something like that but why would it be $set

Re: FIRST THOUGH! //yup and elephant ;)

Re: Crimes post up your code

Re: [v2] Create a Crystal mabey have this as a rare currency so you have to have ... items to make a (lets say) ruby etc

Re: Lucky Boxes Re-code nice re-code i would use it but i just recoded mine aswell :P not as good as yours tho

Re: cron job help? free thats most probabbly your problem

Re: need some help? i dont get it? do what wolfe said and also learn PHP

Re: need some help? i dont get it? http://criminalexistence.com/ceforums/i ... 49.0 thats karlos' annoucements

Re: need some help? i dont get it?   only one database and thats phpmyadmin if ya wanna create a new table why alter a table basic mysql is understandable by alot of newbies use karlos' annoucement there probabbly the best ones on here that doesnt even use the annocuements table and running the installer again is dropping all the database and runnning installer.php again