WP External SQL Tables Integration

Job: SEO Titles/Meta Tags


I need the Game Titles inside the HTML Title Tags + Meta Tags, when visiting a Game Info Page and the "View Trophy Guide" Page.

Keywords to add:

Game Page => GAME_NAME . "News"

Trophy Guide Page => GAME_NAME." Trophy Guide,". GAME_NAME ." Trophy Liste"

Page Titles

Game Page => GAME_NAME . "News und Infos - PS3inside.de"

Trophy Guide Page => GAME_NAME." Trophy Guide - PS3inside.de"

Job: Browse Trophy Guides

Example URL: [url removed, login to view]


Technically this is a 1:1 copy of the job you already did! The only thing that changes are of course the mod-rewrite URLs and the SQL Query, because its "...WHERE trophy_diffculty!=0" :)

Job: Show Trophy Guide

Example URL: [url removed, login to view]


When the previous Job is done, I need another Template, which displays the Trophy Guides, like in the example above. For this I can give you the SQL select that you need, or phpmyadmin access, just how you like it. The data comes out of two SQL tables (xcms_games and xcms_trophys) and you only need the game id via mod-rewrite to get it. Again, Pretty simple :)

Job: Show Release Calendar

Example URL: [url removed, login to view]


This also includes mod-rewrite URLs and is again pretty simple. Its just kinda selection out of "* FROM xcms_games db WHERE dateline > xyz AND < xyz"

Job: Add Search + Filter Options for "page-browse-games"

URL: [url removed, login to view]


You already converted the "Browse Page" to WP and its working, but its not a 1:1 copy :) I need the option to let users "Search" my database of games + need them to filter it. My Community will go on a rampage if I publish the new site but this is missing ;)

Its a simple system, filter options are PS3 spiele,PSN Spiele,PS Classics. These are inside the SQL database "FROM xcms_games WHERE type = 1/2/3

I already sent you the htaccess file, but can send it again if you need it.

Kemahiran: PHP, Wordpress

Lihat lagi: get external data, job title search, wp meta, SQL Query, sql integration, SQL Access, spiele, infos, id de, games community, game de, database html sql, Data tables, Data Integration, copy a wp, alle, access sql, rewrite sql, sql calendar view, phpmyadmin view, sql select select, psn trophy, copy tables, sql select, dateline

Tentang Majikan:
( 21 ulasan ) Erlensee, Germany

ID Projek: #1543491

Dianugerahkan kepada:


Hired by the Employer

€500 EUR dalam 14 hari
(504 Ulasan)