[HABBO] Hot Campaigns

Quote:

---

Originally Posted by Retro!

Isnt this already released?
Still good,
Nice job.

---

No, this was never released.

First hotel to have it was epichotel :P, though iJames didint want to release it

Cool, but James told me he didn't work for you guys anymore... and came to Echo.. but.. Uh...

Ontopic situation.

I doubt he did all the MySQL and etc..

Quote:

---

Originally Posted by AresCJ

Cool, but James told me he didn't work for you guys anymore... and came to Echo.. but.. Uh...

Ontopic situation.

I doubt he did all the MySQL and etc..

---

Nah he came back :P

and yes he did all he SQL :]

Oh, well I am doing the SQL too.

- Update coming in 30-38 minutes, depending on the "improvision" of my time and patience.

I thought habbzhotel had it first?
Never heard of epichotel,

Well, Epic and Habbz both have coders who get the updates for them..

Anyways, releasing a testing sample of the Hot Campaigns in MySQL format.

EDIT:

Here's a testing sample of it in MySQL, please let me know if it works or not.

erro:
INSERT INTO `cms_content` VALUES ('campaign3', 'Don't miss this last opportunity to get your hands on some valuable furni!', '1', '3');

It takes more then some HTML code, mine is fully read from the database, and generated ect.. :P

you edit housekeeping??
sorry my:Brazilien

The housekeeping doesnt work.You click Hot Randoms Edit then Go!Then it says saved succesfully

Just make a table like cms_campaigns

and then do it like iJames' staff picks

ID
Name
Image
URL
Desc

then in HK make a "add" and a "manage"
then on the page
[php]

<div class="habblet-container ">
<div class="cbb clearfix orange ">

<h2 class="title">Hot Campaigns
</h2>
<div id="hotcampaigns-habblet-list-container">
<ul id="hotcampaigns-habblet-list">
<?php
$getcampaigns = mysql_query("select * from cms_campaigns");
while($campaigns = mysql_fetch_assoc($getcampaigns)) {
?>
<li class="even">
<div class="hotcampaign-container">
<a href="<?php echo $campaigns['url']; ?>"><img src="<?php echo $campaigns['image']; ?>" align="left" alt="" /></a>
<h3><?php echo $campaigns['name']; ?></h3>
<p><?php echo $campaigns['desc']; ?></p>
<p class="link"><a href="<?php echo $campaigns['url']; ?>">Go there

[quote=handyandy160;5022844]Just make a table like cms_campaigns

and then do it like iJames' staff picks

ID
Name
Image
URL
Desc

then in HK make a "add" and a "manage"
then on the page
[php]

<div class="habblet-container ">
<div class="cbb clearfix orange ">

<h2 class="title">Hot Campaigns
</h2>
<div id="hotcampaigns-habblet-list-container">
<ul id="hotcampaigns-habblet-list">
<?php
$getcampaigns = mysql_query("select * from cms_campaigns");
while($campaigns = mysql_fetch_assoc($getcampaigns)) {
?>
<li class="even">
<div class="hotcampaign-container">
<a href="<?php echo $campaigns['url']; ?>"><img src="<?php echo $campaigns['image']; ?>" align="left" alt="" /></a>
<h3><?php echo $campaigns['name']; ?></h3>
<p><?php echo $campaigns['desc']; ?></p>
<p class="link"><a href="<?php echo $campaigns['url']; ?>">Go there

[quote=handyandy160;5022844]Just make a table like cms_campaigns

and then do it like iJames' staff picks

ID
Name
Image
URL
Desc

then in HK make a "add" and a "manage"
then on the page
[php]

<div class="habblet-container ">
<div class="cbb clearfix orange ">

<h2 class="title">Hot Campaigns
</h2>
<div id="hotcampaigns-habblet-list-container">
<ul id="hotcampaigns-habblet-list">
<?php
$getcampaigns = mysql_query("select * from cms_campaigns");
while($campaigns = mysql_fetch_assoc($getcampaigns)) {
?>
<li class="even">
<div class="hotcampaign-container">
<a href="<?php echo $campaigns['url']; ?>"><img src="<?php echo $campaigns['image']; ?>" align="left" alt="" /></a>
<h3><?php echo $campaigns['name']; ?></h3>
<p><?php echo $campaigns['desc']; ?></p>
<p class="link"><a href="<?php echo $campaigns['url']; ?>">Go there

Yes, I think thats the best way to do it Ricky.
No problem on the explaination

@Cornelius, do whatever you like :P