all items to be credited.

[peterisgb]

Hello, a quick question,

How would i be able to credit myself all the items in the game to my inventory quickly?

[sniko]

$get = $db->query("SELECT `itmid` FROM `items`");
while( $r = $db->fetch_row($get) ) {
    item_add(1, $r['itmid'], 1);
}
echo 'All items credited to userid 1';

[peterisgb]

that easy, thanks very much Sniko, nice work.

[peterisgb]

where do i put this, i tried the staff_items page. at the top it show its been credited to userid1 but its doesnt credit it.

[Djkanna]

Could be another possible way, just depends on how quick you want it.

INSERT INTO inventory ( inv_itemid, inv_userid, inv_qty )
SELECT itmid,1,1 FROM items; # 1,1 = inv_userid and inv_qty

Run it in PHPMyAdmin or alternatives.

[sniko]

where do i put this, i tried the staff_items page. at the top it show its been credited to userid1 but its doesnt credit it.

I may have got the function and column name wrong.

[peterisgb]

ty to you both Djkanna, your a star, Sniko, ty for teaching me a little