Reply to thread

Message

<blockquote data-quote="DaLightz" data-source="post: 111068" data-attributes="member: 17436">Hi there devbest <img src="/styles/default/xenforo/smilies/emojione/smile.png"&nbsp; class="smilie" loading="lazy" alt=":)" title="Smile&nbsp; &nbsp; :)" data-shortname=":)" />, as many of you should know, ive left ubercms to start working on revcms <img src="/styles/default/xenforo/smilies/emojione/biggrin.png"&nbsp; class="smilie" loading="lazy" alt=":D" title="Big Grin&nbsp; &nbsp; :D" data-shortname=":D" />Now, my php skills are ok, but i feel i want to advance in my skills so i am releasing some good stuff this week ^.^----------------So here is the release,Campaigns on your cms BUT database powered!------------------WHAT DOES THIS DO? <img src="/styles/default/xenforo/smilies/emojione/eek.png"&nbsp; class="smilie" loading="lazy" alt=":eek:" title="Eek!&nbsp; &nbsp; :eek:" data-shortname=":eek:" />-Ok well, as you know in ubercms, it would read campaigns from the db.. This also does that <img src="/styles/default/xenforo/smilies/emojione/smile.png"&nbsp; class="smilie" loading="lazy" alt=":)" title="Smile&nbsp; &nbsp; :)" data-shortname=":)" />--------------------Screen shot of it on cms: <a href="http://prntscr.com/ai8w0" target="_blank">http://prntscr.com/ai8w0</a>Screen shot of db (for proof): <a href="http://prntscr.com/ai8wn" target="_blank">http://prntscr.com/ai8wn</a>Note: once my revcms hk is out, you will be able to edit, or delete campaigns instead of using the db.-------------------VERY IMPORTANT! RUN THIS IN YOUR DATABASE:!![CODE]CREATE TABLE IF NOT EXISTS `cms_campaigns` (&nbsp; `id` int(11) NOT NULL AUTO_INCREMENT,&nbsp; `order_id` int(11) NOT NULL DEFAULT '1',&nbsp; `enabled` enum('0','1') NOT NULL DEFAULT '1',&nbsp; `image_url` text NOT NULL,&nbsp; `caption` text NOT NULL,&nbsp; `descr` text NOT NULL,&nbsp; `url` text NOT NULL,&nbsp; PRIMARY KEY (`id`)) ENGINE=MyISAM&nbsp; DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;&nbsp;INSERT INTO `cms_campaigns` (`id`, `order_id`, `enabled`, `image_url`, `caption`, `descr`, `url`) VALUES(2, 1, '1', 'http://65.96.141.124/app/tpl/skins/Habbo/images/facebookconnect.gif', 'Test 2', 'MOAR MOAR MOAR!', 'http://devbest.com'),(3, 1, '1', 'http://65.96.141.124/app/tpl/skins/Habbo/images/facebookconnect.gif', 'MOAR TEST!', 'LOOOOOL MOAR!', 'http://devbest.com'),(1, 1, '1', 'http://65.96.141.124/app/tpl/skins/Habbo/images/facebookconnect.gif', 'Test', 'This is a test for my shit..', 'http://devbest.com');[/CODE]Now, on your me.php,under column 1 tag add this: [CODE]&lt;?php&nbsp; &nbsp; $campaign = mysql_query(&quot;SELECT * FROM cms_campaigns ORDER BY `id` DESC&quot;); // Query, Select data from cms_camps..&nbsp; &nbsp; if(mysql_num_rows($campaign) == 0){&nbsp; &nbsp; &nbsp; &nbsp; echo 'MAKE A CAMPAIGN TO FIX ME!!!'; // No campaigns? This will show.&nbsp; &nbsp; }else{&nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;div class=&quot;habblet-container &quot;&gt;'; // Container..&nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;div class=&quot;cbb clearfix orange &quot;&gt;'; // Decor..&nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;h2 class=&quot;title&quot;&gt;Hot Campaigns&lt;/h2&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div id=&quot;hotcampaigns-habblet-list-container&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;hotcampaign-container&quot;&gt;';&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; while($row = mysql_fetch_array($campaign)){ // Fetch shit from $camps..&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Start variables&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $id = $row[&quot;id&quot;];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $caption = $row[&quot;caption&quot;];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $image_url = $row[&quot;image_url&quot;];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $descr = $row[&quot;descr&quot;];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $url = $row[&quot;url&quot;];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // End variables&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;ul id=&quot;hotcampaigns-habblet-list&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;li class=&quot;even&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;a href=&quot;'.$url.'&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;img src=&quot;'.$image_url.'&quot; align=&quot;left&quot; alt=&quot;'.$caption.'&quot; /&gt;&lt;/a&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;h3&gt;'.$caption.'&lt;/h3&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;p&gt;'.$descr.'&lt;/p&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;p class=&quot;link&quot;&gt;&lt;a href=&quot;'.$url.'&quot;&gt;Go there &amp;raquo;&lt;/a&gt;&lt;/p&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/li&gt; &lt;/ul&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ';&nbsp; &nbsp; }&nbsp; &nbsp; ?&gt;&nbsp; &nbsp; &lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;[/CODE]&nbsp;Enjoy <img src="/styles/default/xenforo/smilies/emojione/smile.png"&nbsp; class="smilie" loading="lazy" alt=":)" title="Smile&nbsp; &nbsp; :)" data-shortname=":)" /></blockquote>

