Reply to thread

Message

<blockquote data-quote="Queso" data-source="post: 425393" data-attributes="member: 72618">Hi there DevBest, releasing another basic simple script. Basically this script allows a user to get a free item everyday, which can be selected from a table in the database.First off, add this code to the page.[CODE]&lt;center&gt;Here at &lt;strong&gt;{hotelname}&lt;/strong&gt; we reward our active users with various items. &lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Everyday you login, you can click on the box below to receive an item in-game. &lt;br /&gt;&lt;/center&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/p&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;center&gt;&lt;a href=&quot;#&quot; onclick=&quot;window.open('{url}/reward', 'newwindow', 'width=300, height=180');&quot; target=&quot;_blank&quot;&gt;&lt;img src=&quot;IMAGEHERE&quot;&gt;&lt;/a&gt;&lt;/center&gt;[/CODE]Next, create a new file called reward.php and paste this into it[PHP]&lt;?php$user = mysql_query(&quot;SELECT * FROM `users` WHERE id='&quot;.$_SESSION['user']['id'].&quot;'&quot;);&nbsp;while ($u = mysql_fetch_array($user)){&nbsp; if ($u['id'] &gt; 0 || $u['id'] != null){&nbsp;&nbsp; if(date(&quot;Y-m-d&quot;) == date(&quot;Y-m-d&quot;, $u['account_created'])){&nbsp; &nbsp; &nbsp;&nbsp; echo &quot;&lt;br&gt;&lt;div class=\&quot;rounded-green rounded-done\&quot;&gt;You need to be a member for at least one day!&lt;/div&gt;&quot;;&nbsp;&nbsp; }&nbsp;&nbsp; else&nbsp;&nbsp; {&nbsp; &nbsp; if ($u['online'] == 0){&nbsp; &nbsp; if(date(&quot;Y-m-d&quot;) == $u['lastusedgift']){&nbsp; &nbsp; &nbsp; &nbsp; if ($u['lastmysteryprize'] == null){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;div class=&quot;rounded-red rounded-done&quot;&gt;You can only receieve one reward per day!&lt;/div&gt;';&nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;br&gt;&lt;div class=&quot;rounded-red rounded-done&quot;&gt;You can only receive one reward per day!&lt;/div&gt;';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;br&gt;&lt;div class=&quot;rounded-red rounded-done&quot;&gt;You last received a '.$u['lastdailygift'].'!&lt;/div&gt;';&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; $rare = mysql_query(&quot;SELECT * FROM `gift_settings` ORDER BY RAND() LIMIT 1&quot;);&nbsp; &nbsp; &nbsp; &nbsp; $r = mysql_fetch_assoc($rare);&nbsp; &nbsp; &nbsp; &nbsp; if ($r){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $urRare = $r['rare_id'];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $urRareName = $r['rare_name'];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $urRareImg = $r['rare_img'];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mysql_query(&quot;INSERT INTO `items` (`user_id`, `base_item`, `extra_data`) VALUES ('&quot;.$_SESSION['user']['id'].&quot;', '&quot;.$urRare.&quot;', '0')&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mysql_query(&quot;UPDATE `users` SET `lastusedgift` = '&quot;.date(&quot;Y-m-d&quot;, time()).&quot;' WHERE `id` = '&quot;.$_SESSION['user']['id'].&quot;'&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mysql_query(&quot;UPDATE `users` SET `lastdailygift` = '&quot;.$urRareName.&quot;' WHERE `id`='&quot;.$_SESSION['user']['id'].&quot;'&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;br&gt;&lt;div class=&quot;rounded-green rounded-done&quot;&gt;You have just received a '.$urRareName.'!&lt;/div&gt;';&nbsp; &nbsp; }}&nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;br&gt;&lt;div class=\&quot;rounded-red rounded-done\&quot;&gt;Make sure you're logged out of the client first!&lt;/div&gt;&quot;;&nbsp; &nbsp; }&nbsp; }}}?&gt;[/PHP] P.S, this was made on a Habbo theme, so you may have to change some lines if you use a different skin than HabboLastly, run these queries in your Navicat[CODE]ALTER TABLE users ADD lastusedgift varchar(255);[/CODE][CODE]ALTER TABLE users ADD lastdailygift varchar(255);[/CODE][CODE]DROP TABLE IF EXISTS `gift_settings`;CREATE TABLE `gift_settings` (&nbsp; `id` int(11) NOT NULL AUTO_INCREMENT,&nbsp; `rare_name` varchar(255) DEFAULT NULL,&nbsp; `rare_id` int(11) DEFAULT NULL,&nbsp; PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;[/CODE]Screenshots:<a href="https://prnt.sc/hsllr6" target="_blank">https://prnt.sc/hsllr6</a><a href="https://prnt.sc/hslm2z" target="_blank">https://prnt.sc/hslm2z</a><a href="https://prnt.sc/hsln3m" target="_blank">https://prnt.sc/hsln3m</a><a href="https://prnt.sc/hslnd1" target="_blank">https://prnt.sc/hslnd1</a><a href="https://prnt.sc/hslnse" target="_blank">https://prnt.sc/hslnse</a>Done.If you have any questions or need help, PM me, and I can try to help you. Don't really care if you think this poorly coded or anything, I'm not a professional web developer, nor do I really know of ways this can be sql injected, so yeah. This was just something I wanted to have on my hotel.</blockquote>

