iSpeedDevil! Posted September 21, 2008 Share Posted September 21, 2008 Hello there, i was wondering why the profiles in my game is so fcuk'ed up, i have been in the database, and set the type to Varchar[255], Char[255], and Blob, nothing gives me more than 255 characters! what can i do, i want it to be like 1,000,000 characters on the profile Link to comment https://forums.phpfreaks.com/topic/125171-game-profile-error/ Share on other sites More sharing options...
Minase Posted September 21, 2008 Share Posted September 21, 2008 what ??? 1 million characters? what the heck this is not possible (i think) but what you mean what you want to store in that column? Link to comment https://forums.phpfreaks.com/topic/125171-game-profile-error/#findComment-646959 Share on other sites More sharing options...
JasonLewis Posted September 21, 2008 Share Posted September 21, 2008 Make it a "text" type in the database. Link to comment https://forums.phpfreaks.com/topic/125171-game-profile-error/#findComment-646963 Share on other sites More sharing options...
xoligy Posted September 21, 2008 Share Posted September 21, 2008 you really need to learn more about php and the dtabase before posting if i be honest i have a character count of 1543 and the db is set to 255 varchar! 1million is stupid btw! limit should be 500max Link to comment https://forums.phpfreaks.com/topic/125171-game-profile-error/#findComment-646964 Share on other sites More sharing options...
Minase Posted September 21, 2008 Share Posted September 21, 2008 that message was for me? xoligy??? i mean you can enter a number like 1.000.000 (just 7characters) but 1 milion characters will be damn big and yes i do really know mysql and php prety good //edit btw from what i know the maximum limit is 65.535 limit Link to comment https://forums.phpfreaks.com/topic/125171-game-profile-error/#findComment-646966 Share on other sites More sharing options...
xoligy Posted September 21, 2008 Share Posted September 21, 2008 not for you ispeed i just did a character count on something i wrote and it came to 1543 for a profile the max needed is just 500 this is what i wrote for a project i was working on: 1. Spy displays the "value" or "???" and "0" ONLY if there are no units - default spy (100, 100, 100 \2) now (100 100 60 \1) 2. Mail now has automatic line breaks 3. Percentage on gold and attacks (damage, amount stolen) - add to an admin page so its easier to change 4. Hits work above 2.1bil 5. Fixed recruit link (just need to insall the GDlib on computer) 6. Delete user works 7. Improved security md5 passwords, sanitized input (more to do on this) 8. Fixed spylogs, and attack page (almost one small issue) 9. Added a news page with news comments and the ability for the admin to edit/delete them (needs finishing) 10. Now have current users online just need to add guests 11. Date a person joined the game 12. Stop people with the same ip attacking each other but not spying Found out max spy and unit production is 1,010 need to add a limit to both really To do list: 1. Add if a message is read or not (inbox - bgcolor change) 2. Make a bbcode display page and look up adding it via Not Permitted (click smiles) 3. Research max button purchess (Not Permitted i think) 4. Add userlevels, supporter status, alliances, whos on line and winners page + banned and why 5. Merge some code together to save space and have less pages! 6. Spylevel required to view gold on battlefield 7. Fix armory prices 8. count up on time for - messages recieved, attacks, spying and last ip 9. 25% of army can be mercs so.. "but only up to a strength of 25% of your total force - so for every 3 normal soldiers you gain, you can hire one more mercenary" site i used: http://www.javascriptkit.com/script/script2/charcount.shtml Link to comment https://forums.phpfreaks.com/topic/125171-game-profile-error/#findComment-646967 Share on other sites More sharing options...
Minase Posted September 21, 2008 Share Posted September 21, 2008 sorry then Link to comment https://forums.phpfreaks.com/topic/125171-game-profile-error/#findComment-646968 Share on other sites More sharing options...
xoligy Posted September 21, 2008 Share Posted September 21, 2008 nps did you use to play a game called duels.com btw? know this is off topic but name rings a bell thats all Link to comment https://forums.phpfreaks.com/topic/125171-game-profile-error/#findComment-646971 Share on other sites More sharing options...
Minase Posted September 21, 2008 Share Posted September 21, 2008 sorry for offtopic no i did not play it Link to comment https://forums.phpfreaks.com/topic/125171-game-profile-error/#findComment-646972 Share on other sites More sharing options...
iSpeedDevil! Posted September 21, 2008 Author Share Posted September 21, 2008 uhh, 1,000,000 was a joke xD but about 65,000 as max chars is what i want i have that when i create a topic in the forum Link to comment https://forums.phpfreaks.com/topic/125171-game-profile-error/#findComment-646974 Share on other sites More sharing options...
JasonLewis Posted September 21, 2008 Share Posted September 21, 2008 As I said, use the field type as "text". Link to comment https://forums.phpfreaks.com/topic/125171-game-profile-error/#findComment-646975 Share on other sites More sharing options...
iSpeedDevil! Posted September 21, 2008 Author Share Posted September 21, 2008 As I said, use the field type as "text". Will it be able to show pictures on the profile too then? =) Link to comment https://forums.phpfreaks.com/topic/125171-game-profile-error/#findComment-646976 Share on other sites More sharing options...
JasonLewis Posted September 21, 2008 Share Posted September 21, 2008 Depends how you do it. If you are using a BBCode parser then yes, although I'm sure if you stored the HTML IMG tag it would work fine too. Link to comment https://forums.phpfreaks.com/topic/125171-game-profile-error/#findComment-646977 Share on other sites More sharing options...
xoligy Posted September 21, 2008 Share Posted September 21, 2008 uhh, 1,000,000 was a joke xD but about 65,000 as max chars is what i want i have that when i create a topic in the forum 65k is still too much if you ask me for a profile which is what your asking for... for a profile 500max is all thats needed in my presonal opinion. Link to comment https://forums.phpfreaks.com/topic/125171-game-profile-error/#findComment-646979 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.