[QUOTE="DaLightz, post: 111068, member: 17436"] Hi there devbest :), as many of you should know, ive left ubercms to start working on revcms :D Now, my php skills are ok, but i feel i want to advance in my skills so i am releasing some good stuff this week ^.^ ---------------- So here is the release, Campaigns on your cms BUT database powered! ------------------ WHAT DOES THIS DO? :o - Ok well, as you know in ubercms, it would read campaigns from the db.. This also does that :) -------------------- Screen shot of it on cms: [url]http://prntscr.com/ai8w0[/url] Screen shot of db (for proof): [url]http://prntscr.com/ai8wn[/url] Note: once my revcms hk is out, you will be able to edit, or delete campaigns instead of using the db. ------------------- VERY IMPORTANT! RUN THIS IN YOUR DATABASE:!! [CODE]CREATE TABLE IF NOT EXISTS `cms_campaigns` ( `id` int(11) NOT NULL AUTO_INCREMENT, `order_id` int(11) NOT NULL DEFAULT '1', `enabled` enum('0','1') NOT NULL DEFAULT '1', `image_url` text NOT NULL, `caption` text NOT NULL, `descr` text NOT NULL, `url` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; INSERT INTO `cms_campaigns` (`id`, `order_id`, `enabled`, `image_url`, `caption`, `descr`, `url`) VALUES (2, 1, '1', 'http://65.96.141.124/app/tpl/skins/Habbo/images/facebookconnect.gif', 'Test 2', 'MOAR MOAR MOAR!', 'http://devbest.com'), (3, 1, '1', 'http://65.96.141.124/app/tpl/skins/Habbo/images/facebookconnect.gif', 'MOAR TEST!', 'LOOOOOL MOAR!', 'http://devbest.com'), (1, 1, '1', 'http://65.96.141.124/app/tpl/skins/Habbo/images/facebookconnect.gif', 'Test', 'This is a test for my shit..', 'http://devbest.com'); [/CODE] Now, on your me.php,under column 1 tag add this: [CODE] <?php $campaign = mysql_query("SELECT * FROM cms_campaigns ORDER BY `id` DESC"); // Query, Select data from cms_camps.. if(mysql_num_rows($campaign) == 0){ echo 'MAKE A CAMPAIGN TO FIX ME!!!'; // No campaigns? This will show. }else{ echo '<div class="habblet-container ">'; // Container.. echo '<div class="cbb clearfix orange ">'; // Decor.. echo '<h2 class="title">Hot Campaigns</h2> <div id="hotcampaigns-habblet-list-container"> <div class="hotcampaign-container">'; } while($row = mysql_fetch_array($campaign)){ // Fetch shit from $camps.. // Start variables $id = $row["id"]; $caption = $row["caption"]; $image_url = $row["image_url"]; $descr = $row["descr"]; $url = $row["url"]; // End variables echo '<ul id="hotcampaigns-habblet-list"> <li class="even"> <a href="'.$url.'"> <img src="'.$image_url.'" align="left" alt="'.$caption.'" /></a> <h3>'.$caption.'</h3> '.$descr.' <a href="'.$url.'">Go there »</a> </li> </ul> '; } ?> </div></div> </div> </div>[/CODE] Enjoy :) [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members