Installation error

Adam

New Member
I tried the install twice and got this message after both times. The install seemed to go perfectly, and the admin page is showing fine. This is what displays on the Topsites index

Fatal error: Database error in "/home/content/60/8475760/html/socialmediasun/best/index.php(298) : eval()'d code" on line 5

Table 'smsvisiobest2012.VL1_osbanners' doesn't exist in /home/content/60/8475760/html/socialmediasun/best/sources/sql/mysql.php on line 88
 

Basti

Administrator
Staff member
Hey, adam. Its a missing table in the database, because we forgot to include the entries in the install process. To solve this please go to admin -> plugin manager -> click install next to the "Ads" plugin
 

Adam

New Member
Ok, that fixxed the install. I added an account for testing, and it wouldn't let me upload a banner, and when I go back for the Link Code, nothing is generated.

It lets me select the domain, but then doesn't generate a code.
 

Adam

New Member
Are there any other problems I need to know about that you guys are already aware of? My host is Go Daddy.

I also dropped the tables out of the database for of an initial install. I re-installed to make sure that I hadn't made a mistake, and that is the one I finally used the ad plugin and got to work.
 

Adam

New Member
Ok, I got the banner upload working, the Link Code for individual sites still isn't generating.
 

Basti

Administrator
Staff member
With which skin are you testing? the default, parabola?
If its a downloaded skin, provided by user, it properbly is outdated. link_code.html should just have this
Code:
{$link_code_content}
If its one of them, its wise to check files against parabola.

If you use parabola, never experienced that problem before, sounds more like the above
 

Adam

New Member
I am using parabola, and the file link_code.html just has what you specified. Here is what the screen looks like after I select Link Code, and then the proper domain. Have any ideas? I may go through the PHP and files when I get home, but I'd really like to get this cleared up ASAP. I'm racing a launch deadline.

link_code.JPG
 

Basti

Administrator
Staff member
Ahh, easy fix. You havent configured admin settings. Choose your backlink choices in admin -> Settings -> Button settings

EDIT:: Might be good to include an error message if admin havent configured these options.
 

Adam

New Member
Thanks Basti, that got the link code to appear. I am really glad you guys are helping me daily. As I mentioned in another thread, I'm battling a deadline. I have 2 more requests at the moment. How do I include an error message as well??

1) I need to change what the text link says though, it should read something like "Vote for *User Site* on Social Media Sun Best List" Instead of just my list title.

Also, I would like to offer more options. I would like to offer the Google friendly list for the actual website, but the other type with the username directly in the link for users to copy from the control panel and share as a message on Twitter. "Vote for my site on the SMS Top 100 http://socialmediasun.com/best/index.php?a=in&u=etelligence " so basically add another option to Link Code. "Share on Twitter and Facebook" option.

I know you guys specify to code in plugins, but I don't understand hooking to the core, but I can usually fumble my way through editing the actual scripts. Is there a way to add this feature where a non-google friendly link gets generated for Sharing on social media in addition to the link codes for their sites? And where can I edit the actual text of the link codes?

2) I need to know the Div names to add CSS to the user.css file. I don't like using jquery, but I want to change the colors of the menu bar, in the table where there is navigation the color of ranking method, categories and newest members, the profile score bar, basically everything that is blue on all the pages a user can possibly access. I'd really also like to add a header to all the pages. Another menu, and maybe some other objects so I can integrate the top sites with my domain's blog more. Is there a way to display the top users on another page? Maybe a java snippet, wordpress plugin?
 

Basti

Administrator
Staff member
1) I need to change what the text link says though, it should read something like "Vote for *User Site* on Social Media Sun Best List" Instead of just my list title.
For now its properbly the best to change the core.
Ill make sure to add an admin setting for 0.7 Beta which lets you specify that message. After the upgrade to 0.7 you would need to enter it then in admin, as the core change will be lost then

Look up the following in sources/user_cp/link_code.php
Code:
if($CONF['text_link'] == 1) {
 
$TMPL['link_code_content'] .= <<<EndHTML
<br />
Preview: <a href="{$TMPL['list_url']}/{$TMPL['verbose_link']}">{$TMPL['list_name']}<img src="{$TMPL['list_url']}/button.php?u={$TMPL['site']}&buttontype=text" alt="{$TMPL['list_name']}" border="0" style="display: none;" width="1px" height="1px"/></a>
<br />
<textarea readonly="readonly" name="code" rows="6" style="width: 100%;" onclick="select_all();">&lt;a href="{$TMPL['list_url']}/{$TMPL['verbose_link']}">{$TMPL['list_name']}&lt;img src="{$TMPL['list_url']}/button.php?u={$TMPL['site']}" alt="{$TMPL['list_name']}" style="display: none;" width="1px" height="1px" />&lt;/a></textarea>
<hr />
 
EndHTML;
}
In there you see {$TMPL['list_name']} That is what you would need to change for now.
If you scroll down a little you will also find the img alt codes which use the same tag

Also, I would like to offer more options. I would like to offer the Google friendly list for the actual website, but the other type with the username directly in the link for users to copy from the control panel and share as a message on Twitter. "Vote for my site on the SMS Top 100 http://socialmediasun.com/best/index.php?a=in&u=etelligence " so basically add another option to Link Code. "Share on Twitter and Facebook" option.
This is best handled via a simple plugin, until we code something into the core or make a real complete plugin with admin integration.
Will Pm you something later today which you can use until then

2) I need to know the Div names to add CSS to the user.css file. I don't like using jquery, but I want to change the colors of the menu bar, in the table where there is navigation the color of ranking method, categories and newest members, the profile score bar, basically everything that is blue on all the pages a user can possibly access. I'd really also like to add a header to all the pages. Another menu, and maybe some other objects so I can integrate the top sites with my domain's blog more. Is there a way to display the top users on another page? Maybe a java snippet, wordpress plugin?
- For css changes simply simply look up the corresponding div in the html files. Or chrome has a nice right click -> search in element.
- The ucp score uses jquery, same as the join, edit form.
See here -> http://visiolist.com/community/threads/theme-developement-tips-tricks.174/
Roll a jquery theme which match your skin, or remove it. If remove, simply style it with css ( see above )
- Adding headers, other blocks simply alter your files, especially wrapper.html ( main layout )

For top users on another page there are multiple choices.
first off ssi_top.html, ssi_top_row.html for the style.

On same domain
- php include call to site.com/topsite/ssi.php

On the topsite itself, in the stats.html template for example
Code:
{include "{$list_url}/ssi.php"}
Then on an external page
- calling iframe to site.com/topsite/ssi.php
- making an curl request in your php file
Code:
  $ch = curl_init();
 
    $top_url= "http://site.com/ssi.php";
 
    curl_setopt($ch, CURLOPT_URL,$top_url);
    curl_setopt($ch, CURLOPT_HEADER, 0);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);
 
    $show_toplist = curl_exec($ch);
 
  curl_close($ch);
 
echo $show_toplist;
Whereever you place the echo $show_toplist in your external script, it will output top 5 members
More or less members = site.com/ssi.php?num=10
 

Adam

New Member
Alright, I got the core and edited the Text displayed on the Twitter Link Code. Everything is showing up good on the link code page, and I know how to edit what is there now. Awesome.

As for the CSS, the right click on Chrome along with firebug got me all the DIV names, I edited the User CSS in the control panel and the page looks uniform now.

I may try and edit the wrapper more, and I will have to get some more editing done on my blog's main page before I can try the curl request in a wordpress plugin, or ssi.php include. Thanks for all the help!
 
Top