[8WR] XenPorta (Portal)

[8WR] XenPorta (Portal) 1.6.0

No permission to download
Overview Updates (11) Reviews (91) History Discussion
Also, does anyone know how to get an AdSense advertisement on the portal page, the same as 8WayRun.com? I.e. not using the AdSense block.
 
So under recent news i just turned off caching in the options and went to the home page and this happened.

An exception occurred: Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') OR EWRporta_promotes.promote_date < ?) AND xf_thread.discussion_state = 'v' at line 11 in /home/content/60/9276860/html/library/Zend/Db/Statement/Mysqli.php on line 77


  1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
  2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
  3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
  4. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 734
  5. Zend_Db_Adapter_Abstract->fetchAll() in EWRporta/Block/RecentNews.php at line 32
  6. EWRporta_Block_RecentNews->getModule() in EWRporta/Model/Blocks.php at line 116
  7. EWRporta_Model_Blocks->getBlockParams() in EWRporta/ViewPublic/Custom.php at line 71
  8. EWRporta_ViewPublic_Custom->renderHtml() in XenForo/ViewRenderer/Abstract.php at line 215
  9. XenForo_ViewRenderer_Abstract->renderViewObject() in XenForo/ViewRenderer/HtmlPublic.php at line 67
  10. XenForo_ViewRenderer_HtmlPublic->renderView() in XenForo/FrontController.php at line 533
  11. XenForo_FrontController->renderView() in XenForo/FrontController.php at line 156
  12. XenForo_FrontController->run() in /home/content/60/9276860/html/index.php at line 13

So my portal is dead right now.

Any help would be greatly appreciated.

