No valid database connection Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' SQL=SELECT a.id, a.title, a.alias, a.introtext, a.catid, a.sectionid, a.publish_up AS date, a.created_by_alias, c.title AS category, u.id AS uid, u.name AS author, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug FROM jos_content AS a LEFT JOIN jos_categories AS c ON c.id = a.catid LEFT JOIN jos_sections AS s ON s.id = a.sectionid LEFT JOIN jos_users AS u ON u.id = a.created_by WHERE a.state = 1 AND a.access <= 0 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-20 06:06:48' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-20 06:06:48' ) AND ( ((LOWER(a.title) LIKE '%features%') OR (LOWER(a.introtext) LIKE '%features%') OR (LOWER(a.`fulltext`) LIKE '%features%') OR (LOWER(a.metakey) LIKE '%features%') OR (LOWER(a.metadesc) LIKE '%features%')) OR ((LOWER(a.title) LIKE '%writing%') OR (LOWER(a.introtext) LIKE '%writing%') OR (LOWER(a.`fulltext`) LIKE '%writing%') OR (LOWER(a.metakey) LIKE '%writing%') OR (LOWER(a.metadesc) LIKE '%writing%')) OR ((LOWER(a.title) LIKE '%chapter%') OR (LOWER(a.introtext) LIKE '%chapter%') OR (LOWER(a.`fulltext`) LIKE '%chapter%') OR (LOWER(a.metakey) LIKE '%chapter%') OR (LOWER(a.metadesc) LIKE '%chapter%')) OR ((LOWER(a.title) LIKE '%working%') OR (LOWER(a.introtext) LIKE '%working%') OR (LOWER(a.`fulltext`) LIKE '%working%') OR (LOWER(a.metakey) LIKE '%working%') OR (LOWER(a.metadesc) LIKE '%working%')) OR ((LOWER(a.title) LIKE '%other%') OR (LOWER(a.introtext) LIKE '%other%') OR (LOWER(a.`fulltext`) LIKE '%other%') OR (LOWER(a.metakey) LIKE '%other%') OR (LOWER(a.metadesc) LIKE '%other%')) OR ((LOWER(a.title) LIKE '%implement%') OR (LOWER(a.introtext) LIKE '%implement%') OR (LOWER(a.`fulltext`) LIKE '%implement%') OR (LOWER(a.metakey) LIKE '%implement%') OR (LOWER(a.metadesc) LIKE '%implement%')) OR ((LOWER(a.title) LIKE '%Windows%') OR (LOWER(a.introtext) LIKE '%Windows%') OR (LOWER(a.`fulltext`) LIKE '%Windows%') OR (LOWER(a.metakey) LIKE '%Windows%') OR (LOWER(a.metadesc) LIKE '%Windows%')) OR ((LOWER(a.title) LIKE '%reinforce%') OR (LOWER(a.introtext) LIKE '%reinforce%') OR (LOWER(a.`fulltext`) LIKE '%reinforce%') OR (LOWER(a.metakey) LIKE '%reinforce%') OR (LOWER(a.metadesc) LIKE '%reinforce%')) OR ((LOWER(a.title) LIKE '%knowledge%') OR (LOWER(a.introtext) LIKE '%knowledge%') OR (LOWER(a.`fulltext`) LIKE '%knowledge%') OR (LOWER(a.metakey) LIKE '%knowledge%') OR (LOWER(a.metadesc) LIKE '%knowledge%')) OR ((LOWER(a.title) LIKE '%scrolling%') OR (LOWER(a.introtext) LIKE '%scrolling%') OR (LOWER(a.`fulltext`) LIKE '%scrolling%') OR (LOWER(a.metakey) LIKE '%scrolling%') OR (LOWER(a.metadesc) LIKE '%scrolling%')) OR ((LOWER(a.title) LIKE '%creating%') OR (LOWER(a.introtext) LIKE '%creating%') OR (LOWER(a.`fulltext`) LIKE '%creating%') OR (LOWER(a.metakey) LIKE '%creating%') OR (LOWER(a.metadesc) LIKE '%creating%')) OR ((LOWER(a.title) LIKE '%joystick%') OR (LOWER(a.introtext) LIKE '%joystick%') OR (LOWER(a.`fulltext`) LIKE '%joystick%') OR (LOWER(a.metakey) LIKE '%joystick%') OR (LOWER(a.metadesc) LIKE '%joystick%')) OR ((LOWER(a.title) LIKE '%learning%') OR (LOWER(a.introtext) LIKE '%learning%') OR (LOWER(a.`fulltext`) LIKE '%learning%') OR (LOWER(a.metakey) LIKE '%learning%') OR (LOWER(a.metadesc) LIKE '%learning%')) OR ((LOWER(a.title) LIKE '%material%') OR (LOWER(a.introtext) LIKE '%material%') OR (LOWER(a.`fulltext`) LIKE '%material%') OR (LOWER(a.metakey) LIKE '%material%') OR (LOWER(a.metadesc) LIKE '%material%')) OR ((LOWER(a.title) LIKE '%programs%') OR (LOWER(a.introtext) LIKE '%programs%') OR (LOWER(a.`fulltext`) LIKE '%programs%') OR (LOWER(a.metakey) LIKE '%programs%') OR (LOWER(a.metadesc) LIKE '%programs%')) ) AND a.id NOT IN (3379) AND a.sectionid = 10 ORDER BY rand() LIMIT 0, 5
|
E-Book -
E-Book
|
|
Автор: DSAdmin
|
|
17.12.2009 05:50 |
|
Create your own high-caliber games with some of the same tools used by professional game developers! If you have a working knowledge of C or C++, then Game Programming All in One, 2nd Edition can get you started on your journey. It uses hands-on projects to explain each new subject and includes many sample programs to reinforce the material in each chapter. Begin by learning about cross-platform game programming, writing code that will run under Windows®, Linux®, Mac OS® X, and many other systems. Enhance your skills by working through the core features of the Allegro game library and writing code to load images, manipulate sprites, scroll the background, use double-buffering, read a joystick, detect collisions, and implement other core features of any game. You will gain experience by creating a complete game and adding features to it in each new chapter. You will also learn how to write a scrolling platform game and a vertical shooter.
Quote: http://rapidshare.com/files/255530447/3D_game_Program.rar
 |
