Uridium

  Valid Point The Logs come with an Expiry Date and can be deleted on a date set by the Admin All logs can either be truncated at the same time of if you wish to keeps logs longer you can truncate individual logs on different dates so you can keep ones most needed and get rid of all or some of the ones you dont need. Failing this you can create and send your whole SQL to a defined folder on your FTP and have it update whenever you want it to.. Incase you need to revert back to it later (Remember however Data deleted before the SQL has been sent to FTP will be lost)

Few things i can see wrong on your script so im going to try help you out a bit but im not going to recode it for you.. As Savage mentioned a user could visit the page more than once as your script is now there isnt a way to stop this from happening without upsetting users at level.. example if you told the script to let if($ir['level'] ==5) then created a STOP function so once they have viewed and gained their Merit it wouldnt allow them to get another merit for level 5 this would then make it so users after that who get to level 10 would'nt be able to gain a merit due to level 5 stopping them. Same applies for the rest of the script you need to make it so it knows which merit to give then you can stop that merit if its been rewarded then the script moves onto the level 10 merit..

This mod will allow you to Setup Logs for anything in your game example Bank, attacking, staff, training, courses taken, course results searching areas (if added) in fact just about anything you want to make a log for in the pack it includes... 1 SQL TABLE 1 FILE 1 readme file Very Easy to Install and to Edit files needed for it to work.... Few screenies Drop Down Selection training Logs excuse my spelling on the image fat fingers at time Bank Logs This mod costs $20 and any future updates to this mod will be given free Paypal Addy [email protected] FOOTNOTE* When sending payment could you also include Your sites URL of where the Mod will be used and also An Email Address as to where i can send the Zipped Mod.... SOLD OUT

You could always complain to their hosting company and tell em from me they are Crap oops lol ;) http://www.atomicwebhosting.com/

Send me a copy to make mods with ? I aint paying for a licence to a game engine im never going to use publicly unless you count creating mods public :)

Nicely done Kieran :)

I cant comment on the Demo as it just uses 2 slots but im sure with a bit of editing you could make your version require 4 slots

I came across a script last night quite accidentaly and thought it would make for a decent mod.. How to install The SQLS Sqls Needed Working Demo DEMO I havent attempted to add this mod to a MCC working game but im sure those of you who want it to work will make it do so... Credit goes to Danny Van Kooten

After the current situation with the Burning Board Dowtime I feel its about time We the Public put it to a Vote as to the future of the Current situation..

This is a Mod that creates a Mod it isnt a running Mod its one that will allow you to setup Features on your game using the Script ive written for you. There after its up to you to continue the script on your own for it to work on your site....

I Totally agree with rulerofzu on this one

Your SQL bts at top of page are wrong matey... ft_like int(11) defult 0 AND ft_dislike int(11) defult 0 should be [mysql]ALTER TABLE `forum_topics` ADD `ft_like` INT (11) DEFAULT 0;[/mysql] [mysql]ALTER TABLE `forum_topics` ADD `ft_dislike` INT (11) DEFAULT 0;[/mysql]

Use a cookie session

youd need to create 2 new items bith that can be combined so example ID 11 and ID 12 so ID 11 Creates ID 12 then ID 12 creates the final outcome ID 13 Just to NOTE ABOVE you dont need to create NEW ITEMS to make the combine feature woirk you could just Edit any exsisting items to make them combinable

Thank you :)

Legend try running the Hour cron Manaually to see what Errors it gives.. if its a Cron problem it will always show errors.. Also on the jobs i Noticed you have jobspecials and not jobs unless this is a different data section

On tuesday the site was on and offline a total of 23 times whilst i was on MWG with the too many connections error took me 5 attempts to post the Combine mod And quess what whilst writing this ;) Fatal error: Connecting to MySQL server 'localhost' failed. You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=1203 Information: error message: Connecting to MySQL server 'localhost' failed. error code: 1203 sql type: MySQLDatabase sql error: User makewebg_forums already has more than 'max_user_connections' active connections sql error number: 1203 sql version: file: /home/makewebg/public_html/wcf/lib/system/database/MySQLDatabase.class.php (31) php version: 5.2.14 wcf version: 1.1.2 (Tempest) date: Thu, 03 Mar 2011 13:01:13 +0000 request: /index.php?page=Index referer: http://makewebgames.io/index.php?form=Search&searchID=138052 Stacktrace: #0 /home/makewebg/public_html/wcf/lib/system/database/Database.class.php(78): MySQLDatabase->connect() #1 /home/makewebg/public_html/wcf/lib/system/WCF.class.php(296): Database->__construct(...) #2 /home/makewebg/public_html/wcf/lib/system/WCF.class.php(95): WCF->initDB() #3 /home/makewebg/public_html/global.php(18): WCF->__construct() #4 /home/makewebg/public_html/index.php(8): require_once('/home/makewebg/...') #5 {main}