[QUOTE="Queso, post: 425393, member: 72618"] Hi there [B]DevBest[/B], releasing another basic simple script. Basically this script allows a user to get a free item everyday, which can be selected from a table in the database. First off, add this code to the page. [CODE]<center>Here at {hotelname} we reward our active users with various items. Everyday you login, you can click on the box below to receive an item in-game. </center> <center><a href="#" onclick="window.open('{url}/reward', 'newwindow', 'width=300, height=180');" target="_blank"><img src="IMAGEHERE"></a></center>[/CODE] Next, create a new file called reward.php and paste this into it [PHP]<?php $user = mysql_query("SELECT * FROM `users` WHERE id='".$_SESSION['user']['id']."'"); while ($u = mysql_fetch_array($user)){ if ($u['id'] > 0 || $u['id'] != null){ if(date("Y-m-d") == date("Y-m-d", $u['account_created'])){ echo " <div class=\"rounded-green rounded-done\">You need to be a member for at least one day!</div>"; } else { if ($u['online'] == 0){ if(date("Y-m-d") == $u['lastusedgift']){ if ($u['lastmysteryprize'] == null){ echo '<div class="rounded-red rounded-done">You can only receieve one reward per day!</div>'; } else { echo ' <div class="rounded-red rounded-done">You can only receive one reward per day!</div>'; echo ' <div class="rounded-red rounded-done">You last received a '.$u['lastdailygift'].'!</div>'; } } else { $rare = mysql_query("SELECT * FROM `gift_settings` ORDER BY RAND() LIMIT 1"); $r = mysql_fetch_assoc($rare); if ($r){ $urRare = $r['rare_id']; $urRareName = $r['rare_name']; $urRareImg = $r['rare_img']; mysql_query("INSERT INTO `items` (`user_id`, `base_item`, `extra_data`) VALUES ('".$_SESSION['user']['id']."', '".$urRare."', '0')"); mysql_query("UPDATE `users` SET `lastusedgift` = '".date("Y-m-d", time())."' WHERE `id` = '".$_SESSION['user']['id']."'"); mysql_query("UPDATE `users` SET `lastdailygift` = '".$urRareName."' WHERE `id`='".$_SESSION['user']['id']."'"); echo ' <div class="rounded-green rounded-done">You have just received a '.$urRareName.'!</div>'; }} } else { echo " <div class=\"rounded-red rounded-done\">Make sure you're logged out of the client first!</div>"; } }}} ?>[/PHP] [I]P.S, this was made on a Habbo theme, so you may have to change some lines if you use a different skin than Habbo[/I] Lastly, run these queries in your Navicat [CODE]ALTER TABLE users ADD lastusedgift varchar(255);[/CODE] [CODE]ALTER TABLE users ADD lastdailygift varchar(255);[/CODE] [CODE] DROP TABLE IF EXISTS `gift_settings`; CREATE TABLE `gift_settings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `rare_name` varchar(255) DEFAULT NULL, `rare_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; [/CODE] Screenshots: [URL]https://prnt.sc/hsllr6[/URL] [URL]https://prnt.sc/hslm2z[/URL] [URL]https://prnt.sc/hsln3m[/URL] [URL]https://prnt.sc/hslnd1[/URL] [URL]https://prnt.sc/hslnse[/URL] [B]Done.[/B] If you have any questions or need help, PM me, and I can try to help you. Don't really care if you think this poorly coded or anything, I'm not a professional web developer, nor do I really know of ways this can be sql injected, so yeah. This was just something I wanted to have on my hotel. [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members