:(
 
Sorry, Yeah i was actually on my way to go back and delete the post.

PS. I tried turning the option back on but it was too late and the error is still coming up.

inkdapp.com is the address if that helps

Also here is the error log.

Code: 
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') OR EWRporta_promotes.promote_date < ?) AND xf_thread.discussion_state = 'v' at line 11 - library/Zend/Db/Statement/Mysqli.php:77
Generated By: justin, A moment ago
Stack Trace
#0 /home/content/60/9276860/html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('????SELECT xf_t...')
#1 /home/content/60/9276860/html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '????SELECT xf_t...')
#2 /home/content/60/9276860/html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('????SELECT xf_t...')
#3 /home/content/60/9276860/html/library/Zend/Db/Adapter/Abstract.php(734): Zend_Db_Adapter_Abstract->query('????SELECT xf_t...', Array)
#4 /home/content/60/9276860/html/library/EWRporta/Block/RecentNews.php(32): Zend_Db_Adapter_Abstract->fetchAll('????SELECT xf_t...', Array)
#5 /home/content/60/9276860/html/library/EWRporta/Model/Blocks.php(116): EWRporta_Block_RecentNews->getModule(Array, 1)
#6 /home/content/60/9276860/html/library/EWRporta/ViewPublic/Custom.php(71): EWRporta_Model_Blocks->getBlockParams(Array, 1)
#7 /home/content/60/9276860/html/library/XenForo/ViewRenderer/Abstract.php(215): EWRporta_ViewPublic_Custom->renderHtml()
#8 /home/content/60/9276860/html/library/XenForo/ViewRenderer/HtmlPublic.php(67): XenForo_ViewRenderer_Abstract->renderViewObject('EWRporta_ViewPu...', 'Html', Array, 'EWRporta_Portal')
#9 /home/content/60/9276860/html/library/XenForo/FrontController.php(533): XenForo_ViewRenderer_HtmlPublic->renderView('EWRporta_ViewPu...', Array, 'EWRporta_Portal', NULL)
#10 /home/content/60/9276860/html/library/XenForo/FrontController.php(156): XenForo_FrontController->renderView(Object(XenForo_ControllerResponse_View), Object(XenForo_ViewRenderer_HtmlPublic), Array)
#11 /home/content/60/9276860/html/index.php(13): XenForo_FrontController->run()
#12 {main}
Request State
array(3) {
  ["url"] => string(19) "http://inkdapp.com/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}

UPDATE: I just unistalled and reinstalled xenporta and its corrected.
 
For some reason my "Recent Threads" header is displaying short. I checked 8wayrun, and it appears properly there.

Screen%20Shot%202012-05-01%20at%205.05.06%20PM.png


Is there a known fix for this?
 
Xarcell said:
I haven't looked, but if I remember correctly, it's "newsTitle".

If your using Chrome browser, mouse over the title and select "inspect element", then you'll see what class is used.
Click to expand...

I still can't, for the life of me, find this in any XenPorta CSS files. I've downloaded Firefox and Firebug to inspect the element, and it is newsTitle, but I can't find the reference in order to change it. I apologize in advance for not knowing CSS.
 
I'm trying to get this running and I'm not having much luck. I uploaded the files using ftp and tried to add the XenPorta and I keep getting "Please enter a valid file name. The requested file could not be read."

I don't know if I uploaded to the wrong area and/or giving it the wrong info on where to find the file.

Can anyone help me with this?

James
 
Joe Link said:
I still can't, for the life of me, find this in any XenPorta CSS files. I've downloaded Firefox and Firebug to inspect the element, and it is newsTitle, but I can't find the reference in order to change it. I apologize in advance for not knowing CSS.
Click to expand...

Now that I think about it, it's actually a xenforo class, not xenporta. So if you want to change it just for the recentNews, just open EWRblock_RecentNews and look for class="newsTitle" and add an inline style to it like so class="newsTitle" style="font-size: whatever", and that will override the style of it.

Help, look at inline styles: http://www.w3schools.com/css/css_howto.asp
 
Flexin said:
I'm trying to get this running and I'm not having much luck. I uploaded the files using ftp and tried to add the XenPorta and I keep getting "Please enter a valid file name. The requested file could not be read."

I don't know if I uploaded to the wrong area and/or giving it the wrong info on where to find the file.

Can anyone help me with this?

James
Click to expand...

Most likely you are not using the correct file. You want to install file "addon-EWRporta.xml".
 
When I place text inside the PREBREAK tags, I still get 'Continue Reading' in addition to that text. How does one remove the Continue Reading link when text appears within these tags?
 
Reposting again: Can someone please let me know if anything needs to be done specifically with XenPorta for Google Analytics to work as it should? I have set my Google Analytics Web Property ID under the Statistics and Metrics options section however I am not sure if any modifications need to be done to the portal itself?

Also, can someone please tell me how to place the AdSense ad exactly the same as 8WayRun.com? (I.e. not using the AdSense addon, it seems).
 
The GA code should be added automatically if you have it set. Just check that the code is appearing in the template if you want to make sure.

There are various ways to add in adsense code, either use one of the addons or edit the templates manually, etc.
 
I had a request to post the changes I made to the RecentSlider on ValveTime.net. This should cover everything, but I haven't super tested it, so do let me know if you run into any issues.

In Recent Slider, around line 36.
PHP: 
<div class="tagline" style="height: {$option.itemheight}px;">
<div class="image" style="height: {$option.imgheight}px; width: {$option.imgwidth}px; background-image: url('{xen:link attachments, $news.attach}'); background-position: {$option.anchor} top;"></div>
<div class="title" style="margin-{$option.position}: {$option.itemwidth}px;">{xen:helper wordtrim, $news.title, {$option.trimtitle}}</div>
</div>

Change to:

PHP: 
<div class="tagline">
<div class="image" style="height: 20px; width: 20px; padding: 0px; margin-top: -4px;"></div>
</div>

This strip the image and text from the preview, leaving just the container div, that we'll treat as a button. Now do note that because of the size change of the preview (since we've replaced an entire image with just a small div), the entire recent slider has to change sizes.

Replace your RecentSlider.CSS with this. Note that you'll most likely want to change the colours.

HTML: 
#recentSlider { padding: 10px;}
 
.recentSlider
{
position: relative;
background-color: #161616;
overflow: hidden;
    margin-left: auto;
    margin-right: auto;
    float: none;
    width: 602px;
}
 
.recentSlider .ui-tabs-hide { display: none; }
.recentSlider .ui-tabs-selected { background-color: #a12621!important; }
 
.recentSlider .ui-tabs-nav { list-style: none; margin: 0; padding: 0; position: absolute; top: 0px; }
.recentSlider .ui-tabs-nav-item a { text-decoration: none !important; color: #EEE; }
.recentSlider .ui-tabs-nav-item:hover { background-color: #666; }
 
.recentSlider .ui-tabs-nav-item {
border: 0px solid #333;
height: 20px;
width: 20px;
background-color: #292929;
margin: 5px;
}
 
.recentSlider .ui-tabs-nav-item:last-child { border-bottom: 0px; }
.recentSlider .ui-tabs-nav-item .image { background-repeat: no-repeat; margin: 5px; float: left; }
.recentSlider .ui-tabs-nav-item .title { font-size: 12px; font-weight: bold; padding: 10px; }
 
.recentSlider .ui-tabs-panel { position: relative; background-repeat: no-repeat; }
.recentSlider .ui-tabs-panel a { text-decoration: none !important; color: #EEE; }
.recentSlider .ui-tabs-panel .summary
{
background-color: rgba(0,0,0,0.7);
border-top: 1px solid #333;
position: absolute;
bottom: 0px;
left: 0px;
padding: 12px 15px;
width: 100%;
}
.recentSlider .ui-tabs-panel .summary .title { font-size: 22px; margin-right: 15px; letter-spacing: -1px;    text-overflow: ellipsis;
    -o-text-overflow: ellipsis;
    -ms-text-overflow: ellipsis;
    overflow: hidden;
    white-space: nowrap;
    height: 1em; }
.recentSlider .ui-tabs-panel .summary .excerpt { font-size: 11px; margin-right: 30px; }
 
.recentSlider.leftSlider .ui-tabs-nav { border-left: 1px solid #333; text-align: left; width: 30px;}
.recentSlider.leftSlider .ui-tabs-panel { float: left; }
.recentSlider.leftSlider .ui-tabs-nav-item .image { background-size: auto 100%; float: left; }
 
.recentSlider.rightSlider .ui-tabs-nav { float: left; text-align: right; width: 30px!important;}
.recentSlider.rightSlider .ui-tabs-panel { float: right; border: 1px solid #292929;}
.recentSlider.rightSlider .ui-tabs-nav-item .image { background-size: auto 100%; float: left; }
 
Thanks for sharing with us Yorick. I have general issue with the slider, it doesn't show up at all, just a black background. I looked it up the Guide here if there is something that I'm missing but still nothing showing up. I even created another recentnews module which isn't showing up either. Deleted cache, activated / reactivated, moved around the modules without luck.
 
Xarcell said:
Most likely you are not using the correct file. You want to install file "addon-EWRporta.xml".
Click to expand...

The info I found said to use /library/EWRporta/addon-EWRporta.xml and I have tried it many ways and I'm just getting the error.

James
 
yavuz said:
Thanks for sharing with us Yorick. I have general issue with the slider, it doesn't show up at all, just a black background. I looked it up the Guide here if there is something that I'm missing but still nothing showing up. I even created another recentnews module which isn't showing up either. Deleted cache, activated / reactivated, moved around the modules without luck.
Click to expand...

Is that after adding my code, or it was doing that already? Can you supply me with a link to your site?
 
Yorick said:
Is that after adding my code, or it was doing that already? Can you supply me with a link to your site?
Click to expand...

It was doing it already has nothing to do with your code. I applied your modification to another site it's perfectly working.
 
How can I insert an ad between before the first thread and after the third thread on the xenporta home page? Does anybody know what code needs to be written or where it should be placed? I think it might require modifying the core files, which I am willing to do but sort of clueless on how to do it.
 
You must log in or register to reply here.

Similar threads

Baby Community
[8WR] XenPorta 2 (Portal) PRO Turkish Language File
Replies
0
Views
515
Baby Community
Baby Community
mcatze
German translation for [8WR] XenAtendo 2 (Calendar) PRO [Paid]
Replies
4
Views
1K
K a M a L
K
Menerv
XF2 [8WR] XenPorta 2 (Portal) PRO - French Translation
Replies
0
Views
739
Menerv
Menerv
Jaxel
XF2 [8WR] XenPorta 2 (Portal) PRO [Paid]
113 114 115
Replies
2K
Views
192K
Digital Doctor
Digital Doctor
Marv
[8WR] XenAtendo 2 (Calendar) PRO - German/Deutsch translation [Deleted]
Replies
3
Views
842
Marv
Marv
Back
Top Bottom