On tuesday the site was on and offline a total of 23 times whilst i was on MWG with the too many connections error took me 5 attempts to post the Combine mod

Update this is the same but with additional amount of items needed to create a new one which was mentioned by newttster   <?php ////////////////////////////////////////////////////////////////////////////////////////// /* THIS MOD WILL ALLOW YOU TO COMBINE ITEMS AND WEAPONS TO CREATE OTHER ITEMS OR WEAPONS*/ ////////////////////// ILLUSIONS 2011 FOR MCCODES V2 ////////////////////////// ////////////////////////////////////////////////////////////////////////////////////////// include "globals.php"; $_GET['ID'] = abs((int) $_GET['ID']); //Food if(!$_GET['ID']) { print "Invalid use of file"; } else { $i=$db->query("SELECT iv.*,i.*,it.* FROM inventory iv LEFT JOIN items i ON iv.inv_itemid=i.itmid LEFT JOIN itemtypes it ON i.itmtype=it.itmtypeid WHERE iv.inv_id={$_GET['ID']} AND iv.inv_userid=$userid"); if(mysql_num_rows($i) == 0) { print "Invalid item ID"; } $r=$db->fetch_row($i); if($r['itmid'] == 13) { print "You used your {$r['itmname']} to create a Master Potion"; item_add($userid, 2, 1); item_remove($userid, $r['inv_itemid'], 1); die(); $h->endpage(); } else { $p=$db->query("SELECT iv.*,i.*,it.* FROM inventory iv LEFT JOIN items i ON iv.inv_itemid=i.itmid LEFT JOIN itemtypes it ON i.itmtype=it.itmtypeid WHERE iv.inv_id={$_GET['ID']} AND iv.inv_userid=$userid"); $r=$db->fetch_row($p); if($r['itmid'] == 2) { print "You used your {$r['itmname']} to create a Wicked Potion"; item_add($userid, 13, 1); item_remove($userid, $r['inv_itemid'], 1); die(); $h->endpage(); } } // TOO KEEP ADDING COMBINES JUST KEEP ADDING THE BELOW CHANGING THE itmid too match Item Before Combining then change the item_add to the value of the item you want it to be combined too // dont forget to change this >> print "You used your {$r['itmname']} to create a Wicked Potion"; to be named for the item youve just created // // THE BELOW LINE HAS BEEN ADDED SO A USER NEEDS THE CORRECT NUMBER OF ITEMS TO MAKE A NEW ONE $p=$db->query("SELECT iv.*,i.*,it.* FROM inventory iv LEFT JOIN items i ON iv.inv_itemid=i.itmid LEFT JOIN itemtypes it ON i.itmtype=it.itmtypeid WHERE iv.inv_id={$_GET['ID']} AND iv.inv_userid=$userid"); $r=$db->fetch_row($p); if($r['itmid'] == 5 && $r['inv_qty'] < '50') { echo "you dont have 50 of this item to combine "; die(); } else { print "You used your {$r['itmname']} to create a New Axe"; item_add($userid, 1, 1); item_remove($userid, $r['inv_itemid'], 50); } } $h->endpage(); ?>

For those that are Interested in how this script was made. I used the orig V2 itemuse.php took out what was not needed and replaced with the new code.. inventory.php i just renamed the use link to combine and staff.php just added 4 new lines and edited the sql to insert the new one... All in all this mod took about 30 mins to complete using waht was already in the scripts...

Infact newttster your question before it is actually possible use the same principal as a bove BUT when deleting a item make it delete the amount you want then create a new combine for B and when thats combined it produces C :)

Its a free mod do with it as you wish just leave the copright intact and your fine :)

The probably is matey but this script doesnt support multiple items Had a nightmare just getting 1 item to work :)

This script may come in handy for those who wish to add something like BROKEN AXE as an Item and when Combined Creates a New Axe in replace of the old one or a Rusty Jail Key into a Usable Jail Key

Redone a bit of this so now you can combine both Items and Weapons to create something else. SQL [mysql]ALTER TABLE `items` ADD `combine` INT( 11 ) NOT NULL DEFAULT '0' AFTER `itmbuyable` ; [/mysql] Now open up inventory.php look for   if($i['effect1_on'] || $i['effect2_on'] || $i['effect3_on']) { print " <a href='itemuse.php?ID={$i['inv_id']}'>Use</a>"; }   and underneath add   if($i['combine'] > 0) { print " [a href='combine.php?ID={$i['inv_id']}'>Combine</a>"; }   now open up staff_items.php in the adding new item part look for   Item Sell Value: <input type='text' name='itmsellprice' />   Then Add underneath   Combine With Item ID: <input type='text' name='combine' />   in the INSERT query for adding an item add ,{$_POST['combine']} After the ,{$_POST['itemsellprice']} Now goto the edit Item find Item Type: ".itemtype_dropdown($c,'itmtype',$itemi['itmtype'])."   And underneath add   Combined With.: <input type='text' name='combine' value='{$itemi['combine']}' />   in the edit item part for the INSERT find ,$itmbuy, and next to it put '{$_POST['combine']}', now call this file combine.php   <?php ////////////////////////////////////////////////////////////////////////////////////////// /* THIS MOD WILL ALLOW YOU TO COMBINE ITEMS AND WEAPONS TO CREATE OTHER ITEMS OR WEAPONS*/ ////////////////////// ILLUSIONS 2011 FOR MCCODES V2 ////////////////////////// ////////////////////////////////////////////////////////////////////////////////////////// include "globals.php"; $_GET['ID'] = abs((int) $_GET['ID']); //Food if(!$_GET['ID']) { print "Invalid use of file"; } else { $i=$db->query("SELECT iv.*,i.*,it.* FROM inventory iv LEFT JOIN items i ON iv.inv_itemid=i.itmid LEFT JOIN itemtypes it ON i.itmtype=it.itmtypeid WHERE iv.inv_id={$_GET['ID']} AND iv.inv_userid=$userid"); if(mysql_num_rows($i) == 0) { print "Invalid item ID"; } $r=$db->fetch_row($i); if($r['itmid'] == 13) { print "You used your {$r['itmname']} to create a Master Potion"; item_add($userid, 2, 1); item_remove($userid, $r['inv_itemid'], 1); $h->endpage(); } else { $p=$db->query("SELECT iv.*,i.*,it.* FROM inventory iv LEFT JOIN items i ON iv.inv_itemid=i.itmid LEFT JOIN itemtypes it ON i.itmtype=it.itmtypeid WHERE iv.inv_id={$_GET['ID']} AND iv.inv_userid=$userid"); $r=$db->fetch_row($p); if($r['itmid'] == 2) { print "You used your {$r['itmname']} to create a Wicked Potion"; item_add($userid, 13, 1); item_remove($userid, $r['inv_itemid'], 1); } } // TOO KEEP ADDING COMBINES JUST KEEP ADDING THE BELOW CHANGING THE itmid too match Item Before Combining then change the item_add to the value of the item you want it to be combined too // dont forget to change this >> print "You used your {$r['itmname']} to create a Wicked Potion"; to be named for the item youve just created // $p=$db->query("SELECT iv.*,i.*,it.* FROM inventory iv LEFT JOIN items i ON iv.inv_itemid=i.itmid LEFT JOIN itemtypes it ON i.itmtype=it.itmtypeid WHERE iv.inv_id={$_GET['ID']} AND iv.inv_userid=$userid"); $r=$db->fetch_row($p); if($r['itmid'] == 5) { print "You used your {$r['itmname']} to create a Sword"; item_add($userid, 1, 1); item_remove($userid, $r['inv_itemid'], 1); } } $h->endpage(); ?>   Now when your created or editing an Item in the combine part put the ID number of the item you want it to be combined with from the staff_items.php file